X-Git-Url: https://git.ralfj.de/ansible.git/blobdiff_plain/d60c3d0624872eacb41ee95e2cc29ae88a0372f9..4ae7df074f5a9241c4e2590562efc45defc9f579:/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
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'