AMXX.pl: Support AMX Mod X i SourceMod

Witam
Mam problem z polaczeniem sie z bazą
nie wiem co tu wpisac
amx_sql_host "xxxxxxx"
Probowalem juz wszyskiego. mam zainstalowany amxxbans 5.0
Pozdrawiam i proszę o pomoc

Wersję AMXMODX (1.8.1)
Wersję serwera: dproto steam/ns
Logi

12/16/2010 - 15:39:52: [amxbans.amxx] [Amxbans] Threaded query error, location: 6
L 12/16/2010 - 15:39:52: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:39:52: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:40:19: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:40:19: [amxbans.amxx] [Amxbans] Threaded query error, location: 16
L 12/16/2010 - 15:40:19: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:40:19: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:40:19: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:40:19: [amxbans.amxx] [Amxbans] Threaded query error, location: 17
L 12/16/2010 - 15:40:19: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:40:19: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:40:20: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:40:20: [amxbans.amxx] [Amxbans] Threaded query error, location: 17
L 12/16/2010 - 15:40:20: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:40:20: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:40:20: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:40:20: [amxbans.amxx] [Amxbans] Threaded query error, location: 16
L 12/16/2010 - 15:40:20: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:40:20: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:40:28: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:40:28: [amxbans.amxx] [Amxbans] Threaded query error, location: 16
L 12/16/2010 - 15:40:28: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:40:28: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:40:28: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:40:28: [amxbans.amxx] [Amxbans] Threaded query error, location: 17
L 12/16/2010 - 15:40:28: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:40:28: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:41:19: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:41:19: [amxbans.amxx] [Amxbans] Threaded query error, location: 16
L 12/16/2010 - 15:41:19: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:41:19: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:41:19: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:41:19: [amxbans.amxx] [Amxbans] Threaded query error, location: 17
L 12/16/2010 - 15:41:19: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:41:19: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:42:01: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:42:01: [amxbans.amxx] [Amxbans] Threaded query error, location: 16
L 12/16/2010 - 15:42:01: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:42:01: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:42:01: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:42:01: [amxbans.amxx] [Amxbans] Threaded query error, location: 17
L 12/16/2010 - 15:42:01: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:42:01: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:42:55: [admin.amxx] Login: "Polski-Net # SzAkAl<98><STEAM_0:1:36014872><>" became an admin (account "STEAM_0:1:36014872") (access "bcdefghijklmnopqrstu") (address "83.24.71.81")
L 12/16/2010 - 15:42:56: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:42:56: [amxbans.amxx] [Amxbans] Threaded query error, location: 16
L 12/16/2010 - 15:42:56: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:42:56: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:42:56: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:42:56: [amxbans.amxx] [Amxbans] Threaded query error, location: 17
L 12/16/2010 - 15:42:56: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:42:56: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:43:26: [adminchat.amxx] Chat: "Polski-Net # SzAkAl<98><STEAM_0:1:36014872><>" tsay "elo"
L 12/16/2010 - 15:47:00: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:47:00: [amxbans.amxx] [Amxbans] Threaded query error, location: 16
L 12/16/2010 - 15:47:00: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:47:00: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:47:00: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:47:00: [amxbans.amxx] [Amxbans] Threaded query error, location: 17
L 12/16/2010 - 15:47:00: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:47:00: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:47:02: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:47:02: [amxbans.amxx] [Amxbans] Threaded query error, location: 16
L 12/16/2010 - 15:47:02: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:47:02: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:47:02: [amxbans.amxx] [Amxbans] Connection failed!
L 12/16/2010 - 15:47:02: [amxbans.amxx] [Amxbans] Threaded query error, location: 17
L 12/16/2010 - 15:47:02: [amxbans.amxx] [Amxbans] Message: Unknown MySQL server host '[email protected]' (1) (2005)
L 12/16/2010 - 15:47:02: [amxbans.amxx] [Amxbans] Query statement: 
L 12/16/2010 - 15:50:50: [adminchat.amxx] Chat: "Polski-Net # SzAkAl<98><STEAM_0:1:36014872><>" tsay "za autolame ban ba tym serwie!!!"

Plugins.ini

; AMX Mod X plugins

; 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)
amxbans.amxx        ;AMXBans

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

; 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

admin_freelook.amxx
admin_check.amxx
adminlisten.amxx
amx_ip.amxx
chat_info.amxx
dontsayips.amxx
hpk.amxx
descriptive_fire_in_the_hole.amxx
pokazuj.amxx
ReasonKicker.amxx
bcd_hudtimer.amxx
polski_cs.amxx
ad_manager.amxx
ultimate_sounds.amxx
mapchooser4.amxx
you.amxx
unbanmenu.amxx
interpchanger.amxx
alt_end_round_sounds.amxx
ptb.amxx
;server_connect_message.amxx
menu.amxx
amx_snapshot.amxx

Modules.ini

;;;
; To enable a module, remove the semi-colon (<img src='https://amxx.pl/public/style_emoticons/<#EMO_DIR#>/wink.gif' class='bbc_emoticon' alt=';)' /> 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

sql.cfg

// SQL configuration file
// File location: $moddir/addons/amxmodx/configs/sql.cfg

// *NOTE* Linux users may encounter problems if they specify "localhost" instead of "127.0.0.1"
// We recommend using your server IP address instead of its name

// *NOTE* amx_sql_type specifies the DEFAULT database type which admin.sma will use.

amx_sql_host	"nie wiem co tu wpisac"
amx_sql_user	"counters_cs"
amx_sql_pass	"xxxxxx"
amx_sql_db	"counters_bany"
amx_sql_table	"admins"
amx_sql_type	"mysql"

Host to jest nazwa strony na jakiej masz baze danych. Ja mam tak :

amx_sql_host db4free.net (w to miejsce musisz wpisać nazwę strony na jakiej masz baze danych)
Użytkownik Szymon95 edytował ten post 16.12.2010 15:59

Na jakim hostingu masz postawiony amxbans ?

wykupilem strone i hosting z glowanet.pl tam tez mam utrozona bazę

wpisz tam adres hosta bazy danych proste

nierozumiem

Dodano 17 grudzień 2010 - 17:54:
jaki adres hosta ??? nie wiem o co w ogóle chodzi

Dodano 18 grudzień 2010 - 18:10:
a jak sparwdzic adres hosta bazy danych?

jak ty nei wiesz co to jest Ip hosta to sie nei bierz za amxbans

muszi tam wpsiac IP.

wejdz w directadmin albo cpanel i tam masz Ip wpisane

no wszedłem w cpanel i nie widze tam ip hosta.
Gdzie on sie dokladnie znajduje?

po lewej stronie

a dzie dokladnie?

ss:

jak nie masz IP tam to wpisz w cmd.exe -> ping twoja.strona i wyskoczy ci IP...
co prawda ja tam widzę tabelkę: "IP"

L 12/19/2010 - 14:27:02: [amxbans.amxx] [Amxbans] Connection failed!
L 12/19/2010 - 14:27:02: [amxbans.amxx] [Amxbans] Threaded query error, location: 16
L 12/19/2010 - 14:27:02: [amxbans.amxx] [Amxbans] Message: Can't connect to MySQL server on '178.248.75.84' (110) (2003)
L 12/19/2010 - 14:27:02: [amxbans.amxx] [Amxbans] Query statement:

a wyłącz moduł sqlite (postaw średnik na początku linijki z nim)

L 12/19/2010 - 17:33:26: [amxbans.amxx] [Amxbans] Connection failed!
L 12/19/2010 - 17:33:26: [amxbans.amxx] [Amxbans] Threaded query error, location: 16
L 12/19/2010 - 17:33:26: [amxbans.amxx] [Amxbans] Message: Can't connect to MySQL server on '178.248.75.84' (110) (2003)
L 12/19/2010 - 17:33:26: [amxbans.amxx] [Amxbans] Query statement:

ten host (178.248.75.84) jest poprawny w ogóle ?
Może inny port, bo na tym to serwera MySQL nie widać

mysql -h 178.248.75.84
ERROR 2003 (HY000): Can't connect to MySQL server on '178.248.75.84' (110)

telnet 178.248.75.84 3306
Trying 178.248.75.84...
telnet: Unable to connect to remote host: Connection timed out

ten host znajduje sie w tej tabelce co jest u góry kolo IP