[GUIDE] Ubuntu/Debian/CentOS/RHEL Install Guide

[redigaffi]

Ehm, explain please more for noobs, how to change rates, how to change the mode, PvP or normal..

[Toinan67]

Ehm, explain please more for noobs, how to change rates, how to change the mode, PvP or normal..

See mangosd.conf, all is explained in it

[redigaffi]

Thank you bro

[redigaffi]

Sorry for doble post, i follow the complete guide, everything, i installed mangosweb enhanced, create account, i add a server in admin panel, and then via SSH i start the server and in the webs appears online, i connect with my created account and when it arrives on connect, there stops there, also it stops on connect, and dont follow

visit to see www.gamingfive.com (spanish community)

[CrashMan©]

2010-09-17 10:18:12 Loading Game Object Templates...

2010-09-17 10:18:12 ERROR:Error in gameobject_template table, probably sql file format was updated (there should be 43 fields in sql).

Can help me?

[redigaffi]

Answer please!

[Havsmonstret]

Looks like an awesome tutorial

But which version of wow should I use to create the maps, dbc and vmaps?

Also, which version should I use to connect to the server?

[SOADfan]

Currently, Mangos supports 3.3.5 (12340) build.

[Lodur]

i can't run "make install"

it always gives me this error:

make[4]: Entering directory `/root/mangos/objdir/dep/ACE_wrappers'
make[4]: Nothing to be done for `install-exec-am'.
make[4]: Nothing to be done for `install-data-am'.
make[4]: Leaving directory `/root/mangos/objdir/dep/ACE_wrappers'
make[3]: Leaving directory `/root/mangos/objdir/dep/ACE_wrappers'
make[2]: Leaving directory `/root/mangos/objdir/dep/ACE_wrappers'
Making install in tbb
make[2]: Entering directory `/root/mangos/objdir/dep/tbb'
make[3]: Entering directory `/root/mangos/objdir/dep/tbb'
/usr/bin/install -c /root/mangos/objdir/dep/tbb/lib*.so* /opt/mangos/lib
/usr/bin/install: cannot stat `/root/mangos/objdir/dep/tbb/lib*.so*': No such file or directory
make[3]: *** [install-exec-local] Error 1
make[3]: Leaving directory `/root/mangos/objdir/dep/tbb'
make[2]: *** [install-am] Error 2
make[2]: Leaving directory `/root/mangos/objdir/dep/tbb'
make[1]: *** [install-recursive] Error 1
make[1]: Leaving directory `/root/mangos/objdir/dep'
make: *** [install-recursive] Error 1

what to do ?

[Furious-Py]

i can't run "make install"

it always gives me this error:

make[4]: Entering directory `/root/mangos/objdir/dep/ACE_wrappers'
make[4]: Nothing to be done for `install-exec-am'.
make[4]: Nothing to be done for `install-data-am'.
make[4]: Leaving directory `/root/mangos/objdir/dep/ACE_wrappers'
make[3]: Leaving directory `/root/mangos/objdir/dep/ACE_wrappers'
make[2]: Leaving directory `/root/mangos/objdir/dep/ACE_wrappers'
Making install in tbb
make[2]: Entering directory `/root/mangos/objdir/dep/tbb'
make[3]: Entering directory `/root/mangos/objdir/dep/tbb'
/usr/bin/install -c /root/mangos/objdir/dep/tbb/lib*.so* /opt/mangos/lib
/usr/bin/install: cannot stat `/root/mangos/objdir/dep/tbb/lib*.so*': No such file or directory
make[3]: *** [install-exec-local] Error 1
make[3]: Leaving directory `/root/mangos/objdir/dep/tbb'
make[2]: *** [install-am] Error 2
make[2]: Leaving directory `/root/mangos/objdir/dep/tbb'
make[1]: *** [install-recursive] Error 1
make[1]: Leaving directory `/root/mangos/objdir/dep'
make: *** [install-recursive] Error 1

what to do ?

Try:

mkdir /opt/mangos

mkdir /opt/mangos/lib

Then: make install again

[Furious-Py]

Looks like an awesome tutorial

But which version of wow should I use to create the maps, dbc and vmaps?

Also, which version should I use to connect to the server?

For last mangos use w.w version 3.3.5A

[Pims]

Hi all,

I tried to install my own mangos serv. to do it i use http://getmangos.eu/wiki/Compile_MaNGOS_On_Ubuntu

But when i arrived to Create the MaNGOS database whith this command

mysql -u mangos -ppassword < /opt/mangos/mangos/sql/create_mysql.sql

I have an error :

pims@pims-desktop:~$ mysql -u wowserv -pxxxxxxxx < ~/opt/mangos/mangos/sql/create_mysql.sql
ERROR 1045 (28000) at line 1: Access denied for user 'wowserv'@'localhost' (using password: YES)

Have you an idea ?

thnaks

before trying tu create my DB i create user with privilege with :

CREATE USER 'wowserv'@'localhost' IDENTIFIED BY 'xxxxxxxx';
GRANT ALL PRIVILEGES ON *.* TO 'wowserv'@'localhost';
CREATE USER 'wowserv'@'%' IDENTIFIED BY 'xxxxxxxx';
GRANT ALL PRIVILEGES ON *.* TO 'wowserv'@'%';
FLUSH PRIVILEGES;
exit;

ps : scuse for my english

-----------------------------------------------------------------------------------------------------------------------------------

I solve my problème:

When i look for prilège user i see a difference betewn root and wowserv

so you should chnage

GRANT ALL PRIVILEGES ON *.* TO 'wowserv'@'localhost';

by

GRANT ALL PRIVILEGES ON *.* TO 'wowserv'@'localhost' WITH GRANT OPTION;

and use mangos as name for ur user

[SOADfan]

Great tutorial indeed. Helped me to get server running. But there's an issue. How do i recompile using ubuntu? I pull changes from git, update scriptdev2, but what do i have to do next in order to recompile and replace old revision with newly compiled one? Do i have to completely remove and remake server everytime i want to update?

[Locario]

All ok for me, except the patching

Phpmyadmin shows for db "characters" : required_10862_01_characters_mail

If i do :

mysql -p'PASS' characters < 10862_01_characters_mail.sql

It returns :

ERROR 1054 (42S22) at line 1: Unknown column 'required_10664_01_characters_arena_team_stats' in 'character_db_version'

ok...

if i do :

 mysql -p'PASS' characters < 10664_01_characters_arena_team_stats.sql

then again :

ERROR 1054 (42S22) at line 1: Unknown column 'required_10662_01_characters_item_loot' in 'character_db_version'

and allways the same

[lostab]

I got an error when I compile the mongos with "make" command:

  CXX    CreatureEventAIMgr.o
 CXX    Creature.o
../../../src/game/Creature.cpp: In member function 'virtual void Creature::DeleteFromDB()':
../../../src/game/Creature.cpp:1377: error: no matching function for call to 'MapPersistentStateManager::DoForAllStatesWithMapId(uint32, CreatureRespawnDeleteWorker)'
../../../src/game/MapPersistentStateMgr.h:336: note: candidates are: void MapPersistentStateManager::DoForAllStatesWithMapId(uint32, Do&) [with Do = CreatureRespawnDeleteWorker]
make[4]: *** [Creature.o] Error 1
make[4]:Leaving directory `/home/lostab/mangos/objdir/src/game'
make[3]: *** [all-recursive] Error 1
make[3]:Leaving directory `/home/lostab/mangos/objdir/src/game'
make[2]: *** [all-recursive] Error 1
make[2]:Leaving directory `/home/lostab/mangos/objdir/src'
make[1]: *** [all-recursive] Error 1
make[1]:Leaving directory `/home/lostab/mangos/objdir'
make: *** [all] Error 2

Can anyone help me, please?

[mindblack]

when i'm running mangos-worldd, i have been msg err

Connected to MySQL database at 95.168.212.179

MySQL client library: 5.0.51a

MySQL server ver: 5.0.51a-3ubuntu5.8

AUTOCOMMIT SUCCESSFULLY SET TO 1

SQL: SET NAMES `utf8`

SQL: SET CHARACTER SET `utf8`

Connected to MySQL database at 95.168.212.179

MySQL client library: 5.0.51a

MySQL server ver: 5.0.51a-3ubuntu5.8

AUTOCOMMIT SUCCESSFULLY SET TO 1

SQL: SET NAMES `utf8`

SQL: SET CHARACTER SET `utf8`

SQL: SELECT required_11117_01_mangos_world_template FROM db_version LIMIT 1

query ERROR: Unknown column 'required_11117_01_mangos_world_template' in 'field

SQL: SELECT * FROM db_version LIMIT 1

The table `db_version` in your [WORLD] database indicates that this database is

1. You have: --> `10537_01_mangos_command.sql`

2. You need: --> `11117_01_mangos_world_template.sql`

You must apply all updates after 1 to 2 to use mangos with this database.

These updates are included in the sql/updates folder.

Please read the included README in sql/updates for instructions on updating.

how fix that

[Patman128]

when i'm running mangos-worldd, i have been msg err

Connected to MySQL database at 95.168.212.179

MySQL client library: 5.0.51a

MySQL server ver: 5.0.51a-3ubuntu5.8

AUTOCOMMIT SUCCESSFULLY SET TO 1

SQL: SET NAMES `utf8`

SQL: SET CHARACTER SET `utf8`

Connected to MySQL database at 95.168.212.179

MySQL client library: 5.0.51a

MySQL server ver: 5.0.51a-3ubuntu5.8

AUTOCOMMIT SUCCESSFULLY SET TO 1

SQL: SET NAMES `utf8`

SQL: SET CHARACTER SET `utf8`

SQL: SELECT required_11117_01_mangos_world_template FROM db_version LIMIT 1

query ERROR: Unknown column 'required_11117_01_mangos_world_template' in 'field

SQL: SELECT * FROM db_version LIMIT 1

The table `db_version` in your [WORLD] database indicates that this database is

1. You have: --> `10537_01_mangos_command.sql`

2. You need: --> `11117_01_mangos_world_template.sql`

You must apply all updates after 1 to 2 to use mangos with this database.

These updates are included in the sql/updates folder.

Please read the included README in sql/updates for instructions on updating.

how fix that

Step 1: READ IT

Step 2: ???? (<--- you figure this one out after reading it)

Step 3: PROFIT!

[mindblack]

when i'm running mangos-worldd, i have been msg err

Connected to MySQL database at 95.168.212.179

MySQL client library: 5.0.51a

MySQL server ver: 5.0.51a-3ubuntu5.8

AUTOCOMMIT SUCCESSFULLY SET TO 1

SQL: SET NAMES `utf8`

SQL: SET CHARACTER SET `utf8`

Connected to MySQL database at 95.168.212.179

MySQL client library: 5.0.51a

MySQL server ver: 5.0.51a-3ubuntu5.8

AUTOCOMMIT SUCCESSFULLY SET TO 1

SQL: SET NAMES `utf8`

SQL: SET CHARACTER SET `utf8`

SQL: SELECT required_11117_01_mangos_world_template FROM db_version LIMIT 1

query ERROR: Unknown column 'required_11117_01_mangos_world_template' in 'field

SQL: SELECT * FROM db_version LIMIT 1

The table `db_version` in your [WORLD] database indicates that this database is

1. You have: --> `10537_01_mangos_command.sql`

2. You need: --> `11117_01_mangos_world_template.sql`

You must apply all updates after 1 to 2 to use mangos with this database.

These updates are included in the sql/updates folder.

Please read the included README in sql/updates for instructions on updating.

how fix that

Step 1: READ IT

Step 2: ???? (<--- you figure this one out after reading it)

Step 3: PROFIT!

pls give me clear and simple answer to fix that

[Skirnir]

pls is please ;-)

Either way you should do what Patman128 suggested. Read it.

1. You have: --> `10537_01_mangos_command.sql`
2. You need: --> `11117_01_mangos_world_template.sql`

It isn't that complicated. Look inside your mangos sql/updates folder and apply all pending sql updatefiles in order of appearance.

10551_01_mangos_spell_proc_event.sql
10568_01_characters_character_tutorial.sql
10582_01_mangos_spell_proc_event.sql
...
11115_01_mangos_command.sql
11117_01_mangos_world_template.sql
11117_02_characters_world.sql

By the way this ain't a problem of installing MaNGOS with one of the linux distributions of the title.

Regards

Skirnir

[mindblack]

pls is please ;-)

Either way you should do what Patman128 suggested. Read it.

1. You have: --> `10537_01_mangos_command.sql`
2. You need: --> `11117_01_mangos_world_template.sql`

It isn't that complicated. Look inside your mangos sql/updates folder and apply all pending sql updatefiles in order of appearance.

10551_01_mangos_spell_proc_event.sql
10568_01_characters_character_tutorial.sql
10582_01_mangos_spell_proc_event.sql
...
11115_01_mangos_command.sql
11117_01_mangos_world_template.sql
11117_02_characters_world.sql

By the way this ain't a problem of installing MaNGOS with one of the linux distributions of the title.

Regards

Skirnir

i'm just newbie btw i'm look inside my mangos sql/update...is many sql data included 11117_01_mangos_world_template.sql so what can do for now, how to apply that with command line?.....give me a detail instruction for fix this thank's

[Skirnir]

i'm just newbie btw i'm look inside my mangos sql/update...is many sql data included 11117_01_mangos_world_template.sql so what can do for now, how to apply that with command line?.....give me a detail instruction for fix this thank's

We all were once newbies, but some of us tried reading and others just tried questioning stuff that has been written dozens of times.

You do it like this:

mysql --host=127.0.0.1 --user=mangos --password=mangos --port=3306 mangos < 10551_01_mangos_spell_proc_event.sql

Every file has to be applied to the correct database. This file has to be applied to the mangos database.

mysql --host=127.0.0.1 --user=mangos --password=mangos --port=3306 characters < 10568_01_characters_character_tutorial.sql

This to the characters database.

After applying every pending file you should not get startup errors.

Regards

Skirnir

PS: I'm outta this thread, ur on ur own pal. G'luck!

[mindblack]

i'm just newbie btw i'm look inside my mangos sql/update...is many sql data included 11117_01_mangos_world_template.sql so what can do for now, how to apply that with command line?.....give me a detail instruction for fix this thank's

We all were once newbies, but some of us tried reading and others just tried questioning stuff that has been written dozens of times.

You do it like this:

mysql --host=127.0.0.1 --user=mangos --password=mangos --port=3306 mangos < 10551_01_mangos_spell_proc_event.sql

Every file has to be applied to the correct database. This file has to be applied to the mangos database.

mysql --host=127.0.0.1 --user=mangos --password=mangos --port=3306 characters < 10568_01_characters_character_tutorial.sql

This to the characters database.

After applying every pending file you should not get startup errors.

Regards

Skirnir

PS: I'm outta this thread, ur on ur own pal. G'luck!

ok i understand for that, i'm update with python script but i'm not sure about that

and now i have msg error for my server like this

2011-02-13 17:07:12 Login Database: 95.168.212.179;3306;xxxxxxxx;xxxxxx;realmd, total connections: 2

2011-02-13 17:07:12 MySQL client library: 5.0.51a

2011-02-13 17:07:12 MySQL server ver: 5.0.51a-3ubuntu5.8

2011-02-13 17:07:12 MySQL client library: 5.0.51a

2011-02-13 17:07:12 MySQL server ver: 5.0.51a-3ubuntu5.8

2011-02-13 17:07:12 Realm running as realm ID 1

2011-02-13 17:07:12 Using World DB: UDB 0.12.1 (393) for MaNGOS 10545 with SD2 SQL for rev. 1833

2011-02-13 17:07:12 Using creature EventAI: ACID 3.0.8 - Full Release for Mangos (3.3.5a Client)

2011-02-13 17:07:12 Using DataDir ./

2011-02-13 17:07:12 WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1

2011-02-13 17:07:12 WORLD: VMap data directory is: ./vmaps

2011-02-13 17:07:12 ERROR:Map file './maps/0004331.map' is non-compatible version (outdated?). Please, create new using ad.exe program.

2011-02-13 17:07:12 ERROR:Correct *.map files not found in path './maps' or *.vmtree/*.vmtile files in './vmaps'. Please place *.map and vmap files in appropriate dir$

for that's err problem from my maps and vmaps right?, i must replace my maps and vmaps for new version?

[Cyberfreak]

i must replace my maps and vmaps for new version?

Not necessarily replace with a newer version, rather with the (v)maps from a client with a version (3.3.5a) adequate to your server core version. Since Cataclym, most people with this error trying to run their 3.3.5 server with 4.0.x client maps.

[mindblack]

i must replace my maps and vmaps for new version?

Not necessarily replace with a newer version, rather with the (v)maps from a client with a version (3.3.5a) adequate to your server core version. Since Cataclym, most people with this error trying to run their 3.3.5 server with 4.0.x client maps.

ok but i can't start up my mangos-worldd because if i start up i have err msg, how to ignored that?

[Skirnir]

2011-02-13 17:07:12 Using DataDir ./

This comes from mangosd.conf. Check if your path is correct. I usually have my folders like: bin/ data/ etc/ lib/, that's why I have to change my path in mangosd.conf to:

DataDir = "../data"

(One folder above mangosd bin file and inside the folder data)

Regards

Skirnir