[OpenSIPS-Users] acc not writing INVITE to db

Sat Feb 26 19:51:29 UTC 2022

I have provided full dbg 4 days ago but it is still waiting for 
moderator approval.

will this help? or I can provide an external link for full dbg output

Feb 26 19:42:55 chi /usr/sbin/opensips[7050]: DBG:dialog:dlg_onroute: 
route param is '174.f272907' (len=11)
Feb 26 19:42:55 chi /usr/sbin/opensips[7050]: DBG:dialog:lookup_dlg: no 
dialog id=118040367 found on entry 1137
Feb 26 19:42:55 chi /usr/sbin/opensips[7050]: DBG:dialog:dlg_onroute: 
unable to find dialog for BYE with route param '174.f272907'
Feb 26 19:42:55 chi /usr/sbin/opensips[7050]: DBG:core:parse_headers: 
flags=58
Feb 26 19:42:55 chi /usr/sbin/opensips[7050]: DBG:dialog:get_dlg: input 
ci=<56eebba946add6203bcb00af09cae6dc at 10.0.0.111:5062>(48), 
tt=<as05e5db16>(10), ft=<as258b7bab>(10)
Feb 26 19:42:55 chi /usr/sbin/opensips[7050]: DBG:dialog:get_dlg: no 
dialog callid='56eebba946add6203bcb00af09cae6dc at 10.0.0.111:5062' found
Feb 26 19:42:55 chi /usr/sbin/opensips[7050]: DBG:dialog:dlg_onroute: 
Callid '56eebba946add6203bcb00af09cae6dc at 10.0.0.111:5062' not found
Feb 26 19:42:55 chi /usr/sbin/opensips[7050]: DBG:rr:run_rr_callbacks: 
callback id 2 entered with <lr;ftag=as258b7bab;did=174.f272907>
Feb 26 19:42:55 chi /usr/sbin/opensips[7050]: DBG:uac:restore_uri: 
getting 'vsf' Route param
Feb 26 19:42:55 chi /usr/sbin/opensips[7050]: DBG:uac:restore_uri: route 
param 'vsf' not found
Feb 26 19:42:55 chi /usr/sbin/opensips[7050]: DBG:uac:restore_uri: 
getting 'vst' Route param
Feb 26 19:42:55 chi /usr/sbin/opensips[7050]: DBG:uac:restore_uri: route 
param 'vst' not found

and DB entry for the same call: select * from dialog;

| 4883495855919 | 56eebba946add6203bcb00af09cae6dc at 10.0.0.111:5062 | 
sip:13125551184 at 10.0.0.111:5062 | as258b7bab | 
sip:13125555555 at chi.domain.com | as05e5db16 | NULL             | 
NULL           | 0           | 102         |                0 
|                0 | NULL             | NULL             | 
sip:13125551184 at 10.0.0.111:5062 | sip:13125555555 at 10.0.1.111:5062 | 
udp:99.99.99.99:5060 | udp:99.99.99.99:5060 |     4 | 1645904552 | 
1646646240 | NULL | NULL     |            0 |            0 | 24600 | 
NULL         | NULL          | NULL         |

as one can see the callid 
56eebba946add6203bcb00af09cae6dc at 10.0.0.111:5062 exists in dialog table

On 2/22/2022 2:31 AM, Răzvan Crainea wrote:
> Hi, Marcin!
>
> Can you provide the full debug logs of a call without CDR?
>
> Best regards,
>
> Răzvan Crainea
> OpenSIPS Core Developer
> http://www.opensips-solutions.com
>
> On 2/20/22 22:58, Marcin Groszek wrote:
>> An update: Perhaps this will help:
>>
>> debug of  acc successfully written to db:
>>
>>   DBG:dialog:fetch_dlg_value: looking for <accX_core>
>>   DBG:dialog:fetch_dlg_value: var found-> <#006>!
>>   DBG:db_mysql:db_mysql_do_prepared_query: new query=|insert into acc 
>> (method,from_tag,to_tag,callid,sip_code,sip_reason,time,src,dst,src_ip,dst_ip,caller_cus_id,callee_cus_id,billsec,caller_bill,callee_bill,rate,fee,setuptime,created,duration,ms_duration 
>> ) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)|
>> DBG:db_mysql:re_init_statement:  query  is <insert into acc 
>> (method,from_tag,to_tag,callid,sip_code,sip_reason,time,src,dst,src_ip,dst_ip,caller_cus_id,callee_cus_id,billsec,caller_bill,callee_bill,rate,fee,setuptime,created,duration,ms_duration 
>> ) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)>, ptr=(nil)
>>
>> and dbug of no cdr written to db:
>>
>> DBG:dialog:lookup_dlg: no dialog id=1391388357 found on entry 737
>>   DBG:dialog:dlg_onroute: unable to find dialog for BYE with route 
>> param '1e2.5c6eee25'
>>   DBG:dialog:get_dlg: input 
>> ci=<3ded0fe13eeb83243d0285fe620772ad at 10.0.0.111:5062>(48), 
>> tt=<as5c819c44>(10), ft=<as1a9a4ffb>(10)
>>   DBG:dialog:get_dlg: no dialog 
>> callid='3ded0fe13eeb83243d0285fe620772ad at 10.0.0.111:5062' found
>>   DBG:dialog:dlg_onroute: Callid 
>> '3ded0fe13eeb83243d0285fe620772ad at 10.0.0.111:5062' not found
>>   DBG:dialog:destroy_dlg: destroying dialog 0x7effaf2068a0
>>   DBG:dialog:destroy_dlg: dlg expired or not in list - dlg 
>> 0x7effaf2068a0 [737:1391388357] with clid 
>> '3ded0fe13eeb83243d0285fe620772ad at 10.0.0.111:5062' and tags 
>> 'as1a9a4ffb' 'as5c819c44'
>>
>> 10.0.0.111 is a originating host, and it looks as the dialog var is 
>> missing.
>>
>> I have also compared queries: insert into dialog and update dialog 
>> and they are identical other then a  dlg_id and callid.
>>
>> Debug for the calls states: DBG:dialog:get_dlg: no dialog callid= and 
>> I was able to find it same callid in  insert into dialog query and in 
>> database table as well.
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-- 
Best Regards:
Marcin Groszek
Business Voip Resource.
http://www.voipplus.net