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

[Fleep Tuque]

Ahh yeah I haven't installed 0.7.3 yet, planning on giving it a whirl this
weekend..  Sorry for the confusion!

- 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:38 AM, 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
>
> On Mar 2, 2012, at 10:20 AM, Clive Gould wrote:
>
> > mysql> use opensim
> > Reading table information for completion of table and column names
> > You can turn off this feature to get a quicker startup with -A
> >
> > Database changed
> > mysql> show tables;
> >
> > +-------------------+
> > | Tables_in_opensim |
> > +-------------------+
> > | Avatars           |
> > | Friends           |
> > | GridUser          |
> > | UserAccounts      |
> > | assets            |
> > | auth              |
> > | estate_groups     |
> > | estate_managers   |
> > | estate_map        |
> > | estate_settings   |
> > | estate_users      |
> > | estateban         |
> > | inventoryfolders  |
> > | inventoryitems    |
> > | land              |
> > | landaccesslist    |
> > | migrations        |
> > | primitems         |
> > | prims             |
> > | primshapes        |
> > | regionban         |
> > | regions           |
> > | regionsettings    |
> > | regionwindlight   |
> > | spawn_points      |
> > | terrain           |
> > | tokens            |
> > +-------------------+
> > 27 rows in set (0.00 sec)
> >
> > 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
> >
> > Maybe because this is 0.7.3 ??
> >
> > Thanks
> >
> > Clive
> >
> >
> > On Fri, Mar 2, 2012 at 3:11 PM, Fleep Tuque <fleep513 at gmail.com> wrote:
> >> 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
> >>
> >>
> > _______________________________________________
> > 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/e4088d5c/attachment.html>