Besides the database lookup, you can also directly access SER's cache using RPC method *usrloc.show*. You can check its functionality with ser_ctl:<br><br>ser_ctl usrloc show <a href="mailto:sam@mydomain.org">sam@mydomain.org
</a><br><br>Remember that it's more accurate to check SER's cache (it's effectively the source of information) than the "backup" stored in the database...<br><br>hope it helps,<br>samuel.<br><br><br>
<div><span class="gmail_quote">2007/10/10, Jiri Kuthan <<a href="mailto:jiri@iptel.org">jiri@iptel.org</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
yes, set usrloc's database mode to 1. -jiri<br><br>At 03:32 10/10/2007, roayu wrote:<br><br>>Thanks for your reply. I found that it's only update after around 30<br>>seconds. Is there anyway that I can fasten the update on the database?
<br>><br>>Thanks.<br>><br>>Cheers,<br>>Roa Yu<br>><br>>-----Original Message-----<br>>From: SIP [mailto:<a href="mailto:sip@arcdiv.com">sip@arcdiv.com</a>]<br>>Sent: Tuesday, October 09, 2007 9:14 PM
<br>>To: roayu<br>>Cc: <a href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a><br>>Subject: Re: [Serusers] Get RealTime Online Users status<br>><br>>roayu wrote:<br>>><br>>> Hi there!
<br>>><br>>> Can anyone tell me how to get the RealTime Online user status other<br>>> than using command '*serctl ul show*'? Or how can I store the realtime<br>>> online user status to the MySQL db?
<br>>><br>>> Thanks.<br>>><br>>> Cheers,<br>>><br>>> Roa Yu J<br>>><br>>> ------------------------------------------------------------------------<br>>><br>>> _______________________________________________
<br>>> Serusers mailing list<br>>> <a href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org</a><br>>> <a href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers
</a><br>>><br>>The location table in the MySQL database stores what are, in effect,<br>>currently online users. It is, however, only an approximation. When a UA<br>>registers, it sends an expiration time on its registration and that gets
<br>>stored in the location table. If the user disconnects without cancelling<br>>his registration (some UAs send am expire register message to 'log out'<br>>and some don't), then the data may still be in the table until the
<br>>expire time occurs. Realistically, though, you can get a good idea of<br>>currenly online users using the location table and while it may not be<br>>100% accurate, it's close enough for government work, as it were.
<br>><br>>N.<br>>_______________________________________________<br>>Serusers mailing list<br>><a href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org</a><br>><a href="http://lists.iptel.org/mailman/listinfo/serusers">
http://lists.iptel.org/mailman/listinfo/serusers</a><br><br><br><br>--<br>Jiri Kuthan <a href="http://iptel.org/~jiri/">http://iptel.org/~jiri/</a><br><br>_______________________________________________<br>Serusers mailing list
<br><a href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org</a><br><a href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a><br></blockquote></div><br>