AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   SourceBans / SourceBans++ (https://forums.alliedmods.net/forumdisplay.php?f=152)
-   -   'MySQL Unable to connect to host' (https://forums.alliedmods.net/showthread.php?t=279248)

Geeza 02-18-2016 13:47

'MySQL Unable to connect to host'
 
Hello, I am setting up sourcemods for a friend's server, and this pops up in the sourcemod logs:

L 02/18/2016 - 16:40:43: [sourcebans.smx] Database failure: [2005]: Unknown MySQL server host 'http://wisdom-hotel.org' (1). See FAQ: http://www.sourcebans.net/node/20
L 02/18/2016 - 16:55:12: [sourcebans.smx] Database failure: [2005]: Unknown MySQL server host 'http://wisdom-hotel.org' (1). See FAQ: http://www.sourcebans.net/node/20


I am hosting this Sourcebans upon a VPS where the database is using the VPS's MySQL.

Does anyone know how to make it be able to connect to the mysql?

asherkin 02-18-2016 14:29

Re: 'MySQL Unable to connect to host'
 
Remove the http:// >_>

Geeza 02-18-2016 14:38

Re: 'MySQL Unable to connect to host'
 
Hey, i've tried that, i haven't got any other logs within this..

For some reason, when i try to ban someone, it doesnt record in the Sourcebans i have set up, do you know the reason why? It's connected to the server.

Geeza 02-18-2016 15:24

Re: 'MySQL Unable to connect to host'
 
Quote:

Originally Posted by asherkin (Post 2394228)
Remove the http:// >_>

Still saying the same error.

asherkin 02-18-2016 15:27

Re: 'MySQL Unable to connect to host'
 
It literally can't be saying the same error since the http:// is part of the error message.

Geeza 02-18-2016 15:31

Re: 'MySQL Unable to connect to host'
 
Quote:

Originally Posted by asherkin (Post 2394247)
It literally can't be saying the same error since the http:// is part of the error message.

My Mistake, this is the error;

L 02/18/2016 - 20:22:48: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on 'wisdom-hotel.org' (114). See FAQ: http://www.sourcebans.net/node/20

asherkin 02-18-2016 15:44

Re: 'MySQL Unable to connect to host'
 
Hmm, error code 114 doesn't really make sense in this context - are you sure you're meant to be accessing the MySQL server at that domain/port (and that it allows remote connections)?

Geeza 02-18-2016 16:24

Re: 'MySQL Unable to connect to host'
 
The domain is that, that is the domain that links to the VPS IP, i have tried using the VPS IP as the host but that doesnt seem to connect either, MySQL is installed on the VPS and the database is set up, all working apart from it isnt connecting to the database.

Geeza 02-18-2016 16:30

Re: 'MySQL Unable to connect to host'
 
I could try linking it into another database, hold up, ill try this one.

Rytis 02-19-2016 07:30

Re: 'MySQL Unable to connect to host'
 
Is the database accessible from outside?


All times are GMT -4. The time now is 11:38.

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