Проблема с MySQL

I_Love_Snusik

Участник
Сообщения
55
Реакции
7
Операционная система
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
При подключении БД к серверу,начинает долго включаться сервер,а после ядро шопа ложиться спать,пытался найти хоть-какойто гайд на подключение БД,что я сделал не так?
 

Вложения

  • database.cfg
    165 байт · Просмотры: 36
Решение

C-подобный:
"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"...

hirowatch

Живет ХЛмод`ом
Сообщения
2,722
Реакции
1,634

C-подобный:
"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

Участник
Сообщения
55
Реакции
7

C-подобный:
"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

Участник
Сообщения
55
Реакции
7
Оффтоп Пробуйте через FTP все делать
Всегда через фтп делаю,хост cw-serv
Сообщения автоматически склеены:

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

Живет ХЛмод`ом
Сообщения
2,722
Реакции
1,634
Всегда через фтп делаю,хост cw-serv
Оффтоп

Я думаю вопрос можно закрыть Проблема с MySQL
Сообщения автоматически склеены:

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
 
Сверху Снизу