On Wed, 2009-09-16 at 13:03 +0200, Timo Sirainen wrote:

On Sep 16, 2009, at 12:42 PM, John Dubchak wrote:

Where does home come from? What userdb do you use?

Hi Timo,

Thanks for your reply. I guess I must have misread the wiki. Here is my current conf settings:

dovecot -n # 1.1.13: /etc/dovecot.conf # OS: Linux 2.6.18-128.7.1.el5 i686 CentOS release 5.3 (Final) ext3 base_dir: /var/run/dovecot/ listen: * ssl_listen: * ssl_cert_file: /etc/postfix/ssl/eliteswa-cert.pem ssl_key_file: /etc/postfix/ssl/eliteswa-key.pem verbose_ssl: yes login_dir: /var/run/dovecot//login login_executable(default): /usr/libexec/dovecot/imap-login login_executable(imap): /usr/libexec/dovecot/imap-login login_executable(pop3): /usr/libexec/dovecot/pop3-login mail_location: maildir:/var/spool/virtual_mailboxes/%h mail_executable(default): /usr/libexec/dovecot/imap mail_executable(imap): /usr/libexec/dovecot/imap mail_executable(pop3): /usr/libexec/dovecot/pop3 mail_plugin_dir(default): /usr/lib/dovecot/imap mail_plugin_dir(imap): /usr/lib/dovecot/imap mail_plugin_dir(pop3): /usr/lib/dovecot/pop3 auth default: passdb: driver: sql args: /etc/dovecot-sql.conf userdb: driver: prefetch

I am using PostgreSQL for a database backend.

I guess my real question, then, is how do I use the new mail_location when I want it to point to /var/spool/virtual_mailboxes/%h?

Thanks, John

On Wed, 2009-09-16 at 17:12 +0200, Timo Sirainen wrote:

On Sep 16, 2009, at 1:11 PM, John Dubchak wrote:

mail_location = maildir:%h

and change your SQL query to return something like:

password_query = select .., '/var/spool/virtual_mailboxes/' ||
maildir_path as userdb_home, ..

Thanks Timo! The upgrade was very smooth and, with your suggestion, I was able to cleanup the SQL and the use of the virtual mailbox home directories.

The upgrade was actually a non-event - wow. Thanks again.

John