Skip to content

Database setup

Jump to bottom
Alexander Olk edited this page Feb 23, 2021 · 8 revisions

Domination supports extDB3 from torndeco and Intercept DB from Dedmen Miller.

The following is based on the free mySQL database mariaDB

  1. You need to download the required files

  2. Install mariadb (and don't forget to install the HeidiSQL tool from mariadb too)

    • For extDB3, install @extDB3 (from the extDB3 download not from the Domination 7z) into your Arma 3 server folder (don’t forget to copy the tbbmalloc dll files, both, from your extDB3 download to the A3 server folder or A3 game folder for a host).
    • For InterceptDB, copy @InterceptDB (from the InterceptDB download not from Domination 7z) into your Arma 3 server folder. InterceptDB also needs CBA so don’t forget that one.

  4. Open HeidiSQL and connect as root to the database (root password is set during mariaDB installation).

    • Choose File->Execute SQL and select the Domination.sql file which you can find inside the Domination 7z File (I hope it is File->Execute SQL as I only have the german version of HeidiSQL). This should create the Domination database.

    • Now open the user management in Tools (still HeidiSQL) and create a new user. It’s up to you how you name this new user. Just make sure that you add the Domination object (green button on the right, new object?) and give the user the following rights/credentials:

    • DB Rights/Credentials

extDB3

5. Copy the domination-custom.ini file from the Domination 7z download @extDB3\sql_custom folder to the @extDB3\sql_custom folder in your Arma 3 server directory

  1. Do the same with the extdb3-conf.ini file from the Domination 7z download @extDB3 folder. Copy it to the @extDB3 folder in your Arma 3 server directory

  2. Open extdb3-conf.ini in your Arma 3 @extDB3 folder with a text editor and add the Domination user and the password for the Domination user (the ones from mariaDB that you set with HeidiSQL. Don't use your root user and password!).

    [Domination]
    IP = 127.0.0.1
    Port = 3306
    Username = yourdbuserwithaccesstodominationdb
    Password = thepasswordofthedatabaseuser
    Database = domination

  3. Now start your server with -servermod=@extDB3 and DB support should work as soon as you start the mission.


InterceptDB

5. Copy the config.yaml and domination.sqf files from the Domination 7z @InterceptDB folder to your @InterceptDB folder in your Arma 3 server directory

  1. Open the config.yaml file in your Arma 3 server @InterceptDB folder with a text editor and add the Domination user and the password for the Domination user (the ones from mariaDB that you set with HeidiSQL. Don't use your root user and password!).

    accounts:
    domination: #production db, don't break things here!
    ip: 127.0.0.1
    username: yourdbuserwithaccesstodominationdb
    password: thepasswordofthedatabaseuser
    database: domination
    port: 3306 #optional

  2. Now start your server with -servermod=@InterceptDB -mod=@CBA -filepatching (don’t forget -filepatching otherwise it won’t work)


The first run of the mission will add all available Params from the mission to the dom_params2 table. You are now able to change all params directly in the database dom_params2 table. Please don't forget that the values in dom_params2 table will always overwrite the params a logged in admin may choose in server lobby or changes you've made to description.ext!!!

Now player stats will be saved to the players table in the database and mission progress can be saved to a missionsave table (from inside the mission or automatically).

Clone this wiki locally