Arch Linux

karcher

Member

Registered: 2018-01-09

Posts: 140

[SOLVED] MariaDB auth_pam_tool_dir warning & error

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)

V1del

Forum Moderator

Registered: 2012-10-16

Posts: 21,665

Re: [SOLVED] MariaDB auth_pam_tool_dir warning & error

Well the message seems to be quite clear, you should run the mariadb-upgrade command with the same user that's running the service

karcher

Member

Registered: 2018-01-09

Posts: 140

Re: [SOLVED] MariaDB auth_pam_tool_dir warning & error

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.

V1del

Forum Moderator

Registered: 2012-10-16

Posts: 21,665

Re: [SOLVED] MariaDB auth_pam_tool_dir warning & error

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

karcher

Member

Registered: 2018-01-09

Posts: 140

Re: [SOLVED] MariaDB auth_pam_tool_dir warning & error

OK. Many thanks!