Re: Unable to get virtual users set up with database auth

2014-10-17 Thread 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 =

Re: Unable to get virtual users set up with database auth

2014-10-16 Thread Steffen Kaiser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 16 Oct 2014, Cliff Hayes wrote: But %u always contains just chayes instead of cha...@domain.tld even though I tried different select statements to put the entire username in the username field. mail_location =

Unable to get virtual users set up with database auth

2014-10-16 Thread Cliff Hayes
I can't seem to get imap virtual users to work with database authentication on new Scientific Linux 6.5 server with Sendmail 8.14.4 Dovecot 2.0.9 Apparently I have to also create system users because sendmail/procmail/dovecot want to check directory ownership. So I created a database, made

Re: Unable to get virtual users set up with database auth

2014-10-16 Thread Cliff Hayes
I tried both ways with same result. I tried just returning the username as well. On 10/16/2014 10:45 AM, Steffen Kaiser wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 16 Oct 2014, Cliff Hayes wrote: But %u always contains just chayes instead of cha...@domain.tld even though I

Re: Unable to get virtual users set up with database auth

2014-10-16 Thread Cliff Hayes
ok I tried this as the query: password_query = SELECT uName as user, uNameDomain as username, uDomain as domain, uPass as password FROM users WHERE uName = '%n' AND uDomain = '%d' and it is still putting mail /var/spool/mail/chayes and erroring trying to look in cha...@domain.tld/chayes

Re: Unable to get virtual users set up with database auth

2014-10-16 Thread Gedalya
Since you have to use system users, why don't you just use that? Why use SQL? On 10/16/2014 12:06 PM, Cliff Hayes wrote: I tried both ways with same result. I tried just returning the username as well. On 10/16/2014 10:45 AM, Steffen Kaiser wrote: -BEGIN PGP SIGNED MESSAGE- Hash:

Re: Unable to get virtual users set up with database auth

2014-10-16 Thread Gedalya
On 10/16/2014 12:19 PM, Cliff Hayes wrote: well i don't want to use system users. but how do I assign a UID and GID to virtual users to eliminate the permissions errors? For dovecot, it is like this: http://wiki2.dovecot.org/AuthDatabase/SQL#User_database_lookups I don't know if this would

Re: Unable to get virtual users set up with database auth

2014-10-16 Thread Gedalya
When you reply, try to make sure you reply to the list (dovecot@dovecot.org), in Thunderbird you should have a Reply List button, or just use reply to all. btw I meant: the output of the 'dovecot -n' command, sorry :D OK so, first of all, lda doesn't do any passdb lookup at all, only userdb.

Unable to get virtual users set up with database auth

2014-10-15 Thread Cliff Hayes
I can't seem to get imap virtual users to work with database authentication on new Scientific Linux 6.5 server with Sendmail 8.14.4 Dovecot 2.0.9 Apparently I have to also create system users because sendmail/procmail/dovecot want to check directory ownership. So I created a database, made