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 [email protected] (513) 556-3018 http://ucsim.uc.edu On Sat, Mar 3, 2012 at 6:08 AM, Clive Gould <[email protected]> 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 > [email protected] > https://lists.berlios.de/mailman/listinfo/opensim-users >
_______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
