Dear All
I do have two kamailio servers, same firewall same config the only difference is the listening IPs, and the alias name, they do use the same database. And both insert accounting information into different tables.
My issue is that one kamailio does correctly store users in the location table for one of the kamailio servers but it does do so for the second kamailio, I did apply *diff *to both kamailio.cfg and kamctlrc and the only thing that is different is IPs/Alias/Accounting table names.
Please advice.
On 09/10/2013 08:37 AM, Ali Jawad wrote:
Dear All
I do have two kamailio servers, same firewall same config the only difference is the listening IPs, and the alias name, they do use the same database. And both insert accounting information into different tables.
My issue is that one kamailio does correctly store users in the location table for one of the kamailio servers but it does do so for the second kamailio, I did apply *diff *to both kamailio.cfg and kamctlrc and the only thing that is different is IPs/Alias/Accounting table names.
Are you sharing both the database and the table among the two Kamailio instances, or just sharing the database and using different tables?
Are you sure that your db_mode parameter for usrloc is the same on both servers?
-- Alex
Dear Alex 100% positive that both are using the same db_mode parameter for usrloc, and yes they both share the same database and table the only different table is the accounting table. Both kamailio servers work great and newly registered users through site can logon just fine to both systems and make calls, it is this location table issue that is killing me as I have scripts that do various functions by accessing the location table. Regards
On Tue, Sep 10, 2013 at 3:39 PM, Alex Balashov abalashov@evaristesys.comwrote:
On 09/10/2013 08:37 AM, Ali Jawad wrote:
Dear All
I do have two kamailio servers, same firewall same config the only difference is the listening IPs, and the alias name, they do use the same database. And both insert accounting information into different tables.
My issue is that one kamailio does correctly store users in the location table for one of the kamailio servers but it does do so for the second kamailio, I did apply *diff *to both kamailio.cfg and kamctlrc and the
only thing that is different is IPs/Alias/Accounting table names.
Are you sharing both the database and the table among the two Kamailio instances, or just sharing the database and using different tables?
Are you sure that your db_mode parameter for usrloc is the same on both servers?
-- Alex
-- Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Decatur, GA 30030 United States Tel: +1-678-954-0670 Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
______________________________**_________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/**cgi-bin/mailman/listinfo/sr-**usershttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
On 09/10/2013 08:45 AM, Ali Jawad wrote:
100% positive that both are using the same db_mode parameter for usrloc, and yes they both share the same database and table the only different table is the accounting table. Both kamailio servers work great and newly registered users through site can logon just fine to both systems and make calls, it is this location table issue that is killing me as I have scripts that do various functions by accessing the location table.
What is the db_mode you are using, and what is the sync timer interval? Is it possible that these servers are removing each others' contacts quite quickly when they get updated?
Dear Alex One server is for iphone users and one for android users, so technically speaking a user is registered to only one server at a time, apart from a few exceptions I guess.
Please see my settings below :
# ----- usrloc params ----- /* enable DB persistency for location entries */ #!ifdef WITH_USRLOCDB modparam("usrloc", "timer_interval", 1) modparam("usrloc", "db_url", DBURL) modparam("usrloc", "db_mode", 2) modparam("usrloc", "use_domain", MULTIDOMAIN) #!endif
Thanks !
On Tue, Sep 10, 2013 at 3:47 PM, Alex Balashov abalashov@evaristesys.comwrote:
On 09/10/2013 08:45 AM, Ali Jawad wrote:
100% positive that both are using the same db_mode parameter for usrloc,
and yes they both share the same database and table the only different table is the accounting table. Both kamailio servers work great and newly registered users through site can logon just fine to both systems and make calls, it is this location table issue that is killing me as I have scripts that do various functions by accessing the location table.
What is the db_mode you are using, and what is the sync timer interval? Is it possible that these servers are removing each others' contacts quite quickly when they get updated?
-- Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Decatur, GA 30030 United States Tel: +1-678-954-0670 Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
______________________________**_________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/**cgi-bin/mailman/listinfo/sr-**usershttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
That may not stop the other server from deleting its contacts. Try using db_mode 3.
On 09/10/2013 08:53 AM, Ali Jawad wrote:
Dear Alex One server is for iphone users and one for android users, so technically speaking a user is registered to only one server at a time, apart from a few exceptions I guess.
Please see my settings below :
# ----- usrloc params ----- /* enable DB persistency for location entries */ #!ifdef WITH_USRLOCDB modparam("usrloc", "timer_interval", 1) modparam("usrloc", "db_url", DBURL) modparam("usrloc", "db_mode", 2) modparam("usrloc", "use_domain", MULTIDOMAIN) #!endif
Thanks !
On Tue, Sep 10, 2013 at 3:47 PM, Alex Balashov <abalashov@evaristesys.com mailto:abalashov@evaristesys.com> wrote:
On 09/10/2013 08:45 AM, Ali Jawad wrote: 100% positive that both are using the same db_mode parameter for usrloc, and yes they both share the same database and table the only different table is the accounting table. Both kamailio servers work great and newly registered users through site can logon just fine to both systems and make calls, it is this location table issue that is killing me as I have scripts that do various functions by accessing the location table. What is the db_mode you are using, and what is the sync timer interval? Is it possible that these servers are removing each others' contacts quite quickly when they get updated? -- Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Decatur, GA 30030 United States Tel: +1-678-954-0670 Web: http://www.evaristesys.com/, http://www.alexbalashov.com/ _________________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org> http://lists.sip-router.org/__cgi-bin/mailman/listinfo/sr-__users <http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>-- *Ali Jawad
*Information Systems Manager CISSP - PMP - ITIL V3 - RHCE - VCP - C|EH - CCNA - MCSA
*Splendor Telecom (www.splendor.net http://www.splendor.net/) Beirut, Lebanon Phone: +9611373725/ext 116 FAX: +9611375554
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Will do but the issue is that the contacts are not added to start with, but will try 3
On Tue, Sep 10, 2013 at 4:12 PM, Alex Balashov abalashov@evaristesys.comwrote:
That may not stop the other server from deleting its contacts. Try using db_mode 3.
On 09/10/2013 08:53 AM, Ali Jawad wrote:
Dear Alex
One server is for iphone users and one for android users, so technically speaking a user is registered to only one server at a time, apart from a few exceptions I guess.
Please see my settings below :
# ----- usrloc params ----- /* enable DB persistency for location entries */ #!ifdef WITH_USRLOCDB modparam("usrloc", "timer_interval", 1) modparam("usrloc", "db_url", DBURL) modparam("usrloc", "db_mode", 2) modparam("usrloc", "use_domain", MULTIDOMAIN) #!endif
Thanks !
On Tue, Sep 10, 2013 at 3:47 PM, Alex Balashov <abalashov@evaristesys.com <mailto:abalashov@evaristesys.**comabalashov@evaristesys.com>> wrote:
On 09/10/2013 08:45 AM, Ali Jawad wrote: 100% positive that both are using the same db_mode parameter for usrloc, and yes they both share the same database and table the only different table is the accounting table. Both kamailio servers work greatand newly registered users through site can logon just fine to both systems and make calls, it is this location table issue that is killing me as I have scripts that do various functions by accessing the location table.
What is the db_mode you are using, and what is the sync timer interval? Is it possible that these servers are removing each others' contacts quite quickly when they get updated? -- Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Decatur, GA 30030 United States Tel: +1-678-954-0670 Web: http://www.evaristesys.com/, http://www.alexbalashov.com/ ______________________________**___________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailinglist sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-**router.orgsr-users@lists.sip-router.org
http://lists.sip-router.org/__**cgi-bin/mailman/listinfo/sr-__**users<http://lists.sip-router.org/__cgi-bin/mailman/listinfo/sr-__users> <http://lists.sip-router.org/**cgi-bin/mailman/listinfo/sr-**users<http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>-- *Ali Jawad
*Information Systems Manager
CISSP - PMP - ITIL V3 - RHCE - VCP - C|EH - CCNA - MCSA
*Splendor Telecom (www.splendor.net http://www.splendor.net/)
Beirut, Lebanon Phone: +9611373725/ext 116 FAX: +9611375554
______________________________**_________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/**cgi-bin/mailman/listinfo/sr-**usershttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-- Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Decatur, GA 30030 United States Tel: +1-678-954-0670 Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
______________________________**_________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/**cgi-bin/mailman/listinfo/sr-**usershttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
On 09/10/2013 09:13 AM, Ali Jawad wrote:
Will do but the issue is that the contacts are not added to start with, but will try 3
I'm not so sure about that. I would hypothesise that they are simply being deleted too quickly for you to notice, since your timer interval is 1 second.
So if the timer is 1 sec, they will get deleted if the client does not send a keep alive ? or other servers are affecting each other ? Regards
On Tue, Sep 10, 2013 at 4:14 PM, Alex Balashov abalashov@evaristesys.comwrote:
On 09/10/2013 09:13 AM, Ali Jawad wrote:
Will do but the issue is that the contacts are not added to start with,
but will try 3
I'm not so sure about that. I would hypothesise that they are simply being deleted too quickly for you to notice, since your timer interval is 1 second.
-- Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Decatur, GA 30030 United States Tel: +1-678-954-0670 Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
______________________________**_________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/**cgi-bin/mailman/listinfo/sr-**usershttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
On 09/10/2013 09:18 AM, Ali Jawad wrote:
So if the timer is 1 sec, they will get deleted if the client does not send a keep alive ? or other servers are affecting each other ?
I think the two servers are affecting each other. Try change the db_mode to 3, and set your timer interval to something longer.
Hi I did change db_mode to 3 , and restarted both server, it did not really affect the setup, I will change timer and retry as well. Regards
On Tue, Sep 10, 2013 at 4:19 PM, Alex Balashov abalashov@evaristesys.comwrote:
On 09/10/2013 09:18 AM, Ali Jawad wrote:
So if the timer is 1 sec, they will get deleted if the client does not
send a keep alive ? or other servers are affecting each other ?
I think the two servers are affecting each other. Try change the db_mode to 3, and set your timer interval to something longer.
-- Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Decatur, GA 30030 United States Tel: +1-678-954-0670 Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
______________________________**_________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/**cgi-bin/mailman/listinfo/sr-**usershttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Strangely db_mode 3 did bring down the no of users to 0 in kamctl ul show --brief on one server, but I could register on that server and make a call and it would still show 0, although I did set timer to 3600.
On Tue, Sep 10, 2013 at 4:21 PM, Ali Jawad ali.jawad@splendor.net wrote:
Hi I did change db_mode to 3 , and restarted both server, it did not really affect the setup, I will change timer and retry as well. Regards
On Tue, Sep 10, 2013 at 4:19 PM, Alex Balashov abalashov@evaristesys.comwrote:
On 09/10/2013 09:18 AM, Ali Jawad wrote:
So if the timer is 1 sec, they will get deleted if the client does not
send a keep alive ? or other servers are affecting each other ?
I think the two servers are affecting each other. Try change the db_mode to 3, and set your timer interval to something longer.
-- Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Decatur, GA 30030 United States Tel: +1-678-954-0670 Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
______________________________**_________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/**cgi-bin/mailman/listinfo/sr-**usershttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-- *Ali Jawad
*Information Systems Manager CISSP - PMP - ITIL V3 - RHCE - VCP - C|EH - CCNA - MCSA
*Splendor Telecom (www.splendor.net) Beirut, Lebanon Phone: +9611373725/ext 116 FAX: +9611375554
-
Alex Balashov -
Ali Jawad