diff options
author | Silvio Rhatto <rhatto@riseup.net> | 2010-08-08 13:33:16 -0300 |
---|---|---|
committer | Silvio Rhatto <rhatto@riseup.net> | 2010-08-08 13:33:16 -0300 |
commit | 882512b64dc8ae53ea5f7a661ed325133653bf6f (patch) | |
tree | 17d98e26fd541d74c7e9f9801f3011e422d490ed /templates/postfix/sql | |
parent | 578987e73074ea93f569e9f07249f59dd9f2f609 (diff) | |
download | puppet-mail-882512b64dc8ae53ea5f7a661ed325133653bf6f.tar.gz puppet-mail-882512b64dc8ae53ea5f7a661ed325133653bf6f.tar.bz2 |
Postfixadmin configuration
Diffstat (limited to 'templates/postfix/sql')
7 files changed, 28 insertions, 28 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 index 19374f2..9fa4867 100644 --- a/templates/postfix/sql/mysql_virtual_alias_domain_catchall_maps.cf.erb +++ b/templates/postfix/sql/mysql_virtual_alias_domain_catchall_maps.cf.erb @@ -1,5 +1,5 @@ -user = <%= postfixadmin_user %> -password = <%= postfixadmin_password %> -hosts = <%= postfixadmin_hosts %> -dbname = <%= postfixadmin_dbname %> +user = <%= postfixadmin_database_user %> +password = <%= postfixadmin_database_password %> +hosts = <%= postfixadmin_database_host %> +dbname = <%= postfixadmin_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 index ef7a880..b7aabf2 100644 --- a/templates/postfix/sql/mysql_virtual_alias_domain_mailbox_maps.cf.erb +++ b/templates/postfix/sql/mysql_virtual_alias_domain_mailbox_maps.cf.erb @@ -1,5 +1,5 @@ -user = <%= postfixadmin_user %> -password = <%= postfixadmin_password %> -hosts = <%= postfixadmin_hosts %> -dbname = <%= postfixadmin_dbname %> +user = <%= postfixadmin_database_user %> +password = <%= postfixadmin_database_password %> +hosts = <%= postfixadmin_database_host %> +dbname = <%= postfixadmin_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 index 10da8ad..ac120c0 100644 --- a/templates/postfix/sql/mysql_virtual_alias_domain_maps.cf.erb +++ b/templates/postfix/sql/mysql_virtual_alias_domain_maps.cf.erb @@ -1,5 +1,5 @@ -user = <%= postfixadmin_user %> -password = <%= postfixadmin_password %> -hosts = <%= postfixadmin_hosts %> -dbname = <%= postfixadmin_dbname %> +user = <%= postfixadmin_database_user %> +password = <%= postfixadmin_database_password %> +hosts = <%= postfixadmin_database_host %> +dbname = <%= postfixadmin_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 index 2bf5d9d..f80c6fc 100644 --- a/templates/postfix/sql/mysql_virtual_alias_maps.cf.erb +++ b/templates/postfix/sql/mysql_virtual_alias_maps.cf.erb @@ -1,6 +1,6 @@ -user = <%= postfixadmin_user %> -password = <%= postfixadmin_password %> -hosts = <%= postfixadmin_hosts %> -dbname = <%= postfixadmin_dbname %> +user = <%= postfixadmin_database_user %> +password = <%= postfixadmin_database_password %> +hosts = <%= postfixadmin_database_host %> +dbname = <%= postfixadmin_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 index cc26c90..0706f4b 100644 --- a/templates/postfix/sql/mysql_virtual_domains_maps.cf.erb +++ b/templates/postfix/sql/mysql_virtual_domains_maps.cf.erb @@ -1,7 +1,7 @@ -user = <%= postfixadmin_user %> -password = <%= postfixadmin_password %> -hosts = <%= postfixadmin_hosts %> -dbname = <%= postfixadmin_dbname %> +user = <%= postfixadmin_database_user %> +password = <%= postfixadmin_database_password %> +hosts = <%= postfixadmin_database_host %> +dbname = <%= postfixadmin_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 diff --git a/templates/postfix/sql/mysql_virtual_mailbox_limit_maps.cf.erb b/templates/postfix/sql/mysql_virtual_mailbox_limit_maps.cf.erb index 357bcb3..61804f3 100644 --- a/templates/postfix/sql/mysql_virtual_mailbox_limit_maps.cf.erb +++ b/templates/postfix/sql/mysql_virtual_mailbox_limit_maps.cf.erb @@ -1,5 +1,5 @@ -user = <%= postfixadmin_user %> -password = <%= postfixadmin_password %> -hosts = <%= postfixadmin_hosts %> -dbname = <%= postfixadmin_dbname %> +user = <%= postfixadmin_database_user %> +password = <%= postfixadmin_database_password %> +hosts = <%= postfixadmin_database_host %> +dbname = <%= postfixadmin_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 index 6d3d642..f52049b 100644 --- a/templates/postfix/sql/mysql_virtual_mailbox_maps.cf.erb +++ b/templates/postfix/sql/mysql_virtual_mailbox_maps.cf.erb @@ -1,6 +1,6 @@ -user = <%= postfixadmin_user %> -password = <%= postfixadmin_password %> -hosts = <%= postfixadmin_hosts %> -dbname = <%= postfixadmin_dbname %> +user = <%= postfixadmin_database_user %> +password = <%= postfixadmin_database_password %> +hosts = <%= postfixadmin_database_host %> +dbname = <%= postfixadmin_database_name %> query = SELECT maildir FROM mailbox WHERE username='%s' AND active = '1' #expansion_limit = 100 |