SQL Connection for amxbans and fresh bans

Статус
В этой теме нельзя размещать новые ответы.
Сообщения
14
Реакции
0
Ошибка
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 [email protected]/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:
IDUsernamePasswordHostAction
#1sql_1088672_e9tZYV86USFlocalhost

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"
 
В этой теме было размещено решение! Перейти к решению.
Последнее редактирование:
Сообщения
31
Реакции
16
Помог
1 раз(а)
drag1c, Зайдите в phpmyadmin и покажите скриншот из раздела users.
Уползователя sql_1088672_e9t есть привилегии на доступ и редактирование базы sql_1088672_e9t?
 
Сообщения
47
Реакции
-7
Извините если я ошибся Зачем тебе AMXBANS CORE AMXBANS MAIN
тебе надо freshbans.amxx и adminload.amxx
9 Окт 2021
Наверное идёт подключение через sql.cfg к фрешу другое подключение
 
Сообщения
16
Реакции
52
Помог
2 раз(а)
drag1c, do you have database? do you have tables in your database? Tables are usually created with Web part installation (amxbans, or CS:Bans)
 
Сообщения
14
Реакции
0
[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 !
 
Статус
В этой теме нельзя размещать новые ответы.

Пользователи, просматривающие эту тему

Сейчас на форуме нет ни одного пользователя.
Сверху Снизу