[SR-Users] Issue with Location table

[Atle Samuelsen]

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 at 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 at edvina.net> wrote:
>>
>>
>> 25 jun 2013 kl. 14:34 skrev Ali Jawad <ali.jawad at 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 at 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 at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>