Forrest's Idiot-proof Guide to Setting Up Your Own MangoS Server

[gottmos]

Hi I cant create an account at all! I just got an error!

User bob whit password "password" created successfully
Mangos>SQL: INSERT INTO account<username,sha_pass_hash,joindate> VALUES<´bob´,SHA1<CONCAT<UPPER<´bob´>;:´,UPPER<´bob´>>>,NOW<>>
SQL ERROR: Unkown column ´sha_pass_hash´ in ´field list´


Pls help me thank you

[Hicara]

Im sorry to say forest. But ive tried to make an account, but it just get stucked at Handsaking. ;/

What can i do then?

[andrewrebe]

can anyone pls upload on other site Forrest's All-in-one Pack.rar because i can't download ... pls

[Hicara]

Here ya go

I had the problem too.
so i uploade it to rapidshare for everyone els

RapidShare: 1-Click Webhosting

[Forrest]

Hello everybody!

my realmd.exe works but when i startup mangosd.exe it gives this error:

2008-03-30 16:47:47 Using configuration file mangosd.conf.
2008-03-30 16:47:47 MaNGOS daemon /0.10.0-SVN (Revision 5499) (Win32)
2008-03-30 16:47:47 <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-03-30 16:47:47 World Database: 127.0.0.1;3306;root;root;mangos
2008-03-30 16:47:47 MySQL client library: 5.0.45
2008-03-30 16:47:47 MySQL server ver: 5.0.45-community-nt 
2008-03-30 16:47:47 Character Database: 127.0.0.1;3306;root;root;characters
2008-03-30 16:47:47 MySQL client library: 5.0.45
2008-03-30 16:47:47 MySQL server ver: 5.0.45-community-nt 
2008-03-30 16:47:47 Login Database: 127.0.0.1;3306;root;root;realmd
2008-03-30 16:47:47 MySQL client library: 5.0.45
2008-03-30 16:47:47 MySQL server ver: 5.0.45-community-nt 
2008-03-30 16:47:47 Realm running as realm ID 1
2008-03-30 16:47:47 Using UDB 0.9.2 (343) with SD2 calls rev.293
2008-03-30 16:47:47 Using DataDir D:MaNGOS/
2008-03-30 16:47:47 WORLD: VMap support included. LineOfSight:1, getHeight:1
2008-03-30 16:47:47 WORLD: VMap data directory is: D:MaNGOS/vmaps
2008-03-30 16:47:47 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-03-30 16:47:47 ERROR:Could not find vmap file 'D:MaNGOS/vmaps/001_33_39.vmdir'
2008-03-30 16:47:47 ERROR:Correct *.map files not found in path 'D:MaNGOS/maps' or *.vmap/*vmdir files in 'D:MaNGOS/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.

The first error isnt the problem i think because the file is there, so it should be the second error. Can u plz help me?

Grtz, Dancol

Dancol, its probably a bad vmaps extraction, when extracting vmaps, try using "make vmaps.bat" instead of "makevmaps_SIMPLE.bat". OR alternatively, open mangosd.conf and change the following lines such that:

vmap.enableLOS = 0
vmap.enableHeight = 0

Hope this helps.

[Forrest]

Hi I cant create an account at all! I just got an error!

User bob whit password "password" created successfully
Mangos>SQL: INSERT INTO account<username,sha_pass_hash,joindate> VALUES<´bob´,SHA1<CONCAT<UPPER<´bob´>;:´,UPPER<´bob´>>>,NOW<>>
SQL ERROR: Unkown column ´sha_pass_hash´ in ´field list´


Pls help me thank you

Gottmos, I would suggest that you not use "password" as a password. And to empty your realmd datbase, then restore it again with realmd.sql and the changesets. It should work.

[Forrest]

Im sorry to say forest. But ive tried to make an account, but it just get stucked at Handsaking. ;/

What can i do then?

Hicara, thanks for uploading my pack again. It'll probably help alot of people. Would you mind if I used it in my guide as well? Btw, this problem that you have at handshaking is probably either a connection error OR a natural Mangos occurence.

Connection error
1. Start->Run->cmd.exe->OK
2. ping 127.0.0.1
3. If succesful ping, then:
Did you set specify 127.0.0.1 at all the correct places?

realmd database -> realmlist changeset -> address field

realmd.conf

LoginDatabaseInfo = "127.0.0.1;3306;root;<your password here>;realmd"

mangosd.conf

LoginDatabaseInfo     = "127.0.0.1;3306;root;<your password here>;realmd"
WorldDatabaseInfo     = "127.0.0.1;3306;root;<your password here>;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;<your password here>;characters"

scriptdev2.conf

ScriptDev2DatabaseInfo     = "127.0.0.1;3306;mangos;<your password here>;scriptdev2"

4. If unsuccessful ping, then:
There is something seriously wrong about your network card, consider changing it.

Natural Mangos Occurence

This hasn't happened ever since rev. 3000+ of mangos and I won't expect it to happen unless there are 50 and above people in your server, hence there will be lags and you can't connect, however, seeing that you are only 1 person inside(am I right?), I would ask you to cancel, try again, cancel, try again until it works. If things come to a point where you really can't solve it, add me on MSN, my address is in my guide.

[Hicara]

Hicara, thanks for uploading my pack again. It'll probably help alot of people. Would you mind if I used it in my guide as well?

Indeed you can

Connection error
1. Start->Run->cmd.exe->OK
2. ping 127.0.0.1
3. If succesful ping, then:
Did you set specify 127.0.0.1 at all the correct places?

Well, if i can login and play with the default accounts that are made, how can it be anything at the connection then?
But ill check it anyway just to see if i missed somewhere

[wow.souza]

Very good, congratulations for the good work!
How do I update MaNGOS?
How do I update the database?:nervous:
You recommends make those upgrades?
I am totally new on project Mangos, however have found these links on the new updates:
MaNGOS Revision 5530 + ScriptDev2 Revision 310
mangos-fae.info/download.php?view.71
UDB 0.9.2 updatepack 344 MaNGOS 5470 ScriptDev2 297
mangos-fae.info/download.php?view.62
Forrest, with your experience, what you would in my case?:wave:
Mount yesterday the project, that's exactly like this "How to".
+Rep

[arno000]

Nice copy paste guy.

mangosproject.org/forum/index.php?showtopic=12126

[Forrest]

Nice copy paste guy.

mangosproject.org/forum/index.php?showtopic=12126

Hi genius, in case you haven't noticed, I gave credits at the start of my guide. At least I was kind enough to simplify and explain their guides in more detail so that newbs would be able to understand better.

Credits
ALL server related guide content within is credited to z-vap, Spuddlethud, elegos87 from Mangos Community Forums. ALL ScriptDev2 related guide content within is credited to Ntsc from ScriptDev2 Community Forums.

[Forrest]

Very good, congratulations for the good work!
How do I update MaNGOS?
How do I update the database?:nervous:
You recommends make those upgrades?
I am totally new on project Mangos, however have found these links on the new updates:
MaNGOS Revision 5530 + ScriptDev2 Revision 310
mangos-fae.info/download.php?view.71
UDB 0.9.2 updatepack 344 MaNGOS 5470 ScriptDev2 297
mangos-fae.info/download.php?view.62
Forrest, with your experience, what you would in my case?:wave:
Mount yesterday the project, that's exactly like this "How to".
+Rep

Hi wow.souza, I DON'T intend to make a second release until Mangos supports ver 2.4.0. Hence, by all means, download the latest versions of mangos and UDB and scriptdev. My guide here used to explain everything about how to update blah blah blah but alot of pple didn't understand. U can always check out the UDB, Mangos and ScriptDev forums for their guides. Rgds.

Board Message
UDB community forums (Powered by Invision Power Board)
ScriptDev2 - Index

[Hicara]

Hey Forrest.
So could you plz help me?

[shady_devil]

all things good for me, great guide forest !!
+Rep from me


....

oh yeah..i do have a problem...I HAVE NO MOBS. NO NPC , NO NOTHING (i wonder if i have a spirit healer , but i doubt it) ..help someone ?

[Hicara]

Try restore your Database sql again. That might help, not sure tho.