[Opensim-users] SQL error or connection string configurationerror
Fleep Tuque
fleep513 at gmail.com
Sun Mar 20 17:59:02 UTC 2011
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 <fleep513 at gmail.com> 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
> 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/20110320/c2c5294e/attachment.html>
More information about the Opensim-users
mailing list