[Dovecot] dovecot and virtual mailbox - suggestions please
I've setup postfix to delivered my mail to a maildir located at
/var/spool/virtual_mailboxes/mydomain.com/myuser
My postgresql database called 'mails' has a user table setup as follows:
CREATE TABLE users ( userid VARCHAR(128) NOT NULL, password VARCHAR(128), realname VARCHAR(128), uid INTEGER NOT NULL, gid INTEGER NOT NULL, home VARCHAR(128), mail VARCHAR(255), PRIMARY KEY (userid) );
What would the query look like in my dovecot-pgsql.conf file to retrieve the appropriate INBOX information?
mine currently looks like this. user_query = SELECT '/var/spool/virtual_mailboxes/'||home AS home, uid, gid FROM users WHERE userid = '%u'
The user authenticates fine via pop, yet I keeping getting the following error. -*ERR No INBOX for user*
Update. Because postfix delivers messages by username I had to switch it to: default_mail_env = maildir:/var/spool/virtual_mailboxes/%d/%n/
Otherwise ti would create mailboxes in the from /var/spool/virtual_mailboxes/domain/blah@domain/ (not very useful)
Thanks again Johannes
On 12/26/05, David Bain <david.bain@alteroo.com> wrote:
participants (2)
-
David Bain
-
Johannes Berg