Latest MariaDB repo data seems to be incompatible with Debian 9

**TheRiddler1982** · Nov 2nd 2019

Hi all,

first of all, I am using the latest version of I-MSCP and Debian 9 (9.9). I set up I-MSCP from a clean Debian install (9.7). During I-MSCP setup I have chosen to use MariaDB 10.2:

Code

root@cloudserv111:~# service mysql status
● mariadb.service - MariaDB 10.2.25 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2019-10-31 02:09:12 CET; 2 days ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 1979 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1948 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Process: 997 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POS
Process: 988 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 941 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 1184 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 39 (limit: 36864)
Memory: 342.2M
CPU: 5min 16.937s
CGroup: /system.slice/mariadb.service
└─1184 /usr/sbin/mysqld

Display More

However, since about a month, MariaDB updates are not installed due to incompatibility (see attached screenshot from the console):

pasted-from-clipboard.png

I have not altered any apt sources manually. The one currently in use for MariaDB comes from the I-MSCP installation:

Code

deb http://mirror.netcologne.de/mariadb/repo/10.2/debian stretch main
deb-src http://mirror.netcologne.de/mariadb/repo/10.2/debian stretch main

Strech is the right distro name for version 9. I have googled about the library and for some reason the new requested version only runs with Debian 10. How is it possible that a repo built against Debian 9 requests Debian 10 dependencies? Aptitude offers some solutions. As the packages are part of I-MSCP I do not know what to do. Could you help me solve this conflict, i.e. update MariaDB without destroying I-MSCP?

Thanks

**Nuxwin** · Nov 2nd 2019

Good morning,

Please show us the APT preferences files from your /etc/apt/preferences.d directory and also the content of any file in the /etc/apt/sources.list.d directory.

If you cannot figure out alone, give us access to your server.

**TheRiddler1982** · Nov 3rd 2019

Hi Nuxwin,

sorry for the late reply, as I had no access to my server. Here is the answer:

/etc/apt/preferences.d

Code

Package: libmariadbclient18
Pin: release o=Debian,n=stretch
Pin-Priority: 1002
Package: *
Pin: release o=MariaDB,n=stretch
Pin-Priority: 1001
Package: *
Pin: origin packages.sury.org
Pin-Priority: 1001

Display More

And the sources.d files:

mod-pagespeed.list

Code

### THIS FILE IS AUTOMATICALLY CONFIGURED ###
# You may comment out this entry, but any other modifications may be lost.
deb http://dl.google.com/linux/mod-pagespeed/deb/ stable main

nginx.list

Code

deb http://nginx.org/packages/debian/ stretch nginx
deb-src http://nginx.org/packages/debian/ stretch nginx

Thanks again!

**freedom** · Nov 8th 2019

Hello together,

is there any known incompatibility with I-MSCP, Debian Stretch (9.11) and MariaDB 10.2? We're currently using MariaDB 10.1.41 from the first installation of I-MSCP on our new server. Now we would like to switch to MariaDB 10.2, using the autoinstaller, because it's a software requirement for one of our web services. I found this thread and a lot of information regarding i-mscp is compatible with MariaDB 10.2, but I would like to make sure there's no surprise waiting for me.

So my questions would be:

Is this a real bug regarding debian stretch and i-mscp 10.2 or is this a local problem? Unfortunately there was no update since november 3rd.
I guess the switch would be going with the autoinstaller using perl imscp-autoinstall -dr sql. Is this correct?

Thank you for any additional information.

**DrCarsonBeckett** · Nov 8th 2019

IF you are on mariadb already, then you dont need to reconfigure i-MSCP. As far as I know.

**kess** · Nov 8th 2019

Well, in effect there have been some changes in MariaDB repo since last year. You have to change a couple of things in order to upgrade to MariaDB 10.2 from MariaDB 10.1 on Debian Stretch.

1. Before proceding, make sure you have your MariaDB root password

2. Remove the package pinning for libmariadbclient18 from /etc/apt/preferences.d/imscp

3. cd to your imscp setup directory: /usr/local/src/imscp-1.5.3-2018120800

4. Edit autoinstaller/Packages/debian-stretch.xml and change in the section "mariadb_10.2" -> <package>libmariadbclient18</package> from the package pin

Then you should be able to run perl imscp-autoinstall -dr sql

Edit: Step 2 corrected from libmysqlclient18 to libmariadbclient18

**Nuxwin** · Nov 9th 2019

Quote from kess

Well, in effect there have been some changes in MariaDB repo since last year. You have to change a couple of things in order to upgrade to MariaDB 10.2 from MariaDB 10.1 on Debian Stretch.

1. Before proceding, make sure you have your MariaDB root password

2. Remove the package pinning for libmysqlclient18 from /etc/apt/preferences.d/imscp

3. cd to your imscp setup directory: /usr/local/src/imscp-1.5.3-2018120800

4. Edit autoinstaller/Packages/debian-stretch.xml and change in the section "mariadb_10.2" -> <package>libmariadbclient18</package> from the package pin

Then you should be able to run perl imscp-autoinstall -dr sql

Display More

I love you.

**kess** · Nov 9th 2019

Quote from Nuxwin

I love you.

Every girl tells me the same

**freedom** · Nov 11th 2019

Hi kess and Nuxwin,

I checked the files from your instructions and did the following changes:

Removed libmariadbclient18 from /etc/apt/preferences.d/imscp
Removed the same package pinning in the autoinstaller for MariaDB 10.2 as done here (https://github.com/i-MSCP/imsc…6199c4c6d24b0fc8b253bf379)
Switched to MariaDB 10.2 with perl imscp-autoinstall -dr sql

I can confirm, your instructions work as expected and the problem from the first post seems to be related. I have now MariaDB 10.2.29 and no pending updates from apt update. Thank you very much.

PS: In the instructions above, you used libmysqlclient18 instead of libmariadbclient18, thats why I was confused first. But after I saw the commit on GitHub I understood your instructions. Thank you both!

**kess** · Nov 11th 2019

Glad you fixed, ant thank you for pointing me out my typo error.

Step 2 corrected

Latest MariaDB repo data seems to be incompatible with Debian 9

Share

Daily visitors