jOpenSimWorld

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

mysql config?

14 years 1 month 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.

14 years 1 month 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.

14 years 1 month 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.070 seconds