httpd + mod_auth_mysql in Fedora 15

[rabiek]

I did upgrade my F14 to F15 today, I was running Apache and Mysql, and after the upgrade I have an issue starting httpd.

I tried the following command :
/etc/init.d/httpd start

but I got the following error :

Starting httpd (via systemctl): Job failed. See system logs and 'systemctl status' for details.
[FAILED]


so ran : httpd -t to see the loaded modules and I found out there is a Syntax Error

httpd: Syntax error on line 238 of /etc/httpd/conf/httpd.conf: Syntax error on line 6 of /etc/httpd/conf.d/auth_mysql.conf: Cannot load /etc/httpd/modules/mod_auth_mysql.so into server: /etc/httpd/modules/mod_auth_mysql.so: undefined symbol: make_scrambled_password

Line 6 is : LoadModule mysql_auth_module modules/mod_auth_mysql.so

it seems normal to me. the mod_auth_mysql.so exists in this two folders :
/usr/lib64/httpd/modules/ and /etc/httpd/modules

Linux localhost 2.6.38.6-27.fc15.x86_64 #1 SMP Sun May 15 17:23:28 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux


is this a known issue !!!

[tboland]

I just updated also. Same problem. It looks like a bug in F15.

libmysqlclient.so is upgraded from .16 to .18.

mod_auth_mysql.so is making a deprecated call (make_scrambled_password). libmysqlclient.so.16 allows the call, libmysqlclient.so.18 does not allow the call.

To get my apache running, I commented out the "LoadModule mysql_auth_module modules/mod_auth_mysql.so" directive in /etc/httpd/conf.d/auth_mysql.conf and /etc/httpd/httpd.conf. It was in both on my install. YMMV.

This looks like it will take an update of mod_auth_mysql.so from Fedora to fix it.

You could try to install libmysqlclient.so.16, but I don't know what other problems that would cause for the other Apache mysql modules.

There was a bug report in F15 alpha concerning PureFTPd about the same type of problem with the deprecated call and that was fixed with an update.

Tom

[tboland]

This has been reported to bugzilla.redhat.com already.
Not assigned for repair yet.
No ETA for release of bug fix.
Bug ID#708287.

[rabiek]

Thanks tboland,

I did compile it from the source and it is working.

Thank you for your response.

[tboland]

Source from apache.org or elsewhere? Looking to solve it myself. Thanks

Tom

[rabiek]

I tried to share it earlier using the url tag but it would not allow me to insert it:

modauthmysql.sourceforge.net

precompiled can be found under heuer.org/mod_auth_mysql/

Regards,

Rabiek

[tboland]

I just downloaded a test fix from bugzilla. It is being submitted for standard update with 48 hours. It replaces mod_auth_mysql.so.