Dear jmsans,

So sorry about this issue. You can fix it with below steps:

- Open /usr/share/apache2/iredadmin/libs/__init__.py, change __version_ose to __version_ose__ (Two underscores).
- Restart Apache web service.

I uploaded iRedMail-0.8.1 which was re-packed with this fix. Thanks very much for your feedback.

in the file  /usr/share/apache2/iredadmin/controllers/ldap/basic.py
on line 10

change
from libs import iredutils

into
from libs import iredutils, languages

worked for me

I installed iRedMail-0.8.1 on fresh installation on Debian Wheezy using PostgreSQL.
This is fragment in my mail.log:

Jun 12 19:14:10 area51 amavis[6557]: (06557-01-4) (!)WARN save_info_final: sql exec: err=7, 42703, DBD::Pg::st execute failed: ERROR:  column "rseqnum" of relation "msgrcpt" does not exist\nLINHA 1: INSERT INTO msgrcpt (partition_tag, mail_id, rseqnum, rid, i...\n                                                      ^ at (eval 111) line 170, <GEN37> line 1198.
Jun 12 19:14:12 area51 amavis[6557]: (06557-01-4) (!)WARN save_info_final: sql exec: err=7, 42703, DBD::Pg::st execute failed: ERROR:  column "rseqnum" of relation "msgrcpt" does not exist\nLINHA 1: INSERT INTO msgrcpt (partition_tag, mail_id, rseqnum, rid, i...\n                                                      ^ at (eval 111) line 170, <GEN37> line 1198.
Jun 12 19:14:12 area51 amavis[6594]: (06594-01-2) (!)WARN save_info_final: sql exec: err=7, 42703, DBD::Pg::st execute failed: ERROR:  column "rseqnum" of relation "msgrcpt" does not exist\nLINHA 1: INSERT INTO msgrcpt (partition_tag, mail_id, rseqnum, rid, i...\n                                                      ^ at (eval 111) line 170, <GEN37> line 473.

Tanks ZhangHuangbin! Works fine now...

Does /etc/dovecot/share-folder.conf exist? iRedMail uses share-folder.conf in old releases. Sorry about this confusion.

Oops, my mistake. Sorry.
You can replace "/etc/rc.d/iredapd restart" by "/var/run/iredapd.pid" (without quotes). The PID file is defined in /opt/iredapd/etc/iredapd.ini.

Will fix this in wiki and iRedMail later. Thanks for your feedback.

= UPDATE =
* Fixed in upgrade tutorial
* Fixed in iRedMail: https://bitbucket.org/zhb/iredmail/chan … dd5c080967

Hi,
no, /etc/dovecto/share-folder.conf doesn't exist.
This is the output of #ls -al /etc/dovecot

drwxr-xr-x.  3 root    root    4096 Jun 13 19:03 .
drwxr-xr-x. 71 root    root    4096 Jun 13 17:10 ..
drwxr-xr-x.  2 root    root    4096 Jan  9 01:12 conf.d
-rw-rw-r--.  1 root    root    4146 Jun 13 15:52 dovecot.conf
-rw-r--r--.  1 root    root    3672 Jan  9 01:13 dovecot.conf.2012.01.09.01.09.01
-r-xr-x---   1 root    root     580 Jun 13 19:03 dovecot-mysql.conf
-r-x------.  1 dovecot dovecot  494 Jan  9 01:13 used-quota.conf

The dovecot version is 2.0.14

Alessio

OK, here we go.

Please backup files which we're going to modify before you actually modify it.

1) Create 3 SQL tables in database 'iredadmin': used_quota, share_folder,
  anyone_share.

With OpenLDAP backend, these 3 tables are created in database 'iredadmin', but
they're in database 'vmail' with MySQL and PostgreSQL backend.

If you already have them, skip this step. If you don't have them all, or some of them, please find SQL structure templates in iRedMail-0.8.1, then create them.

samples/dovecot/used_quota.sql     # <- table used_quota
samples/dovecot/imap_share_folder.sql    # <- table share_folder and anyone_share

2) Make sure you have below content in dovecot.conf, nested in "plugin {}":

   # ACL and share folder                                                         
   acl = vfile                                                                    
   acl_shared_dict = proxy::acl                                                           

   # By default Dovecot doesn't allow using the IMAP "anyone" or                  
   # "authenticated" identifier, because it would be an easy way to spam          
   # other users in the system. If you wish to allow it,                          
   #acl_anyone = allow

If you're not sure how it looks like, please refer to sample config file
shipped in iRedMail-0.8.1: samples/dovecot/dovecot2.conf.

3) Make sure you have below content in dovecot.conf, nested in "dict {}":

   acl = mysql:/etc/dovecot/dovecot-share-folder.conf

Again, if you're not sure how it looks like, please refer to sample config file
shipped in iRedMail-0.8.1: samples/dovecot/dovecot2.conf.

4) Copy iRedMail-0.8.1/samples/dovecot/dovecot-share-folder.conf to /etc/dovecot/dovecot-share-folder.conf.

Open /etc/dovecot/dovecot-share-folder.conf, you will find some words start with
'PH_', they're placeholders which will be replaced by correct value during
iRedMail installation, you have to set correct MySQL username, database
name/password in it now.

You can find SQL related settings used in dovecot-share-folder.conf in
/etc/dovecot/used-quota.conf.

Replace 'PH_DOVECOT_SHARE_FOLDER_DB_TABLE' by 'share_folder' (without quotes).
Replace 'PH_DOVECOT_SHARE_FOLDER_ANYONE_DB_TABLE' by 'anyone_share'.

With above steps, you now have IMAP share folder related settings, but it's
disabled. To enable it, please append required plugin name in
/etc/dovecot/dovecot.conf:

protocol lda {
   mail_plugins = ... acl            # <-- add 'acl'
}

protocol imap {
   mail_plugins = ... acl imap_acl    # <- add 'acl' and 'imap_acl'
}

Restarting Dovecot service is required to reload config files.

Hope it helps.

Now i use the following solution to rotate my iredapd.log

1. install logrotate
       cd /usr/ports/sysutils/logrotate
       make install clean
2. create /usr/local/etc/logrotate.conf
       vi /usr/local/etc/logrotate.conf

                 /var/log/iredapd.log {
                         daily
                         rotate 30
                         create 640 root wheel
                         copytruncate
                         start 0
                         postrotate
                                   /usr/local/etc/rc.d/iredapd restart
                         endscript
                }

3. create a cronjob

30   3   *   *   *   root  /usr/local/sbin/logrotate /usr/local/etc/logrotate.conf

that's it

Hi agattei,

You should use the same SQL database name and username/password in dovecot-share-folder.conf.