[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*
On Sun, 2005-12-25 at 10:13 -0500, David Bain wrote:
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
What does your default_mail_env look like?
johannes
On Sun, 2005-12-25 at 10:13 -0500, David Bain wrote:
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'
never mind my question. What does the userid field in the database look like? The full email address? Then this default_mail_env should work:
default_mail_env = maildir:/var/spool/virtual_mailboxes/%d/%u/
johannes
Surely enough, changing my to default_mail_env default_mail_env = maildir:/var/spool/virtual_mailboxes/%d/%u/
Did the trick... thanks Johannes
On 12/25/05, Johannes Berg <johannes@sipsolutions.net> wrote:
On Sun, 2005-12-25 at 10:13 -0500, David Bain wrote:
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'
never mind my question. What does the userid field in the database look like? The full email address? Then this default_mail_env should work:
default_mail_env = maildir:/var/spool/virtual_mailboxes/%d/%u/
johannes
-----BEGIN PGP SIGNATURE----- Comment: Johannes Berg (SIP Solutions)
iQIVAwUAQ6667KVg1VMiehFYAQJwQQ/6AjC0Yz/iOlCU62FIB/xXilL8RWrBydqB e5EIetk3PildJMiV2oXpdF2lACp8UBaUdpIUqOZcSG2fE9sygUC5ZmeL9YEsVF3+ M3C3LlwBSnUcGQV01xpBSx7+/0kIwQSkOyunztLwMtH1am1IfR7n7my/8MCp2S9j 8paI7T+Q4RMxNENNadtmsp+S+BWAxjWFWGiuYlfaMYnCKmU8uCYRkKB3hBxKg8dF vwzeYYOroJKgQ76baaxdc0bmF0hE58r5HAow8f024FHXJbp5fduJ0inTNav8euIN pXsKX3gvoda6vQAh7Mw3O1uoYWpyANr4Aj0AFdVa8z+NZaAQPvlI82V5IPPi5wQv CXZizWEGuPnT4TI6xu90mk99h92L14OQaHaU4ZcKRwHVw4P36Quzs5eGdeQfQEsC 8IRuG6q/fLWZgnxdl3PL5GvED0NhdnHUx/6z4GYJkeXTYBZ+7fZVL2gVc2JZ6EvW 8uGtPpC5ZYpZSQ5+sj7d2dc3IflloynXRMbYRvWKPUKdqV/dPxI3DGdt6ErojEeb jj64ugzXSMW/ubaM4SIHlyXRtsp/xzKZVcuG+DIojnKvv/vOpn22GRAYKNhNZGC7 r5KEzG0mzjzApJihmaPuluMtXri71gRyBgMFevuQTd3IDck8eB5gc1JCsSmZmls7 +mAmB2PzAnA= =mQY/ -----END PGP SIGNATURE-----
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:
Surely enough, changing my to default_mail_env default_mail_env = maildir:/var/spool/virtual_mailboxes/%d/%u/
Did the trick... thanks Johannes
On 12/25/05, Johannes Berg <johannes@sipsolutions.net> wrote:
On Sun, 2005-12-25 at 10:13 -0500, David Bain wrote:
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'
never mind my question. What does the userid field in the database look like? The full email address? Then this default_mail_env should work:
default_mail_env = maildir:/var/spool/virtual_mailboxes/%d/%u/
johannes
-----BEGIN PGP SIGNATURE----- Comment: Johannes Berg (SIP Solutions)
iQIVAwUAQ6667KVg1VMiehFYAQJwQQ/6AjC0Yz/iOlCU62FIB/xXilL8RWrBydqB e5EIetk3PildJMiV2oXpdF2lACp8UBaUdpIUqOZcSG2fE9sygUC5ZmeL9YEsVF3+ M3C3LlwBSnUcGQV01xpBSx7+/0kIwQSkOyunztLwMtH1am1IfR7n7my/8MCp2S9j 8paI7T+Q4RMxNENNadtmsp+S+BWAxjWFWGiuYlfaMYnCKmU8uCYRkKB3hBxKg8dF vwzeYYOroJKgQ76baaxdc0bmF0hE58r5HAow8f024FHXJbp5fduJ0inTNav8euIN pXsKX3gvoda6vQAh7Mw3O1uoYWpyANr4Aj0AFdVa8z+NZaAQPvlI82V5IPPi5wQv CXZizWEGuPnT4TI6xu90mk99h92L14OQaHaU4ZcKRwHVw4P36Quzs5eGdeQfQEsC 8IRuG6q/fLWZgnxdl3PL5GvED0NhdnHUx/6z4GYJkeXTYBZ+7fZVL2gVc2JZ6EvW 8uGtPpC5ZYpZSQ5+sj7d2dc3IflloynXRMbYRvWKPUKdqV/dPxI3DGdt6ErojEeb jj64ugzXSMW/ubaM4SIHlyXRtsp/xzKZVcuG+DIojnKvv/vOpn22GRAYKNhNZGC7 r5KEzG0mzjzApJihmaPuluMtXri71gRyBgMFevuQTd3IDck8eB5gc1JCsSmZmls7 +mAmB2PzAnA= =mQY/ -----END PGP SIGNATURE-----
participants (2)
-
David Bain
-
Johannes Berg