Hello Daniel, I use a value of 3 for db_mode. On Wed, Nov 15, 2017 at 11:11 AM, Daniel-Constantin Mierla < miconda(a)gmail.com&gt; wrote: > Hello, > > what is the value of db_mode parameter for usrloc module? > > Cheers, > Daniel > > On 15.11.17 06:36, Gholamreza Sabery wrote: > > I have a Kamailio server that has: > > modparam("registrar", "max_contacts", 2) > > But recently I noticed some users have more than two records in the > location table. For example one of the users has three different records > with nearly the same information. The records are as follows. Is this > behavior normal? (I am using Kamailio 4XX). > > *************************** 1. row *************************** > id: 171296745 > ruid: uloc-2c69-59db6c73-7ca-132d92 > username: 999999999999 > domain: NULL > contact: sip:999999999999@5.106.35.18:10362 > received: sip:5.106.35.18:10361 > path: NULL > expires: 2017-11-14 08:45:50 > q: -1.00 > callid: XpCnmaAhRF > cseq: 43 > last_modified: 2017-11-14 08:44:50 > flags: 0 > cflags: 64 > user_agent: android_1.1.0_samsung_SM-E500H > _7b271714c08b942aa821fc756cdd2e890a37069e/1.1.0 (belle-sip/1.4.2) > socket: udp:192.168.103.21:5060 > methods: NULL > instance: <urn:uuid:8369ef6e-202b-4844-8928-492a7678c269> > reg_id: 0 > server_id: 11369 > connection_id: -1 > keepalive: 1 > partition: 14 > *************************** 2. row *************************** > id: 171296746 > ruid: uloc-2c69-59db6c73-7f2-eb5d92 > username: 999999999999 > domain: NULL > contact: sip:999999999999@5.106.35.18:10362 > received: sip:5.106.35.18:10361 > path: NULL > expires: 2017-11-14 08:45:50 > q: -1.00 > callid: BzMKuyJN8C > cseq: 50 > last_modified: 2017-11-14 08:44:50 > flags: 0 > cflags: 64 > user_agent: android_1.1.0_samsung_SM-E500H > _7b271714c08b942aa821fc756cdd2e890a37069e/1.1.0 (belle-sip/1.4.2) > socket: udp:192.168.103.21:5060 > methods: NULL > instance: <urn:uuid:8369ef6e-202b-4844-8928-492a7678c269> > reg_id: 0 > server_id: 11369 > connection_id: -1 > keepalive: 1 > partition: 23 > *************************** 3. row *************************** > id: 171296747 > ruid: uloc-2c69-59db6c73-80f-541d92 > username: 999999999999 > domain: NULL > contact: sip:999999999999@5.106.35.18:10362 > received: sip:5.106.35.18:10361 > path: NULL > expires: 2017-11-14 08:45:50 > q: -1.00 > callid: 3p9P4PgZSv > cseq: 51 > last_modified: 2017-11-14 08:44:50 > flags: 0 > cflags: 64 > user_agent: android_1.1.0_samsung_SM-E500H > _7b271714c08b942aa821fc756cdd2e890a37069e/1.1.0 (belle-sip/1.4.2) > socket: udp:192.168.103.21:5060 > methods: NULL > instance: <urn:uuid:8369ef6e-202b-4844-8928-492a7678c269> > reg_id: 0 > server_id: 11369 > connection_id: -1 > keepalive: 1 > partition: 15 > > > _______________________________________________ > Kamailio (SER) - Users Mailing Listsr-users@lists.kamailio.orghttps://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > > > -- > Daniel-Constantin Mierlawww.twitter.com/miconda -- www.linkedin.com/in/miconda > Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com > Kamailio World Conference - www.kamailioworld.com > >

Dear Daniel, I can not use db_mode=1 in my setup; but I will try to test it. Regards On Thu, Nov 16, 2017 at 9:23 PM, Daniel-Constantin Mierla < miconda(a)gmail.com&gt; wrote: > Very busy with the work this week ... > > To see if this a limitation of db only mode or not, can you test with > db_mode=1? > > Cheers, > Daniel > > On 16.11.17 16:51, Gholamreza Sabery wrote: > > No ideas? > > On Wed, Nov 15, 2017 at 3:27 PM, Gholamreza Sabery < > gr.sabery(a)gmail.com&gt; wrote: > >> Hello Daniel, >> >> I use a value of 3 for db_mode. >> >> On Wed, Nov 15, 2017 at 11:11 AM, Daniel-Constantin Mierla < >> miconda(a)gmail.com&gt; wrote: >> >>> Hello, >>> >>> what is the value of db_mode parameter for usrloc module? >>> >>> Cheers, >>> Daniel >>> >>> On 15.11.17 06:36, Gholamreza Sabery wrote: >>> >>> I have a Kamailio server that has: >>> >>> modparam("registrar", "max_contacts", 2) >>> >>> But recently I noticed some users have more than two records in the >>> location table. For example one of the users has three different records >>> with nearly the same information. The records are as follows. Is this >>> behavior normal? (I am using Kamailio 4XX). >>> >>> *************************** 1. row *************************** >>> id: 171296745 >>> ruid: uloc-2c69-59db6c73-7ca-132d92 >>> username: 999999999999 >>> domain: NULL >>> contact: sip:999999999999@5.106.35.18:10362 >>> received: sip:5.106.35.18:10361 >>> path: NULL >>> expires: 2017-11-14 08:45:50 >>> q: -1.00 >>> callid: XpCnmaAhRF >>> cseq: 43 >>> last_modified: 2017-11-14 08:44:50 >>> flags: 0 >>> cflags: 64 >>> user_agent: android_1.1.0_samsung_SM-E500H >>> _7b271714c08b942aa821fc756cdd2e890a37069e/1.1.0 (belle-sip/1.4.2) >>> socket: udp:192.168.103.21:5060 >>> methods: NULL >>> instance: <urn:uuid:8369ef6e-202b-4844-8928-492a7678c269> >>> reg_id: 0 >>> server_id: 11369 >>> connection_id: -1 >>> keepalive: 1 >>> partition: 14 >>> *************************** 2. row *************************** >>> id: 171296746 >>> ruid: uloc-2c69-59db6c73-7f2-eb5d92 >>> username: 999999999999 >>> domain: NULL >>> contact: sip:999999999999@5.106.35.18:10362 >>> received: sip:5.106.35.18:10361 >>> path: NULL >>> expires: 2017-11-14 08:45:50 >>> q: -1.00 >>> callid: BzMKuyJN8C >>> cseq: 50 >>> last_modified: 2017-11-14 08:44:50 >>> flags: 0 >>> cflags: 64 >>> user_agent: android_1.1.0_samsung_SM-E500H >>> _7b271714c08b942aa821fc756cdd2e890a37069e/1.1.0 (belle-sip/1.4.2) >>> socket: udp:192.168.103.21:5060 >>> methods: NULL >>> instance: <urn:uuid:8369ef6e-202b-4844-8928-492a7678c269> >>> reg_id: 0 >>> server_id: 11369 >>> connection_id: -1 >>> keepalive: 1 >>> partition: 23 >>> *************************** 3. row *************************** >>> id: 171296747 >>> ruid: uloc-2c69-59db6c73-80f-541d92 >>> username: 999999999999 >>> domain: NULL >>> contact: sip:999999999999@5.106.35.18:10362 >>> received: sip:5.106.35.18:10361 >>> path: NULL >>> expires: 2017-11-14 08:45:50 >>> q: -1.00 >>> callid: 3p9P4PgZSv >>> cseq: 51 >>> last_modified: 2017-11-14 08:44:50 >>> flags: 0 >>> cflags: 64 >>> user_agent: android_1.1.0_samsung_SM-E500H >>> _7b271714c08b942aa821fc756cdd2e890a37069e/1.1.0 (belle-sip/1.4.2) >>> socket: udp:192.168.103.21:5060 >>> methods: NULL >>> instance: <urn:uuid:8369ef6e-202b-4844-8928-492a7678c269> >>> reg_id: 0 >>> server_id: 11369 >>> connection_id: -1 >>> keepalive: 1 >>> partition: 15 >>> >>> >>> _______________________________________________ >>> Kamailio (SER) - Users Mailing Listsr-users@lists.kamailio.orghttps://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>> >>> >>> -- >>> Daniel-Constantin Mierlawww.twitter.com/miconda -- www.linkedin.com/in/miconda >>> Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com >>> Kamailio World Conference - www.kamailioworld.com >>> >>> >> > > -- > Daniel-Constantin Mierlawww.twitter.com/miconda -- www.linkedin.com/in/miconda > Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com > Kamailio World Conference - www.kamailioworld.com > > _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Thank you very much Dimitri, good point. On Fri, Nov 17, 2017 at 2:38 PM, Dmitri Savolainen < savolainen(a)erinaco.ru&gt; wrote: > One of them is expired in my mind and wiating for "usrloc" > "timer_interval" for clearing in DB. Expired contact will ignore while > calling. Like this > MariaDB [kamailio_dev]> select username, expires, > UNIX_TIMESTAMP(expires) - UNIX_TIMESTAMP(now()), user_agent from location > where username='000*888'; > +----------+---------------------+-------------------------- > -----------------------+--------------------------------+ > | username | expires | UNIX_TIMESTAMP(expires) - > UNIX_TIMESTAMP(now()) | user_agent | > +----------+---------------------+-------------------------- > -----------------------+--------------------------------+ > | 000*888 | 2017-11-17 14:24:55 | > 1260 | Yealink SIP-T46G 28.81.0.25 | > | 000*888 | 2017-11-17 14:02:02 | > -113 | CSipSimpl||errrr | > | 000*888 | 2017-11-17 14:17:42 | > 827 | Bria Android 3.9.6 build 99409 | > +----------+---------------------+-------------------------- > -----------------------+--------------------------------+ > > > 2017-11-16 21:18 GMT+03:00 Gholamreza Sabery &lt;gr.sabery(a)gmail.com&gt;om>: > >> Dear Daniel, >> >> I can not use db_mode=1 in my setup; but I will try to test it. >> >> Regards >> >> >> On Thu, Nov 16, 2017 at 9:23 PM, Daniel-Constantin Mierla < >> miconda(a)gmail.com&gt; wrote: >> >>> Very busy with the work this week ... >>> >>> To see if this a limitation of db only mode or not, can you test >>> with db_mode=1? >>> >>> Cheers, >>> Daniel >>> >>> On 16.11.17 16:51, Gholamreza Sabery wrote: >>> >>> No ideas? >>> >>> On Wed, Nov 15, 2017 at 3:27 PM, Gholamreza Sabery < >>> gr.sabery(a)gmail.com&gt; wrote: >>> >>>> Hello Daniel, >>>> >>>> I use a value of 3 for db_mode. >>>> >>>> On Wed, Nov 15, 2017 at 11:11 AM, Daniel-Constantin Mierla < >>>> miconda(a)gmail.com&gt; wrote: >>>> >>>>> Hello, >>>>> >>>>> what is the value of db_mode parameter for usrloc module? >>>>> >>>>> Cheers, >>>>> Daniel >>>>> >>>>> On 15.11.17 06:36, Gholamreza Sabery wrote: >>>>> >>>>> I have a Kamailio server that has: >>>>> >>>>> modparam("registrar", "max_contacts", 2) >>>>> >>>>> But recently I noticed some users have more than two records in >>>>> the location table. For example one of the users has three different >>>>> records with nearly the same information. The records are as follows. Is >>>>> this behavior normal? (I am using Kamailio 4XX). >>>>> >>>>> *************************** 1. row *************************** >>>>> id: 171296745 >>>>> ruid: uloc-2c69-59db6c73-7ca-132d92 >>>>> username: 999999999999 >>>>> domain: NULL >>>>> contact: sip:999999999999@5.106.35.18:10362 >>>>> received: sip:5.106.35.18:10361 >>>>> path: NULL >>>>> expires: 2017-11-14 08:45:50 >>>>> q: -1.00 >>>>> callid: XpCnmaAhRF >>>>> cseq: 43 >>>>> last_modified: 2017-11-14 08:44:50 >>>>> flags: 0 >>>>> cflags: 64 >>>>> user_agent: android_1.1.0_samsung_SM-E500H >>>>> _7b271714c08b942aa821fc756cdd2e890a37069e/1.1.0 (belle-sip/1.4.2) >>>>> socket: udp:192.168.103.21:5060 >>>>> methods: NULL >>>>> instance: <urn:uuid:8369ef6e-202b-4844-8928-492a7678c269> >>>>> reg_id: 0 >>>>> server_id: 11369 >>>>> connection_id: -1 >>>>> keepalive: 1 >>>>> partition: 14 >>>>> *************************** 2. row *************************** >>>>> id: 171296746 >>>>> ruid: uloc-2c69-59db6c73-7f2-eb5d92 >>>>> username: 999999999999 >>>>> domain: NULL >>>>> contact: sip:999999999999@5.106.35.18:10362 >>>>> received: sip:5.106.35.18:10361 >>>>> path: NULL >>>>> expires: 2017-11-14 08:45:50 >>>>> q: -1.00 >>>>> callid: BzMKuyJN8C >>>>> cseq: 50 >>>>> last_modified: 2017-11-14 08:44:50 >>>>> flags: 0 >>>>> cflags: 64 >>>>> user_agent: android_1.1.0_samsung_SM-E500H >>>>> _7b271714c08b942aa821fc756cdd2e890a37069e/1.1.0 (belle-sip/1.4.2) >>>>> socket: udp:192.168.103.21:5060 >>>>> methods: NULL >>>>> instance: <urn:uuid:8369ef6e-202b-4844-8928-492a7678c269> >>>>> reg_id: 0 >>>>> server_id: 11369 >>>>> connection_id: -1 >>>>> keepalive: 1 >>>>> partition: 23 >>>>> *************************** 3. row *************************** >>>>> id: 171296747 >>>>> ruid: uloc-2c69-59db6c73-80f-541d92 >>>>> username: 999999999999 >>>>> domain: NULL >>>>> contact: sip:999999999999@5.106.35.18:10362 >>>>> received: sip:5.106.35.18:10361 >>>>> path: NULL >>>>> expires: 2017-11-14 08:45:50 >>>>> q: -1.00 >>>>> callid: 3p9P4PgZSv >>>>> cseq: 51 >>>>> last_modified: 2017-11-14 08:44:50 >>>>> flags: 0 >>>>> cflags: 64 >>>>> user_agent: android_1.1.0_samsung_SM-E500H >>>>> _7b271714c08b942aa821fc756cdd2e890a37069e/1.1.0 (belle-sip/1.4.2) >>>>> socket: udp:192.168.103.21:5060 >>>>> methods: NULL >>>>> instance: <urn:uuid:8369ef6e-202b-4844-8928-492a7678c269> >>>>> reg_id: 0 >>>>> server_id: 11369 >>>>> connection_id: -1 >>>>> keepalive: 1 >>>>> partition: 15 >>>>> >>>>> >>>>> _______________________________________________ >>>>> Kamailio (SER) - Users Mailing Listsr-users@lists.kamailio.orghttps://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>>> >>>>> >>>>> -- >>>>> Daniel-Constantin Mierlawww.twitter.com/miconda -- www.linkedin.com/in/miconda >>>>> Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com >>>>> Kamailio World Conference - www.kamailioworld.com >>>>> >>>>> >>>> >>> >>> -- >>> Daniel-Constantin Mierlawww.twitter.com/miconda -- www.linkedin.com/in/miconda >>> Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com >>> Kamailio World Conference - www.kamailioworld.com >>> >>> >> >> _______________________________________________ >> Kamailio (SER) - Users Mailing List >> sr-users(a)lists.kamailio.org >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >> >> > > > -- > Savolainen Dmitri > > _______________________________________________ > Kamailio (SER) - Users Mailing List > sr-users(a)lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > >