summaryrefslogtreecommitdiff
path: root/templates/postfix
diff options
context:
space:
mode:
authorSilvio Rhatto <rhatto@riseup.net>2010-08-04 22:43:58 -0300
committerSilvio Rhatto <rhatto@riseup.net>2010-08-04 22:43:58 -0300
commitdad5888cea24eb71cb58d0a260a208ba6e2d8073 (patch)
treef84b5e77b78a39b85a141a9e00c0622689d7ca27 /templates/postfix
downloadpuppet-mail-dad5888cea24eb71cb58d0a260a208ba6e2d8073.tar.gz
puppet-mail-dad5888cea24eb71cb58d0a260a208ba6e2d8073.tar.bz2
Initial import
Diffstat (limited to 'templates/postfix')
-rw-r--r--templates/postfix/sql/mysql-virtual-mailbox-limit-maps.cf.erb5
-rw-r--r--templates/postfix/sql/mysql_virtual_alias_domain_catchall_maps.cf.erb5
-rw-r--r--templates/postfix/sql/mysql_virtual_alias_domain_mailbox_maps.cf.erb5
-rw-r--r--templates/postfix/sql/mysql_virtual_alias_domain_maps.cf.erb5
-rw-r--r--templates/postfix/sql/mysql_virtual_alias_maps.cf.erb6
-rw-r--r--templates/postfix/sql/mysql_virtual_domains_maps.cf.erb9
-rw-r--r--templates/postfix/sql/mysql_virtual_mailbox_maps.cf.erb6
7 files changed, 41 insertions, 0 deletions
diff --git a/templates/postfix/sql/mysql-virtual-mailbox-limit-maps.cf.erb b/templates/postfix/sql/mysql-virtual-mailbox-limit-maps.cf.erb
new file mode 100644
index 0000000..357bcb3
--- /dev/null
+++ b/templates/postfix/sql/mysql-virtual-mailbox-limit-maps.cf.erb
@@ -0,0 +1,5 @@
+user = <%= postfixadmin_user %>
+password = <%= postfixadmin_password %>
+hosts = <%= postfixadmin_hosts %>
+dbname = <%= postfixadmin_dbname %>
+query = SELECT quota FROM mailbox WHERE username='%s' AND active = '1'
diff --git a/templates/postfix/sql/mysql_virtual_alias_domain_catchall_maps.cf.erb b/templates/postfix/sql/mysql_virtual_alias_domain_catchall_maps.cf.erb
new file mode 100644
index 0000000..19374f2
--- /dev/null
+++ b/templates/postfix/sql/mysql_virtual_alias_domain_catchall_maps.cf.erb
@@ -0,0 +1,5 @@
+user = <%= postfixadmin_user %>
+password = <%= postfixadmin_password %>
+hosts = <%= postfixadmin_hosts %>
+dbname = <%= postfixadmin_dbname %>
+query = SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = '%d' and alias.address = CONCAT('@', alias_domain.target_domain) AND alias.active = 1 AND alias_domain.active='1'
diff --git a/templates/postfix/sql/mysql_virtual_alias_domain_mailbox_maps.cf.erb b/templates/postfix/sql/mysql_virtual_alias_domain_mailbox_maps.cf.erb
new file mode 100644
index 0000000..ef7a880
--- /dev/null
+++ b/templates/postfix/sql/mysql_virtual_alias_domain_mailbox_maps.cf.erb
@@ -0,0 +1,5 @@
+user = <%= postfixadmin_user %>
+password = <%= postfixadmin_password %>
+hosts = <%= postfixadmin_hosts %>
+dbname = <%= postfixadmin_dbname %>
+query = SELECT maildir FROM mailbox,alias_domain WHERE alias_domain.alias_domain = '%d' and mailbox.username = CONCAT('%u', '@', alias_domain.target_domain) AND mailbox.active = 1 AND alias_domain.active='1'
diff --git a/templates/postfix/sql/mysql_virtual_alias_domain_maps.cf.erb b/templates/postfix/sql/mysql_virtual_alias_domain_maps.cf.erb
new file mode 100644
index 0000000..10da8ad
--- /dev/null
+++ b/templates/postfix/sql/mysql_virtual_alias_domain_maps.cf.erb
@@ -0,0 +1,5 @@
+user = <%= postfixadmin_user %>
+password = <%= postfixadmin_password %>
+hosts = <%= postfixadmin_hosts %>
+dbname = <%= postfixadmin_dbname %>
+query = SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = '%d' and alias.address = CONCAT('%u', '@', alias_domain.target_domain) AND alias.active = 1 AND alias_domain.active='1'
diff --git a/templates/postfix/sql/mysql_virtual_alias_maps.cf.erb b/templates/postfix/sql/mysql_virtual_alias_maps.cf.erb
new file mode 100644
index 0000000..2bf5d9d
--- /dev/null
+++ b/templates/postfix/sql/mysql_virtual_alias_maps.cf.erb
@@ -0,0 +1,6 @@
+user = <%= postfixadmin_user %>
+password = <%= postfixadmin_password %>
+hosts = <%= postfixadmin_hosts %>
+dbname = <%= postfixadmin_dbname %>
+query = SELECT goto FROM alias WHERE address='%s' AND active = '1'
+#expansion_limit = 100
diff --git a/templates/postfix/sql/mysql_virtual_domains_maps.cf.erb b/templates/postfix/sql/mysql_virtual_domains_maps.cf.erb
new file mode 100644
index 0000000..cc26c90
--- /dev/null
+++ b/templates/postfix/sql/mysql_virtual_domains_maps.cf.erb
@@ -0,0 +1,9 @@
+user = <%= postfixadmin_user %>
+password = <%= postfixadmin_password %>
+hosts = <%= postfixadmin_hosts %>
+dbname = <%= postfixadmin_dbname %>
+query = SELECT domain FROM domain WHERE domain='%s' AND active = '1'
+#query = SELECT domain FROM domain WHERE domain='%s'
+#optional query to use when relaying for backup MX
+#query = SELECT domain FROM domain WHERE domain='%s' AND backupmx = '0' AND active = '1'
+#expansion_limit = 100
diff --git a/templates/postfix/sql/mysql_virtual_mailbox_maps.cf.erb b/templates/postfix/sql/mysql_virtual_mailbox_maps.cf.erb
new file mode 100644
index 0000000..6d3d642
--- /dev/null
+++ b/templates/postfix/sql/mysql_virtual_mailbox_maps.cf.erb
@@ -0,0 +1,6 @@
+user = <%= postfixadmin_user %>
+password = <%= postfixadmin_password %>
+hosts = <%= postfixadmin_hosts %>
+dbname = <%= postfixadmin_dbname %>
+query = SELECT maildir FROM mailbox WHERE username='%s' AND active = '1'
+#expansion_limit = 100