[Opensim-users] User exists in MySQL but ROBUST says user not found

Wed Feb 23 18:37:06 UTC 2011

OK in continuing to try to troubleshoot this, I realized I tried stopping
and starting both the ROBUST and opensim services, but I did NOT try
stopping and restarting the MySQL database service itself.

When I did that, suddenly I could log in again...

So, still don't know what the error message I saw before means:

 10:59:51 - [GRID HANDLER]: Exception System.NullReferenceException: Object
refer
ence not set to an instance of an object.

But it seems as if somehow the ROBUST service lost (?) connection to the
database and .. maybe when it tried to query for the user and got no
response it interpreted as user not found even though the issue actually was
that it no longer had a connection to the database?

I don't know, I'm pretty n00b at all this, but if restarting the MySQL
database resolved the issue then my next question is why did it stop working
in the first place and how do I prevent it from happening again.

Thanks as always,

- Chris/Fleep

Chris M. Collins (SL: Fleep Tuque)
Project Manager, UC Second Life
Second Life Ambassador, Ohio Learning Network
UCit Instructional & Research Computing
University of Cincinnati
406E Zimmer Hall
PO Box 210088
Cincinnati, OH 45221-0088
(513)556-3018
chris.collins at uc.edu

UC Second Life:   http://homepages.uc.edu/secondlife
OLN Second Life: http://www.oln.org/emerging_technologies/emtech.php

On Wed, Feb 23, 2011 at 12:02 PM, Fleep Tuque <fleep513 at gmail.com> wrote:

> Also, in case it's helpful, here's the console output when I successfully
> logged in this morning:
>
> *Successful login from internal IP looks like this on ROBUST:*
>
> 04:38:57 - [LLOGIN SERVICE]: Login request for Fleep Tuque from
> 10.24.146.106 wi
>
> th user agent Imprudence 1.3.0 / Second Life 1.23.5.136262 starting in last
> 04:38:57 - [PASS AUTH]: got ; hashed = ; stored =
> 04:38:57 - [LLOGIN SERVICE]: 0 active gestures
> 04:38:57 - [PRESENCE SERVICE]: LoginAgent
> 3cc87096-b350-4ded-b7b3-26a19884e839 w
> ith session c9112461-9b79-4e5f-b876-b71c70bd4083 and ssession
> 27e0f832-62ce-41b6
> -96f7-70f621d3ef78
> 04:38:57 - [GRID USER SERVICE]: User 3cc87096-b350-4ded-b7b3-26a19884e839
> is onl
> ine
> 04:38:57 - [LLOGIN SERVICE]: FindDestination for start location last
> 04:38:57 - [REMOTE SIMULATION CONNECTOR]: Posted CreateAgent request to
> remote s
> im http://10.23.23.149:9000/agent/3cc87096-b350-4ded-b7b3-26a19884e839/,
> region
> University of Cincinnati, x=2304000 y=2304000
> 04:38:58 - [REMOTE SIMULATION CONNECTOR]: DoCreateChildAgentCall reply was
> {"suc
> cess":true,"your_ip":"10.23.23.148"}
> 04:38:58 - [LLOGIN SERVICE]: Retrieved 0 friends
> 04:38:58 - [LLOGIN]: Library has 19 folders
> 04:38:58 - [LLOGIN SERVICE]: All clear. Sending login response to client.
> 04:38:59 - [AVATAR SERVICE]: SetAvatar for
> 3cc87096-b350-4ded-b7b3-26a19884e839,
> attachs=1
> 04:38:59 - [PRESENCE SERVICE]: ReportAgent with session
> c9112461-9b79-4e5f-b876-
> b71c70bd4083 in region 5985af1b-4223-4a12-ba87-1c3830a44e97
> 04:39:00 - [GRID SERVICE]: region University of Cincinnati has 0 neighours
> 04:39:33 - [PRESENCE SERVICE]: Session c9112461-9b79-4e5f-b876-b71c70bd4083
> logo
> ut
> 04:39:33 - [GRID USER SERVICE]: User 3cc87096-b350-4ded-b7b3-26a19884e839
> is off
> line
>
> *Successful login from internal IP looks like this on OPENSIM:*
>
> 04:38:54 - [LOCAL SIMULATION CONNECTOR]: Found region University of
> Cincinnati t
> o send SendCreateChildAgent
> 04:38:54 - [CONNECTION BEGIN]: Region University of Cincinnati told of
> incoming
> root agent Fleep Tuque 3cc87096-b350-4ded-b7b3-26a19884e839 (circuit code
> 153707
> 9610, teleportflags 128)
> 04:38:54 - [CONNECTION BEGIN]: Region University of Cincinnati
> authenticated and
> authorized incoming root agent Fleep Tuque
> 3cc87096-b350-4ded-b7b3-26a19884e839
> (circuit code 1537079610)
> 04:38:54 - [CAPS]: Registered seed capability
> /CAPS/a0b03555-745c-4b59-9100-229c
> 526c32f50000/ for 3cc87096-b350-4ded-b7b3-26a19884e839
> 04:38:54 - [EVENTQUEUE]: Adding new queue for agent
> 3cc87096-b350-4ded-b7b3-26a1
> 9884e839 in region University of Cincinnati
> 04:38:54 - [OBJECTADD]: /CAPS/OA/9d6729c7-c198-4a4a-868b-ae80926a36fb/
> 04:38:54 - [GETTEXTURE]: /CAPS/19bff37d-59e8-4176-b50d-17f1bc0eea6f
> 04:38:55 - [CAPS]: Seed Caps Request in region: University of Cincinnati
> 04:38:55 - [SCENE]: Incoming client Fleep Tuque in region University of
> Cincinna
> ti via regular login. Client IP verification not performed.
> 04:38:56 - [LLUDPSERVER]: Handling UseCircuitCode packet from
> 10.24.146.106:5423
> 9
> 04:38:56 - [SCENE]: Adding new agent Fleep Tuque to scene University of
> Cincinna
> ti
> 04:38:56 - [ACCOUNTS CONNECTOR]: GetUserAccount
> 3cc87096-b350-4ded-b7b3-26a19884
> e839
> 04:38:56 - [USER CACHE]: cached user 3cc87096-b350-4ded-b7b3-26a19884e839
> 04:38:56 - [ATTACHMENTS MODULE]: Rezzing single attachment from item
> 2c3a10fc-a8
> 82-45a3-8a14-2332bc96edf9 for Fleep Tuque
> 04:38:56 - [XINVENTORY CONNECTOR]: GetItem
> 2c3a10fc-a882-45a3-8a14-2332bc96edf9
> 04:38:56 - [XINVENTORY CONNECTOR]: GetItem
> 2c3a10fc-a882-45a3-8a14-2332bc96edf9
> 04:38:56 - [SCENE]: Upgrading child to root agent for Fleep Tuque in
> University
> of Cincinnati
> 04:38:56 - [APPEARANCE]: UpdateDatabase
> 04:38:56 - [PRESENCE DETECTOR]: Detected root presence
> 3cc87096-b350-4ded-b7b3-2
> 6a19884e839 in University of Cincinnati
> 04:38:57 - [ACTIVITY DETECTOR]: Detected root presence
> 3cc87096-b350-4ded-b7b3-2
> 6a19884e839 in University of Cincinnati
> 04:38:57 - [ATTACHMENTS MODULE]: Updating inventory of Fleep Tuque to show
> attac
> hment of Test Object 1 (item ID 2c3a10fc-a882-45a3-8a14-2332bc96edf9)
> 04:38:57 - [XINVENTORY CONNECTOR]: GetItem
> 2c3a10fc-a882-45a3-8a14-2332bc96edf9
> 04:38:57 - [WORLD MAP]: Starting remote MapItem request thread
> 04:38:57 - [ATTACHMENT]: Rezzed attachment in point 2 from item
> 2c3a10fc-a882-45
> a3-8a14-2332bc96edf9 and asset 00000000-0000-0000-0000-000000000000
> (a907aee9-25
> 7f-4b47-a11e-ed6f054fe3c1)
> 04:38:57 - [SCENE]: Received request for wearables of Fleep Tuque
> 04:38:58 - [PHYSICS]: trying to change capsule size, but the following ODE
> data
> is missing - Shell Body Amotor
> 04:38:58 - [XINVENTORY CONNECTOR]: GetItem
> 2c3a10fc-a882-45a3-8a14-2332bc96edf9
> 04:38:58 - [WATCHDOG]: Started tracking thread "MapItemRequestThread" (ID
> 27)
> 04:38:58 - [CAPS]: UploadBakedTexture Request in region: University of
> Cincinnat
> i
> 04:38:58 - [CAPS]: Received baked texture
> aff25517-16a9-47da-b11d-cacb4e0916b6
> 04:38:59 - [CAPS]: UploadBakedTexture Request in region: University of
> Cincinnat
> i
> 04:38:59 - [CAPS]: UploadBakedTexture Request in region: University of
> Cincinnat
> i
> 04:38:59 - [CAPS]: UploadBakedTexture Request in region: University of
> Cincinnat
> i
> 04:39:00 - [CAPS]: UploadBakedTexture Request in region: University of
> Cincinnat
> i
> 04:39:00 - [CAPS]: Received baked texture
> 532db0d5-53f4-4635-b6cd-b9d90b776d76
> 04:39:00 - [CAPS]: Received baked texture
> 9c5ba2b3-019e-4d3b-b413-2b0ff50b2268
> 04:39:00 - [CAPS]: Received baked texture
> 7e7d35d1-3280-41f3-889b-ce6811f1d647
> 04:39:01 - [CAPS]: UploadBakedTexture Request in region: University of
> Cincinnat
> i
> 04:39:01 - [CAPS]: Received baked texture
> 2d9e9051-80e5-4d3b-9452-6a318d6ffc18
> 04:39:01 - [CAPS]: Received baked texture
> b7035f7b-6cf8-4da1-882b-bac89d391648
> 04:39:01 - [CAPS]: UploadBakedTexture Request in region: University of
> Cincinnat
> i
> 04:39:01 - [CAPS]: UploadBakedTexture Request in region: University of
> Cincinnat
> i
> 04:39:02 - [CAPS]: Received baked texture
> 9f27db59-f8bc-4bc4-9017-b2ea900df6b1
> 04:39:02 - [CAPS]: Received baked texture
> b44ae4f1-a839-4086-af02-eecb5004a9f5
> 04:39:30 - [CLIENT]: Got a logout request for Fleep Tuque in University of
> Cinci
> nnati
> 04:39:30 - [CLIENT]: Close has been called for Fleep Tuque attached to
> scene Uni
> versity of Cincinnati
> 04:39:30 - [PRESENCE DETECTOR]: Detected client logout
> 3cc87096-b350-4ded-b7b3-2
> 6a19884e839 in University of Cincinnati
> 04:39:30 - [ACTIVITY DETECTOR]: Detected client logout
> 3cc87096-b350-4ded-b7b3-2
> 6a19884e839 in University of Cincinnati
> 04:39:30 - [SCENE]: Removing root agent
> 3cc87096-b350-4ded-b7b3-26a19884e839 fro
> m region University of Cincinnati
> 04:39:30 - [EVENTQUEUE]: Closed client 3cc87096-b350-4ded-b7b3-26a19884e839
> in r
> egion University of Cincinnati
>
>
> As far as I know nothing changed between then and my next login attempt a
> few hours later when ROBUST reported:
>
> 10:59:51 - [GRID HANDLER]: Exception System.NullReferenceException: Object
> refer
> ence not set to an instance of an object.
> 11:01:33 - [LLOGIN SERVICE]: Login request for Fleep Tuque from
> 10.24.146.106 wi
> th user agent Imprudence 1.3.0  / Second Life 1.23.5.136262 starting in
> last
> 11:01:33 - [LLOGIN SERVICE]: Login failed, reason: user not found
>
> Thanks again for any thoughts..
>
> - Chris/Fleep
>
>
> Chris M. Collins (SL: Fleep Tuque)
> Project Manager, UC Second Life
> Second Life Ambassador, Ohio Learning Network
> UCit Instructional & Research Computing
> University of Cincinnati
> 406E Zimmer Hall
> PO Box 210088
> Cincinnati, OH 45221-0088
> (513)556-3018
> chris.collins at uc.edu
>
> UC Second Life:   http://homepages.uc.edu/secondlife
> OLN Second Life: http://www.oln.org/emerging_technologies/emtech.php
>
>
>
> On Wed, Feb 23, 2011 at 11:52 AM, Fleep Tuque <fleep513 at gmail.com> wrote:
>
>> Hi all,
>>
>> I'm attempting to get 0.7.0.2 running in grid mode on our campus Win2008
>> servers and I can't figure out for the life of me what's wrong.
>>
>> I've got FleepGrid running 0.7.0.2 on WinXP in grid mode at home, the only
>> other difference is that FleepGrid is all on a single physical machine, and
>> the campus grid is running on two separate virtual machines.  This is the
>> first time I've tried setting up a grid where the grid services are on a
>> different (virtual) machine than the simulators.  At the moment, I am just
>> trying to get everything working properly on the university's internal
>> network.
>>
>> This morning when I first installed everything, it seemed to go fine.  I
>> successfully created a user "Fleep Tuque" through ROBUST console.  I added
>> the first region "University of Cincinnati" to the region.ini file.  I
>> logged in.  All seemed well.  I rezzed a prim, stored in inventory, attached
>> to head to test attachment points.  Still good, I see everything coming
>> through on the console.  I upload an OAR file with our campus build in
>> progress, still all good - everything seems to load properly, it looks right
>> in-world.  I'm thinking yay, all good at least on the internal network.
>>
>> I go away for a few hours.  Come back, create some new accounts on the
>> ROBUST console to get my staff all set up, and then try to login myself and
>> get this on the ROBUST console:
>>
>> 10:59:51 - [GRID HANDLER]: Exception System.NullReferenceException: Object
>> refer
>> ence not set to an instance of an object.
>> 11:01:33 - [LLOGIN SERVICE]: Login request for Fleep Tuque from
>> 10.24.146.106 wi
>> th user agent Imprudence 1.3.0  / Second Life 1.23.5.136262 starting in
>> last
>> 11:01:33 - [LLOGIN SERVICE]: Login failed, reason: user not found
>>
>> Things I've tried so far:
>>
>> 1.  Shutting down opensim and ROBUST and restarting.  No love.
>>
>> 2.  Double checking the database connection string in PRIM STORAGE section
>> opensim.ini
>>
>> storage_plugin="OpenSim.Data.MySQL.dll"
>>     storage_connection_string="Data
>> Source=10.23.23.148;Database=opensim;User ID=opensim;Password=MYPASSWORD;"
>>
>> 3.  Changing the URLs in gridcommon.ini to IP addresses instead of
>> FQDN (one example, they all say the same thing):
>>
>> WAS
>>
>> [UserAccountService]
>>     ;
>>     ; change this to your grid-wide user accounts server
>>     ;
>>     UserAccountServerURI = "http://ucsim.uc.edu:8003"
>>
>> NOW
>>
>> [UserAccountService]
>>     ;
>>     ; change this to your grid-wide user accounts server
>>     ;
>>     UserAccountServerURI = "http://10.23.23.148:8003"  <--- Machine where
>> ROBUST and MySQL are running
>>
>>
>> Still no luck.  So my questions are:
>>
>> 1.  What does this error mean:  11:24:24 - [GRID HANDLER]: Exception
>> System.NullReferenceException: Object refer
>> ence not set to an instance of an object.
>>
>> 2.  Why is ROBUST not seeing that the user exists in the database?
>>
>> 3.  Why was I successfully able to login initially but not now?  What
>> changed?  (That is, I'm pretty sure I didn't change anything between my last
>> successful login and my first unsuccessful login.)
>>
>>
>> Any help much appreciated!
>>
>> Sincerely,
>>
>> - Chris/Fleep
>>
>>
>>
>> Chris M. Collins (SL: Fleep Tuque)
>> Project Manager, UC Second Life
>> Second Life Ambassador, Ohio Learning Network
>> UCit Instructional & Research Computing
>> University of Cincinnati
>> 406E Zimmer Hall
>> PO Box 210088
>> Cincinnati, OH 45221-0088
>> (513)556-3018
>> chris.collins at uc.edu
>>
>> UC Second Life:   http://homepages.uc.edu/secondlife
>> OLN Second Life: http://www.oln.org/emerging_technologies/emtech.php
>>
>>
>>
>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20110223/8ede13ed/attachment.html>