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. It doesn't have any password to check.
Just as a comment, your password query could just as well be:
password_query = SELECT uPass as password FROM users WHERE uName = '%n' AND uDomain = '%d'
auth_username_format = %Lu -- which I believe is set by default, would lowercase the username for you on the way in from the client, so if all your usernames are meant to be purely lowercase, there is no need to return these fields from the database. Set it explicitly just to be sure. You're using a somewhat old version, I'm not sure how it was back then. Either way, this shouldn't be affecting lda.
Now, this seems to be wrong.
mail_location = mbox:/var/spool/mail/%u:INBOX=/var/spool/mail/%u
You probably want it more like: mbox:~/mail:INBOX=/var/spool/mail/%u
The first value, ~/mail, will be a /mail directory under the 'home' directory set in your static userdb, and that's where mailboxes (folders) other than INBOX will be stored. It must be a directory, not a file!
I'm a little confused about some of the other details in your log. Let's try to correct your mail_location first and see where that takes us.
Also, under namespace, you might as well comment out the 'location = ' and 'prefix = ' lines, though I'm not sure it matters.
On 10/16/2014 12:51 PM, Cliff Hayes wrote:
Here it is:
[root@avalon dovecot]# dovecot -n output # 2.0.9: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-431.29.2.el6.x86_64 x86_64 Scientific Linux release 6.5 (Carbon) ext4 auth_debug = yes auth_debug_passwords = yes auth_verbose = yes auth_verbose_passwords = plain first_valid_uid = 496 mail_access_groups = mail mail_debug = yes mail_location = mbox:/var/spool/mail/%u:INBOX=/var/spool/mail/%u mbox_write_locks = fcntl namespace { hidden = no inbox = yes list = yes location = prefix = separator = . subscriptions = yes type = private } passdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } protocols = imap ssl_ca =
[root@avalon dovecot]# cat dovecot-sql.conf.ext
driver = mysql
default_pass_scheme = PLAIN
connect = host=localhost dbname=email user=blah password=blah
password_query = SELECT uName as user, uNameDomain as username, uDomain as domain, uPass as password FROM users WHERE uName = '%n' AND uDomain = '%d'
On 10/16/2014 11:24 AM, Gedalya wrote:
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 be OK with your sendmail side.
You should really post your complete dovecot config (dovecot -n output + any ".ext" files) so that we can get a better picture.