md5() was added to core postgresql as of 7.4, so it may be to new for
dbmail to require it, but as of 7.4 contrib is not required.
Jesse Norell wrote:
Hello,
DBMA 2.0.2 uses MD5-Digest (md5sum) by default for MySQL which is a
built-in since around v4.0 but I am in a quandary with PostgreSQL which
seems to rely on contribs to handle md5 selects. There also seems to be
quite a range of options. I wonder what seasoned PostgreSQL folks would
favour? (Is anyone using PSQL 8-beta?)
What we do is have the application do all the md5 functions (which are
quite easy in perl) and just pass the actual hash back and forth between
the database. That way you plaintext passwords never cross the network
(assuming your db server is on another computer), so it's more secure,
and it doesn't need any of the pgsql contrib md5 functions.
--
Jesse Norell
[EMAIL PROTECTED] is not my email address;
change "administrator" to my first name.
--
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
