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

Database Failure, Unable to connect to database.


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Moonblaze
New Member
Join Date: Feb 2016
Old 02-29-2016 , 23:36   Database Failure, Unable to connect to database.
Reply With Quote #1

I am currently trying to setup sourcebans++ with my gameservers, with my webserver as my database. However I am getting this error:

Code:
[sourcebans.smx] Database failure: [2013]: Lost connection to MySQL server at 'reading initial communication packet', system error 111
My first thought was my database details were incorrect, however I double checked the details. They are correct.
Code:
    "sourcebans"
    {
        "driver"            "mysql"
        "host"                "97.107.***.***"
        "database"            "bkg"
        "user"                "******"
        "pass"                "***********"
        //"timeout"            "0"
        "port"            "3306"
    }
I have starred out the important information, but rest assured, it is correct. I next thought that maybe that I didn't have port 3306 open, but I do. It should work as I run PHPMyAdmin on the webserver as well, and can connect there. I am unsure as to what is wrong, and have looked around the internet for solution that have already been posted and have not found a definitive answer. However, in addition to this post I will continue looking.
Moonblaze is offline
Moonblaze
New Member
Join Date: Feb 2016
Old 03-01-2016 , 02:30   Re: Database Failure, Unable to connect to database.
Reply With Quote #2

I found the issue. I actually found the answer in this stackoverflow post unrelated to sourcemod.

On my webserver, in the /etc/mysql/my.cnf, by default it was set to only allow connections via localhost.
Moonblaze 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 22:15.


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