gutsy does not have a working apache+mysql authentication solution
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Debian |
Fix Released
|
Unknown
|
|||
apr-util (Ubuntu) |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
Binary package hint: libaprutil1
As of Mon Oct 8 17:08:24 EEST 2007, there is no working solution to authenticate with mysql from apache. This is a serious problem that might hinder migration to gutsy in many sites.
I have to file this bug against two packages as there are two possible solutions for mysql authentication, *neither of which work*:
1 [DEPRECATED] libapache2-
doesn't honour the AuthBasicAuthor
2 [RECOMMENDED by Apache Foundation] mod_authn_dbd
(http://
Versions:
-------------
Updated Gutsy beta release.
apache2-mpm-prefork 2.2.4-3build1
libaprutil1 1.2.7+dfsg-2build1
Setup:
-------------
a2enmod authn_dbd
virtual host conf:
DBDriver mysql
DBParams host=localhost, user=authtestuser, pass=something, dbname=
<Location /dbdauth>
</Location>
db setup:
DROP database IF EXISTS apache_auth_test;
create database apache_auth_test;
use apache_auth_test;
create table auth ( username char(25) not null,
passwd char(25), primary key (username) );
insert into auth values ('somebody', PASSWORD(
grant all privileges on apache_auth_test.* to authtestuser@
Result:
-------------
Apache doesn't start, complaining:
Syntax error on line 37 of /etc/apache2/
DBD: No driver for mysql
...fail!
Conclusion:
-------------
mysql driver is missing from libaprutils. See also Debian bug #405773
This bug is still valid in Hardy - I can't believe no one else has a problem with this. Any news on this front?