Asura

Hi Xyndor, In your map/char/login conf files, do not use your LAN IP. Use your WAN IP for all the IP entries.

Hi Yoona, What is there to learn about NoIP? You simply set up an account, and install it on your computer. I would HIGHLY recommend that you actually take a look at NoIP's site before asking for "help help help" on something which is provided by the service creator; http://www.noip.com/support/

Hi Yoona, You'll need to use NoIP; http://www.noip.com/

Hi Everyone, Seems like it's a bug? Report it here; http://rathena.org/board/tracker/

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 Yoona, You should change the localhost to your IP; doesn't hurt. Also, make sure you are not using your LAN IP; '192.168.1.x', etc. It has to be your WAN IP for your friends to see your site; http://whatismyip.com Lastly, as I have said this before; your ISP may already be blocking you from hosting a web site. Please contact and review their terms.

Hi Yoona, Go to your own browser, and type "http://127.0.0.1". Can you see your own website? Also, your ISP may already be blocking your service from hosting a web site; there's no work around besides changing the port of your web server. Then you'd have to connect as such... http://x.x.x.x:y (replace x.x.x.x with your WAN IP, and y with your custom web server port) There's really no other way to host besides owning your own server, or renting a server. Some people do host from home, but that's because they have an ISP which allows them to.

Hi chatterboy, Look at what Patskie wrote. It's been said and done.

Hi Yoona,For public, I would not recommend it. However, if it's just between friends; then it would work just fine. Just remember your IP address is viewable to the public if you choose to do this, and also your ISP may have terms which prevent you from doing this; so please check that out before attempting.

Hi Yoona, You need to portforward port 80, but if you are hosting from your own PC; please remember that *most* internet service providers don't allow web hosting. Here is a website on how to portforward; http://portfoward.com After doing this, you can go to http://x.x.x.x (replace x.x.x.x with your IP address, to allow your friends/public to see your site).

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 Thor v2, Then I'd recommend that you contact your web hosting provider to see if they have port 465 opened. Why are you not using PHP to mail instead?

Hi GM RhaiB, Contact your host. --- Hi ccjosh, He may not be able to change the ownership if he doesn't have root privileges, which is the usual scenario.

Hi pachupappy1234, Simply just run the 2nd server via Terminal within VNC. All you have to do is set up a "trunk2" folder, configure it with different ports for login/char/map and then set it to use a 2nd database. After that, you'd open the Terminal within VNC by right-clicking the background and selecting "Terminal". Type the following commands in Terminal... To compile; cd /root/Desktop/trunk2 ./configure make clean make sql To start server; cd /root/Desktop/trunk2 ./athena-start start To stop server; cd /root/Desktop/trunk2 ./athena-start stop

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 Thor v2, Yep, that's correct.

Hi Thor v2, I am not sure about Russia, however, we have no issues with lag for Europe/Brazil/India. If interested, I would recommend trying out our Trial packages first; https://asurahosting.com/index.php?/cart/trial-service/ The DDoS Protected package located in Dallas is best for Brazil; however, if you are thinking of purchasing a package and want a Standard service: we can make sure you have a good connection to Brazil as well.

Hi Thor v2, Security is better on Linux than Windows. As long as you don't share your password, and you have an actual good password; you should be okay. Setting up the firewall is fairly easy, you can use CSF; http://configserver.com/cp/csf.html All you need to do is install it, and configure it by editing "/etc/csf/csf.conf"; everything is well explained for the options presented in that .conf file. After doing so; your Linux server is protected.

Hi Ron, No, you don't. To answer your initial question, to run a starter rAthena server w/ Harmony; At minimal, you should have... 512MB RAM 2 CPU Cores (varies, due to CPU Frequency Speed; but 2 for 2.5ghz+)

Hi nyks, Please do not private message me for support. I only provide community support on my free time. To access the FluxCP, you need a domain/sub-domain to be linked to your cPanel. Please contact your webhost in regards to this; it doesn't seem like you have a domain name linked properly. So if you have a domain purchased from Dynadot, you still need to set the name servers to what your webhoster provides you with; and also make sure the cPanel is using that domain name. It usually takes 2-24hours for the domain to fully propagate after a name server update. Hello there, i follow all the steps on the guide that you post, but why they cant see my files? Hi Yoona, This is too vague. Which guide did you follow?

Hi nyks, What is CpanelX? Is it this? http://cpanelx.us/ Here is a guide found on Google, on how to install and set up WAMPP step by step; http://techathena.com/tools/make-wamp-local-server-windows/ Here is a guide on how to configure FluxCP for installation; https://asurahosting.com/forum/index.php?/topic/13-fluxcp-installation-for-cpanel-webhost/

Hi Thor v2, It's simply because Linux is not resource hungry, and actually easy to use (once you spend a small time with it). Windows requires more CPU/RAM/IO to run as an operating system, which degrades the performance of your service. Linux is a minimal OS which does not require hardly any CPU/RAM/IO; for example... Debian Minimal only requires <20MB of RAM to run. So the resources of your server can be concentrated on other services you run on your server instead; such as an Athena emulator, MySQL, or a webserver. Installing on Windows requires you to search for installers for whatever you are trying to install (.exe/.msi/etc.), but with Linux; it's as easy as typing 1 line of command... For example; a Debian based OS uses 'apt-get', so you'd just type: apt-get install mysql-server. And that single command line, would install a MySQL server in 2-3 minutes on your service. Also, if you want a visual interface to move your mouse around for point n' click action; just install a Desktop Environment such as FluxBox (<15MB RAM), or GNOME (~120MB RAM). There are tons of Desktop Environments which vary in RAM usage, and you can choose what you want to easily install with the command line. Then simply use a program such as VNC Viewer to connect. Lastly; Linux Servers cost less than Windows Servers. There's no licensing fee for Linux OS, so it's cheaper to use.

Hi chatterboy, Not in this case. 000webhost generates a PDO Exception because it does not allow external SQL connections for their free hosting.

Hi dhanyru, If you are only hosting for your friends; consider using Hamachi. Otherwise, you can port forward by using this website to help guide you; http://portforward.com/ Make sure you portforward 6900, 6121, and 5121. For your /conf files, make sure you are using the WAN IP. You can find your WAN IP by visiting this website; http://whatismyip.com/

Hi Thor v2, To answer your question; I do not believe the server OS is the issue. Perhaps you do not have everything installed which is required to compile the emulator? As the other posters have mentioned; Linux is better, I would recommend that you consider switching.