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

'MySQL Unable to connect to host'


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Geeza
Junior Member
Join Date: Feb 2016
Old 02-18-2016 , 13:47   'MySQL Unable to connect to host'
Reply With Quote #1

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?
Geeza is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 02-18-2016 , 14:29   Re: 'MySQL Unable to connect to host'
Reply With Quote #2

Remove the http:// >_>
__________________
asherkin is offline
Geeza
Junior Member
Join Date: Feb 2016
Old 02-18-2016 , 14:38   Re: 'MySQL Unable to connect to host'
Reply With Quote #3

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 is offline
Geeza
Junior Member
Join Date: Feb 2016
Old 02-18-2016 , 15:24   Re: 'MySQL Unable to connect to host'
Reply With Quote #4

Quote:
Originally Posted by asherkin View Post
Remove the http:// >_>
Still saying the same error.
Geeza is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 02-18-2016 , 15:27   Re: 'MySQL Unable to connect to host'
Reply With Quote #5

It literally can't be saying the same error since the http:// is part of the error message.
__________________
asherkin is offline
Geeza
Junior Member
Join Date: Feb 2016
Old 02-18-2016 , 15:31   Re: 'MySQL Unable to connect to host'
Reply With Quote #6

Quote:
Originally Posted by asherkin View Post
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
Geeza is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 02-18-2016 , 15:44   Re: 'MySQL Unable to connect to host'
Reply With Quote #7

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)?
__________________
asherkin is offline
Geeza
Junior Member
Join Date: Feb 2016
Old 02-18-2016 , 16:24   Re: 'MySQL Unable to connect to host'
Reply With Quote #8

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 is offline
Geeza
Junior Member
Join Date: Feb 2016
Old 02-18-2016 , 16:30   Re: 'MySQL Unable to connect to host'
Reply With Quote #9

I could try linking it into another database, hold up, ill try this one.
Geeza is offline
Rytis
Veteran Member
Join Date: Feb 2012
Location: Germany
Old 02-19-2016 , 07:30   Re: 'MySQL Unable to connect to host'
Reply With Quote #10

Is the database accessible from outside?
Rytis 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 00:20.


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