Issue with Location table
Dear All I had an issue with my kamailio that non-registered users were able to send calls "I.e. similar to Asterisk Peer mode" . So I did add the following statement if(!reg_fetch_contacts("location", "$fu", "caller")) { sl_send_reply("403", "Please register first"); exit; } That did fix the the problem with my registration issues, however as a a side effect the location table is not updated anymore and this broke a few scripts I use to maintain a few aspects of my system. kamctl ul --show does display all users correctly. However the database table only contains a few entries. My location settings are : # ----- 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 Please advice * *
25 jun 2013 kl. 14:34 skrev Ali Jawad <ali.jawad@splendor.net>:
Dear All
I had an issue with my kamailio that non-registered users were able to send calls "I.e. similar to Asterisk Peer mode" . So I did add the following statement
if(!reg_fetch_contacts("location", "$fu", "caller")) { sl_send_reply("403", "Please register first"); exit; }
That did fix the the problem with my registration issues, however as a a side effect the location table is not updated anymore and this broke a few scripts I use to maintain a few aspects of my system.
kamctl ul --show does display all users correctly.
However the database table only contains a few entries.
It all depends on where you added the code, so it's very hard for any on the list to help you. You might have a problem that REGISTER statements get checked here too and you want to avoid that to get them actually to successfully register. EIther add a check if method is not equal REGISTER or that it is equal INVITE depending upon what you want to do. Regards /Olle
My location settings are :
# ----- 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
Please advice
_______________________________________________ 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
That is logical, however in that case shouldn't the location table in memory be also missing entries ? On Tue, Jun 25, 2013 at 3:37 PM, Olle E. Johansson <oej@edvina.net> wrote:
25 jun 2013 kl. 14:34 skrev Ali Jawad <ali.jawad@splendor.net>:
Dear All
I had an issue with my kamailio that non-registered users were able to send calls "I.e. similar to Asterisk Peer mode" . So I did add the following statement
if(!reg_fetch_contacts("location", "$fu", "caller")) { sl_send_reply("403", "Please register first"); exit; }
That did fix the the problem with my registration issues, however as a a side effect the location table is not updated anymore and this broke a few scripts I use to maintain a few aspects of my system.
kamctl ul --show does display all users correctly.
However the database table only contains a few entries.
It all depends on where you added the code, so it's very hard for any on the list to help you. You might have a problem that REGISTER statements get checked here too and you want to avoid that to get them actually to successfully register. EIther add a check if method is not equal REGISTER or that it is equal INVITE depending upon what you want to do.
Regards /Olle
My location settings are :
# ----- 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
Please advice
* * _______________________________________________ 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
_______________________________________________ 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
-- *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 *
Howdy Ali, What version of Kamailio and mysql are you running? If you are running a VERY (yes, VERY) old version.. of both, you might end up in a case, where you will see that the location database will be updated in the beginning (just after you restart your proxy) but not afterwords. try to restart your proxy, see if a few registrations end up in your database table.. If so ;) I bet the problem is mysql timeouts ;) and you should update both your mysql and your kamailio :) - Atle On Tue, Jun 25, 2013 at 3:00 PM, Ali Jawad <ali.jawad@splendor.net> wrote:
That is logical, however in that case shouldn't the location table in memory be also missing entries ?
On Tue, Jun 25, 2013 at 3:37 PM, Olle E. Johansson <oej@edvina.net> wrote:
25 jun 2013 kl. 14:34 skrev Ali Jawad <ali.jawad@splendor.net>:
Dear All
I had an issue with my kamailio that non-registered users were able to send calls "I.e. similar to Asterisk Peer mode" . So I did add the following statement
if(!reg_fetch_contacts("location", "$fu", "caller")) { sl_send_reply("403", "Please register first"); exit; }
That did fix the the problem with my registration issues, however as a a side effect the location table is not updated anymore and this broke a few scripts I use to maintain a few aspects of my system.
kamctl ul --show does display all users correctly.
However the database table only contains a few entries.
It all depends on where you added the code, so it's very hard for any on the list to help you. You might have a problem that REGISTER statements get checked here too and you want to avoid that to get them actually to successfully register. EIther add a check if method is not equal REGISTER or that it is equal INVITE depending upon what you want to do.
Regards /Olle
My location settings are :
# ----- 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
Please advice
_______________________________________________ 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
_______________________________________________ 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
-- 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
_______________________________________________ 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
Hi Atle Thanks for the input, however please note that it was working fine until I did insert the few lines above. Having said that I am running Kamailio 3.4 on that particular server. Regards On Tue, Jun 25, 2013 at 4:05 PM, Atle Samuelsen <atle.samuelsen@gmail.com>wrote:
Howdy Ali,
What version of Kamailio and mysql are you running?
If you are running a VERY (yes, VERY) old version.. of both, you might end up in a case, where you will see that the location database will be updated in the beginning (just after you restart your proxy) but not afterwords.
try to restart your proxy, see if a few registrations end up in your database table.. If so ;) I bet the problem is mysql timeouts ;) and you should update both your mysql and your kamailio :)
- Atle
On Tue, Jun 25, 2013 at 3:00 PM, Ali Jawad <ali.jawad@splendor.net> wrote:
That is logical, however in that case shouldn't the location table in memory be also missing entries ?
On Tue, Jun 25, 2013 at 3:37 PM, Olle E. Johansson <oej@edvina.net> wrote:
25 jun 2013 kl. 14:34 skrev Ali Jawad <ali.jawad@splendor.net>:
Dear All
I had an issue with my kamailio that non-registered users were able to send calls "I.e. similar to Asterisk Peer mode" . So I did add the
following
statement
if(!reg_fetch_contacts("location", "$fu", "caller")) { sl_send_reply("403", "Please register first"); exit; }
That did fix the the problem with my registration issues, however as a a side effect the location table is not updated anymore and this broke a few scripts I use to maintain a few aspects of my system.
kamctl ul --show does display all users correctly.
However the database table only contains a few entries.
It all depends on where you added the code, so it's very hard for any on the list to help you. You might have a problem that REGISTER statements get checked here too and you want to avoid that to get them actually to successfully register. EIther add a check if method is not equal REGISTER or that it is equal INVITE depending upon what you want to do.
Regards /Olle
My location settings are :
# ----- 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
Please advice
_______________________________________________ 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
_______________________________________________ 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
-- 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
_______________________________________________ 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
_______________________________________________ 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
-- *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 *
participants (3)
-
Ali Jawad -
Atle Samuelsen -
Olle E. Johansson