MaNGOS Installation Guide, Latest SDB and Others
Simple(:roll1:) Mangos Installation Guide.
Step 1 Preparing Software and Server Files :
1. Download MySQL HERE
2. SQLyog OR Navicat you can choose one NAVICAT OR SQLyog
3. Download Latest Mangos Core HERE by Bogie, IMO its the best one
4. Download Latest Full SDB HERE by Urbin
5. Download DBC Files HERE by Urbin
6. Create Maps Pack for mangos with Ad.exe by AlexLuana or Ad.exe by bogie
7. Download WAMP OR EasyPHP, but I recommend you use WAMP
Step 2 Installing MySQL :
1. Install and Configure MySQL.
2. Select "Deatiled Configuration" choose Next.
3. Select "Developer Machine" choose Next.
4. Select "Multifunctional Database" choose Next.
5. Choose Next again.
6. Select "Decision Support (DSS)/OLAP" choose Next.
7. Leave Port Number in default "3306", choose Next.
6. Select "Standard Character Set" choose Next.
7. Choose Next again.
8. In username you better leave as default ( root ) and put your password here.
9. Click Execute, Everything should work and MySQL service will start.
If you get errors, try to repeat steps above. and if ou still get error on starting MySQL Service.
try to change Service Name, just follow the instruction and you'll be fine.
Step 3 Installing Navicat or SQLyog :
1. Navicat :
a. Install Navicat. easy Installation. you should have no problem.
b. Startup Navicat
c. Hit Connection
d. Put in localhost as the Connection name.
e. Leave IP/port alone, remember when you put the username and password on installing MySQL in Step 2? put that in username and password.
f. Right-click localhost (the name you named the connection)
g. Select New Database and name it mangos
h. Right-click on localhost.
i. Select New Database and name it realmd
2. SQLyog
a. Install SQLyog, easy Installation. you should have no problem.
b. Setup a new connection, name it localhost.
c. MySQL Host Addres should be localhost.
d. Put your username and password when you installing MySQL in Step 2.
e. leave Port to default ( 3306 ) and Default Charser to [default]. cek Save Password.
f. Now choose "Connect".
g. If you did right in installing MySQL you shoul have connection on "root@localhost". if not go back to Step 2.
h. Right click on "root@localhost" and Create Database name it mangos.
i. Right click again on "root@localhost" and Create Database name it realmd.
Step 4 Install and Configure MaNGOS :
1. Server :
a. Create New Folder on your C: drive name it mangos ( C:\mangos )
b. Extract your Mangos Server File to mangos folder.
c. open up your mangos.conf file and edit :
Quote:
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = "Your mangos server folder - C:\mangos"
# Database connection settings for the world server.
# Default: hostname;port;username;password;database
LoginDatabaseInfo = "127.0.0.1;3306;Your MySQL Username;Your MySQL Password;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;Your MySQL Username;Your MySQL Password;mangos"
d. open up your realmd.conf and edit :
Code:
# Database connection settings for the realm server.
# Default: hostname;port;username;password;database
LoginDatabaseInfo = "127.0.0.1;3306;Your MySQLUsername;Your MySQL Password;realmd"
e. Create folder maps in your wow root folder and double-click ad.exe let it run, it takes about 5 - 10 minutes.
f. Move / Copy your WoW Maps that you created with ad.exe
2. Database :
a. Extract any Full SDB, into any folder.
b. Open up your SQLyog or Navicat.
c. Right Click on mangos database, chose Execute Batch File ( if you use Navicat ). Import Batch File ( if you use SQLyog ).
d. Find mangos.sql that you extracted from and "Open" it ( if you use Navicat it will automaticaly install ). Execute ( if you use SQLyog ).
e. Right Click on realmd database, chose Execute Batch File ( if you use Navicat ). Import Batch File ( if you use SQLyog ).
f. Find realmd.sql that you extracted from and "Open" it ( if you use Navicat it will automaticaly install ). Execute ( if you use SQLyog ).
Everything should work now. and you can Start Your Server....^^, but before that you need account to play don't you ? acctualy you login
with default account such as administrator, gamemaster, moderator and player. Login ID and Password are the same.
Account Creation :
1. Install wamp let it on default folder - c:\wamp if you use wamp. wamp will only run Apache on startup, because you already have MySQL run on startup too.
2. Download Account Creation Page
Simple Account Creation
3. Extract it, put on your www folder, C:\wamp\www ( better use new folder i.e C:\wamp\www\wow\ )
4. now configure your account creation webpage, edit :
Code:
// SQL data
$db_u = "root"; // Your MySQL Username
$db_p = "MySQL Password"; // your MySQL Password
$db_host = "localhost"; // fill in only if u're not running it on the same machine as the db.
5. Each time you want make new account you can click wamp icon tray and choose localhost or by your browser
Code:
http://localhost/wow/
UPDATE MANGOS CORE AND DB :
CORE :
1. to update your core, get the latest rev. carefull sometime even latest rev. it can crash, so you better find the stable one Anyway you can get it HERE by bogie try to get that support Anticheat and MCH.
2. Extract it to any folder and copy ONLY mangosd.exe, realmd.exe, MaNGOSScript.dll, msvcr71d.dll and others .dll files.
into C:\mangos
DB:
1. you can get latest FULL SDB Release by Urbin HERE
2. For the update get it HERE by itizai.
3. Each time you want to update your DB get the latest changset and patch it with SQLyog or NAVICAT
For Example :
If you take Full SDB_0[1].5.3_Full_Changeset_30-2843.rar
for the update you just install changeset 31, changeset 32, changeset 33....until the latest one... you don't have to install Full SDB SDB_0[1].5.3_Full_Changeset_35-2856.rar. FULL SDB is use for FRESH INSTALLATION
4. IF you get error while updating your db with newest changset. it's OK cuz sometime it will fixed in next changset. Just be patient...^^
MANGOS LATEST FULL SDB or SDB CHANGESET :
FULL SDB :
1. SDB 0.5.3 REVISION 40 COMPLETE by cyrex
2. Full SDB 0.5.4 *Changeset 40* 2867 by Urbin
Cyrex explained about size in changset < 35 and 40 ( maybe start from 37 changset )
Quote:
AND the explanation of the WHY sizes between 190mbs and 40mbs.
There are MANY empty rows in several columns that are NULL value, for some filling purpose, some DB makers create a zero (0) filling in this so they are not empty. Its the same thing. Well this is for some columns not all. The zeros in this MANYYYY rows create this oversize, then creates the size of 190 mb. Both work equally and both work good.
PATCH / CHANGESET SDB :
You can get latest patch by looking HERE
by packetspyke - can get Full SDB and latest mangos core rev. too.
OTHERS GUIDE :
1. COMPLETE MANGOS WEBSITE by Dristol
2. DJRavine
3. by tr4shm4n
4. by wedtm
5. by kiasta
Sorry about my bad English...
Credits are for Urbin, itizai, bogie, cyrex, AlexLuana, tr4shm4n, kiasta, Dristol, packetspyke and wedtm...thx very much...^^
Note : If mod find this thread is useless please delete it...^^
ok here is new problem...
ok .. i finally can log into my new mangos server... BUT i cant after logging into a new accout ( any account ) create characters... and i have checked out mysql rights ( data base privaledges ) and i cant grant all privaledges on the DB's .. but i dont think it has anything to do with the access since my kobold server works flawlessly.. so.. does anyone know why i cant create characters?
