CS Server cannot open SQL DB

Overkill · Post by **Overkill** » Thu May 29, 2008 7:31 am

I have an **OLD** warcraft3 server running 1.6.5
AMX version is 0.9.7
MetaMod version is 1.17
rcon lists posted below.

I was able to use the vault conversion page to create a table on the MySQL database, but for some reason the server can't connect using the same credentials which i've entered into the war3FT.cfg file. I've configured the SQL server to allow access for my gameserver.

I saw in the 'how to' that you need to enter a port= line into an INI for MySQL, however the only access I have is cPanel & PHPMyAdmin. There is no matching INI file anywhere in the FTP tree.

Can somebody help me?

Thanks,
Overkill

Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX RUN - amx_mm.dll v0.9.7 ini ANY ANY
[ 2] CS STATS RUN - csstats_mm.dll v0.9.7 ( cmd ANY ANY
[ 3] FUN RUN - fun_mm.dll v0.9.8 cmd ANY ANY
[ 4] XtraFun RUN - xtrafun_mm.dll v1.2 cmd ANY Pause
[ 5] JGHGdll RUN - jghg_mm.dll v1.0 cmd ANY ause
[ 6] Vexd Util. Modu RUN - vexdum_mm.dll v0.2.0.7 cmd ANY ANY
6 plugins, 6 running

Currently loaded plugins:
name version author file status
[ 1] Admin Base 0.9 default admin.amx running
[ 2] Admin Commands 0.9 default admincmd.amx running
[ 3] Admin Help 0.9 tcquest78 adminhelp.amx running
[ 4] Slots Reservation 0.9.7 defaut adminslots.amx running
[ 5] Menus Front-End 0.9 default menufront.amx running
[ 6] Commands Menu 0.9 default cmdmenu.amx running
[ 7] Players Menu 0.9 default plmenu.amx running
[ 8] Restrict Weapons 0.9.6.1 default restmenu.amx running
[ 9] Maps Menu 0.9 default mapsmenu.amx running
[ 10] Anti Flood 0.9 default antiflood.amx runing
[ 11] Admin Chat 0.9 default adminchat.amx running
[ 12] Admin Votes 0.9 default adminvote.amx running
[ 13] NextMap 0.9 default nextmap.amx running
[ 14] TimeLeft 0.9 default timeleft.amx running
[ 15] Nextmap chooser 0.9 default mapchooser.amx running
[ 16] Scrolling Message 0.9 default scrollmsg.amx running

[ 17] Info. Messages 0.9 default imessage.amx running
[ 18] Welcome Message 0.9 default welcomemsg.amx running
[ 19] Stats 0.9 default stats.amx running
[ 20] Stats Logging 0.9 JustinHoMi stats_logging.a running
[ 21] Teleport Menu 0.9 default telemenu.amx running
[ 22] Misc. Stats 0.9 default miscstats.amx running
[ 23] Pause Plugins 0.9 default pasecfg.amx running
[ 24] Stats Configurati 0.9 default statscfg.amx running
[ 25] War3: Frozen Thro 1.6.5 Pimp Daddy (OoTO warcraft3FT.amx running
25 plugins, 25 running

Currently loaded modules:
name type version author status
[ 1] Vexd Util. Module amx&mm 0.2.0.7 Vexd running
[ 2] JGHGdll amx&mm 1.0 jghg running
[ 3] XtraFun amx&mm 1.2 Misc running
[ 4] MySQL access amx 0.9 dJeyL running
[ 5] Fun amx&mm 0.9.8 OLO running
[ 6] CS STATS amx&mm 0.9.7 ( OLO running
6 modules, 6 correct

hostname: jesusservers.com - NEW IP
version : 47/1.1.2.5 3647 secure
tcp/ip : 216.6.226.163:27015

Post by **YamiKaitou** » Thu May 29, 2008 10:01 am

AMX Mod is no longer supported here. Please upgrade to the latest version if you want help

Overkill · Post by **Overkill** » Thu May 29, 2008 11:38 am

Our community has made the decision not to update to the latest version because it is not something that the players want.

I'm relatively certain this is something that won't take much to fix, and I would like to get assistance from someone that knows what they're doing.

Overkill · Post by **Overkill** » Thu May 29, 2008 12:10 pm

I think that your policy of no update = no support is unnecessary, and it's the kind of thing I avoid when I troubleshoot PCs, but maybe that's because I get paid to do it...

It was clear enough, I just didn't expect to get this kind of response. It's not necessary to discontinue support for it, especially if it's a well-traveled issue that shouldn't take more than 15 minutes to resolve.

The only reason I'm using this version is because of community and donor demand, personally I like the changes of the 3.0 RCs - except the spectator of doom glitch...

Is there any chance you'll reconsider your response or should I continue spending a ridiculous amount of time trying to fix it myself?

Thanks,
Overkill

Post by **YamiKaitou** » Thu May 29, 2008 2:30 pm

The main problem I have is that you are using the version for AMX, which is dead. If you upgrade to 2.3.2, I would consider helping.

Overkill · Post by **Overkill** » Thu May 29, 2008 3:16 pm

are you referring to War3FT 2.3.2?

our old server @ 69.93.114.118:27015 is running it fine
the new server @ 216.6.226.163:27015 is running on vaulted XP

like i said, i've done just about everything i can on my end. I'd love to get this solved today so we can start redirecting players to the new IP.

Post by **Geesu** » Thu May 29, 2008 3:34 pm

Overkill -

Do you have the source code for the version you are using? Honestly I don't remember the work I did pre-2.3.2 - if you could post the .sma file I'll take a look.

And I agree - I don't like the policy of "update or no help" - but honestly we get a decent amount of requests (and sadly don't have time) - so difficult to research some of these issues. Yours seems relatively tiny so I'll try to help if I can.

Josh

Overkill · Post by **Overkill** » Thu May 29, 2008 3:54 pm

Done.

However, this seems to be an issue with the game server not having r/w access to the SQL DB

Overkill · Post by **Overkill** » Thu May 29, 2008 5:01 pm

Here's the server config files and a screenshot of the server added as an allowed host

To answer questions in advance i have 2 monitors and a few nifty scripts that let me run it in a window.

Overkill · Post by **Overkill** » Thu May 29, 2008 5:15 pm

I appreciate it geesu, i understand that you guys are busy and i appreciate any help you can offer. i wouldnt be here if i hadn't exhausted all of my other resources.

Post by **Geesu** » Thu May 29, 2008 7:02 pm

can you paste the exact error message you are getting when it tries to connect?

Overkill · Post by **Overkill** » Fri May 30, 2008 12:09 am

I don't get an error message anywhere, and can't find a log file.

What happens is this:

Installed war3ft mod - OK
Save & Load XP using vault - OK
Convert vault to SQL using website - OK
Save & Load XP using SQL file - FAIL
Revert to VAULT - OK

Post by **Geesu** » Fri May 30, 2008 10:04 am

wait - so you try to import the SQL file and that fails? How are you importing it? (Note: war3ft doesn't do this - you have to do it manually using something like phpmyadmin)

Overkill · Post by **Overkill** » Fri May 30, 2008 10:53 am

Sorry for the confusion

by "Save & Load XP using SQL file" I mean I've changed sv_sql to 1 in my .cfg file
I guess i should have said SQL database...oops

I used your very ingenious web tool to create the table and all that jazz for me

I also decided to eliminate the version of the mod I'm using and temporarily installed 2.3.2, it said "An error has occurred when retreiving your race infrmation, please contact a server administrator"

I changed sv_sql to 0 and it worked fine.

Apparently, it's an issue with read/write access for the SQL database.
I know it's not the credentials because I used the same credentials to create the war3users table in the database. Could it be the port that the game server is trying to access the SQL server on?

Post by **YamiKaitou** » Fri May 30, 2008 11:18 am

The port that the server is using should be the default (3306). Verify that the server IP has access to the sql database first.

Overkill · Post by **Overkill** » Fri May 30, 2008 11:50 am

@Yami - please see the RTF containing screenshot in sample.zip

Post by **YamiKaitou** » Fri May 30, 2008 1:15 pm

Okay, let me phrase it this way.

Did you add the user BEFORE you added the access thingy? I have noticed that if you allow a new ip, sometimes you need to readd the user to get it to work correctly.