[OpenSIPS-Users] cdr accounting on opensips restart

[Razvan Crainea]

Hi, Ryan!

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].
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.

[1] http://dev.mysql.com/doc/refman/5.0/en/c-api-data-structures.html

Regards,

--
Răzvan Crainea
OpenSIPS Developer


On 12/07/2011 08:40 PM, Ryan Bullock wrote:
> 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<jayesh.voip at gmail.com>  wrote:
>> 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<razvancrainea at opensips.org>
>> wrote:
>>> 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:
>>>> Hi Razwan,
>>>>
>>>> This is the pastebin of logs after shutdown:
>>>> http://pastebin.com/tvmrSqwB
>>>>
>>>> This is the pastebin of logs after start which is huge:
>>>> http://pastebin.com/C6K4Jt5y
>>>>
>>>> --- Jayesh
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20111208/e0657f95/attachment.htm>