Sieve and multi-auth databases
Hello Community,
I am currently facing the following:
- dovecot+postfix+sieve are running smoothly using passwd-file authentication
- if a add a second authentication scheme (let's say mysql), I face a problem with sieve: -- receiving thru postfix is ok on both passwd-file and mysql entries and correctly stored -- I am able to send from the server as before ** BUT sieve == does not authenticate anymore from a client (using the same configuration as before ie using imap credentials) == does not process the messages anymore
Digging in the sieve logs, it reports not finding the scripts anymore for existing accounts found in the passwd-file
Any idea?
Thank you!
Here is the 90-sieve.conf:
plugin { sieve = file:/sd/MAIL_IMAP_POP/%d/%n/_dovecot-sieve;active=/sd/MAIL_IMAP_POP/%d/%n/_dovecot-sieve-active sieve_default = /sd/myhost/var/lib/dovecot/sieve/default.sieve
sieve = /sd/MAIL_IMAP_POP/%d/%n/__Sieve
sieve_global_dir = /sd/myhost/var/lib/dovecot/sieve/global/
sieve_before = /sd/MAIL_IMAP_POP/SieveBefore sieve_after = /sd/MAIL_IMAP_POP/%d/SieveAfter/ sieve_after2 = /sd/MAIL_IMAP_POP/SieveAfter/
sieve_plugins = sieve_extprograms sieve_extensions = +vnd.dovecot.filter sieve_filter_bin_dir = /etc/dovecot/sieve-filters
}
Authentication for SQL users. Included from 10-auth.conf.
passdb sql { driver = sql args = /etc/dovecot/dovecot-sql.conf.ext # Associated query: # password_query = SELECT email as user, password FROM virtual_users WHERE email='%u'; }
userdb sql { driver = static args = uid=vmail gid=vmail home=/sd/MAIL_IMAP_POP/%d/%n:LAYOUT=fs }
Op 2/21/2017 om 5:19 PM schreef dovecot@avv.solutions:
Hello Community,
I am currently facing the following:
- dovecot+postfix+sieve are running smoothly using passwd-file authentication
- if a add a second authentication scheme (let's say mysql), I face a problem with sieve: -- receiving thru postfix is ok on both passwd-file and mysql entries and correctly stored -- I am able to send from the server as before ** BUT sieve == does not authenticate anymore from a client (using the same configuration as before ie using imap credentials) == does not process the messages anymore
Digging in the sieve logs, it reports not finding the scripts anymore for existing accounts found in the passwd-file
Any idea?
You should enable mail_debug. That will provide details on what Sieve is
doing regarding file system storage paths. Also a full dovecot -n
output is helpful.
Regards,
Stephan.
Thank you!
Here is the 90-sieve.conf:
plugin { sieve = file:/sd/MAIL_IMAP_POP/%d/%n/_dovecot-sieve;active=/sd/MAIL_IMAP_POP/%d/%n/_dovecot-sieve-active sieve_default = /sd/myhost/var/lib/dovecot/sieve/default.sieve
sieve = /sd/MAIL_IMAP_POP/%d/%n/__Sieve
sieve_global_dir = /sd/myhost/var/lib/dovecot/sieve/global/
sieve_before = /sd/MAIL_IMAP_POP/SieveBefore sieve_after = /sd/MAIL_IMAP_POP/%d/SieveAfter/ sieve_after2 = /sd/MAIL_IMAP_POP/SieveAfter/
sieve_plugins = sieve_extprograms sieve_extensions = +vnd.dovecot.filter sieve_filter_bin_dir = /etc/dovecot/sieve-filters
}
Authentication for SQL users. Included from 10-auth.conf.
passdb sql { driver = sql args = /etc/dovecot/dovecot-sql.conf.ext # Associated query: # password_query = SELECT email as user, password FROM virtual_users WHERE email='%u'; }
userdb sql { driver = static args = uid=vmail gid=vmail home=/sd/MAIL_IMAP_POP/%d/%n:LAYOUT=fs }
Op 2/21/2017 om 6:09 PM schreef Stephan Bosch:
Op 2/21/2017 om 5:19 PM schreef dovecot@avv.solutions:
- + - - - -
Authentication for SQL users. Included from 10-auth.conf.
passdb sql { driver = sql args = /etc/dovecot/dovecot-sql.conf.ext # Associated query: # password_query = SELECT email as user, password FROM virtual_users WHERE email='%u'; }
userdb sql { driver = static args = uid=vmail gid=vmail home=/sd/MAIL_IMAP_POP/%d/%n:LAYOUT=fs }
Based on the log file you sent me, the above sql userdb is the problem. The configured home field makes no sense. A home directory is strictly a filesystem path and does not accept options such as LAYOUT. That only applies to a mail storage location; i.e., the "mail" field.
What I find puzzling though is that that userdb is not in the configuration you sent me.
Regards,
Stephan.
participants (2)
-
dovecot@avv.solutions
-
Stephan Bosch