[OpenSIPS-Users] cdr accounting on opensips restart

Razvan Crainea razvancrainea at opensips.org
Wed Dec 7 11:30:54 CET 2011


Hi, Jayesh!

And what is the string in the database? You can see it in the database 
after you kill opensips with the following command:

select vars from dialog;

Regards,

--
Răzvan Crainea
OpenSIPS Developer


On 12/07/2011 12:24 PM, Jayesh Nambiar wrote:
> Hi Razvan,
> Applied the patch and re-tested it. Here the logs that you are 
> interested in specifically:
>
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: Dumping var name: <accX_flags> value: <#026>
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: compare char 22 - 0 - 11
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: compare char 0 - 1 - 12
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: compare char 0 - 2 - 13
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: compare char 0 - 3 - 14
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: Serialized string <accX_flags##026> (16)
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 0) char: a hex: 61
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 1) char: c hex: 63
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 2) char: c hex: 63
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 3) char: X hex: 58
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 4) char: _ hex: 5F
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 5) char: f hex: 66
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 6) char: l hex: 6C
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 7) char: a hex: 61
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 8) char: g hex: 67
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 9) char: s hex: 73
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 10) char: # hex: 23
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 11) char: #026 hex: 16
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 12) char: #000 hex: 00
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 13) char: #000 hex: 00
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 14) char: #000 hex: 00
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: 15) char: | hex: 7C
> Dec  7 15:50:33 dev /usr/local/sbin/opensips[8011]: 
> DBG:dialog:write_pair: Dumping var name: <accX_db> value: <(>
>
> Apart from this, I have pasted everything in syslog after opensips 
> shutdown in the paste-bin here:
> http://pastebin.com/gx0ZxFLb
>
> Let me know if there is anything more to test.
>
> --- Jayesh
>
> On Wed, Dec 7, 2011 at 3:36 PM, Razvan Crainea 
> <razvancrainea at opensips.org <mailto:razvancrainea at opensips.org>> wrote:
>
>     Sorr, I forgot to attach it. Here it is.
>
>
>     Regards,
>
>     --
>     Răzvan Crainea
>     OpenSIPS Developer
>
>
>     On 12/07/2011 11:59 AM, Jayesh Nambiar wrote:
>>     Hi Razvan,
>>     I don't see the patch attached !!
>>
>>     --- Jayesh
>>
>>     On Wed, Dec 7, 2011 at 2:57 PM, Razvan Crainea
>>     <razvancrainea at opensips.org <mailto:razvancrainea at opensips.org>>
>>     wrote:
>>
>>         Hi, Jayesh !
>>
>>         The root of the problem is the accX_flags dialog variable
>>         isn't properly serialized. What I'm trying to find out is why
>>         this happens, that's why I will need some extra debug as I
>>         can't figure out the problem there. So please apply this last
>>         patch and try again. It should be applied after the previous
>>         patch I've sent you, so you won't need another fresh checkout.
>>         This time there will be a lot of dumped info in the log, so I
>>         would really appreciate if you could send them over pastebin.
>>         The only part that I will be interested in is between these
>>         lines:
>>
>>
>>         DBG:dialog:write_pair: Dumping var name: <accX_flags> value:
>>         <#026>
>>
>>         and
>>
>>
>>         DBG:dialog:write_pair: Dumping var name: <accX_db> value: <(>
>>
>>         Thank you very much for testing!
>>         Regards,
>>
>>         --
>>         Răzvan Crainea
>>         OpenSIPS Developer
>>
>>
>>         On 12/06/2011 07:57 PM, Jayesh Nambiar wrote:
>>>         Hi Razvan,
>>>         I just did a fresh download from
>>>         http://opensips.org/pub/opensips/latest/src/. I did apply
>>>         the patch successfully and I still have the problem of CDR
>>>         not being recorded after restart. Here is the syslog pasted
>>>         after opensips was being shut down:
>>>
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[
>>>         15700]: DBG:dialog:dialog_update_db: inserting new dialog
>>>         0x7f3d323bd5f8
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Dumping var name: <accX_flags> value:
>>>         <#026>
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Serialized string <accX_flags##026> (16)
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Dumping var name: <accX_db> value: <(>
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Serialized string <accX_db#(> (263)
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Dumping var name: <accX_leg> value: <>
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Serialized string <accX_leg#> (14)
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Dumping var name: <accX_core> value:
>>>         <#006>
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: escaping char 53
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Serialized string <accX_core##006> (165)
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Dumping var name: <accX_created>
>>>         value: <<95>+ÃN>
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Serialized string
>>>         <accX_created#<95>+ÃN> (22)
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_dialog_vars: var string is
>>>         <accX_flags##026>(480)
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Dumping var name: <carrierChannels>
>>>         value: <1002>
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Serialized string
>>>         <carrierChannels#1002|> (21)
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Dumping var name: <carrierChannels>
>>>         value: <1003>
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Serialized string
>>>         <carrierChannels#1003|> (21)
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Dumping var name: <carrierChannels>
>>>         value: <1007>
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_pair: Serialized string
>>>         <carrierChannels#1007|> (21)
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:dialog:write_dialog_profiles: profile string is
>>>         <carrierChannels#1002|carrierChannels#1003|carrierChannels#1007|>(63)
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:db_mysql:has_stmt_ctx: ctx found for dialog
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:db_mysql:db_mysql_do_prepared_query: conn=0x810858
>>>         (tail=8454488) MC=0x8101b8
>>>         Dec  6 20:20:13 dev /usr/local/sbin/opensips[15700]:
>>>         DBG:db_mysql:db_mysql_do_prepared_query: set values for the
>>>         statement run
>>>
>>>         I hope this will help you figure out something more relevant.
>>>
>>>
>>>         --- Jayesh
>>>
>>>
>>>         On Tue, Dec 6, 2011 at 7:56 PM, Razvan Crainea
>>>         <razvancrainea at opensips.org
>>>         <mailto:razvancrainea at opensips.org>> wrote:
>>>
>>>             Hi, Jayesh!
>>>
>>>             Can you post your dlg_db_handler.c file on pastebin? I
>>>             think you are using an old version of the dialog module,
>>>             and that's why you have this problem.
>>>
>>>
>>>             Regards,
>>>
>>>             --
>>>             Răzvan Crainea
>>>             OpenSIPS Developer
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20111207/b56e36b2/attachment-0001.htm>


More information about the Users mailing list