Bug 1526789 - httpd does not work with mysql in f27, although apr-util-mysql properly installed
Summary: httpd does not work with mysql in f27, although apr-util-mysql properly insta...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: httpd
Version: 27
Hardware: i686
OS: Linux
unspecified
urgent
Target Milestone: ---
Assignee: Luboš Uhliarik
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On: 1494093
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-12-17 13:11 UTC by Tom Kovar
Modified: 2018-01-10 02:05 UTC (History)
6 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2018-01-10 02:05:05 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

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.


Note You need to log in before you can comment on or make changes to this bug.