Server rentals :: NFOservers.com

Forums

All times are UTC - 8 hours



Author Message
 Post subject: How do I find MySql IP?
PostPosted: Fri Jan 26, 2007 6:46 pm 
Offline
This is my homepage
This is my homepage
User avatar

Joined: Thu Jan 18, 2007 5:07 pm
Posts: 84
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?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 26, 2007 7:01 pm 
Offline
Former staff
Former staff
User avatar

Joined: Sun Mar 30, 2003 1:56 pm
Posts: 2252
Location: 127.0.0.1
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.

_________________
-Nick


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 26, 2007 7:13 pm 
Offline
This is my homepage
This is my homepage
User avatar

Joined: Thu Jan 18, 2007 5:07 pm
Posts: 84
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


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 26, 2007 7:17 pm 
Offline
Former staff
Former staff
User avatar

Joined: Sun Mar 30, 2003 1:56 pm
Posts: 2252
Location: 127.0.0.1
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.

_________________
-Nick


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 26, 2007 7:54 pm 
Offline
This is my homepage
This is my homepage
User avatar

Joined: Thu Jan 18, 2007 5:07 pm
Posts: 84
do i require a uwc3 file in the /addons/amxmodx/data/ directory?

like uwc3.db?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 26, 2007 8:13 pm 
Offline
Former staff
Former staff
User avatar

Joined: Sun Mar 30, 2003 1:56 pm
Posts: 2252
Location: 127.0.0.1
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.

_________________
-Nick


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 26, 2007 8:20 pm 
Offline
This is my homepage
This is my homepage
User avatar

Joined: Thu Jan 18, 2007 5:07 pm
Posts: 84
I have

http://wc3mods.net/forums/viewtopic.php?t=2467&highlight=nuclear+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"


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 26, 2007 8:37 pm 
Offline
Former staff
Former staff
User avatar

Joined: Sun Mar 30, 2003 1:56 pm
Posts: 2252
Location: 127.0.0.1
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.

_________________
-Nick


Top
 Profile  
 
 Post subject:
PostPosted: Sat Jan 27, 2007 10:46 am 
Offline
This is my homepage
This is my homepage

Joined: Wed Aug 02, 2006 8:52 am
Posts: 140
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:
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:
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

_________________
http://www.BnDClan.com

WC3:FT CS 1.6: wc3.bndclan.com:27015 or 64.94.101.52:27015)

http://rentals.nuclearfallout.net/rent. ... ferrer=bnd


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: Bing [Bot] and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
It is currently Tue May 21, 2013 11:40 pm
Powered by phpBB® Forum Software © phpBB Group