Oops message got bounced for being too big, cutting off the tail and trying again..<div><br></div><div>- Fleep<br><br><div class="gmail_quote">On Sun, Mar 20, 2011 at 1:53 PM, Fleep Tuque <span dir="ltr"><<a href="mailto:fleep513@gmail.com">fleep513@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">I'm having exactly the same problem but with different OS, Opensim, and MySQL versions: <div><br></div><div>Opensim 0.7.0.2</div>
<div>MySQL 5.1.55</div><div>Windows Server 2008</div><div><br></div><div>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.</div>
<div><br></div><div>Here are the steps I took:</div><div><br></div><div><span style="border-collapse:collapse"><div style="font-family:arial, sans-serif;font-size:13px">Start up ROBUST.exe</div>
<div style="font-family:arial, sans-serif;font-size:13px"><font face="arial, helvetica, sans-serif"><span style="line-height:19px">Start up Opensim.exe</span></font></div><div style="font-family:arial, sans-serif;font-size:13px">
<font face="arial, helvetica, sans-serif"><span style="line-height:19px"><br><span style="font-size:13px">12:12:01 - </span>Attempt to login with user Fleep Tuque which already exists in the database. Login successful.</span></font><br>
<span style="font-family:arial, helvetica, sans-serif;line-height:19px"><span style="font-size:13px">12:15:48 - </span>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.)</span></div>
<div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px"><span style="font-size:13px">12:16:16 - </span>Create user "Ringo Moonstone" through the ROBUST console.</span></div>
<div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px"><span style="font-size:13px">12:16:46 - </span>Attempt to login with user Ringo Moonstone. Login successful.</span></div>
<div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px"><span style="font-size:13px">12:17:18 - </span>User Fleep Tuque closes session. (logout)</span></div>
<div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px"><span style="font-size:13px">12:17:31 - </span>Attempt to login with user Fleep Tuque which already exists. Login failed. ROBUST console reports "user not found".</span></div>
<div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px"><span style="font-size:13px">12:18:07 - </span>User Ringo Moonstone closes session. (logout)</span></div>
<div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px"><span style="font-size:13px">12:18:28 - </span>Attempt to login with user Ring Moonstone which already exists. Login failed. ROBUST console reports "user not found".</span></div>
<div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px"><br></span></div><div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px">ROBUST Console output:</span></div>
<div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px"><br></span></div><div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px"><span style="border-collapse:separate"><span style="background-color:rgb(255, 255, 255)">12:17:18 - [PRESENCE SERVICE]: Session a6b52d94-bc46-4b67-9170-b6fae1773530 logo<br>
ut<br>12:17:18 - [GRID USER SERVICE]: User d2897dae-70e8-4250-bacb-7a81bd07a562 is off<br>line<br>12:17:31 - [LLOGIN SERVICE]: Login request for Fleep Tuque from 10.24.146.14 wit<br>h user agent Imprudence 1.3.0 / Second Life 1.23.5.136262 starting in last<br>
12:17:31 - [LLOGIN SERVICE]: Login failed, reason: user not found<br>12:18:07 - [PRESENCE SERVICE]: Session 7b141115-1b9e-4b91-afcb-403a043f8bcc logo<br>ut<br>12:18:07 - [GRID USER SERVICE]: User 0b89f808-f828-4fba-bfc5-89fed6353a40 is off<br>
line<br>12:18:28 - [LLOGIN SERVICE]: Login request for Ringo Moonstone from 10.47.2.11 w<br>ith user agent Imprudence 1.3.0 / Second Life 1.23.5.136262 starting in last</span><br>12:18:28 - [LLOGIN SERVICE]: Login failed, reason: user not found</span></span></div>
<div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px"><span style="border-collapse:separate"><br></span></span></div>
<div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px"><span style="border-collapse:separate">ROBUST Log file output:</span></span></div>
<div style="font-family:arial, sans-serif;font-size:13px"><span style="font-family:arial, helvetica, sans-serif;line-height:19px"><span style="border-collapse:separate"><br></span></span></div>
<div><span style="line-height:19px"><span style="border-collapse:separate"><span style="line-height:normal"><pre style="word-wrap:break-word;white-space:pre-wrap;font-family:'Times New Roman';font-size:medium">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</pre><pre style="word-wrap:break-word;white-space:pre-wrap;font-family:'Times New Roman';font-size:medium"><br></pre>
<pre style="word-wrap:break-word;white-space:pre-wrap;font-family:'Times New Roman';font-size:medium">MySQL Query Log output:</pre><pre style="word-wrap:break-word"><pre style="word-wrap:break-word;white-space:pre-wrap;font-family:'Times New Roman';font-size:medium">
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 </pre><pre style="word-wrap:break-word;white-space:pre-wrap;font-family:'Times New Roman';font-size:medium"><br></pre><pre style="word-wrap:break-word;white-space:pre-wrap"><font face="arial, helvetica, sans-serif">I'm totally at a loss at this point..</font></pre>
<pre style="word-wrap:break-word;white-space:pre-wrap"><font face="arial, helvetica, sans-serif"><br>
</font></pre><pre style="word-wrap:break-word;white-space:pre-wrap"><font face="arial, helvetica, sans-serif">- Chris/Fleep</font></pre><pre style="word-wrap:break-word;white-space:pre-wrap"><font face="arial, helvetica, sans-serif"><br>
</font></pre><pre style="word-wrap:break-word"><span style="white-space:pre-wrap"><font face="arial, helvetica, sans-serif">Chris M. Collins (SL: Fleep Tuque)
</font></span><span style="font-family:arial, helvetica, sans-serif;white-space:normal">Project Manager, UC Second Life <br></span><span style="font-family:arial, helvetica, sans-serif;white-space:normal">Second Life Ambassador, Ohio Learning Network <br>
</span><span style="font-family:arial, helvetica, sans-serif;white-space:normal">UCit Instructional & Research Computing<br></span><span style="font-family:arial, helvetica, sans-serif;white-space:normal">University of Cincinnati <br>
</span><span style="font-family:arial, helvetica, sans-serif;white-space:normal">406E Zimmer Hall<br></span><span style="font-family:arial, helvetica, sans-serif;white-space:normal">PO Box 210088<br>
</span><span style="font-family:arial, helvetica, sans-serif;white-space:normal">Cincinnati, OH 45221-0088<br></span><span style="font-family:arial, helvetica, sans-serif;white-space:normal"><a href="tel:%28513%29556-3018" target="_blank">(513)556-3018</a><br>
</span><span style="font-family:arial, helvetica, sans-serif;white-space:normal"><a href="mailto:chris.collins@uc.edu" target="_blank">chris.collins@uc.edu</a></span></pre><pre style="word-wrap:break-word"><span style="font-family:arial, helvetica, sans-serif;white-space:normal">UC Second Life: <a href="http://homepages.uc.edu/secondlife" target="_blank">http://homepages.uc.edu/secondlife</a><br>
</span><span style="font-family:arial, helvetica, sans-serif;white-space:normal">OLN Second Life: <a href="http://www.oln.org/emerging_technologies/emtech.php" target="_blank">http://www.oln.org/emerging_technologies/emtech.php</a></span></pre>
<div><div></div><div class="h5">
<pre style="word-wrap:break-word"><font class="Apple-style-span" face="arial"><span class="Apple-style-span" style="white-space: normal;"><br></span></font></pre></div></div></pre></span></span></span></div></span></div>
</blockquote></div></div>