Asura

Hi Mickosis, The issue you are having is because of improper configuration in your 'login_athena.conf', 'char_athena.conf', and 'map_athena.conf'. It is suggested that you never use the bind ip function; so please make sure you comment out those lines with // in front of the bind entry. Now for the char_ip, login_ip, and map_ip; you would need to place your VPS's IP and not localhost or 127.0.0.1. The issue you are having is the fact that your login-server_sql is directing traffic to '127.0.0.1', which is to the player's own computer... and he is not the host, the VPS is the host. You should be able to connect just fine after you have entered the proper values; enjoy and good luck!

Hi DarkKazuki, It seems to be that you have not properly port-forwarded your computer's LAN IP on your internet router. You will need to open up your Windows Command Line by clicking on 'Start', 'Run', and then type 'cmd' (without ' ') and enter. A command line will pop-up, then you will need to type 'ipconfig' (without ' ') and you should see a line for 'IPv4' address. This is the LAN IP which you will port forward on your router. You may visit this site to learn how to port forward for your specific router model: http://portforward.com/ If you are using the standard Athena ports (6900,6121,5121); you must port forward your IPv4 IP for all 3 ports. Enjoy, and good luck.

Hi victorfa1, You may find your IP by visiting this site: http://www.whatismyip.com/ Please note that most home internet providers, give you a dynamic IP; which means it changes itself every 12/24hours or maybe even longer, depending on which provider. So a lot of home-hosters use the service of 'No-IP' to help maintain a consistent sub-domain name, which will be linked with your changing IP. http://www.no-ip.com/ Also to note... FluxCP would require you to install WAMPP or some type of web server on your computer; you may find a guide on XAMPP here: http://rathena.org/wiki/XAMPP_Installation Good luck!

Hi WillSuranol, This error is caused by insufficient privileges on your RO server's MySQL. The MySQL account that you have provided in '/config/servers.php' is probably locked down in access for localhost only. You will need to create a new MySQL user within phpMyAdmin or terminal, and set the new account's host as '198.105.222.91'; also, you need to make sure that this new account has the proper permissions to use your Athena SQL database.

Hi WillSuranol, It should have been obvious; as FluxCP is designed fairly straightforward. If you took the effort to look, you should have seen the following line; 'DateDefaultTimezone' => null, // The default timezone, consult the PHP manual for valid timezones: http://php.net/timezones (null for defaut system TZ) In order to set it to PHT, you would put: 'DateDefaultTimezone' => 'Asia/Manila', // The default timezone, consult the PHP manual for valid timezones: http://php.net/timezones (null for defaut system TZ) For other times, you can see within the comment; the link to guide you to proper values for the Timezone: http://php.net/timezones

Hi WillSuranol, You will need to edit '/config/application.php', and declare the timezone.

Hi GM Neri, What data are you referring to? Can you be a bit more specific as to what you are trying to do?

Hi Najara, Please check the file called "error_log" within your website files, it should explain what issues your webserver has in generating the page.

Hi Everyone, After taking a closer look at the script; you can actually just add the script into the crontab to run per minute. Just open up your crontab with this command: crontab -e And then add this to the last line of your cron tasks */1 * * * * /location/to/file/auto-restarter.sh Make sure you put the proper location to the file in the crontab, and also when you want the script to stop running; just edit the 'auto-restarter.sh' file and change 'run=1' to 'run=0'.

Hi Rage, Yes, it's fine to do that; though once your database becomes a fairly large size, it'd be recommended that you switch MySQL from MyISAM to InnoDB.

Hi Virus, You would simply open up the Terminal or SSH command line, and then type... mysqldump -u USERNAME -p, --password=PASSWORD DATABASE_NAME > FILE_NAME.sql Replace all capitalized words with the proper values. This question has actually been asked a few times on rAthena.org; doing a search would have brought you the answer quicker.

Hi Achhandrian, Please try replacing '127.0.0.1' in `inter_athena.conf` with your Dedicated Server/VPS IP. If starting up works, then this would probably mean your MySQL server is being binded to only listen to connections from your Dedicated Server/VPS IP. You can correct this by removing the bind ip setting in '/etc/my.cnf'.

Hi naaaan, As the error states, you need to open port 3306 in your software firewall and also your router. Make sure you've set up port forwarding for your computer's LAN address for port 3306.

Hi kaka19, It's probably because your no-ip address 'zapro.no-ip.org' is not set to anything. C:\Users>ping zapro.no-ip.info Ping request could not find host zapro.no-ip.info. Please check the name and try again. It's not even ping-able.

Hi WillSuranol, There has to be permission granted both sides to communicate with each other. Make sure your RO VPS's MySQL user allows 'tango.ks.dzfav.net', and then make sure that your Webhost has whitelisted your RO VPS IP. If you have cPanel, adding the VPS IP in 'MySQL Hosts' would do fine.

Hi shades, You will need to correctly enter the proper MySQL user information in the file '/config/servers.php'. Once you've entered that, you must make sure that the MySQL user account that you are using has the capability to be accessed by that particular host.

Hi killernot, The delay would be caused by the transaction time from your RO VPS service to your GoDaddy Database... that's probably why you're experiencing lag. Plus the fact that a webhosting company's database isn't optimized for hosting high transaction databases...

Hi kou, I would suggest using the search function, or browsing the WIKI. Surely this is not the first time that this question has been asked. Category:Installation_Guides Setting up a CentOS VPS with rAthena & VNC There are more topics, for Debian and Ubuntu; just use the search function on the forum.

Hi RaGERO, Did the server crash already? It's suppose to generate the core file within the trunk folder once it has crashed. You may also search for the .core file by using the following commands via Terminal. updatedb locate *.core

Hi RaGERO, You still need to do the following... File: /etc/security/limits.conf Change... #* soft core 0 To... * soft core unlimited File: /etc/profile Change... # No core files by default #ulimit -S -c 0 > /dev/null 2>&1 To... # No core files by default ulimit -S -c 0 > /dev/null 2>&1 Type this in SSH/Terminal... ulimit -c unlimited Proceed to reboot your server, and then re-compile with --enable-debug=gdb once more. Now you may proceed to start your Athena server and it should generate the .core dump.

Hi PokemonRO, Are you using Harmony for the server? Maybe her IP was blocked via Harmony.

Hi Mang-Berto, Since you are using Gmail, make sure you are using the correct SMTP server, enabled POP/SMTP, and also have the correct ports. http://support.google.com/mail/bin/answer.py?hl=en&answer=13287

Hi Calypso000, What CP are you using and also what's your MySQL server version? I've never seen this error before, pretty curious.

Hi Calypso000, You should follow every bit of those guides, and just replace the '127.0.0.1' values inside '/config/servers.php' with the IP of the "other VPS". This should work just fine as long as your MySQL user that you specify to use, can log in properly from that source.

Hi WillSuranol, It seems like you're missing some libraries required for the configuration... I would try, yum -y install mysql-devel