I don't know off hand if there is a reason for it being limited in that way. The only way to know for sure is to have the issue in the bug tracker so that it can be added to the queue and addressed one way or the other at some point.
Cheers, On Mon, Jul 6, 2009 at 10:09 PM, Doeko<[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
