[Bug 1061532] New: /var/lib/mysql gets wrong permissions and mariadb wont run - openSUSE Bugs - openSUSE Mailing Lists

newer
[Bug 1079672] NetworkManager does...

[Bug 1061532] New: /var/lib/mysql gets wrong permissions and mariadb wont run

older
[Bug 946310] Sound configuration...

bugzilla_noreply＠novell.com

4 Oct 2017 4 Oct '17

06:22

http://bugzilla.opensuse.org/show_bug.cgi?id=1061532 Bug ID: 1061532 Summary: /var/lib/mysql gets wrong permissions and mariadb wont run Classification: openSUSE Product: openSUSE Distribution Version: Leap 42.3 Hardware: Other OS: Other Status: NEW Severity: Normal Priority: P5 - None Component: Installation Assignee: yast2-maintainers@suse.de Reporter: dpbasti@wp.pl QA Contact: jsrain@suse.com Found By: --- Blocker: --- /var/lib/mysql gets root:root permissions making it unable to perform rcmysql start after clean install chown -R mysql:mysql /var/lib/mysql solves the issue -- You are receiving this mail because: You are on the CC list for the bug.

Attachments:

attachment.htm (text/html — 2.3 KB)

Reply

Sign in to reply online Use email software

Show replies by date

bugzilla_noreply＠novell.com

4 Oct 4 Oct

08:44

New subject: [Bug 1061532] /var/lib/mysql gets wrong permissions and mariadb wont run

http://bugzilla.opensuse.org/show_bug.cgi?id=1061532 http://bugzilla.opensuse.org/show_bug.cgi?id=1061532#c1 Andreas Stieger changed: What |Removed |Added ---------------------------------------------------------------------------- Component|Installation |Other Assignee|yast2-maintainers@suse.de |kstreitova@suse.com QA Contact|jsrain@suse.com |qa-bugs@suse.de --- Comment #1 from Andreas Stieger --- Assign to mariadb maintainer -- You are receiving this mail because: You are on the CC list for the bug.

Reply

Sign in to reply online Use email software

bugzilla_noreply＠novell.com

3 Mar 3 Mar

21:22

New subject: [Bug 1061532] /var/lib/mysql gets wrong permissions and mariadb wont run

http://bugzilla.opensuse.org/show_bug.cgi?id=1061532 http://bugzilla.opensuse.org/show_bug.cgi?id=1061532#c2 Balázs Németh changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jobbara.artalmatlan@gmail.c | |om --- Comment #2 from Balázs Németh --- Though on my freshly install 42.3 the permissions were mysql:root on /var/lib/mysql I still had to set mysql:mysql to be able to start mysql at all. -- You are receiving this mail because: You are on the CC list for the bug.

Reply

Sign in to reply online Use email software

bugzilla_noreply＠novell.com

9 Mar 9 Mar

16:51

New subject: [Bug 1061532] /var/lib/mysql gets wrong permissions and mariadb wont run

http://bugzilla.opensuse.org/show_bug.cgi?id=1061532 http://bugzilla.opensuse.org/show_bug.cgi?id=1061532#c3 --- Comment #3 from Kristyna Streitova --- Hello, Thank you for your bug report. I tested it for a fresh openSUSE Leap 42.3 installation but I cannot reproduce this problem: # ls -lah /var/lib/mysql total 0 drwxr-xr-x 1 root root 0 Aug 18 2017 . drwxr-xr-x 1 root root 750 Aug 18 2017 .. # rcmysql start # ls -lah /var/lib/mysql total 109M drwxr-xr-x 1 mysql root 268 Mar 9 17:13 . drwxr-xr-x 1 root root 750 Aug 18 2017 .. -rw-rw---- 1 mysql mysql 16K Mar 9 17:13 aria_log.00000001 -rw-rw---- 1 mysql mysql 52 Mar 9 17:13 aria_log_control -rw-rw---- 1 mysql mysql 5 Mar 9 17:13 germ70.pid -rw-rw---- 1 mysql mysql 48M Mar 9 17:13 ib_logfile0 -rw-rw---- 1 mysql mysql 48M Mar 9 17:13 ib_logfile1 -rw-rw---- 1 mysql mysql 12M Mar 9 17:13 ibdata1 -rw-rw---- 1 mysql mysql 0 Mar 9 17:13 multi-master.info drwx------ 1 mysql root 2.6K Mar 9 17:13 mysql -rw------- 1 root root 4 Mar 9 17:13 mysql_upgrade_info drwx------ 1 mysql mysql 3.3K Mar 9 17:13 performance_schema drwx------ 1 mysql root 0 Mar 9 17:13 test # mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 4 Server version: 10.0.33-MariaDB SLE 12 SP1 package (...) --- Can you please provide me with exact steps how to reproduce it along with mariadb error log and systemd log that capture the failure? Do you use any non-standard setting/configuration? Thanks! -- You are receiving this mail because: You are on the CC list for the bug.

Reply

Sign in to reply online Use email software

bugzilla_noreply＠novell.com

10 Mar 10 Mar

10:07

New subject: [Bug 1061532] /var/lib/mysql gets wrong permissions and mariadb wont run

http://bugzilla.opensuse.org/show_bug.cgi?id=1061532 http://bugzilla.opensuse.org/show_bug.cgi?id=1061532#c4 --- Comment #4 from Balázs Németh --- As of today I cannot reproduce it anymore neither on docker (opensuse:42.3 image) nor in Virtualbox on a fresh standard install (btrfs). Even though the permissions on /var/lib/mysql are set to root:root by default, rcmysql starts just fine. Thanks for spending time on the investigation. Just for your information these are the logs I can get from journald when I had encounter this issue at the first time. ------------- Mar 03 22:04:22 microchuck systemd[1]: Starting MySQL server... Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: Creating MySQL privilege database... Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: Installing MariaDB/MySQL system tables in '/var/lib/mysql' ... Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: 180303 22:04:22 [Note] /usr/sbin/mysqld (mysqld 10.0.33-MariaDB) starting as process 31824 ... Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: cat: write error: Broken pipe Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: Installation of system tables failed! Examine the logs in Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: /var/lib/mysql for more information. Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: The problem could be conflicting information in an external Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: my.cnf files. You can ignore these by doing: Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: shell> /usr/bin/mysql_install_db --defaults-file=~/.my.cnf Mar 03 22:04:22 microchuck systemd[1]: mysql.service: Control process exited, code=exited status=1 Mar 03 22:04:22 microchuck systemd[1]: Failed to start MySQL server. Mar 03 22:04:22 microchuck systemd[1]: mysql.service: Unit entered failed state. Mar 03 22:04:22 microchuck systemd[1]: mysql.service: Failed with result 'exit-code'. Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: You can also try to start the mysqld daemon with: Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: shell> /usr/sbin/mysqld --skip-grant --general-log & Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: and use the command line tool /usr/bin/mysql Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: to connect to the mysql database and look at the grant tables: Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: shell> /usr/bin/mysql -u root mysql Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: mysql> show tables; Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: Try 'mysqld --help' if you have problems with paths. Using Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: --general-log gives you a log in /var/lib/mysql that may be helpful. Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: The latest information about mysql_install_db is available at Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: MariaDB is hosted on launchpad; You can find the latest source and Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: email lists at http://launchpad.net/maria Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: Please check all of the above before submitting a bug report Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: at http://mariadb.org/jira Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: Creation of MySQL databse in /var/lib/mysql failed Mar 03 22:04:22 microchuck polkitd[31773]: Unregistered Authentication Agent for unix-process:31768:5312640 (system bus name :1.199, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale POSIX) (di Mar 03 22:04:22 microchuck sudo[31758]: pam_unix(sudo:session): session closed for user mysql ------------- -- You are receiving this mail because: You are on the CC list for the bug.

Reply

Sign in to reply online Use email software

bugzilla_noreply＠novell.com

12 Mar 12 Mar

18:40

New subject: [Bug 1061532] /var/lib/mysql gets wrong permissions and mariadb wont run

http://bugzilla.opensuse.org/show_bug.cgi?id=1061532 http://bugzilla.opensuse.org/show_bug.cgi?id=1061532#c5 Kristyna Streitova changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |WORKSFORME --- Comment #5 from Kristyna Streitova --- (In reply to Balázs Németh from comment #4)

As of today I cannot reproduce it anymore neither on docker (opensuse:42.3 image) nor in Virtualbox on a fresh standard install (btrfs). Even though the permissions on /var/lib/mysql are set to root:root by default, rcmysql starts just fine.

Thanks for checking it again. As none of us can reproduce this issue right now, I'm going to close this bug but if you encounter the same behaviour, feel free to reopen. -- You are receiving this mail because: You are on the CC list for the bug.

Reply

Sign in to reply online Use email software

2254

Age (days ago)

2413

Last active (days ago)

Download

5 comments

1 participants

tags

participants (1)

bugzilla_noreply＠novell.com