[[T4E]Demon]

hi me and my friends was trying to get his server working with sql because he needed it for a plugin but we got some error messages when i finally got the configs as i putted on my own server wich was working...

L 10/27/2006 - 21:23:40: [MySQL] Invalid DBI handle 0
L 10/27/2006 - 21:23:40: [AMXX] Displaying debug trace (plugin "skillsrank1_4_4.amxx")
L 10/27/2006 - 21:23:40: [AMXX] Run time error 10: native error (native "dbi_close")
L 10/27/2006 - 21:23:40: [AMXX] [0] textlqqHsl.sma::plugin_end (line 267)
L 10/27/2006 - 21:23:40: -------- Mapchange to concmap_rax --------
L 10/27/2006 - 21:23:40: [AMXX] Plugin needs newer debug version info (plugin "mapmanager.amxx")
[AMXX] SQL error: can't connect: 'Unknown database 'amx''
L 10/27/2006 - 21:23:48: [skillsrank1_4_4.amxx] [AMXX: skillrank] SQL Connection Failed to table skillrank

plugins.ini is as following
_________________

; 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)
; 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
; Team Fortress Classic
stats.amxx ; stats on death (TFC Module required!)
statssounds.amxx ; precache plugin for stats plugins
stats_logging.amxx ; weapons stats logging (TFC Module required!)
block_con.amxx ; no dizzy
tfcnades.amxx ; nades to red blue green yellow all
mapmanager.amxx ; rockthevote plugins
hpk.amxx ; high ping kicker
skillsrank1_4_4.amxx ; some record things
loadingsound.amxx ; connect sound
; Custom - Add 3rd party plugins here

and modules.ini
________________

; AMX Mod X Modules
; You can specify both linux & win32 modules here
; To enable a module, remove the semi-colon from the line
; ------------------------------
; Fun - provides extra functions
; ------------------------------
fun_amxx_i386.so
fun_amxx.dll
fun_amxx_amd64.so
; ----------------------------------------------------
; Engine - provides engine functions core to Half-Life
; ----------------------------------------------------
;engine_amxx_i386.so
engine_amxx.dll
;engine_amxx_amd64.so
; ----------------------------------------------------------
; Fakemeta - provides a massive interface into the HL engine
; ----------------------------------------------------------
;fakemeta_amxx_i386.so
fakemeta_amxx.dll
;fakemeta_amxx_amd64.so
; -------------------------------------------
; Database Access - only enable one of these
; -------------------------------------------
; MySQL
;mysql_amxx_i386.so
mysql_amxx.dll
;mysql_amxx_amd64.so
; PostgreSQL
;pgsql_amxx_i386.so
;pgsql_amxx.dll
; Microsoft SQL
;mssql_amxx.dll
; SQLite
;sqlite_amxx.dll
;sqlite_amxx_i386.so
;sqlite_amxx_amd64.so
; ---------------------------------------------
; GeoIP - determines the country of ip adresses
; ---------------------------------------------
;geoip_amxx_i386.so
;geoip_amxx.dll
;geoip_amxx_amd64.so
; ------------------------------------
; Array - advanced arrays in scripting
; ------------------------------------
;array_amxx_i386.so
;array_amxx.dll
;array_amxx_amd64.so
; --------------------------------
; Sockets - network socket support
; --------------------------------
;sockets_amxx_i386.so
;sockets_amxx.dll
;sockets_amxx_amd64.so
; --------------------------
; Regular Expression support
; --------------------------
;regex_amxx_i386.so
;regex_amxx.dll
;regex_amxx_amd64.so
; ------------------------------------------------------------------
; Team Fortress Classic X - adds functions and stats specific to TFC
; ------------------------------------------------------------------
;tfcx_amxx_i386.so
tfcx_amxx.dll
;tfx_amxx_amd64.so
; ------------------------------------------------------------------
;Cstrike modules
; ------------------------------------------------------------------
;cstrike_amxx.dll
;csx_amxx.dll

me and my friend (who doesnt speak english well) will be very gratefull if someone could tell us what the problem is

/Demon

[.:Predator:.]

Try Reinstall

[[T4E]Demon]

reinstall what? i just upgraded his amxx to 1,76a and just today installed mysql.. any other suggestions? :X

[Brad]

1.76a doesn't have a module.ini file that looks anything like what you posted. I suggest reinstalling from scratch.

After you do that, go into your plugins.ini and make sure only ONE of admin.amxx or admin_sql.amxx is uncommented. Only one. Not both.

Finally, look at the SQL error after the map change.

Originally Posted by SQL Error [AMXX] SQL error: can't connect: 'Unknown database 'amx''

That's your problem. It's looking for the "amx" database but it either doesn't exist or you can't make a connection to your SQL server. I'm not going to say how to fix it if it doesn't exist to help maintain my sanity. As for the connection, make sure what you have in .\addons\amxmodx\configs\sql.cfg is correct and that the server is allowing connections from your game server.

[[T4E]Demon]

well i made a connection to the sql server from mysql adminstrator tool and used some of the info in the sql.cfg as for the modules.ini ... i upgraded on my own (without sql) and it works as it should though i havent tested sql yet.. thats gonna wait untill my own server comp is running again :S before i had the info fixed from mysql administrator it compained about wrong password.. so that means amxx has a connection to sql right? so it cant be there the problem is :S but ill try install amxx from scratch and at least save his plugins.ini and sql.cfg

/Demon

[[T4E]Demon]

lol problem solved just made my friend change db in the sql.cfg and it worked so maybe the modules.ini aint original from 1.76a it works good cheers
/Demon