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

[Daniel-Constantin Mierla]

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 at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140225/381a4325/attachment.html>