<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix"><tt>Hi John,<br>
<br>
I see you also open a ticket on this:<br>
<a class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/issues/398">https://github.com/OpenSIPS/opensips/issues/398</a><br>
<br>
I suppose your dialog table does have a reasonable size
constrain for the vars column, right ? <br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
On 22.12.2014 09:27, John Nash wrote:<br>
</div>
<blockquote
cite="mid:CAA4rGPzZyaackQyH8X2FyD+vyFZz-7q7gFF7rURK4mK4Vx9v2Q@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>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.<br>
<br>
</div>
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 ...<br>
<br>
"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)<br>
<br>
</div>
On the other hand when i see dialog using mi fifo command
I see full list of variables.<br>
<br>
accX_table:: acc<br>
accX_flags:: 5 DB_MISSED_FLAG DB_FLAG CDR_FLAG
FAIL_TRANS_FLAG<br>
accX_db::
\b\x00\x00\x00\x1d\<a class="moz-txt-link-abbreviated" href="mailto:x00sip:test@192.168.7.5:9090$\">x00sip:test@192.168.7.5:9090$\</a><a
moz-do-not-send="true"
href="http://x00sip:919811618189@192.168.7.5:9090#%5Cx00sip:11025919811618189@192.168.7.8%5Cx0e%5Cx00192.168.3.1">x00sip:919811618189@192.168.7.5:9090#\x00sip:11025919811618189@192.168.7.8\x0e\x00192.168.3.1</a>?\x00\x00\n\x001419221825<br>
accX_leg:: \x00\x00\x00\x00<br>
accX_core:: \x06\x00INVITE
\x0052a5e031f1fa4a50883cf14fcfb0dfb1"\x007C34DE52-54979B3E000CEDFB-4BCFC700
\x00e26faa1c7c654b1dbe6b1d86a12b2e61\x03\x00200\x02\x00OK\b\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>
</div>
Somehow values after accX_db are not being stored into the
DB.<br>
<br>
</div>
Any ideas?<br>
<br>
</div>
John<br>
<div>
<div><br>
<br>
<br>
<div><br>
<br>
<br>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>