Re: Passwd Problems - Cannot Change password, no UPDATE applied

Eric Jon Rostetter <[email protected]> Tue, 20 Oct 2009 15:24:29 -0500
Newsgroups gmane.comp.horde.sork
Message-ID <[email protected]>
Quoting Simon Brereton <[email protected]>:

> The page loads with the Old password prefilled (but it always seems  
> to be 10 characters no matter if I use a user with a longer or  
> shorter password.

This sounds to me like your browser is filling in the password field
for you with some saved password.  Try changing this to the proper password.

> Failure in changing password on Postfix (the name of my SQL backend)  
> : Incorrect Password

This sounds like the "old" password isn't being entered correctly, or
verified correctly...  See above for the first case.

> Passwd_Driver_sql::_lookup(): SELECT Password FROM MailAccounts  
> WHERE EmailAdd = ? [on line 110 of

Assuming that "EmailAdd" is the proper field name in you DB, this looks fine.

>                     582 Query       SELECT Password FROM  
> MailAccounts WHERE EmailAdd = '[email protected]'

Assuming the same as above, plus that your database stores the full
username with domain as shown, then this looks fine.

> concerns me is the total absence of any UPDATE statement.  I take it  
> this is not normal.

It first verifies the old password, and only if that succeeds does it
try the update.  So this would be normal if the old password is wrong,
or the query fails.

> Can someone please give me some pointers as what to investigate next.

If you haven't already, try typing the old password in rather than
using the pre-filled value...

> If you need other information, I'm happy to provide that too.
>
> Thanks.
>
> SPB

-- 
Eric Rostetter
The Department of Physics
The University of Texas at Austin

This message is provided "AS IS" without warranty of any kind,
either expressed or implied.  Use this message at your own risk.
-- 
Sork mailing list - Join the hunt: http://horde.org/bounties/#sork
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: [email protected]