Re: [SR-Users] usrloc module expires column issues

2016-11-10 Thread Daniel-Constantin Mierla
sdag 8 november 2016 14:58 > *To:* Grant Bagdasarian ; Kamailio (SER) - Users Mailing > List > *Subject:* Re: [SR-Users] usrloc module expires column issues > > > > Hello, > > so it seems that inserting a timestamp value to a datetime column is > no longer accepted, but no

Re: [SR-Users] usrloc module expires column issues

2016-11-09 Thread Grant Bagdasarian
; Kamailio (SER) - Users Mailing List Subject: Re: [SR-Users] usrloc module expires column issues Hello, 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

Re: [SR-Users] usrloc module expires column issues

2016-11-08 Thread Daniel-Constantin Mierla
,`last_modified`=14786116 > > > 49,`ruid`='uloc-5821d267-22ed-1',`instance`=NULL,`reg_id`=0,`server_id`=0,`connection_id`=-1,`keepalive`=0,`contact`='sip:s@1.1.1.1:5060' > where `username`='sip-server-ivr-01' AND > `contact`='sip:s@1.1.1.1:5060&#x

Re: [SR-Users] usrloc module expires column issues

2016-11-08 Thread Grant Bagdasarian
contact`='sip:s@1.1.1.1:5060' AND `call id`='56b9ca823f9a11d361e184cc5eed07fc@1.1.1.1' AND `domain`='sip-server-gw-01.test.voipdomain.local' From: Daniel-Constantin Mierla [mailto:mico...@gmail.com] Sent: dinsdag 8 november 2016 12:38 To: Grant Bagdasarian ; Kamailio

Re: [SR-Users] usrloc module expires column issues

2016-11-08 Thread Daniel-Constantin Mierla
tantin Mierla [mailto:mico...@gmail.com] > *Sent:* dinsdag 8 november 2016 11:32 > *To:* Grant Bagdasarian ; Kamailio (SER) - Users Mailing > List > *Subject:* Re: [SR-Users] usrloc module expires column issues > > > > Hello, > > I haven't encountered such pro

Re: [SR-Users] usrloc module expires column issues

2016-11-08 Thread Grant Bagdasarian
: Grant Bagdasarian ; Kamailio (SER) - Users Mailing List 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

Re: [SR-Users] usrloc module expires column issues

2016-11-08 Thread Daniel-Constantin Mierla
lists.sip-router.org] *On > Behalf Of *Daniel-Constantin Mierla > *Sent:* donderdag 6 oktober 2016 12:50 > *To:* Kamailio (SER) - Users Mailing List > *Subject:* Re: [SR-Users] usrloc module expires column issues > > > > Hello, > > what database server ar

Re: [SR-Users] usrloc module expires column issues

2016-11-08 Thread Grant Bagdasarian
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

Re: [SR-Users] usrloc module expires column issues

2016-10-06 Thread Daniel-Constantin Mierla
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 pre