[Mangos Zero] Help completing server setup

[Rolland]

Hello,

I have just successfully completed the compilation of my 1.12.1 server with mangoszero using the tutorial by madmax, but now I am wondering where I go from here. How do I set up the database and lua scripts? I'm not sure where these things go, I have downloaded them from github, just not sure what to do with them now. Any help would be greatly appreciated. Thanks,

-J

[Rolland]

I just don't understand why is there a detailed tutorial on compiling but then nothing on what else to do.... the readme says run installdatabase.bat and thats it... doesn't say where to put it

UPDATE:

1. Compiling complete (as stated before)

2. SQL Server set up

3. Connected to SQL server with heidisql

4. Made maps, vmaps, dbc folders from extractors

5. Manually made 3 databases in heidisql, "character" "mangos" "realmd"

6. Now I am trying to populate the databases using the "InstallDatabases.bat" and I am confused as to where I place the "InstallDatabases.bat" file at to run it - Because I have tried running it in the folder I downloaded it in, I have tried running it in the server main directory, and I have I have tried running it in the WoW folder, so far none of them have worked. I am not sure if I need some other files along with it or what?? When I run the "InstallDatabases.bat" file, I enter all of the information for my sql, and then it just flashes really quick, I was able to capture a screenshot of what it says because it flashes too fast to read.

"The system cannot find the batch label specified - WorldDB1"

So I will probably need help installing lua script database too

Definately could use some help with this.

Thanks,

-J

UPDATE #2:

Now I have everything set up and am trying to start the game, realmd.exe runs just fine. However, when I run mangosd.exe it keeps crashing and I get this in my error log:

2015-10-24 04:36:46 Using configuration file mangosd.conf.

2015-10-24 04:36:46 World Database total connections: 2

2015-10-24 04:36:46 MySQL client library: 5.5.37

2015-10-24 04:36:46 MySQL server ver: 5.5.46

2015-10-24 04:36:46 MySQL client library: 5.5.37

2015-10-24 04:36:46 MySQL server ver: 5.5.46

2015-10-24 04:36:46 ERROR:SQL: SELECT required_20007_01_Rel20_Release_Prep FROM db_version LIMIT 1

2015-10-24 04:36:46 ERROR:query ERROR: Unknown column 'required_20007_01_Rel20_Release_Prep' in 'field list'

2015-10-24 04:36:46 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!

2015-10-24 04:36:46 ERROR:

2015-10-24 04:36:46 ERROR: [A] You have: --> `20007_18_Deadmines_Mr_Smite_Corrections.sql`

2015-10-24 04:36:46 ERROR:

2015-10-24 04:36:46 ERROR: You need: --> `20007_01_Rel20_Release_Prep.sql`

2015-10-24 04:36:46 ERROR:

2015-10-24 04:36:46 ERROR:You must apply all updates after [A] to to use mangos with this database.

2015-10-24 04:36:46 ERROR:These updates are included in the sql/updates folder.

2015-10-24 04:36:46 ERROR:Please read the included [README] in sql/updates for instructions on updating.

I got the server + db from here:

https://github.com/mangoszero/server

https://github.com/mangoszero/database

What is this? How can the database not be up to date when I just got all of this stuff from the mangoszero github like today...?

I don't even have an sql/updates folder.

[magic]

Hello,

Did you use the commands "git clone https://github.com/mangoszero/server -b develop21 --recursive" and "git clone https://github.com/mangoszero/database -b develop21 --recursive" to download the source?

If you didn't, follow this:

1. Right click on your desktop and left click create new folder

2. Name this folder Source

3. Right click on your desktop and left click create new folder

4. Name this folder Build

5. Open Git Shell

6. Type C:\Users\magic\Desktop\Source

7. Replace magic for your own pc username

8. Press Enter

9. In the now opened CMD window, type "git clone https://github.com/mangoszero/server -b develop21 --recursive"

10. The -b flag is used to change the branch to the branch desired, in this case develop21

11. The --recursive flag pulls the submodules, and initializes them

12. In the opened CMD window, type "git clone https://github.com/mangoszero/database -b develop21 --recursive"

All database and server files are now successfully downloaded!

[Rolland]

Thank you for your reply magic,

I am giving this a try now, i will post on how its going.

-J