Error connecting remote MySQL db

2 weeks 6 days ago #3215 by antlampas
Hi,

I have a little problem: i have an OpenSimulator grid running on a server, and Joomla running on another server (on a commercial web hosting service). The OpenSimulator is running a MySQL server, which is publicly accessible, for the OS Grid. Now i installed jOpenSim on my Joomla website and i'm trying to connect it to my OS Grid on the other server. The problem is that i'm not able to connect jOpenSim to my OS Grid, because it is not able to connect to MySQL server (MariaDB on a linux host). I checked MySQL connectivity, and it seems to be all OK. On jOpenSim configuration username, password, hostname, db name and port are all right.
In jOpenSim and/or Joomla configuration, in addition to my Grid database connection data, i am missing something else?

Thank you for your time

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

2 weeks 4 days ago #3216 by foto50
Hi antlampas

There are usually 2 to 3 important things that many times get missed when connecting from another server:

1. in your opensim database server you also need an additional user with the host of your joomla server.
So if you e.g. have a user named opensim@localhost, you also need opensim@host-of-your-joomla so it gets access to the database

2. many times the mysql port (usually 3306) is not accessible from outside by firewall rules, which is usually actually a good idea. But in this case you might need a custom firewall rule for the IP of your joomla server to be able to connect.

3. from mysql side, settings like "bind-address = 127.0.0.1" or "skip-networking" in your my.cnf also avoid connections from outside

Hope this helps
Greetz
FoTo50
The following user(s) said Thank You: antlampas

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

2 weeks 4 days ago #3217 by antlampas
Thank you for the reply.

Ok, i checked all these points, and set everything following your suggestions.
Now i can reach my database from external hosts (i know this is insecure, but i need to do this way for now...), but jOpenSim still cannot connect to my database.
Going on with my search, at the end i found that the problem doesn't depend on jOpenSim configuration nor my database configuration, but on my web hosting service, who is denying all connection on external databases... so, i solved simply changing my web hosting service.

Thank you

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

2 weeks 2 days ago #3218 by foto50
Hi antlampas

Denying remote access to MySQL is for sure basically no bad idea. It avoids many security issues towards your data, that are otherwise hard to handle in a manageable frame.

Good providers though offer a possibility to handle port openings for certain services to certain IP addresses. In that case the security management keeps comprehensible I think.

Greetz
FoTo50
The following user(s) said Thank You: antlampas

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

2 weeks 2 days ago #3219 by antlampas
Opening MySQL to remote hosts it's undoubtedly a bad idea. I had to do this way because, at this time, i cannot install Joomla in the same machine where OpenSimlator is installed.
Lucky, the machine is for testing purpose only, in a testing environment, so this security issue is not so critical. :)

Greets,
antlampas

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

Time to create page: 0.114 seconds

Search

Our Regions

Region: Loc X: Loc Y:
Agora 1000 998
Basilic… 1007 1000
Bay Sho… 997 1003
Boardwa… 1003 1004
BoraBor… 1002 999
Canary … 997 999
Creator… 990 990
Crystal… 1001 1000
DeepTho… 1005 998
Fantasy 1009 1004
FoToSan… 996 995
Hiatus 1007 1004
jAdult 1003 1003
jCity 1009 1003
jOpenWe… 1000 999
JuniorT… 1002 1001
Kanadah… 1002 1000
Kansas 1007 1003
Kodu 980 983
LindaKe… 1000 997
MA2 1008 1003
MA5 1008 1004
MonteSc… 1001 1001
Mountai… 1009 1000
Naos 999 999
Pangaea 1005 1003
RiverSi… 999 1000
Sakani 999 998
Snambin 1001 998
Tropica… 1004 1003
ViewerH… 1002 998
WaterWo… 1001 999
WilderK… 1000 1000

Donate jOpenSim

Please consider supporting our efforts.

Amount