Skip Menu |
 

This queue is for tickets about the Apache-DBI CPAN distribution.

Report information
The Basics
Id: 17073
Status: resolved
Priority: 0/
Queue: Apache-DBI

People
Owner: pgollucci [...] p6m7g8.com
Requestors: rkimmelmann [...] web.de
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 0.9901
Fixed in: (no value)



Subject: Error using AuthDBI with MySQL
Download (untitled) / with headers
text/plain 561b
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
Download (untitled) / with headers
text/plain 399b
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


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.