AMXX.pl: Support AMX Mod X i SourceMod

Chopy pomocy chyba internet popsułem. Z tego co mi sie wydaje to nie łączy z msql, sam juz nie wiem.
Jak ktos wie to niech sie wypowie i pomoże będą pozytywy.
 wersja amxbans 1.6.1 + poprawki

Czysty amxx 1.8.1 chodz nie wiem czy na to wpływa

dproto 0.9.369 + VTC

 

logi

L 05/12/2014 - 00:41:52: [amxbans_core.amxx] [AMXBANS] Index: 1
L 05/12/2014 - 00:41:52: [amxbans_core.amxx] [AMXBANS] Index: 1 | Name:
L 05/12/2014 - 00:41:52: Function is not present (function "check_player") (plugin "amxbans_main.amxx")
L 05/12/2014 - 00:41:52: [] Displaying debug trace (plugin "amxbans_main.amxx")
L 05/12/2014 - 00:41:52: [] Run time error 10: native error (native "set_task")
L 05/12/2014 - 00:41:52: [] [0] amxbans_main_2273738.sma::client_authorized (line 289)
[AMXBans] SQL error: can't connect: 'Can't connect to MySQL server on '192.168.1.106' (110)'
Connection to Steam servers successful.
VAC secure mode is activated.
L 05/12/2014 - 00:43:59: [name_reg.amxx] Error on nick_handle query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 05/12/2014 - 00:43:59: [name_reg.amxx] Could not connect to SQL database.
L 05/12/2014 - 00:43:59: [amxbans_main.amxx] [AMXBans] Connection failed!
L 05/12/2014 - 00:43:59: [amxbans_main.amxx] [AMXBans] Message: Can't connect to MySQL server on '192.168.1.106' (110) (2003)
L 05/12/2014 - 00:43:59: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '80.72.41.98:27035';
144.76.16.8:27392:reconnect
L 05/12/2014 - 00:44:00: [amxbans_core.amxx] [AMXBANS] Index: 1
L 05/12/2014 - 00:44:00: [amxbans_core.amxx] [AMXBANS] Index: 1 | Name:
L 05/12/2014 - 00:44:00: Function is not present (function "check_player") (plugin "amxbans_main.amxx")
L 05/12/2014 - 00:44:00: [] Displaying debug trace (plugin "amxbans_main.amxx")
L 05/12/2014 - 00:44:00: [] Run time error 10: native error (native "set_task")
L 05/12/2014 - 00:44:00: [] [0] amxbans_main_2273738.sma::client_authorized (line 289)
Menu item 20 added to Menus Front-End: "AMXBans: Player-Flagging" from plugin "AMXBans: Main"
Menu item 21 added to Menus Front-End: "AMXBans: Disconnected Players" from plugin "AMXBans: Main"
Menu item 22 added to Menus Front-End: "AMXBans: Banhistory" from plugin "AMXBans: Main"
L 05/12/2014 - 00:44:02: HLTV CS-AGGRO.PL @ Zabijaka.pl <>HLTV><>144.76.16.8:27392><>8fb71874ca2c2440ea522489e12d5011> put in server
Segmentation fault

sql.cfg

amx_sql_host	"192.168.1.106"
amx_sql_user	"zielony0_amx"
amx_sql_pass	"*********"
amx_sql_db	"zielony0_amx"
amx_sql_table	"admins"
amx_sql_type	"mysql"

plugins.ini

; 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          ;  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)        
pluginmenu.amxx          ;  Menus for commands/cvars organized by plugin      

; 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!)   
;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       

; Custom - Add 3rd party plugins here
c4timer.amxx          ; 
afkbombtransfer.amxx          ; 
galileo.amxx          ; 
extreme_bancfg2.amxx          ; 
bf2rank.amxx          ; 
parachute.amxx          ; 
vip.amxx          ; 
name_reg.amxx          ; 
afkkicker.amxx          ; 
hpk.amxx          ; 
alt_end_round_sounds.amxx          ; 

modules.ini

;;;
; 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

Użytkownik Pan Zielony edytował ten post 12.05.2014 00:02

Tu
amx_sql_host "192.168.1.106"
Wpisz nazwe sie bez "www" na poczatku czyli np:
amx_sql_host "amxx.pl"

To raczej bez znaczenia .... ale zrob jak radzi @UP

// I skad wytrzasnoles adres 192.168 ****
Stoi u Cb w domu ?
Użytkownik CzarNNaninJJa^^ edytował ten post 12.05.2014 06:38

Dopiero przyszedłem, zaraz sprawdzę czy działa i dodam edit a IP jak na ss.

 

Daj adres zamiast IP [...]

// Jak radzil iroNZ

Jak dodałem adres strony to z konsoli

 

A % i ip serwera jest dodane jak w pierwszym ss widac.

L 05/12/2014 - 17:27:13: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '80.72.41.98:27035'
L 05/12/2014 - 17:27:13: [amxbans_main.amxx] [AMXBans] Connection failed!
L 05/12/2014 - 17:27:13: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5
L 05/12/2014 - 17:27:13: [amxbans_main.amxx] [AMXBans] Message: Host '80.72.41.98' is not allowed to connect to this MySQL server (1130)
L 05/12/2014 - 17:27:13: [amxbans_main.amxx] [AMXBans] Query statement:
[AMXBans] No Reasons found
[AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 05/12/2014 - 17:27:13: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.
Menu item 19 added to Menus Front-End: "AMXBans: Player-Flagging" from plugin "AMXBans Main"
Menu item 20 added to Menus Front-End: "AMXBans: Disconnected Players" from plugin "AMXBans Main"
Menu item 21 added to Menus Front-End: "AMXBans: Banhistory" from plugin "AMXBans Main"
Menu item 22 added to Menus Front-End: "AMXBans: Screens" from plugin "AMXBans: Screens"
MasterRequestRestart
Your server needs to be restarted in order to receive the latest update.

Użytkownik Pan Zielony edytował ten post 12.05.2014 16:29

Spróbuj dać 127.0.0.1 do zezwolonych hostow

Edit. Po co zamazałeś screena !?
Przecież to samo jest w sql.cfg ...

A na 99% to jest przyczyną
Użytkownik CzarNNaninJJa^^ edytował ten post 12.05.2014 18:35

Spróbuj dać 127.0.0.1 do zezwolonych hostow

 

 

192.168.1.106 to wewnętrzne IP, znajdź w panelu adres MySQL dla połączeń z zewnątrz, jeśli takowego nie ma to pisz do webd.

Znajdziesz/dostaniesz to IP, to wpisujesz je przy amx_sql_host.

Następny błąd, który może się pojawić w zwykłych logach to

[amxbans_main.amxx] [AMXBans] Message: Access denied for user 'xxx'@'12.123.123.123' (using password: YES)

Dodajesz wtedy IP widniejące w logu do menedżera zdalnego połączenia MySQL.

Użytkownik master522 edytował ten post 12.05.2014 18:49

Spróbuj dać 127.0.0.1 do zezwolonych hostow

192.168.1.106 to wewnętrzne IP, znajdź w panelu adres MySQL dla połączeń z zewnątrz, jeśli takowego nie ma to pisz do webd.
Znajdziesz/dostaniesz to IP, to wpisujesz je przy amx_sql_host.
Następny błąd, który może się pojawić w zwykłych logach to

[amxbans_main.amxx] [AMXBans] Message: Access denied for user 'xxx'@'12.123.123.123' (using password: YES)

Dodajesz wtedy IP widniejące w logu do menedżera zdalnego połączenia MySQL.

Przecież 127.0.0.1 to localhost ...
Zazwyczaj jest na 1 miejsu i nie mozna go usunac ...
A z tego co widac na SS zewnetrznym adresem jest 192.168.1.106 [...]

zapomniałem wspomniec ze jak jest ip 192.168.1.106  w sql.cfg to serwer pada nie chce sie włączyć.

działa po restarcie ale jak zmienia mape to wywala caly serwer

L 05/12/2014 - 21:20:57: [amxbans_main.amxx] [AMXBans] Connection failed!
L 05/12/2014 - 21:20:57: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5
L 05/12/2014 - 21:20:57: [amxbans_main.amxx] [AMXBans] Message: Can't connect to MySQL server on '192.168.1.106' (110) (2003)
L 05/12/2014 - 21:20:57: [amxbans_main.amxx] [AMXBans] Query statement:
[AMXBans] No Reasons found
[AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 05/12/2014 - 21:20:57: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.

Użytkownik Pan Zielony edytował ten post 12.05.2014 20:24

Moze logi ...

Console initialized.
Using breakpad crash handler
Setting breakpad minidump AppID = 10
Forcing breakpad minidump interfaces to load
Looking up breakpad interfaces from steamclient
Calling BreakpadMiniDumpSystemInit
Installing breakpad exception handler for appid(10)/version(5787)
scandir failed:/home/servers/s37456/SAVE
scandir failed:/home/servers/s37456/./valve/SAVE
scandir failed:/home/servers/s37456/./platform/SAVE
Protocol version 48
Exe version 1.1.2.6/Stdio (cstrike)
Exe build: 11:30:00 Aug 28 2012 (5787)
STEAM Auth Server
Server IP address 80.72.41.98:27035

Metamod version 1.19p32 Copyright (c) 2001-2006 Will Day
Patch: Metamod-P (mm-p) v32 Copyright (c) 2004-2007 Jussi Kivilinna
Metamod comes with ABSOLUTELY NO WARRANTY; for details type `meta gpl'.
This is free software, and you are welcome to redistribute it
under certain conditions; type `meta gpl' for details.


AMX Mod X version 1.8.2-dev Copyright (c) 2004-2006 AMX Mod X Development Team
AMX Mod X comes with ABSOLUTELY NO WARRANTY; for details type `amxx gpl'.
This is free software and you are welcome to redistribute it under
certain conditions; type 'amxx gpl' for details.

Version 0.9.369 Linux
[DPROTO]: Loading config './dproto.cfg'
[DPROTO]: LoggingMode = 2
[DPROTO]: Config sucessfully loaded.
[DPROTO]: Done.
scandir failed:/home/servers/s37456/SAVE
scandir failed:/home/servers/s37456/./valve/SAVE
scandir failed:/home/servers/s37456/./platform/SAVE
L 05/12/2014 - 21:31:43: -------- Mapchange to de_dust2 --------
stray key in process_key: item_getiteminfo 63
L 05/12/2014 - 21:31:43: [] Plugin file open error (plugin "afkkiss.amxx")
Executing AMX Mod X Configuration File
Scrolling message displaying frequency: 10:00 minutes
[AMXBans] laduje plik amxbans.cfg
[AMXBans] amxbans.cfg zostal zaladowany | .PL | Wersja PL - Szyfrant i MisieQ
Looking up breakpad interfaces from steamclient
Calling BreakpadMiniDumpSystemInit

[AMXBans] Loaded 8 admins from file
Menu item 17 added to Menus Front-End: "Plugin Cvars" from plugin "pluginmenu.amxx"
Menu item 18 added to Menus Front-End: "Plugin Commands" from plugin "pluginmenu.amxx"
Connection to Steam servers successful.
VAC secure mode is activated.
Menu item 19 added to Menus Front-End: "AMXBans: Player-Flagging" from plugin "AMXBans Main"
Menu item 20 added to Menus Front-End: "AMXBans: Disconnected Players" from plugin "AMXBans Main"
Menu item 21 added to Menus Front-End: "AMXBans: Banhistory" from plugin "AMXBans Main"
Menu item 22 added to Menus Front-End: "AMXBans: Screens" from plugin "AMXBans: Screens"
MasterRequestRestart
Your server needs to be restarted in order to receive the latest update.
L 05/12/2014 - 21:33:51: [amxbans_main.amxx] [AMXBans] Connection failed!
L 05/12/2014 - 21:33:51: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 1
L 05/12/2014 - 21:33:51: [amxbans_main.amxx] [AMXBans] Message: Can't connect to MySQL server on '192.168.1.106' (110) (2003)
L 05/12/2014 - 21:33:51: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '80.72.41.98:27035'

To są całe logi po resecie, wbijam na serwer  jak zmieniam mape to w konsoli wyskakuje ze zmieniam mape i nic wiecej w logach i po jakis 5 min serw sam sie resetuje

Użytkownik Pan Zielony edytował ten post 12.05.2014 20:46

A z tego co widac na SS zewnetrznym adresem jest 192.168.1.106 [...]

Nie jest.
Ja już rozwiązanie podałem, co zrobisz to już od Ciebie zależy.

A wpisz "zielony0.webd.pl" do amx_sql_host ...

Niestety nie działa robiłem to juz milion razy od piątku próbuje ro zrobić... miliony amxbans pobrałem i ni chu nie działa

Ps. Czy cos zmienia jak strona amxbans nie jest w głównym katalogu np cs-aggro.pl/bans ?? bo w głównym katalogu mam forum.

log

Menu item 17 added to Menus Front-End: "Plugin Cvars" from plugin "pluginmenu.amxx"
Menu item 18 added to Menus Front-End: "Plugin Commands" from plugin "pluginmenu.amxx"
L 05/12/2014 - 22:59:55: [amxbans_main.amxx] [AMXBans] Connection failed!
L 05/12/2014 - 22:59:55: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 1
L 05/12/2014 - 22:59:55: [amxbans_main.amxx] [AMXBans] Message: Host '80.72.41.98' is not allowed to connect to this MySQL server (1130)
L 05/12/2014 - 22:59:55: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '80.72.41.98:27035'
L 05/12/2014 - 22:59:55: [amxbans_main.amxx] [AMXBans] Connection failed!
L 05/12/2014 - 22:59:55: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5
L 05/12/2014 - 22:59:55: [amxbans_main.amxx] [AMXBans] Message: Host '80.72.41.98' is not allowed to connect to this MySQL server (1130)
L 05/12/2014 - 22:59:55: [amxbans_main.amxx] [AMXBans] Query statement:
[AMXBans] No Reasons found
[AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 05/12/2014 - 22:59:55: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.
Menu item 19 added to Menus Front-End: "AMXBans: Player-Flagging" from plugin "AMXBans Main"
Menu item 20 added to Menus Front-End: "AMXBans: Disconnected Players" from plugin "AMXBans Main"
Menu item 21 added to Menus Front-End: "AMXBans: Banhistory" from plugin "AMXBans Main"
Menu item 22 added to Menus Front-End: "AMXBans: Screens" from plugin "AMXBans: Screens"
MasterRequestRestart
Your server needs to be restarted in order to receive the latest update.
L 05/12/2014 - 23:01:25: [amxbans_main.amxx] [AMXBans] Connection failed!
L 05/12/2014 - 23:01:25: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 17
L 05/12/2014 - 23:01:25: [amxbans_main.amxx] [AMXBans] Message: Host '80.72.41.98' is not allowed to connect to this MySQL server (1130)
L 05/12/2014 - 23:01:25: [amxbans_main.amxx] [AMXBans] Query statement:
L 05/12/2014 - 23:01:26: [amxbans_main.amxx] [AMXBans] Connection failed!
L 05/12/2014 - 23:01:26: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 16
L 05/12/2014 - 23:01:26: [amxbans_main.amxx] [AMXBans] Message: Host '80.72.41.98' is not allowed to connect to this MySQL server (1130)
L 05/12/2014 - 23:01:26: [amxbans_main.amxx] [AMXBans] Query statement: 

Użytkownik Pan Zielony edytował ten post 12.05.2014 22:07

No to zostaje 1 rozwiazanie ... złe passy do bazy Mysql

Proszę nie rób sobie jaj. Wszedzie daje to samo hasło

Ps.

L 05/12/2014 - 23:01:26: [amxbans_main.amxx] [AMXBans] Message: Host '80.72.41.98' is not allowed to connect to this MySQL server (1130)

Ten log chyba oznacza ze nie dalem ip serwera do bazy mysql ale jak na ss widzc wyżej to ip jest i % tez jest

 

@ edit

moze przez to ze daje czytanie adminów z users.ini

 

internet popsuty w pół ...

Użytkownik Pan Zielony edytował ten post 12.05.2014 22:56

Twoj uzytkownik nazywa sie tak samo jak baza ?

tak, latwiej wszedzie to samo

Zrób jak radził master522 ...