[Opensim-users] User exists in MySQL but ROBUST says user not found
Justin Clark-Casey
jjustincc at googlemail.com
Thu Feb 24 01:04:06 UTC 2011
The "[GRID HANDLER]: Exception System.NullReferenceException: Object reference not set to an instance of an object."
indicates some kind of unexpected failure when the grid service handles a request (possibly the call which asks for
details about the desired login region for the user). I changed the log message to give some more useful information
under Windows (namely, the stack trace).
Since it was short and easy, I also ported this to 0.7-post-fixes.
However, this failure and the login service failure probably stem from a deeper underlying cause, possibly the database.
It's not an issue I've seen before.
On 23/02/11 18:37, Fleep Tuque wrote:
> 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 <mailto: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 <mailto: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 <http://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 <mailto: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 <mailto: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 <mailto:chris.collins at uc.edu>
>
> UC Second Life: http://homepages.uc.edu/secondlife
> OLN Second Life: http://www.oln.org/emerging_technologies/emtech.php
>
>
>
>
>
>
>
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
--
Justin Clark-Casey (justincc)
http://justincc.org/blog
http://twitter.com/justincc
More information about the Opensim-users
mailing list