I am using this howto to set up a postfix email server. http://howtoforge.com/virtual_users_and_domains_with_postfix_debian_etch I want to add users to my email server using the following SQL INSERT users (email, iv, password) VALUES ('[email protected]', (RAND()*4294967295), SHA(CONCAT('plain text pwd', iv))); This uses the database's SHA algorithm which is more secure then the ENCRYPT algorithm. It also uses an initialization vector which ensures no two users have the same hash when they use the same password. I am just not sure I can use this for all the different modules that are authenticating against the MySQL database. Does anyone know if this is impossible?
