Raised This Month: $12 Target: $400
 3% 

Bans not showing on sourceban page


Post New Thread Reply   
 
Thread Tools Display Modes
YamiKaitou
Has a lovely bunch of coconuts
Join Date: Apr 2006
Location: Texas
Old 11-10-2012 , 20:55   Re: Bans not showing on sourceban page
Reply With Quote #21

Um, it seems that nobody is getting to the real problem here. The Game Server is unable to even open the initial connection to you MySQL Server. So, either you are telling the GS to connect to the wrong IP or you have a firewall somewhere (either the source or the destination or inbetween) that is blocking the port.

I would start by checking your firewall settings on your VPS
__________________
ProjectYami Laboratories

I do not browse the forums regularly anymore. If you need me for anything (asking questions or anything else), then PM me (be descriptive in your PM, message containing only a link to a thread will be ignored).
YamiKaitou is offline
jsterling
SourceMod Donor
Join Date: Mar 2004
Location: Denver, CO, USA
Old 11-10-2012 , 22:01   Re: Bans not showing on sourceban page
Reply With Quote #22

Quote:
Originally Posted by YamiKaitou View Post
Um, it seems that nobody is getting to the real problem here. The Game Server is unable to even open the initial connection to you MySQL Server. So, either you are telling the GS to connect to the wrong IP or you have a firewall somewhere (either the source or the destination or inbetween) that is blocking the port.

I would start by checking your firewall settings on your VPS
I already asked about the firewall to which he responded there is none and I asked about making sure the IP was correct as well. I can see that it is refusing the initial connection but sourcebans also only gives a generic error output for pretty much every SQL error.

I tried to telnet his IP and port 3306 and it can't respond. Obviously my IP is not in his allowed hosts config but it should at least give a response telling me the connection was refused but it fails to even connect so either it is the wrong IP or there is some sort of firewall blocking it.

Only so much we can do if he says theres no firewall and the IP is correct. If I had to guess I would guess the IP is wrong.

Last edited by jsterling; 11-10-2012 at 22:05.
jsterling is offline
Send a message via AIM to jsterling
IcEWoLF
Senior Member
Join Date: Jul 2007
Old 11-10-2012 , 22:07   Re: Bans not showing on sourceban page
Reply With Quote #23

The IP is correct: 173.254.194.142 for my server.

I'll contact my host to see if they are using any external firewalls.
__________________
The 47 Ronin Gaming - http://www.47r-squad.com


IcEWoLF is offline
Bellicus
AlliedModders Donor
Join Date: Mar 2011
Location: Chicago
Old 11-11-2012 , 01:18   Re: Bans not showing on sourceban page
Reply With Quote #24

you need to edit the mysql config /etc/my.cnf via ssh using nano or vim and add this line to it.

bind-address=173.254.194.142 save and restart the mysql service in cpanel.

I had the same problem with my sourcebans before i did that.
Bellicus is offline
IcEWoLF
Senior Member
Join Date: Jul 2007
Old 11-11-2012 , 02:03   Re: Bans not showing on sourceban page
Reply With Quote #25

Quote:
Originally Posted by Bellicus View Post
you need to edit the mysql config /etc/my.cnf via ssh using nano or vim and add this line to it.

bind-address=173.254.194.142 save and restart the mysql service in cpanel.

I had the same problem with my sourcebans before i did that.

173.254.194.142 is not my game server IP, but the VPS server IP.

You mean the game server IP?
__________________
The 47 Ronin Gaming - http://www.47r-squad.com


IcEWoLF is offline
Bellicus
AlliedModders Donor
Join Date: Mar 2011
Location: Chicago
Old 11-11-2012 , 02:12   Re: Bans not showing on sourceban page
Reply With Quote #26

Nope, the Main IP of your VPS.
Bellicus is offline
YamiKaitou
Has a lovely bunch of coconuts
Join Date: Apr 2006
Location: Texas
Old 11-11-2012 , 07:56   Re: Bans not showing on sourceban page
Reply With Quote #27

Quote:
Originally Posted by jsterling View Post
I already asked about the firewall to which he responded there is none and I asked about making sure the IP was correct as well
You asked about the firewall in his web interface, not the one on the VPS. I have used hosts before that have a firewall on the parent server that I control using a web interface and then also allow me to use firewall software on my VPS, such as iptables.

Quote:
I can see that it is refusing the initial connection but sourcebans also only gives a generic error output for pretty much every SQL error.
But it isn't SourceBans that is producing the error but the MySQL Module. Also, that is the standard MySQL error message for when it fails to initiate the connection, regardless of the programming language

Quote:
Obviously my IP is not in his allowed hosts config but it should at least give a response telling me the connection was refused but it fails to even connect so either it is the wrong IP or there is some sort of firewall blocking it.
Right, except if your IP wasn't allowed to connect you would be getting a completely different error message

Quote:
Only so much we can do if he says theres no firewall and the IP is correct. If I had to guess I would guess the IP is wrong.
I would guess that iptables is running and blocking the connection or mysqld isn't even running
__________________
ProjectYami Laboratories

I do not browse the forums regularly anymore. If you need me for anything (asking questions or anything else), then PM me (be descriptive in your PM, message containing only a link to a thread will be ignored).
YamiKaitou is offline
IcEWoLF
Senior Member
Join Date: Jul 2007
Old 11-12-2012 , 03:36   Re: Bans not showing on sourceban page
Reply With Quote #28

We tried all of the above and nothing is working.
At this point I am wondering if I properly installed sourcebans from our end...
http://www.47r-squad.com/sourcebans/
__________________
The 47 Ronin Gaming - http://www.47r-squad.com


IcEWoLF is offline
IcEWoLF
Senior Member
Join Date: Jul 2007
Old 11-12-2012 , 04:44   Re: Bans not showing on sourceban page
Reply With Quote #29

Just wondering, I don't run the tradional MySQL, I run MariaDB 5.5.28, the installation went through fine so I don't this might be the issue...
__________________
The 47 Ronin Gaming - http://www.47r-squad.com


IcEWoLF is offline
YamiKaitou
Has a lovely bunch of coconuts
Join Date: Apr 2006
Location: Texas
Old 11-12-2012 , 13:17   Re: Bans not showing on sourceban page
Reply With Quote #30

I get a new error now when I attempt to connect to your SQL server, so you did something different.

Code:
ERROR 1130 (HY000): Host 'voyager' is not allowed to connect to this MariaDB server
I expected to see this message, so this means that it is working now
__________________
ProjectYami Laboratories

I do not browse the forums regularly anymore. If you need me for anything (asking questions or anything else), then PM me (be descriptive in your PM, message containing only a link to a thread will be ignored).
YamiKaitou is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 15:44.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode