Ошибка подключения к базе mysql

Groot

Участник
Сообщения
4
Реакции
0
Операционная система
Linux
Текст ошибки
L 10/31/2019 - 08:37:06: [sourcebans.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 10/31/2019 - 08:44:15: [sourcebans.smx] Verify Ban Query Failed: Can't connect to MySQL server on '46.174.50.9' (4)
L 10/31/2019 - 08:56:19: [sourcebans.smx] Verify Ban Query Failed: Can't connect to MySQL server on '46.174.50.9' (4)
L 10/31/2019 - 09:20:12: [sourcebans.smx] plugins/basebans.smx was unloaded and moved to plugins/disabled/basebans.smx
L 10/31/2019 - 09:20:13: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 10/31/2019 - 09:24:08: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 10/31/2019 - 09:29:50: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 10/31/2019 - 09:56:47: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 10/31/2019 - 10:28:50: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 10/31/2019 - 11:00:28: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 10/31/2019 - 11:32:24: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 10/31/2019 - 12:04:15: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 10/31/2019 - 12:36:40: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 10/31/2019 - 13:09:02: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 10/31/2019 - 13:41:07: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
L 10/31/2019 - 14:12:53: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4). See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/
Список мета-модулей
[01] SourceMod (1.9.0.6282) by AlliedModders LLC
[02] BanId Fix (1.0) by Phoenix (˙·٠●Феникс●٠·˙)
[03] SDK Tools (1.9.0.6282) by AlliedModders LLC
[04] CS Tools (1.9.0.6282) by AlliedModders LLC
[05] SDK Hooks (1.9.0.6282) by AlliedModders LLC
[06] DHooks (2.2.0) by Dr!fter
[07] PTaH (1.1.0) by Phoenix (˙·٠●Феникс●٠·˙)
Список плагинов SM
01 "AdminTag" (2.0) by KeepCalm
02 "SMAC ConVar Checker" (0.8.6.0) by SMAC Development Team
03 "Basic Commands" (1.9.0.6282) by AlliedModders LLC
04 "Basic Comm Control" (1.9.0.6282) by AlliedModders LLC
05 "[CR] Ammo" (2.0) by Someone
06 "SMAC Command Monitor" (0.8.6.0) by SMAC Development Team
07 "DR.API SHOW DAMAGE" (1.1.2) by Dr. Api
08 "Gloves" (1.0.3) by kgns | oyunhost.net
09 "Simple Chat Processor (Redux)" (1.1.5) by Simple Plugins, Mini
10 "[Levels Ranks] Core" (v3.0 SR1) by RoadSide Romeo & Wend4r
11 "NoZoom System" (1.0.9) by DUCK (vk.com/geliydaun)
12 "Particle Effects [VIP|SHOP]" (RC 10) by Phoenix (˙·٠●Феникс●٠·˙)
13 "Chat Colors CSGO" (1.3) by Pheonix (˙·٠●Феникс●٠·˙)
14 "SourceComms" ((SB++) 1.5.4.6) by Alex, Sarabveer(VEER™)
15 "[CR] Intervals" (2.0) by Someone
16 "SMAC Anti-Speedhack" (0.8.6.0) by SMAC Development Team
17 "Basic Votes" (1.9.0.6282) by AlliedModders LLC
18 "Roun End Gravity" (0.1) by Muvik
19 "Reserved Slots" (1.9.0.6282) by AlliedModders LLC
20 "Admin Help" (1.9.0.6282) by AlliedModders LLC
21 <Failed> "[MA] Advanced Functionality" (1.1.4) by OkyHp
22 "Player Commands" (1.9.0.6282) by AlliedModders LLC
23 "SMAC Rcon Locker" (0.8.6.0) by SMAC Development Team
24 "Client Preferences" (1.9.0.6282) by AlliedModders LLC
25 "SMAC Aimbot Detector" (0.8.6.0) by SMAC Development Team
26 "SMAC AutoTrigger Detector" (0.8.6.0) by SMAC Development Team
27 "Nextmap" (1.9.0.6282) by AlliedModders LLC
28 "CS:GO Admin ESP" (2.1) by Root
29 "SourceBans++ TR" (1.5.4.6) by SourceBans Development Team, Sarabveer(VEER™), NoTiCE
30 "[CR] Misc" (2.0) by Someone
31 "Weapons & Knives" (1.4.2) by kgns | oyunhost.net
32 "Fun Commands" (1.9.0.6282) by AlliedModders LLC
33 "Basic Chat" (1.9.0.6282) by AlliedModders LLC
34 "Admin List" (1.0) by Someone
35 "SourceMod Anti-Cheat" (0.8.6.0) by SMAC Development Team
36 "[VIP] Admin" (1.0.0) by R1KO
37 "[VIP] Tracers" (1.0.1) by R1KO
38 "[VIP] Vips Online" (1.0.1) by R1KO (skype: vova.andrienko1)
39 "[VIP] No Fall Damage" (1.0.1) by R1KO (skype: vova.andrienko1)
40 "[VIP] Healthshot" (1.0.1) by R1KO (skype: vova.andrienko1)
41 "[VIP] Electro Effects" (1.0.3) by R1KO
42 "[VIP] Tag" (1.1) by R1KO
43 "[VIP] Spawn Effects" (1.2) by Mr.ToNik
44 "[LR] Module - Boost(Vip)" (v3.0) by Designed (Discord: .Designed#7985)
45 "[CS:S/CS:GO] [VIP] Respawn" (1.3) by R1KO
46 "[VIP] Bhop" (1.0) by MaZa
47 "[VIP] CHAT (+scp)" (3.1.1) by R1KO
48 "[VIP] Core" (3.0 R) by R1KO
49 "[VIP] COIN" (1.1.0) by Pheonix (˙·٠●Феникс●٠·˙) & R1KO
50 "VIP Connected Msg" (1.2) by Skeriiz, HLmod
51 "[VIP] Test" (1.0.3) by R1KO (skype: vova.andrienko1)
52 <Failed> "SMAC Anti-Wallhack" (0.8.6.0) by SMAC Development Team
53 "Anti-Flood" (1.9.0.6282) by AlliedModders LLC
54 "BlockingZones | Блокирующие зоны" (1.3) by Drumanid
55 "[LR] Module - HUD" (v3.0) by Designed (Discord: .Designed#7985)
56 "SMAC EAC Global Banlist" (0.8.6.0) by SMAC Development Team
57 "SuperAdminka" (1.4.7) by Grey™
58 "GoTT" (1.2.0) by GoTT
59 "[CR] Weapons" (2.0) by Someone
60 "Реклама" (1.4.1) by Pheonix (˙·٠●Феникс●٠·˙)
61 "Admin Messages" (1.2)) by K1NG
62 "[CR] Only HeadShot" (2.0) by FIVE
63 "Sound Commands" (1.9.0.6282) by AlliedModders LLC
64 "Basic Info Triggers" (1.9.0.6282) by AlliedModders LLC
65 "[CS:GO] Spritetrail fix" (1.0.1) by FrozDark
66 "Connect MSG" (1.0) by Crazy
67 "SMAC Spinhack Detector" (0.8.6.0) by SMAC Development Team
68 "[CR] Menu" (2.0) by Someone
69 "[CR] Messages" (2.0) by Someone
70 "[CS:GO/CSS] AbNeR Round End Sounds" (4.0.1) by abnerfs
71 "Fun Votes" (1.9.0.6282) by AlliedModders LLC
72 "SMAC Client Protection" (0.8.6.0) by SMAC Development Team
73 "[Discord] Core" (1.0.8) by CrazyHackGUT aka Kruzya
74 "[Discord] Simple Report System" (1.2.2) by CrazyHackGUT aka Kruzya
75 "Custom Rounds" (2.0) by Someone
76 "Admin File Reader" (1.9.0.6282) by AlliedModders LLC
77 "XDuels" (1.0) by XTANCE
78 "[VIP] Dissolve Body" (1.2.1) by KOROVKA, R1KO
79 "Advanced Rules Menu" (1.3) by haN
80 "Anti Server Crash 9/1/2019" (1.8.0.5969) by backwards
81 "Admin Menu" (1.9.0.6282) by AlliedModders LLC
82 "SMAC ESEA Global Banlist" (0.8.6.0) by SMAC Development Team
83 "AFK Check" (1.0.0) by R1KO
84 "GameVoting" (1.8.8) by Neatek
85 "SourceBans: Admin Config Loader" ((SB++) 1.5.5-dev) by AlliedModders LLC, Sarabveer(VEER™)
86 "[CS:GO] ResetScore" (1.0) by pracc
87 "[LR] Module - TOP KDR" (v2.5.4.2) by Wend4r
88 "[LR] Module - Unusual Kills" (v3.0 SR4) by Wend4r
89 <Failed> "[LR] Module - ExStats GeoIP" (v3.0) by RoadSide Romeo
90 "[LR] Module - FakeRank" (v3.0 SR2) by RoadSide Romeo & Wend4r
91 <Failed> "SourceBans Checker" ((SB++) 1.5.4.6) by psychonic, Ca$h Munny, Sarabveer(VEER™)
Список расширений SM
[01] Automatic Updater (1.9.0.6282): Updates SourceMod gamedata files
[02] Webternet (1.9.0.6282): Extension for interacting with URLs
[03] BanId Fix (1.0): Correcting 'Ghost players' error
[04] SDK Tools (1.9.0.6282): Source SDK Tools
[05] BinTools (1.9.0.6282): Low-level C/C++ Calling API
[06] CS Tools (1.9.0.6282): CS extended functionality
[07] Top Menus (1.9.0.6282): Creates sorted nested menus
[08] Client Preferences (1.9.0.6282): Saves client preference settings
[09] SQLite (1.9.0.6282): SQLite Driver
[10] SDK Hooks (1.9.0.6282): Source SDK Hooks
[11] DHooks (2.2.0): Dynamic Hooks
[12] PTaH (1.1.0): Additional CS:GO Hooks and Natives
[13] Socket (3.0.1): Socket extension for SourceMod
[14] GeoIP (1.9.0.6282): Geographical IP information
[15] <OPTIONAL> file "soundlib.ext.so": csgo/addons/sourcemod/extensions/soundlib.ext.so: cannot open shared object file: No such file or directory
[16] REST in Pawn (1.0.6): Provides HTTP and JSON natives for plugins
[17] <FAILED> file "geoipcity.ext.so": csgo/addons/sourcemod/extensions/geoipcity.ext.so: cannot open shared object file: No such file or directory
[18] MySQL-DBI (1.9.0.6282): MySQL driver implementation for DBI
Не подключается к базе, вот логи
 

rejchev

менеджер клоунов
Сообщения
1,669
Реакции
1,291
Разрешите серверу трогать бдшку в панеле управления
 

Kruzya

Участник
Сообщения
12,970
Реакции
10,914
  • Команда форума
  • #4
Серваку с базой плохо. Пишите в ТП.
 

KeyWin

Участник
Сообщения
100
Реакции
8
У меня то же самое, это же айпишники май арены?
Может у них проблемы, надо подождать просто?
 
Последнее редактирование:

senku

Участник
Сообщения
5
Реакции
0
у меня таже фигня, люди. Помогайте. Шоп, вип, лк не работают и говорят не могут подключиться к базе
 

senku

Участник
Сообщения
5
Реакции
0
всё шикарно работало, но вдруг просто перестали работать шоп, лк, звания, материал и т.д и у всех одна ошибка. Не могут подкл к базе. А консоль ваще пишет, что ошибка в databases, но я смотрел, всё чисто, как и было. Решил обновится до последний версии sm, обновил. Всё равно та же проблема
 

Kruzya

Участник
Сообщения
12,970
Реакции
10,914
  • Команда форума
  • #9
Вроде, по русски написал, что проблема на сервере с БД, и писать надо в ТП хостинга. Тем более если все работало, Вы реально ничего не трогали, и резко оно сломалось с ошибкой подключения.

Тем более...
ТС предоставил лог. Видим там:
C-подобный:
L 10/31/2019 - 13:41:07: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '46.174.50.9' (4)
Открываем поисковую систему с простым названием Google, и пишем mysql connect error 2003, и смотрим:
Screenshot_20191101-225009_Firefox.jpg
Первым же результатом Гугл выдает выдержку с оф сайта, где не открывая, видно текст, что проблемы с подключением между клиентом (в нашем случае, сервером CSGO/CSS/любая другая игра на Source) и сервером с БД, и перечисляются возможные причины, которые все сводятся к одному: копать надо не клиент (игровой сервер), а сервер с базой.
И почему Вы до сих пор здесь, а не в ТП - для меня лично большая загадка. А еще большая для меня загадка - почему на Арене не заметили проблемы с доступностью сервера БД, но это уже совсем другая история.
 

KeyWin

Участник
Сообщения
100
Реакции
8
На арене сказали, чтобы я добавил айпишники серверов в разрешенные, потому что раньше я так понял у них так не работало, так как я ничего не указывал и айпи не блокировались. Они сейчас что то обновили и блок заработал
 
Сверху Снизу