[Opensim-users] MySQL query and number of agents online
Clive Gould
cliveg at gmail.com
Fri Mar 2 15:20:47 UTC 2012
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
>
>
More information about the Opensim-users
mailing list