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 unix timestamp 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

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda