Bug 1497694

Summary:	mysqld service not working by default after bd72127
Product:	[Fedora] Fedora	Reporter:	Terje Røsten <terje.rosten>
Component:	community-mysql	Assignee:	Michal Schorm <mschorm>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	27	CC:	hhorak, jakub.dornak, jstanek, mschorm
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-11-12 09:25:23 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Terje Røsten 2017-10-02 13:27:04 UTC

Description of problem:

community-mysql-server %post script does:

 touch /var/log/mysqld.log

RPM runs as root, giving root:root as owner:group on log file.

Before bd72127 - Include mysqld@.service file and do not run start scripts in the unit file as root

mysqld service fixed this by running mysql-prepare-db-dir as root
due to:

# Execute pre and post scripts as root
PermissionsStartOnly=true

in service file.

When bd72127 removed this option, /var/log/mysqld.log will be owned 
root:root when mysqld tries to start and everything fails apart.

mysqld (running as mysql user) can't create /var/log/mysqld.log itself,
in some way file has to present and writable by mysql before mysqld starts.

Comment 1 Fedora Update System 2017-10-27 23:16:39 UTC

community-mysql-5.7.20-1.fc26 has been submitted as an update to Fedora 26. https://bodhi.fedoraproject.org/updates/FEDORA-2017-50c790aaed

Comment 2 Fedora Update System 2017-10-27 23:17:00 UTC

community-mysql-5.7.20-1.fc25 has been submitted as an update to Fedora 25. https://bodhi.fedoraproject.org/updates/FEDORA-2017-95327e44ec

Comment 3 Fedora Update System 2017-10-27 23:17:13 UTC

community-mysql-5.7.20-1.fc27 has been submitted as an update to Fedora 27. https://bodhi.fedoraproject.org/updates/FEDORA-2017-9e28c78e07

Comment 4 Fedora Update System 2017-10-28 12:17:53 UTC

community-mysql-5.7.20-1.fc25 has been pushed to the Fedora 25 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2017-95327e44ec

Comment 5 Fedora Update System 2017-10-28 12:33:56 UTC

community-mysql-5.7.20-1.fc26 has been pushed to the Fedora 26 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2017-50c790aaed

Comment 6 Fedora Update System 2017-10-30 14:45:33 UTC

community-mysql-5.7.20-1.fc27 has been pushed to the Fedora 27 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2017-9e28c78e07

Comment 7 Fedora Update System 2017-11-06 23:33:18 UTC

community-mysql-5.7.20-1.fc25 has been pushed to the Fedora 25 stable repository. If problems still persist, please make note of it in this bug report.

Comment 8 Fedora Update System 2017-11-06 23:33:50 UTC

community-mysql-5.7.20-1.fc26 has been pushed to the Fedora 26 stable repository. If problems still persist, please make note of it in this bug report.

Comment 9 Fedora Update System 2017-11-11 03:08:14 UTC

community-mysql-5.7.20-1.fc27 has been pushed to the Fedora 27 stable repository. If problems still persist, please make note of it in this bug report.