Migrate Redmine from MySQL to MariaDB

0 Comments

I recently switched from MySQL to MariaDB. As a result my Redmine installation decided to rebel and I, of course, didn’t even notice until a user informed me. The error message that Redmine (ruby actually) threw was not at all cryptic:

“Incorrect MySQL client library version! This gem was compiled for 5.1.63 but the client library is 5.2.13-MariaDB.”

Pretty obvious what the problem is. The problem was how to go about fixing it. I like ruby but I am not a regular ruby admin, programmer or anything. I finally figured out how to get it working though.

By installing the libmariadbclient-dev package you get the /usr/bin/mysql_config file which can then be used to install the mysql2 gem that will get Redmine working again.

apt-get install libmariadbclient-dev
gem1.9.1 install mysql2 -- --with-mysql-config=/usr/bin/mysql_config

Afterwards a simple “service apache2 restart” got Redmine back up and running.

Tags: , , ,

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.