SQL I need fast help!
 

My problem is:
"
11/17/2016 - 10:01:35: [SM] [0] SetFailState
L 11/17/2016 - 10:01:35: [SM] [1] Line 41, include/shopsms/error.inc::ShopThrowError
L 11/17/2016 - 10:01:35: [SM] [2] Line 43, include/shopsms/db.inc::db_ConnectToDatabase
L 11/17/2016 - 10:01:35: [SM] [4] Database.Connect
L 11/17/2016 - 10:01:35: [SM] [5] Line 28, include/shopsms/db.inc::ConnectToDatabase
L 11/17/2016 - 10:01:35: [SM] [6] Line 12, include/shopsms/db.inc::Db_OnPluginStart
L 11/17/2016 - 10:01:35: [SM] [7] Line 140, /home/seek/coding/shop-sms/shop-sms-sm/scripting/shopsms.sp::OnPluginStart
L 11/17/2016 - 10:01:36: [multi1v1.smx] Could not connect: [2013]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111
L 11/17/2016 - 10:01:37: [multi1v1.smx] Could not connect: [2013]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111
L 11/17/2016 - 10:01:47: [multi1v1.smx] Could not connect: [2013]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111
"

and my datebase.cfg is :
"
"Databases"
{
"driver_default" "mysql"

// When specifying "host", you may use an IP address, a hostname, or a socket file path

"default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
"pass" "***"
//"timeout" "0"
//"port" "0"
}


"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}

"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" "***"
//"timeout" "0"
//"port" "0"
}
"multi1v1"
{
"driver" "mysql"
"host" "localhost"
"database" "game_servers_database"
"user" "root"
"pass" ""
"timeout" "10"
// "port" "3306"
}


"shopsms"
{
"driver""mysql"
"host""localhost"
"database""c0sklep"
"user""root"
"pass" ""
//"timeout""10"
//"port""3306"
}




}
"

Shopsms cant connect to database but not only shopsms Multi1vs1 cant connect too :c why ?


Debian 8

Re: SQL I need fast help!
 

11/17/2016 - 09:51:57: [multi1v1.smx] Could not connect: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 11/17/2016 - 09:51:59: [multi1v1.smx] Could not connect: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 11/17/2016 - 09:52:09: [multi1v1.smx] Could not connect: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Re: SQL I need fast help!
 

Do you have a mysql server running on the same machine as your gameserver runs on? You might want to try using sqlite instead, if the plugins support it.

Re: SQL I need fast help!
 

Yes on the same machine but this plugins use mysql and i have instaled it but it is'n working

Re: SQL I need fast help!
 

https://wklej.to/BZulI Help please!

Re: SQL I need fast help!
 

Best guess would be the MySQL server is crashing (possibly running out of memory? Quite common, especially if you're using a VPS). If you're running under linux, check "var\log\mysql\error.log" for any hints.

Re: SQL I need fast help!
 

Probably missing linux files for MySQL extension to work. I had this issue before (Ubuntu) but I couldn't figure it out, ended up just reinstalling a different OS (Debian 7 x64) and it started working fine.

Re: SQL I need fast help!
 

i have debian 8

https://wklej.to/J4hRr
Log from "var\log\mysql\error.log"
What i must do? :c

Re: SQL I need fast help!
 

If you need to fix it right now temporarily you can export the databases and see if you can connect to a free database from here: https://db4free.net/ If not you know it's something to do with your sourcemod.
However this is NOT a permanent solution. Their DB's get wiped frequently, and you WILL loose your data.

Re: SQL I need fast help!
 

But look datbase work on my shop on website but not in game :/
this is my demo shop and there database work So what ? :c
http://csgo.allthebest.pl/sklep/