Asura

Hi altious,
In my current experience, 3TB/3000GB worth of bandwidth would be able to serve a constant 500 active players at all times with a website running as well on the server. Here are my very raw and somewhat accurate calculations...
50 players = .05 mb/s [180mb used in 1hr] | [4.32gb used in 24hrs] | [129.6gb used in 31 days]
100 players = .1 mb/s [360mb used in 1hr] | [8.64gb used in 24hrs] | [267.84gb used in 31 days]
500 players = .5 mb/s [1.8gb used in 1hr] | [43.2gb used in 24hrs] | [1339.2gb used in 31 days]
Remember, you must have 500 active players on at all times to even achieve using 1.3~1.4GB of bandwidth in a month of 31 days.

Hi badarosko1,
 
You need to install gcc in order to compile.
yum -y install gcc

Hi BugsLIFE,
Run login-server, map-server, and char-server instead. Without the _sql extension in the file names.

Hi BugsLIFE,
Remove the _sql extension in the name of the files to run. It should work fine.

Hi Raijin,
 
If you are okay with using the console/SSH, stick with it. GUI does require more resources.

Hi Cold,
 
They removed the *_sql at the end of map/char/login, so try running "login-server" instead.

Hi kangfredy,
 
Protimus is definitely right. But I'll be more specific... please back up all your MySQL databases before attempting to do this.
yum -y remove mysql* rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm yum --enablerepo=remi -y install mysql mysql-server mysql-devel chkconfig --levels 235 mysqld on mysql_secure_installation

Hi P r o p e r t i e s,
 
I would recommend that you use the files that you are running on your own computer, and use them to replace the 'trunk' folder located on your VNC Desktop. You can do this by following this guide; https://asurahosting.com/forum/index.php?/topic/2-transfer-files-to-from-your-vps/
 
When you're down, you should re-compile the emulator files you uploaded by selecting 'Compile Server'. Then finally, re-configure your conf files to the correct IP, and MySQL info. It should work as it did on your own computer.

Hi Thor v2,
FluxCP does not require SMTP, it can also use PHP to send e-mails. Just switch 'MailerUseSMTP' to false, and it should use PHP by default to send the e-mails.

Hi Lelouch,
 
Edit your my.cnf and turn the 'old-passwords' value to false, by adding or editing to match this line;
old-passwords = 0  
Then restart your MySQL server. After doing this, you'll need to update your MySQL account passwords again once more; then this should have resolved your issue.

Hi cumbe11,
 
Instead of 'TYPE=MyISAM', should try using 'ENGINE=MyISAM'.
 
# # Database : `sgcp` #   DROP TABLE IF EXISTS `mainnews`; CREATE TABLE `mainnews` (   `post_id` int(11) NOT NULL auto_increment,   `title` varchar(60) NOT NULL,   `message` text NOT NULL,   `poster` text NOT NULL,   `date` varchar(255) NOT NULL,   PRIMARY KEY  (`post_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1;   DROP TABLE IF EXISTS `privilege`; CREATE TABLE `privilege` (   `account_id` int(11) NOT NULL default '0',   `privilege` int(11) NOT NULL default '0',   PRIMARY KEY  (`account_id`) ) ENGINE=MyISAM;   INSERT INTO `privilege` VALUES (704554,5);   DROP TABLE IF EXISTS `bugreport`; CREATE TABLE `bugreport` (   `post_id` int(11) NOT NULL auto_increment,   `report` text NOT NULL,   `poster` text NOT NULL,   `sex` char(1) NOT NULL default 'M',   `ip` varchar(255) NOT NULL,   `date` varchar(255) NOT NULL,   PRIMARY KEY  (`post_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1;   DROP TABLE IF EXISTS `forum`; CREATE TABLE `forum` (   `forum_id` int(11) NOT NULL auto_increment,   `category_id` int(11) NOT NULL,   `forum_title` varchar(255) default '',   `forum_description` varchar(255) default '',   `forum_perm` mediumtext NOT NULL,   PRIMARY KEY  (`forum_id`) ) ENGINE=MyISAM; INSERT INTO `forum` (category_id,forum_title,forum_description,forum_perm) VALUES ('1','A Test Forum','A test forum that may be removed at any time','[g1]:show_perm::read_perm::reply_perm::start_perm:[/g1][g2]:show_perm::read_perm::reply_perm::start_perm:[/g2][g3][/g3][g4]:show_perm::read_perm::reply_perm::start_perm:[/g4][g5]:show_perm::read_perm::reply_perm::start_perm:[/g5]');   DROP TABLE IF EXISTS `board_reply`; CREATE TABLE `board_reply` (   `reply_id` int(11) NOT NULL auto_increment,   `topic_id` int(11) NOT NULL,   `forum_id` int(11) NOT NULL,   `reply_user_id` varchar(255) default '',   `reply_emo` int(11) NOT NULL,   `reply_message` text,   `reply_ip` varchar(255) NOT NULL default '0.0.0.0',   `reply_date` varchar(255) default '',   `reply_upload` varchar(255) default '',   `reply_edit_name` varchar(255) default '',   `reply_edit_date` varchar(255) default '',   PRIMARY KEY  (`reply_id`) ) ENGINE=MyISAM;   DROP TABLE IF EXISTS `board_topic`; CREATE TABLE `board_topic` (   `topic_id` int(11) NOT NULL auto_increment,   `forum_id` int(11) NOT NULL,   `pinned_mode` varchar(255) NOT NULL default '0',   `closed_mode` varchar(255) NOT NULL default '0',   `topic_name` varchar(255) default '',   `topic_description` varchar(255) default '',   `topic_starter` varchar(255) NOT NULL default '',   `topic_reading` varchar(255) NOT NULL default '0',   `topic_replying` varchar(255) NOT NULL default '0',   `topic_lastreply_name` varchar(255) default '',   `topic_start_date` varchar(255) default '',   `topic_last_action_date` varchar(255) default '',   PRIMARY KEY  (`topic_id`) ) ENGINE=MyISAM;   DROP TABLE IF EXISTS `user_profile`; CREATE TABLE `user_profile` (   `user_number` int(11) unsigned NOT NULL auto_increment,   `user_id` int(11) unsigned NOT NULL,   `display_name` varchar(255)  NOT NULL default '',   `user_sls_pass` varchar(255)  NOT NULL default '',   `user_time_offset` varchar(255) default '',   `user_ranking` varchar(255) NOT NULL default '0',   `user_avatar` varchar(255) default '',   `user_avatar_width` varchar(255) NOT NULL default '0',   `user_avatar_height` varchar(255) NOT NULL default '0',   `user_signature_message` text,   `user_flood_protection` varchar(12) NOT NULL default '0',   `user_joined` varchar(255) default '',   `user_last_login` varchar(255) default '',   `user_online` tinyint(1) default '0',   PRIMARY KEY  (`user_number`) ) ENGINE=MyISAM;   DROP TABLE IF EXISTS `status`; CREATE TABLE `status` (   `last_checked` varchar(255) NOT NULL default '',   `login` int(11) NOT NULL default '0',   `char` int(11) NOT NULL default '0',   `map` int(11) NOT NULL default '0',   PRIMARY KEY  (`last_checked`) ) ENGINE=MyISAM;   DROP TABLE IF EXISTS `user_online`; CREATE TABLE `user_online` (   `session` char(100) NOT NULL,   `time` int(11) DEFAULT '0' NOT NULL ) ENGINE=MyISAM;   DROP TABLE IF EXISTS `poll`; CREATE TABLE `poll` (   `poll_id` int(11) NOT NULL auto_increment,   `topic_id` int(11) NOT NULL,   `starter_id` varchar(255) default '',   `last_vote_date` varchar(255) default '',   `poll_question` varchar(255) default '',   `choice1` text,   `choice2` text,   `choice3` text,   `choice4` text,   `choice5` text,   `choice6` text,   `choice7` text,   `choice8` text,   `choice9` text,   `choice10` text,   PRIMARY KEY  (`poll_id`) ) ENGINE=MyISAM;   DROP TABLE IF EXISTS `poll_vote`; CREATE TABLE `poll_vote` (   `poll_id` int(11) NOT NULL auto_increment,   `topic_id` int(11) NOT NULL,   `vote1` int(11) default '0',   `vote2` int(11) default '0',   `vote3` int(11) default '0',   `vote4` int(11) default '0',   `vote5` int(11) default '0',   `vote6` int(11) default '0',   `vote7` int(11) default '0',   `vote8` int(11) default '0',   `vote9` int(11) default '0',   `vote10` int(11) default '0',   PRIMARY KEY  (`poll_id`) ) ENGINE=MyISAM;   DROP TABLE IF EXISTS `voters`; CREATE TABLE `voters` (   `vid` int(11) NOT NULL auto_increment,   `ip_address` varchar(255) default '',   `vote_date` varchar(255) default '',   `topic_id` varchar(255) default '',   `member_id` varchar(255) default '',   PRIMARY KEY  (`vid`) ) ENGINE=MyISAM;   DROP TABLE IF EXISTS `groups`; CREATE TABLE `groups` (   `g_id` int(11) NOT NULL auto_increment,   `g_title` varchar(32) default '',   `g_img` varchar(255) default '',   `g_color` varchar(255) default '',   `g_view_board` tinyint(1),   `g_post_new_topics` tinyint(1),   `g_post_polls` tinyint(1),   `g_vote_polls` tinyint(1),   `g_edit_topics` tinyint(1),   `g_edit_posts` tinyint(1),   `g_delete_topics` tinyint(1),   `g_delete_posts` tinyint(1),   `g_move_topics` tinyint(1),   `g_file_upload` tinyint(1),   `g_avatar_upload` tinyint(1),   `g_pinned_topics` tinyint(1),   `g_closed_topics` tinyint(1),   `g_read_news` tinyint(1),   `g_read_privilege` tinyint(1),   `g_add_news` tinyint(1),   `g_add_privilege` tinyint(1),   `g_edit_news` tinyint(1),   `g_edit_privilege` tinyint(1),   `g_delete_news` tinyint(1),   `g_delete_privilege` tinyint(1),   `g_delete_id` tinyint(1),   `g_view_lastestcp` tinyint(1),   `g_view_adminmenu` tinyint(1),   `g_view_topic_option` tinyint(1),   `g_upload_nonlimit` int(11),   `g_post_closed_topics` tinyint(1),   `g_non_showip` tinyint(1),   `g_no_delay_posts` tinyint(1),   `g_view_userip` tinyint(1),   `g_searching_id` tinyint(1),   `g_edit_rank_title` tinyint(1),   `g_edit_mes_control` tinyint(1),   `g_forum_manage` tinyint(1),   `g_account_manage` tinyint(1),   PRIMARY KEY  (`g_id`) ) ENGINE=MyISAM; INSERT INTO `groups` VALUES (1,'Guest','guest.gif','',1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); INSERT INTO `groups` VALUES (2,'Member','member.gif','',1,1,1,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); INSERT INTO `groups` VALUES (3,'Banned','banned.gif','gray',1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); INSERT INTO `groups` VALUES (4,'Sub Admin','sub_admin.gif','green',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,0,1,0,0,0,1,1,1,1,1,1,1,1,0,0,0,0); INSERT INTO `groups` VALUES (5,'Administrator','admin.gif','red',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);   DROP TABLE IF EXISTS `query_log`; CREATE TABLE `query_log` (   `action_id` int(11) NOT NULL auto_increment,   `Date` datetime NOT NULL default '0000-00-00 00:00:00',   `User` varchar(24) NOT NULL default '',   `IP` varchar(20) NOT NULL default '',   `page` varchar(24) NOT NULL default '',   `query` text NOT NULL,   PRIMARY KEY  (`action_id`),   KEY `action_id` (`action_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1;   DROP TABLE IF EXISTS `ranking_ignore`; CREATE TABLE `ranking_ignore` (   `account_id` int(11) NOT NULL default '0',   PRIMARY KEY  (`account_id`) ) ENGINE=MyISAM;   DROP TABLE IF EXISTS `security_code`; CREATE TABLE `security_code` (   `sc_id` text NOT NULL,   `sc_code` varchar(11) NOT NULL default '0',   `sc_time` int(11) NOT NULL default '0' ) ENGINE=MyISAM;   DROP TABLE IF EXISTS `rank_title`; CREATE TABLE `rank_title` (   `title_id` int(11) NOT NULL auto_increment,   `title` varchar(255) NOT NULL default '0',   `min_post` int(11) NOT NULL default '0',   PRIMARY KEY  (`title_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1; INSERT INTO `rank_title` VALUES (1,'Baby',0); INSERT INTO `rank_title` VALUES (2,'Child',10); INSERT INTO `rank_title` VALUES (3,'Adult',30); INSERT INTO `rank_title` VALUES (4,'Major',50); INSERT INTO `rank_title` VALUES (5,'Colonel',100); INSERT INTO `rank_title` VALUES (6,'General',200); INSERT INTO `rank_title` VALUES (7,'Sir',350); INSERT INTO `rank_title` VALUES (8,'Baron',600); INSERT INTO `rank_title` VALUES (9,'Marquis',900); INSERT INTO `rank_title` VALUES (10,'King',1200);   DROP TABLE IF EXISTS `register_log`; CREATE TABLE `register_log` (   `reg_id` int(11) NOT NULL auto_increment,   `Date` datetime NOT NULL default '0000-00-00 00:00:00',   `account_id` int(11) unsigned NOT NULL,   `userid` varchar(23) NOT NULL default '',   `level` tinyint(3) NOT NULL default '0',   `ip` varchar(100) NOT NULL default '',   PRIMARY KEY  (`reg_id`),   KEY (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 ;   DROP TABLE IF EXISTS `memory`; CREATE TABLE `memory` (   `memory_id` int(11) NOT NULL auto_increment,   `memory_object` varchar(255) default '',   `memory_value1` varchar(255) default '',   `memory_value2` varchar(255) default '',   `memory_value3` text,   PRIMARY KEY  (`memory_id`) ) ENGINE=MyISAM;   INSERT INTO `memory` (memory_object,memory_value1) VALUES ('sgcp_install','1'); INSERT INTO `memory` (memory_object,memory_value1) VALUES ('ro_message','Administrator'); INSERT INTO `memory` (memory_object,memory_value1,memory_value2,memory_value3) VALUES ('forum_category','1','1','A Test Category');

Hi thecandymachine,
 
Don't believe you can use webhost000 for FluxCP hosting, they disallow external SQL connection; so you'll end up with a PDO Exception error when trying to install it.
 
WAMP shouldn't have done anything to your SQL server, unless it overwrote your previous installation of MySQL. I would suggest you simply back up the database you need, re-install WAMP and then restore your database from those backups.

Hi yudi91,
Ignore mrlongshen, that link is for clients and not the rAthena repo. The correct link is; http://svn.code.sf.net/p/rathena/svn/trunk/

Hi mrlongshen,
Just create a symbolic link...

ln -sf /root/www /var/www/html

Hi baconator,
 
I believe this guide may help you out; https://asurahosting.com/forum/index.php?/topic/13-fluxcp-installation-for-cpanel-webhost/
 
As a recommendation, I would suggest that you use Xantara's FluxCP for rAthena.

Hi o GM Mark o,
 
The issue is that you are missing the 'athena-start' file, which is why it says that it can not be found. You should download it again with this command...
wget http://svn.code.sf.net/p/rathena/svn/trunk/athena-start  
Then you need to run this command to make sure it's executable...
chmod +x *start  
So now when you run './athena-start start', it should work just fine.


Hi o GM Mark o,
 
This may be because you uploaded it from your Windows computer which is in DOS format, and so you need to convert the file to UNIX. Use this command to do so;
dos2unix FILENAME

Hi kodak,
 
If you mean to say that you are trying to host your website on your own computer, I would recommend that you make sure that you have a static IP and not a dynamic IP; otherwise this would be completely useless.
 
You can set an A-record for your domain, in your domain provider's control panel to your WAN static IP. Then this would point your domain to your computer.

Hi Will,
Since you are using nGinx; it's fine to set public files' permissions to '0777', should not be an issue... especially since you're on your own private webhost and it's not shared webhosting.

Hi fredou81,
Why would you use SMTP for FluxCP if you are hosted with us? You can just use the PHP Mail function, and it would work absolutely fine. Just switch 'UseSMTP' to false.

Hi jordan,
You need to edit the '/config/servers.php' file inside your FluxCP, and put the correct MySQL information. Since you are hosting the MySQL information on your own PC, you must use your PC's IP (whatismyip.com) instead of 'localhost'. And you must port forward (portforward.com) 3306 for your PC in order to allow your webhost to connect to your MySQL server.

Hi rexxar31,
As mleo1 has already stated, there are guides already available for people to learn how to use Linux in hosting their rAthena Project. But I'd like to add this guide I found, it enables you to have a desktop interface for easier use; so it's closer to what you are use to (i.e. - Windows/Apple).
http://rathena.org/b...-w-rathena-vnc/
Hi emong,
Linux is better than Windows in terms of hosting an RO server. It's easier to perform backups, saves on RAM/CPU resources, allows a lot more functionality, and is a very barebone operating system. Windows is easier to use for users who are not familiar with Linux.
Hi mleo1,
Here is a great site for you to download a perl script to analyze your MySQL setup. It also gives you solutions to help optimize your MySQL process.
http://mysqltuner.pl/mysqltuner.pl