Re: [SR-Users] issue with usr_loc db_mode

2014-05-09 Thread Daniel-Constantin Mierla
Hello, can you enable query log in mysql and verify if they happen in such case? I checked and for db_mode=1, it should immediately do the query. For db_mode=3, th queries are done on time. Also, is there any other application that could potentially delete records? Because after the first re

Re: [SR-Users] issue with usr_loc db_mode

2014-05-08 Thread Henry Fernandes
There are no errors in the log about this. Yesterday, I tried db_mode=2 (with default 'timer_interval' of 60 seconds) and it's better now, although still not working properly. There are still some records that are not in the 'location' table in the database. For example, I have a phone that

Re: [SR-Users] issue with usr_loc db_mode

2014-05-08 Thread Daniel-Constantin Mierla
Hello, any db_mode>0 in 3.3 is safe for not losing registrations upon kamailio restart (e.g., db_mode=2 writes to db on time and at shutdown, so nothing is lost as well). db_mode=1 should do that in realtime, indeed. I'm not aware of any issue with db_mode=1, being used in quite some deploym

Re: [SR-Users] issue with usr_loc db_mode

2014-05-07 Thread 5060
I am facing very similar problem. the sip phones can registered, online and ul show can see the phones. but after while (less 5 min), kamailio show the error: binding ... has expired. I change to db_mode=2, the problem still there. after restart kamailio again, the phones come on. 2014-05-08

[SR-Users] issue with usr_loc db_mode

2014-05-07 Thread Henry Fernandes
I'm using Kamailio 3.3 and the USRLOC module to track registrations. I have set "db_mode" to 1 because I want to store all registration info to the database and I want the database to be up to date (in case I need to restart Kamailio). Unfortunately, this doesn't work as I expect. When I quer