<div dir="ltr"><div><div>Hello Razvan,<br><br></div>I opened ticket for the issue <a href="https://github.com/OpenSIPS/opensips/issues/398">https://github.com/OpenSIPS/opensips/issues/398</a> . I will update in case I am able to pin point the issue in code.<br><br></div>John<br><div><div><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Dec 24, 2014 at 1:56 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">Hi, John!<br>
<br>
Please open an issue on the ticketing system[1]. I will run some tests and let you know if I can replicate this.<br>
<br>
[1] <a href="https://github.com/OpenSIPS/opensips/issues" target="_blank">https://github.com/OpenSIPS/<u></u>opensips/issues</a><br>
<br>
Best regards,<br>
<br>
Răzvan Crainea<br>
OpenSIPS Core Developer<br>
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<u></u>com</a><span class=""><br>
<br>
On 12/23/2014 06:04 PM, John Nash wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
I would have looked into code by now but its taking me a while to go<br>
through it as I recently started studying it. I thought of posting in<br>
case its some know issue.<br>
<br>
On Tue, Dec 23, 2014 at 5:27 PM, John Nash <<a href="mailto:john.nash778@gmail.com" target="_blank">john.nash778@gmail.com</a><br></span><span class="">
<mailto:<a href="mailto:john.nash778@gmail.com" target="_blank">john.nash778@gmail.com</a><u></u>>> wrote:<br>
<br>
I think the issue is somewhere in storing these values into the<br>
postgres DB (Not checked with mysql) because ....<br>
<br>
1- I connected one call and let dialog created and then restarted<br>
opensips and again checked dialog variables (using opensipsctl) and<br>
found dialog variables gone (I could see the dialog other core<br>
values though)<br>
<br>
2- When dialog is created I ran following queries<br>
select position('accX_db'::bytea in vars) from dialog (To check<br>
position of "accX_db after that non-printable binary data is there")<br>
select length(vars) from dialog (Checked total binary length)<br>
<br>
and found there was only one byte after "accX_db" so I think it is<br>
not storing complete value.<br>
<br>
BTW my version is Server:: OpenSIPS (1.12.0dev-notls (x86_64/linux))<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
On Tue, Dec 23, 2014 at 5:19 PM, Răzvan Crainea <<a href="mailto:razvan@opensips.org" target="_blank">razvan@opensips.org</a><br></span><span class="">
<mailto:<a href="mailto:razvan@opensips.org" target="_blank">razvan@opensips.org</a>>> wrote:<br>
<br>
Hi, Josh!<br>
<br>
Most likely it is a printing problem. The dialog variables are<br>
stored in the DB as binary/non-printable data. That's why you<br>
can't see them properly when doing a select.<br>
<br>
Best regards,<br>
<br>
Răzvan Crainea<br>
OpenSIPS Solutions<br></span>
<a href="http://www.opensips-solutions.com" target="_blank">www.opensips-solutions.com</a> <<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-<u></u>solutions.com</a>><span class=""><br>
<br>
On 12/23/2014 01:08 PM, John Nash wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
I am using Opensips with dialog module and using DB as Postgresql. I am<br>
using modparam("dialog", "db_mode", 1). At the time of dialog creation I am<br>
also setting values to some dialog variables which I can see with mi fifo<br>
commands.<br>
<br>
My issue is when i run a select query and try to see "vars" column contents<br>
(I set vars column data type as text for simplicity), I do not see all<br>
information stored. It seems to be truncated. I see like below ...<br>
<br>
"accX_table#acc|accX_flags#5 DB_MISSED_FLAG DB_FLAG CDR_FLAG<br>
FAIL_TRANS_FLAG|accX_db# " (There is some special character at the end)<br>
<br>
On the other hand when i see dialog using mi fifo command I see full list<br>
of variables.<br>
<br>
accX_table:: acc<br>
accX_flags:: 5 DB_MISSED_FLAG DB_FLAG CDR_FLAG FAIL_TRANS_FLAG<br></span>
accX_db:: \b\x00\x00\x00\x1d\x00sip:test at 192.168.7.5 <<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/<u></u>cgi-bin/mailman/listinfo/users</a><u></u>>:9090$\<br>
x00sip:1111111111 at 192.168.7.5 <<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/<u></u>cgi-bin/mailman/listinfo/users</a><u></u>>:9090#\x00sip:11025111111111 at 192.168.7.8 <<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/<u></u>cgi-bin/mailman/listinfo/users</a><u></u>>\x0e\x00192.168.3.1<span class=""><br>
?\x00\x00\n\x001419221825<br>
accX_leg:: \x00\x00\x00\x00<br>
accX_core:: \x06\x00INVITE<br>
\<u></u>x0052a5e031f1fa4a50883cf14fcfb<u></u>0dfb1"\x007C34DE52-<u></u>54979B3E000CEDFB-4BCFC700<br>
\<u></u>x00e26faa1c7c654b1dbe6b1d86a12<u></u>b2e61\x03\x00200\x02\x00OK\b\<u></u>x00E\x9b\x97T\x00\x00\x00\x00<br>
accX_created:: >\x9b\x97T\x00\x00\x00\x00<br>
caller_IP:: 192.168.3.1<br>
ring_time:: 1419221825<br>
<br>
Somehow values after accX_db are not being stored into the DB.<br>
<br>
Any ideas?<br>
<br>
John<br>
<br>
<br>
______________________________<u></u>_________________<br>
Devel mailing list<br></span>
<a href="mailto:Devel@lists.opensips.org" target="_blank">Devel@lists.opensips.org</a> <mailto:<a href="mailto:Devel@lists.opensips.org" target="_blank">Devel@lists.opensips.<u></u>org</a>><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel" target="_blank">http://lists.opensips.org/cgi-<u></u>bin/mailman/listinfo/devel</a><br>
</blockquote>
<br>
<br>
______________________________<u></u>_________________<br>
Devel mailing list<br>
<a href="mailto:Devel@lists.opensips.org" target="_blank">Devel@lists.opensips.org</a> <mailto:<a href="mailto:Devel@lists.opensips.org" target="_blank">Devel@lists.opensips.<u></u>org</a>><span class=""><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel" target="_blank">http://lists.opensips.org/cgi-<u></u>bin/mailman/listinfo/devel</a><br>
<br>
<br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
Devel mailing list<br>
<a href="mailto:Devel@lists.opensips.org" target="_blank">Devel@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel" target="_blank">http://lists.opensips.org/cgi-<u></u>bin/mailman/listinfo/devel</a><br>
<br>
</span></blockquote><div class="HOEnZb"><div class="h5">
<br>
______________________________<u></u>_________________<br>
Devel mailing list<br>
<a href="mailto:Devel@lists.opensips.org" target="_blank">Devel@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel" target="_blank">http://lists.opensips.org/cgi-<u></u>bin/mailman/listinfo/devel</a><br>
</div></div></blockquote></div><br></div>