<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
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.<br>
<br>
The db_extra columns should be defined as varchar - kamailio is
writing the values as string.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 17/02/15 15:13, Uri Shacked wrote:<br>
</div>
<blockquote
cite="mid:CAMMbDhQe-8exNcovyn_eOEz3656zzgt+-yVN5-7dJQOQ3UKF2A@mail.gmail.com"
type="cite">
<div dir="ltr">Hi again,
<div><br>
</div>
<div>I remembered :-) but do not really understand why it
works...</div>
<div>Deleting the my.cnf from /etc (or from /usr) did the job.</div>
<div>The acc db_extra works.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Tue, Feb 17, 2015 at 2:09 PM, Uri
Shacked <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:ushacked@gmail.com" target="_blank">ushacked@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hi,
<div><br>
</div>
<div>It is my second time upgrading kamailio to 4.2.X.</div>
<div>Everything is working except the acc db_extra
inserts.</div>
<div><br>
</div>
<div>I keep on getting that error:</div>
<div><br>
</div>
<div> ERROR: db_mysql [km_dbase.c:123]:
db_mysql_submit_query(): driver error on query:
Incorrect integer value: '' for column XXXXXXX<br>
</div>
<div><br>
</div>
<div>I must confess, I managed to solve the problem once.
But I do not remember how :-(.<br>
</div>
<div>
<div><br>
</div>
<div>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...)</div>
</div>
<div><br>
</div>
<div>Any ideas of where it comes from?</div>
<div><br>
</div>
<div>BR,</div>
<div>Uri</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - <a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>