[sork] problem to change passwd

[René Lund Jensen]

Yep.. I have the same problem...

If you look in the entry made by the sql driver from Passwd it prepends 
{crypt} to the encrypted password. (and expects this to be in the 
password retrieved from the DB, so it chops off 7 characters before 
doing the verification.)

furthermore.. I use STD_DES with a 2 character salt.
(My PostFix/Courier-IMAP solution wants it this way)
But sql/crypt made some weird password which PostFix/Courier did not 
understand, (because of not setting a specific salt).

So I ended p hacking the sql/crypt driver to fit my needs.

I guess the sql driver is intended to use with Horde.
Maybe there should be two sql drivers:
horde-sql and sql ?

René Jensen

John-Patrick Obermeier wrote:
> hi,
> 
> i've a problem to change password with passwd.
> first my system and backend configuration:
> 
> horde 3.x
> imp 4.0
> passwd 2.1
> IMAP/Cyrus with MySQL authentification
> password with crypt encryption
> 
> backend.php:
> 
> $backends['sql'] = array (
>    'name' => 'Horde Authentication',
>    'preferred' => '',
>    'password policy' => array(
>        'minLength' => 3,
>        'maxLength' => 8,
>        'maxSpace' => 0,
>        'minUpper' => 1,
>        'minLower' => 1,
>        'minNumeric' => 1
>    ),
>    'driver' => 'sql',
>    'params' => array(
>        'phptype'    => 'mysql',
>        'hostspec'   => 'localhost',
>        'username'   => 'mail',
>        'password'   => '*****',
>        'encryption' => 'crypt',
>        'database'   => 'mail',
>        'table'      => 'accountuser',
>        'user_col'   => 'username',
>        'pass_col'   => 'password'
>    )
> );
> 
> if i want to change the password, the SORK:passwd can not authorize the 
> change. the error message is: "*Incorrect Password*".
> 
> thx for help
> 
> J.-P. Obermeier
> 
> 
> 
>