[One] DB setup

[Alorain]

Hello.

I'm trying to get up and running with Mangos One (TBC). For the most part, I'm comfortable with the setup thus far, but when it comes to updating the databases, I am a bit confused. I've read the documentation about how to check what to upgrade, but I am confused with the tons of files that are in the mangos/sql/updates/ folder. It seems there's two or more styles of file labeling.

Can someone give me an exact place to start with a fresh clone of mangos one? What are the 0.5->0.12 branches?

Also, how does the "Database" repository fit in with the whole project?

Thanks for any help.

[smallbus]

when i run mangosd.exe everything seems to load fine except this new pop up error. "the procedure entry point ?LoadCreatureAddon@Creature@@QAE_N_N@Z could not be located in the dynamic link library mangosd.exe

We get this error after it loads quite a bit of the other information.

[antz]

when i run mangosd.exe everything seems to load fine except this new pop up error. "the procedure entry point ?LoadCreatureAddon@Creature@@QAE_N_N@Z could not be located in the dynamic link library mangosd.exe

We get this error after it loads quite a bit of the other information.

Are you able to post any of the messages / logs ?

[tifalita]

2013-03-28 21:13:44 >>> Loaded 84 path templates with 2123 nodes and 24 behaviors

2013-03-28 21:13:44 Loading Localization strings...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 creature locale strings. DB table `locales_creature` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 Item locale strings. DB table `locales_item` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 gossip_menu_option locale strings. DB table `locales_gossip_menu_option` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 points_of_interest locale strings. DB table `locales_points_of_interest` is empty.

2013-03-28 21:13:44 >>> Localization strings loaded

2013-03-28 21:13:44

2013-03-28 21:13:44 Loading Auctions...

2013-03-28 21:13:44

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 auction items

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 auctions. DB table `auction` is empty.

2013-03-28 21:13:44 >>> Auctions loaded

2013-03-28 21:13:44

2013-03-28 21:13:44 Loading Guilds...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 guild definitions

2013-03-28 21:13:44 Loading ArenaTeams...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 arenateam definitions

2013-03-28 21:13:44 Loading Groups...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 group definitions

2013-03-28 21:13:44 Loading ReservedNames...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 reserved player names

2013-03-28 21:13:44 Loading GameObjects for quests...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 948 GameObjects for quests

2013-03-28 21:13:44 Loading BattleMasters...

2013-03-28 21:13:45

2013-03-28 21:13:45 >> Loaded 71 battlemaster entries

2013-03-28 21:13:45 Loading BattleGround event indexes...

2013-03-28 21:13:45

2013-03-28 21:13:45 >> Loaded 1236 battleground eventindexes

2013-03-28 21:13:45 Loading GameTeleports...

2013-03-28 21:13:45

2013-03-28 21:13:45 >> Loaded 421 GameTeleports

2013-03-28 21:13:45 Loading GM tickets...

2013-03-28 21:13:45

2013-03-28 21:13:45 >> Loaded `character_ticket`, table is empty.

2013-03-28 21:13:45 Returning old mails...

2013-03-28 21:13:45

2013-03-28 21:13:45 >> Only expired mails (need to be return or delete) or DB table `mail` is empty.

2013-03-28 21:13:45 Loading Scripts...

2013-03-28 21:13:45

2013-03-28 21:13:45 dbscripts_on_quest_start :

2013-03-28 21:13:45

2013-03-28 21:13:45 >> Loaded 231 script definitions

2013-03-28 21:13:45 dbscripts_on_quest_end :

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 293 script definitions

2013-03-28 21:13:46 dbscripts_on_spell :

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 10 script definitions

2013-03-28 21:13:46 dbscripts_on_go_use :

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 54 script definitions

2013-03-28 21:13:46 dbscripts_on_go_template_use :

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 18 script definitions

2013-03-28 21:13:46 dbscripts_on_event :

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 484 script definitions

2013-03-28 21:13:46 dbscripts_on_creature_death :

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 0 script definitions

2013-03-28 21:13:46 >>> Scripts loaded

2013-03-28 21:13:46

2013-03-28 21:13:46 Loading Scripts text locales...

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 436 string templates from db_script_string

2013-03-28 21:13:46 Loading CreatureEventAI Texts...

2013-03-28 21:13:47

2013-03-28 21:13:47 >> Loaded 975 string templates from creature_ai_texts

2013-03-28 21:13:47 Loading EventAI Texts additional data...

2013-03-28 21:13:47

2013-03-28 21:13:47 >> Loaded 975 additional CreatureEventAI Texts data.

2013-03-28 21:13:47 Loading CreatureEventAI Summons...

2013-03-28 21:13:47

2013-03-28 21:13:47 >> Loaded 21 CreatureEventAI summon definitions

2013-03-28 21:13:47 Loading CreatureEventAI Scripts...

2013-03-28 21:13:48

2013-03-28 21:13:48 >> Loaded 20174 CreatureEventAI scripts

2013-03-28 21:13:48 Initializing Scripts...

2013-03-28 21:13:59 ERROR:Scripting library not found or not accessible.

2013-03-28 21:13:59 DEBUG:: Initialize game time and timers

2013-03-28 21:14:00 Starting Map System

2013-03-28 21:14:00 Starting BattleGround System

2013-03-28 21:14:00

2013-03-28 21:14:00 >> Loaded 8 battlegrounds

2013-03-28 21:14:00 Starting Outdoor PvP System

2013-03-28 21:14:00

2013-03-28 21:14:00 >> Loaded 6 Outdoor PvP zones

2013-03-28 21:14:00 Loading Transports...

2013-03-28 21:14:00

2013-03-28 21:14:00 >> Loaded 9 transports

2013-03-28 21:14:00 Deleting expired bans...

2013-03-28 21:14:00 Calculate next daily quest reset time...

2013-03-28 21:14:00 Starting Game Event system...

2013-03-28 21:14:00 GameEvent 16 "Gurubashi Arena Booty Run" started.

2013-03-28 21:14:00 GameEvent 21 "Call to Arms: Eye of the Storm!" started.

2013-03-28 21:14:00 GameEvent 31 "Edge of Madness, Renataki" started.

2013-03-28 21:14:00 GameEvent 47 "Brew of the Month - March" started.

2013-03-28 21:14:00 GameEvent 62 "Darkmoon Faire (Mulgore) - Building Stage 1" started.

2013-03-28 21:14:00 Player::DeleteOldChars: Deleting all characters which have been deleted 30 days before...

2013-03-28 21:14:00 Initialize AuctionHouseBot...

2013-03-28 21:14:00 AHBOT is Disabled. Unable to open configuration file(ahbot.conf).

2013-03-28 21:14:00 WORLD: World initialized

2013-03-28 21:14:00 SERVER STARTUP TIME: 1 minutes 2 seconds

2013-03-28 21:14:00 mangosd process priority class set to HIGH

2013-03-28 21:14:00

2013-03-28 21:14:00

[tifalita]

i posted the concerning areas. should those be 0? and the error happens near the bottom loading scripts

[tifalita]

also when i try to build scriptdev2 project in visual studio 2012 i get "error MSB6006: "cmd.exe" exited with code 3

[tifalita]

also the title of this thread says ZERO, but this is for a ONE build. just incase thats what this means.

[Christian Schamara]

clone the core https://github.com/mangosone/server clone scripts https://github.com/mangosone/scripts clone database https://github.com/mangosone/database

move scripts folder in core folder under src/bindings

go in core folder win and open VC110.sln

set up to release mode push F7 and run

when done go to src/bindings/scripts and open VC110.sln change mode to release and run

when this done open database folder and navigate under _tools folder

click on make_full_db.bat (this create the full_db)

batch full with navicat or sqlyog than batch realmd and character + scripts database from core folder sql and core folder src/bindings/scripts/sql

setiing the config files and run the server

done

[tifalita]

ty ill give it a try

[tifalita]

ok i dont fully understand this part

move scripts folder in core folder under src/bindings

go in core folder win and open VC110.sln

set up to release mode push F7 and run

im using visual studio 2012. should i be using a different tool?

pushing f7 does nothing.

edit: im not getting the popup error anymore, but my scripts still are not loading.

log says, scripting library not found or not accessible.

edit2: also

"when done go to src/bindings/scripts and open VC110.sln change mode to release and run:

i goto src/bindings and there is no "scripts"folder there is a universal folder. But there is no sln to run

[Christian Schamara]

you must clone the scripts repo git clone git://github.com/mangosone/scripts.git

than you have a folder "name = scripts" this folder you move to src/bindings

[tifalita]

when i try to build the release version of scriptdev2 i get "error msb6006: "cmd.exe" exited with code 3

[tifalita]

i can build the debug, but not the release...

and all the sudden it works... but now what do i do with all these .obj files?

[Christian Schamara]

when i try to build the release version of scriptdev2 i get "error msb6006: "cmd.exe" exited with code 3

you must first build the core in release than you can scripts in release too

[tifalita]

OMG im a tard!!! I do believe it worked!!!! omg ty!!!

[antz]

i can build the debug, but not the release...

and all the sudden it works... but now what do i do with all these .obj files?

obj files can be deleted... if the compile finished succesfully, then the DLL is copied into the server/bin folder (on windows)

[tifalita]

Its working beautifully ty all very much for your assistance. how do i stay up to date? is there a place i goto to see when patches and updates are released?

[Chunjee]

I'm having setup issues with MaNGOS-One as well.

As I understand it, The Database repo has many annoying separate .sql files you need to import into the mangos/world database.

I don't understand the update folder but there is a complicated README in there.

I had a problem with vmaps being assembled incorrectly. I finally figured that out and they seem ok now. My problem is that MaNGOS crashes on character creation (image). It seems to be creating the character but nothing appears in the SQL database. I don't think there is a permissions issue (using same user/pass for working trinitycore install that I am trying to replace) so I don't understand what the problem is. My only idea is that something of the initial items/spells of each class is incorrect in the mangos database. Is it possible someone could just post a SQL dump of a clean or updated MaNGOs-One install?

[X-Savior_]

You can also go to UDB FOrum and look at TBC-DB. The DB in the Mangos Repo IS TBC-DB but they break it down and put into individual tables and ect.

Go to Here: http://udb.no-ip.org/index.php/topic,12422.0.html

This is my installation instructions to get up and going with Mangos One and TBC-DB. If you have any questions just ask and I will try and help you through it.

I still need to talk with Mangos Dev's to come up with a better unified way of doing the database.

IN about 3 weeks I will be starting work again on TBC-DB as well and have some new fixes and content already done for it.

[Alorain]

Thanks for replying.

A couple questions regarding your instructions:

1) Your TBC-DB applies only to the actual "mangos" database, right? "Characters" "realmdb" and "scriptdev2" still have to be updated with the updates contained from the mangos-one repo (sql files in the mangos/sql/updates/), right?

2) Is ACID in TBC 1.2.0 FULL_DB?

[X-Savior_]

Yes, I guess my instructions could get a little more detailed. I will update the post on the forum tonight for more detail.

What you need to do is:

1) apply is the 1.2.0 Full DB to your MANGOS db

2) apply the 1.2.1 Core Patch Rollup to your MANGOS db

3) apply the 1.2.1 Update Pack to your MANGOS db and then apply any additional core updates that were released since last TBC-DB update int he Mangos One Repo

4) (if starting fresh realm) Apply the Characters.sql from Mangos One Repo to your CHARACTERS db

5) Apply your realmdb (cant remember exact SQL name) SQL from Mangos One Repo to your realm db

6) For SD2 portion refer to their instructions (You apply template to scriptdev 2 db and then the scriptdev2 data and then there is another file you apply to mangos db as well

7) for ACID apply the latest Mangos One ACID (2.0,6D I think is most up to date but 2.0.7 will be release VERY soon).

now you are pretty much setup, get your config files done up and edit your realm db for proper config.

Hope this helps (This is standard instructions for all Mangos Core)

[Chunjee]

Thanks for the extra instructions, but I'm confused what a "Core Patch Rollup" is and where to find version 1.2.1

7 ) ... then go to the Updates folder and apply the Core Patch rollup and then Update packs for Each Release Version (In That Order)

I'm assuming the updates folder is ~\\server\\sql\\updates of mangos-one database repo. But there is no file with a name like 'rollup'. Are we talking about every single file with mangos in it? example: s1540_11955_02_mangos_command.sql

I'm also confused if "Update packs" are the folders with dozens of .sql files. That will honestly take me all day. Is there some SQL software that can automate importing an entire folder?

Should I know about the point of 0.12 and 0.12_branch in the updates folder?

[Alorain]

Thanks X-Savior. My DB is golden now.

Chunjee -

The Core sets the structure of the database. The updates populate the database. So always apply a core patch, then an update patch.

Click on the magnos DB. Open the tables folder scroll to db_version. Click that and see the table data.

The first column should be "version", the second column "creature_ai_version", last column should be "required_SXXXX_#####_$$_mangos_something".

Whatever XXXX is, is the rev number you are currently at. You need to update with everything AFTER XXXX. And yes, it is a pain.

I think it would be great for mangos newcomers to just have an up-to-date DB ready to plug and play. That said, I realize it's a free project and someone would have to take the time to set that up.

But it really would remove a large hurdle to getting started.

[Chunjee]

Ok well I started with the updates from s1399 all the way up to s1592 one by one. Backup the database so I can try launching MaNGOS with that but still crash at character creation. So I revert to the backup and start on the updates. 0.12_branch start at 001 so I assume I don't need that. 1592 is higher. 0.12 folder starts at 2008, so I start doing those but quickly run into SQLyog spitting errors at me.

Am I doing something wrong? Can I just get a copy of your database Alorain? I'll offer FTP access if you have nowhere to upload it.

My trinitycore world DB is 52MB. As soon as I figure out this exercise I'm going to post it as a single file.

[X-Savior_]

Are you looking at the TBC-DB Repo for your Database files?

(NOT The Mangos GIT Database Section)

http://udb.no-ip.org/index.php/topic,12857.0.html

So what you do is apply the 1.2.0 Full release (What full release is, is a complete DB package). Then in the TBC-DB repo you will see a folder called updates and it hold the 1.2.1 update pack and core rollup package.

What a core rollup package has in it is ALL of the require Core Updates in sequential order to take your full release to the next required core stepping.

So as you see here:

https://tbc-db.svn.sourceforge.net/svnroot/tbc-db/

in 1.2.0 you will see "Full DB" and "Updates". You always start with the full db and then apply the update packs as required after.

1) Apply https://tbc-db.svn.sourceforge.net/svnroot/tbc-db/1.2.0/Full_DB/ to your Mangos DB. As you see in the file name:

TBCDB_1.2.0_mangos-one_s1409_SD2_2319.rar

This is Release 1.2.0 for Core Version s1409 and includes SD2 2319 in the Mangos DB.

So now we will look at update folder:

https://tbc-db.svn.sourceforge.net/svnroot/tbc-db/1.2.0/Updates/

right now we have 2 files:

1.2.1_corepatch_mangos_1410_to_1434.sql

1.2.1_updatepack.sql

So what you need to do is bring your core version up from 1409 (That is what last full version was from 1.2.0) to the new required version for the update pack (1434). So instead of applying all the individual files from mangos core repo you can just execute the single file located here that will bring the Mangos Db up from 1410 -> 1434 in a single step.

Now you are able to apply the update pack to the correct core version. Apply the 1.2.1 update pack to your mangos DB.

Now only thing to do left is apply your SD2 files if you compiled a newer SD2 then version 2319.

I can understand from a new person this is extremely confusing (I been there).

I suggest if you are still have problems come on to IRC and ask people for help so they can talk you through it step by step. There is MANY basic tutorials on UDB/TBC-DB/Mangos Forums outline this process as it is same process (just different files) for updating and setting up for all cores.

[shlainn]

Wow, what a wall of text. Let me present an alternative (The MaNGOS One Git Database):

1) Get the database from git (same procedure as getting mangos source, just different repo: https://github.com/mangos-one/database.git)

2) Right-click the folder you just dumped the DB into and select "Git Bash here..." (same as for extracting MoveMaps)

3) In the console type ./make_full_db.sh - This creates a file called full_db.sql

4) Apply this file to your database.

You are done.