Compiling rAthena for MariaDB 10.1 in CentOS 7 (x64) - configure: error: MySQL not found or incompatible

[Latheesan]

I am trying to compile rAthena on CentOS 7 64-Bit OS; but I want to use MariaDB 10.1 (instead of MySQL, since it's a fork and should work the same).

 

When I run the ./configure --enable-64bit command, I see the following error:

...checking for library containing pthread_cancel... none required
checking for library containing pthread_join... none required
checking for mysql_config... /usr/bin/mysql_config
checking for mysql_init in -lmysqlclient... no
checking mysql.h usability... yes
checking mysql.h presence... yes
checking for mysql.h... yes
checking MySQL library (required)... no
configure: error: MySQL not found or incompatible

Prior to starting the installation, I have made sure the following packages are installed: yum install -y mysql-devel pcre-devel zlib-devel;

[root@server host]# yum install -y mysql-devel pcre-devel zlib-devel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.sov.uk.goscomb.net
 * epel: mirrors.coreix.net
 * extras: centos.serverspace.co.uk
 * remi-safe: remi.check-update.co.uk
 * updates: repo.bigstepcloud.com
Package MariaDB-devel-10.1.10-1.el7.centos.x86_64 already installed and latest version
Package pcre-devel-8.32-15.el7.x86_64 already installed and latest version
Package zlib-devel-1.2.7-15.el7.x86_64 already installed and latest version
Nothing to do

I checked the /usr/lib64/ folder and I can see the libmysqlclient dev binaries:

[root@server host]# ls /usr/lib64/ | grep mysql
libmysqlclient.a
libmysqlclient_r.a
libmysqlclient_r.so
libmysqlclient_r.so.18
libmysqlclient_r.so.18.0.0
libmysqlclient.so
libmysqlclient.so.18
libmysqlclient.so.18.0.0
libmysqld.a
libmysqld.so
libmysqld.so.18
libmysqlservices.a

So, I tried to configure the installation like this: ./configure --enable-64bit --with-MYSQL_LIBS=/usr/lib64

 

However, this too did not work. Any ideas what I might be doing wrong? Is MariaDB not supported with rAthena?

 

This is how I installed MariaDB 10.1 on my CentOS 7 (x64):

wget -O /etc/yum.repos.d/MariaDB.repo http://mariadb.if-not-true-then-false.com/centos/$(rpm -E %centos)(uname -i)/10_1
yum install MariaDB MariaDB-server

Thanks in advance for any help & happy new year to the community.

 

UPDATE:

Sorry, posted this question too soon. This has fixed my issue:

./configure --enable-64bit --with-MYSQL_LIBS=/usr/lib64/libmysqlclient.so

Edited January 1, 2016 by Latheesan

[brunoshp]

use this friend!

Quote

apt install gcc
apt install g++
apt install mariadb_server
apt install zlib-devel
apt-get install libmariadb*
apt install default-libmysqlclient-dev
apt-get install zlib1g-dev
apt install make
 

 

[THPO]

Thank you worked for me

[Keanu]

It's taken me far too long to figure this out, just incase anyone else gets into a bind like I was

/sbin/ldconfig -p | grep mysql | cut -d\> -f2

(Side note - I'm using Debian)

It located my libmysqlclient.so for me, popped it into the command and it worked straight away.

-Keanu

Edited September 14, 2017 by Keanu

[Lighta]

This is weird that he didn't found / check usr/lib64 tough.

Does the same issue appear with cmake ? he seem to resolve fine for me. (using mariadb on fedora)

 

[YJ1994]

use this if you're running maria-db v10+ on centos 7 

yum install MariaDB-shared