1 Topic by zhall_h

  • zhall_h
  • Member
  • Offline
  • Registered: 2019-01-11
  • Posts: 4

Topic: 0.9.9 upgrade issue with dovecot changes

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

iRedmail 0.9.8 being upgraded to 0.9.9
- downloadable installer starting with 0.9.4
- ubunutu 14 LTS
- mySQL
- nginx
- iRedmail-Pro

Well I did something wrong I'm sure.  On the last step it says to change the dovecot config to ;

LOWER(CONCAT(mailbox.storagebasedirectory, '/', mailbox.storagenode, '/', mailbox.maildir)) AS home, \
            CONCAT(mailbox.mailboxformat, ':~/', mailbox.mailboxfolder, '/') AS mail, \


and when I do that, it starts reading some new empty mailbox, no emails show up from dovecot.  Unable to see any of the old messages.  I change it back to the way it was and all the emails come back except any emails I sent while dovecot was changed, they go to the new mailbox I suppose.

in mySQL the field:
mailboxformat = maildir
mailboxfolder = Maildir


Any ideas what I messed up?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by zhall_h (edited by zhall_h 2019-01-11 00:42:17)

  • zhall_h
  • Member
  • Offline
  • Registered: 2019-01-11
  • Posts: 4

Re: 0.9.9 upgrade issue with dovecot changes

in case it matters, the existing dovecot-mysql.conf file before the new commands.



driver = mysql
default_pass_scheme = CRYPT
connect = host=127.0.0.1 dbname=vmail user=vmail password=<blah>
# Required by 'doveadm mailbox ...'.
iterate_query = SELECT username AS user FROM mailbox
password_query = SELECT mailbox.password, mailbox.allow_nets \
        FROM mailbox,domain \
       WHERE mailbox.username='%u' \
             AND mailbox.`enable%Ls%Lc`=1 \
             AND mailbox.active=1 \
             AND mailbox.domain=domain.domain \
             AND domain.backupmx=0 \
             AND domain.active=1
user_query = SELECT \
    '%u' AS master_user, \
     CONCAT(mailbox.storagebasedirectory, '/', mailbox.storagenode, '/', mailbox.maildir) AS home, \
     CONCAT('*:bytes=', mailbox.quota*1048576) AS quota_rule \
FROM mailbox,domain \
WHERE mailbox.username='%u' \
    AND mailbox.domain='%d' \
    AND mailbox.`enable%Ls%Lc`=1 \
    AND mailbox.domain=domain.domain \
    AND domain.backupmx=0 \
    AND domain.active=1 \
    AND mailbox.active=1

3 Reply by zhall_h (edited by zhall_h 2019-01-11 00:59:17)

  • zhall_h
  • Member
  • Offline
  • Registered: 2019-01-11
  • Posts: 4

Re: 0.9.9 upgrade issue with dovecot changes

ah, it appears to have created a new Maildir inside the Maildir

so the location of the current directory:

/var/vmail/vmail1/highspeedlink.net/ncbackup/Maildir/cur  ; with the new command

and existing setup where all da mail is:

/var/vmail/vmail1/highspeedlink.net/ncbackup/cur   



so I guess I don't need the last line?

4 Reply by zhall_h

  • zhall_h
  • Member
  • Offline
  • Registered: 2019-01-11
  • Posts: 4

Re: 0.9.9 upgrade issue with dovecot changes

I just changed the mailboxfolder field to have nothing in it, and for my setup that worked fine with the changes to the dovecot mysql config.

That should be fine right?

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,091

Re: 0.9.9 upgrade issue with dovecot changes

zhall_h wrote:

That should be fine right?

yes.