Resolved Plesk 12.5.30 # Debian 8.6 - Moodle problem version MYSQL

[Zucchi Massimiliano]

Good evening,
I just installed a new version of plesk (12_5_30 # 50) on the new Debian 8.6 server. On this server can not install "Moodle 3.1.2" because the mysql server version is not compatible.
Moodle requires this version (5.5.31 minimum) while the one installed is the (5.5.5-10.0.27-MariaDB-deb8u1 + 0);
you can update the version of the MySQL server without conflict with the installation of plesk / debian and its update services?
Thank you.

 

[IgorG]

You can refer to KB - https://kb.plesk.com/en/127962 for steps to resolve your issue.

 

[Zucchi Massimiliano]

Good evening,
I tried several times as described in the article, without success.
The last time I tried reinstalling Debian with Plesk and without making any kind of operation I am connected via terminal and I ran immediately these steps.
But the result is always the same one that I reproduce below:

xxxxxxxxxxxx root @: ~ # apt-get install mariadb-server
Reading package lists ... Done
Building dependency tree
Reading state information ... Done
The Following extra packages will be installed:
jail-3 iproute libjemalloc1 libmariadbclient18 libmysqlclient18
mariadb-client-10.1 mariadb-client-core 10.1-mariadb-common
mariadb-server-10.1 mariadb-server-core 10.1-socat
Suggested packages:
mariadb netcat-openbsd tinyca-test
The Following packages will be REMOVED:
mariadb-client-10.0 mariadb-client-core 10.0-mariadb-server-10.0
mariadb-server-core-10.0
The Following NEW packages will be installed:
jail-3 iproute libjemalloc1 libmariadbclient18 mariadb-client-10.1
mariadb-client-core 10.1-mariadb-server-10.1 mariadb-server-core 10.1-socat
The Following packages will be upgraded:
libmysqlclient18 mariadb mariadb-server-common
3 upgraded, 9 newly installed, 4 to remove and 1 not upgraded.
Need to get 20.8 MB of archives.
After this operation, 49.4 MB of additional disk space will be used.
Do you want to continue? [Y / n] y
Get: 1 http://mirror.sov.uk.goscomb.net/debian/ jessie / main iproute to 1: 2 3.16.0- [15.5 kB]
Get: 2 http://mirror.sov.uk.goscomb.net/debian/ jessie / main libjemalloc1 amd64 6.0-3 3. [89.1 kB]
Get 3 http://mirror.sov.uk.goscomb.net/debian/ jessie / main socat amd64 1.7.2.4-2 [333 kB]
Get: 4 http://ftp.bme.hu/pub/mirrors/mariadb/repo/10.1/debian/ jessie / main jail -3-amd64 03.25.18 jessie [7.402 kB]
Get: 5 http://ftp.bme.hu/pub/mirrors/mariadb/repo/10.1/debian/ jessie / main mariad b-server to 10.1.18 + maria-1 ~ jessie [2,986 B]
Get: 6 http://ftp.bme.hu/pub/mirrors/mariadb/repo/10.1/debian/ jessie / main libmys qlclient18 amd64 10.1.18 + maria-1 ~ jessie [2,942 B]
Get: 7 http://ftp.bme.hu/pub/mirrors/mariadb/repo/10.1/debian/ jessie / main mariad b-common to 10.1.18 + maria-1 ~ jessie [3,276 B]
Get: 8 http://ftp.bme.hu/pub/mirrors/mariadb/repo/10.1/debian/ jessie / main libmar iadbclient18 amd64 10.1.18 + maria-1 ~ jessie [586 kB]
Get: 9 http://ftp.bme.hu/pub/mirrors/mariadb/repo/10.1/debian/ jessie / main mariad b-client-core-amd64 10.1 10.1.18 + maria-1 ~ jessie [694 kB]
Get: 10 http://ftp.bme.hu/pub/mirrors/mariadb/repo/10.1/debian/ jessie / main maria db-client-amd64 10.1 10.1.18 + maria-1 ~ jessie [1.106 kB]
Get: 11 http://ftp.bme.hu/pub/mirrors/mariadb/repo/10.1/debian/ jessie / main maria db-server-core-amd64 10.1 10.1.18 + maria-1 ~ jessie [4.397 kB]
Get: 12 http://ftp.bme.hu/pub/mirrors/mariadb/repo/10.1/debian/ jessie / main maria db-server-amd64 10.1 10.1.18 + maria-1 ~ jessie [6.128 kB]
Fetched 20.8 MB 13s (1,595 kB / s)
Reading changelogs ... Done
Preconfiguring packages ...
Selecting previously unselected jail-3 package.
(Reading database ... 124672 files and directories currently installed.)
Preparing to unpack ... / jail-3_25.3.18-jessie_amd64.deb ...
jail-3 Unpacking (03/25/18-jessie) ...
Selecting previously unselected package iproute.
Preparing to unpack ... / iproute_1% 3a3.16.0-2_all.deb ...
Unpacking iproute (1: 3.16.0-2) ...
Preparing to unpack ... / mariadb-server_10.1.18 + maria-1 ~ jessie_all.deb ...
Unpacking mariadb-server (10.1.18 + maria-1 ~ jessie) over (10.0.27-0 deb8u1 +) ...
dpkg: mariadb-client-core-10.0: dependency problems, but removing anyway as you requested:
mariadb-client-10.0 depends on mariadb-client-core-10.0 (> = + 10.0.27-0 deb8u1).

(Reading database ... 124682 files and directories currently installed.)
Removing mariadb-client-core-10.0 (10.0.27-0 deb8u1 +) ...
dpkg: mariadb-server-core-10.0: dependency problems, but removing anyway as you requested:
mariadb-server-10.0 depends on mariadb-server-core-10.0 (> = + 10.0.27-0 deb8u1).

Removing mariadb-server-core-10.0 (10.0.27-0 deb8u1 +) ...
dpkg: mariadb-server-10.0: dependency problems, but removing anyway as you reque sted:
plesk-mysql-server depends on mariadb-server | virtual-mysql-server; However:
Package mariadb-server is not configured yet.
Package virtual-mysql-server is not installed.
Package mariadb-server-10.0 Which Provides virtual-mysql-server is to be remov ed.

Removing mariadb-server-10.0 (10.0.27-0 deb8u1 +) ...
Removing mariadb-client-10.0 (10.0.27-0 deb8u1 +) ...
Processing triggers for man-db (2.7.0.2-5) ...
(Reading database ... 124462 files and directories currently installed.)
Preparing to unpack ... / libmysqlclient18_10.1.18 + maria-1 ~ jessie_amd64.deb ...
Unpacking libmysqlclient18 (10.1.18 + maria-1 ~ jessie) over (5.5.52-0 + deb8u1) ...
Preparing to unpack ... / mariadb-common_10.1.18 + maria-1 ~ jessie_all.deb ...
Unpacking mariadb-common (10.1.18 + maria-1 ~ jessie) over (10.0.27-0 deb8u1 +) ...
Selecting previously unselected package libmariadbclient18.
Preparing to unpack ... / libmariadbclient18_10.1.18 + maria-1 ~ jessie_amd64.deb ...
Unpacking libmariadbclient18 (10.1.18 + maria-1 ~ jessie) ...
Selecting previously unselected package mariadb-client-core-10.1.
Preparing to unpack ... / mariadb-client-core-10.1_10.1.18 + maria-1 ~ jessie_amd64.de b ...
Unpacking mariadb-client-core-10.1 (10.1.18 + maria-1 ~ jessie) ...
Selecting previously unselected package mariadb-client-10.1.
Preparing to unpack ... / mariadb-client-10.1_10.1.18 + maria-1 ~ jessie_amd64.deb ...
Unpacking mariadb-client-10.1 (10.1.18 + maria-1 ~ jessie) ...
Selecting previously unselected package libjemalloc1.
Preparing to unpack ... / ... libjemalloc1_3.6.0-3_amd64.deb
Unpacking libjemalloc1 (3.6.0-3) ...
Selecting previously unselected package mariadb-server-core-10.1.
Preparing to unpack ... / mariadb-server-core-10.1_10.1.18 + maria-1 ~ jessie_amd64.de b ...
Unpacking mariadb-server-core-10.1 (10.1.18 + maria-1 ~ jessie) ...
Selecting previously unselected package socat.
Preparing to unpack ... / ... socat_1.7.2.4-2_amd64.deb
Unpacking socat (1.7.2.4-2) ...
Processing triggers for man-db (2.7.0.2-5) ...
Setting up mariadb-common (10.1.18 + maria-1 ~ jessie) ...
Selecting previously unselected package mariadb-server-10.1.
(Reading database ... 124640 files and directories currently installed.)
Preparing to unpack ... / mariadb-server-10.1_10.1.18 + maria-1 ~ jessie_amd64.deb ...
Unpacking mariadb-server-10.1 (10.1.18 + maria-1 ~ jessie) ...
Processing triggers for systemd (215-17 + deb8u5) ...
Processing triggers for man-db (2.7.0.2-5) ...
Setting up prison-3 (25/3/18-jessie) ...
Setting up iproute (1: 3.16.0-2) ...
Setting up libjemalloc1 (3.6.0-3) ...
Setting up socat (1.7.2.4-2) ...
Setting up libmysqlclient18 (10.1.18 + maria-1 ~ jessie) ...
Setting up libmariadbclient18 (10.1.18 + maria-1 ~ jessie) ...
Setting up mariadb-client-core-10.1 (10.1.18 + maria-1 ~ jessie) ...
Setting up mariadb-client-10.1 (10.1.18 + maria-1 ~ jessie) ...
Setting up mariadb-server-core-10.1 (10.1.18 + maria-1 ~ jessie) ...
Setting up mariadb-server-10.1 (10.1.18 + maria-1 ~ jessie) ...
Installing new version of config files /etc/init.d/mysql ...
Installing new version of config files /etc/logrotate.d/mysql-server ...
Installing new version of config file / etc / mysql / debian-start ...
19/10/2016 17:44:51 140458250446784 [Note] Using unique option prefix 'key_buffe r' is error-prone and can break in the future. Please use the full name 'key_buf fer_size' instead.
19/10/2016 17:44:51 140458250446784 [Notes] / usr / sbin / mysqld (mysqld 10.1.18 Mari-ADB-1 ~ jessie) starting as process 4154 ...
Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mariadb-server-10.1 package (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mariadb-server:
mariadb-server depends on mariadb-server-10.1 (10.1.18 = + maria-1 ~ jessie); However:
Package mariadb-server-10.1 is not configured yet.

dpkg: error processing mariadb-server package (--configure):
dependency problems - leaving unconfigured
Processing triggers for libc-bin (2.19-18 + deb8u6) ...
Processing triggers for systemd (215-17 + deb8u5) ...
Errors were encountered while processing:
mariadb-server-10.1
mariadb-server
E: Sub-process / usr / bin / dpkg returned an error code (1)

 

[urki]

@Zucchi Massimiliano,

In case of a new server (fresh installation), you could consider the option of installing MariaDB before Plesk.

That way MariaDB gets installed without any problems, and Plesk installer will detect and configure MariaDB for use with Plesk.

 

[UFHH01]

Hi Zucchi Massimiliano,

dpkg: error processing mariadb-server-10.1 package (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mariadb-server:
mariadb-server depends on mariadb-server-10.1 (10.1.18 = + maria-1 ~ jessie); However:
Package mariadb-server-10.1 is not configured yet.

Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.
invoke-rc.d: initscript mysql, action "start" failed.

If you see such a message "See 'systemctl status mariadb.service' and 'journalctl -xn' for details" either in your logs, or over the command line, you really should consider to follow the suggestions, to investigate possible errors/issues/problems.

=> Command to use over your command line: systemctl status mariadb.service ( if you need help with the investigations, you should consider to post the results of the command in your post/thread )
=> Command to use over your command line: journalctl -xn ( if you need help with the investigations, you should consider to post the results of the command in your post/thread )​

As you can see at the very end, it is in this case not necessary to post the results of the commands, because here

Errors were encountered while processing:
mariadb-server-10.1
mariadb-server

... you can see, that the installation wasn't finished yet as expected. Pls. continue with

=> Command to use over your command line: apt-get -f install​

... which should finish the installation - process as expected. If you experience further issues/errors/problems, consider to post the results of "apt-get -f install" from your command line.



Pls. keep in mind, that you are always able to use additional options when you install packages over your command line on Debian/Ubuntu - based systems. There is not only "apt-get", but as well "aptitude" or "dpkg".

mkdir -p /root/apt-downloads
cd /root/apt-downloads
apt-get download <package-name>
dpkg -i <downloaded_package_deb_file_with_the_ending_*.deb>

Due to the fact, that you would use the manual installation process with the combination "apt-get download" and "dpkg" in case of previous issues/errors/problems, you might be interested, that "dpkg" has a lot of additional options, which you can use to force an installation, or to ignore dependencies:

dpkg -i --force-depends <downloaded_package_deb_file_with_the_ending_*.deb>
or
dpkg -i --ignore-depends=<package-name_which_should_be_ignored> <downloaded_package_deb_file_with_the_ending_*.deb>

or to ignore several packages: dpkg -i --ignore-depends=package1,package2 package3.deb <downloaded_package_deb_file_with_the_ending_*.deb>

Pls. use "dpkg --help", if you are interested in additional, possible command options for "dpkg".
​

You could as well consider to use "aptitude" instead of "apt-get", which has way better options for unexperienced linux - users, because it will give you the choice to use ( possible ) different dependencies solutions, found when using "aptitude" - give it a try the next time you choose to install something over your command - line.

=> Command to use over your command line: aptitude install <package_name>​