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 <razvancrai...@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.v...@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 <razvancrai...@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@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
