Unable To Connect/unable To Validate

[Viira]

Issues Fixed!!!! ty!!!


- I downloaded MaNGOSx 2.0
- I originally I thought it would work with patch 2.4.2, but I kept getting "Unable to validate game version"
- So I reinstalled WoW, and patched it to 2.3.0 (I dont know if I should go any higher, because I dont want to reinstall again)
- My MAMP is up and running, Apache port 80, MySQL port 3306.
- MaNGOSx says ManGOS 5961 + ScriptDev2 414 / UDB 351
- ManGOS + ScriptDev2, DBC Files, and Database have been "freshly downloaded" the maps I simply pasted to mangos folder, I downloaded maps.rar from another source and have been using those for the past 4 times trying to set up mangos
- so I start server:

see next post for terminal code


- my WoW realmlist is:
set realmlist 127.0.0.1
set patchlist 127.0.0.1
- I go to Options Run WoW
- login as un: root, pw: root, now I get "unable to validate game" message, last night it was "unable to connect"

is it my patches? my database? maps?

so far I've spent 3 days trying to set this up, using different mangos versions and set up instructions, navicat executing batch files, etc.

so far this has given me the lest amount of errors

I would try Accent, if I knew where to find a mac version.

[Viira]

Last login: Mon Jun  9 00:01:54 on ttyp3
Welcome to Darwin!
/opt/mangos/bin/mangos-realmd; exit
XXXX-XXXXXXXX-computer:~ avchic$ /opt/mangos/bin/mangos-realmd; exit
ThreadQueue created
Using configuration file /opt/mangos/etc/realmd.conf.
MaNGOS realm daemon /0.11.0 (Revision 5961) (Unix)
<Ctrl-C> to stop.

Database: 127.0.0.1;3306;root;root;realmd
User thread created.
Reference thread created.
1 reference-thread added.
pollPendingThreads()
1 user-thread added.
Thread starting...
MySQL client library: 5.0.45
MySQL server ver: 5.0.41 
Added realm "MaNGOSx".

Last login: Mon Jun  9 11:05:31 on ttyp2
Welcome to Darwin!
XXXX-XXXXXXXX-computer:~ avchic$ /opt/mangos/bin/mangos-worldd; exit
ThreadQueue created
Using configuration file /opt/mangos/etc/mangosd.conf.
MaNGOS daemon /0.11.0 (Revision 5961) (Unix)
<Ctrl-C> to stop.


MM   MM         MM   MM  MMMMM   MMMM   MMMMM
MM   MM         MM   MM MMM MMM MM  MM MMM MMM
MMM MMM         MMM  MM MMM MMM MM  MM MMM
MM M MM         MMMM MM MMM     MM  MM  MMM
MM M MM  MMMMM  MM MMMM MMM     MM  MM   MMM
MM M MM M   MMM MM  MMM MMMMMMM MM  MM    MMM
MM   MM     MMM MM   MM MM  MMM MM  MM     MMM
MM   MM MMMMMMM MM   MM MMM MMM MM  MM MMM MMM
MM   MM MM  MMM MM   MM  MMMMMM  MMMM   MMMMM
        MM  MMM 
        MMMMMM


World Database: 127.0.0.1;3306;root;root;mangos
User thread created.
Reference thread created.
1 reference-thread added.
pollPendingThreads()
1 user-thread added.
Thread starting...
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.0.45
MySQL server ver: 5.0.41 
AUTOCOMMIT SUCCESSFULLY SET TO 1
Character Database: 127.0.0.1;3306;root;root;characters
User thread created.
pollPendingThreads()
1 user-thread added.
Thread starting...
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.0.45
MySQL server ver: 5.0.41 
AUTOCOMMIT SUCCESSFULLY SET TO 1
Login Database: 127.0.0.1;3306;root;root;realmd
User thread created.
pollPendingThreads()
1 user-thread added.
Thread starting...
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.0.45
MySQL server ver: 5.0.41 
AUTOCOMMIT SUCCESSFULLY SET TO 1
Realm running as realm ID 1
[0 ms] SQL: SELECT version FROM db_version LIMIT 1
Using UDB 0.10.2 (351) for MaNGOS rev. 5949 with SD2 SQL for rev. 414
Using DataDir /opt/mangos/
WORLD: VMap support included. LineOfSight:0, getHeight:0
WORLD: VMap data directory is: /opt/mangos/vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
[1 ms] SQL: SELECT MAX(guid) FROM characters
[1 ms] SQL: SELECT MAX(guid) FROM creature
[1 ms] SQL: SELECT MAX(id) FROM character_pet
[1 ms] SQL: SELECT MAX(guid) FROM item_instance
[0 ms] SQL: SELECT MAX(guid) FROM gameobject
[1 ms] SQL: SELECT MAX(id) FROM auctionhouse
[0 ms] SQL: SELECT MAX(id) FROM mail
[1 ms] SQL: SELECT MAX(id) FROM item_text
[0 ms] SQL: SELECT MAX(guid) FROM corpse

Loading MaNGOS strings...
[2 ms] SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = '1')
[1 ms] SQL: UPDATE characters SET online = 0
[0 ms] SQL: UPDATE realmlist SET allowedSecurityLevel = '0' WHERE id = '1'
[2 ms] SQL: SELECT entry,content_default FROM mangos_string
[******************                    [3 ms] SQL: DELETE FROM character_inventory WHERE item >= '1' 
[**************************************************] 100%  
>> Loaded 500 MaNGOS strings

Initialize data stores...
[[9 ms] SQL: DELETE FROM mail_items WHERE item_guid >= '1'
[0 ms] SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'
[1 ms] SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'
[0 ms] SQL: DELETE FROM corpse WHERE bones_flag = '1'
[2 ms] SQL: UPDATE realmlist SET icon = 1 WHERE id = '1'
[**************************************************] 100%  
>> Loaded 52 data stores


Using Autodetected DBC Locale (0).

Cleaning up instances...
[1 ms] SQL: SELECT DISTINCT(instance) FROM creature_respawn WHERE instance <> 0
[0 ms] SQL: SELECT DISTINCT(instance) FROM gameobject_respawn WHERE instance <> 0
[1 ms] SQL: SELECT DISTINCT(instance) FROM character_instance
[1 ms] SQL: SELECT id FROM instance
[0 ms] SQL: SELECT DISTINCT(instance.id) AS id FROM instance LEFT JOIN character_instance ON (character_instance.instance = instance.id) WHERE (instance.id = character_instance.instance) AND (instance.resettime > 1213023932)
[**************************************************] 100%  
>> Initialized 0 instances, deleted 0 old instances

Packing instances...
[0 ms] SQL: SELECT DISTINCT(instance) FROM character_instance WHERE instance <> 0
[**************************************************] 100%  
>> Instance numbers remapped, next instance id is 1

Loading Localization strings...
[0 ms] SQL: SELECT entry,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_l
oc6,content_loc7 FROM mangos_string WHERE NOT(content_loc1 IS NULL AND content_loc2 IS NULL AND content_loc3 IS NULL AND content_loc4 IS NULL AND content_loc5 IS NULL AND content_loc6 IS NULL AND content_loc7 IS NULL)
[**************************************************] 100%  
>> Loaded 0 MaNGOS locale strings. DB table `mangos_string` contains no localization.

[0 ms] SQL: SELECT entry,name_loc1,subname_loc1,name_loc2,subname_loc2,name_loc3,subname_loc3,name_
loc4,subname_loc4,name_loc5,subname_loc5,name_loc6,subname_loc6,name_loc7,subname
_loc7 FROM locales_creature
[**************************************************] 100%  
>> Loaded 0 creature locale strings. DB table `locales_creature` is empty.

[1 ms] SQL: SELECT entry,name_loc1,name_loc2,name_loc3,name_loc4,name_loc5,name_loc6,name_loc7,cast
barcaption_loc1,castbarcaption_loc2,castbarcaption_loc3,castbarcaption_loc4,castb
arcaption_loc5,castbarcaption_loc6,castbarcaption_loc7 FROM locales_gameobject
[**************************************************] 100%  
>> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.

[1 ms] SQL: SELECT entry,name_loc1,description_loc1,name_loc2,description_loc2,name_loc3,descriptio
n_loc3,name_loc4,description_loc4,name_loc5,description_loc5,name_loc6,descriptio
n_loc6,name_loc7,description_loc7 FROM locales_item
[**************************************************] 100%  
>> Loaded 0 Item locale strings. DB table `locales_item` is empty.

[1 ms] SQL: SELECT entry,Title_loc1,Details_loc1,Objectives_loc1,OfferRewardText_loc1,RequestItemsT
ext_loc1,EndText_loc1,ObjectiveText1_loc1,ObjectiveText2_loc1,ObjectiveText3_loc1
,ObjectiveText4_loc1,Title_loc2,Details_loc2,Objectives_loc2,OfferRewardText_loc2
,RequestItemsText_loc2,EndText_loc2,ObjectiveText1_loc2,ObjectiveText2_loc2,Objec
tiveText3_loc2,ObjectiveText4_loc2,Title_loc3,Details_loc3,Objectives_loc3,OfferR
ewardText_loc3,RequestItemsText_loc3,EndText_loc3,ObjectiveText1_loc3,ObjectiveTe
xt2_loc3,ObjectiveText3_loc3,ObjectiveText4_loc3,Title_loc4,Details_loc4,Objectiv
es_loc4,OfferRewardText_loc4,RequestItemsText_loc4,EndText_loc4,ObjectiveText1_lo
c4,ObjectiveText2_loc4,ObjectiveText3_loc4,ObjectiveText4_loc4,Title_loc5,Details
_loc5,Objectives_loc5,OfferRewardText_loc5,RequestItemsText_loc5,EndText_loc5,Obj
ectiveText1_loc5,ObjectiveText2_loc5,ObjectiveText3_loc5,ObjectiveText4_loc5,Titl
e_loc6,Details_loc6,Objectives_loc6,OfferRewardText_loc6,RequestItemsText_loc6,En
dText_loc6,ObjectiveText1_loc6,ObjectiveText2_loc6,ObjectiveText3_loc6,ObjectiveT
ext4_loc6,Title_loc7,Details_loc7,Objectives_loc7,OfferRewardText_loc7,RequestIte
msText_loc7,EndText_loc7,ObjectiveText1_loc7,ObjectiveText2_loc7,ObjectiveText3_l
oc7,ObjectiveText4_loc7 FROM locales_quest
[**************************************************] 100%  
>> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.

[1 ms] SQL: SELECT entry,Text0_0_loc1,Text0_1_loc1,Text1_0_loc1,Text1_1_loc1,Text2_0_loc1,Text2_1_l
oc1,Text3_0_loc1,Text3_1_loc1,Text4_0_loc1,Text4_1_loc1,Text5_0_loc1,Text5_1_loc1
,Text6_0_loc1,Text6_1_loc1,Text7_0_loc1,Text7_1_loc1,Text0_0_loc2,Text0_1_loc2,Te
xt1_0_loc2,Text1_1_loc2,Text2_0_loc2,Text2_1_loc2,Text3_0_loc2,Text3_1_loc1,Text4
_0_loc2,Text4_1_loc2,Text5_0_loc2,Text5_1_loc2,Text6_0_loc2,Text6_1_loc2,Text7_0_
loc2,Text7_1_loc2,Text0_0_loc3,Text0_1_loc3,Text1_0_loc3,Text1_1_loc3,Text2_0_loc
3,Text2_1_loc3,Text3_0_loc3,Text3_1_loc1,Text4_0_loc3,Text4_1_loc3,Text5_0_loc3,T
ext5_1_loc3,Text6_0_loc3,Text6_1_loc3,Text7_0_loc3,Text7_1_loc3,Text0_0_loc4,Text
0_1_loc4,Text1_0_loc4,Text1_1_loc4,Text2_0_loc4,Text2_1_loc4,Text3_0_loc4,Text3_1
_loc1,Text4_0_loc4,Text4_1_loc4,Text5_0_loc4,Text5_1_loc4,Text6_0_loc4,Text6_1_lo
c4,Text7_0_loc4,Text7_1_loc4,Text0_0_loc5,Text0_1_loc5,Text1_0_loc5,Text1_1_loc5,
Text2_0_loc5,Text2_1_loc5,Text3_0_loc5,Text3_1_loc1,Text4_0_loc5,Text4_1_loc5,Tex
t5_0_loc5,Text5_1_loc5,Text6_0_loc5,Text6_1_loc5,Text7_0_loc5,Text7_1_loc5,Text0_
0_loc6,Text0_1_loc6,Text1_0_loc6,Text1_1_loc6,Text2_0_loc6,Text2_1_loc6,Text3_0_l
oc6,Text3_1_loc1,Text4_0_loc6,Text4_1_loc6,Text5_0_loc6,Text5_1_loc6,Text6_0_loc6
,Text6_1_loc6,Text7_0_loc6,Text7_1_loc6,Text0_0_loc7,Text0_1_loc7,Text1_0_loc7,Te
xt1_1_loc7,Text2_0_loc7,Text2_1_loc7,Text3_0_loc7,Text3_1_loc1,Text4_0_loc7,Text4
_1_loc7,Text5_0_loc7,Text5_1_loc7,Text6_0_loc7,Text6_1_loc7,Text7_0_loc7,Text7_1_
loc7  FROM locales_npc_text
[**************************************************] 100%  
>> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty.

[0 ms] SQL: SELECT entry,text_loc1,text_loc2,text_loc3,text_loc4,text_loc5,text_loc6,text_loc7 FROM locales_page_text
[**************************************************] 100%  
>> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.

Loading Page Texts...
[1 ms] SQL: SELECT MAX(entry) FROM page_text
[0 ms] SQL: SELECT COUNT(*) FROM page_text
[0 ms] SQL: SELECT * FROM page_text
[**************************************************] 100%  
>> Loaded 1375 page texts

Loading Game Object Templates...
[0 ms] SQL: SELECT MAX(entry) FROM gameobject_template
[0 ms] SQL: SELECT COUNT(*) FROM gameobject_template
[2 ms] SQL: SELECT * FROM gameobject_template
[**************************************************] 100%  
>> Loaded 13508 game object templates

Loading Spell Chain Data...
[1 ms] SQL: SELECT spell_id, prev_spell, first_spell, rank FROM spell_chain
[**************************************************] 100%  
>> Loaded 1919 spell chain records

Loading Spell Elixir types...
[1 ms] SQL: SELECT entry, mask FROM spell_elixir
[**************************************************] 100%  
>> Loaded 98 spell elixir definitions

Loading Spell Learn Skills...
[1 ms] SQL: SELECT entry, SkillID, Value, MaxValue FROM spell_learn_skill
[**************************************************] 100%  
>> Loaded 42 spell learn skills + 74 found in DBC

Loading Spell Learn Spells...
[0 ms] SQL: SELECT entry, SpellID FROM spell_learn_spell
[**************************************************] 100%  
>> Loaded 15 spell learn spells + 500 found in DBC

Loading Spell Proc Event conditions...
[2 ms] SQL: SELECT entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate FROM spell_proc_event
[**************************************************] 100%  
>> Loaded 932 spell proc event conditions

Loading Aggro Spells Definitions...
[1 ms] SQL: SELECT MAX(entry) FROM spell_threat
[0 ms] SQL: SELECT COUNT(*) FROM spell_threat
[0 ms] SQL: SELECT * FROM spell_threat
[**************************************************] 100%  
>> Loaded 89 aggro generating spells

Loading NPC Texts...
[1 ms] SQL: SELECT * FROM npc_text
[**************************************************] 100%  
>> Loaded 4002 npc texts

Loading Item Random Enchantments Table...
[2 ms] SQL: SELECT entry, ench, chance FROM item_enchantment_template
[**************************************************] 100%  
>> Loaded 28408 Item Enchantment definitions

Loading Items...
[1 ms] SQL: SELECT MAX(entry) FROM item_template
[0 ms] SQL: SELECT COUNT(*) FROM item_template
[1 ms] SQL: SELECT * FROM item_template
[**************************************************] 100%  
>> Loaded 23551 item prototypes

Loading Item Texts...
[1 ms] SQL: SELECT id, text FROM item_text
[**************************************************] 100%  
>> Loaded 0 item pages

Loading Creature Model Based Info Data...
[0 ms] SQL: SELECT MAX(modelid) FROM creature_model_info
[0 ms] SQL: SELECT COUNT(*) FROM creature_model_info
[3 ms] SQL: SELECT * FROM creature_model_info
[**************************************************] 100%  
>> Loaded 16842 creature model based info

Loading Equipment templates...
[1 ms] SQL: SELECT MAX(entry) FROM creature_equip_template
[0 ms] SQL: SELECT COUNT(*) FROM creature_equip_template
[1 ms] SQL: SELECT * FROM creature_equip_template
[**************************************************] 100%  
>> Loaded 2182 equipment template

Loading Creature templates...
[0 ms] SQL: SELECT MAX(entry) FROM creature_template
[0 ms] SQL: SELECT COUNT(*) FROM creature_template
[2 ms] SQL: SELECT * FROM creature_template
[**************************************************] 100%  
>> Loaded 18714 creature definitions

Loading SpellsScriptTarget...
[0 ms] SQL: SELECT entry,type,targetEntry FROM spell_script_target
[**************************************************] 100%  
>> Loaded 183 Spell Script Targets

Loading Creature Reputation OnKill Data...
[1 ms] SQL: SELECT creature_id, RewOnKillRepFaction1, RewOnKillRepFaction2,IsTeamAward1, MaxStanding1, RewOnKillRepValue1, IsTeamAward2, MaxStanding2, RewOnKillRepValue2, TeamDependent FROM creature_onkill_reputation
[**************************************************] 100%  
>> Loaded 1056 creature award reputation definitions

Loading Pet Create Spells...
[2 ms] SQL: SELECT entry, Spell1, Spell2, Spell3, Spell4,FamilyPassive FROM petcreateinfo_spell
[**************************************************] 100%  
>> Loaded 736 pet create spells

Loading Creature Data...
[3 ms] SQL: SELECT creature.guid, id, map, modelid,equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint,curhealth, curmana, DeathState, MovementType, spawnMask, event FROM creature LEFT OUTER JOIN game_event_creature ON creature.guid = game_event_creature.guid
[**************************************************] 100%  
>> Loaded 96634 creatures

Loading Creature Addon Data...
[1 ms] SQL: SELECT MAX(entry) FROM creature_template_addon
[0 ms] SQL: SELECT COUNT(*) FROM creature_template_addon
[2 ms] SQL: SELECT * FROM creature_template_addon
[**************************************************] 100%  
>> Loaded 4424 creature template addons

[0 ms] SQL: SELECT MAX(guid) FROM creature_addon
[0 ms] SQL: SELECT COUNT(*) FROM creature_addon
[1 ms] SQL: SELECT * FROM creature_addon
[**************************************************] 100%  
>> Loaded 32927 creature addons

Loading Creature Respawn Data...
[0 ms] SQL: DELETE FROM creature_respawn WHERE respawntime <= UNIX_TIMESTAMP(NOW())
[0 ms] SQL: SELECT guid,respawntime,instance FROM creature_respawn
[**************************************************] 100%  
>> Loaded 0 creature respawn time.

Loading Gameobject Data...
[3 ms] SQL: SELECT gameobject.guid, id, map, position_x, position_y, position_z, orientation,rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state, spawnMask, event FROM gameobject LEFT OUTER JOIN game_event_gameobject ON gameobject.guid = game_event_gameobject.guid
[**************************************************] 100%  
>> Loaded 47693 gameobjects

Loading Gameobject Respawn Data...
[1 ms] SQL: DELETE FROM gameobject_respawn WHERE respawntime <= UNIX_TIMESTAMP(NOW())
[1 ms] SQL: SELECT guid,respawntime,instance FROM gameobject_respawn
[**************************************************] 100%  
>> Loaded 0 gameobject respawn time.

Loading Game Event Data...
[0 ms] SQL: SELECT MAX(entry) FROM game_event
[0 ms] SQL: SELECT entry,UNIX_TIMESTAMP(start_time),UNIX_TIMESTAMP(end_time),occurence,length,description FROM game_event
[**************************************************] 100%  
>> Loaded 34 game events
[6 ms] SQL: SELECT creature.guid, game_event_creature.event FROM creature JOIN game_event_creature ON creature.guid = game_event_creature.guid
[**************************************************] 100%  
>> Loaded 2201 creatures in game events

[6 ms] SQL: SELECT gameobject.guid, game_event_gameobject.event FROM gameobject JOIN game_event_gameobject ON gameobject.guid=game_event_gameobject.guid
[**************************************************] 100%  
>> Loaded 11731 gameobjects in game events

[0 ms] SQL: SELECT creature.guid, game_event_model_equip.event, game_event_model_equip.modelid,game_event_model_equip.equipment_id FROM creature JOIN game_event_model_equip ON creature.guid=game_event_model_equip.guid
[**************************************************] 100%  
>> Loaded 10 model/equipment changes in game events

[0 ms] SQL: SELECT id, quest, event FROM game_event_creature_quest
[**************************************************] 100%  
>> Loaded 4 quests additions in game events


Loading Weather Data...
[0 ms] SQL: SELECT zone, spring_rain_chance, spring_snow_chance, spring_storm_chance, summer_rain_chance, summer_snow_chance, summer_storm_chance, fall_rain_chance, fall_snow_chance, fall_storm_chance, winter_rain_chance, winter_snow_chance, winter_storm_chance FROM game_weather
[**************************************************] 100%  
>> Loaded 35 weather definitions

Loading Quests...
[2 ms] SQL: SELECT entry, ZoneOrSort, SkillOrClass, MinLevel, QuestLevel, Type, RequiredRaces, RequiredSkillValue,RepObjectiveFaction, RepObjectiveValue, RequiredMinRepFaction, RequiredMinRepValue, RequiredMaxRepFaction, RequiredMaxRepValue, SuggestedPlayers, LimitTime,QuestFlags, SpecialFlags, CharTitleId, PrevQuestId, NextQuestId, ExclusiveGroup, NextQuestInChain, SrcItemId, SrcItemCount, SrcSpell,Title, Details, Objectives, OfferRewardText, RequestItemsText, EndText, ObjectiveText1, ObjectiveText2, ObjectiveText3, ObjectiveText4,ReqItemId1, ReqItemId2, ReqItemId3, ReqItemId4, ReqItemCount1, ReqItemCount2, ReqItemCount3, ReqItemCount4,ReqSourceId1, ReqSourceId2, ReqSourceId3, ReqSourceId4, ReqSourceCount1, ReqSourceCount2, ReqSourceCount3, ReqSourceCount4, ReqSourceRef1, ReqSourceRef2, ReqSourceRef3, ReqSourceRef4,ReqCreatureOrGOId1, ReqCreatureOrGOId2, ReqCreatureOrGOId3, ReqCreatureOrGOId4, ReqCreatureOrGOCount1, ReqCreatureOrGOCount2, ReqCreatureOrGOCount3, ReqCreatureOrGOCount4,ReqSpellCast1, ReqSpellCast2, ReqSpellCast3, ReqSpellCast4,RewChoiceItemId1, RewChoiceItemId2, RewChoiceItemId3, RewChoiceItemId4, RewChoiceItemId5, RewChoiceItemId6,RewChoiceItemCount1, RewChoiceItemCount2, RewChoiceItemCount3, RewChoiceItemCount4, RewChoiceItemCount5, RewChoiceItemCount6,RewItemId1, RewItemId2, RewItemId3, RewItemId4, RewItemCount1, RewItemCount2, RewItemCount3, RewItemCount4,RewRepFaction1, RewRepFaction2, RewRepFaction3, RewRepFaction4, RewRepFaction5, RewRepValue1, RewRepValue2, RewRepValue3, RewRepValue4, RewRepValue5,RewOrReqMoney, RewMoneyMaxLevel, RewSpell, RewSpellCast, PointMapId, PointX, PointY, PointOpt, DetailsEmote1, DetailsEmote2, DetailsEmote3, DetailsEmote4,IncompleteEmote, CompleteEmote, OfferRewardEmote1, OfferRewardEmote2, OfferRewardEmote3, OfferRewardEmote4, StartScript, CompleteScript FROM quest_template
[**************************************************] 100%  
>> Loaded 6506 quests definitions

Loading Quests Relations...
[1 ms] SQL: SELECT id,quest FROM gameobject_questrelation
[**************************************************] 100%  
>> Loaded 278 quest relations from gameobject_questrelation

[0 ms] SQL: SELECT id,quest FROM gameobject_involvedrelation
[**************************************************] 100%  
>> Loaded 210 quest relations from gameobject_involvedrelation

[1 ms] SQL: SELECT id,quest FROM creature_questrelation
[**************************************************] 100%  
>> Loaded 5408 quest relations from creature_questrelation

[1 ms] SQL: SELECT id,quest FROM creature_involvedrelation
[**************************************************] 100%  
>> Loaded 5651 quest relations from creature_involvedrelation

Loading AreaTrigger definitions...
[1 ms] SQL: SELECT id, required_level, required_item, required_item2, heroic_key, heroic_key2, required_quest_done, required_failed_text, target_map, target_position_x, target_position_y, target_position_z, target_orientation FROM areatrigger_teleport
[**************************************************] 100%  
>> Loaded 165 area trigger teleport definitions

Loading Quest Area Triggers...
[1 ms] SQL: SELECT id,quest FROM areatrigger_involvedrelation
[**************************************************] 100%  
>> Loaded 35 quest trigger points

Loading Tavern Area Triggers...
[1 ms] SQL: SELECT id FROM areatrigger_tavern
[**************************************************] 100%  
>> Loaded 70 tavern triggers

Loading Graveyard-zone links...
[1 ms] SQL: SELECT id,ghost_zone,faction FROM game_graveyard_zone
[**************************************************] 100%  
>> Loaded 283 graveyard-zone links

Loading Spell teleport coordinates...
[1 ms] SQL: SELECT id, target_map, target_position_x, target_position_y, target_position_z, target_orientation FROM spell_teleport
[**************************************************] 100%  
>> Loaded 83 spell teleport coordinates

Loading SpellAffect definitions...
[1 ms] SQL: SELECT entry, effectId, SpellFamilyMask FROM spell_affect
[**************************************************] 100%  
>> Loaded 1224 spell affect definitions

Loading player Create Info & Level Stats...
[1 ms] SQL: SELECT race, class, map, zone, position_x, position_y, position_z FROM playercreateinfo
[**************************************************] 100%  
>> Loaded 52 player create definitions

[1 ms] SQL: SELECT race, class, itemid, amount FROM playercreateinfo_item
[**************************************************] 100%  
>> Loaded 387 player create items

[2 ms] SQL: SELECT race, class, Spell, Active FROM playercreateinfo_spell
[**************************************************] 100%  
>> Loaded 2005 player create spells

[1 ms] SQL: SELECT race, class, Skill FROM playercreateinfo_skill
[**************************************************] 100%  
>> Loaded 188 player create skills

[1 ms] SQL: SELECT race, class, button, action, type, misc FROM playercreateinfo_action
[**************************************************] 100%  
>> Loaded 281 player create actions

[1 ms] SQL: SELECT class, level, basehp, basemana FROM player_classlevelstats
[**************************************************] 100%  
>> Loaded 630 level health/mana definitions

[1 ms] SQL: SELECT race, class, level, str, agi, sta, inte, spi FROM player_levelstats
[**************************************************] 100%  
>> Loaded 3640 level stats definitions

Loading Exploration BaseXP Data...
[1 ms] SQL: SELECT level,basexp FROM exploration_basexp
[**************************************************] 100%  
>> Loaded 71 BaseXP definitions

Loading Pet Name Parts...
[1 ms] SQL: SELECT word,entry,half FROM pet_name_generation
[**************************************************] 100%  
>> Loaded 198 pet name parts

Loading the max pet number...
[1 ms] SQL: SELECT MAX(id) FROM character_pet
[**************************************************] 100%  
>> Loaded the max pet number: 0

Loading pet level stats...
[1 ms] SQL: SELECT creature_entry, level, hp, mana, str, agi, sta, inte, spi, armor FROM pet_levelstats
[**************************************************] 100%  
>> Loaded 560 level pet stats definitions

Loading Player Corpses...
[0 ms] SQL: SELECT position_x, position_y, position_z, orientation, map, data, bones_flag, instance, player, guid FROM corpse WHERE bones_flag = 0
[**************************************************] 100%  
>> Loaded 0 corpses

Loading Loot Tables...
creature_loot_template :
[2 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, freeforall, lootcondition, condition_value1, condition_value2 FROM creature_loot_template
[**************************************************] 100%  
>> Loaded 273693 loot definitions (6455 templates)

disenchant_loot_template :
[1 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, freeforall, lootcondition, condition_value1, condition_value2 FROM disenchant_loot_template
[**************************************************] 100%  
>> Loaded 102 loot definitions (46 templates)

fishing_loot_template :
[2 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, freeforall, lootcondition, condition_value1, condition_value2 FROM fishing_loot_template
[**************************************************] 100%  
>> Loaded 432 loot definitions (205 templates)

gameobject_loot_template :
[1 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, freeforall, lootcondition, condition_value1, condition_value2 FROM gameobject_loot_template
[**************************************************] 100%  
>> Loaded 24054 loot definitions (712 templates)

item_loot_template :
[2 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, freeforall, lootcondition, condition_value1, condition_value2 FROM item_loot_template
[**************************************************] 100%  
>> Loaded 4541 loot definitions (205 templates)

pickpocketing_loot_template :
[2 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, freeforall, lootcondition, condition_value1, condition_value2 FROM pickpocketing_loot_template
[**************************************************] 100%  
>> Loaded 10565 loot definitions (2439 templates)

skinning_loot_template :
[2 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, freeforall, lootcondition, condition_value1, condition_value2 FROM skinning_loot_template
[**************************************************] 100%  
>> Loaded 3644 loot definitions (1066 templates)

prospecting_loot_template :
[2 ms] SQL: SELECT entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, freeforall, lootcondition, condition_value1, condition_value2 FROM prospecting_loot_template
[**************************************************] 100%  
>> Loaded 75 loot definitions (10 templates)

Loading Skill Discovery Table...
[1 ms] SQL: SELECT spellId, reqSpell, chance FROM skill_discovery_template
[**************************************************] 100%  
>> Loaded 17 skill discovery definitions

Loading Skill Extra Item Table...
[1 ms] SQL: SELECT spellId, requiredSpecialization, additionalCreateChance, additionalMaxNum FROM skill_extra_item_template
[**************************************************] 100%  
>> Loaded 160 spell specialization definitions

Loading Skill Fishing base level requirements...
[1 ms] SQL: SELECT entry,skill FROM skill_fishing_base_level
[**************************************************] 100%  
>> Loaded 78 areas for fishing base skill level

Loading Auctions...
[0 ms] SQL: SELECT itemguid,item_template FROM auctionhouse
[1 ms] SQL: SELECT COUNT(*) FROM auctionhouse
Loading Guilds...
[1 ms] SQL: SELECT guildid FROM guild
[**************************************************] 100%  
>> Loaded 0 guild definitions

Loading ArenaTeams...
[1 ms] SQL: SELECT arenateamid FROM arena_team
[**************************************************] 100%  
>> Loaded 0 arenateam definitions

Loading Groups...
[1 ms] SQL: SELECT mainTank, mainAssistant, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, isRaid, leaderGuid FROM groups
[**************************************************] 100%  
>> Loaded 0 group definitions

Loading ReservedNames...
[1 ms] SQL: SELECT name FROM reserved_name
[**************************************************] 100%  
>> Loaded 0 reserved player names

Loading GameObject for quests...

>> Loaded 651 GameObject for quests
Loading InstanceTemplate
[1 ms] SQL: SELECT MAX(map) FROM instance_template
[0 ms] SQL: SELECT COUNT(*) FROM instance_template
[0 ms] SQL: SELECT * FROM instance_template
[**************************************************] 100%  
>> Loaded 51 Instance Template definitions

Loading BattleMasters...
[1 ms] SQL: SELECT entry,bg_template FROM battlemaster_entry
[**************************************************] 100%  
>> Loaded 59 battlemaster entries

Returning old mails...
Returning mails current time: hour: 11, minute: 5, second: 40 
[1 ms] SQL: SELECT id,messageType,sender,receiver,itemTextId,has_items,expire_time,cod,checked FROM mail WHERE expire_time < '1213023940'
Loading Scripts...
quest_start_scripts :
[2 ms] SQL: SELECT id,delay,command,datalong,datalong2,datatext, x, y, z, o FROM quest_start_scripts
[**************************************************] 100%  
>> Loaded 260 script definitions

quest_end_scripts :
[1 ms] SQL: SELECT id,delay,command,datalong,datalong2,datatext, x, y, z, o FROM quest_end_scripts
[[1 ms] SQL: DELETE FROM mail WHERE expire_time < '1213023940' AND has_items = '0' AND itemTextId = 0
[**************************************************] 100%  
>> Loaded 162 script definitions

spell_scripts :
[1 ms] SQL: SELECT id,delay,command,datalong,datalong2,datatext, x, y, z, o FROM spell_scripts
[**************************************************] 100%  
>> Loaded 4 script definitions

gameobject_scripts :
[1 ms] SQL: SELECT id,delay,command,datalong,datalong2,datatext, x, y, z, o FROM gameobject_scripts
[**************************************************] 100%  
>> Loaded 49 script definitions

event_scripts :
[2 ms] SQL: SELECT id,delay,command,datalong,datalong2,datatext, x, y, z, o FROM event_scripts
[**************************************************] 100%  
>> Loaded 396 script definitions

Initializing Scripts...
Scripts Library libmangosscript.dylib was successfully loaded.

SD2: ScriptDev2 initializing (Revision 246) (Unix)

SD2: Using configuration file ScriptDev2.conf
SD2: Using locale 0

User thread created.
pollPendingThreads()
1 user-thread added.
Thread starting...
Could not connect to MySQL database at 127.0.0.1: Unknown database 'unifiedsd2'

SD2: Unable to connect to Database
SD2: Loaded 521 C++ Scripts

DEBUG:: Initialize game time and timers
Mail timer set to: 420, mail return is called every 1440 minutes
[7 ms] SQL: SELECT distinct(id) as uniqueid FROM creature_movement
[0 ms] SQL: INSERT INTO uptime (startstring, starttime, uptime) VALUES('2008-06-09 11:05:40', 1213023940, 0)
Starting Map System
[1 ms] SQL: SELECT MAX(id) FROM instance
Starting BattleGround System
[0 ms] SQL: SELECT id, MinPlayersPerTeam,MaxPlayersPerTeam,MinLvl,MaxLvl,AllianceStartLoc,AllianceStart
O,HordeStartLoc,HordeStartO FROM battleground_template
[Creature 97085 used AI is ReactorAI.              ] 24%  
Loading map /opt/mangos/maps/4892929.map
Ignored VMAP name:Warsong Gulch, id:489, x:29, y:29 (vmap rep.: x:29, y:29)
Object 97085 enters grid[34,34]
Creature 97086 used AI is ReactorAI.
Loading map /opt/mangos/maps/4893029.map
Ignored VMAP name:Warsong Gulch, id:489, x:30, y:29 (vmap rep.: x:29, y:30)
Object 97086 enters grid[33,34]
BatteGroundWS: BG objects and spirit guides spawned
[Creature 97087 used AI is ReactorAI.              ] 50%  
Loading map /opt/mangos/maps/5662729.map
Ignored VMAP name:Eye of the Storm, id:566, x:27, y:29 (vmap rep.: x:29, y:27)
Object 97087 enters grid[36,34]
Creature 97088 used AI is ReactorAI.
Loading map /opt/mangos/maps/5662829.map
Ignored VMAP name:Eye of the Storm, id:566, x:28, y:29 (vmap rep.: x:29, y:28)
Object 97088 enters grid[35,34]
[**************************************************] 100%  
>> Loaded 8 battlegrounds

Loading Transports...
[0 ms] SQL: SELECT entry, name, period FROM transports
[**************************************************] 100%  
>> Loaded 9 transports
[29 ms] SQL: SELECT gameobject.guid,gameobject.id,transports.name FROM gameobject,transports WHERE gameobject.id = transports.entry

Deleting expired bans...
Calculate next daily quest reset time...
[2 ms] SQL: SELECT MAX(time) FROM character_queststatus_daily
Starting Game Event system...
GameEvent 4 "Darkmoon Faire (Elwynn Forest)" started.
GameEvent 16 "Gurubashi Arena Booty Run" started.
GameEvent 18 "Call to Arms: Alterac Valley!" started.
GameEvent 30 "Edge of Madness, Hazza'rah" started.
INSTANCEMAP: Loading instance template
New instance data, "instance_zulgurub" ,initialized!
Next game event check in 3260 seconds.
Game Event system initialized.
WORLD: World initialized
User thread created.
pollPendingThreads()
1 user-thread added.
Thread starting...
User thread created.
pollPendingThreads()
1 user-thread added.
Thread starting...

help          - Display this help message.
broadcast     - Announce in-game message.
create        - Create account.
delete        - Delete account and characters.
info          - Display Server infomation.
uptime        - Displays the server uptime.
motd          - Change or display motd.
kick          - Kick user.
ban           - Ban account|ip.
listbans      - List bans.
unban         - Remove ban from account|ip.
setgm         - Edit user privileges.
setpass       - Set password for account.
setbc         - Set user expansion allowed.
listgm        - Display user privileges.
loadscripts   - Load script library.
setloglevel   - Set Log Level.
corpses       - Manually call corpses erase global even code.
version       - Display server version.
idleshutdown  - Shutdown server with some delay when there are no active connections remaining.
shutdown      - Shutdown server with some delay.
exit          - Shutdown server NOW.
writepdump    - Write a player dump to a file.
loadpdump     - Load a player dump from a file.
saveall       - Save all players.
send          - Send message to a player.
tele          - Teleport player to location.
plimit        - Show or set player login limitations.
mangos>[0 ms] SQL: DELETE FROM ip_banned WHERE unbandate<=UNIX_TIMESTAMP() AND unbandate<>bandate
[1 ms] SQL: UPDATE realmlist SET color = 0, population = 0 WHERE id = '1'
Grid[35,34] on map 566 moved to IDLE state
Grid[36,34] on map 566 moved to IDLE state

[Station15]

Did you set the passwords right?

;root;----->root<---;realmd

[Viira]

realmd.conf has:

LoginDatabaseInfo = "127.0.0.1;3306;root;root;realmd"

[Viira]

Note, I got server to work, need the resent patches thats all. Had a blast for a week!

new issue, mysql wont start now, in the log it says something is running on port 3306, possibly a mysql that didn't shut down correctly?

How do I shut down whatever is on that port? Is there a terminal command?

FIXED: thanks to http://www.mmowned.com/forums/emulat...p-mac-osx.html guide

used,

cd /usr/local/mysql

then:

sudo ./bin/mysqld_safe

then:

sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop

[**Sweeny**]

Issues:
-Virus on computer
-You didnt apply patch to WoW
-your logonserver.exe and ascent/antrix.exe are form different server starts and arent working together, restart
-your firewall or other program is blocking your server or mysql access tot he internet
-Max build?
Dont use mangos.
*EDIT* My bad didnt read that post above me right.

new issue, mysql wont start now, in the log it says something is running on port 3306, possibly a mysql that didn't shut down correctly?

Open up [CMD] & type "NET STOP MYSQL". Then type "NET START MYSQL". disable firewall. and btw chose mysql51 or sumthing on setup.