dovecot - Feb 2017 - 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 at
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 at 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.