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

[Yita Wu]

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
?

(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/devel/attachments/20101007/4d481638/attachment-0001.htm