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

[Fleep Tuque]

The same query worked for me, did you name your database something other
than opensim?

- 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 Fri, Mar 2, 2012 at 10:08 AM, Clive Gould <cliveg at gmail.com> wrote:

> Sorry didn't work for me - am I being dense?
>
> useraccounts was UserAccounts but...
>
> mysql> select  a.firstname, a.lastname from UserAccounts a, presence b
> where a.principalid = b.userid;
> ERROR 1146 (42S02): Table 'opensim.presence' doesn't exist
>
>
> On Fri, Mar 2, 2012 at 2:05 PM, Steven Salter <ssalter at indiana.edu> wrote:
> > This seemed to work for me:
> >
> > select  a.firstname, a.lastname from useraccounts a, presence b where
> a.principalid = b.userid
> >
> >
> > Steve
> >
> > On Mar 2, 2012, at 8:40 AM, Clive Gould wrote:
> >
> >> Hi
> >>
> >> Any idea what SQL query I need to use to find out how many users are
> logged in?
> >>
> >> I've tried the query on the page
> >> http://opensimulator.org/wiki/Useful_Queries and the table
> >> opensim.agents no longer exists in the database schema
> >>
> >> i.e. Count the number of users presently logged in (same issues as
> >> listing online users, above):
> >> SELECT count(UUID) AS 'Users Online' FROM opensim.agents WHERE
> >> agentonline = '1';
> >>
> >> I've looked at the Online=TRUE in the opensim.GridUser table and this
> >> returns 21, whereas the console reports 9 agents online
> >>
> >> Any suggestions most welcome
> >>
> >> Thanks
> >>
> >> Clive
> >>
> >> P.S I've just freed up some memory on our server and upgraded to 0.7.3
> >> and so far nothing has gone wrong
> >> _______________________________________________
> >> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20120302/6f3972d9/attachment.html>