[gmamxbans][ROZWIĄZANE] Amxbans nie banuje na serwerze - Problemy

GmAMXBans
[ROZWIĄZANE] Amxbans nie banuje na serwerze

Zablokowany

BooYa 11.02.2013

Witam!
Otóż zainstalowałem sobie na serwerze amxbans.
Miałem nieco problemy bo była to moja pierwsza instalacja amxbans'a, ale poradziłem sobie.
Najpierw zainstalowałem amxbansa na stronie, na forum, mam na xaa.
Następnie wrzuciłem pliki na serwer.
Serwer do amxbans'a się nie dodał, więc dodałem ręcznie przez phpmyadmin.
Wszystko elegancko ale jest gracz i nie mogę go zbanować. Jak za chwilę chcę go zbanować ponownie to ma już nick szary i nie da się, ale nadal gra.
Proszę o pomoc ! Jedynie można zrobić ssy.
Jeśli ktoś pomoże, to chętnie dam +.
Daje jeszcze logi.

Spoiler

L 02/11/2013 - 23:41:52: [amxbans_core.amxx] [AMXBans] WARNING: admin.amxx plugin running! stopped.
[AMXBans] plugin_cfg: ip 178.19.106.138:27065 / prefix amx
L 02/11/2013 - 23:41:52: [amxbans_main.amxx] [AMXBans] Received DB Info Tuple from amxbans_core: 1 | amx
[AMXBans] Loaded 11 admins from file
[AMXBans] The server IP:PORT is: 178.19.106.138:27065
L 02/11/2013 - 23:41:52: [amxbans_main.amxx] [AMXBans] The server IP:PORT is: 178.19.106.138:27065
L 02/11/2013 - 23:41:52: [amxbans_main.amxx] [AMXBans] Connection failed!
L 02/11/2013 - 23:41:52: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5
L 02/11/2013 - 23:41:52: [amxbans_main.amxx] [AMXBans] Message: Access denied for user '[user]'@'localhost' (using password: TAK) (1045)
L 02/11/2013 - 23:41:52: [amxbans_main.amxx] [AMXBans] Query statement:
[AMXBans] No Reasons found
[AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 02/11/2013 - 23:41:52: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 02/11/2013 - 23:41:52: [amxbans_main.amxx] [AMXBans] Connection failed!
L 02/11/2013 - 23:41:52: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 1
L 02/11/2013 - 23:41:52: [amxbans_main.amxx] [AMXBans] Message: Access denied for user '[user]'@'localhost' (using password: TAK) (1045)
L 02/11/2013 - 23:41:52: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '178.19.106.138:27065'
Connection to Steam servers successful.
   VAC secure mode is activated.
Menu item 17 added to Menus Front-End: "AMXBans: Player-Flagging" from plugin "AMXBans Main"
Menu item 18 added to Menus Front-End: "AMXBans: Disconnected Players" from plugin "AMXBans Main"
Menu item 19 added to Menus Front-End: "AMXBans: Banhistory" from plugin "AMXBans Main"
Menu item 20 added to Menus Front-End: "AMXBans: Screens" from plugin "AMXBans: Screens"

sql.cfg

Spoiler

amx_sql_host "127.0.0.1"
amx_sql_user "user"
amx_sql_pass "moje haslo"
amx_sql_db   "baza"
amx_sql_table "admins"
amx_sql_type "mysql"

modules.ini

Spoiler

;;;
; To enable a module, remove the semi-colon (  in front of its name.
; If it's not here, simply add it its name, one per line.
; You don't need to write the _amxx part or the file extension.
;;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; SQL Modules usually need to be enabled manually ;;
;; You can have any number on at a time.  Use	  ;;
;;  amx_sql_type in sql.cfg to specify the default ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
mysql
sqlite
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; Put third party modules below here.			  ;;
;; You can just list their names, without the _amxx ;;
;;  or file extension.							  ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; These modules will be auto-detected and loaded   ;;
;;  as needed.  You do not need to enable them here ;;
;;  unless you have problems.					   ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
fun
engine
fakemeta
geoip
sockets
regex
nvault
cstrike
csx
hamsandwich

plugins.ini

Spoiler

; AMX Mod X plugins
amxbans_core.amxx
amxbans_main.amxx debug
; Admin Base - Always one has to be activated
admin.amxx  ; admin base (required for any admin-related)
;admin_sql.amxx  ; admin base - SQL version (comment admin.amxx)
; Basic
admincmd.amxx  ; basic admin console commands
adminhelp.amxx  ; help command for admin console commands
adminslots.amxx  ; slot reservation
multilingual.amxx ; Multi-Lingual management
; Menus
menufront.amxx  ; front-end for admin menus
cmdmenu.amxx; teammenu_nokill.amxx  ; command menu (speech, settings)
plmenu.amxx  ; players menu (kick, ban, client cmds.)
;telemenu.amxx  ; teleport menu (Fun Module required!)
mapsmenu.amxx  ; maps menu (vote, changelevel)
; Chat / Messages
adminchat.amxx  ; console chat commands
antiflood.amxx  ; prevent clients from chat-flooding the server
scrollmsg.amxx  ; displays a scrolling message
imessage.amxx  ; displays information messages
adminvote.amxx  ; vote commands
; Map related
nextmap.amxx  ; displays next map in mapcycle
;mapchooser.amxx  ; allows to vote for next map
timeleft.amxx  ; displays time left on map
; Configuration
pausecfg.amxx  ; allows to pause and unpause some plugins
statscfg.amxx  ; allows to manage stats plugins via menu and commands
; Counter-Strike
;restmenu.amxx  ; restrict weapons menu
statsx.amxx   ; stats on death or round end (CSX Module required!)
banner.amxx   ; FPSplay plugins
server_connect_message.amxx
;miscstats.amxx  ; bunch of events announcement for Counter-Strike
;stats_logging.amxx ; weapons stats logging (CSX Module required!)
; Enable to use AMX Mod plugins
;amxmod_compat.amxx ; AMX Mod backwards compatibility layer
... [ Inne pluginy które się nie łączą z amxbansem ]

Dodam jeszcze że nie czyta mi adminów jak dodam do amxbansa tylko z users.ini

Odpowiedz

Kawon 11.02.2013

admin.amxx

Wyłącz

L 02/11/2013 - 23:41:52: [amxbans_main.amxx] [AMXBans] Message: Access denied for user '[user]'@'localhost' (using password: TAK) (1045)

AMXBANS i MySQL. TUTORIAL

Odpowiedz

BooYa 11.02.2013

Wyłączałem ale to nic nie dało.

Spoiler

[AMXBans] plugin_cfg: ip 178.19.106.138:27065 / prefix amx
L 02/11/2013 - 23:56:27: [amxbans_main.amxx] [AMXBans] Received DB Info Tuple from amxbans_core: 1 | amx
[AMXBans] Loaded 11 admins from file
[AMXBans] The server IP:PORT is: 178.19.106.138:27065
L 02/11/2013 - 23:56:27: [amxbans_main.amxx] [AMXBans] The server IP:PORT is: 178.19.106.138:27065
L 02/11/2013 - 23:56:27: [amxbans_main.amxx] [AMXBans] Connection failed!
L 02/11/2013 - 23:56:27: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5
L 02/11/2013 - 23:56:27: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'user'@'localhost' (using password: TAK) (1045)
L 02/11/2013 - 23:56:27: [amxbans_main.amxx] [AMXBans] Query statement:
[AMXBans] No Reasons found
[AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 02/11/2013 - 23:56:27: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 02/11/2013 - 23:56:27: [amxbans_main.amxx] [AMXBans] Connection failed!
L 02/11/2013 - 23:56:27: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 1
L 02/11/2013 - 23:56:27: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'user'@'localhost' (using password: TAK) (1045)
L 02/11/2013 - 23:56:27: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '178.19.106.138:27065'
Connection to Steam servers successful.
   VAC secure mode is activated.
Menu item 17 added to Menus Front-End: "AMXBans: Player-Flagging" from plugin "AMXBans Main"
Menu item 18 added to Menus Front-End: "AMXBans: Disconnected Players" from plugin "AMXBans Main"
Menu item 19 added to Menus Front-End: "AMXBans: Banhistory" from plugin "AMXBans Main"
Menu item 20 added to Menus Front-End: "AMXBans: Screens" from plugin "AMXBans: Screens"

Kawon (11.02.2013 23:54):
Pokaż nowe logi.

Odpowiedz

Kawon 12.02.2013

Pokaż sql.cfg tak jak masz uzupełnione tylko ukryj hasło....

Odpowiedz

BooYa 12.02.2013

Spoiler

amx_sql_host "127.0.0.1"

amx_sql_user "p227731_Aroxik"

amx_sql_pass "xxxxxxxx"

amx_sql_db   "p227731_napiwek"

amx_sql_table "admins"

amx_sql_type "mysql"

Kawon (12.02.2013 22:42):
Kod w postach (np. źródło pluginu) umieszczaj w odpowiednich tagach (code/php/spoiler itp), a powyżej 200 linijek tylko w załączniku lub na wklejce.

Odpowiedz

Kawon 12.02.2013

zamiast 127.0.0.1 wpisz nazwę domeny bez www i http
przykład:

amx_sql_host "amxx.pl"

Odpowiedz

MaroTM 12.02.2013

127.0.0.1 to host lokalny, czyli wychodzi na to, że chcesz się łączyć z AmxBansem wewnętrznym (jakby hosting na którym masz AmxBansa jest w twoim domu

), a musisz się łączyć z zewnętrznym (dla proserwer.pl to będzie np. amx_sql_host "cs-[CENZURA].xaa.pl")
Użytkownik Dangerous97 edytował ten post 12.02.2013 22:51

Odpowiedz

BooYa 13.02.2013

No tak zmieniłem to i nadal to samo.

Kawon (13.02.2013 00:18):
podaj nowe logi...

Odpowiedz

BooYa 14.02.2013

Nowe Logi

Spoiler

[AMXBans] Loaded 11 admins from file
L 02/14/2013 - 20:54:15: [amxbans_main.amxx] [AMXBans] Connection failed!
L 02/14/2013 - 20:54:15: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 1
L 02/14/2013 - 20:54:15: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'p227731_Aroxik'@'178.19.107.210' (using password: YES) (1045)
L 02/14/2013 - 20:54:15: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '178.19.106.138:27065'
L 02/14/2013 - 20:54:15: [amxbans_main.amxx] [AMXBans] Connection failed!
L 02/14/2013 - 20:54:15: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5
L 02/14/2013 - 20:54:15: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'p227731_Aroxik'@'178.19.107.210' (using password: YES) (1045)
L 02/14/2013 - 20:54:15: [amxbans_main.amxx] [AMXBans] Query statement:
[AMXBans] No Reasons found
[AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 02/14/2013 - 20:54:15: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.
Connection to Steam servers successful.
   VAC secure mode is activated.
Menu item 17 added to Menus Front-End: "AMXBans: Player-Flagging" from plugin "AMXBans Main"
Menu item 18 added to Menus Front-End: "AMXBans: Disconnected Players" from plugin "AMXBans Main"
Menu item 19 added to Menus Front-End: "AMXBans: Banhistory" from plugin "AMXBans Main"
Menu item 20 added to Menus Front-End: "AMXBans: Screens" from plugin "AMXBans: Screens"

Użytkownik BooYa edytował ten post 14.02.2013 21:24

Odpowiedz

Kawon 14.02.2013

zrobiłeś dobrze?

w amxbans.cfg ustaw:

amxbans_use_admins_file 0

Odpowiedz

BooYa 14.02.2013

No tak ustawiłem, tylko wtedy wcale adminów mi nie czyta. :c

Dobra wszystko już śmiga !

Chodziło o to że w Menadżerze zdalnego połączenia MySql trzeba było dodać %, a ja tego nie zrobiłem.
Dzięki wielkie.
Kawon +. !

Temat do zamknięcia

Odpowiedz

Kawon 14.02.2013

Wiadomość wygenerowana automatycznie

Ten temat został zamknięty przez moderatora.

Powód: Pomoc udzielona

Jeśli się z tym nie zgadzasz, Dołączona grafika