Thank you very much Dimitri, good point. On Fri, Nov 17, 2017 at 2:38 PM, Dmitri Savolainen <savolai...@erinaco.ru> 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 <gr.sab...@gmail.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 < >> mico...@gmail.com> 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.sab...@gmail.com> >>> wrote: >>> >>>> Hello Daniel, >>>> >>>> I use a value of 3 for db_mode. >>>> >>>> On Wed, Nov 15, 2017 at 11:11 AM, Daniel-Constantin Mierla < >>>> mico...@gmail.com> 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@lists.kamailio.org >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >> >> > > > -- > Savolainen Dmitri > > _______________________________________________ > Kamailio (SER) - Users Mailing List > sr-users@lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > >
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users