bartgrefte
Posts: 22
Joined: Wed Aug 19, 2015 11:31 am

missing lib's in mariadb

Wed Jul 24, 2019 7:32 am

Yesterday I tried to install (the apparently not available) mysql-server on my Pi Zero W running Raspbian Buster, it seems MariaDB is now default.

After installing MariaDB twice, the first attempt ended with phpmyadmin not having privileges to create databases, I managed to get it to work, just not with the program I installed it for.

There's an old weather station hooked up to the Pi and the program that can read data from it has the capability of storing it in a database, that's where I get stuck.

The program is complaining about not being able to find "libmysqlclient.so.18 or libmysqlclient.so".

If I had to guess, those aren't included with MariaDB but are with mysql-server/mysql-client? Looks like the same problem as https://jira.mariadb.org/browse/MDEV-19568

edit: Solved it by doing

Code: Select all

sudo apt install libmariadb-dev
sudo ln -s /usr/lib/arm-linux-gnueabihf/libmariadbclient.so /usr/lib/arm-linux-gnueabihf/libmysqlclient.so
Now I've got a new MySQL/MariaDB related problem:

Code: Select all

TMySQL56Connection can not work with the installed MySQL client version: Expected (5.6), got (10.3.15).

fruitoftheloom
Posts: 20495
Joined: Tue Mar 25, 2014 12:40 pm
Location: Delightful Dorset

Re: missing lib's in mariadb

Wed Jul 24, 2019 11:15 am

bartgrefte wrote:
Wed Jul 24, 2019 7:32 am
Yesterday I tried to install (the apparently not available) mysql-server on my Pi Zero W running Raspbian Buster, it seems MariaDB is now default.

After installing MariaDB twice, the first attempt ended with phpmyadmin not having privileges to create databases, I managed to get it to work, just not with the program I installed it for.

There's an old weather station hooked up to the Pi and the program that can read data from it has the capability of storing it in a database, that's where I get stuck.

The program is complaining about not being able to find "libmysqlclient.so.18 or libmysqlclient.so".

If I had to guess, those aren't included with MariaDB but are with mysql-server/mysql-client? Looks like the same problem as https://jira.mariadb.org/browse/MDEV-19568

edit: Solved it by doing

Code: Select all

sudo apt install libmariadb-dev
sudo ln -s /usr/lib/arm-linux-gnueabihf/libmariadbclient.so /usr/lib/arm-linux-gnueabihf/libmysqlclient.so
Now I've got a new MySQL/MariaDB related problem:

Code: Select all

TMySQL56Connection can not work with the installed MySQL client version: Expected (5.6), got (10.3.15).

Raspbian Stretch moved to MariaDB from MySQL, as Raspbian is based of Debian ARMHF:

https://mariadb.com/kb/en/library/movin ... -debian-9/
Retired disgracefully.....

bartgrefte
Posts: 22
Joined: Wed Aug 19, 2015 11:31 am

Re: missing lib's in mariadb

Thu Jul 25, 2019 5:08 pm

fruitoftheloom wrote:
Wed Jul 24, 2019 11:15 am
Raspbian Stretch moved to MariaDB from MySQL, as Raspbian is based of Debian ARMHF:

https://mariadb.com/kb/en/library/movin ... -debian-9/
Ah, okay. Guess I didn't notice that on a different Pi since the other one isn't running programs looking for specific MySQL versions.

I don't suppose you (or anyone else) happens to know how to get around

Code: Select all

TMySQL56Connection can not work with the installed MySQL client version: Expected (5.6), got (10.3.15).
without having to wait for the app-developer to fix this? I'm hoping this can be as fixed as easily as the missing lib's.

Return to “Raspbian”