<div dir="ltr"><div><div><div><div>I think the issue is somewhere in storing these values into the postgres DB (Not checked with mysql) because ....<br><br></div>1- I connected one call and let dialog created and then restarted opensips and again checked dialog variables (using opensipsctl) and found dialog variables gone (I could see the dialog other core values though)<br><br></div>2- When dialog is created I ran following queries<br>select position('accX_db'::bytea in vars) from dialog (To check position of "accX_db after that non-printable binary data is there")<br>select length(vars) from dialog (Checked total binary length)<br><br></div>and found there was only one byte after "accX_db" so I think it is not storing complete value.<br><br></div>BTW my version is Server:: OpenSIPS (1.12.0dev-notls (x86_64/linux))<br><br><br><div><br><div><br><br><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 23, 2014 at 5:19 PM, Răzvan Crainea <span dir="ltr"><<a href="mailto:razvan@opensips.org" target="_blank">razvan@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">
<div><tt>Hi, Josh!<br>
<br>
Most likely it is a printing problem. The dialog variables are
stored in the DB as binary/non-printable data. That's why you
can't see them properly when doing a select.<br>
<br>
Best regards,<br>
</tt>
<pre cols="72">Răzvan Crainea
OpenSIPS Solutions
<a href="http://www.opensips-solutions.com" target="_blank">www.opensips-solutions.com</a></pre><div><div class="h5">
On 12/23/2014 01:08 PM, John Nash wrote:<br>
</div></div></div>
<blockquote type="cite"><div><div class="h5">
<div dir="ltr">
<pre style="color:rgb(0,0,0);font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;word-spacing:0px">I am using Opensips with dialog module and using DB as Postgresql. I am
using modparam("dialog", "db_mode", 1). At the time of dialog creation I am
also setting values to some dialog variables which I can see with mi fifo
commands.
My issue is when i run a select query and try to see "vars" column contents
(I set vars column data type as text for simplicity), I do not see all
information stored. It seems to be truncated. I see like below ...
"accX_table#acc|accX_flags#5 DB_MISSED_FLAG DB_FLAG CDR_FLAG
FAIL_TRANS_FLAG|accX_db# " (There is some special character at the end)
On the other hand when i see dialog using mi fifo command I see full list
of variables.
accX_table:: acc
accX_flags:: 5 DB_MISSED_FLAG DB_FLAG CDR_FLAG FAIL_TRANS_FLAG
accX_db:: \b\x00\x00\x00\x1d\x00sip:<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">test at 192.168.7.5</a>:9090$\
x00sip:<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">1111111111 at 192.168.7.5</a>:9090#\x00sip:<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">11025111111111 at 192.168.7.8</a>\x0e\x00192.168.3.1
?\x00\x00\n\x001419221825
accX_leg:: \x00\x00\x00\x00
accX_core:: \x06\x00INVITE
\x0052a5e031f1fa4a50883cf14fcfb0dfb1"\x007C34DE52-54979B3E000CEDFB-4BCFC700
\x00e26faa1c7c654b1dbe6b1d86a12b2e61\x03\x00200\x02\x00OK\b\x00E\x9b\x97T\x00\x00\x00\x00
accX_created:: >\x9b\x97T\x00\x00\x00\x00
caller_IP:: 192.168.3.1
ring_time:: 1419221825
Somehow values after accX_db are not being stored into the DB.
Any ideas?
John</pre>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
Devel mailing list
<a href="mailto:Devel@lists.opensips.org" target="_blank">Devel@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/devel</a>
</pre>
</blockquote>
<br>
</div>
<br>_______________________________________________<br>
Devel mailing list<br>
<a href="mailto:Devel@lists.opensips.org">Devel@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/devel</a><br>
<br></blockquote></div><br></div>