Hi
I'm putting some simple screens together in zope to allow some users to
change their passwords. I think we're using 1.0rc4 with mysql patches.
We usually add passwords using phpmyadmin and 'encrypt' them.
I thought I could use a sql statement to check their existing username &
password like
SELECT * FROM users
WHERE
passwd = encrypt('passwdsupplied')
AND
userid = useridsupplied
but this doesn't work - I guess it's due to not using a 'salt' to generate
consistant encrypt results.
But how does dbmail authenticate users in the db?
Any hints - greatly received.
Kind regards
Guy Redwood
SimpleUsability Ltd
Maximising ROI through minimal change.
http://www.SimpleUsability.com