#17073: Error using AuthDBI with MySQL

Apache::AuthDBI does not work in my configuraton with Apache2 and MySQL
because the DBI command '$sth->rows()' always returns 0. (Even if a
password record has been found.)


Apache/AuthDBI.pm (line ~ 1340):
undef $passwd if 0 == $sth->rows; # so we can distinguish later on
between no password and empty password


Also the documentation for DBI.pm says not to use sth->rows() with
SELECT-Statements because not all DB-drivers return a correct value.


My configuration:
- RedHat Fedora Core 4
- perl, v5.8.6
- DBI 1.48
- DBD-mysql-2.1025
- Apache/2.0.54

Yikes, your DBD::mysql is ancient.

It works for me:

FreeBSD 6.1-RELEASE
perl 5.8.8 w/out ithreads
httpd 2.2.2 apr is not threaded
mod_perl svn trunk
DBI 1.50
DBD::mysql 3.004
mysql 5.1.9-beta

Though I agree that the DBI docs say that this method is inconsistent
across DBD::* drivers.

I'll see what I can come up with. In the meantime, I think if you
upgrade you should be good.

Committed revision 6409

This will be in 1.0_01