<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix"><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 class="moz-signature" cols="72">Răzvan Crainea
OpenSIPS Solutions
<a class="moz-txt-link-abbreviated" href="http://www.opensips-solutions.com">www.opensips-solutions.com</a></pre>
On 12/23/2014 01:08 PM, John Nash wrote:<br>
</div>
<blockquote
cite="mid:CAA4rGPzrfHOU1KaHdQo-TZmw5u0DB5BG1ivb0QSR4ET3SqTj4Q@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">test at 192.168.7.5</a>:9090$\
x00sip:<a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">1111111111 at 192.168.7.5</a>:9090#\x00sip:<a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">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 class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Devel@lists.opensips.org">Devel@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel">http://lists.opensips.org/cgi-bin/mailman/listinfo/devel</a>
</pre>
</blockquote>
<br>
</body>
</html>