Hi, No, not submitted as a bug. I also investigated more closely and I have found out the specific cause of the bug. The maximum string length of the "lastname" field in dbo.users (which is for example <[email protected]>) is super limited length-wise, so for example [email protected] would be way too long. Is there any reason for this cap? (i.e. is it a feature instead of a bug?)
On Jul 5, 11:59 pm, Ryan McDougall <[email protected]> wrote: > Hello, > > Has this bug been logged in the tracker so someone can look into it > when they return from vacation? > > http://forge.opensimulator.org/gf/project/modrex/tracker/?action=Trac... > > Cheers, > > > > On Sun, Jul 5, 2009 at 1:29 AM, Doeko<[email protected]> wrote: > > > This bug is database independent. Same bug occurs on mySQL database > > > On Jul 5, 12:02 am, Doeko <[email protected]> wrote: > >> I've figured out why it is erratic. > > >> If you login with usern...@directipaddress FIRST and THEN > >> [email protected] then it works. However if you create a user and > >> start to log in with usern...@domain, the user fails to get into the > >> opensim databases and fails login. > > >> On Jul 4, 6:45 pm, Doeko <[email protected]> wrote: > > >> > I must say this problem has driven me to the edge of my sanity by now, > >> > as it seems pretty random and erratic. The solution also doesn't > >> > always work, but at least it looks like a kind of "solution" which > >> > works at least half the time :) > > >> > The field "lastname" in the opensim database does not accept anything > >> > but the actual IP address. You can simply enter the IP address > >> > everywhere and it will still be able to log in with the recognizeable > >> > URL. Maybe that should be listed somewhere, because I'm sure others > >> > will run into this when trying to setup their own sims. Ideally maybe > >> > someone could make the "lastname" field accept values that are not > >> > strictly the IP address? > > >> > Sometimes this works and othertimes it still doesn't. I haven't really > >> > figured out why it sometimes does work and other times not, but it may > >> > be that I hadn't cleaned up the faulty data properly. > > >> > Regards, > >> > Jules > > >> > On Jul 4, 5:32 pm, Doeko <[email protected]> wrote: > > >> > > I wanted to add that it is definitely not a problem with the domain > >> > > itself. I tested creating a user directly in opensim (without > >> > > rexauthentication) and that worked fine @domainname.com > > >> > > On Jul 4, 5:17 pm, "[email protected]" <[email protected]> > >> > > wrote: > > >> > > > Hi, > > >> > > > I Hope someone knows what the cause of this issue is. When using the > >> > > > bare IP address of the server, everything works quite fine. When I > >> > > > replace all the IP addresses with a more memorable URL then I > >> > > > invariably get the following login fail: > > >> > > > 2009-07-04 08:15:16,463 DEBUG - > >> > > > ModularRex.RexNetwork.RexLogin.RexLoginModule [REXLOGIN]: XMLRPC > >> > > > Client is realXtend 1.20.13.91224, start location is last > >> > > > 2009-07-04 08:15:16,466 INFO - > >> > > > ModularRex.RexNetwork.AuthenticationService [AUTHENTICATIONSERVICE]: > >> > > > SimAuthenticationAccount with account > >> > > > 2009-07-04 08:15:17,274 INFO - > >> > > > ModularRex.RexNetwork.AuthenticationService [AUTHENTICATIONSERVICE]: > >> > > > GetUserByAccount > >> > > > 2009-07-04 08:15:17,783 ERROR - OpenSim.Data.MSSQL.MSSQLUserData > >> > > > System.Data.SqlClient.SqlException: String or binary data would be > >> > > > truncated. > >> > > > The statement has been terminated. > >> > > > at System.Data.SqlClient.SqlConnection.OnError(SqlException > >> > > > exception, Boolean breakConnection) > >> > > > at > >> > > > System.Data.SqlClient.SqlInternalConnection.OnError(SqlException > >> > > > exception, Boolean breakConnection) > >> > > > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning > >> > > > (TdsParserStateObject stateObj) > >> > > > at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, > >> > > > SqlCommand cmdHandler, SqlDataReader dataStream, > >> > > > BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject > >> > > > stateObj) > >> > > > at System.Data.SqlClient.SqlCommand.FinishExecuteReader > >> > > > (SqlDataReader ds, RunBehavior runBehavior, String > >> > > > resetOptionsString) > >> > > > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds > >> > > > (CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean > >> > > > returnStream, Boolean async) > >> > > > at System.Data.SqlClient.SqlCommand.RunExecuteReader > >> > > > (CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean > >> > > > returnStream, String method, DbAsyncResult result) > >> > > > at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery > >> > > > (DbAsyncResult result, String methodName, Boolean sendToPipe) > >> > > > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() > >> > > > at OpenSim.Data.MSSQL.MSSQLUserData.InsertUserRow(UUID uuid, > >> > > > String > >> > > > username, String lastname, String email, String passwordHash, String > >> > > > passwordSalt, UInt64 homeRegion, Single homeLocX, Single homeLocY, > >> > > > Single homeLocZ, Single homeLookAtX, Single homeLookAtY, Single > >> > > > homeLookAtZ, Int32 created, Int32 lastlogin, String inventoryURI, > >> > > > String assetURI, UInt32 canDoMask, UInt32 wantDoMask, String > >> > > > aboutText, String firstText, UUID profileImage, UUID firstImage, UUID > >> > > > webLoginKey, UUID homeRegionID, Int32 godLevel, Int32 userFlags, > >> > > > String customType, UUID partnerID) > >> > > > 2009-07-04 08:15:17,825 INFO - > >> > > > ModularRex.RexNetwork.RexLogin.RexLoginModule [REXLOGIN END]: XMLRPC > >> > > > Login failed, System.NullReferenceException: Object reference not set > >> > > > to an instance of an object. > >> > > > at OpenSim.Framework.Communications.UserManagerBase.CreateAgent > >> > > > (UserProfileData profile, XmlRpcRequest request) > >> > > > at ModularRex.RexNetwork.RexLogin.RexLoginModule.XmlRpcLoginMethod > >> > > > (XmlRpcRequest request) > >> > > > 2009-07-04 08:15:17,827 INFO - > >> > > > ModularRex.RexNetwork.RexLogin.RexLoginModule [REXLOGIN END]: XMLRPC > >> > > > Login failed. Sending back blank XMLRPC response --~--~---------~--~----~------------~-------~--~----~ http://groups.google.com/group/realxtend http://www.realxtend.org -~----------~----~----~----~------~----~------~--~---
