Change font size
It is currently Thu Apr 26, 2018 2:21 am

Forum rules


{L_IMAGE}
. please keep questions related to an OpenSimulator and OSgrid nature.



Post a new topicPost a reply Page 1 of 1   [ 7 posts ]
Author Message
 Post subject: MySQL Date Problem when logging in.
PostPosted: Mon Oct 16, 2017 9:09 pm 

Joined: Fri Oct 13, 2017 2:18 pm
Posts: 16
I have started Robust using:
mono Robust.exe -inifile Robust.HG.ini
I was able to create a user, launch opensim and create a region and estate and assign both to my user account.
Now when I try to login I an of error on the Robust console. This is the beginning of the error:


17:34:33 - [LLOGIN SERVICE]: Exception processing login for Roger Dangerously: MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime
at MySql.Data.Types.MySqlDateTime.GetDateTime () [0x00000] in <filename unknown>:0


On my viewer I get: Login failed. Error generating Login Response.

Full copy of the login attempt is here:
17:34:32 - [LLOGIN SERVICE]: Login request for Roger XXXXXXXXXX at last using viewer 5.0.7.52912, channel Firestorm-Releasex64, IP x.x.x.x, Mac [REDACTED], Possible LibOMVGridProxy: False
17:34:33 - [AUTH SERVICE]: Authenticating for d7ddc0f3-2a3d-4233-9db5-149b2a83831a, user account service present: True
17:34:33 - [HG SUITCASE INVENTORY SERVICE]: GetRootFolder for d7ddc0f3-2a3d-4233-9db5-149b2a83831a
17:34:33 - [PRESENCE SERVICE]: LoginAgent: session 28cf0275-0483-4a4a-8282-d4fd140cd891, user d7ddc0f3-2a3d-4233-9db5-149b2a83831a, region 00000000-0000-0000-0000-000000000000, secure session af8196fa-0a53-4c16-b624-34b8ae0ebfd3
17:34:33 - [LLOGIN SERVICE]: Failed to fetch GridUserInfo. Creating empty GridUserInfo as home
17:34:33 - [LLOGIN SERVICE]: Finding destination matching start location last for Roger Dangerously
17:34:33 - [GRID SERVICE]: GetDefaultRegions returning 0 regions
17:34:33 - [LLOGIN SERVICE]: Last Region Not Found Attempting to find random region
17:34:33 - [GRID SERVICE]: Fallback returned 0 regions
17:34:33 - [GRID SERVICE]: Hyperlinks returned 0 regions
17:34:33 - [LLOGIN SERVICE]: Found destination \DG Welcome Center, endpoint 127.0.0.1:9000 for Roger Dangerously
17:34:33 - [LLLOGIN SERVICE]: found new key HomeURI http://login.dangerouslygrid.com:8002/
17:34:33 - [LLLOGIN SERVICE]: found new key InventoryServerURI http://login.dangerouslygrid.com:8002/
17:34:33 - [LLLOGIN SERVICE]: found new key AssetServerURI http://login.dangerouslygrid.com:8002/
17:34:33 - [LLLOGIN SERVICE]: found new key ProfileServerURI http://login.dangerouslygrid.com:8002/
17:34:33 - [LLLOGIN SERVICE]: found new key FriendsServerURI http://login.dangerouslygrid.com:8002/
17:34:33 - [LLLOGIN SERVICE]: found new key IMServerURI http://login.dangerouslygrid.com:8002/
17:34:33 - [LLLOGIN SERVICE]: found new key GroupsServerURI http://login.dangerouslygrid.com:8002/
17:34:33 - [LLOGIN SERVICE]: Launching agent at \DG Welcome Center
17:34:33 - [USER AGENT SERVICE]: Request to login user Roger XXXXXXXX (@x.x.x.x) to grid http://login.dangerouslygrid.com:8002/
17:34:33 - [USER AGENT SERVICE]: this grid: http://login.dangerouslygrid.com:8002/, desired grid: http://login.dangerouslygrid.com:8002/, desired region: b15b9832-f9c9-4bc4-8b0b-e87a1d137164
17:34:33 - [GATEKEEPER SERVICE]: Login request for Roger XXXXXXXXX@ http://login.dangerouslygrid.com:8002/ (d7ddc0f3-2a3d-4233-9db5-149b2a83831a) at b15b9832-f9c9-4bc4-8b0b-e87a1d137164 using viewer Firestorm-Releasex64 5.0.7.52912, channel Firestorm-Releasex64, IP x.x.x.x, Mac [REDACTED], Id0 500bb9ee7292b9c7feacc9f4583ed59a, Teleport Flags: ViaLogin, ViaRegionID. From region Unknown
17:34:33 - [GATEKEEPER SERVICE]: Verifying http://login.dangerouslygrid.com:8002 against http://login.dangerouslygrid.com:8002
17:34:33 - [LLOGIN SERVICE]: Exception processing login for Roger Dangerously: MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime
at MySql.Data.Types.MySqlDateTime.GetDateTime () [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.MySqlDataReader.GetValue (Int32 i) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.MySqlDataReader.get_Item (Int32 i) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.String name) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.HGTravelingData].DoQueryWithConnection (MySql.Data.MySqlClient.MySqlCommand cmd, MySql.Data.MySqlClient.MySqlConnection dbcon) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.HGTravelingData].DoQuery (MySql.Data.MySqlClient.MySqlCommand cmd) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.HGTravelingData].Get (System.String[] fields, System.String[] keys, System.String options) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.HGTravelingData].Get (System.String[] fields, System.String[] keys) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.HGTravelingData].Get (System.String field, System.String key) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLHGTravelData.Get (UUID sessionID) [0x00000] in <filename unknown>:0
at OpenSim.Services.HypergridService.UserAgentService.VerifyAgent (UUID sessionID, System.String token) [0x00000] in <filename unknown>:0
at OpenSim.Services.HypergridService.GatekeeperService.Authenticate (OpenSim.Framework.AgentCircuitData aCircuit) [0x00000] in <filename unknown>:0
at OpenSim.Services.HypergridService.GatekeeperService.LoginAgent (OpenSim.Services.Interfaces.GridRegion source, OpenSim.Framework.AgentCircuitData aCircuit, OpenSim.Services.Interfaces.GridRegion destination, System.String& reason) [0x00000] in <filename unknown>:0
at OpenSim.Services.HypergridService.UserAgentService.LoginAgentToGrid (OpenSim.Services.Interfaces.GridRegion source, OpenSim.Framework.AgentCircuitData agentCircuit, OpenSim.Services.Interfaces.GridRegion gatekeeper, OpenSim.Services.Interfaces.GridRegion finalDestination, Boolean fromLogin, System.String& reason) [0x00000] in <filename unknown>:0
at OpenSim.Services.LLLoginService.LLLoginService.LaunchAgentIndirectly (OpenSim.Services.Interfaces.GridRegion gatekeeper, OpenSim.Services.Interfaces.GridRegion destination, OpenSim.Framework.AgentCircuitData aCircuit, System.Net.IPEndPoint clientIP, System.String& reason) [0x00000] in <filename unknown>:0
at OpenSim.Services.LLLoginService.LLLoginService.LaunchAgentAtGrid (OpenSim.Services.Interfaces.GridRegion gatekeeper, OpenSim.Services.Interfaces.GridRegion destination, OpenSim.Services.Interfaces.UserAccount account, OpenSim.Framework.AvatarAppearance avatar, UUID session, UUID secureSession, Vector3 position, System.String currentWhere, System.String viewer, System.String channel, System.String mac, System.String id0, System.Net.IPEndPoint clientIP, TeleportFlags flags, System.String& where, System.String& reason, OpenSim.Services.Interfaces.GridRegion& dest) [0x00000] in <filename unknown>:0
at OpenSim.Services.LLLoginService.LLLoginService.Login (System.String firstName, System.String lastName, System.String passwd, System.String startLocation, UUID scopeID, System.String clientVersion, System.String channel, System.String mac, System.String id0, System.Net.IPEndPoint clientIP, Boolean LibOMVclient) [0x00000] in <filename unknown>:0 at MySql.Data.Types.MySqlDateTime.GetDateTime () [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.MySqlDataReader.GetValue (Int32 i) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.MySqlDataReader.get_Item (Int32 i) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.String name) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.HGTravelingData].DoQueryWithConnection (MySql.Data.MySqlClient.MySqlCommand cmd, MySql.Data.MySqlClient.MySqlConnection dbcon) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.HGTravelingData].DoQuery (MySql.Data.MySqlClient.MySqlCommand cmd) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.HGTravelingData].Get (System.String[] fields, System.String[] keys, System.String options) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.HGTravelingData].Get (System.String[] fields, System.String[] keys) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[OpenSim.Data.HGTravelingData].Get (System.String field, System.String key) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLHGTravelData.Get (UUID sessionID) [0x00000] in <filename unknown>:0
at OpenSim.Services.HypergridService.UserAgentService.VerifyAgent (UUID sessionID, System.String token) [0x00000] in <filename unknown>:0
at OpenSim.Services.HypergridService.GatekeeperService.Authenticate (OpenSim.Framework.AgentCircuitData aCircuit) [0x00000] in <filename unknown>:0
at OpenSim.Services.HypergridService.GatekeeperService.LoginAgent (OpenSim.Services.Interfaces.GridRegion source, OpenSim.Framework.AgentCircuitData aCircuit, OpenSim.Services.Interfaces.GridRegion destination, System.String& reason) [0x00000] in <filename unknown>:0
at OpenSim.Services.HypergridService.UserAgentService.LoginAgentToGrid (OpenSim.Services.Interfaces.GridRegion source, OpenSim.Framework.AgentCircuitData agentCircuit, OpenSim.Services.Interfaces.GridRegion gatekeeper, OpenSim.Services.Interfaces.GridRegion finalDestination, Boolean fromLogin, System.String& reason) [0x00000] in <filename unknown>:0
at OpenSim.Services.LLLoginService.LLLoginService.LaunchAgentIndirectly (OpenSim.Services.Interfaces.GridRegion gatekeeper, OpenSim.Services.Interfaces.GridRegion destination, OpenSim.Framework.AgentCircuitData aCircuit, System.Net.IPEndPoint clientIP, System.String& reason) [0x00000] in <filename unknown>:0
at OpenSim.Services.LLLoginService.LLLoginService.LaunchAgentAtGrid (OpenSim.Services.Interfaces.GridRegion gatekeeper, OpenSim.Services.Interfaces.GridRegion destination, OpenSim.Services.Interfaces.UserAccount account, OpenSim.Framework.AvatarAppearance avatar, UUID session, UUID secureSession, Vector3 position, System.String currentWhere, System.String viewer, System.String channel, System.String mac, System.String id0, System.Net.IPEndPoint clientIP, TeleportFlags flags, System.String& where, System.String& reason, OpenSim.Services.Interfaces.GridRegion& dest) [0x00000] in <filename unknown>:0
at OpenSim.Services.LLLoginService.LLLoginService.Login (System.String firstName, System.String lastName, System.String passwd, System.String startLocation, UUID scopeID, System.String clientVersion, System.String channel, System.String mac, System.String id0, System.Net.IPEndPoint clientIP, Boolean LibOMVclient) [0x00000] in <filename unknown>:0
17:34:33 - [PRESENCE SERVICE]: LogoutAgent: session 28cf0275-0483-4a4a-8282-d4fd140cd891, user d7ddc0f3-2a3d-4233-9db5-149b2a83831a, region 00000000-0000-0000-0000-000000000000


Top
 Profile  
 
 Post subject: Re: MySQL Date Problem when logging in.
PostPosted: Tue Oct 17, 2017 6:23 pm 
Site Admin

Joined: Sun Jul 04, 2010 8:20 pm
Posts: 468
What version of mysql are you using?

https://bugs.mysql.com/bug.php?id=87120

dan


Top
 Profile  
 
 Post subject: Re: MySQL Date Problem when logging in.
PostPosted: Tue Oct 17, 2017 7:09 pm 

Joined: Fri Oct 13, 2017 2:18 pm
Posts: 16
MySQL version is MySQL 5.7.17
I am running it on a separate server, the Robust/OpenSim server is Ubuntu 14.0.4


Top
 Profile  
 
 Post subject: Re: MySQL Date Problem when logging in.
PostPosted: Wed Oct 18, 2017 7:01 am 
Site Admin
User avatar

Joined: Sun Jun 27, 2010 10:34 am
Posts: 87
Location: France
apt-get install php mysql-server mysql-client php5-mysql

_________________
Paela Argus,
Webmanagement Osgrid

https://www.osgrid.org


Top
 Profile  
 
 Post subject: Re: MySQL Date Problem when logging in.
PostPosted: Wed Oct 18, 2017 7:04 am 
Site Admin
User avatar

Joined: Sun Jun 27, 2010 10:34 am
Posts: 87
Location: France
Ubuntu are not the must for start a grid,
Try use debian :) more stable !

_________________
Paela Argus,
Webmanagement Osgrid

https://www.osgrid.org


Top
 Profile  
 
 Post subject: Re: MySQL Date Problem when logging in.
PostPosted: Wed Oct 18, 2017 12:09 pm 

Joined: Fri Oct 13, 2017 2:18 pm
Posts: 16
paela argus {L_WROTE}:
Ubuntu are not the must for start a grid,
Try use debian :) more stable !


I am building on Amazon AWS and don't have a Debian image option. I have Ubuntu, SUSE Linux Server, RHEL and Amazon Deep Learning Linux. Which one would you suggest? I come from a windows background and have Ubuntu experience but learning a new OS isn't a problem to get this set up right.


Top
 Profile  
 
 Post subject: Re: MySQL Date Problem when logging in.
PostPosted: Thu Oct 19, 2017 3:08 pm 
Site Admin
User avatar

Joined: Sun Jun 27, 2010 10:34 am
Posts: 87
Location: France
I see you have solved your problem mysql but please use the same sujet for yours questions grid

_________________
Paela Argus,
Webmanagement Osgrid

https://www.osgrid.org


Top
 Profile  
 
Display posts from previous:  Sort by  
Post a new topicPost a reply Page 1 of 1   [ 7 posts ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  


Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
610nm Style by Daniel St. Jules of Gamexe.net