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

[Fleep Tuque]

Hi Clive, glad you got it figured out!  Thanks for posting the solution to
the list, too, for other standalone operators.  :)

- Chris/Fleep

Chris M. Collins (SL/OS: Fleep Tuque)
Center for Simulations & Virtual Environments Research (UCSIM)
UCIT Instructional & Research Computing
University of Cincinnati
406A Zimmer Hall
315 College Drive
PO BOX 210088
Cincinnati, OH 45221-0088
chris.collins at uc.edu
(513) 556-3018

http://ucsim.uc.edu

On Sat, Mar 3, 2012 at 6:08 AM, Clive Gould <cliveg at gmail.com> wrote:

> 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
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20120303/3f393193/attachment.html>