MariaDB

2020-05-23T16:17:08Z

Night: /* Ubuntu 19 Notice */

==Installation==
Open the ''server_config.json'' file and add '''mariadb''' to the plugins.

[[File:mariadb_installation.JPG]]
===Windows===
Make sure to have the file ''libmariadb.dll'' in the same directory as ''OnsetServer.exe''.
You can find that file in the Server folder delivered with the game.

The MariaDB plugin can connect to MySQL 5.x and MariaDB 10.x servers. But it can not connect to MySQL 8.x servers.

===Linux===
Install the following package on the target system.
<syntaxhighlight lang="bash">
apt-get install libmariadbclient-dev
</syntaxhighlight>

====Ubuntu 19 & Ubuntu 20 Notice====
On Ubuntu 19/20 you might need to create a link to the correct libmariadbclient.
<syntaxhighlight lang="bash">
cd /usr/lib/x86_64-linux-gnu
sudo ln -s libmariadbclient.so libmariadbclient.so.18
</syntaxhighlight>

==Compiling from source==
Minimum requirements
* CMake 3.1 (https://cmake.org)
* Boost 1.69 (https://boost.org)
* Visual Studio 2017 (Windows) or GCC 7 (Linux)

===Windows===
Download the MariaDB C/C++ Connector from https://mariadb.com/downloads/#connectors
<syntaxhighlight lang="batch">
git clone https://github.com/BlueMountainsIO/PluginMariaDB.git
cd PluginMariaDB
cmake -DMARIADBCAPI_INCLUDE_DIR="C:\Program Files\MariaDB\MariaDB Connector C 64-bit\include" -DBOOST_ROOT="D:\Lib\boost_1_71_0" -DCMAKE_GENERATOR_PLATFORM=x64 .
</syntaxhighlight>

Open the generated mariadb.sln file and select "Release" as build target.
Right click on the solution and hit rebuild.

[[File:BuildMariaDBPluginWindows.png]]

The .dll will be under ''PluginMariaDB\src\Release''.

===Ubuntu===
<syntaxhighlight lang="bash">
apt-get install libmariadbclient-dev
git clone https://github.com/BlueMountainsIO/PluginMariaDB.git
cd PluginMariaDB
cmake -DMARIADBCAPI_INCLUDE_DIR=/usr/include/mysql -DMARIADBCAPI_LIBRARY=/usr/lib/x86_64-linux-gnu/libmariadbclient.so -DBOOST_ROOT=/usr/include/boost_1_71_0 -DBUILD_STATIC=OFF .
make
</syntaxhighlight>

For static builds you can do:
<syntaxhighlight lang="bash">
cmake -DMARIADBCAPI_INCLUDE_DIR=/usr/include/mysql -DMARIADBCAPI_LIBRARY_STATIC=/usr/lib/x86_64-linux-gnu/libmariadbclient_r.a -DBOOST_ROOT=/usr/include/boost_1_71_0 -DBUILD_STATIC=ON .
</syntaxhighlight>
The reason why we use ''libmariadbclient-dev'' over ''libmariadb-dev'' is because the latter does have a wrong hardcoded path for the mysql.sock file.

Onset Developer Wiki - User contributions [en]

MariaDB