[WC3 v2.2.6] Using MySQL to store data doesn't work

dtdesign · Post by **dtdesign** » Fri Oct 07, 2005 5:10 pm

Hi there,

I'm running two cs-servers on Debian Sarge 3.1 , three weeks ago I've decided to turn one cs-server into a wc3:tft mod cs-server. Since I had several issues with AMXX v1.5, I've backed up my whole addons folder and completly reinstalled metamod (latest) including amxmodx (v1.6). I've successfully written the admins into my mysql database and access to my db via amxx works. Now I tried to store my wc3 users in the same db.

I've done every step listed in one thread somewhere on this boards (I think it was a stickied or announced one in this board). The plugin crashs with error 10. Debuging displays the following text:

Code: Select all

L 10/08/2005 - 00:55:38: -------- Mapchange to cs_assault_mini --------
L 10/08/2005 - 00:55:45: [MYSQL] Invalid database handle 0
L 10/08/2005 - 00:55:45: [AMXX] Displaying debug trace (plugin "warcraft3.amxx")
L 10/08/2005 - 00:55:45: [AMXX] Run time error 10: native error (native "dbi_query")
L 10/08/2005 - 00:55:45: [AMXX]    [0] warcraft3.sma::set_mysql (line 8265)

Any ideas? The access data for MySQL is correct (checked more than 5 times) and I tried everything listed in forums and doc. Anyone can help me?

My system:
- Debian Sarge 3.1
- HLDS running CS v1.6/Steam
- Metamod v1.18-p26
- AMX Mod X v1.60
- WarCraft 3 Mod v2.2.6
- MySQL Server v4.1.11 (installed using apt-get)

Thanks for your time.

I'm looking forward for some help

Best regards
dtdesign

PS: Excuse any mistakes in my post, I'm just a 17 year old german

Post by **Lazarus Long** » Sat Oct 08, 2005 2:36 am

dtdesign:

Did you compile it yourself? Which files did you download? I have exactly the same config as you (well I upgraded last week to MySQL 5.0.x ) and never seen that error (not even when testing), so better re-check everything.

Cheers,

dtdesign · Post by **dtdesign** » Sat Oct 08, 2005 4:41 am

Hi Lazarus Long,

I've downloaded the Server files from wc3mod.net (specified for amxx v1.6). Expanded races, sql based.

viewtopic.php?t=473&sid=36066be7e8b71ae ... efbd28b88c

That's where I got the compiled plugin from.

Best regards
dtdesign

Post by **Geesu** » Sat Oct 08, 2005 8:38 am

It's not connecting to your database correctly. What's weird though is I've never seen a database handle of 0, only -1 when it screws up.

Are you sure the database information is correct? Post your war3ft.cfg

dtdesign · Post by **dtdesign** » Sat Oct 08, 2005 8:46 am

Code: Select all

// Warcraft 3 Frozen Throne Configuration File
// Note: NO MATTER WHAT, you must have the mysql module running
// even if you're not using it

mp_savexp               1               // Enables saving of experience (uses a vault, default is 0)
sv_mysql                1               // this will save w/MySQL (note: to use this mp_savexp must also be 1, default is 0)
FT_saveby               0               // What should I save this as?  steam id = 0, IP = 1, name = 2 (works for vault and mysql, default is 0)

// MySQL configuration
FT_mysql_host           "127.0.0.1"     // Host Name
FT_mysql_user           "amxx"          // User Name
FT_mysql_pass           ""            // Password
FT_mysql_db             "amxx"          // Database Name
sv_mysql_auto_pruning   0               // Automatically prunes the database of old users at a mapchange occuring between 5:36 to 5:59 AM (default is 0, doesn't work for vault)
sv_daysbeforedelete     999             // However many days before deleting XP or pruning from MySQL database (default is 31)
sv_mysqltablename       "war3users"     // Table Name, no need to change (default is war3users)

The password is blanked out. It's the same passwort as amxx is using.

Post by **Geesu** » Sat Oct 08, 2005 9:25 am

He's actually running war3, talking to him on aim.. just realized that

I shoulda looked at the plugin file name above dammit!

Daver · Post by **Daver** » Sat Oct 08, 2005 2:29 pm

So what does that mean?

Post by **Lazarus Long** » Sat Oct 08, 2005 6:46 pm

It means it's a whole mess!

The plugin he is talking about is Warcraft 3 XP and the config files are Warcraft 3 FT.

I don't know what to do with this, but it's best to lock it with the following warning for future users:

Please note that the forum has five different sections each one for a different plugin, so make sure of what you download and where you post.