[SR-Users] usrloc module expires column issues

[Daniel-Constantin Mierla]

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>
> *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://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/aabce66c/attachment.html>