title: Cakephp Auth login returns false even though SQL query finds rows
body: <p>I have Cakephp app installed on a linux box.
  The Mysql Driver is installed and php-pecl-acl has been removed.
  There are no problems with the Cookies. The users and passwords exist in the database. The password is a CHAR(40) in the database. </p>
  
  <p>The Auth->login() method <strong>always returns false</strong>, even though the sql query debug log shows that rows affected = 1</p>
  
  <pre><code>array(
  'log' =&gt; array(
      (int) 0 =&gt; array(
          'query' =&gt; 'SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, FROM `somedatabase`.`users` AS `User`   WHERE `User`.`username` = 'someuser' AND `User`.`password` = '2d7a34c9ef8efa2cfdf4b89175f7edec1cd0ddda'    LIMIT 1',
          'params' =&gt; array(),
          'affected' =&gt; (int) 1,
          'numRows' =&gt; (int) 1,
          'took' =&gt; (float) 2
      )
  ),
  'count' =&gt; (int) 1,
  'time' =&gt; (float) 2
  </code></pre>
  
  <p>Please help.
  Thank you.</p>