Issue Installing mariaDB Ubuntu16.04 Plesk17.5

[Julian Kallidat]

Hello experts,

I checked the search function of the forum and google. So far I couldn't resolve my issue.

I would would like to switch to mariaDB and planned to do so after updating to Plesk 17.5 which I run on Ubuntu 16.04 LTS. I followed this Instruction Database Server

Including step three are no problems.
Then I try:

env DEBIAN_FRONTEND=noninteractive apt-get -o OrderList::Score::Immediate=1000 install libmariadbclient18 mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server mariadb-server-10.1 mariadb-server-core-10.1



So according to the dokumentation and other posts in this forum I tried following command:
dpkg -i --force-overwrite /var/cache/apt/archives/mariadb-server-10.1_10.1.24+maria-1~xenial_am d64.deb

Ends up to


dpkg --configure -a



apt-get install -f



And what to do now?

Help is appreciated. Any other Information needed?

Warm regards
Julian

 

[Cike76]

Did you end up installing socat?
In the third image says its a dependency...

 

[Julian Kallidat]

Sorry for comming back to this so late. Still getting the same error... Even with dependencies installed

 

[UFHH01]

Hi Julian Kallidat,

if you desire help with your investigations ( and to get possible suggestions and solutions! ), you should consider to include the corresponding ( actual! ) log - files, or/and should paste the commands from your command line into a CODE - bracket - box, so that people willing to help you are able to use as well "copy&paste" - to point you to your issues/errors/problems and are the able to answer with possible solutions/suggestions.

=> Plesk for Linux services logs and configuration files ( KB - article: 213403509 )​

 

[B4c4rd1]

My tutorial may help you on another way: Input - TUTORIAL: downgrade MariaDB 10.2 to MariaDB 10.1

This is not testet for a upgrade or a databaseserver change.

This could work just as well.

Example for MySQL 5.7:

apt-get install --purge mysql-client-5.7- mysql-client-core-5.7- mysql-server-5.7- mysql-server-core-5.7- mysql-server- mariadb-client-10.1 mariadb-client-core-10.1 mariadb-server-10.1 mariadb-server-core-10.1 libmariadbclient18 libjemalloc1 libmysqlclient18

My way destroy the databeserver. Please backup your database.

You warned, large databases need a lot of time for the import! Please test this before in a VM!

 

[virtubox]

Hello experts,

I checked the search function of the forum and google. So far I couldn't resolve my issue.

I would would like to switch to mariaDB and planned to do so after updating to Plesk 17.5 which I run on Ubuntu 16.04 LTS. I followed this Instruction Database Server

Including step three are no problems.
Then I try:

env DEBIAN_FRONTEND=noninteractive apt-get -o OrderList::Score::Immediate=1000 install libmariadbclient18 mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server mariadb-server-10.1 mariadb-server-core-10.1

View attachment 12895

So according to the dokumentation and other posts in this forum I tried following command:
dpkg -i --force-overwrite /var/cache/apt/archives/mariadb-server-10.1_10.1.24+maria-1~xenial_am d64.deb

Ends up to
View attachment 12896

dpkg --configure -a

View attachment 12897

apt-get install -f

View attachment 12899

And what to do now?

Help is appreciated. Any other Information needed?

Warm regards
Julian

On Ubuntu 16.04, switching from MySQL 5.7 to MariaDB 10.1 seems to be pretty hard due to an incompatible schema of mysql tables
How to install MariaDB in Ubuntu 16.04

 

[B4c4rd1]

I have now tested different possibilities. Once from MariaDB 10.1 back to MySQL 5.6 and then back to MariaDB 10.1 (Plesk installed):





Restoring the data has worked without problems (Backup and restore from my tutorial). The change was not so easy.

Theoretically, the following folders for a change must be deleted or unnamed(Without backup, you lost all data):

mv /etc/mysql{,.bak}
mv /usr/share/mysql{,.bak}
mv /var/lib/mysql{,.bak}

Otherwise there are only problems.

My console command:

apt-get install --purge mysql-server- mysql-client-5.7- mysql-client-core-5.7- mysql-server-core-5.7- mariadb-server-10.1 mariadb-client-10.1 mariadb-server-core-10.1 socat libdbd-mysql-perl libmariadbclient18 mariadb-client-core-10.1 libmysqlclient18 libjemalloc1

fix attention any errors.