MariaDB: Difference between revisions

From Onset Developer Wiki
No edit summary
No edit summary
Line 12: Line 12:
Install the following package on the target system.
Install the following package on the target system.
<syntaxhighlight lang="bash">
<syntaxhighlight lang="bash">
apt-get install libmariadbclient-dev
apt-get install libmariadb-dev
</syntaxhighlight>
</syntaxhighlight>
On newer Ubuntu versions this package is called '''libmariadb-dev'''.
On newer Ubuntu versions this package is called '''libmariadb-dev'''.

Revision as of 14:02, 19 December 2022

Installation

Open the server_config.json file and add mariadb to the plugins.

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.

apt-get install libmariadb-dev

On newer Ubuntu versions this package is called libmariadb-dev.

Ubuntu 19 & Ubuntu 20 Notice

On Ubuntu 19/20 you might need to create a link to the correct libmariadbclient.

cd /usr/lib/x86_64-linux-gnu
sudo ln -s libmariadbclient.so libmariadbclient.so.18

Compiling from source

Recommended requirements

Windows

Download the MariaDB C/C++ Connector 64bit for Windows from https://mariadb.com/downloads/#connectors Download boost and extract it.

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_81_0" -DCMAKE_GENERATOR_PLATFORM=x64 .

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

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

Ubuntu

apt-get install libmariadb-dev
git clone https://github.com/BlueMountainsIO/PluginMariaDB.git
cd PluginMariaDB
cmake -DMARIADBCAPI_INCLUDE_DIR=/usr/include/mariadb -DMARIADBCAPI_LIBRARY=/usr/lib/x86_64-linux-gnu/libmariadbclient.so -DBOOST_ROOT=/usr/include/boost_1_81_0 -DBUILD_STATIC=OFF .
make

For static builds you can do:

cmake -DMARIADBCAPI_INCLUDE_DIR=/usr/include/mariadb -DMARIADBCAPI_LIBRARY=/usr/lib/x86_64-linux-gnu/libmariadbclient.a -DBOOST_ROOT=/usr/include/boost_1_81_0 -DBUILD_STATIC=ON .