SQL Connection for amxbans and fresh bans

[drag1c]

Ошибка

L 10/07/2021 - 21:50:52: [FB]TCONNECTION_FAILED time 0.003784
L 10/07/2021 - 21:50:52: [FB]MYSQL ERROR #1044
L 10/07/2021 - 21:50:52: [FB]MYSQL ERROR Access denied for user 'sql_1088672_e9t'@'' to database 'amx'

ОС

Linux

Amx Mod X

1.10

Билд

5435

ReGamedll

5.21.0.534-dev

Версия Metamod

Metamod v1.21p37  2013/05/30

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

[ 1] Reunion          RUN   -    reunion_mm_i386.  v0.1.92d  ini   Start Never

 [ 2] ReAuthCheck      RUN   -    reauthcheck_mm_i  v0.1.6    ini   Start Never

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

 [ 4] Rechecker        RUN   -    rechecker_mm_i38  v2.5      ini   Chlvl ANY  

 [ 5] SafeNameAndChat  RUN   -    SafeNameAndChat.  v1.1      ini   ANY   ANY  

 [ 6] ReSRDetector     RUN   -    resrdetector_mm_  v0.1.0    ini   Chlvl ANY  

 [ 7] Revoice          RUN   -    revoice_mm_i386.  v0.1.0.3  ini   Start Never

 [ 8] Fun              RUN   -    fun_amxx_i386.so  v1.10.0.  pl3   ANY   ANY  

 [ 9] Engine           RUN   -    engine_amxx_i386  v1.10.0.  pl3   ANY   ANY  

 [10] FakeMeta         RUN   -    fakemeta_amxx_i3  v1.10.0.  pl3   ANY   ANY  

 [11] GeoIP            RUN   -    geoip_amxx_i386.  v1.10.0.  pl3   ANY   ANY  

 [12] CStrike          RUN   -    cstrike_amxx_i38  v1.10.0.  pl3   ANY   ANY  

 [13] CSX              RUN   -    csx_amxx_i386.so  v1.10.0.  pl3   ANY   ANY  

 [14] Ham Sandwich     RUN   -    hamsandwich_amxx  v1.10.0.  pl3   ANY   ANY  

 [15] ReAPI            RUN   -    reapi_amxx_i386.  v5.20.0.  pl3   ANY   Never

 [16] ReAimDetector    RUN   -    reaimdetector_am  v0.2.2    pl3   ANY   Never

 [17] MySQL            RUN   -    mysql_amxx_i386.  v1.10.0.  pl3   ANY   ANY  

17 plugins, 17 running

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

[  1] 0   AMXBans Core            6.13        YamiKaitou        unknown                          amxbans_cor  running  

 [  2] 1   AMXBans Main            6.13        YamiKaitou        unknown                          amxbans_mai  running  

 [  3] 2   FreshBans               1.4.5b      kanagava                                           fresh_bans_  running  

 [  4] 3   AdminListen             2.3x        /dev/ urandom /   unknown                          adminlisten  running  

 [  5] 4   Admin Commands          1.10.0.544  AMXX Dev Team                                      admincmd.am  running  

 [  6] 5   Admin Help              1.10.0.544  AMXX Dev Team                                      adminhelp.a  running  

 [  7] 6   Slots Reservation       1.10.0.544  AMXX Dev Team                                      adminslots.  running  

 [  8] 7   Multi-Lingual System    1.10.0.544  AMXX Dev Team                                      multilingua  running  

 [  9] 8   Menus Front-End         1.10.0.544  AMXX Dev Team                                      menufront.a  running  

 [ 10] 9   Commands Menu           1.10.0.544  AMXX Dev Team                                      cmdmenu.amx  running  

 [ 11] 10  Players Menu            1.10.0.544  AMXX Dev Team                                      plmenu.amxx  running  

 [ 12] 11  Pause Plugins           1.10.0.544  AMXX Dev Team                                      pausecfg.am  running  

 [ 13] 12  Maps Menu               1.10.0.544  AMXX Dev Team                                      mapsmenu.am  running  

 [ 14] 13  Plugin Menu             1.10.0.544  AMXX Dev Team                                      pluginmenu.  running  

 [ 15] 14  Anti Flood              1.10.0.544  AMXX Dev Team                                      antiflood.a  running  

 [ 16] 15  Scrolling Message       1.10.0.544  AMXX Dev Team                                      scrollmsg.a  running  

 [ 17] 16  Info. Messages          1.10.0.544  AMXX Dev Team                                      imessage.am  running  

 [ 18] 17  Admin Votes             1.10.0.544  AMXX Dev Team                                      adminvote.a  running  

 [ 19] 18  NextMap                 1.10.0.544  AMXX Dev Team                                      nextmap.amx  running  

 [ 20] 19  Roundsleft              0.2         JGHG              unknown                          roundsleft_  running  

 [ 21] 20  Stats Configuration     1.8.2       AMXX Dev Team     unknown                          statscfg.am  running  

 [ 22] 21  Restrict Weapons        1.10.0.544  AMXX Dev Team                                      restmenu.am  running  

 [ 23] 22  AES: StatsX             0.5+1       serfreeman1337                                     aes_statsx_  running  

 [ 24] 23  StatsX                  1.8.2       AMXX Dev Team     unknown                          statsx.amxx  running  

 [ 25] 24  CS Misc. Stats          1.75        AMXX Dev Team     unknown                          miscstats3.  running  

 [ 26] 25  CS Stats Logging        1.8.2       AMXX Dev Team     unknown                          stats_loggi  running  

 [ 27] 26  Std Admin Color Chat    1.1.1       Van der Cal       unknown                          kgb_admin_c  debug    

 [ 28] 27  Deluxe Admin Chat       1.7         Hell Phoenix/EJL  unknown                          amx_ejl_adm  debug    

 [ 29] 28  Admin Free Look         1.9         Jim               unknown                          admin_freel  debug    

 [ 30] 29  Map Spawns Editor       1.0.16      iG_os             unknown                          Map_Spawns_  debug    

 [ 31] 30  Task Scheduler          0.2         JustinHoMi        unknown                          task_schedu  debug    

 [ 32] 31  Reset Score             1.0         Silenttt          unknown                          ressetscore  debug    

 [ 33] 32  Autoresponder/Advertis  0.5         MaximusBrood      unknown                          ad_manager.  running  

 [ 34] 33  Admin Commands Log      1.2.1       twisterniq        https://github.com/twisterniq/a  admin_comma  running  

 [ 35] 34  Bypass Guard            1.0.1       mx?!                                               bypass_guar  running  

 [ 36] 35  [BG] Provider: GeoIP    0.2         mx?!                                               bg_provider  running  

 [ 37] 36  Admin Spectator ESP     1.3         KoST              unknown                          admin_spec_  running  

 [ 38] 37  Accuracy Fix            3.0         Numb              unknown                          accuracy_fi  running  

 [ 39] 38  Burst Rate of Fire Fix  1.0         Numb              unknown                          burst_rate_  running  

 [ 40] 39  VIP Eng Version         3.0         Dunno             unknown                          VIPfix.amxx  running  

 [ 41] 40  Free VIP                1.0         DoNii             unknown                          viphappyhou  running  

 [ 42] 41  Players Models          1.3.1       ConnorMcLeod      unknown                          players_mod  running  

 [ 43] 42  AMX Slay Losers         1.2         [email protected]   unknown                          slayloser.a  running  

 [ 44] 43  KGB Bots                2.1         OvidiuS & Desika  unknown                          kgbbots.amx  running  

 [ 45] 44  Team Semiclip           2.0.0       schmurgel1983     unknown                          teampsemicl  running  

 [ 46] 45  AMXX Gag                1.2         xPaw & Exolent    unknown                          amx_gag.amx  running  

 [ 47] 46  Weapon Model + Sound R  1.3         GHW_Chronic       unknown                          GHW_Weapon_  running  

 [ 48] 47  Parachute               1.3 Fixed   KRoT@L/JTP10181   unknown                          parachute_k  running  

 [ 49] 48  [ReAPI] No Team Flash   0.0.2       Vaqtincha         unknown                          no_team_fla  running  

 [ 50] 49  WalkGuard               1.3.2       mogel             unknown                          walkguard.a  running  

 [ 51] 50  Alternative End Round   2.3b        Arkshine          unknown                          alt_end_rou  running  

 [ 52] 51  Rates Checker           1.61        pRED*             unknown                          ratescheck.  running  

 [ 53] 52  Invisible Spectator     1.0         ReHLDS Team                                        rehlds_spec  running  

 [ 54] 53  ReChecker Logging       freesrv     custom            unknown                          ReCheckerLo  running  

 [ 55] 54  Auto Join on Connect    0.1         VEN               unknown                          auto_join_o  running  

 [ 56] 55  ReAimDetector API       0.2.2       ReHLDS Team                                        reaimdetect  running  

 [ 57] 56  Advanced Kill Assists   1.3c        Xelson                                             kill_assist  running  

 [ 58] 57  GameName Wins           1.0.4       twisterniq        https://github.com/twisterniq/a  gamename_wi  running  

 [ 59] 58  CS AFK Manager          1.0.6 (amx  Freeman                                            afk_manager  running  

 [ 60] 59  Mode 2x2                2.5re       s1lent                                             mode.amxx    running  

 [ 61] 60  Etrail Autoresponder/A  0.5         MaximusBrood      unknown                          ad_manager2  running  

 [ 62] 61  exploitfix              1           KGB               unknown                          noexploit.a  running  

62 plugins, 62 running

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

Yamikaitou

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

6.13

Исходный код

amxbans forum

Hello everyone,

I have troubles to connect to mysql which is located on same server as counter-strike server.
SQL:

ID	Username	Password	Host	Action
#1	sql_1088672_e9t	ZYV86USF	localhost

When I open phpmyadmin, I have next dbs:

New
Database operations
information_schema
sql_1088672_e9t

How to connect amxbans to sql properly with these settings?

I've tried next:
amx_sql_host "127.0.0.1"
amx_sql_user "sql_1088672_e9t"
amx_sql_pass "ZYV86USF"
amx_sql_db "amx"
amx_sql_table "admins"
amx_sql_type "mysql"

But I of the receive error:
L 10/07/2021 - 21:50:52: [FB] TCONNECTION_FAILED time 0.003784
L 10/07/2021 - 21:50:52: [FB] MYSQL ERROR # 1044
L 10/07/2021 - 21:50:52: [FB] MYSQL ERROR Access denied for user 'sql_1088672_e9t' @ '' to database 'amx'

If I enter in fb_sql_db "amx" , I have error:
L 10/07/2021 - 22:12:12: [FB] TQUERY_FAILED
L 10/07/2021 - 22:12:12: [FB] MYSQL ERROR # 1146
L 10/07/2021 - 22:12:12: [FB] MYSQL ERROR Table 'sql_1088672_e9t.amx_bans' doesn't exist

Yes, error is for FB, but It could be probably be because I dont know to connect amxbans...

Connection file for FB:
fb_kick_delay "3"
fb_server_ip "IP"
fb_server_port "port"
fb_server_name "name"
fb_sql_host "127.0.0.1"
fb_sql_user "sql_1088672_e9t"
fb_sql_pass "ZYV86USF"
fb_sql_db "amx"
fb_sql_table "amx_bans"

 

[Artesian]

drag1c, Зайдите в phpmyadmin и покажите скриншот из раздела users.
Уползователя sql_1088672_e9t есть привилегии на доступ и редактирование базы sql_1088672_e9t?

 

[ernar2021]

Извините если я ошибся Зачем тебе AMXBANS CORE AMXBANS MAIN
тебе надо freshbans.amxx и adminload.amxx

9 Окт 2021

Наверное идёт подключение через sql.cfg к фрешу другое подключение

 

[mazdan]

drag1c, do you have database? do you have tables in your database? Tables are usually created with Web part installation (amxbans, or CS:Bans)

 

[drag1c]

[QUOTE = "mazdan, post: 113433, member: 5031"]
[USER = 7940] drag1c [/ USER], do you have database? do you have tables in your database? Tables are usually created with Web part installation (amxbans, or CS: Bans)
[/ QUOTE]
Your lines completly explained me how to fix my problem.

I've expected amxbans, connected to SQL will autoinstall tables, but I have to do it with web part installation. I didnt know that.

Thank you very much !