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

[nada aziz]

----- Original Message ----- 
From: "Simon Brereton" <simon.brereton at dada.net>
To: <sork at lists.horde.org>
Sent: Wednesday, September 29, 2010 4:52 PM
Subject: Re: [sork] failure in changing password for horde 
authentication:user not found


>> 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
>        ),
>    )),
> ));
i used this for my backends.php:

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

   ),
    'driver' => 'composite',
    'params' => array('drivers' => array(
        'sql' => array(
            'name' => 'Horde Authentication',
            'driver' => 'sql',
            'required' => true,
            'params' => array(
                'phptype'    => 'mysql',
                'hostspec'   => 'localhost',
                'username'   => 'horde',
                'password'   => 'my 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'   => 'my password',
         'encryption' => 'plain',
         'database'   => 'postfix',
         'table'      => 'mailbox',
         'user_col'   => 'username',
         'pass_col'   => 'password',
         'show_encryption' => false,

        ),
    )),
 ));

but i got (failure in changing password for Example All services: Failure in 
changing password for Horde Authentication: Unable to connect to sql server)
please help, i am new to horde and dont know php.
thanks in advance
>
>
>> > 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
>
>
> -- 
> Sork mailing list - Join the hunt: http://horde.org/bounties/#sork
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: sork-unsubscribe at lists.horde.org
>