Referring to this and others: http://www.howtoforge.com/virtual-users-domains-postfix-courier-mysql-squirrelmail-ubuntu8.10 Specifically this line: GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost' IDENTIFIED BY 'mail_admin_password'; I'm wondering why this user account needs any write privileges to the mail database? As far as I know, it is only using select statements invoked by postfix.. Am I missing something here?
You're right, but if you want to write your own webmail interface where you can create, update and delete users, then this is useful. Also, SquirrelMail needs the UPDATE privilege because otherwise it wouldn't be possible to change passwords.
Thanks for the reply, falko. If may follow up with another question: Can I adapt the previously linked how-to with postfixadmin? If so what would be involved? Just rewrite the SQL look-ups to the postfixadmin created database and repopulate the postfixadmin tables from the other tables?
I've never tried Postfixadmin with this setup. You might have to change a few MySQL tables and also the SQL queries in the Postfix and Courier configuration.