Unable to get virtual users set up with database auth

[Steffen Kaiser]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 16 Oct 2014, Gedalya wrote:

> btw I meant: the output of the 'dovecot -n' command
>
> OK so, first of all, lda doesn't do any passdb lookup at all, only userdb. It 
> doesn't have any password to check.

Gedalya is correct.

>> mail_location = mbox:/var/spool/mail/%u:INBOX=/var/spool/mail/%u

This makes no sense, either /var/spool/mail/%u is your mail root or INBOX.

>> mbox_write_locks = fcntl
>> namespace {
>>   hidden = no
>>   inbox = yes
>>   list = yes

>>   location =
>>   prefix =
comment them out

>>   separator = .
>>   subscriptions = yes
>>   type = private
>> }
>> passdb {
>>   args = /etc/dovecot/dovecot-sql.conf.ext
>>   driver = sql
>> }

>> userdb {
>>   args = uid=497 gid=12 home=/var/email/%u
>>   driver = static
>> }

quote of your 1st message:

> Oct 16 00:10:26 avalon sendmail[2536]: s9G5APo9002535: forward /var/spool/mail/chayes at domain.tld/chayes/.forward.avalon: Group writable directory
> Oct 16 00:10:26 avalon sendmail[2536]: s9G5APo9002535: forward /var/spool/mail/chayes at domain.tld/chayes/.forward: Group writable directory
> Oct 16 00:10:26 avalon dovecot: lda(chayes): Debug: Effective uid=497, gid=497, home=/var/spool/mail/chayes at domain.tld/chayes
> Oct 16 00:10:26 avalon dovecot: lda(chayes): Debug: Home dir not found: /var/spool/mail/chayes at domain.tld/chayes
> Oct 16 00:10:26 avalon dovecot: lda(chayes): Debug: Namespace : type=private, prefix=, sep=., inbox=yes, hidden=no, list=yes, subscriptions=yes
> location=mbox:/var/spool/mail/chayes:INBOX=/var/spool/mail/chayes
> Oct 16 00:10:26 avalon dovecot: lda(chayes): Debug: fs: root=/var/spool/mail/chayes, index=, control=, inbox=/var/spool/mail/chayes

Both, sendmail and deliver use a non-existant home directory of user chayes.
The last log line then has the values from your config.

It looks like:

a) /etc/passwd contains wrong values for "home", you need a home directory, which must differ from the the mail root

b) you start Dovecot LDA _without_ -d option and not as root, that means, that the LDA does not query the userdb, but relies on the environment variables. See http://wiki2.dovecot.org/LDA

c) Did you configured sendmail to pass the domain forth to the LDA?

====

Please tell us:

0) do you run sendmail in a multi-domain setup with system users?
1) what's the home directory for chayes,
2) what's the mail root and mailbox format for chayes,
3) what's the location of the INBOX of chayes,
4) what's the system user (name, uid & gid, other /etc/passwd data) the procmail script runs under.

- -- 
Steffen Kaiser
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iQEVAwUBVEDAm3z1H7kL/d9rAQLNkgf/Ts0K14NahsEOZD0ocoPqCA/WzdNre2cC
y3FxL4i50Kdr4Y2czso0xcR6cThtVTGLbiJGgG7Hvi4tDH5bTSESJU92BByHFMpD
FCQO7o1j5ubw+0vPb70YCPw0z6OEsN4SPwkh8oLnjAW2PETNKmF5Y9a9v/JrdJeK
yQz7RUy3mOO9g334sKTI3QzuvbFaEnZXPmoCbbOauIljUzTcFOaDg5qcKI9XjNQ5
uV9ZQdG1i2LCv6S88hAmip+/EgeK/FoD/syQYzXuSMjfHnJBnAPUbSBl/mQmMdF5
eRazYldyA7Qtk6Y/piQn24Di6E8Ri+XnfT9EpMDn/oDqBx/wLR+XLA==
=6GuU
-----END PGP SIGNATURE-----