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

Wed Feb 23 17:02:38 UTC 2011

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/b3b94981/attachment.html>