amxx 1.71 mysql problem

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Locked
Highfighter
WC3Mods Donor
WC3Mods Donor
Posts: 60
Joined: Wed Aug 03, 2005 12:22 pm
Location: Highland Heights, KY
Contact:

amxx 1.71 mysql problem

Post by Highfighter » Wed Apr 26, 2006 3:45 pm

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
www.elitegamingcorp.com - - Up and growing counter-strike community.

User avatar
Krazy
Forum Administrator
Posts: 282
Joined: Wed Jul 06, 2005 9:40 am
Location: Dayton, Ohio
Contact:

Post by Krazy » Wed Apr 26, 2006 4:25 pm

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
Website: www.djpsych.com
Image

Need help anything to do with Warcraft 3 Mod, installing other plugins, setting up mySQL, installing PsychoStats, or anything else just PM/email me!

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Wed Apr 26, 2006 9:47 pm

Yea you can't have mysql + sqlite running at same time... will f up hardcore
No Support via PM

Highfighter
WC3Mods Donor
WC3Mods Donor
Posts: 60
Joined: Wed Aug 03, 2005 12:22 pm
Location: Highland Heights, KY
Contact:

Post by Highfighter » Thu Apr 27, 2006 1:33 am

didnt work, no idea why its not giving me any errors
www.elitegamingcorp.com - - Up and growing counter-strike community.

User avatar
Krazy
Forum Administrator
Posts: 282
Joined: Wed Jul 06, 2005 9:40 am
Location: Dayton, Ohio
Contact:

Post by Krazy » Thu Apr 27, 2006 3:07 pm

Hit me up on AIM when I am free and I will help you.
Website: www.djpsych.com
Image

Need help anything to do with Warcraft 3 Mod, installing other plugins, setting up mySQL, installing PsychoStats, or anything else just PM/email me!

User avatar
Krazy
Forum Administrator
Posts: 282
Joined: Wed Jul 06, 2005 9:40 am
Location: Dayton, Ohio
Contact:

Post by Krazy » Fri Apr 28, 2006 6:27 pm

The problem was an outdated war3FT.cfg so make sure you update it when you upgrade.

Problem Solved.
Website: www.djpsych.com
Image

Need help anything to do with Warcraft 3 Mod, installing other plugins, setting up mySQL, installing PsychoStats, or anything else just PM/email me!

Locked