[SOLVED]Problems with pacman installing mysql

sss20081 · 2022-07-07 09:22:03

when i install mysql

Warning: Inconsistent permissions on directory /run/
:: You need to initialize the MySQL data directory prior to starting
   the service. This can be done with mysqld --initialize command, e.g.:
   mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql
:: Additionally you should secure your MySQL installation using
   mysql_secure_installation command after starting the mysqld service

and when I reinstall mysql

Warning: Inconsistent permissions on directory /run/
Filesystem: 755 Packages: 775
Warning: Inconsistent permissions on directory /var/lib/mysqlrouter/
Filesystem: 700 Packages: 775
Warning: Inconsistent permissions on directory /var/log/mysqlrouter/
Filesystem: 750 Packages: 775

I would like to know why this problem occurs when installing mysql, and what is the solution to this

Last edited by sss20081 (2022-07-10 05:32:55)

Awebb · 2022-07-07 09:32:47

man pacman
pacman -Qk $package

sss20081 · 2022-07-07 10:14:52

Awebb wrote:

man pacman
pacman -Qk $package

[1] 57272
[1]  + 57272 suspended (tty output)  sudo pacman -Qk
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

sss20081 · 2022-07-07 10:24:40

I use

pacman -Qkk mysql

Thoroughly checked mysql
Then I got this

Warning: mysql: /run (permission mismatch)
Warning: mysql: /var/lib/mysqlrouter (user identifier UID mismatch)
Warning: mysql: /var/lib/mysqlrouter (user group identifier GID mismatch)
Warning: mysql: /var/lib/mysqlrouter (permission mismatch)
Warning: mysql: /var/log/mysqlrouter (user identifier UID mismatch)
Warning: mysql: /var/log/mysqlrouter (user group identifier GID mismatch)
Warning: mysql: /var/log/mysqlrouter (permission mismatch)
mysql: 326 all files, 3 changed files

I just want to know why this happens

Awebb · 2022-07-07 12:44:27

There is no mysql package in the official repositories. You've either installed if from the AUR or from a third party repository. Alternatively, you're not running 64bit Archlinux. The correct replacement for mysql on Arch is mariadb.

Please clarify and post the output of uname -a.

WorMzy · 2022-07-07 13:56:20

Mod note: Moving to AUR issues.

sss20081 · 2022-07-07 14:37:27

Awebb wrote:

There is no mysql package in the official repositories. You've either installed if from the AUR or from a third party repository. Alternatively, you're not running 64bit Archlinux. The correct replacement for mysql on Arch is mariadb.
Please clarify and post the output of uname -a.

Linux Arch 5.18.9-arch1-1 #1 SMP PREEMPT_DYNAMIC Sat, 02 Jul 2022 21:03:06 +0000 x86_64 GNU/Linux

I installed mysql from AUR

loqs · 2022-07-07 14:41:24

The inconsistencies detected are expected as the package uses tmpfiles.d to change ownership and permissions https://aur.archlinux.org/cgit/aur.git/ … ch?h=mysql

:: You need to initialize the MySQL data directory prior to starting
   the service. This can be done with mysqld --initialize command, e.g.:
   mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql

Did you initialize the data directory before starting mysqld?

sss20081 · 2022-07-07 15:01:59

I initialized the data directory

loqs · 2022-07-07 15:06:01

sss20081 wrote:

I initialized the data directory

Was that before or after the output in the first post was produced? If after can you now run mysqld successfully?
If you still can not run mysqld successfully what is the exact command you are using and the full output it produces?

Muflone · 2022-07-07 19:56:59

loqs wrote:

The inconsistencies detected are expected as the package uses tmpfiles.d to change ownership and permissions https://aur.archlinux.org/cgit/aur.git/ … ch?h=mysql
:: You need to initialize the MySQL data directory prior to starting
   the service. This can be done with mysqld --initialize command, e.g.:
   mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql
Did you initialize the data directory before starting mysqld?

I think this worths a fix

ewaller · 2022-07-07 23:54:18

sss20081 reported wrote:

I've got mysql running now, I just want to know why the install shows up:
Warning, inconsistency in directory permissions
This has never happened to me before

If you were wondering why your post disappeared, you hit the report link, not the reply link

loqs · 2022-07-08 00:46:46

Muflone wrote:

I think this worths a fix

Stop packaging the directories and leave it to tmpfiles.d?

diff --git a/PKGBUILD b/PKGBUILD
index 04e514f..9f3228f 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -226,6 +226,12 @@ package_mysql(){
   # Cleanup
   rmdir "${pkgdir}/usr/usr/lib"
   rmdir "${pkgdir}/usr/usr"
+  rmdir "${pkgdir}/run"
+  rmdir "${pkgdir}/var/lib/mysqlrouter"
+  rmdir "${pkgdir}/var/lib"
+  rmdir "${pkgdir}/var/log/mysqlrouter"
+  rmdir "${pkgdir}/var/log"
+  rmdir "${pkgdir}/var"
 
   # Arch Linux specific patches:
   #  * enable PrivateTmp for a little bit more security

Edit:
Remove /var as well. Only empty directory remaining /usr/lib/mysql/plugin/debug

Last edited by loqs (2022-07-08 00:58:23)

sss20081 · 2022-07-08 23:58:44

sorry i can't understand

seth · 2022-07-09 07:55:35

loqs' comment was for Muflone, who maintains the mysql AUR.
But you could edit the PKGBUILD accordingly when building the mysql package.

Muflone · 2022-07-09 17:52:02

sss20081 wrote:

and when I reinstall mysql
Warning: Inconsistent permissions on directory /run/
Filesystem: 755 Packages: 775
Warning: Inconsistent permissions on directory /var/lib/mysqlrouter/
Filesystem: 700 Packages: 775
Warning: Inconsistent permissions on directory /var/log/mysqlrouter/
Filesystem: 750 Packages: 775
I would like to know why this problem occurs when installing mysql, and what is the solution to this

Simply the mysql package contains such directories and it assumes the permissions 775
In your system instead you have the permissions 700 or 750

For this reason pacman warns you the directories permissions differ.

This is a bug in mysql package (which I maintain) as I used two different permissions sets (755 for the packaged directories and 700/750 for the directories created by systemd-tmpfiles). I'll fix the package soon.

You can safely ignore the warning message, though.

Awebb · 2022-07-09 18:56:24

Besides you being a legend for maintaining mysql on the AUR, is this the moment where we ask "why not mariadb"?

sss20081 · 2022-07-10 05:29:05

ok, thanks for your help

Arch Linux

#1 2022-07-07 09:22:03

[SOLVED]Problems with pacman installing mysql

#2 2022-07-07 09:32:47

Re: [SOLVED]Problems with pacman installing mysql

#3 2022-07-07 10:14:52

Re: [SOLVED]Problems with pacman installing mysql

#4 2022-07-07 10:24:40

Re: [SOLVED]Problems with pacman installing mysql

#5 2022-07-07 12:44:27

Re: [SOLVED]Problems with pacman installing mysql

#6 2022-07-07 13:56:20

Re: [SOLVED]Problems with pacman installing mysql

#7 2022-07-07 14:37:27

Re: [SOLVED]Problems with pacman installing mysql

#8 2022-07-07 14:41:24

Re: [SOLVED]Problems with pacman installing mysql

#9 2022-07-07 15:01:59

Re: [SOLVED]Problems with pacman installing mysql

#10 2022-07-07 15:06:01

Re: [SOLVED]Problems with pacman installing mysql

#11 2022-07-07 19:56:59

Re: [SOLVED]Problems with pacman installing mysql

#12 2022-07-07 23:54:18

Re: [SOLVED]Problems with pacman installing mysql

#13 2022-07-08 00:46:46

Re: [SOLVED]Problems with pacman installing mysql

#14 2022-07-08 23:58:44

Re: [SOLVED]Problems with pacman installing mysql

#15 2022-07-09 07:55:35

Re: [SOLVED]Problems with pacman installing mysql

#16 2022-07-09 17:52:02

Re: [SOLVED]Problems with pacman installing mysql

#17 2022-07-09 18:56:24

Re: [SOLVED]Problems with pacman installing mysql

#18 2022-07-10 05:29:05

Re: [SOLVED]Problems with pacman installing mysql

Board footer