[Ascent][Linux]Please

[ovidel]

For who can...plase compile one to me or say to me one who is compiled...and say to me how to make the mysql because i cannot make it run...thanks.I have ubuntu 7.10

[MentaL]

[gspat]

wow.. need a bit of info from you...

What linux distro? version?

usually, when you are setting up mysql, you'll just get the latest version from the repositories using the commands specific to your distribution. In my case, I use the Ubuntu distribution so I will use a command like:

sudo apt-get install mysql libmysql++-dev

to install what I need... If you use a different distribution it may/may not be different.

The newest version of Ubuntu already has mysql installed for you, so it does not need to be configured. The username will be "root" and the password will be whatever you use as a password to log in to your home account.

to create the databases you need you just have to start up mysql at the cli and enter the commands.

In my case:

-- Open a terminal and start up mysql --

mysql -u root -p

-- the program will start and ask you for your password, enter it and you can start adding the databases --

create database world; 

create database logon; 

create database characters; 

quit

Now you can start adding the .sql files to the databases.

usually, when you are adding the .sql files in... it's the same regardless whether you use Linux/MS at the command line (aka cli.. or Command Line Interface)

example command:

mysql -u <username> -p <db_name> < </path/to/sql/file/file.sql>

where:

<username> = The user name you set up when you created your database

<db_name> = The name of the table in your database you are adding the sql file into

</path/to/sql/file/file.sql> = the path to the .sql files and the .sql file name

I would suggest for simplicity sake, you cd into the folder of the .sql files first, it saves you a bunch of typing...

so.. as per the example, let's say you have your MySQL set up using the user name of "George" and a password of "firefly" and your .sql files are at "/home/ovidel/sources/ascent/trunk/sql" and you want to add a .sql file into your database called "9999_Not_a_real_update.sql" to a table called "example_db" then the command(s) would look like the following (do not add the lines starting or ending in --)...

-- This is to change your working directory to where the .sql files are --

cd /home/ovidel/sources/ascent/trunk/sql

-- This will add the .sql file to the database --

mysql -u george -p example_db < 9999_Not_a_real_update.sql

-- When you press enter it will ask you for your password... in this case "firefly" --

that's it.. that's all there is to it... just remember when you set up your database what the basic database structure is... most people will only have one location for their database, this will contain tables. The tables will contain fields, and the fields will contain records.

Some people have multiple database locations (the databases split up onto different computers), but for our purposes (and 98% of people as well) you will never need more than one.

For our purposes, the databases will be named "world", "logon" and "characters" - if you go by the examples.

For a more complete description, do a google search for mysql for beginners.

Hope this helped you!!!

[ovidel]

i have ubuntu 7.10...but how i start the server(ascent) :-S ... and at mysql..Couldn't find package mysql... can you say to me your ID ?

[gspat]

For Ubuntu 7.10, the command you want to use is:

sudo apt-get install mysql-client-5.0 libmysql++-dev

to start the server, you have to cd into the bin folder you compiled it into and run it using:

For the logon server:

./ascent-logonserver

For the world server:

./ascent-world

[ovidel]

thx

[sebkinne]

if however all this does not work....
use my guide in the sicky?
lol

regards,
seb