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

Server Can't Connect to SQL


Post New Thread Reply   
 
Thread Tools Display Modes
Maxximou5
AlliedModders Donor
Join Date: Feb 2013
Old 04-26-2017 , 14:47   Re: Server Can't Connect to SQL
Reply With Quote #11

Quote:
Originally Posted by africanspacejesus View Post
I will try that out, why would that work though? I'll grab the errors when I get home. I was going to yesterday until the MM:S broke but I think it got fixed already.
Quote:
127.0.0.1 is the loopback Internet protocol (IP) address also referred to as the localhost. The address is used to establish an IP connection to the same machine or computer being used by the end-user.
Maxximou5 is offline
africanspacejesus
Senior Member
Join Date: Nov 2016
Location: Bay Area, CA
Old 04-27-2017 , 20:13   Re: Server Can't Connect to SQL
Reply With Quote #12

Quote:
Originally Posted by Maxximou5 View Post
Did you try 127.0.0.1 ? Also tell us the actual error connection message.
PHP Code:
L 04/27/2017 17:09:14: [ttt\ttt_sql.smx] (OnConnectConnection to database failed: [2003]: Can't connect to MySQL server on '127.0.0.1' (10061)
UTIL_GetListenServerHost() called from a dedicated server or single-player game.
UTIL_GetListenServerHost() called from a dedicated server or single-player game.
L 04/27/2017 - 17:09:14: "African | S> Kara Fade<2><STEAM_1:0:54284444><>" STEAM USERID validated
L 04/27/2017 - 17:09:14: server_cvar: "sv_airaccelerate" "1111"
UTIL_GetListenServerHost() called from a dedicated server or single-player game.
PutClientInServer: no info_player_start on level
L 04/27/2017 - 17:09:17: "African | S> Kara Fade<2><STEAM_1:0:54284444><>" entered the game
L 04/27/2017 - 17:09:17: "African | S> Kara Fade<2><STEAM_1:0:54284444><Unassigned>" triggered "clantag" (value "")
L 04/27/2017 - 17:09:19: [ttt\ttt_sql.smx] We try again to connect to a database (Retry #1)!
L 04/27/2017 - 17:09:20: [ttt\ttt_sql.smx] (OnConnect) Connection to database failed: [2003]: Can'
t connect to MySQL server on '127.0.0.1' (10061)
L 04/27/2017 17:09:25: [ttt\ttt_sql.smxWe try again to connect to a database (Retry #2)!
Bad SetLocalAngularVelocity(0.000000,6859.417969,0.000000on Pigurt_TankTrain
L 04
/27/2017 17:09:26: [ttt\ttt_sql.smx] (OnConnectConnection to database failed: [2003]: Can't connect to MySQL server on '127.0.0.1' (10061)
L 04/27/2017 - 17:09:31: [ttt\ttt_sql.smx] We try again to connect to a database (Retry #3)!
L 04/27/2017 - 17:09:31: [ttt\ttt_sql.smx] Last chance with sqlite. Let me try it!
L 04/27/2017 - 17:09:32: [ttt\ttt_sql.smx] (SQL_Start) Error: [2003]: Can'
t connect to MySQL server on '127.0.0.1' (10061)
L 04/27/2017 17:09:32: [ttt\ttt_sql.smx] (SQL_StartDatabase failureCouldn't connect to "ttt"! 
I'm using this

PHP Code:
"ttt"
    
{
        
"driver"            "mysql" // mysql or sqlite
        
"host"                "127.0.0.1"
        "database"            "db48907"
        "user"                "db48907"
        "pass"                "*******"
        "port"            "3306"
    

Still not working
__________________
Taking paid plugin requests
africanspacejesus is offline
csgoservers
AlliedModders Donor
Join Date: Apr 2017
Old 04-28-2017 , 12:32   Re: Server Can't Connect to SQL
Reply With Quote #13

I doubt your csgo server and sql server are on the same box/ip.....
csgoservers is offline
africanspacejesus
Senior Member
Join Date: Nov 2016
Location: Bay Area, CA
Old 04-28-2017 , 19:31   Re: Server Can't Connect to SQL
Reply With Quote #14

Issue was fixed, I tried putting in the original info again and it magically worked...
__________________
Taking paid plugin requests
africanspacejesus 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 11:44.


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