From dad5888cea24eb71cb58d0a260a208ba6e2d8073 Mon Sep 17 00:00:00 2001 From: Silvio Rhatto Date: Wed, 4 Aug 2010 22:43:58 -0300 Subject: Initial import --- templates/postfix/sql/mysql-virtual-mailbox-limit-maps.cf.erb | 5 +++++ .../postfix/sql/mysql_virtual_alias_domain_catchall_maps.cf.erb | 5 +++++ .../postfix/sql/mysql_virtual_alias_domain_mailbox_maps.cf.erb | 5 +++++ templates/postfix/sql/mysql_virtual_alias_domain_maps.cf.erb | 5 +++++ templates/postfix/sql/mysql_virtual_alias_maps.cf.erb | 6 ++++++ templates/postfix/sql/mysql_virtual_domains_maps.cf.erb | 9 +++++++++ templates/postfix/sql/mysql_virtual_mailbox_maps.cf.erb | 6 ++++++ 7 files changed, 41 insertions(+) create mode 100644 templates/postfix/sql/mysql-virtual-mailbox-limit-maps.cf.erb create mode 100644 templates/postfix/sql/mysql_virtual_alias_domain_catchall_maps.cf.erb create mode 100644 templates/postfix/sql/mysql_virtual_alias_domain_mailbox_maps.cf.erb create mode 100644 templates/postfix/sql/mysql_virtual_alias_domain_maps.cf.erb create mode 100644 templates/postfix/sql/mysql_virtual_alias_maps.cf.erb create mode 100644 templates/postfix/sql/mysql_virtual_domains_maps.cf.erb create mode 100644 templates/postfix/sql/mysql_virtual_mailbox_maps.cf.erb (limited to 'templates/postfix/sql') 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 -- cgit v1.2.3