X-Git-Url: https://git.ralfj.de/ansible.git/blobdiff_plain/0aacb9f875a40b18dfbbc01b705b5337bf872368..a0ef97a3169e9da8b4618116075d54c49b4292b4:/roles/email/templates/mysql_vmail_users.cf

diff --git a/roles/email/templates/mysql_vmail_users.cf b/roles/email/templates/mysql_vmail_users.cf
new file mode 100644
index 0000000..7ddb1f4
--- /dev/null
+++ b/roles/email/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'