jOpenSimWorld

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

mysql config?

13 years 9 months ago #417 by fstltna
i have a working opensim install, but i cant get com_opensim to work. Can someone tell me what I have to do to let host-a talk to host-b I tried telnetting to 3306 on the mysql host and it says connection refused...

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

13 years 9 months ago #418 by foto50
Hi fstltna

Does MySQL tell you \"connection refused\" or the host itself refuses connection?

If MySQL is telling you about it, you should check first if you have created a user for OpenSim\'s database to access from outside. E.g. your user is called \"opensim\", in the DB of opensim (host-a) you usually have \"opensim@localhost\" and/or \"opensim@127.0.0.1\". But for Joomla (host-b) you need the same user as \"opensim@host-b\" to be able to access OpenSim\'s database.

Another reason could be, that in your \"my.cnf\" you have \"skip-networking\" enabled or something similar like \"bind-address=127.0.0.1\". You can try to comment out \"# skip-networking\" or \"bind-address=0.0.0.0\" in my.cnf.

If MySQL is configured for the default port (3306) you also need to ensure, that this port is opened at least for host-b in your firewall settings.

I hope this helps

Greetz
FoTo50

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

13 years 9 months ago #419 by fstltna

\FoTo50\:3b5asn9d wrote: Hi fstltna

Does MySQL tell you \"connection refused\" or the host itself refuses connection?

The connection itself is refused...

\FoTo50\:3b5asn9d wrote: Another reason could be, that in your \"my.cnf\" you have \"skip-networking\" enabled or something similar like \"bind-address=127.0.0.1\". You can try to comment out \"# skip-networking\" or \"bind-address=0.0.0.0\" in my.cnf.
FoTo50


Great! It was \"bind-address\" binding to localhost...

Thanks!

Marisa

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

Time to create page: 0.075 seconds

Search

Donate jOpenSim

Please consider supporting our efforts.

Amount

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