Mangos Creating Mangos Server

[dagamerc13]

Re: [Mangos] How to make a Mangos server

yeah. because the guide tells you everything to do for setup in multi or single player.

 

[dagamerc13]

Re: [Mangos] How to make a Mangos server

I fixed a couple of links today.

 

[luigix]

Re: [Mangos] How to make a Mangos server

Hi guys, and big thanks to dagamerc13 for this awesome guide, finally got my server running =D

But i noticed there wasn't any scriptdev2 being used, but there are sql scripts for it in the mangos folder, and i've been to mangos' forums and i think they do use it? Any idea about that?

i asked because it seemed like something related to scripted events..and i just ran sunwell plateau, but there were several problems,
First boss, Kalecgos & Sathrovarr fight, sathrovarr was no where to be found!
Felmyst doesn't spawn if i recall properly...i killed brutallus but nothing else appeared.
Several bosses later...Mu'ru, he doesnt despawn properly, because he is supposed to die and spawn Entropius, but it doesn't
Lastly, Kil'jaeden! In the center of the room he is supposed to be, he is missing, but instead there is only a invisible npc named "kil'jaeden" with 1 hp, and i had to target him with /target kil'jaeden, he can't be attacked as well.
I personally never fought him before, but i think theres another npc named Anveena linked to summoning him.
Any ideas?

i updated my mangos_instance_template to the latest one provided in the sql updates in the mangos folder. Am using MaNGOS_6563_ScriptDev2_629_SSE which u provided in the guide.


Hope to hear from you again, thanks again for the awesome guide!


Edit: oh yeah illidan also doesn't die properly =( i had to .die him as i couldn't attack him any further after maiev despawned( which i believe should means illidan dies, i watched the world first kill video)

 

[dagamerc13]

Re: [Mangos] How to make a Mangos server

i just read up on that and may add it to the guide. everything here is set up to be sd2 ready but if you want to truly use it you can put the scriptdev2 database in.

 

[luigix]

Re: [Mangos] How to make a Mangos server

thats great to hear, but any idea how to set it up?
Is it just like the other databases such as realmd, character and mangos?
just add it into mysql and restore data from dump?
which sql file to restore with?

Thanks

 

[Gokuj]

Re: [Mangos] How to make a Mangos server

K well new error now:

2008-09-22 15:46:11 Using configuration file mangosd.conf.
2008-09-22 15:46:11 MaNGOS/0.12.0-SVN (Revision 6563) (Win32,little-endian) (world-daemon)
2008-09-22 15:46:11 <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 http://www.mangosproject.org
        MMMMMM


2008-09-22 15:46:11 World Database: 127.0.0.1;3306;root;root;mangos
2008-09-22 15:46:11 MySQL client library: 5.0.56
2008-09-22 15:46:11 MySQL server ver: 5.0.67-community-nt 
2008-09-22 15:46:11 Character Database: 127.0.0.1;3306;root;root;characters
2008-09-22 15:46:11 MySQL client library: 5.0.56
2008-09-22 15:46:11 MySQL server ver: 5.0.67-community-nt 
2008-09-22 15:46:11 Login Database: 127.0.0.1;3306;root;root;realmd
2008-09-22 15:46:11 MySQL client library: 5.0.56
2008-09-22 15:46:11 MySQL server ver: 5.0.67-community-nt 
2008-09-22 15:46:11 Realm running as realm ID 1
2008-09-22 15:46:11 Using UDB 0.10.3 (357) for MaNGOS rev. 6240 with SD2 SQL for rev. 473
2008-09-22 15:46:11 Using DataDir C:\Documents and Settings\Jay\Desktop\Mangos/
2008-09-22 15:46:11 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-09-22 15:46:11 WORLD: VMap data directory is: C:\Documents and Settings\Jay\Desktop\Mangos/vmaps
2008-09-22 15:46:11 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-09-22 15:46:11 
2008-09-22 15:46:11 Loading MaNGOS strings...
2008-09-22 15:46:11 
2008-09-22 15:46:11 >> Loaded 503 MaNGOS strings
2008-09-22 15:46:11 Initialize data stores...
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 55 data stores
2008-09-22 15:46:12 
2008-09-22 15:46:12 Using enUS DBC Locale as default. All available DBC locales: enUS 
2008-09-22 15:46:12 Loading InstanceTemplate
2008-09-22 15:46:12 >> Loaded 51 Instance Template definitions
2008-09-22 15:46:12 
2008-09-22 15:46:12 Loading SkillLineAbilityMultiMap Data...
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 7025 SkillLineAbility MultiMap
2008-09-22 15:46:12 Cleaning up instances...
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Initialized 0 instances
2008-09-22 15:46:12 Packing instances...
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Instance numbers remapped, next instance id is 600
2008-09-22 15:46:12 Loading Localization strings...
[COLOR="Red"]2008-09-22 15:46:12 ERROR:SQL: SELECT[/COLOR] entry,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 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 AND content_loc8 IS NULL)
2008-09-22 15:46:12 ERROR:query ERROR: Unknown column 'content_loc8' in 'field list'
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 0 MaNGOS locale strings. DB table `mangos_string` contains no localization.
2008-09-22 15:46:12 ERROR: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,name_loc8,subname_loc8 FROM locales_creature
2008-09-22 15:46:12 ERROR:query ERROR: Unknown column 'name_loc8' in 'field list'
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 0 creature locale strings. DB table `locales_creature` is empty.
2008-09-22 15:46:12 ERROR:SQL: SELECT entry,name_loc1,name_loc2,name_loc3,name_loc4,name_loc5,name_loc6,name_loc7,name_loc8,castbarcaption_loc1,castbarcaption_loc2,castbarcaption_loc3,castbarcaption_loc4,castbarcaption_loc5,castbarcaption_loc6,castbarcaption_loc7,castbarcaption_loc8 FROM locales_gameobject
2008-09-22 15:46:12 ERROR:query ERROR: Unknown column 'name_loc8' in 'field list'
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.
2008-09-22 15:46:12 ERROR:SQL: SELECT entry,name_loc1,description_loc1,name_loc2,description_loc2,name_loc3,description_loc3,name_loc4,description_loc4,name_loc5,description_loc5,name_loc6,description_loc6,name_loc7,description_loc7,name_loc8,description_loc8 FROM locales_item
2008-09-22 15:46:12 ERROR:query ERROR: Unknown column 'name_loc8' in 'field list'
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 0 Item locale strings. DB table `locales_item` is empty.
2008-09-22 15:46:12 ERROR:SQL: SELECT entry,Title_loc1,Details_loc1,Objectives_loc1,OfferRewardText_loc1,RequestItemsText_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,ObjectiveText3_loc2,ObjectiveText4_loc2,Title_loc3,Details_loc3,Objectives_loc3,OfferRewardText_loc3,RequestItemsText_loc3,EndText_loc3,ObjectiveText1_loc3,ObjectiveText2_loc3,ObjectiveText3_loc3,ObjectiveText4_loc3,Title_loc4,Details_loc4,Objectives_loc4,OfferRewardText_loc4,RequestItemsText_loc4,EndText_loc4,ObjectiveText1_loc4,ObjectiveText2_loc4,ObjectiveText3_loc4,ObjectiveText4_loc4,Title_loc5,Details_loc5,Objectives_loc5,OfferRewardText_loc5,RequestItemsText_loc5,EndText_loc5,ObjectiveText1_loc5,ObjectiveText2_loc5,ObjectiveText3_loc5,ObjectiveText4_loc5,Title_loc6,Details_loc6,Objectives_loc6,OfferRewardText_loc6,RequestItemsText_loc6,EndText_loc6,ObjectiveText1_loc6,ObjectiveText2_loc6,ObjectiveText3_loc6,ObjectiveText4_loc6,Title_loc7,Details_loc7,Objectives_loc7,OfferRewardText_loc7,RequestItemsText_loc7,EndText_loc7,ObjectiveText1_loc7,ObjectiveText2_loc7,ObjectiveText3_loc7,ObjectiveText4_loc7,Title_loc8,Details_loc8,Objectives_loc8,OfferRewardText_loc8,RequestItemsText_loc8,EndText_loc8,ObjectiveText1_loc8,ObjectiveText2_loc8,ObjectiveText3_loc8,ObjectiveText4_loc8 FROM locales_quest
2008-09-22 15:46:12 ERROR:query ERROR: Unknown column 'Title_loc8' in 'field list'
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.
2008-09-22 15:46:12 ERROR:SQL: SELECT entry,Text0_0_loc1,Text0_1_loc1,Text1_0_loc1,Text1_1_loc1,Text2_0_loc1,Text2_1_loc1,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,Text1_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_loc3,Text2_1_loc3,Text3_0_loc3,Text3_1_loc1,Text4_0_loc3,Text4_1_loc3,Text5_0_loc3,Text5_1_loc3,Text6_0_loc3,Text6_1_loc3,Text7_0_loc3,Text7_1_loc3,Text0_0_loc4,Text0_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_loc4,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,Text5_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_loc6,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,Text1_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, Text0_0_loc8,Text0_1_loc8,Text1_0_loc8,Text1_1_loc8,Text2_0_loc8,Text2_1_loc8,Text3_0_loc8,Text3_1_loc1,Text4_0_loc8,Text4_1_loc8,Text5_0_loc8,Text5_1_loc8,Text6_0_loc8,Text6_1_loc8,Text7_0_loc8,Text7_1_loc8  FROM locales_npc_text
2008-09-22 15:46:12 ERROR:query ERROR: Unknown column 'Text0_0_loc8' in 'field list'

2008-09-22 15:46:12 

2008-09-22 15:46:12 >> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty.
2008-09-22 15:46:12 ERROR:SQL: SELECT entry,text_loc1,text_loc2,text_loc3,text_loc4,text_loc5,text_loc6,text_loc7,text_loc8 FROM locales_page_text
2008-09-22 15:46:12 ERROR:query ERROR: Unknown column 'text_loc8' in 'field list'
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.
2008-09-22 15:46:12 Loading Page Texts...
2008-09-22 15:46:12 >> Loaded 1389 page texts
2008-09-22 15:46:12 
2008-09-22 15:46:12 Loading Game Object Templates...
2008-09-22 15:46:12 >> Loaded 13617 game object templates
2008-09-22 15:46:12 
2008-09-22 15:46:12 Loading Spell Chain Data...
2008-09-22 15:46:12 ERROR:SQL: SELECT spell_id, prev_spell, first_spell, rank, req_spell FROM spell_chain
2008-09-22 15:46:12 ERROR:query ERROR: Unknown column 'req_spell' in 'field list'
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 0 spell chain records
2008-09-22 15:46:12 ERROR:`spell_chains` table is empty!
2008-09-22 15:46:12 Loading Spell Elixir types...
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 98 spell elixir definitions
2008-09-22 15:46:12 Loading Spell Learn Skills...
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 78 Spell Learn Skills from DBC
2008-09-22 15:46:12 Loading Spell Learn Spells...
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 14 spell learn spells + 500 found in DBC
2008-09-22 15:46:12 Loading Spell Proc Event conditions...
2008-09-22 15:46:12 ERROR:SQL: SELECT entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown FROM spell_proc_event
2008-09-22 15:46:12 ERROR:query ERROR: Unknown column 'cooldown' in 'field list'
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 0 spell proc event conditions
2008-09-22 15:46:12 Loading Aggro Spells Definitions...
2008-09-22 15:46:12 >> Loaded 89 aggro generating spells
2008-09-22 15:46:12 
2008-09-22 15:46:12 Loading NPC Texts...
2008-09-22 15:46:12 
2008-09-22 15:46:12 >> Loaded 4357 npc texts
2008-09-22 15:46:12 Loading Item Random Enchantments Table...
2008-09-22 15:46:13 
2008-09-22 15:46:13 >> Loaded 28408 Item Enchantment definitions
2008-09-22 15:46:13 Loading Items...
2008-09-22 15:46:15 >> Loaded 23753 item prototypes
2008-09-22 15:46:15 
2008-09-22 15:46:15 ERROR:Item (Entry: 8498) not correct 20655 display id, must be 44666 (using it).
2008-09-22 15:46:15 ERROR:Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
2008-09-22 15:46:15 ERROR:Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
2008-09-22 15:46:15 ERROR:Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
2008-09-22 15:46:15 ERROR:Item (Entry: 33808) not correct 47014 display id, must be 51920 (using it).
2008-09-22 15:46:15 ERROR:Item (Entry: 33868) not correct 47131 display id, must be 51758 (using it).
2008-09-22 15:46:15 ERROR:Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
2008-09-22 15:46:15 Loading Item Texts...
2008-09-22 15:46:15 
2008-09-22 15:46:15 >> Loaded 0 item pages
2008-09-22 15:46:15 Loading Creature Model Based Info Data...
2008-09-22 15:46:15 >> Loaded 16891 creature model based info
2008-09-22 15:46:15 
2008-09-22 15:46:15 Loading Equipment templates...
2008-09-22 15:46:15 >> Loaded 1849 equipment template
2008-09-22 15:46:15 
2008-09-22 15:46:15 Loading Creature templates...
[COLOR="Red"]2008-09-22 15:46:15 ERROR:Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql).[/COLOR]

 

[Delluseonist]

Re: [Mangos] How to make a Mangos server

Hi im using the following UDB and core version can anyone tell me what client version I should use?

UDB_0.9.2_Core_5242_SD2_259.rar
MaNGOS_5242_ScriptDev2_259_SSE.rar

 

[katmiaugo]

Re: [Mangos] How to make a Mangos server

please help as it was entering the Bugue pvp 2 v 2, not the map appear to still carries the characters that trigger the pvp

above all, waiting for an answer very good server.

 

[NovaGamer]

Re: [Mangos] How to make a Mangos server

Hey, i am trying to follow your guide til i found out i don't have any conf files

i downloaded the top Mangosd core file so well yeah xD

where the hell are they XD

*EDIT*
i just downloaded some repack now i have them..

but now it keeps saying, "using password yes"
and that i can't connect..

but i don't use a password, and if i want to use a password i can't open my database >.<
help please

 

[Delluseonist]

Re: [Mangos] How to make a Mangos server

Hey, i am trying to follow your guide til i found out i don't have any conf files

i downloaded the top Mangosd core file so well yeah xD

where the hell are they XD

*EDIT*
i just downloaded some repack now i have them..

but now it keeps saying, "using password yes"
and that i can't connect..

but i don't use a password, and if i want to use a password i can't open my database >.<
help please

I had this prob too dude, basically I dont know how to fix it without putting a pass on your mysql server, just go to start > programs > mysql > instance config wizard and reconfigure your msql so that you have a password. Just put it as root or somthing. It will work if you use a password on your mysql.

Hope that helped, can anyone help me with my question I posted like two posts back? >_<

 

[dagamerc13]

Re: [Mangos] How to make a Mangos server

yes scriptdev2 database loads the same way any other one does. didn't think i had to state that but apparently i do.

it is recommended to use a password as i forget how to not use one.

please help as it was entering the Bugue pvp 2 v 2, not the map appear to still carries the characters that trigger the pvp

above all, waiting for an answer very good server.

what?!?

 

[katmiaugo]

Re: [Mangos] How to make a Mangos server

In the files of this server is not working properly PVP arena, there is someone who has a solution for this problem

 

[NovaGamer]

Re: [Mangos] How to make a Mangos server

how can i update 2.0.0 to 2.2.3???

 

[katmiaugo]

Re: [Mangos] How to make a Mangos server

Hi.

very good records without suspended for 48 hours but still does not transport us to the area of pvp these are the catches during the game

and

Here are the catches made to activate them. any way to fix it

 

[Rickpwns]

Re: [Mangos] How to make a Mangos server

let me try

 

[bearzin]

Re: [Mangos] How to make a Mangos server

Is it possible to import a .conf file from any other mangos rev to run any of these server files?

 

[Innovative]

Re: [Mangos] How to make a Mangos server

Sorry, but where is this mangosd.conf? ._.

 

[dagamerc13]

Re: [Mangos] How to make a Mangos server

the pvp arena i am not sure about because i haven't really looked into it for a long time. just helped you guys with tech support. i would say to try doing a search on that part.

as for conf files. the conf file should be located inside your mangos folder,

yes you can import your old conf file from older versions of mangos. or at least usually, in some rare cases you may not be able to.

 

[Twister1002]

Re: [Mangos] How to make a Mangos server

Ummm, Lol, All the files for the server isnt in the folder or a RAR to download. . I'm making my first server in WoW but techanlly my 4th server overall. Ummm, Where else is there another guide with all the downloads?

 

[ASGGVT]

Re: [Mangos] How to make a Mangos server

Hello I've followed this tutorial correctly 100% I believe. I'm stuck at the login screen with connecting when typing in the user admin with pass admin.

I've set my realmlist in mysql with navicat to my external ip.
Mangos reads my databases.
my mangosd.CONF file has this;

LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;characters"

I have forwarded ports 8085, 80, 3724 and 2 others I believe.

I've go into the realmlist through navicat and changed the name from mangos to alexstrasza.
I then changed the 127.0.0.1 ip to my external IP.
And lastly I've go into my realmlist.WTF in WoW directory and put

set realmlist 64.90.70.161
set patchlist us.version.worldofwarcraft.com
set portal us.

EDIT: Oh and I went into windows/system32/drivers/etc/ opened HOSTS.FILE and put the following.

# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

127.0.0.1 64.90.70.161 <- my external ip
127.0.0.1 192.168.2.10 <- my lan ip