hosts = ${config.myEnv.mail.postfix.mysql.remoteHost}
dbname = ${config.myEnv.mail.postfix.mysql.database}
query = SELECT DISTINCT 1
- FROM forwardings_merge
+ FROM forwardings
WHERE
((regex = 1 AND '%s' REGEXP CONCAT('^',source,'$') ) OR (regex = 0 AND source = '%s'))
AND active = 1
LIMIT 1
'';
}
+ {
+ dest = "postfix/sympa_mailbox_maps";
+ user = config.services.postfix.user;
+ group = config.services.postfix.group;
+ permissions = "0440";
+ text = ''
+ hosts = ${config.myEnv.mail.sympa.postgresql.host}
+ user = ${config.myEnv.mail.sympa.postgresql.user}
+ password = ${config.myEnv.mail.sympa.postgresql.password}
+ dbname = ${config.myEnv.mail.sympa.postgresql.database}
+ query = SELECT DISTINCT CONCAT(name_list, '@', robot_list) FROM list_table
+ '';
+ }
{
dest = "postfix/ldap_ejabberd_users_immae_fr";
user = config.services.postfix.user;
networking.firewall.allowedTCPPorts = [ 25 ];
- nixpkgs.overlays = [ (self: super: {
- postfix = super.postfix.override { withMySQL = true; };
- }) ];
users.users."${config.services.postfix.user}".extraGroups = [ "keys" ];
services.filesWatcher.postfix = {
restart = true;
paths = [
config.secrets.fullPaths."postfix/mysql_alias_maps"
config.secrets.fullPaths."postfix/mysql_mailbox_maps"
+ config.secrets.fullPaths."postfix/sympa_mailbox_maps"
config.secrets.fullPaths."postfix/ldap_ejabberd_users_immae_fr"
];
};
virtual_mailbox_maps = [
"hash:/etc/postfix/host_dummy_mailboxes"
"mysql:${config.secrets.fullPaths."postfix/mysql_mailbox_maps"}"
+ "pgsql:${config.secrets.fullPaths."postfix/sympa_mailbox_maps"}"
];
in
backup_recipients ++ virtual_alias_maps ++ virtual_mailbox_maps;