<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=Big5" http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<p><font face="Times New Roman, Times, serif">Hi,<br>
</font></p>
On 10/07/2010 06:54 AM, Yita Wu wrote:
<blockquote
cite="mid:AANLkTimKVt5Jhiw0wYeEE+VNhmTxD=-y4VZdd6sr1wm-@mail.gmail.com"
type="cite">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></blockquote>
<font face="Times New Roman, Times, serif">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
<a class="moz-txt-link-freetext" href="http://www.opensips.org/html/docs/modules/devel/usrloc.html#id271279">http://www.opensips.org/html/docs/modules/devel/usrloc.html#id271279</a>.<br>
</font>
<pre class="moz-signature" cols="72"><font
face="Times New Roman, Times, serif">--
Anca Vamanu
<a class="moz-txt-link-abbreviated" href="http://www.voice-system.ro">www.voice-system.ro</a></font></pre>
<br>
<font face="Times New Roman, Times, serif"><br>
</font>
<blockquote
cite="mid:AANLkTimKVt5Jhiw0wYeEE+VNhmTxD=-y4VZdd6sr1wm-@mail.gmail.com"
type="cite">(Q2)I am trying to use command "
<meta http-equiv="Content-Type" content="text/html; charset=Big5">
<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>
</blockquote>
<blockquote
cite="mid:AANLkTimKVt5Jhiw0wYeEE+VNhmTxD=-y4VZdd6sr1wm-@mail.gmail.com"
type="cite"><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>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Devel@lists.opensips.org">Devel@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel">http://lists.opensips.org/cgi-bin/mailman/listinfo/devel</a>
</pre>
</blockquote>
</body>
</html>