+ secrets.keys."dovecot/sql" = {
+ user = config.services.dovecot2.user;
+ group = config.services.dovecot2.group;
+ permissions = "0400";
+ text = ''
+ driver = mysql
+ connect = host=${config.myEnv.mail.dovecot.mysql.socket} dbname=${config.myEnv.mail.dovecot.mysql.database} user=${config.myEnv.mail.dovecot.mysql.user} password=${config.myEnv.mail.dovecot.mysql.password}
+ password_query = SELECT NULL AS password, 'Y' as noauthenticate, destination AS user \
+ FROM forwardings WHERE \
+ ((regex = 1 AND '%u' REGEXP CONCAT('^',source,'$')) OR (regex = 0 AND source = '%u')) \
+ AND active = 1
+ '';
+ };