[Ascent][Linux]Tutorial - How To Create a Server

[sebkinne]

Hello everyone, since so many people have been requesting a tut, here it is : >

Firstly, i would recomend debian for running an ascent wow server.
I will firstly only explain for debian and debian based OSs', so you might have to modify the commands a little.

first, go into your terminal and type:

sudo apt-get update

This updates your os.

Now we will need to get a few packages that are required for the compiling proccess of your ascent server.

1.1. mysql. this is of course very important ;)
if you do not have it set up, do:

sudo apt-get install mysql

sudo apt-get install libmysql++-dev

1.2. now you will want to set a mysql passwrd

mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
SET PASSWORD FOR 'root'@'%' = PASSWORD('newpwd');

write your password into the newpwd.
if you are having problems, please post here, ill help individually.

1.3.Now you will need to get create a db. do this by executing these in the mysql promt.

create database world;

create database logon;

create database characters;

quit

1.4 Now some of us will need the ssl package. Get this by typing:

sudo apt-get install openssl

2. you will need the build essentials for compiling so:

sudo apt-get install build-essential

OR

sudo apt-get install build-essentials

3. you will need subversion (to get the source)

sudo apt-get install subversion

4. you will need automake and make if they are not currently installed:

sudo apt-get install make

sudo apt-get install automake

4.1. Some of you will need to get the libtool.

sudo apt-get install libtool

5. now we will want to get the source. do:

cd /dir/you/choose/your/server/to/be/in/

svn co http://mmoforge.org/svn/ascent/

If it promts you for a password, the user is: anonymous
and the pass is left blank


6. Now we will start to compile.
-choose what rev u wna compile, i would suggest the trunk
-so:

cd trunk

-make the dirs.

mkdir bin

mkdir etc

-

autoreconf --force --install

- now we need it to configure the comming compile:

./configure

- now do:

make

This may take a while!
-

make install

7. after this is done, cd into the bin folder.
copy conf files to the newly made "etc" directory
example : cp src/*.conf etc/


8. now you wna edit your conf files so:

vim ascent-world.conf

edit this by pressing " i " (to get out of editing press esc) change the conf to your needs.
do this for all your confs, and thats it for them. To then save the file:

:wq!

9. now copy your "DBC", "maps", and "scripts" folders into the trunk/bin/ folder.
DBC FILES enGB
Maps enGB
The scripts i do not currently have here, ill post later.


10.Now we will need to import the sql files. Lets start with the world file
do this by executing the following command:

mysql -h localhost -u root -p world < /path/to/your/sql-file/2785_world_structure.sql

Now our logon db (also called account db):

mysql -h localhost -u root -p logon < /path/to/your/sql-file/2785_logon_structure.sql

And finally your character db:

mysql -h localhost -u root -p character < /path/to/your/sql-file/2785_character_structure.sql

Normally your path is where_your_ascent_is/trunk/sql/


11. Now forward the ports on your router to make it accessible. you might have to forward a couple of other ports if it doesnt work.
3724 - 3724
80 - 80
3306 - 3306
8129 - 8129
8093 - 8093
6112 - 6112
6881 - 6999
3036 - 3036
8050 - 8050


12. great. start ur server.

cd trunk/bin/

./ascent-logonserver

./ascent-world

[B]

[MentaL]

[Juggalo90]

Very nice man....when i switch to linux ill try this out

[Sprayaz]

Great guide I will be trying this guide out very soon on Ubuntu. Will let you know how it goes, get ready for the kids to start installing Unix and screwing up there servers/computers and start to blame you or ask 100000 things they could google.

[Juggalo90]

If noobs fuck up PC by installing Unix/Linux...No more noobs XD

[ovidel]

linux is better than others because it don't take resources?

[sebkinne]

Yea, i hope it helps....i will be adding some things soon, like scripts etc, also an example of a conf / a tutorial on how to use dynamic dns.

I hope it helps people, and im happy tp answer any questions

[sebkinne]

oh and @ ovidel

linux is better because it generally runs more stable, it runs safer, and is just overall a better server.

And at all the people trying this tut, please let me know if it helped, and if you have any problems post them.

thank you,

Seb

[tziku]

checking for mysql_init in -lmysqlclient... no
checking for mysql_init in -lmysql... no
configure: error: Missing mysql


cs:/usr/wow/trunk# mysql --version
mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2

cs:/usr/wow/trunk# uname -a
Linux cs.fastinternet.ro 2.6.8-3-686 #1 Tue Dec 5 21:26:38 UTC 2006 i686 GNU/Linux

cs:/usr/wow/trunk# cat /etc/issue
Debian GNU/Linux 4.0 \n \l

cs:/usr/wow/trunk# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1154
Server version: 5.0.32-Debian_7etch3-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit;
Bye

[trunks94]

Very nice man :)

[sebkinne]

Hello,

@tziku
yea, you are missing the developnment files.
get it by typing

sudo apt-get install libmysql++-dev

Then run

./configure

again. that should do.

And thanks trunk94, really apreciate it

Regards,
sebkinne

[Forseakyn]

Hi,

First of the guide is great! But could you explain how to import the database files into MySQL in Linux?

Thanks.

[sebkinne]

I added how to make and import the sql files.

Hope it helps,
seb

[sebkinne]

Ok, new edit:

added a how-to for a Web-server and how-to for SPORA

[RedLink]

I got a error while executing the autoreconf command,

configure.ac:23: error: possibly undefined macro: AC_PROG_LIBTOOL
If this token and others are legitimate, please use m4_pattern_allow.
See the Autoconf documentation.

I fixed this by installing the package libtool

$ sudo apt-get install libtool

I thougt this might be helpful =)

Anyway, thx for a great guide^^

[sebkinne]

Thank you, i totally forgott about that package o0
ill add it now, thank you,

regards,
sebkinne