Server Crashing Frequently

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

Moderator: Forum Moderator

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

Server Crashing Frequently

Post by Daver » Sun Aug 26, 2007 8:57 pm

Cant figure out why it happening now after I got it to work with the new database. Here is the error log from war 3:
L 08/26/2007 - 22:49:43: Log file started (file "cstrike/addons/amxmodx/configs/war3ft/wc3_error.log") (game "cstrike") (amx "1.76d")
L 08/26/2007 - 22:49:43: ** Map 'de_dust' started
L 08/26/2007 - 22:49:43: ** Plugin version: '3.0 RC8'
L 08/26/2007 - 22:49:49: [MYSQLX] Error in querying database, location: 12
L 08/26/2007 - 22:49:49: [MYSQLX] Message: SELECT command denied to user 'cs102545_players'@'8.9.36.80' for table 'tables' (1142)
L 08/26/2007 - 22:49:49: [MYSQLX] Query statement: SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cs102545_war3xp' AND table_name = 'war3users';
L 08/26/2007 - 22:49:59: ** Map 'de_dust' ended
L 08/26/2007 - 22:50:00: ** Map 'de_dust' started
L 08/26/2007 - 22:50:00: ** Plugin version: '3.0 RC8'
L 08/26/2007 - 22:50:05: [MYSQLX] Error in querying database, location: 12
L 08/26/2007 - 22:50:05: [MYSQLX] Message: SELECT command denied to user 'cs102545_players'@'8.9.36.80' for table 'tables' (1142)
L 08/26/2007 - 22:50:05: [MYSQLX] Query statement: SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cs102545_war3xp' AND table_name = 'war3users';


What are the schema tables and why is there a war3users when I know I dont have it in my war3.cfg?

--- Please enter the following information for support ---
War3ft Version: 3.0rc8
Amxmodx Version: 176d
Metamod Version: 1.19p28
amxx list:
amxx modules:
meta list:

war3.cfg:

// 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 31 // 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 "66.55.132.6" // Host Name
wc3_sql_dbuser "cs102545_xxxx" // User Name
wc3_sql_dbpass "xxxxxx" // Password
wc3_sql_dbname "cs102545_war3xp" // 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_ignore_bots 0 // Should you ignore bots when calculating the minimum players required to gain xp? (default is 0)
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 0 // Shows how much XP you gain for killing someone (each kill, default is 0)
wc3_xp_radius 750 // 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 1 // 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 0 // 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 0 // Print psychostats information to log files for wc3 abilities? (default is 0)
wc3_start_level 0 // What level should all players start at when joining? (default is 0)

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

wc3_race_icon 0 // Allow users to type /icons to show player icons above the player (default is 1)
wc3_level_icon 0 // 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 1 // What skill ID for skill 1?
wc3_cham_skill2 2 // What skill ID for skill 2?
wc3_cham_skill3 4 // What skill ID for skill 3?
wc3_cham_ultimate 7 // What skill ID for the user's ultimate?
wc3_cham_passive 20 // What skill ID for the user's passive skill?


// Skill and Ultimate configurations

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


// Item configurations

wc3_glove_timer 20 // Interval between receiving a new grenade with the Flaming Gloves of Warmth (default is 10)
wc3_glove_orc_damage 1 // When using gloves, should orcs be given the critical dmg? (Default is 0)
wc3_boots 0.15 // Percentage increase given by boots (.10 = 10%, default is 0.10)
wc3_claw 6 // 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 130 // 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 75 // 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

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

Post by YamiKaitou » Sun Aug 26, 2007 9:28 pm

You are using MySQL 4.x, correct?
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 » Sun Aug 26, 2007 11:14 pm

Yami,
On this database I think it is only 4.x for the mysql. This database is at the same place as the server. I have tried it on 5.x but that database is in ny and the server is in chgo and there is some kind of problem where the datbase laggs out on map changes, so badd the players timeout and get dropped...

Any ideas?

Daver

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

Post by YamiKaitou » Mon Aug 27, 2007 11:11 am

The only thing that I can say is that you remove the parts about "information_schema" from the code. If you are unaware of what to remove or what to do, reply with the version that you are using of War3FT so that I can remove them for you. Note, If you remove these, I do not have any idea what impact it will have on the functionality of War3FT.
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 » Mon Aug 27, 2007 9:18 pm

--- Please enter the following information for support ---
War3ft Version: 3.0rc8
Amxmodx Version: 176d
Metamod Version: 1.19p28

Thx YamiKaitou, ill try anything at this point...

Daver

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

Post by YamiKaitou » Tue Aug 28, 2007 7:54 am

Here is the only changed file. It belongs in the scripting/war3ft/db folder.
Attachments
db_mysqlx.inl
(20.29 KiB) Downloaded 363 times
Image

No support via PM or Email

MoFFaTT
Peon
Posts: 9
Joined: Mon Jun 05, 2006 3:49 am

Post by MoFFaTT » Thu Sep 06, 2007 5:46 am

Thanks YamiKaitou, I've had the same problem for a while now and that seemed to do the trick.

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

Post by Geesu » Wed Sep 12, 2007 9:11 am

Daver that error shouldn't cause your server to crash @ all - if that change fixed it let me know...

But that code is to convert from an old war3users database to the new format - it's meant to auto-detect
No Support via PM

Post Reply