How do I find MySql IP?

[Hatz]

I talked to Siren just now and this is our conversation:

Nathan: How do i find the ip of my mysql database?


You are now speaking with Siren of Support.

Siren: mysql.nuclearfallout.net

Nathan: it says this

Nathan: No website is currently set up at this address.

If you just set this site up, there may be a slight delay of up to a minute while the new Apache configuration is loaded; try visiting the page again in a minute or two.

Siren: snkclan.nuclearfallout.net

Siren: have you looked at that?

Nathan: vaguely

Nathan: what should i be looking for in there?

Siren: im not exactly sure what you are trying to do here?

Nathan: i have uwc3 on my server, it isnt saving xp. My problem i found out is in my sql.cfg i put in my server ip. I was told to put in mysql IP

Nathan: and im trying to find where the mysql ip is

Siren: 206.253.195.194

Nathan: where did u find that?

Siren: /dns in irc on your address

Nathan: am i able to do that? what is the dns command?

Siren: /dns mysql.nuclearfallout.net

Nathan: hmm i enter that into my browser and it says invaild

Siren: rentals@nuclearfallout.net

Siren: you should email in about this

Nathan: ive tried most people ive talked too through you guys wont help me with the issue

Nathan: and i tried entering that ip in the sql.cfg still doesnt work, anyway of checking to see if sql is connected?

Siren: i dont have access to that unfortunately

Nathan: wish i knew what the problem was, ill post on the forums to see if anyone knows





-------------

i entered both mysql.nuclearfallout.net and the ip he gave me in both sql.cfg and uwc3_sql.cfg

xp still doesnt save

then i tried putting my server ip in sql.cfg and the mysql ip in the uwc3_sql.cfg, and vica versa, and nothing happened.


Anyone who set up uwc3 through NFO know anything about this?

[Nick|NFo]

She gave you the correct information, you can use either the IP or the DNS if you were actually going to use mysql to save the data. You don't have to set it up this way, you can use the vault. You probably haven't enabled it in the config to actually save (most common mistake since the wc3 mods I've seen come with it off by default).

The mod will probably make connections to the mysql db when a person connects to check for xp and all, you can check your amxmodx logs for issues regarding that.

[Hatz]

L 01/26/2007 - 20:33:00: [uwc3.amxx] UWC3 SQL :: Config Report: host=(206.253.195.194) user=(snk) pass=(*) db=(uwc3)
L 01/26/2007 - 20:33:00: [uwc3.amxx] UWC3 SQL :: Connect Error [ Access denied for user: 'snk@%.nuclearfallout.net' to database 'uwc3'



it's detecting the mysql server, but no pass and/or password

[Nick|NFo]

That is because you didn't set the right database name (which is your identifier). You need to read about your mysql database on your website page.

[Hatz]

do i require a uwc3 file in the /addons/amxmodx/data/ directory?

like uwc3.db?

[Nick|NFo]

No, you do not need to do this. You should read the install directions with it as well as their forums here, http://wc3mods.net/forums/index.php?c=5.

[Hatz]

I have

http://wc3mods.net/forums/viewtopic.php ... ar+fallout

And after hours of talking with a guy who tried helping me, he ended with:

"Not sure how your host allows you, so you will have to contact them"

[Nick|NFo]

We do allow you, you just need to use the correct information there. Other users use the webspace fine for their mods like amxbans, wc3, superheroes, etc.

[BnD|Sleeper]

Yes, it is possible to save War3 XP data because I host a WC3FT server @ bnd.nuclearfallout.net which saves XP to SQL.

My top 3 lines of War3FT.cfg are as follows:

Code: Select all

mp_savexp		1		// Enables saving of experience (uses a vault, default is 0)
sv_sql			1		// Save using a SQL module (a module needs to be turned on, 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 (default is 0)

You MUST have mp_savexp and sv_sql set to 1. FT_saveby would be steamid/etc...

My sql.cfg has the following:

Code: Select all

amx_sql_host	"mysql.nuclearfallout.net"
amx_sql_user	"<identifier>"
amx_sql_pass	"<secret password>"
amx_sql_db	"<identifier>"
amx_sql_table	"admins"
amx_sql_type	"mysql"

Make sure everything on yours is correctly corresponding to that except "table" I think can differ. You are probably not using MySQLi but MySQL so it should say amx_sql_type "mysql"

I can probably help here because I've run my WAR3FT server for over a year

Sleeper