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