Re: [Dovecot] Upgrade 1.0-1.2 dbox mysql

2009-12-29 Thread Timo Sirainen
On Fri, 2009-12-18 at 08:02 -0800, Bradley Giesbrecht wrote:

 I renamed the mailboxes that were created yesterday before doing so.  
 Thank goodness I have less then a hundred imap users.
 
 I wish I understood dovecots directory vars better.
 
 What is mail_location used for?

Points to the directory containing mails. What's under it depends on the
mailbox format. For example the mailboxes directory you saw is part of
dbox.

 What is the userdb_home returned from my passdb and userdb used for?

http://wiki.dovecot.org/VirtualUsers/Home

 Would userdb_home ever not start with the complete mail_location path?

Usually it's the other way around. mail_location is under home. But it
doesn't have to be.


signature.asc
Description: This is a digitally signed message part


Re: [Dovecot] Upgrade 1.0-1.2 dbox mysql

2009-12-18 Thread Benny Pedersen

On tor 17 dec 2009 21:30:37 CET, Bradley Giesbrecht wrote

Most everything seems to work but my webmail (roundcube) clients are  
not seeing their subscribed folders.


roundcube 0.3.1  settings  server settings  Use IMAP Subscriptions (togle)

--
xpoint


pgpR5bCrVR5rM.pgp
Description: PGP digital signatur


Re: [Dovecot] Upgrade 1.0-1.2 dbox mysql

2009-12-18 Thread Bradley Giesbrecht


On Dec 18, 2009, at 7:26 AM, Benny Pedersen wrote:


On tor 17 dec 2009 21:30:37 CET, Bradley Giesbrecht wrote

Most everything seems to work but my webmail (roundcube) clients  
are not seeing their subscribed folders.


roundcube 0.3.1  settings  server settings  Use IMAP  
Subscriptions (togle)


Thank you.

The problem ended up being that since my upgrade from 1.1x to 1.2x  
yesterday the mail box locations have moved inside a directory named  
mailboxes. I don't have the word mailboxes in any configuration I  
set so dovecot 1.2 must have added this. This was not the case with my  
dovecot 1.1 before the upgrade.


I had:

/opt/local/var/mail/domain/user/dbox/INBOX

now:

/opt/local/var/mail/domain/user/dbox/mailboxes/INBOX

Since I could not figure out how to stop this behavior I just went  
with it and moved everyones old mailboxes to the new location in the  
wee hours of this morning.
I renamed the mailboxes that were created yesterday before doing so.  
Thank goodness I have less then a hundred imap users.


I wish I understood dovecots directory vars better.

What is mail_location used for?

What is the userdb_home returned from my passdb and userdb used for?

Would userdb_home ever not start with the complete mail_location path?

Reading the docs leaves me puzzled and I end up just trying things  
till something works.


I'm updating the MacPorts dovecot port to 1.2 and I'd like to be able  
to explain to the MacPorts user base the changes to dovecot 1.1x  
configurations needed for a easy upgrade.



Regards,
Bradley Giesbrecht


[Dovecot] Upgrade 1.0-1.2 dbox mysql

2009-12-17 Thread Bradley Giesbrecht

Hi,


I just upgraded to from dovecot v1.1.15 to v1.2.9 so I can use dovecot- 
sieve.


Most everything seems to work but my webmail (roundcube) clients are  
not seeing their subscribed folders.


Reading over the upgrade docs at http://wiki.dovecot.org/Upgrading/1.2  
I'm wondering if I have the two settings below configured correctly.


dovecot.conf:
mail_location = dbox:/opt/local/var/mail/%d/%n/dbox

dovecot_mysql.conf user_query homedir result:
/opt/local/var/mail/example.com/foo



bash-3.2# dovecot -n
# 1.2.9: /opt/local/etc/dovecot/dovecot.conf
# OS: Darwin 9.8.0 Power Macintosh  hfs
log_path: /opt/local/var/serveza/log/mail/dovecot.log
protocols: imap imaps pop3 pop3s
disable_plaintext_auth: no
verbose_ssl: yes
login_dir: /opt/local/var/run/dovecot/login
login_executable(default): /opt/local/libexec/dovecot/imap-login
login_executable(imap): /opt/local/libexec/dovecot/imap-login
login_executable(pop3): /opt/local/libexec/dovecot/pop3-login
login_greeting: now what?
mail_location: dbox:/opt/local/var/serveza/mail/%d/%n/dbox
mail_debug: yes
mail_executable(default): /opt/local/etc/dovecot/bin/log_imap_login.sh
mail_executable(imap): /opt/local/etc/dovecot/bin/log_imap_login.sh
mail_executable(pop3): /opt/local/etc/dovecot/bin/log_pop3_login.sh
mail_plugin_dir(default): /opt/local/lib/dovecot/imap
mail_plugin_dir(imap): /opt/local/lib/dovecot/imap
mail_plugin_dir(pop3): /opt/local/lib/dovecot/pop3
lda:
  log_path: /opt/local/var/serveza/log/mail/dovecot-deliver.log
  auth_socket_path: /opt/local/var/run/dovecot/auth-master
  postmaster_address: postmas...@pixilla.com
auth default:
  mechanisms: plain login cram-md5 ntlm apop
  verbose: yes
  debug: yes
  debug_passwords: yes
  passdb:
driver: sql
args: /opt/local/etc/dovecot/dovecot_mysql.conf
  userdb:
driver: prefetch
  userdb:
driver: sql
args: /opt/local/etc/dovecot/dovecot_mysql.conf
  socket:
type: listen
client:
  path: /opt/local/var/spool/postfix/private/auth
  mode: 432
  user: _postfix
  group: _postfix
master:
  path: /opt/local/var/run/dovecot/auth-master
  mode: 384
  user: _vmail



Thanks for any clues,
Bradley Giesbrecht


[Dovecot] Upgrade 1.0-1.2 dbox mysql

2009-12-17 Thread Bradley Giesbrecht

Hi,


I just upgraded to from dovecot v1.1.15 to v1.2.9 so I can use dovecot- 
sieve.


Most everything seems to work but my webmail (roundcube) clients are  
not seeing their subscribed folders.


Reading over the upgrade docs at http://wiki.dovecot.org/Upgrading/1.2  
I'm wondering if I have the two settings below configured correctly.


dovecot.conf:
mail_location = dbox:/opt/local/var/mail/%d/%n/dbox

dovecot_mysql.conf user_query homedir result:
/opt/local/var/mail/example.com/foo



bash-3.2# dovecot -n
# 1.2.9: /opt/local/etc/dovecot/dovecot.conf
# OS: Darwin 9.8.0 Power Macintosh  hfs
log_path: /opt/local/var/serveza/log/mail/dovecot.log
protocols: imap imaps pop3 pop3s
disable_plaintext_auth: no
verbose_ssl: yes
login_dir: /opt/local/var/run/dovecot/login
login_executable(default): /opt/local/libexec/dovecot/imap-login
login_executable(imap): /opt/local/libexec/dovecot/imap-login
login_executable(pop3): /opt/local/libexec/dovecot/pop3-login
login_greeting: now what?
mail_location: dbox:/opt/local/var/serveza/mail/%d/%n/dbox
mail_debug: yes
mail_executable(default): /opt/local/etc/dovecot/bin/log_imap_login.sh
mail_executable(imap): /opt/local/etc/dovecot/bin/log_imap_login.sh
mail_executable(pop3): /opt/local/etc/dovecot/bin/log_pop3_login.sh
mail_plugin_dir(default): /opt/local/lib/dovecot/imap
mail_plugin_dir(imap): /opt/local/lib/dovecot/imap
mail_plugin_dir(pop3): /opt/local/lib/dovecot/pop3
lda:
 log_path: /opt/local/var/serveza/log/mail/dovecot-deliver.log
 auth_socket_path: /opt/local/var/run/dovecot/auth-master
 postmaster_address: postmas...@pixilla.com
auth default:
 mechanisms: plain login cram-md5 ntlm apop
 verbose: yes
 debug: yes
 debug_passwords: yes
 passdb:
   driver: sql
   args: /opt/local/etc/dovecot/dovecot_mysql.conf
 userdb:
   driver: prefetch
 userdb:
   driver: sql
   args: /opt/local/etc/dovecot/dovecot_mysql.conf
 socket:
   type: listen
   client:
 path: /opt/local/var/spool/postfix/private/auth
 mode: 432
 user: _postfix
 group: _postfix
   master:
 path: /opt/local/var/run/dovecot/auth-master
 mode: 384
 user: _vmail



Thanks for any clues,
Bradley Giesbrecht


[Dovecot] Upgrade 1.0-1.2 dbox mysql

2009-12-17 Thread Bradley Giesbrecht

Hi,


I just upgraded to from dovecot v1.1.15 to v1.2.9 so I can use dovecot- 
sieve.


Most everything seems to work but my webmail (roundcube) clients are  
not seeing their subscribed folders.


Reading over the upgrade docs at http://wiki.dovecot.org/Upgrading/1.2  
I'm wondering if I have the two settings below configured correctly.


dovecot.conf:
mail_location = dbox:/opt/local/var/mail/%d/%n/dbox

dovecot_mysql.conf user_query homedir result:
/opt/local/var/mail/example.com/foo



bash-3.2# dovecot -n
# 1.2.9: /opt/local/etc/dovecot/dovecot.conf
# OS: Darwin 9.8.0 Power Macintosh  hfs
log_path: /opt/local/var/serveza/log/mail/dovecot.log
protocols: imap imaps pop3 pop3s
disable_plaintext_auth: no
verbose_ssl: yes
login_dir: /opt/local/var/run/dovecot/login
login_executable(default): /opt/local/libexec/dovecot/imap-login
login_executable(imap): /opt/local/libexec/dovecot/imap-login
login_executable(pop3): /opt/local/libexec/dovecot/pop3-login
login_greeting: now what?
mail_location: dbox:/opt/local/var/serveza/mail/%d/%n/dbox
mail_debug: yes
mail_executable(default): /opt/local/etc/dovecot/bin/log_imap_login.sh
mail_executable(imap): /opt/local/etc/dovecot/bin/log_imap_login.sh
mail_executable(pop3): /opt/local/etc/dovecot/bin/log_pop3_login.sh
mail_plugin_dir(default): /opt/local/lib/dovecot/imap
mail_plugin_dir(imap): /opt/local/lib/dovecot/imap
mail_plugin_dir(pop3): /opt/local/lib/dovecot/pop3
lda:
log_path: /opt/local/var/serveza/log/mail/dovecot-deliver.log
auth_socket_path: /opt/local/var/run/dovecot/auth-master
postmaster_address: postmas...@pixilla.com
auth default:
mechanisms: plain login cram-md5 ntlm apop
verbose: yes
debug: yes
debug_passwords: yes
passdb:
  driver: sql
  args: /opt/local/etc/dovecot/dovecot_mysql.conf
userdb:
  driver: prefetch
userdb:
  driver: sql
  args: /opt/local/etc/dovecot/dovecot_mysql.conf
socket:
  type: listen
  client:
path: /opt/local/var/spool/postfix/private/auth
mode: 432
user: _postfix
group: _postfix
  master:
path: /opt/local/var/run/dovecot/auth-master
mode: 384
user: _vmail



Thanks for any clues,
Bradley Giesbrecht


[Dovecot] Upgrade 1.0-1.2 dbox mysql

2009-12-17 Thread Bradley Giesbrecht
Seems to work but it's weird that I lost my subscribed folders. Also  
the perl script imapsync is only seeing an inbox and no other folders.


I seem to be creating a lot of name mailboxes where my INBOX and other  
folders are located.


/opt/local/var/mail/domain.com/username/dbox/mailboxes
This dir is getting populated with new INBOX and default folders.


(domain.com and username are substitutes for the real users domain and  
username)


dovecot.log:

Dec 17 12:29:17 IMAP(usern...@domain.com): Info: Effective uid=5000,  
gid=5000, home=/opt/local/var/mail/domain.com/username
Dec 17 12:29:17 IMAP(usern...@domain.com): Info: dbox: data=/opt/local/ 
var/mail/domain.com/username/dbox
Dec 17 12:29:17 IMAP(usern...@domain.com): Info: fs: root=/opt/local/ 
var/mail/username.com/username/dbox, index=, control=, inbox=


dovecot-deliver.log:
Dec 17 12:35:08 deliver(usern...@domain.com): Info: auth input: home=/ 
opt/local/var/mail/domain.com/username

Dec 17 12:35:08 deliver(usern...@domain.com): Info: auth input: uid=5000
Dec 17 12:35:08 deliver(usern...@domain.com): Info: auth input: gid=5000
Dec 17 12:35:08 deliver(usern...@domain.com): Info: dbox: data=/opt/ 
local/var/mail/domain.com/username/dbox
Dec 17 12:35:08 deliver(usern...@domain.com): Info: fs: root=/opt/ 
local/var/mail/domain.com/username/dbox, index=, control=, inbox=
Dec 17 12:35:08 deliver(usern...@domain.com): Info: msgid=e5136d91-256c-4fd8-87ae-065c95dea...@gmail.com 
: saved mail to INBOX



Could someone confirm that this looks right?

Thank you,
Bradley Giesbrecht


Re: [Dovecot] Upgrade 1.0-1.2 dbox mysql

2009-12-17 Thread Charles Marcus
On 12/17/2009 4:00 PM, Bradley Giesbrecht wrote:
 Seems to work but it's weird that I lost my subscribed folders. Also the
 perl script imapsync is only seeing an inbox and no other folders.

Bradley,

Please stop sending the same message over and over. You have a gmail
account. GMail does not show you list messages that you SEND, only
replies. This is a longstanding issue - go complain to gmail

-- 

Best regards,

Charles


Re: [Dovecot] Upgrade 1.0-1.2 dbox mysql

2009-12-17 Thread Bradley Giesbrecht


On Dec 17, 2009, at 1:18 PM, Charles Marcus wrote:


On 12/17/2009 4:00 PM, Bradley Giesbrecht wrote:
Seems to work but it's weird that I lost my subscribed folders.  
Also the

perl script imapsync is only seeing an inbox and no other folders.


Bradley,

Please stop sending the same message over and over. You have a gmail
account. GMail does not show you list messages that you SEND, only
replies. This is a longstanding issue - go complain to gmail


Please pardon my ignorance.

//Bradley