Surely enough, changing my to default_mail_env<br>
default_mail_env = maildir:/var/spool/virtual_mailboxes/%d/%u/<br><br>
Did the trick... thanks Johannes<br>
<br><div><span class="gmail_quote">On 12/25/05, <b class="gmail_sendername">Johannes Berg</b> <<a href="mailto:johannes@sipsolutions.net">johannes@sipsolutions.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Sun, 2005-12-25 at 10:13 -0500, David Bain wrote:<br><br>> What would the query look like in my dovecot-pgsql.conf file to retrieve the appropriate INBOX information?<br>><br>> mine currently looks like this.<br>
> user_query = SELECT '/var/spool/virtual_mailboxes/'||home AS home, uid, gid FROM users WHERE userid = '%u'<br><br>never mind my question. What does the userid field in the database look<br>like? The full email address? Then this default_mail_env should work:
<br><br>default_mail_env = maildir:/var/spool/virtual_mailboxes/%d/%u/<br><br>johannes<br><br><br>-----BEGIN PGP SIGNATURE-----<br>Comment: Johannes Berg (SIP Solutions)<br><br>iQIVAwUAQ6667KVg1VMiehFYAQJwQQ/6AjC0Yz/iOlCU62FIB/xXilL8RWrBydqB
<br>e5EIetk3PildJMiV2oXpdF2lACp8UBaUdpIUqOZcSG2fE9sygUC5ZmeL9YEsVF3+<br>M3C3LlwBSnUcGQV01xpBSx7+/0kIwQSkOyunztLwMtH1am1IfR7n7my/8MCp2S9j<br>8paI7T+Q4RMxNENNadtmsp+S+BWAxjWFWGiuYlfaMYnCKmU8uCYRkKB3hBxKg8dF<br>vwzeYYOroJKgQ76baaxdc0bmF0hE58r5HAow8f024FHXJbp5fduJ0inTNav8euIN
<br>pXsKX3gvoda6vQAh7Mw3O1uoYWpyANr4Aj0AFdVa8z+NZaAQPvlI82V5IPPi5wQv<br>CXZizWEGuPnT4TI6xu90mk99h92L14OQaHaU4ZcKRwHVw4P36Quzs5eGdeQfQEsC<br>8IRuG6q/fLWZgnxdl3PL5GvED0NhdnHUx/6z4GYJkeXTYBZ+7fZVL2gVc2JZ6EvW<br>8uGtPpC5ZYpZSQ5+sj7d2dc3IflloynXRMbYRvWKPUKdqV/dPxI3DGdt6ErojEeb
<br>jj64ugzXSMW/ubaM4SIHlyXRtsp/xzKZVcuG+DIojnKvv/vOpn22GRAYKNhNZGC7<br>r5KEzG0mzjzApJihmaPuluMtXri71gRyBgMFevuQTd3IDck8eB5gc1JCsSmZmls7<br>+mAmB2PzAnA=<br>=mQY/<br>-----END PGP SIGNATURE-----<br><br><br></blockquote></div>
<br>