PDA

View Full Version : [Issue] Store can no longer connect to my database


Logifl3x
04-26-2013, 00:35
Ok, so ever since the SteamPipe update went live, my server hasn't been able to connect to my website's MySQL database.

meta version
Metamod:Source version 1.9.3-dev
Build ID: 816:9db5e81554dc-dev
Loaded As: Valve Server Plugin
Compiled on: Apr 16 2013
Plugin interface version: 15:14
SourceHook version: 5:
http://www.metamodsource.net/

meta list
[01] SourceMod (1.5.0-dev+3832) by AlliedModders LLC
[02] CS Tools (1.5.0-dev+3832) by AlliedModders LLC
[03] SDK Tools (1.5.0-dev+3832) by AlliedModders LLC
[04] SDK Hooks (1.5.0-dev+3832) by AlliedModders LLC
[05] SteamTools (0.8.3) by Asher Baker (asherkin)

sm version
SourceMod Version: 1.5.0-dev+3832
SourcePawn Engine: SourcePawn 1.1, jit-x86 (build 1.5.0-dev+3832)
SourcePawn API: v1 = 4, v2 = 4
Compiled on: Apr 16 2013 10:38:36
Build ID: 3832:8ac22e807fe5
http://www.sourcemod.net/

sm exts list
[01] Automatic Updater (1.5.0-dev+3832): Updates SourceMod gamedata files
[02] Webternet (1.5.0-dev+3832): Extension for interacting with URLs
[03] CS Tools (1.5.0-dev+3832): CS extended functionality
[04] BinTools (1.5.0-dev+3832): Low-level C/C++ Calling API
[05] SDK Tools (1.5.0-dev+3832): Source SDK Tools
[06] <FAILED> file "connect.ext.so": /usr/local/games/css/1020993/173.199.80.180:27015/css/cstrike/addons/sourcemod/extensions/connect.ext.so: cannot open shared object file: No such file or directory
[07] Top Menus (1.5.0-dev+3832): Creates sorted nested menus
[08] Client Preferences (1.5.0-dev+3832): Saves client preference settings
[09] SQLite (1.5.0-dev+3832): SQLite Driver
[10] GeoIP (1.5.0-dev+3832): Geographical IP information
[11] <FAILED> file "geoipcity.ext.so": /usr/local/games/css/1020993/173.199.80.180:27015/css/cstrike/addons/sourcemod/extensions/geoipcity.ext.so: cannot open shared object file: No such file or directory
[12] SDK Hooks (1.5.0-dev+3832): Source SDK Hooks
[13] <FAILED> file "smrcon.ext.so": /usr/local/games/css/1020993/173.199.80.180:27015/css/cstrike/addons/sourcemod/extensions/smrcon.ext.so: cannot open shared object file: No such file or directory
[14] Regex (1.5.0-dev+3832): Provides regex natives for plugins
[15] SMJansson (2.3.1/3): JSON parser/writer
[16] Socket (3.0.1): Socket extension for SourceMod
[17] SteamTools (0.8.3): SteamWorks for SourceMod.
[18] cURL Extension (1.3.0.0): cURL Extension
[19] MySQL-DBI (1.5.0-dev+3832): MySQL driver implementation for DBI

sm plugins list
01 "SMAC Client Protection" (0.8.4.0) by SMAC Development Team
02 "RankMe" (2.8.3) by lok1
03 "Admin Menu" (1.5.0-dev+3832) by AlliedModders LLC
04 "Anti-Flood" (1.5.0-dev+3832) by AlliedModders LLC
05 "Client Preferences" (1.5.0-dev+3832) by AlliedModders LLC
06 "SMAC Anti-Speedhack" (0.8.4.0) by SMAC Development Team
07 "SourceMod Anti-Cheat" (0.8.4.0) by SMAC Development Team
08 "[Store] Kill Awards" (1.1.1-alpha) by eXemplar
09 "Connect Announce" (1.6) by Arg!
10 "Redie 4 SourceMod" (1.3) by MeoW
11 "Basic Votes" (1.5.0-dev+3832) by AlliedModders LLC
12 "SMAC Rcon Locker" (0.8.4.0) by SMAC Development Team
13 "Reserved Slots" (1.5.0-dev+3832) by AlliedModders LLC
14 "Nextmap" (1.5.0-dev+3832) by AlliedModders LLC
15 "SMAC ConVar Checker" (0.8.4.1) by SMAC Development Team
16 "Basic Commands" (1.5.0-dev+3832) by AlliedModders LLC
17 "[Store] Chat Colors" (1.0-alpha) by Twisted|Panda
18 "[Store] Titles" (1.1-alpha) by alongub
19 <Error> "[Store] Backend" (1.1-alpha) by alongub
20 "[Store] Shop" (1.1-alpha) by alongub
21 "[Store] Refund" (1.1-alpha) by alongub
22 "[Store] Core" (1.1-alpha) by alongub
23 "[Store] Inventory" (1.1-alpha) by alongub
24 "[Store] Logging" (1.1-alpha) by alongub
25 "[Store] Distributor" (1.1-alpha) by alongub
26 "[Store] Gifting" (1.1-alpha) by alongub
27 "[Store] Loadout" (1.1-alpha) by alongub
28 "[Store] NadeTrails" (1.1-alpha) by Phault
29 "[Store] Tracers" (1.0.1) by Franc1sco steam: franug
30 "[Store] Name Colors" (1.0-alpha) by Twisted|Panda
31 "[Store] NadeSkins" (1.1-alpha) by Phault
32 "[Store] Weapon Colors" (1.1-alpha) by Phault
33 "Admin File Reader" (1.5.0-dev+3832) by AlliedModders LLC
34 "Web Shortcuts" (1.1) by Kyle Sanderson, Nicholas Hastings
35 "SMAC CS:S Anti-Rejoin" (0.8.2.2) by SMAC Development Team
36 "Simple Chat Processor (Redux)" (1.1.4-fix2) by Simple Plugins, Mini
37 "Advertisements" (0.6) by Tsunami
38 "Pinion Adverts" (1.12.15) by Multiple contributors
39 "Updater" (1.1.5) by GoD-Tony
40 "Basic Info Triggers" (1.5.0-dev+3832) by AlliedModders LLC
41 "[Source 2009] Custom Chat Colors" (2.4.1) by Dr. McKay
42 "Fun Commands" (1.5.0-dev+3832) by AlliedModders LLC
43 "Fun Votes" (1.5.0-dev+3832) by AlliedModders LLC
44 "SMAC Eye Angle Test" (0.8.4.0) by SMAC Development Team
45 "SMAC Command Monitor" (0.8.4.0) by SMAC Development Team
46 "SMAC Aimbot Detector" (0.8.4.0) by SMAC Development Team
47 "Player Commands" (1.5.0-dev+3832) by AlliedModders LLC
48 "Basic Comm Control" (1.5.0-dev+3832) by AlliedModders LLC
49 "Player Protection" (3.6.2) by Twisted|Panda
50 "Basic Chat" (1.5.0-dev+3832) by AlliedModders LLC
51 "SMAC AutoTrigger Detector" (0.8.4.0) by SMAC Development Team
52 "Admin Help" (1.5.0-dev+3832) by AlliedModders LLC
53 "Basic Ban Commands" (1.5.0-dev+3832) by AlliedModders LLC
54 "Sound Commands" (1.5.0-dev+3832) by AlliedModders LLC

The errors I'm getting in my log file is this:
ERROR | Connection to SQL database has failed, Reason: [2003]: Can't connect to MySQL server on 'my.host.ip' (110)

I know the first thing that someone would think is that there's something wrong with my database, but there isn't. My website's web panel is working perfectly fine and I'm able to edit player's items and credits but the server can no longer connect to it. Is this problem caused by the new SteamPipe update or have I done something wrong?

Thanks in advance,
Logifl3x

Nsk indian outlaw
04-26-2013, 00:43
please add me on steam InDiAn OuTlAw and postur databases.cfg

Logifl3x
04-26-2013, 01:05
I don't think posting my databases.cfg is going to do anything because I know that works fine. Since it worked perfectly until the SteamPipe update.

Arrow768
04-26-2013, 02:02
please add me on steam InDiAn OuTlAw and postur databases.cfg

Its stupid to solve a issue that can be solved via the forums, privately via steam because then other people with the same problem dont know how to solve it

I don't think posting my databases.cfg is going to do anything because I know that works fine. Since it worked perfectly until the SteamPipe update.

You dont need to post it, just check that the details are correct, because it seems like you have misconfigured your database host

Logifl3x
04-26-2013, 02:22
I have gone through it and nothing seems out of place. Like I said before, it was working fine until the SteamPipe update. I haven't actually changed any settings.

Arrow768
04-26-2013, 03:22
Have you entered my.host.ip in your database.cfg or have you entered your hosts ip ? - Cause the logfile says you have entered my.host.ip.

btw. its generally a bad idea to comment out logfiles (cause there is no really sensitive info inside and it slows down the help process; like passwords, ...)

Arrow768
04-26-2013, 03:22
Have you entered my.host.ip in your database.cfg or have you entered your hosts ip ? - Cause the logfile says you have entered my.host.ip.

btw. its generally a bad idea to comment out logfiles (cause there is no really sensitive info inside (like passwords, ...)and it slows down the help process)

Logifl3x
04-26-2013, 05:22
No that was just a replacement for when posting it here.

Logifl3x
04-29-2013, 19:50
Sorry to bump this but I noticed this when trying to check to see if all of my store plugins are running
[Store] Backend: PLUGIN STOPPED - Reason: reconnect counter reached max - PLUGIN STOPPED

Arrow768
04-30-2013, 06:36
[...]reconnect counter reached max[...]

Maybe you have exceeded your maximum sql connections ?!

Logifl3x
04-30-2013, 08:48
But I only have my web panel and server connected to it.

Arrow768
04-30-2013, 11:19
But I only have my web panel and server connected to it.

You should ask your Provider about this problem, he should be able to tell you if you have exceeded the connections (and you limit for them)