[SR-Users] Problems while reading from location and parsing expires

Jöran Vinzens vinzens at sipgate.de
Tue Feb 25 12:01:10 CET 2014


Hi All,

we are upgrading from kamailio 3.1 to 4.1 and we got stuck at a Problem
with usrloc module.

While starting up kamailio reads location from DB and try to parse expires
date from DB.

this is the Problem:

Feb 25 11:42:11 hagi /usr/sbin/kamailio[19580]: ERROR: <core> [db_ut.c:90]:
db_str2int(): Unexpected characters: [-02-25 11:27:08]
Feb 25 11:42:11 hagi /usr/sbin/kamailio[19580]: ERROR: <core>
[db_val.c:75]: db_str2val(): error while converting integer value from
string
Feb 25 11:42:11 hagi /usr/sbin/kamailio[19580]: ERROR:
db_mysql[km_row.c:68]: db_
mysql_convert_row(): failed to convert value
Feb 25 11:42:11 hagi /usr/sbin/kamailio[19580]: ERROR: db_mysql
[km_dbase.c:375]:
db_mysql_fetch_result(): error while converting row #0
Feb 25 11:42:11 hagi /usr/sbin/kamailio[19580]: ERROR: usrloc [udomain.c:420]:
preload_udomain(): fetching rows failed

usrloc 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 datetime. From logs it looks like it try to parse a
unixtimestamp instead of the
datetime.

when i truncate the location table it starts perfectly, since there are no
entries stored where it could fail parsing expires date.

does anybody has similar issue or any suggestions how to solve?

found in Version: 4.1.0

many thanks!

BR
Jöran


-- 

Jöran Vinzens

sipgate GmbH - Gladbacher Str. 74 - 40219 Düsseldorf
HRB Düsseldorf 39841 - Geschäftsführer: Thilo Salmon, Tim Mois
Steuernummer: 106/5724/7147, Umsatzsteuer-ID: DE219349391

www.sipgate.de - www.sipgate.at - www.sipgate.co.uk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140225/ddcf7e96/attachment.html>


More information about the sr-users mailing list