I got this in log:
"warning: directory permissions differ on /usr/lib/mysql/plugin/auth_pam_tool_dir/
filesystem: 700 package: 755"
I also got this right below:
"upgraded mariadb (10.6.4-1 -> 10.6.5-1)"
And when I tried this:
"mariadb-upgrade -u root -p"
I got this:
Enter password:
Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)
FATAL ERROR: Upgrade failed
WHAT PASSWORD? Neither root or sudo pass work.
Now what?
The server isn't running, start it first.
It says:
"Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)'
Shouldn't it be "/run/runit/" ?
And what does it mean?:
""warning: directory permissions differ on /usr/lib/mysql/plugin/auth_pam_tool_dir/
filesystem: 700 package: 755""
What is the correct procedure to update mysql on Artix with runit?
Surely you don't expect me to run:
systemctl restart mariadb.service && mariadb-upgrade -u root -p
And I have never ever started it in the first place. Was it even running in the first place?
You should actually start the service with runit first (install mariadb-runit if you haven't already). It doesn't sound like it is up hence why there is no socket. And yes, '/run/mysqld/mysqld.sock' is the correct path. It's normal for programs to put things in /run
You shouldn't be attempting to upgrade mariadb outside of pacman anyway. If you've done so in the past that might be where your problems stem from ?
But on the WHAT PASSWORD? question. It wants your mariadb (mysql) root password. Which is not the same thing as your root password. So unless you've set the two (linux root pass & mariadb root pass) to the same password, entering your linux root won't work. Even if mariadb was running.
And as stated I'm fairly sure you don't want to be running that command anyway.
I've never used mariadb on Artix or any Arch like but have for years on debian and I've never used
Just left it to the package manager .
I don't know which packages had installed mariadb. I also have never ever upgraded mariadb manually. And I also have never set a password for mariadb. My lose guess would be that its part of KDE Plasma (various databases - krunner, inexing, including KDE PIM - i.e. full KDE Plasma, withouch GTK rubbish from mutter/gnome). Does it mean that something I havent' used in full KDE Plasma will have bugs/security holes because KDE Plasma WAS NOT PROPERLY UPDATED BY PACMAN? Shouldn't pacman take care of it? Does this mean that runnit pacman and plasma become lesss and less compatible and they fall APART and I should give up? I wouldn't like it because system with runit and only a few services running is very, very snappy.
What should be the correct procedure now? Step by step in Artix ?
P.S. As you mentioned With systemd in Debian 10 and 11 (which I also both maintain) I have never ever had an issue.
What does
pacman -Qi mariadb
output ?
Akonadi, what else :D I have manually started mariadb for runnit (symlinks in subfolder, sv up...). Now what?
Any answer how to fix it?