<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
can you give the output in mysql client for:<br>
<br>
describe location<br>
<br>
What version of mysql is used?<br>
<br>
Can you get the logs with debug=3 in kamailio.cfg?<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 25/02/14 12:01, Jöran Vinzens wrote:<br>
</div>
<blockquote
cite="mid:CAC3=B=uzMNoYzkEb+gaTFdwY+j3awWCBZtn_DYtK+ErvKLUsxw@mail.gmail.com"
type="cite">
<div dir="ltr">Hi All,
<div><br>
</div>
<div>we are upgrading from <span class=""
style="background-color:yellow">kamailio</span> 3.1 to 4.1
and we got stuck at a Problem with <span class=""
style="background-color:yellow">usrloc</span> module.</div>
<div><br>
</div>
<div>While starting up <span class=""
style="background-color:yellow">kamailio</span> reads
location from DB and try to parse expires date from DB.</div>
<div><br>
</div>
<div>this is the Problem:</div>
<div><br>
</div>
<div>
<div>Feb 25 11:42:11 <span class=""
style="background-color:yellow">hagi</span> /<span
class="" style="background-color:yellow">usr</span>/<span
class="" style="background-color:yellow">sbin</span>/<span
class="" style="background-color:yellow">kamailio</span>[19580]:
ERROR: <core> [db_<span class=""
style="background-color:yellow">ut</span>.c:90]:
db_str2int(): Unexpected characters: [-02-25 11:27:08]</div>
<div>Feb 25 11:42:11 <span class=""
style="background-color:yellow">hagi</span> /<span
class="" style="background-color:yellow">usr</span>/<span
class="" style="background-color:yellow">sbin</span>/<span
class="" style="background-color:yellow">kamailio</span>[19580]:
ERROR: <core> [db_val.c:75]: db_str2val(): error while
converting integer value from string</div>
<div>Feb 25 11:42:11 <span class=""
style="background-color:yellow">hagi</span> /<span
class="" style="background-color:yellow">usr</span>/<span
class="" style="background-color:yellow">sbin</span>/<span
class="" style="background-color:yellow">kamailio</span>[19580]:
ERROR: db_<span class="" style="background-color:yellow">mysql</span>
[km_row.c:68]: db_<span class=""
style="background-color:yellow">mysql</span>_convert_row():
failed to convert value</div>
<div>Feb 25 11:42:11 <span class=""
style="background-color:yellow">hagi</span> /<span
class="" style="background-color:yellow">usr</span>/<span
class="" style="background-color:yellow">sbin</span>/<span
class="" style="background-color:yellow">kamailio</span>[19580]:
ERROR: db_<span class="" style="background-color:yellow">mysql</span>
[km_<span class="" style="background-color:yellow">dbase</span>.c:375]:
db_<span class="" style="background-color:yellow">mysql</span>_fetch_result():
error while converting row #0</div>
<div>Feb 25 11:42:11 <span class=""
style="background-color:yellow">hagi</span> /<span
class="" style="background-color:yellow">usr</span>/<span
class="" style="background-color:yellow">sbin</span>/<span
class="" style="background-color:yellow">kamailio</span>[19580]:
ERROR: <span class="" style="background-color:yellow">usrloc</span>
[<span class="" style="background-color:yellow">udomain</span>.c:420]:
<span class="" style="background-color:yellow">preload</span>_<span
class="" style="background-color:yellow">udomain</span>():
fetching rows failed</div>
<div><br>
</div>
<div><span class="" style="background-color:yellow">usrloc</span>
Module is configured with db_mode "1" so it saves it's
entries by itself. When i have a look on the database it
looks good and the expires field is an <span class=""
style="background-color:yellow">datetime</span>. From logs
it looks like it try to parse a <span class=""
style="background-color:yellow">unix</span> timestamp
instead of the <span class=""
style="background-color:yellow">datetime</span>.</div>
<div><br>
</div>
<div>when i truncate the location table it starts perfectly,
since there are no entries stored where it could fail
parsing expires date.</div>
<div><br>
</div>
<div>does anybody has similar issue or any suggestions how to
solve?</div>
<div><br>
</div>
<div>found in Version: 4.1.0</div>
<div><br>
</div>
<div>many thanks!</div>
<div><br>
</div>
<div>BR</div>
<div><span class="" style="background-color:yellow">Jöran</span></div>
<div><br>
</div>
<div><br>
</div>
-- <br>
<pre><span class="" style="background-color:yellow">Jöran</span> <span class="" style="background-color:yellow">Vinzens</span>
<span class="" style="background-color:yellow">sipgate</span> <span class="" style="background-color:yellow">GmbH</span> - <span class="" style="background-color:yellow">Gladbacher</span> <span class="" style="background-color:yellow">Str</span>. 74 - 40219 <span class="" style="background-color:yellow">Düsseldorf</span>
<span class="" style="background-color:yellow">HRB</span> <span class="" style="background-color:yellow">Düsseldorf</span> 39841 - <span class="" style="background-color:yellow">Geschäftsführer</span>: <span class="" style="background-color:yellow">Thilo</span> Salmon, Tim <span class="" style="background-color:yellow">Mois</span>
<span class="" style="background-color:yellow">Steuernummer</span>: 106/5724/7147, <span class="" style="background-color:yellow">Umsatzsteuer</span>-ID: DE219349391
<a moz-do-not-send="true" href="http://www.sipgate.de" target="_blank">www.<span class="" style="background-color:yellow">sipgate</span>.<span class="" style="background-color:yellow">de</span></a> - <a moz-do-not-send="true" href="http://www.sipgate.at" target="_blank">www.<span class="" style="background-color:yellow">sipgate</span>.at</a> - <a moz-do-not-send="true" href="http://www.sipgate.co.uk" target="_blank">www.<span class="" style="background-color:yellow">sipgate</span>.co.<span class="" style="background-color:yellow">uk</span></a>
</pre>
</div>
</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://www.asipto.com">http://www.asipto.com</a>
<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></pre>
</body>
</html>