MariaDB - Revision history

BlueMountains at 14:06, 19 December 2022

2022-12-19T14:06:34Z

← Older revision		Revision as of 14:06, 19 December 2022
Line 9:		Line 9:
	The MariaDB plugin can connect to MySQL 5.x and MariaDB 10.x servers. But it can not connect to MySQL 8.x servers.		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===		===Linux (Ubuntu)===
	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 libmariadb-dev		apt-get install libmariadb-dev
	</syntaxhighlight>		</syntaxhighlight>
	~~On newer Ubuntu versions this package is called '''libmariadb-dev'''.~~

	====Ubuntu 19 & Ubuntu 20 Notice====		====Ubuntu 19 & Ubuntu 20 Notice====

BlueMountains at 14:02, 19 December 2022

2022-12-19T14:02:24Z

← Older revision		Revision as of 14:02, 19 December 2022
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'''.

BlueMountains at 13:13, 19 December 2022

2022-12-19T13:13:07Z

← Older revision		Revision as of 13:13, 19 December 2022
Line 47:		Line 47:
	===Ubuntu===		===Ubuntu===
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	apt-get install ~~libmariadbclient~~-dev		apt-get install libmariadb-dev
	git clone https://github.com/BlueMountainsIO/PluginMariaDB.git		git clone https://github.com/BlueMountainsIO/PluginMariaDB.git
	cd PluginMariaDB		cd PluginMariaDB
Line 58:		Line 58:
	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 .		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 .
	</syntaxhighlight>		</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.~~

BlueMountains at 13:07, 19 December 2022

2022-12-19T13:07:16Z

← Older revision		Revision as of 13:07, 19 December 2022
Line 50:		Line 50:
	git clone https://github.com/BlueMountainsIO/PluginMariaDB.git		git clone https://github.com/BlueMountainsIO/PluginMariaDB.git
	cd PluginMariaDB		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_81_0 -DBUILD_STATIC=OFF .		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		make
	</syntaxhighlight>		</syntaxhighlight>
Line 56:		Line 56:
	For static builds you can do:		For static builds you can do:
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	cmake -DMARIADBCAPI_INCLUDE_DIR=/usr/include/~~mysql~~ -DMARIADBCAPI_LIBRARY=/usr/lib/x86_64-linux-gnu/~~libmariadbclient_r~~.a -DBOOST_ROOT=/usr/include/boost_1_81_0 -DBUILD_STATIC=ON .		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 .
	</syntaxhighlight>		</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.		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.

BlueMountains at 13:05, 19 December 2022

2022-12-19T13:05:16Z

← Older revision		Revision as of 13:05, 19 December 2022
Line 35:		Line 35:
	git clone https://github.com/BlueMountainsIO/PluginMariaDB.git		git clone https://github.com/BlueMountainsIO/PluginMariaDB.git
	cd PluginMariaDB		cd PluginMariaDB
	cmake -DMARIADBCAPI_INCLUDE_DIR="C:\Program Files\MariaDB\MariaDB Connector C 64-bit\include" -DBOOST_ROOT="D:\Lib\~~boost_1_78_0~~" -DCMAKE_GENERATOR_PLATFORM=x64 .		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 .
	</syntaxhighlight>		</syntaxhighlight>

BlueMountains at 13:02, 19 December 2022

2022-12-19T13:02:08Z

← Older revision		Revision as of 13:02, 19 December 2022
Line 41:		Line 41:
	Right click on the solution and hit rebuild.		Right click on the solution and hit rebuild.

	[[File:~~BuildMariaDBPluginWindows~~.png]]		[[File:BuildMariaDBPluginWindowsVS2022.png]]

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

BlueMountains at 12:59, 19 December 2022

2022-12-19T12:59:34Z

← Older revision		Revision as of 12:59, 19 December 2022
Line 30:		Line 30:

	===Windows===		===Windows===
	Download the MariaDB C/C++ Connector from https://mariadb.com/downloads/#connectors		Download the MariaDB C/C++ Connector 64bit for Windows from https://mariadb.com/downloads/#connectors
			Download boost and extract it.
	<syntaxhighlight lang="batch">		<syntaxhighlight lang="batch">
	git clone https://github.com/BlueMountainsIO/PluginMariaDB.git		git clone https://github.com/BlueMountainsIO/PluginMariaDB.git
	cd PluginMariaDB		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 .		cmake -DMARIADBCAPI_INCLUDE_DIR="C:\Program Files\MariaDB\MariaDB Connector C 64-bit\include" -DBOOST_ROOT="D:\Lib\boost_1_78_0" -DCMAKE_GENERATOR_PLATFORM=x64 .
	</syntaxhighlight>		</syntaxhighlight>

BlueMountains at 21:14, 18 December 2022

2022-12-18T21:14:05Z

← Older revision		Revision as of 21:14, 18 December 2022
Line 24:		Line 24:

	==Compiling from source==		==Compiling from source==
	~~Minimum~~ requirements		Recommended requirements
	* CMake > 3.1 (https://cmake.org)		* CMake > 3.1 (https://cmake.org)
	* Boost 1.73.0 (https://boost.org)		* Boost 1.81.0 (https://boost.org)
	* Visual Studio ~~2019~~ (Windows) or GCC 7 (Linux)		* Visual Studio 2022 (Windows) or GCC 11 (Linux)

	===Windows===		===Windows===
Line 49:		Line 49:
	git clone https://github.com/BlueMountainsIO/PluginMariaDB.git		git clone https://github.com/BlueMountainsIO/PluginMariaDB.git
	cd PluginMariaDB		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_73_0~~ -DBUILD_STATIC=OFF .		cmake -DMARIADBCAPI_INCLUDE_DIR=/usr/include/mysql -DMARIADBCAPI_LIBRARY=/usr/lib/x86_64-linux-gnu/libmariadbclient.so -DBOOST_ROOT=/usr/include/boost_1_81_0 -DBUILD_STATIC=OFF .
	make		make
	</syntaxhighlight>		</syntaxhighlight>
Line 55:		Line 55:
	For static builds you can do:		For static builds you can do:
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	cmake -DMARIADBCAPI_INCLUDE_DIR=/usr/include/mysql -DMARIADBCAPI_LIBRARY=/usr/lib/x86_64-linux-gnu/libmariadbclient_r.a -DBOOST_ROOT=/usr/include/~~boost_1_73_0~~ -DBUILD_STATIC=ON .		cmake -DMARIADBCAPI_INCLUDE_DIR=/usr/include/mysql -DMARIADBCAPI_LIBRARY=/usr/lib/x86_64-linux-gnu/libmariadbclient_r.a -DBOOST_ROOT=/usr/include/boost_1_81_0 -DBUILD_STATIC=ON .
	</syntaxhighlight>		</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.		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.

BlueMountains at 09:29, 5 February 2022

2022-02-05T09:29:46Z

← Older revision		Revision as of 09:29, 5 February 2022
Line 14:		Line 14:
	apt-get install libmariadbclient-dev		apt-get install libmariadbclient-dev
	</syntaxhighlight>		</syntaxhighlight>
			On newer Ubuntu versions this package is called '''libmariadb-dev'''.

	====Ubuntu 19 & Ubuntu 20 Notice====		====Ubuntu 19 & Ubuntu 20 Notice====

BlueMountains at 18:34, 8 December 2020

2020-12-08T18:34:36Z

← Older revision		Revision as of 18:34, 8 December 2020
Line 24:		Line 24:
	==Compiling from source==		==Compiling from source==
	Minimum requirements		Minimum requirements
	* CMake 3.1 (https://cmake.org)		* CMake > 3.1 (https://cmake.org)
	* Boost 1.69 (https://boost.org)		* Boost 1.73.0 (https://boost.org)
	* Visual Studio ~~2017~~ (Windows) or GCC 7 (Linux)		* Visual Studio 2019 (Windows) or GCC 7 (Linux)

	===Windows===		===Windows===