Hello,
the solution with deleting my.cnf is quite strange, I would say. Perhaps
it has to do with type auto-conversion in mysql, my.cnf was probably
setting a strict rule on that.
The db_extra columns should be defined as varchar - kamailio is writing
the values as string.
Cheers,
Daniel
On 17/02/15 15:13, Uri Shacked wrote:
Hi again,
I remembered :-) but do not really understand why it works...
Deleting the my.cnf from /etc (or from /usr) did the job.
The acc db_extra works.
On Tue, Feb 17, 2015 at 2:09 PM, Uri Shacked <ushacked(a)gmail.com
<mailto:ushacked@gmail.com>> wrote:
Hi,
It is my second time upgrading kamailio to 4.2.X.
Everything is working except the acc db_extra inserts.
I keep on getting that error:
ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver
error on query: Incorrect integer value: '' for column XXXXXXX
I must confess, I managed to solve the problem once. But I do not
remember how :-(.
The XXXXXX column is set as an integer with NULL enabled and no
default value (which works on the kamailio server where i fixed it...)
Any ideas of where it comes from?
BR,
Uri
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda -
http://www.linkedin.com/in/miconda
Kamailio World Conference, May 27-29, 2015
Berlin, Germany -
http://www.kamailioworld.com