CSstatsX SQL и MySQL

[r1ghty]

Ошибка

L 08/06/2020 - 19:00:50: [csstatsx_sql.amxx] SQL connection failed
L 08/06/2020 - 19:00:50: [csstatsx_sql.amxx] [ 2002 ] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

ОС

Linux

Amx Mod X

AMX Mod X 1.9.0.5271 (http://www.amxmodx.org)

Authors:

        David "BAILOPAN" Anderson, Pavol "PM OnoTo" Marko

        Felix "SniperBeamer" Geyer, Jonny "Got His Gun" Bergstrom

        Lukasz "SidLuke" Wlasinski, Christian "Basic-Master" Hammacher

        Borja "faluco" Ferrer, Scott "DS" Ehlert

Compiled: Jun 24 2020 13:53:30

Built from: https://github.com/alliedmodders/amxmodx/commit/5eea3e5

Build ID: 5271:5eea3e5

Core mode: JIT+ASM32

Билд

Protocol version 48

Exe version 1.1.2.7/Stdio (cstrike)

ReHLDS version: 3.7.0.697-dev

Build date: 20:42:34 Jul 24 2020 (2295)

Build from: https://github.com/dreamstalker/rehlds/commit/98db467

ReGamedll

ReGameDLL version: 5.18.0.474-dev

Build date: 11:07:34 Jul 16 2020

Build from: https://github.com/s1lentq/ReGameDLL_CS/commit/efb06a7

Версия Metamod

Metamod-r v1.3.0.128, API (5:13)

Metamod-r build: 17:47:54 Aug 24 2018

Metamod-r from: https://github.com/theAsmodai/metamod-r/commit/0cf2f70

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

Currently loaded plugins:

      description      stat pend  file                      vers             src  load  unload

 [ 1] VoiceTranscoder  RUN   -    VoiceTranscoder.so        v2017RC5         ini  ANY   ANY

 [ 2] ReSemiclip       RUN   -    resemiclip_mm_i386.so     v2.3.9           ini  Chlvl ANY

 [ 3] AMX Mod X        RUN   -    amxmodx_mm_i386.so        v1.9.0.5271      ini  Start ANY

 [ 4] MySQL            RUN   -    mysql_amxx_i386.so        v1.9.0.5271      pl3  ANY   ANY

 [ 5] Ham Sandwich     RUN   -    hamsandwich_amxx_i386.so  v1.9.0.5271      pl3  ANY   ANY

 [ 6] FakeMeta         RUN   -    fakemeta_amxx_i386.so     v1.9.0.5271      pl3  ANY   ANY

 [ 7] CStrike          RUN   -    cstrike_amxx_i386.so      v1.9.0.5271      pl3  ANY   ANY

 [ 8] ReAPI            RUN   -    reapi_amxx_i386.so        v5.15.0.197-dev  pl3  ANY   Never

 [ 9] Engine           RUN   -    engine_amxx_i386.so       v1.9.0.5271      pl3  ANY   ANY

9 plugins, 9 running

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

Currently loaded plugins:

       name                    version     author            file             status

 [  1] Admin Base              1.9.0.5271  AMXX Dev Team     admin.amxx       running

 [  2] Admin Commands          1.9.0.5271  AMXX Dev Team     admincmd.amxx    running

 [  3] Admin Help              1.9.0.5271  AMXX Dev Team     adminhelp.amxx   running

 [  4] Slots Reservation       1.9.0.5271  AMXX Dev Team     adminslots.amxx  running

 [  5] Menus Front-End         1.9.0.5271  AMXX Dev Team     menufront.amxx   running

 [  6] Commands Menu           1.9.0.5271  AMXX Dev Team     cmdmenu.amxx     running

 [  7] Players Menu            1.9.0.5271  AMXX Dev Team     plmenu.amxx      running

 [  8] Maps Menu               1.9.0.5271  AMXX Dev Team     mapsmenu.amxx    running

 [  9] Plugin Menu             1.9.0.5271  AMXX Dev Team     pluginmenu.amxx  running

 [ 10] Admin Chat              1.9.0.5271  AMXX Dev Team     adminchat.amxx   running

 [ 11] Anti Flood              1.9.0.5271  AMXX Dev Team     antiflood.amxx   running

 [ 12] Admin Votes             1.9.0.5271  AMXX Dev Team     adminvote.amxx   running

 [ 13] NextMap                 1.9.0.5271  AMXX Dev Team     nextmap.amxx     running

 [ 14] Nextmap Chooser         1.9.0.5271  AMXX Dev Team     mapchooser.amxx  running

 [ 15] TimeLeft                1.9.0.5271  AMXX Dev Team     timeleft.amxx    running

 [ 16] Pause Plugins           1.9.0.5271  AMXX Dev Team     pausecfg.amxx    running

 [ 17] Stats Configuration     1.9.0.5271  AMXX Dev Team     statscfg.amxx    running

 [ 18] CSStatsX SQL            0.7.4+2     serfreeman1337    csstatsx_sql.am  running

Автор плагина

serfreeman1337

Версия плагина

0.7.4+2

Исходный код

.

CentOS 8, MariaDB 10.5, не работают плагины с sql, у всех такая ошибка. Что можно сделать?

Спойлер: systemctl status mariadb

mariadb.service - MariaDB 10.5.4 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2020-08-06 19:02:07 MSK; 1s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 1923 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1901 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=cd /usr/bin/..; /usr/bin/galera_recovery; [ $? -eq 0 ] && systemctl set-en>
Process: 1899 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 1911 (mariadbd)
Status: "Taking your SQL requests now..."
Tasks: 11 (limit: 5050)
Memory: 69.7M
CGroup: /system.slice/mariadb.service
└─1911 /usr/sbin/mariadbd

Aug 06 19:02:07 hostname mariadbd[1911]: 2020-08-06 19:02:07 0 [Note] InnoDB: 10.5.4 started; log sequence number 45105; transaction id 21
Aug 06 19:02:07 hostname mariadbd[1911]: 2020-08-06 19:02:07 0 [Note] Plugin 'FEEDBACK' is disabled.
Aug 06 19:02:07 hostname mariadbd[1911]: 2020-08-06 19:02:07 0 [Note] Server socket created on IP: '::'.
Aug 06 19:02:07 hostname mariadbd[1911]: 2020-08-06 19:02:07 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Aug 06 19:02:07 hostname mariadbd[1911]: 2020-08-06 19:02:07 0 [Note] InnoDB: Buffer pool(s) load completed at 200806 19:02:07
Aug 06 19:02:07 hostname mariadbd[1911]: 2020-08-06 19:02:07 0 [Note] Reading of all Master_info entries succeeded
Aug 06 19:02:07 hostname mariadbd[1911]: 2020-08-06 19:02:07 0 [Note] Added new Master_info '' to hash table
Aug 06 19:02:07 hostname mariadbd[1911]: 2020-08-06 19:02:07 0 [Note] /usr/sbin/mariadbd: ready for connections.
Aug 06 19:02:07 hostname mariadbd[1911]: Version: '10.5.4-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
Aug 06 19:02:07 hostname systemd[1]: Started MariaDB 10.5.4 database server.

 

[r1ghty]

Решено: причина - банальная невнимательность, линукс плохо работает с ip localhost, ставить надо 127.0.0.1