[OpenSIPS-Devel] how to get user that login in opsnSIPS ?

[Anca Vamanu]

Hi,

On 10/07/2010 06:54 AM, Yita Wu wrote:
> Dear All,
>
> When User use sip client login in to openSIPS server.
> The "location" table will create a record to save the user login
> information.
> But the frequency of updated table is very slow (about once / one minute).
> (Q1)How to make the "location" table updated information of "login in"
> immediately ?
>
With db_mode parameter in usrloc module you can control the way the data
is written in database, for what you want you have to set it to 1
http://www.opensips.org/html/docs/modules/devel/usrloc.html#id271279.

-- 
Anca Vamanu
www.voice-system.ro



> (Q2)I am trying to use command " opensipsctl online" to query "user
> login information" immediately.
> but when over 50000 user login at the same time, the command seems to
> be crash.
> Does the command "opensipsctr online" have any restrictions on use?
>
> (Q3) could the command "opensipsctl online" limit the range of query
> "online users" ?
> example : opensipsctl online 1 to 1000 ==> that to query only 1000
> online user.
>
>
>
> ※table schema :
>
> CREATE TABLE `location` (
> `id` int(10) unsigned NOT NULL auto_increment,
> `username` char(64) NOT NULL default '',
> `domain` char(64) default NULL,
> `contact` char(255) NOT NULL default '',
> `received` char(128) default NULL,
> `path` char(128) default NULL,
> `expires` datetime NOT NULL default '2020-05-28 21:32:15',
> `q` float(10,2) NOT NULL default '1.00',
> `callid` char(255) NOT NULL default 'Default-Call-ID',
> `cseq` int(11) NOT NULL default '13',
> `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',
> `flags` int(11) NOT NULL default '0',
> `cflags` int(11) NOT NULL default '0',
> `user_agent` char(255) NOT NULL default '',
> `socket` char(64) default NULL,
> `methods` int(11) default NULL,
> PRIMARY KEY (`id`),
> KEY `account_contact_idx` (`username`,`domain`,`contact`)
> ) ENGINE=MyISAM AUTO_INCREMENT=76612 DEFAULT CHARSET=latin1
>
>
> Thanks!!
> Best regards,
>
> YITA.
>
>
>
> _______________________________________________
> Devel mailing list
> Devel at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/devel/attachments/20101007/007f5503/attachment.htm