Oops message got bounced for being too big, cutting off the tail and trying again..
- Fleep On Sun, Mar 20, 2011 at 1:53 PM, Fleep Tuque <[email protected]> wrote: > I'm having exactly the same problem but with different OS, Opensim, and > MySQL versions: > > Opensim 0.7.0.2 > MySQL 5.1.55 > Windows Server 2008 > > I turned on query logging on MySQL and I see the query coming through even, > but ROBUST console still reports user not found. Worse the problem is > intermittent, user1 may be able to log in no problem and 30 seconds later > user2 can't log in as it says user not found even though the user exists in > the database, MySQL is running, ROBUST and Opensim are running, and I don't > see errors on the console or in any of the log files. It's very > frustrating. > > Here are the steps I took: > > Start up ROBUST.exe > Start up Opensim.exe > > 12:12:01 - Attempt to login with user Fleep Tuque which already exists in > the database. Login successful. > 12:15:48 - Attempt to login with a user that does not exist in the > database "Ringo Moonstone". Login fails. (Wanted to see what a true failure > looked like.) > 12:16:16 - Create user "Ringo Moonstone" through the ROBUST console. > 12:16:46 - Attempt to login with user Ringo Moonstone. Login successful. > 12:17:18 - User Fleep Tuque closes session. (logout) > 12:17:31 - Attempt to login with user Fleep Tuque which already exists. > Login failed. ROBUST console reports "user not found". > 12:18:07 - User Ringo Moonstone closes session. (logout) > 12:18:28 - Attempt to login with user Ring Moonstone which already exists. > Login failed. ROBUST console reports "user not found". > > ROBUST Console output: > > 12:17:18 - [PRESENCE SERVICE]: Session a6b52d94-bc46-4b67-9170-b6fae1773530 > logo > ut > 12:17:18 - [GRID USER SERVICE]: User d2897dae-70e8-4250-bacb-7a81bd07a562 > is off > line > 12:17:31 - [LLOGIN SERVICE]: Login request for Fleep Tuque from > 10.24.146.14 wit > h user agent Imprudence 1.3.0 / Second Life 1.23.5.136262 starting in last > 12:17:31 - [LLOGIN SERVICE]: Login failed, reason: user not found > 12:18:07 - [PRESENCE SERVICE]: Session 7b141115-1b9e-4b91-afcb-403a043f8bcc > logo > ut > 12:18:07 - [GRID USER SERVICE]: User 0b89f808-f828-4fba-bfc5-89fed6353a40 > is off > line > 12:18:28 - [LLOGIN SERVICE]: Login request for Ringo Moonstone from > 10.47.2.11 w > ith user agent Imprudence 1.3.0 / Second Life 1.23.5.136262 starting in > last > 12:18:28 - [LLOGIN SERVICE]: Login failed, reason: user not found > > ROBUST Log file output: > > 2011-03-17 12:17:18,444 DEBUG - > OpenSim.Services.PresenceService.PresenceService [PRESENCE SERVICE]: Session > a6b52d94-bc46-4b67-9170-b6fae1773530 logout > 2011-03-17 12:17:18,459 DEBUG - > OpenSim.Services.UserAccountService.GridUserService [GRID USER SERVICE]: User > d2897dae-70e8-4250-bacb-7a81bd07a562 is offline > 2011-03-17 12:17:31,475 INFO - > OpenSim.Services.LLLoginService.LLLoginService [LLOGIN SERVICE]: Login > request for Fleep Tuque from 10.24.146.14 with user agent Imprudence 1.3.0 / > Second Life 1.23.5.136262 starting in last > 2011-03-17 12:17:31,491 INFO - > OpenSim.Services.LLLoginService.LLLoginService [LLOGIN SERVICE]: Login > failed, reason: user not found > 2011-03-17 12:18:07,866 DEBUG - > OpenSim.Services.PresenceService.PresenceService [PRESENCE SERVICE]: Session > 7b141115-1b9e-4b91-afcb-403a043f8bcc logout > 2011-03-17 12:18:07,866 DEBUG - > OpenSim.Services.UserAccountService.GridUserService [GRID USER SERVICE]: User > 0b89f808-f828-4fba-bfc5-89fed6353a40 is offline > 2011-03-17 12:18:28,616 INFO - > OpenSim.Services.LLLoginService.LLLoginService [LLOGIN SERVICE]: Login > request for Ringo Moonstone from 10.47.2.11 with user agent Imprudence 1.3.0 > / Second Life 1.23.5.136262 starting in last > 2011-03-17 12:18:28,616 INFO - > OpenSim.Services.LLLoginService.LLLoginService [LLOGIN SERVICE]: Login > failed, reason: user not found > 2011-03-17 12:18:37,303 INFO - > OpenSim.Services.LLLoginService.LLLoginService [LLOGIN SERVICE]: Login > request for Ringo Moonstone from 10.47.2.11 with user agent Imprudence 1.3.0 > / Second Life 1.23.5.136262 starting in last > 2011-03-17 12:18:37,303 INFO - > OpenSim.Services.LLLoginService.LLLoginService [LLOGIN SERVICE]: Login > failed, reason: user not found > 2011-03-17 12:24:46,819 DEBUG - OpenSim.Services.GridService.GridService > [GRID SERVICE]: Region 03433f54-9a39-4f6b-a653-0cccc792d7ea deregistered > 2011-03-17 12:24:52,819 INFO - OpenSim.Server.Base.ServicesServerBase > [CONSOLE] Quitting > > > MySQL Query Log output: > > 110317 12:17:18 2 Init DB opensim > 2 Query delete from Presence where `SessionID` = > 'a6b52d94-bc46-4b67-9170-b6fae1773530' > 2 Init DB opensim > 2 Query select * from GridUser where `UserID` = > 'd2897dae-70e8-4250-bacb-7a81bd07a562' > 2 Init DB opensim > 2 Query replace into GridUser > (`UserID`,`Online`,`Logout`,`LastRegionID`,`LastPosition`,`LastLookAt`) > values > ('d2897dae-70e8-4250-bacb-7a81bd07a562','False','1300378638','03433f54-9a39-4f6b-a653-0cccc792d7ea','<130.7828, > 131.314, 25.7627>','<-0.4889376, -0.8723187, 0>') > 110317 12:17:31 2 Init DB opensim > 2 Query select * from UserAccounts where `FirstName` = > 'Fleep' and `LastName` = 'Tuque' > 110317 12:18:07 2 Init DB opensim > 2 Query delete from Presence where `SessionID` = > '7b141115-1b9e-4b91-afcb-403a043f8bcc' > 2 Init DB opensim > 2 Query select * from GridUser where `UserID` = > '0b89f808-f828-4fba-bfc5-89fed6353a40' > 2 Init DB opensim > 2 Query replace into GridUser > (`UserID`,`Online`,`Logout`,`LastRegionID`,`LastPosition`,`LastLookAt`) > values > ('0b89f808-f828-4fba-bfc5-89fed6353a40','False','1300378687','03433f54-9a39-4f6b-a653-0cccc792d7ea','<128.0708, > 128.1095, 26.00385>','<0.651205, 0.7589018, 0>') > 110317 12:18:28 2 Init DB opensim > 2 Query select * from UserAccounts where `FirstName` = > 'Ringo' and `LastName` = 'Moonstone' > 110317 12:18:37 2 Init DB opensim > 2 Query select * from UserAccounts where `FirstName` = > 'Ringo' and `LastName` = 'Moonstone' > 110317 12:24:46 2 Init DB opensim > 2 Query select * from `regions` where uuid = > '03433f54-9a39-4f6b-a653-0cccc792d7ea' > 2 Init DB opensim > 2 Query delete from Presence where > `RegionID`='03433f54-9a39-4f6b-a653-0cccc792d7ea' > 110317 12:24:47 4 Quit > > > I'm totally at a loss at this point.. > > > - 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 > [email protected] > > UC Second Life: http://homepages.uc.edu/secondlife > OLN Second Life: http://www.oln.org/emerging_technologies/emtech.php > > >
_______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
