Jump to content

Dracula

Members
 View Profile  See their activity

  • Posts

    28

  • Joined

  • Last visited

 Content Type 

Posts posted by Dracula

    Ragnarok Hosting on Google Cloud

    in General Support

    Posted

    Yep, i'm one of users who use Google Cloud. What about it you want to know?  /pat

     

    Until now, I'm not facing any problem since the users can create and delete the project that they created. I recommended you to use the Trial they provide. You just pay it for a Dollar and they give you 60 days for the Trial. 

     

    In your account, you will be credited 300$ as a fund to use inside Google Cloud. They have many specification of hardware and you can choose any one of it. For my project, I'm using a minimum specs that meets rAthena Emulator requirements to make it on-line.

     

    One important thing is (for me), users can choose their desire network location. I'm taking an Asian region as my network location. It will make perfect connection for people around Asia. A low ping and smooth connection, that is what gamers and developers need. 

     

    That's all. Anything else? Try to explore it more. /heh

     

    Good luck. /no1

    Google Cloud VPS - Need some help here. ^^

    in Linux Support

    Posted

    Did you try to start all process with root ? Including MySQL and rAthena

     

    And

     

    I guess have a process already making connection, try to Kill everything related to MySQL. I think you can try MariaDB maybe work.

     

    @edit:

    I've a issue like this, I change for a FreeBSD based, idk you experience with FreeBSD or OpenBSD but let's give a try ;)

     

    Yeah, totally made sense! I can see the connection been interrupted and in progress. Thanks! I'll post it here once I have done! /no1

    Problem solved!

    Thanks to @Stolao and @Dastgir !

     

    If you encounter a problem such like this or anything problem related to the rA Emu. Direct go to this link (CLICK ME) and ask for help in there. For sure they will helped you out with your problem.

     

    Okay this is what they've told me to do :-

     

     

    1 : char_athena.conf

    // Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
login_ip: VPS WAN-IP Changed TO 127.0.0.1

// The character server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Login Server Port
login_port: 6900

// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
char_ip: VPS WAN-IP < Stick with WAN-IP

// Character Server Port
char_port: 6121

    2 : map_athena.conf

    // Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
char_ip: VPS WAN-IP Changed TO 127.0.0.1

// The map server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Character Server Port
char_port: 6121

// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
map_ip: VPS WAN-IP < Stick with WAN-IP

// Map Server Port
map_port: 5121

    3 : subnet_athena.conf

    // Subnet support file
// Format is:
// subnet: net-submask:char_ip:map_ip
// you can add more than one subnet (max 16)
// check is if((net-submask & char_ip ) == (net-submask & servip)) => ok

subnet: 255.0.0.0:VPS WAN-IP:VPS WAN-IP

Changed TO

subnet: 255.255.255.0:WAN-IP:WAN-IP

    4 : inter_athena.conf

    // MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: Everything-remain-the-same
login_server_pw: Everything-remain-the-same
login_server_db: Everything-remain-the-same
login_codepage:
login_case_sensitive: no

ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: Everything-remain-the-same
ipban_db_pw: Everything-remain-the-same
ipban_db_db: Everything-remain-the-same
ipban_codepage:

// MySQL Character server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: Everything-remain-the-same
char_server_pw: Everything-remain-the-same
char_server_db: Everything-remain-the-same

// MySQL Map Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: Everything-remain-the-same
map_server_pw: Everything-remain-the-same
map_server_db: Everything-remain-the-same

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: Everything-remain-the-same
log_db_pw: Everything-remain-the-same
log_db_db: Everything-remain-the-same
log_codepage:
log_login_db: loginlog

    If your port can't be detect, do check your VPS Firewall. In my case, I just change Source filter from IP Ranges to Allow from any source (0.0.0.0/0) and of course you have to add the port in Firewall rules to make it available for you to connecting it. 

     

    Untitled.png

     

    You also can check your port is being close/open at this link (CLICK ME). Just if your case same like mine so this post will be useful for you.  /ok

     

    Thanks all of you.  /bo

    Google Cloud VPS - Need some help here. ^^

    in Linux Support

    Posted

    BUMP!

     

    Anyone who interested to explore Google Cloud? Hmmm. I couldn't find any solution until now.


    Report : 

     

    Successful installing ZPanel, and I tried to enter phpMyadmin from ZPanel. But come out with same output. (Socket #5, error 115. Operation progress)! and (Socket #5, error 4: Interrupted call)!

     

    Any ideas?

    Google Cloud VPS - Need some help here. ^^

    in Linux Support

    Posted

    Check your inter_athena.conf

    For MYSQL connection. database and your root access. If u have successfully apply those map and char server without apply the inter U can't able to connect the server .

    if u know, how to run an offline test server its just same thing. Only need to changes VPS address and sql db etc etc.

     

    That's what I do and see if the changes could solve my problem but no. Thanks for the help. /no1 

     

    Yep, I already change my Login, Char and Map-server IP but no chance to get connect to the server. I just replace my IP with that word *VPS WAN-IP* /heh
     
    Anyone? /hmm

     

     

    I see, how about upgrading your OS to CentOS 7 then install it again or your vps has an issue.

     

     

    Same result bro. /swt I want to try out with Debian (MariaDB). I'll post here right after I've done. Thanks for your help bro. /no1

    Google Cloud VPS - Need some help here. ^^

    in Linux Support

    Posted · Edited by MrDracula

    Hello guys.  /bo 

    Is there anyone who already try Google CloudVPS? I just get it yesterday as I want to try the hosting and thinking about to run rAthena Emu with this VPS. I've tried many times in creating the project and it worked. I mean delete, resetting the storage and the other things work just fine but unfortunately I couldn't make a connection with MySQL and Char server keep showing the error.  /x

    Desktop.png
     

    Char_athena.conf 
    // Athena Character configuration file.

// Note: "Comments" are all text on the right side of a double slash "//"
// Whatever text is commented will not be parsed by the servers, and serves
// only as information/reference.

// Server Communication username and password.
userid: rathuser
passwd: rathpasswd

// Server name, use alternative character such as ASCII 160 for spaces.
// NOTE: Do not use spaces or any of these characters which are not allowed in
//       Windows filenames \/:*?"<>|
//       ... or else guild emblems won't work client-side!
server_name: rAthena

// Wisp name for server: used to send wisp from server to players (between 4 to 23 characters)
wisp_server_name: Server

// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
login_ip: VPS WAN-IP

// The character server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Login Server Port
login_port: 6900

// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
char_ip: VPS WAN-IP

// Character Server Port
char_port: 6121

    Map_athena.conf

    //--------------------------------------------------------------
//rAthena Map-Server Configuration File
//--------------------------------------------------------------

// Note: "Comments" are all text on the right side of a double slash "//"
// Whatever text is commented will not be parsed by the servers, and serves
// only as information/reference.

//--------------------------------------------------------------
//                     Configuration Info
//--------------------------------------------------------------
// Interserver communication passwords, set in account.txt (or equiv.)
userid: rathuser
passwd: rathpasswd

// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
char_ip: VPS WAN-IP

// The map server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Character Server Port
char_port: 6121

// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
map_ip: VPS WAN-IP

// Map Server Port
map_port: 5121

    Subnet_athena.conf

    // Subnet support file
// Format is:
// subnet: net-submask:char_ip:map_ip
// you can add more than one subnet (max 16)
// check is if((net-submask & char_ip ) == (net-submask & servip)) => ok

subnet: 255.0.0.0:VPS WAN-IP:VPS WAN-IP

    *I also try to change subnet from 255.255.255.0 and result remain the same. No changes at all.*

     

    Inter_athena.conf

    // MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: root
login_server_pw: YourPassword
login_server_db: rathena_rag
login_codepage:
login_case_sensitive: no

ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: root
ipban_db_pw: YourPassword
ipban_db_db: rathena_rag
ipban_codepage:

// MySQL Character server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: root
char_server_pw: YourPassword
char_server_db: rathena_rag

// MySQL Map Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: root
map_server_pw: YourPassword
map_server_db: rathena_rag

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: root
log_db_pw: YourPassword
log_db_db: rathena_log
log_codepage:
log_login_db: loginlog

    *Same goes to this, I try already switch the IP to VPS WAN-IP and much worst I get is, I never get connect to the server.*

     

     

    IPtables -L

     

    Iptables.png

     

     
    I'm using centos 6 and followed everything in detail what must and what mustn't to complete the emu installation. It's kinda weird for me because I never face such an error when installing an emu on a VPS.  /hum
     
     Well, this is my first year after being away from Ragnarok about 6 years. Well, specifically is not entire Ragnarok world, I also following, reading and talking about Ragnarok in that days.  /meh
     
    I hope someone will help me to solve my problem. I'm thinking to make a Beta Test Server for the beginning.  /ok
     
    Thank you rAthena community, thank you.  /no1

     

     

    Server status and Online player for wordpress web theme

    in Web Support

    Posted

     

     

     

    i guess they just wrote their custom SQL statement to retrieve the info at the top of the header .

     

    references : http://www.w3schools.com/php/php_mysql_select.asp

     

    Possible SQL Query

    SELECT COUNT(`char_id`) FROM `char` WHERE `online` = 1

     

    Thanks for the reply Emistry. But then, wordpress was based on HTML code, the code as mentioned in the above link reference is based on php. I think it wont work if i add those code & statement.

    Well, i manage to add the status online using a simple coding. However now looking foward to add Player Online.. Got any idea?

     

    Capture.png

    Nvm. Got it done by a help from my friend .. server status and player online done  :)

     

    Capture123.png

     

    Hope there is more active member in this community to help around in the future..

     

     

    Hi Ace, can u share for code please ?

     

     

    The code is already up above your post bud.  /no1 

     

    SELECT COUNT(`char_id`) FROM `char` WHERE `online` = 1
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.

  I accept