jOpenSimWorld

Grid Status: Online
Total Regions: 21
Visitors (30 Days): 13
Total Residents: 442
Online Now: 0
Hypergriders online: 0

Issues Connecting Joomla to different servers DB

10 years 3 months ago #918 by david.bell
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?

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

10 years 3 months ago #919 by foto50
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

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

Time to create page: 0.109 seconds

Search

Donate jOpenSim

Please consider supporting our efforts.

Amount

Our Regions

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

jOpenSimWorld

Grid Status: Online
Total Regions: 21
Visitors (30 Days): 13
Total Residents: 442
Online Now: 0
Hypergriders online: 0