Bug 1526789

Summary:	httpd does not work with mysql in f27, although apr-util-mysql properly installed
Product:	[Fedora] Fedora	Reporter:	Tom Kovar <tom>
Component:	httpd	Assignee:	Luboš Uhliarik <luhliari>
Status:	CLOSED ERRATA	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	urgent	Docs Contact:
Priority:	unspecified
Version:	27	CC:	hhorak, jkaluza, jorton, luhliari, pahan, tom
Target Milestone:	---
Target Release:	---
Hardware:	i686
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2018-01-10 02:05:05 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:
Bug Depends On:	1494093
Bug Blocks:

Description Tom Kovar 2017-12-17 13:11:33 UTC

Description of problem:
After upgrade f26->f27, httpd does not work with mysql - httpd cannot load apr_dbd_mysql.so, even though apr-util-mysql is properly installed.
Under f26, these components were working perfectly together, after upgrade using dnf, the problem appeared.


Version-Release number of selected component (if applicable):
httpd: 2.4.29 1.fc27
community-mysql: 5.7.20 1.fc27
apr-util-mysql: 1.6.1 1.fc27


Steps to Reproduce:
1. mysqld is running
2. Start httpd (either directly though command line, or using systemctl start)

Actual results:
httpd exits with error, dying at the config file directive "DBDriver mysql", stating
"AH00526: Syntax error on line xx of /etc/httpd/conf/httpd.conf:
Can't load driver file apr_dbd_mysql.so"

Comment 1 Tom Kovar 2017-12-19 14:09:28 UTC

I have found the problem.
The library installed by apr-util-mysql mentioned above is not linked to libmysqlclient.so, but to libmariadb.so, which apparently causes the error.

I have recompiled libaprutil directly from apr.apache.org and linked it to libmysqlclient, and now httpd loads and works properly.

Maybe it would be a good idea to correct the packages.

Comment 2 Honza Horak 2017-12-19 21:13:35 UTC

Tom, can you test this scratch build, please?
https://koji.fedoraproject.org/koji/taskinfo?taskID=23798888

Anyway, there is already a bug for this: BZ#1494093
...and PR for apr-util component: https://src.fedoraproject.org/rpms/apr-util/pull-request/1

And upstream already has fix as well: https://bz.apache.org/bugzilla/show_bug.cgi?id=61517 (used in the PR above)

Comment 3 Fedora Update System 2018-01-03 08:52:41 UTC

apr-util-1.6.1-2.fc27 has been submitted as an update to Fedora 27. https://bodhi.fedoraproject.org/updates/FEDORA-2018-b24e8679cc

Comment 4 Fedora Update System 2018-01-03 22:30:13 UTC

apr-util-1.6.1-2.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-2018-b24e8679cc

Comment 5 Joe Orton 2018-01-04 08:21:09 UTC

FWIW I couldn't reproduce a problem using simply "DBDriver mysql" with

apr-util-mysql-1.6.1-1.fc27.x86_64
httpd-2.4.29-1.fc27.x86_64
mariadb-libs-10.2.9-3.fc27.x86_64

... but please try the packages in updates-testing.

Comment 6 Joe Orton 2018-01-04 08:25:09 UTC

Ah, I can with the mariadb service running, and can confirm it is fixed with 

apr-util-mysql-1.6.1-2.fc27.x86_64

... so, thanks to Honza.

Comment 7 Fedora Update System 2018-01-10 02:05:05 UTC

apr-util-1.6.1-2.fc27 has been pushed to the Fedora 27 stable repository. If problems still persist, please make note of it in this bug report.