Contents

1.0 Installing Ubuntu
1.1 Installing The Needed Files
1.2 Creating The mySQL Databases
1.3 Downloading Ascent
1.4 Configuring Ascent’s Files
1.5 DBC & Maps
1.6 Importing mySQL Databases
1.7 Forwarding Ports
1.8 Run Your Server

2.0 Creating a Webserver & Running “Spora”

__________________________________________________ ________________________

1.0 Installing Ubuntu

What is Ubuntu? Ubuntu is just like the Windows computer, an operating system (OS). It is alot more stable and harder to use but has its ups and downs. Installing Ubuntu on your computer will get rid of all files and your Windows OS that came installed on it. It will make your computer completely different so be sure you want to do this. You have been warned and I will not take any blame/part in the harm this may do to your computer.

Alright. First off you need to download the .iso. To obtain the .iso go to http://www.ubuntu.com/getubuntu/download.

It will take a long time to download Ubuntu because this is the file that has everything that’s going to install a new OS.

When the file is done downloading, you will need to install a program called “ISO Recorder”. Click here for the download page. I did not make this program.

Install that properly and then find a DVD+R(W) disc.

Once you have put the blank CD into the disc drive, go to your computer and find where the ubuntu ISO was downloaded to (Possibly your desktop or documents). Right click on the .iso file you downloaded and find “Write to CD” or create image, something like that (Not sure). It should have already selected the blank CD and said it is ready to use or something. Click next and it should start writing to the disc, do not turn off the computer or eject the CD during this time. When it’s finished, it will eject automatically. Put the CD back into the computer and turn the computer off correctly.

Start the computer up (I no longer have an image)

Select the first option by pressing ENTER. It will take some time to load up the live cd.

Double click on “Install” and in a few moments a window will pop up.

Follow the on screen instructions until it starts installing.

DO NOT power down or eject the CD at all, or everything will be gone and no progress will have taken place except for a useless HD.

Restart, take the CD out like it says and let it load up again.
Login with your username and password (case sensative)

If it says you have updates, install them because you will need to have a full updated system.

We have finished installing Ubuntu, but I would like you to check something before we move on. Go to System > Administration > Software Sources
It will now prompt you for your password, so enter it. A window will popup. Make sure that “Community-maintainted Open Source software (universal) is checked (enabled).

If it was not originally enabled, then go to your terminal afterwards and type “sudo apt-get update” and it will update your sources.list (sudo is needed)

1.1 Installing The Needed Files

Ok, so you have your fresh new Ubuntu installation and we need the needed “packages” to run Ascent on Linux. The following is a list of commands you will need to type in the Terminal (Application > Accessories > Terminal). It will take some time between each installation of the packages so you can only do one command at a time.

sudo apt-get install mysql-server
sudo apt-get install libmysql++-dev
sudo apt-get install libssl-dev
sudo apt-get install libssl0.9.8
sudo apt-get install build-essential
sudo apt-get install subversion
sudo apt-get install automake
sudo apt-get install libtool
sudo apt-get install libpcre++0
sudo apt-get install libpcre++-dev
sudo apt-get install libzzip-0-13
sudo apt-get install libzzip-dev
sudo apt-get install zlibc

Yes, a big list and lots of time it needs. Some things may be missing and some may not need to be installed. If you have errors tell me and I’ll research it, thats what I did for my errors.

1.2 Create The mySQL Databases

First off, you need to configure and do some other stuff to mySQL which you previously installed. Go to your Terminal and type:

mysql -u root -p

It will ask for your password that you entered during the installation of mysql-server, insert it and hit enter.

Now you should be in mysql so it the command line shows “mysql> ”
Type the following commands, also the semi colon is needed at the end of every command in mysql except for quit. Type them in order ( ; )

create database character;
create database world;
create database logon;
quit

If you have a problem creating the databases such as this error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘character’ at line 1

You should instead follow this:

create database `character`;
create database `world`;
create database `logon`;
quit
Thanks to “Soneca” for that problem being solved.

1.3 Downloading Ascent

We finally got to the Ascent related parts. Go to your Terminal (The Terminal is everything in Linux) and type the following commands (case sensative):

cd Documents
mkdir WoW
cd WoW
svn co http://mmoforge.org/svn/ascent/
I’ll tell you what some of these do…
cd Documents will move you to the folder Documents. It’s not visual like Windows.
mkdir WoW creates the folder, or directory, called WoW.
cd WoW is explained in “cd Documents”
svn co http://mmoforge.org/svn/ascent/ downloads the ascent files.

When you do the last command (svn co http://mmoforge.org/svn/ascent/), it will ask you first for your password, then a login name which you will type “anonymous” and leave the password completely blank. This will start downloading and will take some time.

Your about 3/4’s the way there, so lets hold off the celebration. You now need to type the following, oh and I’m suspecting your still in the WoW directory:

cd ascent
cd Trunk
sudo mkdir etc
sudo mkdir bin
sudo autoreconf –force –install
sudo ./configure
sudo make
sudo make install
If you encounter any errors in ./configure and below, I can probably help you because I had run into many errors because of missing packages. Just make a post or PM me.
“sudo make” takes a long time so you might just start a movie, thats what I did.

Alright so after make is done and make install is done, you want to move the 4 files that were created automatically in /bin/ to /etc/. How do you do this in a command? Easy. The other guide did not state this very clearly and I had to google for the right command.
Make sure you are in the folder /trunk/ and type this:

sudo cp bin/* etc/

1.4 Configuring Ascent’s Files

Ok the last steps to this guide are almost here. I noticed another flaw in the old guide. He/She did not tell you that you were supposed to go into the directory src, which is inside of trunk, and then edit the files.

So as we were. In your terminal (assuming your still in the directory trunk) type the cd command to go into the directory src, if you have not figured out the cd command it is the following:

cd src

Now what your going to do is type “sudo pico ascent-world.conf”
To scroll down use the arrow keys. Find the following and change it to what I specified it to be:

- Change host to localhost.
- Change username to root.
- Change passwd to the password you set for the MySQL server.
- Change the top database to world.
- Change the bottom database to character.
- Delete the first die directive. (<die msg=”I am a newb who didn’t even read half my config file!”>).
- Change the remote password change_me_world to whatever you want.
- Delete the second die directive. (die2 msg=”I read nearly all my config file, but not the whole thing!”> ).

Once your sure you are done, press CTRL+X, type Y and then enter.

Related posts

• WoW Ascent Spora Webpage (0)
• WoW Ascent Portal (0)
• Change Ascent PVP Arena type in WoW (0)
• Ascent Database Editor Version 1.0.5 (0)
• Wrath of the Lich King Patch 3.0.8a Released (3)