yip328

Question regarding this topic.

What if I put all the necessary update SQL files in one folder, and do "cat *.sql" to concatenate them into one big SQL file?

It worked fine until a few months ago. Yeah, it's a very primitive way of doing it though.

Thanks

Hello, i'd like to say thanks for this tut its simple to understand, and makes life easyer lol.

Make sure you have the package, libmysql++-dev, installed on Ubuntu.

It says "required_8840_01_mangos_spell_proc_event" which is the highest available in the updates directory, So I guess that no updates are needed...?

If your db_version table says you're at 8840 and if that's the latest in updates folder, I guess you're set with the updates.

When I apply the patches with this command;

First, you gotta find out which version of Mangos DB you're at. Easiest way, if you're on Linux, install phpmyadmin (GUI for managing database). On Ubuntu,

 sudo aptitude install phpmyadmin 

will do the trick.

Login, and navigate to Mangos DB and click on "db_version" table. On the right side, you'll see something along the line of "required_####_..._mangos_..." where #### is where you're at. Work up from there.

EDIT:

 ERROR 1054 (42S22) at line 1: Unknown column 'required_8731_01_mangos_creature_template' in 'db_version' 

means exactly what it says. You need 8731_01_mangos_creature_template.sql before you can import 8749_01_mangos_mail_loot_template.sql.

I am guessing I used the wrong version of something.

Yes. Just as the errors say. DBC files are extracted from the incompatible version of client.

I have updated the main post, compiled with the current revision.

Great to have you back, Phelpsben. You disappeared for awhile there.

okay the directory listings are re-done but now I get this error:

./mangos-realmd: error while loading shared libraries: libACE-5.6.6.so: cannot open shared object file

is there anyway to... make it so they use shared object files?

Maybe it's not it, but I see your libACE.so is red. In mine, it's a symlink to libACE-5.6.6.so, and red typically denotes that the link is broken. It may be the cause, but also it may be nothing. Here's my lib folder:

jellyb@momserv:~/momd313/r8526/lib$ ll
total 5.6M
-rwxr-xr-x 1 jellyb jellyb 2.3M 2009-09-22 00:30 libACE-5.6.6.so
-rwxr-xr-x 1 jellyb jellyb  970 2009-09-22 00:30 libACE.la
lrwxrwxrwx 1 jellyb jellyb   15 2009-09-22 00:30 libACE.so -> libACE-5.6.6.so
-rwxr-xr-x 1 jellyb jellyb 1007 2009-09-22 00:30 libmangosscript.la
lrwxrwxrwx 1 jellyb jellyb   24 2009-09-22 00:30 libmangosscript.so -> libmangosscript.so.0.0.0
lrwxrwxrwx 1 jellyb jellyb   24 2009-09-22 00:30 libmangosscript.so.0 -> libmangosscript.so.0.0.0
-rwxr-xr-x 1 jellyb jellyb 3.4M 2009-09-22 00:30 libmangosscript.so.0.0.0

That's at least how I understood it. Yes please... If you could further verify it, it'd be great, since my knowledge with SQL is very limited at this point. I'll dig more into udb forums as well and see if I could come up with more useful information regarding this issue.

I'm sorry if I didn't make it clear in my last post.

What I meant to say was that if you use characters.sql and realmd.sql, they already include 380, 381, 382 and updates from mangos/sql/updates. So, you don't have to touch those 2 databases after importing them from mangos/sql. Let me know if i'm not making clear this time.

The only reason why I had to perform step 4 was because I was having trouble running the UDB 381 core patch for the characters DB. So I was forced to take it back by using the UDB clean install dump. So rather than figure out what was gonna break in 381 and 382 in terms of characters and realmd, I decided to just import everything in the clean install directory. Otherwise, I would have done exactly what you did.

But to my understanding, if you take realmd.sql and characters.sql from mangos/sql, you no longer need to update them with anything else including 381 and 382. Correct me if I'm wrong though.

The way I figured out was by checking their db_version tables in each of them. Let me know of what you find. I'm not proficient in SQL.

I'm glad that it's working. The reason I imported characters.sql and realmd.sql from mangos/sql is that they're always at the most recent versions. So, you don't have to worry about updating them like you did in step 4.

... I'll keep yall posted on my progress or if I run into any other snags...

Try importing UDB_0.11.5_Core_7681_SD2_1012.sql into mangos database instead of sql/mangos.sql. Please refer to my post #99 on this thread. And let us know if that works out for you.

Hey, Im installing MaNGOS using this tuturial, currently uploading VMaps and I should be done. But I was just looking through my SQL Database and noticed there was no table containing data for Class ID 6, Death Knights. So I was wondering if the SQL from this guide might be outdated? And if so, could anyone please tell me where I can find the right SQL file to update for this version of MaNGOS? If I'm not mistaken, this version should build-up a MaNGOS for WoW 3.1.3, right?

Thanks in advance

Yes, the OP badlly needs to be updated. I might later post a new Howto for Mangos and Ubuntu. For the mean time, look at post #99 in this thread. They were my notes and about a month old. Mangos DB incremental updates should be updated.

if i was to do this as of today which version of the DBC's, maps and vmaps would i need? Given that the latest (as of 28 Aug 2009) of Acid's SQL is no longer 009, but is 3.0.0.?

Current supported client version is 3.1.3, and that's where you should get maps from. And yes, the guide is a bit outdated: ACID is at 3.0.0.

http://www.scriptdev2.com/acid-3-0-t4502.html

I instaled 9.04 on VM and now a new problem starst to anoy!!

Dang .. seems like mangos doesn't like you ..

Joking aside, I did a little research on your git error, and some people are experiencing similar problems on Jaunty 9.04. But I just tested it, and it went fine on my standalone 9.04 server.

jellyb@momserv:~/playground$ git clone git://github.com/mangos/mangos.git
Initialized empty Git repository in /home/jellyb/playground/mangos/.git/
remote: Counting objects: 35990, done.
remote: Compressing objects: 100% (7052/7052), done.
remote: Total 35990 (delta 29093), reused 35778 (delta 28884)
Receiving objects: 100% (35990/35990), 28.93 MiB | 301 KiB/s, done.
Resolving deltas: 100% (29093/29093), done.

Is it specific to your new install? Can you run git on your regular machine?

Yeah .. other than those.. I"m really out of ideas... try the 9.04 in a VM first. So that you know it's working before you deploy it to a real server.

When I tried it this afternoon, it was in a VM too. In case you wanna reproduce the exact same steps I did, here's how I installed it... (notes of steps that I took.. ask me if any steps doesn't make sense to you):

==========================

NOTES

###  Updated for Mangos(r8429) and ScriptDev2(r1373) on 2009-08-27

# Lines after "$" are actual commands.
# Lines after "#" or "#"s are comments and descriptions.
# MANGOS=$HOME/momserv313  # momd313 is where everything Mangos related resides.
#  myup = mysql -uroot -pmangos

==========================

DEPENDENCIES

#  "sudo aptitude install" the following:

build-essential git-core subversion automake libtool zlibc libmysql++-dev \\
libssl-dev unrar p7zip-full pkg-config

# If you're used to using apt-get, it's fine too.  Just don't mix the two.

==========================

II) COMPILING MANGOS AND SCRIPTDEV2


###  Downloading mangos and scriptdev2 sources

@$MANGOS/
$ git clone git://github.com/mangos/mangos.git
$ svn co [url]http://scriptdev2.svn.sourceforge.net/svnroot/scriptdev2[/url] \\
mangos/src/bindings/ScriptDev2

###  Apply the ScriptDev2 patch to Mangos

@$MANGOS/
$ git apply src/bindings/ScriptDev2/patches/MaNGOS-8273-ScriptDev2.patch
$ autoreconf --install --force --verbose
$ mkdir build && cd build
$ export MANGOS=$HOME/momserv313

###  The usual configure; make; make install

@$MANGOS/build/
$ ../configure --prefix=$MANGOS/r8429 \\
--sysconfdir=$MANGOS/sysconfdir --datadir=$MANGOS/datadir --enable-cli \\
CXXFLAGS="-march=native -O2 -pipe" CFLAGS="${CXXFLAGS}"
$ make -j3            #3:49.7 (i7-920), 9:49 (core2-e6600)
$ make install

==========================

EDIT:

# Package "p7zip-full" is not necessary.

# Package "unrar" is to later extract UDB.

Now i got this

Could it be that your ssl version is incompatible (possibly a bit outdated?) with mangos? Just guessing here. I see that you're using Ubuntu 8.10.

I'd suggest that you try either compiling openssl from source (I've never tried though), or you could test the newer Ubuntu 9.04 in a VM environment. VirtualBox is the easy way.

I also have pkg-config installed and still geting the same error!!!!

Alright guys. I will recompile it from fresh with newest versions, and see if I can come up with the errors you guys are encountering. Give me a couple of hours. As soon as I have results, I will update this post.

----- EDIT:

Just tested. It compiled successfully.

This was tested on Ubuntu Server 9.04 X86_64. (mangos-r8429 / sd2-r1373)

The following are the packages I've installed:

build-essential git-core subversion automake libtool zlibc libmysql++-dev libssl-dev unrar pkg-config

Try a fresh download of sources (i.e. Mangos and SD2) and compile please. I've ran into weird problems in the past, because I just ran the updates on the sources.

Let me know how it goes.

Confirming kouens error message with rev 8415.

My os: ubuntu 9.04 server 64bit

UPDATE: After installing pkg-config the error vanished.

Yes. Make sure you guys have the package, pkg-config, installed. The package name may vary on other distributions though. This requirement has been added per the following commit by VladimirMangos:

http://github.com/mangos/mangos/commit/f3a5a93eb32a0184758cbbe7b0af67e078ed95ee

I tried both, same outcome. No problems in applying the patch, the problem comes after having configured it, and then coming to compiling.

Can you paste your output of configure and make in "pastebin.ca"? I'll see if I can spot what went wrong.

I got a problem in the compiling phase, in the middle of the make install process, I get a long list of errors, and then it stops, saying nothing. I have followed the whole tutorial so far, no errors what so ever in any of the previous steps, the only different thing I did than the tutorial was to update with the newest patch that I got from the svn.

Any help appreciated.

You sure it's not at make process rather than make install?

Anyway, did you get any error output when you applied the patch from the svn? I'm assuming you meant Step 3. Lately, I always do "git apply" instead of "git am", since the later usually spits out errors.

lol assuming on my part that the sha sums were encrypted in phpadmin lol,

but woo loogged in for the first time today and it feels great

thanks for all your help

Usernames and passwords are hashed using sha1sum in the form of 'USERNAME:PASSWORD'. So, for an account with a username "jondoe" with a password "jdpass":

$ echo -n 'JONDOE:JDPASS' | sha1sum
e7f59ba4ba2ad383e27d0f31e589d9e7c70211f2  -

Note that all letters are transformed into uppercases then hashed.

yeah lol turns out i was logging in wrong, now to figure out how to set up an account and i'm golden, bot the wrong client version error last night before work, reverted to 3.0 and updated to 3.1.3 today, now i just gotta get an account and it's on like donkey kong lol, but for now i must sleep, then figure out how the encryption works for the database passwords tonight lol.

though i've heard that you can only do it with a website, that just doesn't sound right. gotta be a tool for it somewhere, or maybe i just am missing an option in phpmyadmin

Not quite sure what you meant by "encryption for the database passwords".

But to set up an account (assuming you're talking about players' accounts with certain gmlevels):

After running mangos-worldd and at the same prompt:

- To create a user account:

 account create PLAYER_NAME PASSWORD [ENTER]

 account set gmlevel PLAYER_NAME # [ENTER] 

where # is 3 for Admin.

ok followed your updating db steps, but still getting the "login server is down". that and i don't know what could be the problem there, gonna try down patching my client and see if that helps, but i'm not too sure...

Are you on the same subnet as the server? Most likely it's the values in the "realmlist" table inside "realmd" database. Double check "address" and "port".

Also, make sure username and pw inside mangosd.conf and realmd.conf are what they supposed to be.

well after 10-12 different tutorials, 5 linux reinstalls and a and a fried motherboard (own mistake there) i finally got through the whole install... copying over the last of my vmaps as we speak and hoping this is it lol. had some trouble with mysql at first, think that was fixed after i started fresh... only time will tell though getting ready to boot up as we speak

Ha! It will be worth the troubles in the end.

Assuming you're trying this out on a headless Ubuntu server, I suggest you install the following packages:

- phpmyadmin: Great remote MySQL administration web frontend. After installation, just go to http://ServerIP/phpmyadmin

- openssh-server: SSH server, so that you can comfortably work from a laptop while watching TV

And if you're following this guide to install databases, there are already a few significant updates. Well, I made a note of myself of what I had to do in order to setup updated databases. So, here's a snippet of my notes:

# I'm lazy so...

# export $MANGOS=$HOME/mangos-313

# alias myup='mysql -uroot -pYOUR_DB_PASSWORD'

# Lines starting with '$' are actual commands

# Import 0.11.5 Core from UDB

# Note that empty mangos db is not imported from $MANGOS/sql/mangos.sql, because I once ran into problems with core patches and updatepacks from UDB.

@ $MANGOS/udb/Full_DB/

$ unrar e UDB_0.11.5_Core_7681_SD2_1012.rar

$ myup mangos < UDB_0.11.5_Core_7681_SD2_1012.sql

# Updating with corepatches and updatepacks

@ $MANGOS/udb/Updates/0.11.5_additions/

$ myup mangos < 380_corepatch_mangos_7682_to_7894.sql

$ myup mangos < 380_updatepack_mangos.sql

$ myup mangos < 381_corepatch_mangos_7895_to_8029.sql

$ myup mangos < 381_updatepack_mangos.sql

$ myup mangos < 382_corepatch_mangos_8030_to_8280.sql

$ myup mangos < 382_updatepack_mangos.sql

# Mangos DB incremental updates (as of 2009-08-02)

@ $MANGOS/

$ myup mangos < mangos/sql/updates/8294_01_mangos_playercreateinfo_action.sql

# ACID DB patch

@ $MANGOS/

$ myup mangos < 3.0.0_acid.sql

# ScriptDev2 DB patch

@ $MANGOS/mangos/src/bindings/ScriptDev2/sql/

$ myup mangos < mangos_scriptname_full.sql

######## Characters Database Installation (Updates not needed as of this writing)

@ $MANGOS/

$ myup characters < mangos/sql/characters.sql

######## Realmd Database Installation (Updates not needed as of this writing)

@ $MANGOS/

$ myup realmd < mangos/sql/realmd.sql

######## Scriptdev2 Database and Updates

# Create Scriptdev2 database and structure

@ $MANGOS/src/bindings/ScriptDev2/sql/

$ myup < scriptdev2_create_database.sql

$ myup scriptdev2 < scriptdev2_create_structure_mysql.sql

# Populate Scriptdev2 database with data

@ $MANGOS/src/bindings/ScriptDev2/sql/

$ myup scriptdev2 < scriptdev2_script_full.sql

#######################################

Let me know if I'm doing something wrong.

Great. Easy on the eyes. Thanks.