This is the string what I see when I query the dialog table for vars:<br><br>accX_flags# |accX_db#( 2 1<br> 1000000001 1002<br> 12013386166<br> 919833171405 0 203.153.53.158 203.153.53.136 0 17 0 2 IP India - Mobile 919 9198 2 1 2 4 0.0150 0.0130 0 0.0000 0.0226 1.0000 6 1 6 1 1 2 2 2<br>
Aal Izz Well<br> Aal Izz Well 1 3 1.2.3.4|accX_leg# |accX_core# INVITE/ 100eb870-9e3599cb-13c4-50029-3b71-60de50d0-3b71\# 97.208.30.751120+1+31850054+b8c0a68/ 100f7670-9e3599cb-13c4-50029-3b71-3c625412-3b71 200 O á=ÃN |accX_created#Ã=ÃN |<br>
<br>--- Jayesh<br><br><div class="gmail_quote">On Wed, Dec 7, 2011 at 4:00 PM, Razvan Crainea <span dir="ltr"><<a href="mailto:razvancrainea@opensips.org">razvancrainea@opensips.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div bgcolor="#FFFFFF" text="#000000">
Hi, Jayesh!<br>
<br>
And what is the string in the database? You can see it in the
database after you kill opensips with the following command:<br>
<br>
<tt>select vars from dialog;</tt><div class="im"><br>
<br>
Regards,<br>
<pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
<br></div><div><div class="h5">
On 12/07/2011 12:24 PM, Jayesh Nambiar wrote:
<blockquote type="cite">Hi Razvan,<br>
Applied the patch and re-tested it. Here the logs that you are
interested in specifically:<br>
<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: Dumping var name: <accX_flags> value:
<#026><br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: compare char 22 - 0 - 11<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: compare char 0 - 1 - 12<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: compare char 0 - 2 - 13<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: compare char 0 - 3 - 14<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: Serialized string <accX_flags##026>
(16)<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 0) char: a hex: 61<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 1) char: c hex: 63<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 2) char: c hex: 63<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 3) char: X hex: 58<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 4) char: _ hex: 5F<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 5) char: f hex: 66<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 6) char: l hex: 6C<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 7) char: a hex: 61<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 8) char: g hex: 67<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 9) char: s hex: 73<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 10) char: # hex: 23<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 11) char: #026 hex: 16<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 12) char: #000 hex: 00<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 13) char: #000 hex: 00<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 14) char: #000 hex: 00<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 15) char: | hex: 7C<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: Dumping var name: <accX_db> value:
<(><br>
<br>
Apart from this, I have pasted everything in syslog after opensips
shutdown in the paste-bin here:<br>
<a href="http://pastebin.com/gx0ZxFLb" target="_blank">http://pastebin.com/gx0ZxFLb</a><br>
<br>
Let me know if there is anything more to test.<br>
<br>
--- Jayesh<br>
<br>
<div class="gmail_quote">On Wed, Dec 7, 2011 at 3:36 PM, Razvan
Crainea <span dir="ltr"><<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Sorr, I forgot to
attach it. Here it is.
<div><br>
<br>
Regards,<br>
<pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
<br>
</div>
<div>
<div> On 12/07/2011 11:59 AM, Jayesh Nambiar
wrote:
<blockquote type="cite">Hi Razvan,<br>
I don't see the patch attached !!<br>
<br>
--- Jayesh<br>
<br>
<div class="gmail_quote">On Wed, Dec 7, 2011 at 2:57
PM, Razvan Crainea <span dir="ltr"><<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hi, Jayesh
!<br>
<br>
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.<br>
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:
<div><br>
<br>
<tt>DBG:dialog:write_pair: Dumping var name:
<accX_flags> value: <#026></tt><br>
<br>
</div>
and
<div><br>
<br>
<tt>DBG:dialog:write_pair: Dumping var name:
<accX_db> value: <(></tt><br>
<br>
</div>
Thank you very much for testing! <br>
<div> Regards,<br>
<pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
<br>
</div>
<div>
<div> On 12/06/2011 07:57 PM, Jayesh Nambiar
wrote:
<blockquote type="cite">Hi Razvan,<br>
I just did a fresh download from <a href="http://opensips.org/pub/opensips/latest/src/" target="_blank">http://opensips.org/pub/opensips/latest/src/</a>.
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:<br>
<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[
<div>15700]: DBG:dialog:dialog_update_db:
inserting new dialog 0x7f3d323bd5f8<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Dumping var name:
<accX_flags> value: <#026><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Serialized string
<accX_flags##026> (16)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Dumping var name:
<accX_db> value: <(><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Serialized string
<accX_db#(> (263)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Dumping var name:
<accX_leg> value: <><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Serialized string
<accX_leg#> (14)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Dumping var name:
<accX_core> value: <#006><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: escaping char 53<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Serialized string
<accX_core##006> (165)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Dumping var name:
<accX_created> value:
<<95>+ÃN><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Serialized string
<accX_created#<95>+ÃN> (22)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_dialog_vars: var string
is <accX_flags##026>(480)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Dumping var name:
<carrierChannels> value:
<1002><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Serialized string
<carrierChannels#1002|> (21)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Dumping var name:
<carrierChannels> value:
<1003><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Serialized string
<carrierChannels#1003|> (21)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Dumping var name:
<carrierChannels> value:
<1007><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair: Serialized string
<carrierChannels#1007|> (21)<br>
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)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:db_mysql:has_stmt_ctx: ctx found for
dialog<br>
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<br>
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<br>
<br>
I hope this will help you figure out
something more relevant.
<div>
<div> <img src="http://images/cleardot.gif"></div>
</div>
<span><font color="#888888"><br>
<br>
--- Jayesh</font></span>
<div>
<div><br>
<br>
<div class="gmail_quote">On Tue, Dec
6, 2011 at 7:56 PM, Razvan Crainea
<span dir="ltr"><<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF"> Hi,
Jayesh!<br>
<br>
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.
<div><br>
<br>
Regards,<br>
<pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
</div></div></div>
</blockquote></div><br>