Проблема с БД

Lunnarking

Участник
Сообщения
29
Реакции
6
Операционная система
Linux
Текст ошибки
L 03/08/2026 - 12:33:33: SourceMod error session started
L 03/08/2026 - 12:33:33: Info (map "de_dust2") (file "/home/container/csgo/addons/sourcemod/logs/errors_20260308.log")
L 03/08/2026 - 12:33:33: [shop.smx] DB_ErrorCheck: no such table: shop_players
L 03/08/2026 - 12:33:33: [shop.smx] DB_UgradeState_1: no such table: shop_items
L 03/08/2026 - 12:50:43: SourceMod error session started
L 03/08/2026 - 12:50:43: Info (map "de_dust2") (file "/home/container/csgo/addons/sourcemod/logs/errors_20260308.log")
L 03/08/2026 - 12:50:43: [SM] Exception reported: Could not connect to database, reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 03/08/2026 - 12:50:43: [SM] Blaming: NCRPG/NCRPG.smx
L 03/08/2026 - 12:50:43: [SM] Call stack trace:
L 03/08/2026 - 12:50:43: [SM] [0] SetFailState
L 03/08/2026 - 12:50:43: [SM] [1] Line 11, NCRPG/NCRPG_Logs.inc::NCRPg_LogPrint
L 03/08/2026 - 12:50:43: [SM] [2] Line 30, NCRPG/NCRPG_Databases.inc::CallBackConnectToDB
L 03/08/2026 - 12:56:14: SourceMod error session started
L 03/08/2026 - 12:56:14: Info (map "de_dust2") (file "/home/container/csgo/addons/sourcemod/logs/errors_20260308.log")
L 03/08/2026 - 12:56:14: [SM] Exception reported: Could not connect to database, reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 03/08/2026 - 12:56:14: [SM] Blaming: NCRPG/NCRPG.smx
L 03/08/2026 - 12:56:14: [SM] Call stack trace:
L 03/08/2026 - 12:56:14: [SM] [0] SetFailState
L 03/08/2026 - 12:56:14: [SM] [1] Line 11, NCRPG/NCRPG_Logs.inc::NCRPg_LogPrint
L 03/08/2026 - 12:56:14: [SM] [2] Line 30, NCRPG/NCRPG_Databases.inc::CallBackConnectToDB
L 03/08/2026 - 13:25:36: SourceMod error session started
L 03/08/2026 - 13:25:36: Info (map "de_dust2") (file "/home/container/csgo/addons/sourcemod/logs/errors_20260308.log")
L 03/08/2026 - 13:25:36: [SM] Exception reported: Could not connect to database, reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 03/08/2026 - 13:25:36: [SM] Blaming: NCRPG/NCRPG.smx
L 03/08/2026 - 13:25:36: [SM] Call stack trace:
L 03/08/2026 - 13:25:36: [SM] [0] SetFailState
L 03/08/2026 - 13:25:36: [SM] [1] Line 11, NCRPG/NCRPG_Logs.inc::NCRPg_LogPrint
L 03/08/2026 - 13:25:36: [SM] [2] Line 30, NCRPG/NCRPG_Databases.inc::CallBackConnectToDB
L 03/08/2026 - 13:59:31: SourceMod error session started
L 03/08/2026 - 13:59:31: Info (map "de_dust2") (file "/home/container/csgo/addons/sourcemod/logs/errors_20260308.log")
L 03/08/2026 - 13:59:31: [SM] Exception reported: Could not connect to database, reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 03/08/2026 - 13:59:31: [SM] Blaming: NCRPG/NCRPG.smx
L 03/08/2026 - 13:59:31: [SM] Call stack trace:
L 03/08/2026 - 13:59:31: [SM] [0] SetFailState
L 03/08/2026 - 13:59:31: [SM] [1] Line 11, NCRPG/NCRPG_Logs.inc::NCRPg_LogPrint
L 03/08/2026 - 13:59:31: [SM] [2] Line 30, NCRPG/NCRPG_Databases.inc::CallBackConnectToDB
L 03/08/2026 - 14:01:14: SourceMod error session started
L 03/08/2026 - 14:01:14: Info (map "de_dust2") (file "/home/container/csgo/addons/sourcemod/logs/errors_20260308.log")
L 03/08/2026 - 14:01:14: [CLIENTPREFS] [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 03/08/2026 - 14:01:14: [CLIENTPREFS] [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 03/08/2026 - 14:01:17: [CLIENTPREFS] [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 03/08/2026 - 14:01:20: [SM] Exception reported: Could not connect to database, reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 03/08/2026 - 14:01:20: [SM] Blaming: NCRPG/NCRPG.smx
L 03/08/2026 - 14:01:20: [SM] Call stack trace:
L 03/08/2026 - 14:01:20: [SM] [0] SetFailState
L 03/08/2026 - 14:01:20: [SM] [1] Line 11, NCRPG/NCRPG_Logs.inc::NCRPg_LogPrint
L 03/08/2026 - 14:01:20: [SM] [2] Line 30, NCRPG/NCRPG_Databases.inc::CallBackConnectToDB
L 03/08/2026 - 14:01:20: [CLIENTPREFS] [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 03/08/2026 - 14:01:21: [weapons.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 03/08/2026 - 14:01:21: [gloves.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 03/08/2026 - 14:04:48: [CLIENTPREFS] [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Список плагинов SM
01 "PlayerWelcome" (1.0.0) by MrQout
02 "Nextmap" (1.11.0.6928) by AlliedModders LLC
03 "Реклама" (1.4.1) by Pheonix (˙·٠●Феникс●٠·˙)
04 "Basic Votes" (1.11.0.6928) by AlliedModders LLC
05 "Basic Commands" (1.11.0.6928) by AlliedModders LLC
06 "[Shop] Roll" (1.2.3) by Faya™ (DS: Faya™#8514)
07 "Client Preferences" (1.11.0.6928) by AlliedModders LLC
08 "[VIP] No Self Damage" (1.1.0) by R1KO, vadrozh aka NaN
09 "[VIP] Anti Flash" (1.2) by R1KO, babka68
10 "[VIP] Core" (3.0.1 R) by R1KO
11 "Round End Music" (1.1.3) by KOROVKA
12 "Quick Defuse" (1.3) by by pRED, babka68
13 "Basic Ban Commands" (1.11.0.6928) by AlliedModders LLC
14 "Player Commands" (1.11.0.6928) by AlliedModders LLC
15 "No Lobby Reservation" (0.0.2) by vanz
16 "Basic Chat" (1.11.0.6928) by AlliedModders LLC
17 "Sound Commands" (1.11.0.6928) by AlliedModders LLC
18 "Weapons & Knives" (1.7.2) by kgns | oyunhost.net
19 "[Shop] Pets" (1.0) by Pheonix (˙·٠●Феникс●٠·˙) & Zephyrus
20 "Fun Commands" (1.11.0.6928) by AlliedModders LLC
21 "Basic Info Triggers" (1.11.0.6928) by AlliedModders LLC
22 "Lite Connect Info" (1.1.0) by MizzZer (rewritten by Grey83)
23 "Reserved Slots" (1.11.0.6928) by AlliedModders LLC
24 "Anti-Flood" (1.11.0.6928) by AlliedModders LLC
25 <Error "NCRPG Skill spy" (1.2) by SenatoR
26 <Error "NCRPG Bouncy Bullets" (1.4) by SenatoR
27 <Error "NCRPG Skill stealth" (1.3) by SenatoR
28 "Spawn Protection [Added CS:GO Support]" (1.5 [CS:GO Support]) by Fredd
29 <Error "NCRPG Skill medic" (1.4) by SenatoR
30 <Error "NCRPG Dissolve" (1.1) by SenatoR
31 <Error "NCRPG/ncrpg_pl_action.smx"
32 <Error "NCRPG Skill incidence" (1.2) by SenatoR
33 <Error "NCRPG Skill master" (1.0) by SenatoR
34 <Error "NCRPG Skill adrenaline" (1.2) by SenatoR
35 <Error "NCRPG Info Player Hud" (1.2) by SenatoR
36 <Failed "NCRPG" (1.3.8.6) by SenatoR
37 <Error "NCRPG Decoy Teleport" (1.0) by SenatoR
38 <Error "NCRPG Skill Fire Taser" (1.2) by SenatoR
39 <Error "NCRPG Tesla Coil" (1.2) by SenatoR
40 <Error "NCRPG Skill Ice Stab" (1.7) by SenatoR
41 <Error "NCRPG/ncrpg_reset.smx"
42 <Error "NCRPG Skill gravity" (1.2) by SenatoR
43 <Error "NCRPG Info Player Menu" (1.2) by SenatoR
44 <Error "NCRPG Admin Console" (2.1) by SenatoR
45 <Error "NCRPG Skill speed" (1.2) by SenatoR
46 <Error "NCRPG Respawn" (1.2) by SenatoR
47 <Error "NCRPG Position Swap" (1.2) by SenatoR
48 <Error "NCRPG Skill icestab_immun" (1.0) by SenatoR
49 <Error "NCRPG Skill inhumanity" (1.3) by SenatoR
50 <Error "NCRPG Skill Poison Smoke" (1.4) by SenatoR
51 <Error "NCRPG Poison scout" (1.2) by SenatoR
52 <Error "NCRPG Skill mirror" (1.3) by SenatoR
53 <Error "NCRPG Frags Menu" (1.3) by SenatoR
54 <Error "NCRPG Skill ghoul" (1.2) by SenatoR
55 <Error "NCRPG Decoy Clone" (1.2) by SenatoR
56 <Error "NCRPG LvlUp" (1.2) by SenatoR
57 <Error "NCRPG Menu" (1.3) by SenatoR
58 <Error "NCRPG Skill engineer" (1.2) by SenatoR
59 <Error "NCRPG Clan Bonus XP" (1.1) by SenatoR
60 <Error "NCRPG Evansion" (1.3) by SenatoR
61 <Error "NCRPG Skill vampire" (1.2) by SenatoR
62 <Error "[NCRPG] Healthshot max heal increaser" (1.0) by inklesspen
63 <Error "NCRPG XP events" (1.4) by SenatoR
64 <Error "NCRPG Long Jump 2 Effect" (1.1) by SenatoR
65 <Error "NCRPG Skill parasite" (1.2) by SenatoR
66 <Error "NCRPG Skill Attack Speed" (1.3) by SenatoR
67 <Error "NCRPG Skill regenarm" (1.1) by SenatoR
68 <Error "NCRPG Skill Frost Pistol" (1.3) by SenatoR
69 <Error "NCRPG Rank & Top" (1.5) by SenatoR
70 <Error "NCRPG DB Cleaner" (1.2) by SenatoR
71 <Error "NCRPG Skill health" (1.3) by SenatoR
72 <Error "NCRPG Eagle Eye" (1.5) by SenatoR
73 <Error "NCRPG Skill damage" (1.4) by SenatoR
74 <Error "NCRPG Long Jump" (1.3) by SenatoR
75 <Error "NCRPG Long Jump 2" (1.3) by SenatoR
76 <Error "NCRPG Skill Regen HP" (1.3) by SenatoR
77 <Error "NCRPG Skill explode" (1.3) by SenatoR
78 <Error "NCRPG Skill Frost Nade" (1.4) by SenatoR
79 "[SHOP] Kills Change" (1.0) by Drimer
80 "Fun Votes" (1.11.0.6928) by AlliedModders LLC
81 "High or Low" (1.1) by SheriF and donut1k
82 "Admin File Reader" (1.11.0.6928) by AlliedModders LLC
83 "[Shop] Core" (3.0E2) by FrozDark (Fork by R1KO & White Wolf)
84 "AbNeR Map Restrictions" (1.2.1) by abnerfs
85 "Admin Menu" (1.11.0.6928) by AlliedModders LLC
86 "Admin Help" (1.11.0.6928) by AlliedModders LLC
87 "[Shop] Vampirism" (1.1) by R1KO
88 "Gloves" (1.0.5) by kgns | oyunhost.net
89 "ResetScore" (1.6) by tuty, babka68
90 "[Shop] Ammo weapons" (1.2.1) by inklesspen / Marks
91 "Basic Comm Control" (1.11.0.6928) by AlliedModders LLC
Привествую
Пытаюсь поставить некоторые моды на сервер и при вводе данных БД от от MySQL ничего не просиходит
Сайт выдал такие данные от:
MySQL Хост для локального подключения
MySQL Хост для внешнего подключения
MySQL Порт
База данных
Имя пользователя
Пароль

БД просит такие данные, как:
Driver
Database
User
Pass

Подскажите что вводить? Понимаю глупый вопрос, но голову ломаю 3 день. Все ввел и также не находит БД
 
Последнее редактирование:

Grey83

не пишу плагины с весны 2022
Сообщения
8,805
Реакции
5,254
а где самые первые строки лога ошибок, в которых указана причина падения ядра NCRPG?
 

ZooM4322

Нейронка:)
Сообщения
175
Реакции
62
Ну у тебя должна быть запись в database.cfg

"идентификатор бд"
{
"driver" "mysql"
"host" "хост"
"database" "имя базы данных "
"user" "имя пользователя бд"
"pass" "твой пароль от бд"
"port" "3306"
}
Если я правильно понял что ты имеешь ввиду
 

Grey83

не пишу плагины с весны 2022
Сообщения
8,805
Реакции
5,254
@Lunnarking, это модуль

Ты лучше сам файл лога прикрепи. Так значительно быстрее выйдет, раз ты не умеешь читать логи и не знаешь что такое ядро.
Сообщения автоматически склеены:

Ты в ошибки вбил совершенно бесполезную информацию: по списку плагинов и так видно, что у тебя не загрузилось ядро, потому и все его модули не работают.
 

Grey83

не пишу плагины с весны 2022
Сообщения
8,805
Реакции
5,254
@Lunnarking, твои ошибки, которые ты упорно не постил вот:
C-подобный:
[shop.smx] DB_ErrorCheck: no such table: shop_players
[shop.smx] DB_UgradeState_1: no such table: shop_items
Exception reported: Could not connect to database, reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[CLIENTPREFS] [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[weapons.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[gloves.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Сообщения автоматически склеены:

Ты уверен, что сервис мускула запущен в системе?
Сообщения автоматически склеены:

В инете на запрос Can't connect to local MySQL server through socket '/tmp/mysql.sock' в основном гугл выдаёт страницы, где обычно проблема именно не запущеный мускул.
Или просто неправильно прописаны настройки (адрес куда нужно стучаться) для коннекта к нему.
 
Последнее редактирование:

Lunnarking

Участник
Сообщения
29
Реакции
6
@Lunnarking, твои ошибки, которые ты упорно не постил вот:
C-подобный:
[shop.smx] DB_ErrorCheck: no such table: shop_players
[shop.smx] DB_UgradeState_1: no such table: shop_items
Exception reported: Could not connect to database, reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[CLIENTPREFS] [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[weapons.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[gloves.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Сообщения автоматически склеены:

Ты уверен, что сервис мускула запущен в системе?
MySQL использовал от хостера который предоставил сервер. Отдельно пока не покупал, он сейчас стоит в статусе: Включен и по ip можно зайти в него
Возможно моя ошибка в том, что отдельно БД не покупал, но с деньгами пока не ахти
Сообщения автоматически склеены:

@Lunnarking, твои ошибки, которые ты упорно не постил вот:
C-подобный:
[shop.smx] DB_ErrorCheck: no such table: shop_players
[shop.smx] DB_UgradeState_1: no such table: shop_items
Exception reported: Could not connect to database, reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[CLIENTPREFS] [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[weapons.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[gloves.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Сообщения автоматически склеены:

Ты уверен, что сервис мускула запущен в системе?
Сообщения автоматически склеены:

В инете на запрос Can't connect to local MySQL server through socket '/tmp/mysql.sock' в основном гугл выдаёт страницы, где обычно проблема именно не запущеный мускул.
Или просто неправильно прописаны настройки (адрес куда нужно стучаться) для коннекта к нему.
Понимаю нагло, но есть варик в дс зайти и на счет этого поговорить? Если так возможно
 

Grey83

не пишу плагины с весны 2022
Сообщения
8,805
Реакции
5,254
@Lunnarking, возможно, как сказали выше, проблема в правильности заполнения файла database.cfg.

Если будешь сюда его содержимое цитировать, то не забудь убрать пароли.
 

Lunnarking

Участник
Сообщения
29
Реакции
6
Все-таки потревожу @Grey83 . Все ввел также кидает ошибку в логах "SM] Exception reported: Could not connect to database, reason: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock'"
Может я реально тупой, но я все настроил. Щас даже в сервере вылез худ с информацией SMRPG, но вся стата идет в "-1"
"Databases"
{
"driver_default" "mysql"

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

"default"
{
"driver" "mysql"
"host" "185.248.101.137"
"database" "gs33513"
"user" "gs33513"
"pass" "..."
"port" "3306"
//"timeout" "0"
}

"storage-local"
{
"driver" "mysql"
"database" "gs33513"
}

"clientprefs"
{
"driver" "mysql"
"host" "185.248.101.137"
"database" "gs33513"
"user" "gs33513"
"pass" "..."
"port" "3306"
}

"smrpg"
{
"driver" "mysql"
"host" "185.248.101.137"
"database" "gs33513"
"user" "gs33513"
"pass" "..."
"port" "3306"
}
}
Сообщения автоматически склеены:

1772977266134.png
 
Сверху Снизу