[SR-Users] Issue with Location table

[Ali Jawad]

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 at 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 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
> >
>
> _______________________________________________
> 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

*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20130625/b512d622/attachment.html>