[Tickets #1333] Changing password fails with DB: Error

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: https://dev.horde.org/horde/whups/ticket/?id=1333
-----------------------------------------------------------------------
 Ticket     | 1333
 Updated By | mike at theupstairsroom.com
 Summary    | Changing password fails with DB: Error
 Queue      | Passwd
 Version    | HEAD
 State      | Feedback
 Priority   | 1. Low
 Type       | Bug
 Owners     | 
-----------------------------------------------------------------------


mike at theupstairsroom.com (2005-02-08 10:30) wrote:

In passwd/config/backends.php:

$backends['sql'] = array (
    'name' => 'Horde Authentication',
    'preferred' => '',
    'password policy' => array(
        'minLength' => 3,
        'maxLength' => 8,
        'maxSpace' => 0,
        'minUpper' => 0,
        'minLower' => 1,
        'minNumeric' => 1,
        'minSymbols' => 0
    ),
    'driver' => 'sql',
    'params' => array(
        'phptype'    => 'mysql',
        'hostspec'   => 'localhost',
        'username'   => 'horde',
        'password'   => 'real_password',
        'encryption' => 'md5-hex',
        'database'   => 'horde',
        'table'      => 'horde_users',
        'user_col'   => 'user_uid',
        'pass_col'   => 'user_pass',
        'show_encryption' => false
    )
);

Log:

Feb 08 13:19:17 HORDE [debug] [passwd] SQL Query by
Passwd_Driver_sql::_lookup(): SELECT user_pass FROM horde_users WHERE
user_uid = NULL [on line 103 of
"/home/www/html/horde/passwd/lib/Driver/sql.php"]

To clarify, the error I get is 'User not found' - the username is typed into
the username field. ..again, if I select not to allow the username field to
show, this works fine.