Forum - DDraceNetwork

How to compile server and set it up with MySQL on Linux
written by Ryozuki, slightly edited by Index

VIDEO
Video not updated to current version COMPILE SERVER
Install packgages with this command:

sudo apt-get install bam libsdl2-dev libfreetype6-dev libcurl4-openssl-dev libogg-dev libopus-dev libopusfile-dev

apt-get install unzip
wget https://github.com/ddnet/ddnet/archive/master.zip
unzip master.zip
cd ddnet-master

ESTABLISH A SERVER WITH MYSQL (Mariadb)
FIrst of all you have to install mySQL and run it. I recommend to press y(es) to all.

Note: In this tutorial we use mariadb, a open-source driven version of mysql with more features and better perfomence. (It's fully compatible with mysql)

sudo apt-get install libmariadbclient-dev libmysqlcppconn-dev libboost-dev mariadb-server
Run mysql_secure_installation and follow the steps, note: it's recommended to set a root password.

On your server config enable mysql and make it load the config:
nano autoexec_server.cfg
sv_use_sql 1
add_sqlserver r database_name "prefix" "user" "password" "localhost" "3306" 1
add_sqlserver w database_name "prefix" "user" "password" "localhost" "3306" 1

What this does?
You need the 2 entries, notice the "w" and the "r", one reads and the other writes to the database.

The prefix is a name prepended to the generated tables (recommended to use "record", it will the generate tables called record_race, record_teamrace, record_points, etc)

• "database_name" is the name of the database, i usually use "teeworlds" or "ddnet"
• The number 3306 is the default mariadb and mysql port.
• The number 1 at the end means "enabled"
• "localhost" is the ip, only change if you have strong reasons, or want to connect to a db on another sv.

Run bam config mysql.use_mysqlconfig=true

Compile the server:
bam server_sql_release

Install screen, so you can run the server after you close the shell.

sudo apt-get install screen
screen ./DDNet-Server_sql -f autoexec_server.cfg

Then you detach it with control+a then control+d

In the last line that should be DDNet-Server_sql I believe.

Thank you for the tuto .
I got an error tho : [16-01-04 14:16:54][console]: failed to open 'maps/Kobra 4.map.cfg'
But the server seem working i'm connected to it

That's not an error. It just checks whether this config file exists, if it doesn't then that's fine.

I reworked the tutorial a bit and soon i'll add a video.

Added video.

Please add date on your first post so that people know that it is up to date.

Chairn wrote:Please add date on your first post so that people know that it is up to date.

What you mean? If you mean the source, on the tutorial post is allways up to date cuz u download master branch. On the vid i downloaded the 10.1 because idk xD

Just add:
Last edited on 14/06/16.

Linux >.<