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)

History Show all quoted text
  Sat Jan 14 13:05:58 2006 Guest - Ticket created
Subject: 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
  Sat May 27 04:52:42 2006 pgollucci [...] p6m7g8.com - Taken
  Mon May 29 01:33:01 2006 pgollucci [...] p6m7g8.com - Correspondence added
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.
  Mon May 29 01:33:02 2006 The RT System itself - Status changed from 'new' to 'open'
  Mon May 29 01:48:00 2006 pgollucci [...] p6m7g8.com - Correspondence added
Committed revision 6409 This will be in 1.0_01
  Mon May 29 01:48:01 2006 pgollucci [...] p6m7g8.com - Status changed from 'open' to 'resolved'