Ummm, so what next?

[Jorvalt]

So I just read the post on how to set up a ManGOS server, and it just ends at the "Extracting Maps, Vmaps and Mmaps" part. What do I do next? I have another question as well. How can I make it so other people can play on my server?

[Jorvalt]

Okay and also I just read that at the beginning it says "This is assuming you have set up a database and user accounts for it." How do I do that?

[madmax]

Okay and also I just read that at the beginning it says "This is assuming you have set up a database and user accounts for it." How do I do that?

There is another here - https://github.com/mangoswiki/Wiki/wiki/WindowsInstallVM

[Jorvalt]

There is another here - https://github.com/mangoswiki/Wiki/wiki/WindowsInstallVM

Um, is this really necessary if I just need a server I can host off my own computer for me and a few friends to play on? It seems really long and complicated and requires a bunch of stuff I don't have.

[madmax]

Um, is this really necessary if I just need a server I can host off my own computer for me and a few friends to play on? It seems really long and complicated and requires a bunch of stuff I don't have.

You might find a guide over here - http://community.getmangos.eu/index.php?board=17.0

You are always welcome to play over on www.covenant-wow.com

[madmax]

I'm off to bed. Just keep an eye on the topic date if you plan on using an old guide.

I'm sure there will be another dev along tomorrow morning who might have a better guide for you. Well good night

[Jorvalt]

You might find a guide over here - http://community.getmangos.eu/index.php?board=17.0

You are always welcome to play over on www.covenant-wow.com

I'll give that server a try, although it looks like pretty much nobody is playing on it and I prefer being able to have gm commands and just mess about.

[Ghurok]

Posting from my laptop where I don't have access to my usual MaNGOS stuff. My CPU fan on my main computer started making strange noises.

It seems like you have compiled the server, right? Did you compile the scripts as well?

Do you have MySQL installed on your computer or know how to use it?

Just need some information before I can help you.

... Actually I just found the guide I was looking for http://community.getmangos.eu/index.php?topic=19787.msg154834

For the database you will need...

http://www.mysql.com/ - database software

http://www.heidisql.com/ - front-end for MySQL

[Jorvalt]

Posting from my laptop where I don't have access to my usual MaNGOS stuff. My CPU fan on my main computer started making strange noises.

It seems like you have compiled the server, right? Did you compile the scripts as well?

Do you have MySQL installed on your computer or know how to use it?

Just need some information before I can help you.

... Actually I just found the guide I was looking for http://community.getmangos.eu/index.php?topic=19787.msg154834

Yeah, that's the thing I was talking about where it just ended at extracting maps, mmaps, and vmaps. Is that really all you have to do?

[Jorvalt]

Okay well I haven't done your tutorial yet but I'm on the part where I need to open mangosdVC110.sln with visual studio express 2012, and there's no build button at the top. I tried setting it to expert settings, but still nothing.

[Ghurok]

Yeah, that's the thing I was talking about where it just ended at extracting maps, mmaps, and vmaps. Is that really all you have to do?

I see. I thought you were referring to another guide that's on GitHub because that one only has the headline "Extracting maps, mmaps and vmaps" and then nothing beneath.

You need to set up the databases. You will need http://www.mysql.com/ (database software) and http://www.heidisql.com/ (MySQL editor/front-end). Set that up. These programs don't really have anything to do with MaNGOS so you should look up tutorial elsewhere on how to use them.

After you've done that you should check out the tools in database/_tools. I haven't tried out "MaNGOSdb_Installer.bat" myself yet but you should. This will hopefully set up the world database where game content is stored.

Two databases left. Realm and characters. Now what I do is perhaps not the most practical way of doing it. First of all create a database called "zp_realmd" using HeidiSQL. Go into server/sql and import realmd.sql. Drag it to the query window and run basically. Create a new database called "zp_characters". Go into server/sql and import characters.sql.

You might need to change the "address" column inside zp_realmd.realmlist to your internal IP.

Make sure all of your configuration files are set up with the correct database names, mysql username and password etc.

I apologize for the half-assed explanation. It's not supposed to be a complete, perfect guide for you. You'll have to fill in some blanks and hopefully figure it out. As I said I'm on my laptop. I don't have my usual stuff on it. On top of that I'm in my bed typing at an annoying angle.

[Ghurok]

Okay well I haven't done your tutorial yet but I'm on the part where I need to open mangosdVC110.sln with visual studio express 2012, and there's no build button at the top. I tried setting it to expert settings, but still nothing.

Right-click the Solution to your right. Click build.

[madmax]

Okay well I haven't done your tutorial yet but I'm on the part where I need to open mangosdVC110.sln with visual studio express 2012, and there's no build button at the top. I tried setting it to expert settings, but still nothing.

Just seen the server disconnected message you wrote over on covenant.

You need to click cancel or change realm and select the right one for the expansion. Currently the realm daemon assigns the wrong random realm.

[Jorvalt]

Just seen the server disconnected message you wrote over on covenant.

You need to click cancel or change realm and select the right one for the expansion. Currently the realm daemon assigns the wrong random realm.

Right, I had figured that out a few minutes ago. Anyways, back to my problem.

Edit: Found out what the problem was, you're supposed to get Microsoft Visual Studio Express 2012 for Windows Desktop, the web version doesn't have C++.

[Jorvalt]

OK so I think the map building finished. Does it close when it's finished? Because when I checked my computer it wasn't there. Anyways what do I do next?

[Jorvalt]

I really wish the wiki actually had a full tutorial on how to set up a mangoszero private server. It just has instructions on how to install the programs you need for it and nothing else. Apparently I need the databse, but what do I do with it?

[TheLuda]

https://github.com/mangoszero/database is the database you need.

You need to import the realmd database, and the characters database from the mangos source, then you need to import the linked database which is for mangosd, and finally, from https://github.com/mangoszero/scripts (the script library) there is a fourth database with content used by scripts.

That is what you need. Importing SQL files into a MySQL database is documented on millions of sites, ask google for it, and if you have trouble during the import, you can of course ask us.

[Jorvalt]

https://github.com/mangoszero/database is the database you need.

You need to import the realmd database, and the characters database from the mangos source, then you need to import the linked database which is for mangosd, and finally, from https://github.com/mangoszero/scripts (the script library) there is a fourth database with content used by scripts.

That is what you need. Importing SQL files into a MySQL database is documented on millions of sites, ask google for it, and if you have trouble during the import, you can of course ask us.

But none of those are actually in the database that I downloaded from git, so is it really necessary to download it? What do I do with it? Also where is the characters database? I could find all the other ones but not that one.

Also do I put these all in seperate databases on the MySQL server?

[madmax]

Hey,

For characters you import this - server\sql\characters.sql

For realmd - server\sql\realmd.sql

They go into separate databases yes. If you encounter a message about missing SQL updates look in the server\sql\updates folder for the latest.

[Jorvalt]

Ok well I messed up somehow. So I was using the MySQL server and I guess I deleted something I wasn't supposed to delete and the whole thing stopped working. So I uninstalled it and then reinstalled it. But now the server won't work at all. It just won't start. Any ideas?

Edit: fixed this problem.

Also another question: what's the linked database? Is that the mangos.sql? Or is it that full_db file I made with the batch file in database?

Also the script one is scriptdev2_script_full.sql right?

[Jorvalt]

Well I finally put everything in, and of course it won't start. You're supposed to put those sql files in queries for each database, right? Well, I did just that, and I tried running mangosd.exe and realmd.exe and of course neither of them started. Command prompt comes up for half a second and then closes, so I have no idea what it says.

[madmax]

No idea what linked database means?

In the _tools directory as you said you have the make_full_db run that and import the full_db.sql to the mangos database

mangos_scriptname_full.sql and scriptdev2_script_full should go into the scriptdev2 database

Over on covenant wow we have the script tables in the mangos database.

This post I made has more information on databases I just found - http://community.getmangos.eu/index.php?topic=19305.msg153635#msg153635

[Jorvalt]

No idea what linked database means?

In the _tools directory as you said you have the make_full_db run that and import the full_db.sql to the mangos database

mangos_scriptname_full.sql and scriptdev2_script_full should go into the scriptdev2 database

Over on covenant wow we have the script tables in the mangos database.

This post I made has more information on databases I just found - http://community.getmangos.eu/index.php?topic=19305.msg153635#msg153635

Uh, yeah... I import Scriptdev2_script_full and it's blank.

I edit it in notepad++ and everything's there, but when I import it into the query in navicat it's just blank.

[madmax]

Uh, yeah... I import Scriptdev2_script_full and it's blank.

I edit it in notepad++ and everything's there, but when I import it into the query in navicat it's just blank.

Don't suppose you have skype and teamviewer? Be simpler if I can see what's going on and set it up for you?

[Jorvalt]

when I run mangosd.exe it provides this message:

Using configuration file mangosd.conf.
OpenSSL 1.0.0d 8 Feb 2011 (Library: OpenSSL 1.0.0d 8 Feb 2011)
Using ACE: 5.8.3
World Database total connections: 2
Connected to MySQL database [email protected]:3306/mangos
MySQL client library: 5.1.49
MySQL server ver: 5.6.13
AUTOCOMMIT SUCCESSFULLY SET TO 1
Connected to MySQL database [email protected]:3306/mangos
MySQL client library: 5.1.49
MySQL server ver: 5.6.13
AUTOCOMMIT SUCCESSFULLY SET TO 1
SQL: SELECT required_r2420_01_mangos_spell_linked FROM db_version LIMIT 1
query ERROR: Table 'mangos.db_version' doesn't exist
SQL: SELECT * FROM db_version LIMIT 1
query ERROR: Table 'mangos.db_version' doesn't exist
The table `db_version` in your [WORLD] database is missing or corrupt.
MaNGOS cannot find the version info needed to check that the db is up to

This revision of mangos requires a database updated to:
`r2420_01_mangos_spell_linked.sql`

Post this error to your database provider forum or find a solution there.

[Jorvalt]

Don't suppose you have skype and teamviewer? Be simpler if I can see what's going on and set it up for you?

I have skype and I could get teamviewer. Add joeare1337.