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

[nada aziz]

----- Original Message ----- 
From: "Simon Brereton" <simon.brereton at dada.net>
To: <sork at lists.horde.org>
Sent: Thursday, September 30, 2010 9:41 PM
Subject: Re: [sork] failure in changing password forhorde 
authentication:user not found


>> -----Original Message-----
>> From: sork-bounces at lists.horde.org [mailto:sork-
>> bounces at lists.horde.org] On Behalf Of nada aziz
>
>
>> 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
>
>
> Looks fine, but no one but you can comment on your system.  Your problem 
> is not a lack of understanding of php, it's a lack of understanding about 
> mysql.  The horde backend is set up so that no knowledge of php is 
> necessary (which is amazing when you think of it).
you are wright, i am new in everything and creating a mail server is my 
first actuall task.
>
> Add these lines to you last block under show_encryption
> 'query_lookup' => 'SELECT password FROM mailbox  WHERE username = %u',
> 'query_modify' => 'UPDATE mailbox SET password = %p WHERE username = %u',
>
> But if it doesn't resolve your issue, you're going to have to increase 
> your debugging on the mysql.log and watch it in realtime as you tinker. 
> Until you do that no one can help you - especially not yourself.  The 
> mysql log is the only place you'll work out whether the input from your 
> form and the actions passwd is trying to do match your DB and structure.
>
it didnt work i got the same error, since i am new in everything can you 
help me increase my debugging on the mysql.log.
thanks very much for your help.
> 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