<html>
<head>
<meta content="text/html; charset=ISO-8859-2"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi, Ryan!<br>
<br>
Unfortunately it won't work. The problem is that the mysql library
detects both VARCHAR and VARBINARY as string types. Only BLOB and
TEXT are mapped as binary objects. You can find more information
here[1].<br>
As far as I know, only the CDR accounting can generate binary data
in dialog variables, so if you don't use this feature you can leave
it as it is for now. But if you find any problems related to dialog
persistence over restart I strongly advise you to change your
columns type to the default ones.<br>
<br>
[1]
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-2">
<a
href="http://dev.mysql.com/doc/refman/5.0/en/c-api-data-structures.html">http://dev.mysql.com/doc/refman/5.0/en/c-api-data-structures.html</a><br>
<br>
Regards,<br>
<pre class="moz-signature" cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
<br>
On 12/07/2011 08:40 PM, Ryan Bullock wrote:
<blockquote
cite="mid:CAAcj4gUTtyiCT0VzLkpfFg+roTgKE-rzUT2yK8hhzQbQCcLDSA@mail.gmail.com"
type="cite">
<pre wrap="">Could a VARBINARY be used here instead?
We actually use a memory table for the dialog table to reduce load on
our disk and it does not support BLOB or TEXT, so instead we changed
it to a large VARCHAR. The mysql docs suggest you can treat a TEXT the
same as a VARCHAR, but obviously there are differences.
Regards,
Ryan
On Wed, Dec 7, 2011 at 9:51 AM, Jayesh Nambiar <a class="moz-txt-link-rfc2396E" href="mailto:jayesh.voip@gmail.com"><jayesh.voip@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi Razvan,
This actually solved the problem. Thank you very much. It was defined as
VARCHAR instead of TEXT.
Thank you very much for all the efforts. Really appreciate it. Need to get
hold of my DB guy for the stupid mistake !!
--- Jayesh
On Wed, Dec 7, 2011 at 8:13 PM, Razvan Crainea <a class="moz-txt-link-rfc2396E" href="mailto:razvancrainea@opensips.org"><razvancrainea@opensips.org></a>
wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
Hi, Jayesh!
Can you check in your mysql database if the vars column from the dialog
table is declared as TEXT or BLOB and not CHAR? If not, please change your
column into BLOB:
ALTER TABLE dialog CHANGE vars vars BLOB;
Regards,
--
Răzvan Crainea
OpenSIPS Developer
On 12/07/2011 02:27 PM, Jayesh Nambiar wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
Hi Razwan,
This is the pastebin of logs after shutdown:
<a class="moz-txt-link-freetext" href="http://pastebin.com/tvmrSqwB">http://pastebin.com/tvmrSqwB</a>
This is the pastebin of logs after start which is huge:
<a class="moz-txt-link-freetext" href="http://pastebin.com/C6K4Jt5y">http://pastebin.com/C6K4Jt5y</a>
--- Jayesh
</pre>
</blockquote>
</blockquote>
<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>
<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>
</body>
</html>