[sork] Passwd Problems - Cannot Change password, no UPDATE applied

[Eric Jon Rostetter]

Quoting Simon Brereton <simon.brereton at dada.net>:

> 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 = 'simon at lydiard.net'

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.