Проблема с MySQL

[I_Love_Snusik]

Операционная система

Windows

Текст ошибки

Спойлер

L 04/21/2022 - 20:40:00: [SM] Exception reported: Script execution timed out
L 04/21/2022 - 20:40:00: [SM] Blaming: shop.smx
L 04/21/2022 - 20:40:00: [SM] Call stack trace:
L 04/21/2022 - 20:40:00: [SM] [1] Line 1146,
L 04/21/2022 - 20:40:00: [SM] [1] Line 1146, C:\Users\FrozDark\Desktop\shop\shop\sourcemod\scripting\shop.sp::ReconnectSQL
L 04/21/2022 - 20:40:00: [SM] [2] Line 1119, C:\Users\FrozDark\Desktop\shop\shop\sourcemod\scripting\shop.sp::ConnectSQL
L 04/21/2022 - 20:40:00: [SM] [3] Line 209, C:\Users\FrozDark\Desktop\shop\shop\sourcemod\scripting\shop.sp::OnConfigsExecuted

Список мета-модулей

Спойлер

Listing 4 plugins:
[01] SourceMod (1.10.0.6490) by AlliedModders LLC
[02] CS Tools (1.10.0.6490) by AlliedModders LLC
[03] SDK Tools (1.10.0.6490) by AlliedModders LLC
[04] SDK Hooks (1.10.0.6490) by AlliedModders LLC

Список плагинов SM

Спойлер

01 "Reserved Slots" (1.10.0.6490) by AlliedModders LLC
02 "[Shop] Trails" (1.7) by FrozDark (HLModders LLC)
03 "Basic Ban Commands" (1.10.0.6490) by AlliedModders LLC
04 "Anti-Flood" (1.10.0.6490) by AlliedModders LLC
05 "Fun Commands" (1.10.0.6490) by AlliedModders LLC
06 "Player Commands" (1.10.0.6490) by AlliedModders LLC
07 "Basic Votes" (1.10.0.6490) by AlliedModders LLC
08 "Admin Join Sound" (1.7) by KK
09 "Rock The Vote" (1.10.0.6490) by AlliedModders LLC
10 "Server Pause" (1.0) by hlmod.ru
11 "[Shop] Medkit" (1.7.2) by FrozDark (HLModders LLC)
12 "[Shop] Money Distributor" (1.3.2) by FrozDark (HLModders LLC)
13 "Fun Votes" (1.10.0.6490) by AlliedModders LLC
14 "[SM] Set Tags Clients" (1.1.0) by acik_traiks
15 "Kigen's Anti-Cheat" (1.2.2.9.9.7) by Kigen, GoD-Tony, psychonic and GoDtm666.
16 "Quake Sounds" (2.7) by dalto, Grrrrrrrrrrrrrrrrrrr, and psychonic
17 "Sound Commands" (1.10.0.6490) by AlliedModders LLC
18 "End Round Overlays" (1.0.0) by ilga80
19 "Basic Chat" (1.10.0.6490) by AlliedModders LLC
20 "[Any] Fakesay" (1.0.0.0) by Mitch
21 "GameVoting" (1.8.8) by Neatek
22 "Nextmap" (1.10.0.6490) by AlliedModders LLC
23 "Round Start Music" (1.2) by wS (World-Source.Ru)
24 "[Shop] Equipments" (1.0.0) by FrozDark
25 "[CS:S] Custom Weapons" (1.1.19) by FrozDark
26 "MapChooser" (1.10.0.6490) by AlliedModders LLC
27 "screen_overlay_gta.smx"
28 "[Shop] Skins" (1.8.6-beta3) by FrozDark
29 "map-decals.smx" (1.2fix CSGO) by Berni, Stingbyte
30 "Basic Info Triggers" (1.10.0.6490) by AlliedModders LLC
31 "SM Parachute" (2.5) by SWAT_88
32 "Round and Map End Sound" (2.4.5) by FrozDark (HLModders.ru LLC)
33 "Map Nominations" (1.10.0.6490) by AlliedModders LLC
34 "ResetScore" (1.3.1) by tuty & GoDtm666
35 "Basic Commands" (1.10.0.6490) by AlliedModders LLC
36 "Admin Menu" (1.10.0.6490) by AlliedModders LLC
37 "Join_Sound" (1.1) by wS / Schmidt
38 "Client Preferences" (1.10.0.6490) by AlliedModders LLC
39 "Basic Comm Control" (1.10.0.6490) by AlliedModders LLC
40 "show_damage.smx"
41 <Error> "SourceBans" (1.4.11) by SourceBans Development Team + [Danyas]
42 "Admin File Reader" (1.10.0.6490) by AlliedModders LLC
43 "Admin Help" (1.10.0.6490) by AlliedModders LLC
44 "[Shop] Core" (1.8.8) by FrozDark (HLModders LLC)

Список расширений SM

Спойлер

[SM] Displaying 10 extensions:
[01] CS Tools (1.10.0.6490): CS extended functionality
[02] BinTools (1.10.0.6490): Low-level C/C++ Calling API
[03] SDK Tools (1.10.0.6490): Source SDK Tools
[04] Top Menus (1.10.0.6490): Creates sorted nested menus
[05] Regex (1.10.0.6490): Provides regex natives for plugins
[06] SDK Hooks (1.10.0.6490): Source SDK Hooks
[07] Socket (3.0.1): Socket extension for SourceMod
[08] Client Preferences (1.10.0.6490): Saves client preference settings
[09] SQLite (1.10.0.6490): SQLite Driver
[10] MySQL-DBI (1.10.0.6490): MySQL driver implementation for DBI

При подключении БД к серверу,начинает долго включаться сервер,а после ядро шопа ложиться спать,пытался найти хоть-какойто гайд на подключение БД,что я сделал не так?

 

[hirowatch]

sourcemod/configs/databases.cfg at master · alliedmodders/sourcemod

SourceMod - Source Engine Scripting and Administration - alliedmodders/sourcemod

github.com

"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"
    }
   
    "shop"
    {
        //Данные от базы для shop
        "driver"            "mysql"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
}

Оффтоп

кек

 

[I_Love_Snusik]

sourcemod/configs/databases.cfg at master · alliedmodders/sourcemod

SourceMod - Source Engine Scripting and Administration - alliedmodders/sourcemod

github.com

"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"
    }
  
    "shop"
    {
        //Данные от базы для shop
        "driver"            "mysql"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
}

Оффтоп

кек
Посмотреть вложение 95270

Оффтоп

прикол в том что я заливал несколько раз и иногда все равно иногда не меняется

Однако благодарю,вообще заметил что в последнее время на хостинге где стоит мой сервер,иногда случается этот прикол,что файлы не заменяются/добавляются/удаляются,отчего приходиться не понимать виноват ли ты тут вообще

 

[hirowatch]

Оффтоп

@I_Love_Snusik, что за хост? интересно.

Пробуйте через FTP все делать

 

[I_Love_Snusik]

Оффтоп

@I_Love_Snusik, что за хост? интересно.

Пробуйте через FTP все делать

Всегда через фтп делаю,хост cw-serv

Сообщения автоматически склеены: 21 Апр 2022

Спойлер: Ошибка

L 04/21/2022 - 20:56:16: [shop.smx] ConnectSQLCallback 2: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 04/21/2022 - 20:56:31: [shop.smx] ConnectSQLCallback 2: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 04/21/2022 - 20:56:46: [shop.smx] ConnectSQLCallback 2: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 04/21/2022 - 20:57:01: [shop.smx] ConnectSQLCallback 2: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 04/21/2022 - 20:57:16: [shop.smx] ConnectSQLCallback 2: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Перезакинул кфг и началась новая волна ошибок

 

[hirowatch]

Всегда через фтп делаю,хост cw-serv

Оффтоп

Я имею ввиду через эту программу работать

Я думаю вопрос можно закрыть Проблема с MySQL

Сообщения автоматически склеены: 21 Апр 2022

L 04/21/2022 - 20:56:16: [shop.smx] ConnectSQLCallback 2: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 04/21/2022 - 20:56:31: [shop.smx] ConnectSQLCallback 2: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 04/21/2022 - 20:56:46: [shop.smx] ConnectSQLCallback 2: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 04/21/2022 - 20:57:01: [shop.smx] ConnectSQLCallback 2: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 04/21/2022 - 20:57:16: [shop.smx] ConnectSQLCallback 2: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Перезакинул кфг и началась новая волна ошибок

А вы данные от базы данных mysql прописали? Вот сама статья на CWSERV

https://forum.cw-serv.ru/threads/15/