Issues Connecting Joomla to different servers DB

Hello everyone,

Currently I am running Joomla on a commercial server, and opensim/database on a seperate server. I would like to keep them both running on different servers. However I can't seem to connect the Grid Status to the Database on a seperate server.

I changed the router settings to forward on port 3306, and I am running XAMPP on the private side. I did test a private joomla site on the same server and it worked just fine. It just doesn't seem to want to cross talk between servers.

Any ideas?

Hi david.bell and welcome to our forum

Most of time, this can have 3 reasons:

1. Does the firewall of your opensim server accept incoming connections on the mysql port (by default 3306)? For security reasons, this is most of time disabled by default. You also can e.g. add a firewall rule, that accepts incoming mysql connections ONLY from this IP address.

2. In the mysql settings of your opensim server (my.cnf at Linux, on Win maybe my.ini), there might be "skip-networking" enabled. This option also prevents MySQL from listening on a TCP/IP port. Another problem in the mysql setting could be a "bind-address=127.0.0.1" or similar.

3. Did you extend the database user of the opensim database to the host of your Joomla server? Most of time, a database user is initially granted with the host localhost only (e.g. opensim@localhost). You can either update the user using wildcards (e.g. opensim@%) which I do not recommend, or better duplicate this user with the IP or hostname of your Joomla server (e.g. ).

There is a nice turtorial for how to enable remote access to your database at www.cyberciti.biz/tips/how-do-i-enable-r...database-server.html (thanks very much Vivek Gite for this!).

I hope these hints will help

Greetz
FoTo50