[SR-Users] usrloc module expires column issues

[Daniel-Constantin Mierla]

Hello,

the version I noticed some changes in dealing with unsigned int values
was 5.7 ...

Can you enable sql query logging and see what's the insert statement for
location table? Or, if the connection to the database server is over IP
(and not tls), then you can do ngrep on port 3306 (iirc by heart the
default port for mysql) -- you should be able to spot the text query
along some binary headers.

It would be good to see if the sql is ok or broken, to know where to
look further.

Cheers,
Daniel


On 08/11/16 11:36, Grant Bagdasarian wrote:
>
> Hi Daniel,
>
>  
>
> My apologies, we’re not running MariaDB, but a regular instance of MySQL:
>
>  
>
> mysql -v
>
> mysql  Ver 14.14 Distrib 5.5.49, for debian-linux-gnu (x86_64) using
> readline 6.3
>
>  
>
> Regards,
>
>  
>
> Grant
>
>  
>
> *From:*Daniel-Constantin Mierla [mailto:miconda at gmail.com]
> *Sent:* dinsdag 8 november 2016 11:32
> *To:* Grant Bagdasarian <gb at cm.nl>; Kamailio (SER) - Users Mailing
> List <sr-users at lists.sip-router.org>
> *Subject:* Re: [SR-Users] usrloc module expires column issues
>
>  
>
> Hello,
>
> I haven't encountered such problem so far and no similar report was
> done to kamailio project recently. I noticed that newer versions of
> mysql (maybe mariadb as well) are behaving differently than old ones
> -- what mariadb version do you run?
>
> Cheers,
> Daniel
>
>  
>
> On 08/11/16 10:42, Grant Bagdasarian wrote:
>
>     Hi Daniel,
>
>      
>
>     Sorry for the late reply.
>
>     We’re using a Galera Cluster based on Maria DB.
>
>      
>
>     Regards,
>
>      
>
>     Grant Bagdasarian
>
>      
>
>      
>
>     *From:*sr-users [mailto:sr-users-bounces at lists.sip-router.org] *On
>     Behalf Of *Daniel-Constantin Mierla
>     *Sent:* donderdag 6 oktober 2016 12:50
>     *To:* Kamailio (SER) - Users Mailing List
>     <sr-users at lists.sip-router.org> <mailto:sr-users at lists.sip-router.org>
>     *Subject:* Re: [SR-Users] usrloc module expires column issues
>
>      
>
>     Hello,
>
>     what database server are you using?
>
>     Cheers,
>     Daniel
>
>      
>
>     On 26/09/16 16:50, Grant Bagdasarian wrote:
>
>         Hello,
>
>          
>
>         When saving in the location table, the expires and
>         last_modified columns contain the value 000-00-00 00:00:00
>         which causes issues when Kamailio is restarted and the preload
>         modparam is set to load the location table from db in memory
>         at startup.
>
>         I’ve already upgraded Kamailio to 4.4.3, and used the dbtables
>         script from version 4.4 to recreate the location table, but
>         without success.
>
>          
>
>         Anyone else having this issue? Any resolution for it?
>
>          
>
>         Regards,
>
>          
>
>         Grant Bagdasarian
>
>         CM
>
>
>
>
>
>         _______________________________________________
>
>         SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>
>         sr-users at lists.sip-router.org
>         <mailto:sr-users at lists.sip-router.org>
>
>         http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
>
>
>     -- 
>
>     Daniel-Constantin Mierla
>
>     http://twitter.com/#!/miconda <http://twitter.com/#%21/miconda> - http://www.linkedin.com/in/miconda
>
>     Kamailio Advanced Training, Berlin, Oct 24-26, 2016 - http://www.asipto.com
>
>
>
> -- 
> Daniel-Constantin Mierla
> http://twitter.com/#!/miconda <http://twitter.com/#%21/miconda> - http://www.linkedin.com/in/miconda
> Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - http://www.asipto.com

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - http://www.asipto.com

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