[sork] failure in changing password for horde authentication:user not found

[Simon Brereton]

> From: Nada Aziz [mailto:nada.aziz at hashab.com]
> Sent: Wednesday, September 29, 2010 3:18 AM
> To: Simon Brereton


> thanks for the quick reply

Please stay on list.


> > Do you actually have any data in the horde_users table?  Are you
> > actually using that table to authenticate Horde access too?
> 
> apparently i don't have any data in the horde_users table.
> the users are stored in a different table "mailbox" in the postfix
> database, should i change my backends.php using the new table and
> columns?

Yes.  For example, here is how I do it.  I also use the same DB as postfix is using..

$backends['composite'] = array(
    'name' => 'All Services',
    'preferred' => '',
    'password policy' => array(
        'minLength' => 8,
        'maxLength' => 18,
        'minClasses' => 2,
                'maxSpace' => 0,
                'minUpper' => 1,
            'minLower' => 1,
            'minNumeric' => 1,
            'minSymbols' => 1

   ),
    'driver' => 'composite',
    'params' => array('drivers' => array(
        'sql' => array(
            'name' => 'Horde Authentication',
            'driver' => 'sql',
            'required' => true,
            'params' => array(
                'phptype'    => 'mysql',
                'hostspec'   => 'localhost',
                'username'   => 'horde',
                'password'   => '',
                'encryption' => 'md5-hex',
                'database'   => 'horde',
                'table'      => 'horde_users',
                'user_col'   => 'user_uid',
                'pass_col'   => 'user_pass',
                'show_encryption' => false
                // 'query_lookup' => '',
                // 'query_modify' => '',
            ),
       ),
       'sql' => array(
                        'name' => 'Postfix',
                'driver' => 'sql',
                        'required' => true,
                'params' => array(
         'phptype'    => 'mysql',
         'hostspec'   => 'localhost',
         'username'   => 'postfix',
         'password'   => 'removed',
         'encryption' => 'plain',
         'database'   => 'Mail',
         'table'      => 'Accounts',
         'user_col'   => 'Email',
         'pass_col'   => 'password',   //Although my actual table has Password, sork wouldn't work unless I used lowercase.
         'show_encryption' => false,
         // The following two settings allow you to specify custom queries for
         // lookup and modify functions if special functions need to be
         // performed.  In places where a username or a password needs to be
         // used, refer to this placeholder reference:
         // The following two settings allow you to specify custom queries for
         // lookup and modify functions if special functions need to be
         // performed.  In places where a username or a password needs to be
         // used, refer to this placeholder reference:
         //    %u -> gets substituted with the user
         //    %p -> gets substituted with the plaintext password
         //    %e -> gets substituted with the encrypted password
        ),
    )),
 ));


> > If your answer to that question is yes, then Eric's advice is the
> way
> > to go.  What happens when you run a mysql query from the
> commandline
> > on those parameters?  The easiest way to troubleshoot this is bump
> up
> > the MYSQL logging (don't forget to take it down again unless you
> want
> > a half gig of logs), tail the log and watch what goes through when
> you
> > actually try to change your password on the interface).
> 
> horde and mysql logs don't show anything regarding the subject.

Try editing your /etc/init.d/mysql to start with -v or use that when you try the commands from the commandline.  Alternatively edit your my.cnf

Simon