extend postfix: vmail and more

[ansible.git] / roles / postfix / templates / mysql_vmail_users.cf

diff --git a/roles/postfix/templates/mysql_vmail_users.cf b/roles/postfix/templates/mysql_vmail_users.cf
new file mode 100644 (file)
index 0000000..7ddb1f4
--- /dev/null
+++ b/roles/postfix/templates/mysql_vmail_users.cf
@@ -0,0 +1,6 @@
+# It is also used to check ownership, mapping email addresses to usernames - however, in my setup, the email address is the username.
+user = vmail
+password = {{ postfix.vmail_mysql_password }}
+hosts = localhost
+dbname = vmail
+query = SELECT username FROM users WHERE username='%s' AND active = '1'