<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello,</p>
<p>ok -- that's clear an issue due to new rules with latest versions
of mysql, definitely we need to investigate a bit more in this
direction.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<br>
<div class="moz-cite-prefix">On 10/11/16 08:56, Grant Bagdasarian
wrote:<br>
</div>
<blockquote
cite="mid:ce624a86f9f546c891b8c4805d4aa979@CM-EX-V01.cm.local"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Times New Roman \,serif";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle24
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle25
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="color:windowtext" lang="NL">Hi
Daniel,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext" lang="NL"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">Thank you!
Changing to bigint in the DB fixed it. Both expires and
last_modified now contain a unix timestamp.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">Reloading
also works now!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">Grant
Bagdasarian<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">CM<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="color:windowtext">From:</span></b><span
style="color:windowtext"> Daniel-Constantin Mierla
[<a class="moz-txt-link-freetext" href="mailto:miconda@gmail.com">mailto:miconda@gmail.com</a>]
<br>
<b>Sent:</b> dinsdag 8 november 2016 14:58<br>
<b>To:</b> Grant Bagdasarian <a class="moz-txt-link-rfc2396E" href="mailto:gb@cm.nl"><gb@cm.nl></a>; Kamailio
(SER) - Users Mailing List
<a class="moz-txt-link-rfc2396E" href="mailto:sr-users@lists.sip-router.org"><sr-users@lists.sip-router.org></a><br>
<b>Subject:</b> Re: [SR-Users] usrloc module expires
column issues<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p>Hello,<span style="font-size:12.0pt"><o:p></o:p></span></p>
<p>so it seems that inserting a timestamp value to a datetime
column is no longer accepted, but no complaints in the syslog
that value is invalid or db operation has failed, right? Nice
behaviour from db server, I would say ...<o:p></o:p></p>
<p>An option for now could be setting expires_type to bigint:<o:p></o:p></p>
<p><a moz-do-not-send="true"
href="https://www.kamailio.org/docs/modules/stable/modules/usrloc.html#usrloc.p.expires_type">https://www.kamailio.org/docs/modules/stable/modules/usrloc.html#usrloc.p.expires_type</a><o:p></o:p></p>
<p>But this kind of behaviour for datetime from database server
needs to be analyzed for several modules and fixed if it's the
case.<o:p></o:p></p>
<p>Cheers,<br>
Daniel<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On 08/11/16 14:33, Grant Bagdasarian
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="color:windowtext" lang="NL">Hi
Daniel,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext" lang="NL"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext" lang="NL">Nice
tip!</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext" lang="NL"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext" lang="NL">I
noticed the following:</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext" lang="NL"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">The
expires and last_modified columns are of DATETIME type,
but the insert and update statements pass a unix
timestamp.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">I can
change the datatype to a varchar for the expires and
last_modified columns, but I’m not sure if I will break
the usrloc module when preloading the rows.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">kamailio
-V</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">version:
kamailio 4.4.3 (x86_64/linux) 5a2195</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">flags:
STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS,
USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK,
SHM_MEM, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC,
TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX,
FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER,
USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">ADAPTIVE_WAIT_LOOPS=1024,
MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE
1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">poll
method support: poll, epoll_lt, epoll_et, sigio_rt,
select.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">id: 5a2195</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">compiled
on 16:42:49 Sep 26 2016 with gcc 4.9.2</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">cat
/usr/local/src/kamailio-4.4.3/utils/kamctl/mysql/usrloc-create.sql</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">CREATE
TABLE `location` (</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> `id`
INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> `ruid`
VARCHAR(64) DEFAULT '' NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`username` VARCHAR(64) DEFAULT '' NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`domain` VARCHAR(64) DEFAULT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`contact` VARCHAR(255) DEFAULT '' NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`received` VARCHAR(128) DEFAULT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> `path`
VARCHAR(512) DEFAULT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`expires` DATETIME DEFAULT '2030-05-28 21:32:15' NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> `q`
FLOAT(10,2) DEFAULT 1.0 NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`callid` VARCHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> `cseq`
INT(11) DEFAULT 1 NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`last_modified` DATETIME DEFAULT '1900-01-01 00:00:01' NOT
NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`flags` INT(11) DEFAULT 0 NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`cflags` INT(11) DEFAULT 0 NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`user_agent` VARCHAR(255) DEFAULT '' NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`socket` VARCHAR(64) DEFAULT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`methods` INT(11) DEFAULT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`instance` VARCHAR(255) DEFAULT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`reg_id` INT(11) DEFAULT 0 NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`server_id` INT(11) DEFAULT 0 NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`connection_id` INT(11) DEFAULT 0 NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`keepalive` INT(11) DEFAULT 0 NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
`partition` INT(11) DEFAULT 0 NOT NULL,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
CONSTRAINT ruid_idx UNIQUE (`ruid`)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext" lang="NL">);</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext" lang="NL"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">insert
into `location`
(`username`,`contact`,`expires`,`q`,`callid`,`cseq`,`flags`,`cflags`,`user_agent`,`received`,`path`,`socket`,`methods`,`last_modified`,`ruid`,`instance`,`reg_id`,`server_id`,`connection_id`,`keepalive`,`partition`,`domain`
) </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">values
('sip-server-ivr-01','<a moz-do-not-send="true"
href="sip:s@1.1.1.1:5060%27,1478611664,1.000000">sip:s@1.1.1.1:5060',1478611664,1.000000</a>
,'<a moz-do-not-send="true"
href="mailto:56b9ca823f9a11d361e184cc5eed07fc@1.1.1.1">56b9ca823f9a11d361e184cc5eed07fc@1.1.1.1</a>',15819,0,0,'Asterisk
PBX 13.9.1',NULL,NULL,'<a moz-do-not-send="true"
href="udp:10.14.34.211:5060%27,NULL,1478611563,%27uloc-5821d267-22ed-1%27,NULL,0,0,-1,0,0,%27sip-server-gw-01.test.voipdomain.local">udp:10.14.34.211:5060',NULL,1478611563,'uloc-5821d267-22ed-1',NULL,0,0,-1,0,0,'sip-server-gw-01.test.voipdomain.local</a>')</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">update
`location` set
`path`=NULL,`expires`=1478611744,`q`=1.000000
,`cseq`=15821,`flags`=0,`cflags`=0,`user_agent`='Asterisk
PBX 13.9.1',`received`=NULL,`socket`='<a
moz-do-not-send="true" href="udp:10.14.34.211:5060">udp:10.14.34.211:5060</a>',`methods`=NULL,`last_modified`=14786116</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">
49,`ruid`='uloc-5821d267-22ed-1',`instance`=NULL,`reg_id`=0,`server_id`=0,`connection_id`=-1,`keepalive`=0,`contact`='<a
moz-do-not-send="true" href="sip:s@1.1.1.1:5060">sip:s@1.1.1.1:5060</a>'
where `username`='sip-server-ivr-01' AND `contact`='<a
moz-do-not-send="true" href="sip:s@1.1.1.1:5060">sip:s@1.1.1.1:5060</a>'
AND `call</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> id`='<a
moz-do-not-send="true"
href="mailto:56b9ca823f9a11d361e184cc5eed07fc@1.1.1.1">56b9ca823f9a11d361e184cc5eed07fc@1.1.1.1</a>'
AND `domain`='sip-server-gw-01.test.voipdomain.local'</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="color:windowtext">From:</span></b><span
style="color:windowtext"> Daniel-Constantin Mierla [<a
moz-do-not-send="true"
href="mailto:miconda@gmail.com">mailto:miconda@gmail.com</a>]
<br>
<b>Sent:</b> dinsdag 8 november 2016 12:38<br>
<b>To:</b> Grant Bagdasarian <a
moz-do-not-send="true" href="mailto:gb@cm.nl"><gb@cm.nl></a>;
Kamailio (SER) - Users Mailing List
<a moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org"><sr-users@lists.sip-router.org></a><br>
<b>Subject:</b> Re: [SR-Users] usrloc module expires
column issues</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p>Hello,<o:p></o:p></p>
<p>the version I noticed some changes in dealing with unsigned
int values was 5.7 ...<o:p></o:p></p>
<p>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.<o:p></o:p></p>
<p>It would be good to see if the sql is ok or broken, to know
where to look further.<o:p></o:p></p>
<p>Cheers,<br>
Daniel<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">On 08/11/16 11:36, Grant Bagdasarian
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="color:windowtext"
lang="NL">Hi Daniel,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"
lang="NL"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">My
apologies, we’re not running MariaDB, but a regular
instance of MySQL:</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">mysql -v</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">mysql
Ver 14.14 Distrib 5.5.49, for debian-linux-gnu (x86_64)
using readline 6.3</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">Regards,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">Grant </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="color:windowtext">From:</span></b><span
style="color:windowtext"> Daniel-Constantin Mierla [<a
moz-do-not-send="true"
href="mailto:miconda@gmail.com">mailto:miconda@gmail.com</a>]
<br>
<b>Sent:</b> dinsdag 8 november 2016 11:32<br>
<b>To:</b> Grant Bagdasarian <a
moz-do-not-send="true" href="mailto:gb@cm.nl"><gb@cm.nl></a>;
Kamailio (SER) - Users Mailing List
<a moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org"><sr-users@lists.sip-router.org></a><br>
<b>Subject:</b> Re: [SR-Users] usrloc module expires
column issues</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p>Hello,<o:p></o:p></p>
<p>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?<o:p></o:p></p>
<p>Cheers,<br>
Daniel<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">On 08/11/16 10:42, Grant Bagdasarian
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="color:windowtext"
lang="NL">Hi Daniel,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"
lang="NL"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">Sorry
for the late reply.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">We’re
using a Galera Cluster based on Maria DB.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">Regards,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext">Grant
Bagdasarian</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:windowtext"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="color:windowtext">From:</span></b><span
style="color:windowtext"> sr-users [<a
moz-do-not-send="true"
href="mailto:sr-users-bounces@lists.sip-router.org">mailto:sr-users-bounces@lists.sip-router.org</a>]
<b>On Behalf Of </b>Daniel-Constantin Mierla<br>
<b>Sent:</b> donderdag 6 oktober 2016 12:50<br>
<b>To:</b> Kamailio (SER) - Users Mailing List <a
moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org">
<sr-users@lists.sip-router.org></a><br>
<b>Subject:</b> Re: [SR-Users] usrloc module
expires column issues</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p>Hello,<o:p></o:p></p>
<p>what database server are you using?<o:p></o:p></p>
<p>Cheers,<br>
Daniel<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">On 26/09/16 16:50, Grant
Bagdasarian wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Anyone else having this issue? Any
resolution for it?<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Regards,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Grant Bagdasarian<o:p></o:p></p>
<p class="MsoNormal">CM<o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman \,serif""><br>
<br>
<br>
<br>
<br>
<br>
</span><o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman \,serif""><br>
<br>
<br>
<br>
<br>
</span><o:p></o:p></p>
<pre>-- <o:p></o:p></pre>
<pre>Daniel-Constantin Mierla<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="http://twitter.com/#%21/miconda">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a><o:p></o:p></pre>
<pre>Kamailio Advanced Training, Berlin, Oct 24-26, 2016 - <a moz-do-not-send="true" href="http://www.asipto.com">http://www.asipto.com</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman",serif"><br>
<br>
<br>
<br>
</span><o:p></o:p></p>
<pre>-- <o:p></o:p></pre>
<pre>Daniel-Constantin Mierla<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="http://twitter.com/#%21/miconda">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a><o:p></o:p></pre>
<pre>Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - <a moz-do-not-send="true" href="http://www.asipto.com">http://www.asipto.com</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New Roman
\,serif""><br>
<br>
<br>
</span><o:p></o:p></p>
<pre>-- <o:p></o:p></pre>
<pre>Daniel-Constantin Mierla<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="http://twitter.com/#%21/miconda">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a><o:p></o:p></pre>
<pre>Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - <a moz-do-not-send="true" href="http://www.asipto.com">http://www.asipto.com</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman",serif"><br>
<br>
<o:p></o:p></span></p>
<pre>-- <o:p></o:p></pre>
<pre>Daniel-Constantin Mierla<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="http://twitter.com/#%21/miconda">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a><o:p></o:p></pre>
<pre>Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - <a moz-do-not-send="true" href="http://www.asipto.com">http://www.asipto.com</a><o:p></o:p></pre>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
</body>
</html>