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

SQL I need fast help!


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
skullboypl
Junior Member
Join Date: Nov 2016
Old 11-17-2016 , 10:07   SQL I need fast help!
Reply With Quote #1

My problem is:
"
11/17/2016 - 10:015: [SM] [0] SetFailState
L 11/17/2016 - 10:015: [SM] [1] Line 41, include/shopsms/error.inc::ShopThrowError
L 11/17/2016 - 10:015: [SM] [2] Line 43, include/shopsms/db.inc::db_ConnectToDatabase
L 11/17/2016 - 10:015: [SM] [4] Database.Connect
L 11/17/2016 - 10:015: [SM] [5] Line 28, include/shopsms/db.inc::ConnectToDatabase
L 11/17/2016 - 10:015: [SM] [6] Line 12, include/shopsms/db.inc:b_OnPluginStart
L 11/17/2016 - 10:015: [SM] [7] Line 140, /home/seek/coding/shop-sms/shop-sms-sm/scripting/shopsms.sp::OnPluginStart
L 11/17/2016 - 10:016: [multi1v1.smx] Could not connect: [2013]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111
L 11/17/2016 - 10:017: [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
skullboypl is offline
skullboypl
Junior Member
Join Date: Nov 2016
Old 11-17-2016 , 10:08   Re: SQL I need fast help!
Reply With Quote #2

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)
skullboypl is offline
Peace-Maker
SourceMod Plugin Approver
Join Date: Aug 2008
Location: Germany
Old 11-17-2016 , 10:31   Re: SQL I need fast help!
Reply With Quote #3

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.
__________________
Peace-Maker is offline
skullboypl
Junior Member
Join Date: Nov 2016
Old 11-17-2016 , 10:44   Re: SQL I need fast help!
Reply With Quote #4

Yes on the same machine but this plugins use mysql and i have instaled it but it is'n working
skullboypl is offline
skullboypl
Junior Member
Join Date: Nov 2016
Old 11-17-2016 , 12:10   Re: SQL I need fast help!
Reply With Quote #5

https://wklej.to/BZulI Help please!
skullboypl is offline
dubbeh
Senior Member
Join Date: Jul 2007
Old 11-17-2016 , 13:02   Re: SQL I need fast help!
Reply With Quote #6

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.
__________________
SM Plugins - dubbeh.net - Plugin requests are welcome
dubbeh is offline
Mitchell
~lick~
Join Date: Mar 2010
Old 11-17-2016 , 13:38   Re: SQL I need fast help!
Reply With Quote #7

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.
Mitchell is offline
skullboypl
Junior Member
Join Date: Nov 2016
Old 11-17-2016 , 13:49   Re: SQL I need fast help!
Reply With Quote #8

i have debian 8

https://wklej.to/J4hRr
Log from "var\log\mysql\error.log"
What i must do? :c
skullboypl is offline
thomasjosif
AlliedModders Donor
Join Date: Mar 2016
Old 11-17-2016 , 14:37   Re: SQL I need fast help!
Reply With Quote #9

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.
__________________
Systems Admin @ http://hellsgamers.com
thomasjosif is offline
skullboypl
Junior Member
Join Date: Nov 2016
Old 11-17-2016 , 15:13   Re: SQL I need fast help!
Reply With Quote #10

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/
skullboypl 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 06:51.


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