[OpenSIPS-Users] cdr accounting on opensips restart

[Ryan Bullock]

Awesome information. Dialogs seem to persist over a restart, however I
am not sure if they are accounting. I will do a switch back to the
defaults, better safe than sorry.

Thanks,

Ryan

2011/12/8 Razvan Crainea <razvancrainea at opensips.org>:
> 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
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>