Hi Bogdan, Actually we have 2 registrar servers in production environment half of the users are registered with one server and other half on the second server so whenever inbound call from PSTN comes to our SBC, The SBC check the user in location table of both opensips servers and then route call to the server on which user is present. so if I change the db_mode to some other value my SBC routing will be disturbed, as entry persist in location table for sometimes.
Well Thanks for you response I'll use some other way to get the stats of registered users. Regards, Husnain Taseer VoIP Developer On Wed, Jan 13, 2016 at 12:55 PM, Bogdan-Andrei Iancu <[email protected]> wrote: > Hi Husnain, > > The statistics (for usrloc) are computed based on the in-memory (cached) > data. In db_mode 3 (db only), there is nothing cached in memory, so not > statistics. > > if you want statistics, use db_mode 1 or 2 ; mode 1 updates the db table > in realtime, but has a performance penalty ; mode 2 is the most efficient, > but DB has a lag in terms of being updated - in this case, better fetch > data via MI directly from cache - see the "opensipsct ul show" > > Regards, > > Bogdan-Andrei Iancu > OpenSIPS Founder and Developerhttp://www.opensips-solutions.com > > On 12.01.2016 21:01, Husnain Taseer wrote: > > Hello Bogdan, > Yes, I m using db_mode=3 because in case of cache (other db_mode values) > when user was getting un-registered it was not clearing the status of the > user and entry was still present for some time in location table. > > Regards, > Husnain > > On Tue, Jan 12, 2016 at 8:33 PM, Bogdan-Andrei Iancu < > <[email protected]>[email protected]> wrote: > >> Hi Husnain, >> >> Are you using db_mode=3 for usrloc module ? >> >> Regards, >> >> Bogdan-Andrei Iancu >> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com >> >> On 12.01.2016 12:09, Husnain Taseer wrote: >> >> Dear Users, >> >> I am using Server:: OpenSIPS (2.1.1 (x86_64/linux)) as a registrar server >> where more than 20 users are registered and I can see their entries in >> location table. but when I run fifo commands to see the statistics it shows >> me 0 registered users: >> >> >> [root@opensips ]# opensipsctl fifo get_statistics 'usrloc:' >> usrloc:registered_users:: 0 >> usrloc:location-users:: 0 >> usrloc:location-contacts:: 0 >> usrloc:location-expires:: 0 >> >> >> and the output of "opensipsctl monitor" is : >> >> [cycle #: 5; if constant make sure server lives] >> Server:: OpenSIPS (2.1.1 (x86_64/linux)) >> Now:: Tue Jan 12 16:13:14 2016 >> Up since:: Mon Jan 11 20:17:19 2016 >> Up time:: 71755 [sec] >> >> Transaction Statistics: >> tm:UAS_transactions:: 2011 >> tm:UAC_transactions:: 14222 >> tm:inuse_transactions:: 0 >> >> Stateless Server Statistics: >> sl:sent_replies:: 258651 >> sl:sent_err_replies:: 15 >> sl:received_ACKs:: 979 >> >> UsrLoc Stats: >> usrloc:registered_users:: 0 >> usrloc:location-users:: 0 >> usrloc:location-contacts:: 0 >> usrloc:location-expires:: 0 >> >> >> Please advise >> >> >> Regards, >> Husnain Taseer >> VoIP Developer >> >> >> _______________________________________________ >> Users mailing >> [email protected]http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> >> > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
