[Opensim-users] MySQL query and number of agents online

[Justin Clark-Casey]

For a standalone you could use one of the monitoring options at [1] to obtain the number of root agents (real avatars) 
in a region.  Please be advised that this can occasionally be inaccurate and will count NPCs, unlike the presence table.

Following what Diva said below, you could also make the presence service store it's data in mysql rather than in-memory 
on a standalone.  I think it would be a case of adding the lines

[PresenceService]
     StorageProvider = "OpenSim.Data.MySQL.dll"

to your StandaloneCommon.ini to override the default OpenSim.Data.Null.dll in Standalone.ini

[1] http://opensimulator.org/wiki/Monitoring

On 02/03/12 16:12, Diva Canto wrote:
> The presence information is managed bythe Presence service. The presence service uses different storages depending on
> the configuration. The default grid configuration uses MySql; the default standalone configuration uses in memory
> storage; the diva configuration uses MySql. What this means is that if you are using the default standalone
> configuration you won't see a Presence table in the DB, it's all handled in memory.
>
> On 3/2/2012 7:47 AM, Clive Gould wrote:
>> Not so promising
>>
>> I'm running a standalone and...
>>
>> mysql> select * from GridUser where Online="TRUE";
>>
>> returns 12 records whereas the console says 1 agent connected
>>
>>
>> On Fri, Mar 2, 2012 at 3:38 PM, Steven Salter<ssalter at indiana.edu> wrote:
>>> Ahh, must be because you have 0.7.3. Take a look at the structure of GridUser. That looks promising. I"m downloading
>>> 0.7.3 as I type...
>>>
>>> Steve
>>>
>> _______________________________________________
>> Opensim-users mailing list
>> Opensim-users at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>
>>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>


-- 
Justin Clark-Casey (justincc)
http://justincc.org/blog
http://twitter.com/justincc