Resolved Update MariaDB from 10.6 to 10.7 on Ubuntu 20.04.5 | Plesk show 10.6 after install

[heydemar]

Hi,

i have a question.
On my Plesk Demo Instanz (Plesk Obsidian Version 18.0.48) i want to Update my MariaDB vom 10.6 to 10.7

root@vps4:~# apt-get install mariadb-server-10.7
Reading package lists... Done
Building dependency tree
Reading state information... Done
mariadb-server-10.7 is already the newest version (1:10.7.7+maria~ubu2004).
0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.

But in my Plesk Panel I see this Version:


Thank you!!!!

PS: Sorry Admin can you move ist to Plesk Obsidian?
Thanks!

 

[Kaspar]

Beware that MariaDB 10.6 is the newest version Plesk currently supports.

You have to manually change the version info shown in Plesk for the database server in the Plesk PSA database.

UPDATE DatabaseServers SET server_version = '10.7.7' WHERE server_version = '10.6.8';

 

[Maarten]

MariaDB 10.6 is also the LTS version (Long Term Support):

MariaDB

Check end-of-life, release policy and support schedule for MariaDB.

endoflife.date

 

[Piekielko]

I don't understand a bit - first I updated the database from version 10.3 to 10.5. Everything worked fine. Now I've tried to upgrade to version 10.6 and I can no longer run this version. When upgrading, do I have to leave the basic version 10.3 on the server?

root@ns3125328:~# apt-get install mariadb-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libpmem1 mariadb-client-10.6 mariadb-client-core-10.6 mariadb-common mariadb-server-10.6 mariadb-server-core-10.6
Suggested packages:
mariadb-test netcat-openbsd
The following packages will be REMOVED:
mariadb-client-10.5 mariadb-client-core-10.5 mariadb-server-10.5 mariadb-server-core-10.5
The following NEW packages will be installed:
libpmem1 mariadb-client-10.6 mariadb-client-core-10.6 mariadb-server-10.6 mariadb-server-core-10.6
The following packages will be upgraded:
mariadb-common mariadb-server
2 upgraded, 5 newly installed, 4 to remove and 3 not upgraded.
Need to get 13.9 MB of archives.
After this operation, 1,987 kB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 Index of /debian buster/main amd64 libpmem1 amd64 1.5.1-1 [56.5 kB]
Get:2 Index of /pub/unix/database/mariadb/repo/10.6/debian buster/main amd64 mariadb-common all 1:10.6.11+maria~deb10 [4,048 B]
Get:3 Index of /pub/unix/database/mariadb/repo/10.6/debian buster/main amd64 mariadb-server all 1:10.6.11+maria~deb10 [2,832 B]
Get:4 Index of /pub/unix/database/mariadb/repo/10.6/debian buster/main amd64 mariadb-server-10.6 amd64 1:10.6.11+maria~deb10 [3,446 kB]
Get:5 Index of /pub/unix/database/mariadb/repo/10.6/debian buster/main amd64 mariadb-client-core-10.6 amd64 1:10.6.11+maria~deb10 [831 kB]
Get:6 Index of /pub/unix/database/mariadb/repo/10.6/debian buster/main amd64 mariadb-client-10.6 amd64 1:10.6.11+maria~deb10 [2,407 kB]
Get:7 Index of /pub/unix/database/mariadb/repo/10.6/debian buster/main amd64 mariadb-server-core-10.6 amd64 1:10.6.11+maria~deb10 [7,147 kB]
Fetched 13.9 MB in 1s (14.0 MB/s)
Preconfiguring packages ...
(Reading database ... 81992 files and directories currently installed.)
Preparing to unpack .../mariadb-common_1%3a10.6.11+maria~deb10_all.deb ...
Unpacking mariadb-common (1:10.6.11+maria~deb10) over (1:10.5.18+maria~deb10) ...
Preparing to unpack .../mariadb-server_1%3a10.6.11+maria~deb10_all.deb ...
Unpacking mariadb-server (1:10.6.11+maria~deb10) over (1:10.5.18+maria~deb10) ...
dpkg: mariadb-server-10.5: dependency problems, but removing anyway as you requested:
plesk-mysql-server depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mariadb-server-10.5 which provides virtual-mysql-server is to be removed.
Package mariadb-server-10.3 which provides virtual-mysql-server is not installed.
Package mysql-server is not installed.
plesk-mysql-server depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mariadb-server-10.5 which provides virtual-mysql-server is to be removed.
Package mariadb-server-10.3 which provides virtual-mysql-server is not installed.
Package mysql-server is not installed.
plesk-mysql-server depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mariadb-server-10.5 which provides virtual-mysql-server is to be removed.
Package mariadb-server-10.3 which provides virtual-mysql-server is not installed.
Package mysql-server is not installed.
plesk-mysql-server depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mariadb-server-10.5 which provides virtual-mysql-server is to be removed.
Package mariadb-server-10.3 which provides virtual-mysql-server is not installed.
Package mysql-server is not installed.

(Reading database ... 81991 files and directories currently installed.)
Removing mariadb-server-10.5 (1:10.5.18+maria~deb10) ...
Setting up mariadb-common (1:10.6.11+maria~deb10) ...
update-alternatives: warning: forcing reinstallation of alternative /etc/mysql/mariadb.cnf because link group my.cnf is broken
update-alternatives: warning: not replacing /etc/mysql/my.cnf with a link
Selecting previously unselected package mariadb-server-10.6.
(Reading database ... 81866 files and directories currently installed.)
Preparing to unpack .../mariadb-server-10.6_1%3a10.6.11+maria~deb10_amd64.deb ...
/var/lib/mysql: found previous version 10.5
Unpacking mariadb-server-10.6 (1:10.6.11+maria~deb10) ...
(Reading database ... 81969 files and directories currently installed.)
Removing mariadb-client-10.5 (1:10.5.18+maria~deb10) ...
Removing mariadb-client-core-10.5 (1:10.5.18+maria~deb10) ...
Removing mariadb-server-core-10.5 (1:10.5.18+maria~deb10) ...
Selecting previously unselected package mariadb-client-core-10.6.
(Reading database ... 81781 files and directories currently installed.)
Preparing to unpack .../mariadb-client-core-10.6_1%3a10.6.11+maria~deb10_amd64.deb ...
Unpacking mariadb-client-core-10.6 (1:10.6.11+maria~deb10) ...
Selecting previously unselected package mariadb-client-10.6.
Preparing to unpack .../mariadb-client-10.6_1%3a10.6.11+maria~deb10_amd64.deb ...
Unpacking mariadb-client-10.6 (1:10.6.11+maria~deb10) ...
Selecting previously unselected package libpmem1.
Preparing to unpack .../libpmem1_1.5.1-1_amd64.deb ...
Unpacking libpmem1 (1.5.1-1) ...
Selecting previously unselected package mariadb-server-core-10.6.
Preparing to unpack .../mariadb-server-core-10.6_1%3a10.6.11+maria~deb10_amd64.deb ...
Unpacking mariadb-server-core-10.6 (1:10.6.11+maria~deb10) ...
Setting up mariadb-client-core-10.6 (1:10.6.11+maria~deb10) ...
Setting up libpmem1 (1.5.1-1) ...
Setting up mariadb-client-10.6 (1:10.6.11+maria~deb10) ...
Setting up mariadb-server-core-10.6 (1:10.6.11+maria~deb10) ...
Setting up mariadb-server-10.6 (1:10.6.11+maria~deb10) ...
Installing new version of config file /etc/init.d/mariadb ...
Installing new version of config file /etc/mysql/mariadb.conf.d/50-server.cnf ...
mariadb-extra.socket is a disabled or a static unit, not starting it.
mariadb-extra.socket is a disabled or a static unit, not starting it.
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
Setting up mariadb-server (1:10.6.11+maria~deb10) ...
Processing triggers for systemd (241-7~deb10u8) ...
Processing triggers for libc-bin (2.28-10+deb10u2) ...
root@ns3125328:~# systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

 

[Maarten]

Can you post the output of "systemctl status mariadb.service" or "journalctl -xe"?

 

[Piekielko]

mariadb.service - MariaDB 10.6.11 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: failed (Result: exit-code) since Mon 2022-12-05 23:34:04 UTC; 19min ago
Docs: man:mariadbd(8)
systemd
Process: 17890 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 17891 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 17893 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $?
Process: 17928 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 17928 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [Note] Plugin 'FEEDBACK' is disabled.
Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-e
Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [Note] Server socket created on IP: '127.0.0.1'.
Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 22: Invalid argu
Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [ERROR] Do you already have another server running on port: 3306 ?
Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [ERROR] Aborting
Dec 05 23:34:04 ns3125328 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 05 23:34:04 ns3125328 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Dec 05 23:34:04 ns3125328 systemd[1]: Failed to start MariaDB 10.6.11 database server.

Dec 05 23:54:45 ns3125328 sshd[18049]: Failed password for root from 1.235.216.34 port 48946 ssh2
Dec 05 23:54:48 ns3125328 sshd[18049]: Received disconnect from 1.235.216.34 port 48946:11: Bye Bye [preauth]
Dec 05 23:54:48 ns3125328 sshd[18049]: Disconnected from authenticating user root 1.235.216.34 port 48946 [preauth]
Dec 05 23:55:47 ns3125328 sshd[18053]: Invalid user ws from 211.221.173.228 port 55014
Dec 05 23:55:47 ns3125328 sshd[18053]: pam_unix(sshd:auth): check pass; user unknown
Dec 05 23:55:47 ns3125328 sshd[18053]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=211.221.173.22
Dec 05 23:55:47 ns3125328 sshd[18053]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/run/mysq
Dec 05 23:55:49 ns3125328 sshd[18053]: Failed password for invalid user ws from 211.221.173.228 port 55014 ssh2
Dec 05 23:55:50 ns3125328 sshd[18053]: Received disconnect from 211.221.173.228 port 55014:11: Bye Bye [preauth]
Dec 05 23:55:50 ns3125328 sshd[18053]: Disconnected from invalid user ws 211.221.173.228 port 55014 [preauth]

 

[Maarten]

What does the bind-address look like in my.cnf?

For MariaDB 10.6 it should be:
bind-address = ::
or
bind-address = 127.0.0.1

 

[Piekielko]

[client-server]

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
[mysqld]
sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
bind-address = ::ffff:127.0.0.1
local-infile=0

I install everything from scratch.
I installed a ready-made installation of Debian + Plesk before.
I will try to install a clean version of Debian and finally manually install Plesk. Just wondering which version is better 10 or 11?

 

[Piekielko]

I managed to run 10.6. I can log in to Mysql, but only as root. When I try to run Plesk, I get a message
ERROR 1698 (28000): Access denied for user 'admin'@'localhost'

 

[Piekielko]

This finally solved my problem. Works Debian 11, MariaDB 10.6 and Plesk is running

https://support.plesk.com/hc/en-us/articles/213364309-Unable-to-access-Plesk-GUI-Access-denied-for-user-admin-localhost-using-password-YES-