RC6 MYSql issues.

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

Moderator: Forum Moderator

Post Reply
elite777
Peon
Posts: 1
Joined: Fri May 25, 2007 5:42 pm

RC6 MYSql issues.

Post by elite777 » Sat May 26, 2007 11:26 am

War3ft Version: RC 6
Amxmodx Version: 1.76D
Metamod Version: 1.19
amxx list:
amxx modules:
mysql
fun
engine
fakemeta
nvault
dodfun
dodx
meta list:

I have searched the forums like crazy about this subject but none of them help me much.

I am trying to enable MYsql so I can save the XP but I am having a little problem. Everything seems to be set right but when I go in game the Races don't show up. It won't even let you choose any. The skills show up though.

I checked the latest AMX Mod X logs and I found this error.

Code: Select all

L 05/26/2007 - 11:43:58: -------- Mapchange to dod_avalanche --------
L 05/26/2007 - 11:43:59: [admin.amxx] Login: "<KoL-UA>Elite Fallen Angel<KoO><31><STEAM_0:1:11341547><>" became an admin (account "STEAM_0:1:11341547") (access "abcdefghijklmnopqrstu") (address "66.69.111.216")
L 05/26/2007 - 11:43:59: [admin.amxx] Login: "<KoL-4B> red nano <KoO><23><STEAM_0:0:10531026><>" became an admin (account "STEAM_0:0:10531026") (access "bfghiju") (address "71.131.28.116")
L 05/26/2007 - 11:43:59: [war3ft.amxx] [MYSQLX] Database Connection Failed: [1045] Access denied for user 'ysxqdnsr_test'@'72.36.222.134' (using password: YES)
L 05/26/2007 - 11:44:00: [admin.amxx] Login: "<KoL-1D>Garcia<KoO><34><STEAM_0:1:8076736><>" became an admin (account "STEAM_0:1:8076736") (access "bfghiju") (address "70.130.47.45")
Here is my war3FT.cfg file:

Code: Select all

//	Warcraft 3 Frozen Throne Configuration File


// Saving Options

wc3_save_xp		1		// Enables saving of experience (default is 0)
wc3_save_xp_db		1		// How should we save XP? (0 = SQLite, 1 = MySQL)

wc3_save_by		0		// What should I save this as?  steam id = 0, IP = 1, name = 2 (default is 0)
wc3_save_pruning	0		// Automatically prunes the database of old users at a mapchange (default is 0)
wc3_days_before_delete	30		// However many days before deleting XP or pruning from the database (default is 31)
wc3_save_end_round	1		// Save xp at the end of each round (may cause lag, default is 1)


// SQL Database Information

wc3_sql_dbhost		"72.52.158.81"	// Host Name
wc3_sql_dbuser		"ysxqdnsr_test"		// User Name
wc3_sql_dbpass		"*HIDDEN*"		// Password
wc3_sql_dbname		"ysxqdnsr_wc3ft"		// Database Name


// Admin Options

wc3_admin_flag		"m"		// Admin flag required to give/take XP (default is m)


// Experience Options

wc3_xp_multiplier	1.0		// set the level required to gain a level as a multiple (default 1.0)
wc3_xp_weap_multiplier	1		// Award XP based on the weapon used (default is 1)
wc3_min_players		2		// Minimum amount of players needed b4 awarding XP (default is 2)
wc3_xp_auto_average	0		// With this option set to 1, the joining players will receive the average amount of XP that all of the players have (SHORT TERM XP ONLY, default is 0)
wc3_show_objectives	1		// If enabled, will display message in chat to show XP they gain for completing certain objectives (default is 1)
wc3_show_kill_obj	1		// Shows how much XP you gain for killing someone (each kill, default is 0)
wc3_xp_radius		500		// Radius to give XP to teammates near where the special objective is completed (rescued hosties, bomb planted, killed vip, vip escaped, default is 750)


// Game Play Enhancements

wc3_races		9		// Number of races (if races are less than 5, the second shopmenu will be disabled (4 is standard war3), default is 8)
wc3_grenade_protection	0		// Only 1 HE grenade will be allowed for purchase per round (default is 0)
wc3_spec_position	0		// 0 is for left, 1 is for right (where to put the information for those spectating, default is 0)
wc3_buy_zone		0		// Restrict purchasing shopmenu items to within the buyzone? (default is 0)
wc3_buy_time		0		// Restrict purchasing shopmenu items to within the buytime? (default is 0)
wc3_buy_dead		1		// Allow users to purchause items when dead? (default is 1)
wc3_show_player		1		// Show teammate and enemy information in the center of the screen when they are on target? (not for DOD, default is 1)
wc3_query_client	1		// Check user's cl_minmodel cvar every second (default is 1)
wc3_cheats		0		// Enable cheats for wc3? (default is 0)
wc3_psychostats		1		// Print psychostats information to log files for wc3 abilities?


// Icon Options (displayed above player's head)

wc3_race_icon		1		// Allow users to type /icons to show player icons above the player (default is 1)
wc3_level_icon		1		// Allow users to type /icons to see player levels above the player (default is 1)


// Chameleon Race Configuration Options - see _chameleon.txt for more information

wc3_cham_random		0		// Should the 9th race have random skills each round?, if so the next 4 option are irrelevant (default is 1)
wc3_cham_skill1		12		// What skill ID for skill 1?
wc3_cham_skill2		14		// What skill ID for skill 2?
wc3_cham_skill3		5		// What skill ID for skill 3?
wc3_cham_ultimate	24		// What skill ID for the user's ultimate?
wc3_cham_passive	30		// What skill ID for the user's passive skill?


// Skill and Ultimate configurations

wc3_ult_delay		15.0		// Amount of time (in seconds) to delay the ultimates at the start of each round (default is 15.0)
wc3_ult_cooldown	35.0		// Cooldown of all ultimates (default is 35.0)
wc3_blink_protection	1		// slays people who abuse blink on some maps (skywalking, map exploiting, default is 1)
wc3_blink_dizziness	0		// What type of diziness? (0 is flashbang effect, 1 is fading blue screen, default is 0)
wc3_entangle_drop	0		// Should the player's primary weapon be dropped when they are entangled? (default is 0)


// Item configurations

wc3_glove_timer		10		// Interval between receiving a new grenade with the Flaming Gloves of Warmth (default is 10)
wc3_glove_orc_damage	0		// When using gloves, should orcs be given the critical dmg? (Default is 0)
wc3_boots		0.10		// Percentage increase given by boots (.10 = 10%, default is 0.10)
wc3_claw		15		// Damage done by Claws of Attack (default is 6)
wc3_health		50		// Health bonus given for periapt of health (default is 15)
wc3_frost		125.0		// Speed of victim when attacked with Orb of Frost (default is 125.0)
wc3_mask		0.3		// Percentage of life gained back by mask of death (default is 0.3)
wc3_cloak		125		// Invisibility given with cloak, lower is more invisible (default is 150)
wc3_sock		0.5		// Gravity level for Sock of the Feather (default is 0.5)
wc3_tome		25		// XP given for purchasing tome of experience (default is 50)


// Bot Configuration Options

wc3_bot_buy_item	0.33		// Chance of a bot buying a shopmenu item at the beginning of the round (default is 0.33)


// DOD Options

wc3_dod_start_money	800		// Starting money for dod
I have mysql uncommented in the plugins.ini also.

Code: Select all

Here is my sql.cfg:

amx_sql_host	"72.52.158.81"
amx_sql_user	"ysxqdnsr_test"
amx_sql_pass	"*HIDDEN*"
amx_sql_db		"ysxqdnsr_wc3ft"
amx_sql_table	"war3users"
amx_sql_type	"mysql"
I am really getting frusterated with this. I can't figure out what to do so I can get this to work. Anyone have any suggestions?

Senne
Rifleman
Posts: 164
Joined: Wed Feb 21, 2007 9:22 am

Post by Senne » Sat May 26, 2007 12:37 pm

your log file says the problem :
[MYSQLX] Database Connection Failed: [1045] Access denied for user 'ysxqdnsr_test'@'72.36.222.134' (using password: YES)

meaning you are not establishing a connecting, make sure the mysql server always to be connect to from the gameserver ip...

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

Post by Geesu » Sun May 27, 2007 10:40 am

Yea it's just a permissions issues for that user
No Support via PM

SmokingJoePot
Peon
Posts: 12
Joined: Sat Aug 18, 2007 6:58 pm
Location: Dallas TX
Contact:

Post by SmokingJoePot » Sat Aug 18, 2007 7:17 pm

Check the modules.ini and make sure you have it uncomment.
It looks something like this:


; -------------------------------------------
; Database Access - only enable one of these
; -------------------------------------------
; MySQL
mysql_amxx_i386.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

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Sat Aug 18, 2007 9:32 pm

Wrong SmokingJoePot. War3FT 3.x enables modules that are needed. So there is no reason to manually enable them. Plus, that is the old modules.ini, I suggest you upgrade if you want to use 3.x
Image

No support via PM or Email

Daver
WC3Mods Donor
WC3Mods Donor
Posts: 93
Joined: Sat Jul 09, 2005 2:34 pm
Location: Orland Park, IL.
Contact:

Post by Daver » Tue Aug 21, 2007 10:40 pm

OK, since noone will answer the similar question I had in my post I will ask it here.

How do you give the server access permission. My xp saves and works ok, but on map change it must be connecting to the database and cant connect or something cuz it laggggs out and disconnects players.

But if i use mysqllite it works better. I want to use the regular mysql though.

Please help!!! My version is 3.0 rc8

Daver

HaNz_BrIx
Peon
Posts: 34
Joined: Mon Jul 25, 2005 10:03 pm

Post by HaNz_BrIx » Wed Aug 22, 2007 10:12 am

daver i was using the clanserver mysql db they give you and if you go all the way down to access host enter your server ip and that should work

Daver
WC3Mods Donor
WC3Mods Donor
Posts: 93
Joined: Sat Jul 09, 2005 2:34 pm
Location: Orland Park, IL.
Contact:

Post by Daver » Wed Aug 22, 2007 5:30 pm

currently i dont use the gameservers database but I could...

Daver

Post Reply