MantisBT - opensim
View Issue Details
0008257opensim[GRID] Other Servicepublic2017-10-25 15:562019-02-06 11:28
mark.shadowblade 
UbitUmarov 
highmajoralways
closedfixed 
Server 20160.9.0release
0.9.0 
master (dev code) 
Grid (1 Region per Sim)
ubODE
.NET / Windows64
None
Firestorm, Singularity
0008257: Error generating login response
2017-10-25 18:43:36,160 WARN (10) - OpenSim.Services.LLLoginService.LLLoginService [LLOGIN SERVICE]: Exception processing login for Damien Shadowblade: MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'UUID' in 'where clause'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at OpenSim.Data.MySQL.MySqlAuthenticationData.Get(UUID principalID)
   at OpenSim.Services.AuthenticationService.PasswordAuthenticationService.Authenticate(UUID principalID, String password, Int32 lifetime, UUID& realID)
   at OpenSim.Services.LLLoginService.LLLoginService.Login(String firstName, String lastName, String passwd, String startLocation, UUID scopeID, String clientVersion, String channel, String mac, String id0, IPEndPoint clientIP, Boolean LibOMVclient) at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at OpenSim.Data.MySQL.MySqlAuthenticationData.Get(UUID principalID)
   at OpenSim.Services.AuthenticationService.PasswordAuthenticationService.Authenticate(UUID principalID, String password, Int32 lifetime, UUID& realID)
   at OpenSim.Services.LLLoginService.LLLoginService.Login(String firstName, String lastName, String passwd, String startLocation, UUID scopeID, String clientVersion, String channel, String mac, String id0, IPEndPoint clientIP, Boolean LibOMVclient)
I've changed my password, tried using different viewers to login, and created a new account and this issue is still ongoing.
No tags attached.
Issue History
2017-10-25 15:56mark.shadowbladeNew Issue
2017-10-25 17:06UbitUmarovNote Added: 0032372
2017-10-25 17:10mark.shadowbladeNote Added: 0032373
2018-03-19 14:33GamaTotchi YoshikawaNote Added: 0032593
2018-03-20 03:11UbitUmarovNote Added: 0032594
2018-03-20 04:46aiaustinNote Added: 0032595
2018-03-20 05:49mewtwo0641Note Added: 0032596
2018-03-20 09:39UbitUmarovNote Added: 0032597
2018-03-20 09:42aiaustinNote Edited: 0032597bug_revision_view_page.php?bugnote_id=32597#r6566
2018-03-20 14:20GamaTotchi YoshikawaNote Added: 0032598
2018-03-20 14:38UbitUmarovNote Added: 0032599
2018-08-24 12:53Fly-Man-Statusnew => resolved
2018-08-24 12:53Fly-Man-Fixed in Version => master (dev code)
2018-08-24 12:53Fly-Man-Resolutionopen => fixed
2018-08-24 12:53Fly-Man-Assigned To => UbitUmarov
2019-02-06 11:28BillBlightNote Added: 0034380
2019-02-06 11:28BillBlightStatusresolved => closed

Notes
(0032372)
UbitUmarov   
2017-10-25 17:06   
please check robust databases configuration
(0032373)
mark.shadowblade   
2017-10-25 17:10   
It's all as it should be the database, username and password are all matching what's in the database.
(0032593)
GamaTotchi Yoshikawa   
2018-03-19 14:33   
running into the same error when enabling this in Robust.ini:

[AuthenticationService]
    ; for the server connector
    LocalServiceModule = "OpenSim.Services.AuthenticationService.dll:PasswordAuthenticationService"
    Realm = "UserAccounts"

when commenting out:
[AuthenticationService]
    ...
    ;Realm = "UserAccounts"

everything works fine
(0032594)
UbitUmarov   
2018-03-20 03:11   
Yes, that should be ; Realm = "auth"
fixed on master
(0032595)
aiaustin   
2018-03-20 04:46   
I note that all my tables on (Windows) MySQL are lower case... e.g. "useraccounts". The commit changes the case to "UserAccounts".

Just checking. It may make no difference on MySQL and perhaps it is for compatibility for other DB choices?
(0032596)
mewtwo0641   
2018-03-20 05:49   
@aiaustin - If I recall correctly, table names are not case-sensitive on Windows MySQL but they are on Linux installs. I am guessing that this change will make no difference in your case since you specified that you're using Windows but it might on Linux installs of OpenSim although I'm not entirely sure.
(0032597)
UbitUmarov   
2018-03-20 09:39   
(edited on: 2018-03-20 09:42)
I made that coherent with source code

(0032598)
GamaTotchi Yoshikawa   
2018-03-20 14:20   
@mewtwo0641 yes, it's case sensitive (at least on my side, running it all on linux), the table create by OS on my side is spelled (case sensitive) UserAccounts

@UbitUmarov with Realm = "auth" it's working well, thanks a lot!
(0032599)
UbitUmarov   
2018-03-20 14:38   
you can keep those 2 commented, they are set to the defaults by the code, the options are only there if someone renames the tables for any reason...
(0034380)
BillBlight   
2019-02-06 11:28   
Marked as Resolved but never closed, can be reopened if needed.