Connecting to remote MYSQL Database

1 week 5 days ago #3322 by Karen Mansour
Thanks for reading ... totally blonde women here ... Running Worldbox Grid (Robust and Wifi configuration) - that all works fine but I would like to add the JOpenSim front end to our website.

The MySQL database (worldboxrobust) is on our own server which hosts the opensim grid, the Joomla website is on commercial shared hosting remotely from me.

I have created a MySQL user xusyou@xusyou - this user has full rights. My Hosting company has checked that they can access the databse from their end (as can I via my LAN) - but when i put the config into JOpenSim it says it cant access the databse.

I think I have done all the mods to GridCommon.ini and StandAloneCommon.ini - the databse has the presence field in it .....

Any idea ??

Thanks Karen
Attachments:

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

1 week 5 days ago - 1 week 5 days ago #3323 by djphil
Hi Karen Mansour,

Have you try database host in jopensim without http:// ?

Make sure you have:
- configured bind-address with the correct ip (without http: //) in your my.ini
- authorized access from an external ip to your robust database
- authorized access from your external ip to your user of your robust database
- allowed external connections on port 3306 in your firewall

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

1 week 5 days ago #3325 by Karen Mansour
hiya - mmmm most I have tried but not sure how to authorized access from an external ip to your robust database - surely Robust wouldnt work otherwise?? sorry never tried this before

answer 1 - yes with and without the http:// I get the same error
answer 2 - removed the bind-address in my.ini (has a # at front of it now)
answer 3 - my hosting company can access the mysql database via Telnet(??)
answer 4 - not sure how i do that
answer 5 - port 3306 is open to all

Any more ideas?

♥Karen♥

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

1 week 5 days ago #3326 by djphil
1) without http:// is is good.
2) don't remove but configure (eg: bind-address = <REMOTE_IP>)
4) with phpMyAdmin, go to User "Accounts, select" a user and clic "Edit privileges"
On tab "Connection information", you can set the "Host name".

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

1 week 5 days ago - 1 week 5 days ago #3327 by djphil
With mysql command prompt you can try;
1) For existi,g database:
mysql> update db set Host='<REMOTE_IP>' where Db='robust';
mysql> update user set Host='<REMOTE_IP>' where user='foo';
2) For new database:
mysql> CREATE DATABASE robust;
mysql> GRANT ALL ON robust.* TO foo@'<REMOTE_IP>' IDENTIFIED BY '<PASSWORD>';

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

Time to create page: 0.124 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