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

[Steven Salter]

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