Jump to content
  • 0

Google Cloud VPS - Need some help here. ^^


Dracula

Question


  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  29
  • Reputation:   7
  • Joined:  05/12/12
  • Last Seen:  

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

 

 

Edited by MrDracula
Link to comment
Share on other sites

17 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  29
  • Reputation:   7
  • Joined:  05/12/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  42
  • Reputation:   0
  • Joined:  05/18/16
  • Last Seen:  

Your login_ip and char_ip is incorrect, it should be your VPS IP ADDRESS ex. 192.168.1.1 and subnet should be ex. 255.255.255.0:192.168.1.1:192.168.1.1
 

 

// 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

 

 

 

 

// 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

 

 

 

// 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

 

 

 

*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.*

 

You don't need to change the 127.0.0.1 IP if your database is intalled in VPS, you only need to change this if your database is in other host like webhosting.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  29
  • Reputation:   7
  • Joined:  05/12/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  24
  • Topics Per Day:  0.01
  • Content Count:  206
  • Reputation:   11
  • Joined:  12/06/11
  • Last Seen:  

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.

Edited by Keysito
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  42
  • Reputation:   0
  • Joined:  05/18/16
  • Last Seen:  

 

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.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  29
  • Reputation:   7
  • Joined:  05/12/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  42
  • Reputation:   0
  • Joined:  05/18/16
  • Last Seen:  

 

 

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

 

If changing OS still same result maybe it has prob with the VPS, I suggest you change your VPS host.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  29
  • Reputation:   7
  • Joined:  05/12/12
  • Last Seen:  

Report :

I got same result. I don't know how to play around with Google cloud VPS. If anyone willing to help me. I will give username and password to discover the VPS. Thanks for both of you guys. /no1

 

Anyone else? Thanks... /sob

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  42
  • Reputation:   0
  • Joined:  05/18/16
  • Last Seen:  

Report :

I got same result. I don't know how to play around with Google cloud VPS. If anyone willing to help me. I will give username and password to discover the VPS. Thanks for both of you guys. /no1

 

Anyone else? Thanks... /sob

 

Just a friendly reminder, never give your username and password to someone else. You can be help thru team viewer.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  29
  • Reputation:   7
  • Joined:  05/12/12
  • Last Seen:  

Changed to Ubuntu. Seems no luck at all.

 

Ubuntu.png

 

 

I also give full privileges to the pointed VPS-IP. 

 

Phpmyadmin.png

 

I do really need help here. I'm stuck and don't know how to get rid of socket #5 error 4. /help 

Edited by MrDracula
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  29
  • Reputation:   7
  • Joined:  05/12/12
  • Last Seen:  

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?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  51
  • Reputation:   4
  • Joined:  07/12/12
  • Last Seen:  

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 ;)

Edited by Felipe
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  24
  • Topics Per Day:  0.01
  • Content Count:  206
  • Reputation:   11
  • Joined:  12/06/11
  • Last Seen:  

Glad it works now this will be useful if some newbiews encounter this issue.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  13
  • Topics Per Day:  0.00
  • Content Count:  79
  • Reputation:   2
  • Joined:  04/27/16
  • Last Seen:  

Hi Everyone,

 

Also planning to avail google VPS, 

 

Maybe this already came on your mind :) 

 

- Is Google VPS offer full root access ? 

- How about for our website and patcher ? 

- Does Google VPS already has a DDOS Protection ? 

- Do you have any idea how much will it cost per month in running rathena with 100 user ? 

Link to comment
Share on other sites

  • 0

  • Group:  Developer
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  587
  • Reputation:   431
  • Joined:  01/26/16
  • Last Seen:  

- Is Google VPS offer full root access ? 

- How about for our website and patcher ? 

- Does Google VPS already has a DDOS Protection ? 

- Do you have any idea how much will it cost per month in running rathena with 100 user ? 

- Is Google VPS offer full root access ? 

    Yes

- How about for our website and patcher ? 

    You have to set up your site and patcher yourself as Google only provide the VPS for you.

- Does Google VPS already has a DDOS Protection ? 

    No, it's not their job.

- Do you have any idea how much will it cost per month in running rathena with 100 user ?

    Depends on your location and VPS spec you need. Go to Google's site to calculate it yourself.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  13
  • Topics Per Day:  0.00
  • Content Count:  79
  • Reputation:   2
  • Joined:  04/27/16
  • Last Seen:  

Anyone can help me about GoogleVPS via Discord ? 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  11
  • Topics Per Day:  0.00
  • Content Count:  35
  • Reputation:   1
  • Joined:  04/08/14
  • Last Seen:  

@Dracula @Secrets
Is google cloud is for around the world? i mean when i go google cloud i don't need to have proxy server?
If the google cloud does not have DDOS protection. Is there other way to apply the DDOS protect in google cloud? 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...