[debian-mysql] Bug#1032047: mariadb-server: Preinst fails if user has mariadb running while system service stopped.

[Otto Kekäläinen]

So Rai has /usr/sbin/mysqld-akonadi from package akonadi-backend-mysql:

/usr/sbin/mysqld-akonadi
--defaults-file=/home/rai/.local/share/akonadi/mysql.conf
--datadir=/home/rai/.local/share/akonadi/db_data/
--socket=/tmp/akonadi-rai.bxYrSB/mysql.socket
--pid-file=/tmp/akonadi-rai.bxYrSB/mysql.pid

Rai was running Debian buster (=oldstable).

Steven has another version (Bullseye/stable?) with:

/usr/sbin/mysqld
--defaults-file=/home/username/.local/share/akonadi/mysql.conf
--datadir=/home/username/.local/share/akonadi/db_data/
--socket=/run/user/1000/akonadi/mysql.socket
--pid-file=/run/user/1000/akonadi/mysql.pid

The process detection indeed would be more robust if it checked for
owner 'mysql'. So we could switch it to run this instead?

pgrep -u root,mysql -x --nslist pid --ns $$ "mysqld|mariadbd"

Just need to be careful that this is run only on systems where the
user 'mysql' already exist, otherwise pgrep will return an error.


The issue https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1031770
Rai mentioned is unrelated. Let's not mix the discussion about that
into this one about the preinstall script process check.