Help needed with setting up MaNGOS 3.3.2 server (Noobish)

[Vh41loR]

Hi guys,

I've been trying for 2 days now to setup and configure a MaNGOS server.

I'm totally new to this but not new to Linux.

I downloaded the latest Ubuntu Server 64-bit edition.

I followed the steps in this forum for installation on Ubuntu/CentOS etc etc

I was hoping someone could help me by giving me a summary of what needs to happen and in what order.

So far, i've installed Ubuntu Server 64bit, I've downloaded all the necessary software.

I've compiled MaNGOS. (followed the instructions on this site)

I've gotten to the point where I'm suppose to run mangos-realmd and mangos-worldd.

Mangos-realmd runs fine but when I execute Mangos-Worldd I get the following message.

Server.log

2010-04-22 13:41:07 MaNGOS/0.16.0 (* * Revision 9773 - *) for Linux_x64 (little-endian) [world-daemon]

2010-04-22 13:41:07 <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://getmangos.eu

MMMMMM

2010-04-22 13:41:07 Using configuration file /opt/mangos/etc/mangosd.conf.

2010-04-22 13:41:07 World Database: 127.0.0.1;3306;mangos;mangos;mangos

2010-04-22 13:41:07 MySQL client library: 5.0.83

2010-04-22 13:41:07 MySQL server ver: 5.1.37-1ubuntu5.1

2010-04-22 13:41:07 ERROR:SQL: SELECT required_9768_01_mangos_command FROM db_version LIMIT 1

2010-04-22 13:41:07 ERROR:query ERROR: Unknown column 'required_9768_01_mangos_command' in 'field list'

2010-04-22 13:41:07 ERROR:Table `db_version` have field `required_9539_01_mangos_spell_bonus_data` but expected `required_9768_01_mangos_command`! Not all sql updates applied?

I've looked it up on the forum and found others with the same problem, and the answer is to update

the SQL database. Can anyone tell me what I need to download and do to update the SQL database.

I'm planning on setting up a 3.3.2 server.

Thanks in advance for any help!

Kind Regards

Vh41loR

[SeySayux]

You obviously missed all the other threads about the same thing, and oh yes, the FAQ thread.

Seriously, could some admin make that one flash in red on the top of the board?

EDIT: Seems you did find the theads and the FAQ. My apologies.

The updates you're looking for are in the <mangos root>/sql/updates folder. Apply all updates with a revision above your current. Copy them to a serperate folder or such.

To apply a patch, use:

mysql -u<username> -p<password> <database> < patch.sql

Where <username> is your sql username, <password> is your sql password, and <database> is mangos, realmd or characters depending on the second word of the patch.

If you can use a Linux shell I'm sure you can work out a for with file globbing.

If not, here's the solution:

for table in 'mangos characters realmd'; do
for x in *$table*.sql; do
mysql -u<username> -p<password> $table < $x; 
done; done

That should do it

[Vh41loR]

Jumping the horse a bit there hey? ;-P

Thanks for the help. Got it updated but now it gives a new error "Outdated Maps" so I'm assuming that the latest MaNGOS doesn't support 3.3.2 anymore since my client is 3.3.2 and the maps,dbc and vmaps were extracted from there.

Can anyone tell me which version of MaNGOS I need to get in order to run 3.3.2. Also I'm using Ubuntu Server 64bit. I've checked the Github website's download section. There's a couple versions but doesn't look like its for Linux. Doesn't have the .git directory in the zip.

Thanks again!

Regards

Vh41loR

[caeruleaus]

.git has nothing to do with it being linux or not....

Why not just update your WoW client? Mangos supports 3.3.3a now.

do git reset --hard c7c8c8ed014dbbd034ae20e7d73beca38d7a4adc

if you want mangos for 3.3.2a