jOpenSimWorld

Grid Status:	Online
Total Regions:	23
Visitors (30 Days):	12
Total Residents:	485
Online Now:	0
Hypergriders online:	0

How to connect to database?

DJ Devil
Topic Author
Offline
Expert Boarder
Developer for jOpenSim

12 years 9 months ago #971 by DJ Devil

Hello i am new here, i was looking for a opensim interface for opensim 0.7.x and found this, my problem now is after the component install (and adding details to standalonecommon.ini) i still get the error


        * Could not connect to OpenSim database! Please check your settings.
        * Could not connect to OpenSim Grid database! Please check your settings.

what am i doing wrong?
greetings from germany

Please Log in or Create an account to join the conversation.

DJ Devil
Topic Author
Offline
Expert Boarder
Developer for jOpenSim

12 years 9 months 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

[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>:0

but when i create the user from the console it works

did i do something wrong?

Please Log in or Create an account to join the conversation.

DJ Devil
Topic Author
Offline
Expert Boarder
Developer for jOpenSim

12 years 9 months 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?

Please Log in or Create an account to join the conversation.

foto50
Offline
Administrator

12 years 9 months 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:

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.

DJ Devil
Topic Author
Offline
Expert Boarder
Developer for jOpenSim

12 years 9 months 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

The following user(s) said Thank You: foto50

Please Log in or Create an account to join the conversation.

Time to create page: 0.085 seconds

Search

Donate jOpenSim

Please consider supporting our efforts.

Our Regions

Region:	Loc X:	Loc Y:
Agora	1000	998
BareBad…	997	997
Bohemas	996	998
BoraBor…	1002	999
Crystal…	1001	1000
DeepTho…	1005	998
FoToSan…	999	995
jCity	1001	997
jOpenWe…	1000	999
JuniorT…	1002	1001
Kanadah…	1002	1000
LindaKe…	1000	997
LittleC…	996	997
MonteSc…	1001	1001
Naos	999	999
Pangaea	1005	1003
RiverSi…	999	1000
Sakani	999	998
Snambin	1001	998
Tartola	997	998
ViewerH…	1002	998
WaterWo…	1001	999
WilderK…	1000	1000

jOpenSimWorld

Grid Status:	Online
Total Regions:	23
Visitors (30 Days):	12
Total Residents:	485
Online Now:	0
Hypergriders online:	0