Raised This Month: $32 Target: $400
 8% 

Sourcebans not connecting to DB


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
tickhf
Member
Join Date: Oct 2014
Old 04-21-2015 , 12:59   Sourcebans not connecting to DB
Reply With Quote #1

L 04/22/2015 - 0286: [sourcebans.smx] Database failure: [1045]: Access denied for user 'defianc1_tick'@'119.252.190.241' (using password: YES). See FAQ: http://www.sourcebans.net/node/20

When I have this placed in my databases.cfg

HTML Code:
	"sourcebans"
	{
		"driver"			"default"
		"host"				"66.55.128.243"
		"database"			"defianc1_sourcebans"
		"user"				"defianc1_tick"
		"pass"				"xxxxxxx"
		//"timeout"			"0"
		"port"			"3306"
	}

I see its connecting through wrong ip?
tickhf is offline
DarkDeviL
SourceMod Moderator
Join Date: Apr 2012
Old 04-21-2015 , 13:25   Re: Sourcebans not connecting to DB
Reply With Quote #2

Quote:
Originally Posted by tickhf View Post
I see its connecting through wrong ip?
Could you explain what you mean there?

Every piece of software connects through server's primary interface unless they have been built (and instructed) to do otherwise.

You have two solutions;

a) Fix your MySQL server's access restrictions.
b) Fix your server's network configurations, so the one you wish to connect from is the default interface.
__________________
Mostly known as "DarkDeviL".

Dropbox FastDL: Public folder will no longer work after March 15, 2017!
For more info, see the [SRCDS Thread], or the [HLDS Thread].
DarkDeviL is offline
tickhf
Member
Join Date: Oct 2014
Old 04-21-2015 , 13:31   Re: Sourcebans not connecting to DB
Reply With Quote #3

Quote:
Originally Posted by arne1288 View Post
Could you explain what you mean there?

Every piece of software connects through server's primary interface unless they have been built (and instructed) to do otherwise.

You have two solutions;

a) Fix your MySQL server's access restrictions.
b) Fix your server's network configurations, so the one you wish to connect from is the default interface.
As you can see, i set it to connect through the 66. ip (in databases.cfg)

but in the error log, its trying to connect with 'defianc1_tick'@'119.252.190.241'
tickhf is offline
DarkDeviL
SourceMod Moderator
Join Date: Apr 2012
Old 04-21-2015 , 13:41   Re: Sourcebans not connecting to DB
Reply With Quote #4

Quote:
Originally Posted by tickhf View Post
As you can see, i set it to connect through the 66. ip (in databases.cfg)

but in the error log, its trying to connect with 'defianc1_tick'@'119.252.190.241'
You have set it to connect TO 66.55.128.243, and not (through / from) that address..

The MySQL server at the address 66.55.128.243 sees your connection to come from the IP address 119.252.190.241.

This is failing, which means either:

a) Your MySQL username or password is wrong
b) That MySQL username is not allowed to connect from 119.252.190.241.
__________________
Mostly known as "DarkDeviL".

Dropbox FastDL: Public folder will no longer work after March 15, 2017!
For more info, see the [SRCDS Thread], or the [HLDS Thread].
DarkDeviL is offline
Reply



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 01:56.


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