You are not logged in.
Hi all,
a few hours ago as I updated with pacman my packages I saw these lines:
warning: directory permissions differ on /usr/lib/mysql/plugin/auth_pam_tool_dir/
filesystem: 700 package: 755
:: MariaDB was updated to a new feature release. To update the data run:
systemctl restart mariadb.service && mariadb-upgrade -u root -p
I tried to run the last line, but I got an error:
Enter password:
FATAL ERROR: Could not open or create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' in the MariaDB Servers data directory, errno: 13 (Permission denied)
Note that mysql_upgrade should be run as the same user as the MariaDB server binary, normally 'mysql' or 'root'.
Alternatively you can use mysql_upgrade --force --force. Please check the documentation if you decide to use the force option!
Then I found this: https://seclists.org/oss-sec/2020/q1/55 and I was wondering if there is a security issue.
The output of:
sudo systemctl status mariadb.service
looks normal, MariaDB is active and running.
Could someone please give some advice, how should I proceed?
Last edited by karcher (2023-02-16 09:11:56)
Offline
Well the message seems to be quite clear, you should run the mariadb-upgrade command with the same user that's running the service
Offline
So I shouldn't worry about the first warning?
I've managed to run the command for updating the data after several attempts with:
$ sudo mariadb-upgrade -p
$ sudo systemctl restart mariadb.service
The password was correct but it still failed.
Offline
Not really the first warning will be because the package changed that at some point. You can align that to the package expectations manually with chmod
Offline
OK. Many thanks!
Offline