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

[Clive Gould]

After a number of postings to the OpenSim forums (thanks especially to
Diva and Justin) the fix was to get the standalone simulator to create
and use a presence table, which could be queried.

This was achieved by adding the following three lines to
StandaloneCommon.ini and restarting the simulator:

[PresenceService]
StorageProvider = "OpenSim.Data.MySQL.dll"
ConnectionString = "Data Source=localhost;Database=opensim;User
ID=xxxx;password=yyyy;"

The following SQL query then successfully returned the names of users
currently online:

select a.firstname, a.lastname from opensim.UserAccounts a,
opensim.Presence b where a.principalid = b.userid