Page 1 of 1

amxx 1.71 mysql problem

Posted: Wed Apr 26, 2006 3:45 pm
by Highfighter
Alright, before I upgraded to amxx 1.71, I had my server saving via mysql, but now with the update it wont connect to the mysql server. Here is my modules.ini file.

errr forgot its a linux server

Code: Select all

Admin Base (AmxBa  1.60     AMXX Dev Team     admin_sql.amxx   running  
AMXBans            4.3      YoMama/Lux & lan  amxbans.amxx     debug    
Admin Commands     1.71     AMXX Dev Team     admincmd.amxx    running  
Admin Help         1.71     AMXX Dev Team     adminhelp.amxx   running  
Slots Reservation  1.71     AMXX Dev Team     adminslots.amxx  running  
Multi-Lingual Sys  1.71     AMXX Dev Team     multilingual.am  running  
Menus Front-End    1.71     AMXX Dev Team     menufront.amxx   running  
Commands Menu      1.71     AMXX Dev Team     cmdmenu.amxx     running  
Players Menu       1.71     AMXX Dev Team     plmenu.amxx      running  
Teleport Menu      1.71     AMXX Dev Team     telemenu.amxx    running  
Maps Menu          1.71     AMXX Dev Team     mapsmenu.amxx    running  
Admin Chat         1.71     AMXX Dev Team     adminchat.amxx
Anti Flood         1.71     AMXX Dev Team     antiflood.amxx   running  
Scrolling Message  1.71     AMXX Dev Team     scrollmsg.amxx   running  
Info. Messages     1.71     AMXX Dev Team     imessage.amxx    running  
Admin Votes        1.71     AMXX Dev Team     adminvote.amxx   running  
NextMap            1.71     AMXX Dev Team     nextmap.amxx     running  
Nextmap Chooser    1.71     AMXX Dev Team     mapchooser.amxx  running  
TimeLeft           1.71     AMXX Dev Team     timeleft.amxx    running  
Pause Plugins      1.71     AMXX Dev Team     pausecfg.amxx    running  
Stats Configurati  1.71     AMXX Dev Team     statscfg.amxx    running  
Restrict Weapons   1.71     AMXX Dev Team     restmenu.amxx    running  
StatsX             1.71     AMXX Dev Team     statsx.amxx      running  
CS Misc. Stats     1.71     AMXX Dev Team     miscstats.amxx   running  
CS Stats Logging   1.71     AMXX Dev Team     stats_logging.a  running  
Warcraft 3 Frozen  2.3.2    Geesu==(Pimp Dad  warcraft3FT.amx  debug    
Last man bets      0.9.3    JGHG              lastmanbets.amx  running  
HLDS<->IRC Bot     1.0      devicenull        irc.amxx         running  
say /motd          1.1      Pa1n              say_motd.amxx    running  
Last Round         1.0      bAnTAi            lastrou
Modules

Code: Select all


Currently loaded modules:
name                    version  author              
Fun                     1.71     AMX Mod X Dev Team  
Engine                  1.71     AMX Mod X Dev Team  
FakeMeta                1.71     AMX Mod X Dev Team  
FakeMeta                1.71     AMX Mod X Dev Team  
MySQL                   1.70     AMX Mod X Dev Team  
GeoIP                   1.71     AMX Mod X Dev Team  
nVault                  1.71     AMX Mod X Dev Team  
CStrike                 1.71     AMX Mod X Dev Team  
CSX                     1.71     AMX Mod X Dev Team  
Sqlite                  1.70     AMX Mod X Dev Team  
Sockets                 1.71     HLSW Dev Team       
RegEx                   1.71     AMX Mod X Dev Team

Code: Select all


Currently running plugins:
 [  1] AMX Mod X, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  2] POD-Bot mm, vR2b46d, Aug  9 2005, by Count Floyd & Bots United, see http://www.bots-united.com
 [  3] Fun, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  4] Engine, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  5] FakeMeta, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  6] MySQL, v1.70, Mar  4 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org/
 [  7] GeoIP, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org/
 [  8] nVault, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org/
 [  9] CStrike, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [ 10] CSX, v1.71, Apr  2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org/ 
here is my modules .ini file

Code: Select all

; 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_amd64.so
mysql_amxx_50_amd64.so
mysql_amxx_50_i386.so
;mysql_amxx_40_i386.so
;mysql_amxx_40_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

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

; --------------------
; Binary Vault support
; --------------------
nvault_amxx_i386.so
nvault_amxx.dll
nvault_amxx_amd64.so

; ----------------------------------------------------------
; Counter-Strike - adds functions specific to Counter-Strike
; ----------------------------------------------------------
cstrike_amxx_i386.so
cstrike_amxx.dll
cstrike_amxx_amd64.so

; -----------------------------------------------------
; CSX - adds functionality for CS statistics and events
; -----------------------------------------------------
csx_amxx_i386.so
csx_amxx.dll
csx_amxx_amd64.so
the mysql is mysql5.0.18.

I cant figure out why it wont connect to the mysql server. so any help please

Posted: Wed Apr 26, 2006 4:25 pm
by Krazy
Make this part of your moledules.ini looks like this and i think you will be fine:

Code: Select all

; ------------------------------------------- 
; Database Access - only enable one of these 
; ------------------------------------------- 
; MySQL 
;mysql_amxx_i386.so 
;mysql_amxx_amd64.so 
;mysql_amxx_50_amd64.so 
mysql_amxx_50_i386.so 
;mysql_amxx_40_i386.so 
;mysql_amxx_40_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

Posted: Wed Apr 26, 2006 9:47 pm
by Geesu
Yea you can't have mysql + sqlite running at same time... will f up hardcore

Posted: Thu Apr 27, 2006 1:33 am
by Highfighter
didnt work, no idea why its not giving me any errors

Posted: Thu Apr 27, 2006 3:07 pm
by Krazy
Hit me up on AIM when I am free and I will help you.

Posted: Fri Apr 28, 2006 6:27 pm
by Krazy
The problem was an outdated war3FT.cfg so make sure you update it when you upgrade.

Problem Solved.