Problem with setting up Ceres Control Pannel

[tehscriptor]

hey rAthena board,

I have got a problem with setting up a Ceres Control Pannel. I have followed this Guide on how to set up a Server :

http://supportmii.com/ro1/JudasBible.pdf

Now my server is online and I want to make a CP for it and now here's the Problem.

I have tried everything for setting up the Ceres Control Pannel and I have filled into the gaps everything correctly , but there's always the same Message :

mysqli_connect: MySERVERIP@MYSERVERHOST [ Here localhost] failed

Can't connect to Ragnarok MySQL server. Press back and check your MySQL host, user, password

Now what do I have to do ,after thousand times of trieng I edited it manually with the normal config.default.php and renamed it to config.php and now if I connect to my cp it says :

Sorry! DB error found, please try again later.

So what should I do?

Thx!

[Law]

your server not accept external mysql connections :B

If you have installed phpMyAdmin, go to your server IP/phpmyadmin, go to Privileges, and edit the user with you connect, change the option of "Host" to "Any host", and select this option(at the end of the page) "keep the old one"

[tehscriptor]

Umm...How do I do that if My Computer runs the Server,that means I don't have a FTP Server for my Computer,I just have MySQL installed with my server files on it and it's up and running,I just want to make the Ceres CP work,so how do I give the Ceres CP the Privileges to connect to the ragnarok server files and not to the CP files.

[tehscriptor]

-bump-

I host the server by myself and the host of the Control Pannel is a free website host,and I just get this Message :

Sorry! DB error found, please try again later

So how to I give the free host permission to connect to the rag db?

Thx.

[Brian]

So MySQL is on your local computer right?

• Are you using your WAN IP for "MySQL Server IP" when you install CeresCP?
  
• Did you configure your router to forward port 3306 to your computer?
  
• Ask your webhost if they allow outgoing connections on port 3306.
  

[tehscriptor]

No not my wan IP ,when I open the MySQL administrator tool I can see the Server IP under clientinformation,that's the IP I'm using.

[Brian]

I host the server by myself and the host of the Control Pannel is a free website host.

"I host the server by myself" so that means MySQL Server (and rAthena) are running on your computer.

"the host of the Control Pannel is a free website host" that means CeresCP (and your website) will be running on another computer.

When your run the MySQL Administrator tool from your computer, it can connect to 'localhost' or 127.0.0.1 or your LAN IP (maybe something like 192.168.*.*) because it's local.

When another computer on the Internet connects to your MySQL Server, they need to use your WAN IP, and make sure you check all of these things:

• Are you using your WAN IP for "MySQL Server IP" when you install CeresCP?
  
• Did you configure your router to forward port 3306 to your computer?
  
• Ask your webhost if they allow outgoing connections on port 3306.
  

[tehscriptor]

Okay this already helped me server is online,but I still get the db error,what should be the SQL Ragnarok Host : My Wan IP or localhost?

[Brian]

your WAN IP

[OffBeat]

First; you need to find your WAN IP address. Which http://www.whatismyip.com/ will give you what your WAN IP is.

Second; if you have a router, you need to forward your mysql ports on your router to your LAN IP adress (please google this to find out what yours is).

Third; you need to make sure your 'server' which is hosting rA & Mysql does not have a firewall blocking your mysql ports. If it is, allow for those ports to bypass your firewall(s) & anti-virus software.

Forth; There is a good chance your 'free host' which your using for the control panel is not going to allow outside mysql connections. Which means, you need a new host (most likely paid hosting) that allows you to use outside mysql connections on their web servers.

Fifth; Good luck, you'll need it.

[tehscriptor]

...I really don't get it working,maybe gotta change tha host,thx anyway!

Edited January 28, 2012 by tehscriptor