jOpenSimWorld
| Grid Status: | Online |
| Total Regions: | 23 |
| Visitors (30 Days): | 7 |
| Total Residents: | 491 |
| Online Now: | 0 |
| Hypergriders online: | 0 |
How to connect to database?
13 years 1 month ago #972
by DJ Devil
Okay Sorry my prior problem was that i didnt see the global configuration button 
now my next problem is when a user signs up (i made test account) and wants to login to the opensim server the login fails the error message looks like this
but when i create the user from the console it works
did i do something wrong?
now my next problem is when a user signs up (i made test account) and wants to login to the opensim server the login fails the error message looks like this[LLOGIN SERVICE]: Exception processing login for Lars Devil: System.FormatException: Invalid format for Guid.Guid(string).
at System.Guid+GuidParser.ParseChar (Char c) [0x00000] in <filename unknown>:0
at System.Guid+GuidParser.ParseGuid2 () [0x00000] in <filename unknown>:0
at System.Guid+GuidParser.Parse () [0x00000] in <filename unknown>:0
at System.Guid..ctor (System.String g) [0x00000] in <filename unknown>:0
at MySql.Data.Types.MySqlGuid.MySql.Data.Types.IMySqlValue.ReadValue (MySql.Data.MySqlClient.MySqlPacket packet, Int64 length, Boolean nullVal) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.NativeDriver.ReadColumnValue (Int32 index, MySql.Data.MySqlClient.MySqlField field, IMySqlValue valObject) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.Driver.ReadColumnValue (Int32 index, MySql.Data.MySqlClient.MySqlField field, IMySqlValue value) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.ResultSet.ReadColumnData (Boolean outputParms) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.ResultSet.NextRow (CommandBehavior behavior) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.MySqlDataReader.Read () [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[T].DoQuery (MySql.Data.MySqlClient.MySqlCommand cmd) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[T].Get (System.String[] fields, System.String[] keys) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[T].Get (System.String field, System.String key) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGridUserData.Get (System.String userID) [0x00000] in <filename unknown>:0
at OpenSim.Services.UserAccountService.GridUserService.LoggedIn (System.String userID) [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) [0x00000] in <filename unknown>:0 at System.Guid+GuidParser.ParseChar (Char c) [0x00000] in <filename unknown>:0
at System.Guid+GuidParser.ParseGuid2 () [0x00000] in <filename unknown>:0
at System.Guid+GuidParser.Parse () [0x00000] in <filename unknown>:0
at System.Guid..ctor (System.String g) [0x00000] in <filename unknown>:0
at MySql.Data.Types.MySqlGuid.MySql.Data.Types.IMySqlValue.ReadValue (MySql.Data.MySqlClient.MySqlPacket packet, Int64 length, Boolean nullVal) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.NativeDriver.ReadColumnValue (Int32 index, MySql.Data.MySqlClient.MySqlField field, IMySqlValue valObject) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.Driver.ReadColumnValue (Int32 index, MySql.Data.MySqlClient.MySqlField field, IMySqlValue value) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.ResultSet.ReadColumnData (Boolean outputParms) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.ResultSet.NextRow (CommandBehavior behavior) [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.MySqlDataReader.Read () [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[T].DoQuery (MySql.Data.MySqlClient.MySqlCommand cmd) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[T].Get (System.String[] fields, System.String[] keys) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGenericTableHandler`1[T].Get (System.String field, System.String key) [0x00000] in <filename unknown>:0
at OpenSim.Data.MySQL.MySQLGridUserData.Get (System.String userID) [0x00000] in <filename unknown>:0
at OpenSim.Services.UserAccountService.GridUserService.LoggedIn (System.String userID) [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) [0x00000] in <filename unknown>:0did i do something wrong?
Please Log in or Create an account to join the conversation.
13 years 1 month ago #973
by DJ Devil
nevermind delete/close this topic i forgot to set home position in the map area this solved my problem, anyways nice work donation will be on its way soon 
you provide some great joomla scripts for opensim just one question is it possible to sync the password update with the joomls password? so is either get changed the other changes too?
you provide some great joomla scripts for opensim just one question is it possible to sync the password update with the joomls password? so is either get changed the other changes too? Please Log in or Create an account to join the conversation.
13 years 1 month ago #976
by foto50
Hi DJ Devil,
and welcome to jOpenSim I'm happy the problem is solved even before I could read it 
For those reading here for similar connection issues, I want to point some specialities when OpenSim is on a different server than jOpenSim resides:
I hope, I will find some time once to write a complete list about what privileges are required for which table, so security fanatics can keep the access as limited as possible
Also I have some OpenSim module in mind for a futuring version of jOpenSim, so that opening the MySQL port for jOpenSim will not be necessary anymore - allthough I have to admit, that this is not my highest priority at the moment.
As to your question about pwd sync: currently this is not implemented yet anywhere. But this could be solved with a plugin I would have to create (or maybe even add it to the current jOpenSimRegister-plugin?). It's definately worth to think more about it
Greetz (back from Austria)
FoTo50
and welcome to jOpenSim
I'm happy the problem is solved even before I could read it For those reading here for similar connection issues, I want to point some specialities when OpenSim is on a different server than jOpenSim resides:
- Most of time, the firewall port for MySQL (usually 3306) is closed for external connections. Since in this case jOpenSim needs to connect from outside, be sure to have this port opened.
- Database users in MySQL are often created by default in the format username@localhost. jOpenSim will not be able to connect with this username to OpenSim even if the MySQL port is opened. So if you use the username from OpenSim for jOpenSim, be sure to duplicate this user in the format username@host-of-jOpenSim or username@ip-address-of-jOpenSim.
- jOpenSim needs SELECT, UPDATE and INSERT privileges for many tables in OpenSim's database. So ensure, these privileges are set for this user.
I hope, I will find some time once to write a complete list about what privileges are required for which table, so security fanatics can keep the access as limited as possible
Also I have some OpenSim module in mind for a futuring version of jOpenSim, so that opening the MySQL port for jOpenSim will not be necessary anymore - allthough I have to admit, that this is not my highest priority at the moment.
As to your question about pwd sync: currently this is not implemented yet anywhere. But this could be solved with a plugin I would have to create (or maybe even add it to the current jOpenSimRegister-plugin?). It's definately worth to think more about it
Greetz (back from Austria)
FoTo50
Please Log in or Create an account to join the conversation.
13 years 1 month ago #978
by DJ Devil
yes my problem was i did not set a default location in the maps section after that it was solved, i am a php developer myself and if you need someone to help with this i would be glad to help
Please Log in or Create an account to join the conversation.
Time to create page: 0.113 seconds