[OpenSIPS-Users] acc not writing INVITE to db

[Marcin Groszek]

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.