[SR-Users] usrloc module expires column issues
Grant Bagdasarian
gb at cm.nl
Tue Nov 8 11:36:09 CET 2016
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://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/1fc0390c/attachment.html>
More information about the sr-users
mailing list