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