Dear All,<br><br>When User use sip client login in to openSIPS server.<br>The "location" table will create a record to save the user login information.<br>But the frequency of updated table is very slow (about once / one minute).<br>
(Q1)How to make the "location" table updated information of "login in" <span class="dct-tt">immediately ?<br><br></span>(Q2)I am trying to use command "<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 12"><meta name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CKENNET%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CDOCUME%7E1%5CKENNET%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CDOCUME%7E1%5CKENNET%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>
<!--
/* Font Definitions */
@font-face
{font-family:新細明體;
panose-1:2 2 3 0 0 0 0 0 0 0;
mso-font-alt:PMingLiU;
mso-font-charset:136;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:3 135135232 22 0 1048577 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:1;
mso-generic-font-family:roman;
mso-font-format:other;
mso-font-pitch:variable;
mso-font-signature:0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-1610611985 1073750139 0 0 159 0;}
@font-face
{font-family:"\@新細明體";
panose-1:2 2 3 0 0 0 0 0 0 0;
mso-font-charset:136;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:3 135135232 22 0 1048577 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-font-family:新細明體;
mso-bidi-font-family:新細明體;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
mso-ascii-font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";
mso-font-kerning:0pt;}
/* Page Definitions */
@page
{mso-page-border-surround-header:no;
mso-page-border-surround-footer:no;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style><span lang="EN-US">opensipsctl online</span>" to query "user login information" immediately.<br> but when over 50000 user login at the same time, the command seems to be crash.<br> Does the command "opensipsctr online" have any restrictions on use? <br>
<br>(Q3) could the command "opensipsctl online" limit the range of query "online users" ?<br> example : opensipsctl online 1 to 1000 ==> that to query only 1000 online user.<br><br><br><br>
※table schema :<br><br>CREATE TABLE `location` (<br> `id` int(10) unsigned NOT NULL auto_increment,<br> `username` char(64) NOT NULL default '',<br> `domain` char(64) default NULL,<br> `contact` char(255) NOT NULL default '',<br>
`received` char(128) default NULL,<br> `path` char(128) default NULL,<br> `expires` datetime NOT NULL default '2020-05-28 21:32:15',<br> `q` float(10,2) NOT NULL default '1.00',<br> `callid` char(255) NOT NULL default 'Default-Call-ID',<br>
`cseq` int(11) NOT NULL default '13',<br> `last_modified` datetime NOT NULL default '1900-01-01 00:00:01',<br> `flags` int(11) NOT NULL default '0',<br> `cflags` int(11) NOT NULL default '0',<br>
`user_agent` char(255) NOT NULL default '',<br> `socket` char(64) default NULL,<br> `methods` int(11) default NULL,<br> PRIMARY KEY (`id`),<br> KEY `account_contact_idx` (`username`,`domain`,`contact`)<br>) ENGINE=MyISAM AUTO_INCREMENT=76612 DEFAULT CHARSET=latin1<br>
<br><br>Thanks!!<br>Best regards,<br><br>YITA.<br><br><br>