Hello I've been struggling the past two hours to make this work. The first 20 minutes was about an error with a function, it failed because i had 1.8.0 . Stupid host installs 1.8.0 by default.
In any case i now the plugin fails with:
Code:
L 09/02/2009 - 06:15:49: [AMXX] Plugin ("advanced_bans_sql.amxx") is setting itself as failed.
L 09/02/2009 - 06:15:49: [AMXX] Plugin says: Could not connect to database.
L 09/02/2009 - 06:15:49: [AMXX] Displaying debug trace (plugin "advanced_bans_sql.amxx")
L 09/02/2009 - 06:15:49: [AMXX] Run time error 1: forced exit
L 09/02/2009 - 06:15:49: [AMXX] [0] 42862.attach::QueryCreateTable (line 402)
Here are some configurations which may or not be relevant:
Amxmodx version is 1.8.1.
modules.ini:
Code:
;;;
; 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
netdb
sql.cfg:
Code:
// 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 "usn.ro" - i tried the adress too
amx_sql_host "89.44.246.250"
amx_sql_user "usnro_servercs"
amx_sql_pass "XXX"
amx_sql_db "usnro_servercs"
amx_sql_table ""
amx_sql_type "mysql"
The sql user is valid
The password is valid
The database is valid
The website is located on usn.ro
I've pinged the usn.ro to get that IP, as i haven't found another source
I've added " % " to hosts in DirectAdmin for that database. It sets access to any host. I also previously attempted adding the server IP and FTP IP.
There are no tables created in the database.
Edit:
I've executed the following cvars
amx_cvar amx_sql_user
amx_cvar amx_sql_db
amx_cvar amx_sql_server
amx_cvar amx_sql_pass
and they've returned accordingly to the value in sql.cfg
It's 6:24 AM and haven't slept at all, for a quick response in the following hours I'll remain forever grateful, as I want to finish configuring the server before I go to sleep.
But another time is, of course, always better than never.
Thank you firstly for this plugin, secondly for having the time to read this reply.
Sergiu.
09-17-2009, 16:55
Linear Mode
