summaryrefslogtreecommitdiff
path: root/templates/postfix/sql
diff options
context:
space:
mode:
Diffstat (limited to 'templates/postfix/sql')
-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_limit_maps.cf.erb5
-rw-r--r--templates/postfix/sql/mysql_virtual_mailbox_maps.cf.erb6
7 files changed, 0 insertions, 41 deletions
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
deleted file mode 100644
index dd41a61..0000000
--- a/templates/postfix/sql/mysql_virtual_alias_domain_catchall_maps.cf.erb
+++ /dev/null
@@ -1,5 +0,0 @@
-user = <%= database_user %>
-password = <%= database_password %>
-hosts = <%= database_host %>
-dbname = <%= database_name %>
-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
deleted file mode 100644
index c148372..0000000
--- a/templates/postfix/sql/mysql_virtual_alias_domain_mailbox_maps.cf.erb
+++ /dev/null
@@ -1,5 +0,0 @@
-user = <%= database_user %>
-password = <%= database_password %>
-hosts = <%= database_host %>
-dbname = <%= database_name %>
-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
deleted file mode 100644
index fddfe91..0000000
--- a/templates/postfix/sql/mysql_virtual_alias_domain_maps.cf.erb
+++ /dev/null
@@ -1,5 +0,0 @@
-user = <%= database_user %>
-password = <%= database_password %>
-hosts = <%= database_host %>
-dbname = <%= database_name %>
-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
deleted file mode 100644
index d4b7164..0000000
--- a/templates/postfix/sql/mysql_virtual_alias_maps.cf.erb
+++ /dev/null
@@ -1,6 +0,0 @@
-user = <%= database_user %>
-password = <%= database_password %>
-hosts = <%= database_host %>
-dbname = <%= database_name %>
-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
deleted file mode 100644
index ecf253e..0000000
--- a/templates/postfix/sql/mysql_virtual_domains_maps.cf.erb
+++ /dev/null
@@ -1,9 +0,0 @@
-user = <%= database_user %>
-password = <%= database_password %>
-hosts = <%= database_host %>
-dbname = <%= database_name %>
-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_limit_maps.cf.erb b/templates/postfix/sql/mysql_virtual_mailbox_limit_maps.cf.erb
deleted file mode 100644
index b40ce8f..0000000
--- a/templates/postfix/sql/mysql_virtual_mailbox_limit_maps.cf.erb
+++ /dev/null
@@ -1,5 +0,0 @@
-user = <%= database_user %>
-password = <%= database_password %>
-hosts = <%= database_host %>
-dbname = <%= database_name %>
-query = SELECT quota FROM mailbox WHERE username='%s' AND active = '1'
diff --git a/templates/postfix/sql/mysql_virtual_mailbox_maps.cf.erb b/templates/postfix/sql/mysql_virtual_mailbox_maps.cf.erb
deleted file mode 100644
index 4e4b54e..0000000
--- a/templates/postfix/sql/mysql_virtual_mailbox_maps.cf.erb
+++ /dev/null
@@ -1,6 +0,0 @@
-user = <%= database_user %>
-password = <%= database_password %>
-hosts = <%= database_host %>
-dbname = <%= database_name %>
-query = SELECT maildir FROM mailbox WHERE username='%s' AND active = '1'
-#expansion_limit = 100