Hello,
can you give the output in mysql client for:
describe location
What version of mysql is used?
Can you get the logs with debug=3 in kamailio.cfg?
Cheers, Daniel
On 25/02/14 12:01, Jöran Vinzens wrote:
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 - 40219Düsseldorf
HRB Düsseldorf 39841 -Geschäftsführer:Thilo Salmon, TimMois
Steuernummer: 106/5724/7147,Umsatzsteuer-ID: DE219349391
www.sipgate.de http://www.sipgate.de -www.sipgate.at http://www.sipgate.at -www.sipgate.co.uk http://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