1

Topic: iRedMail-0.8.1 has been released

Dear all,

iRedMail-0.8.1 bugfix release has been released.

Highlight changes since iRedMail-0.8.0
  • It now works on Debian 7 (Wheezy), with PostgreSQL backend available.

  • Drop support for Linux Mint. Sorry guys.

  • Add new column 'mailbox.language' in MySQL & PGSQL backends, used by iRedAdmin.

  • Make sure per-user BCC settings have higher priority than per-domain settings.

  • Enforce connections over https in Roundcube.

It also fixes some issues:
  • Incorrect MySQL user password and databases in MySQL backup script.

  • Add missing rotate config for iRedAPD log file on FreeBSD, OpenBSD.

  • Add missing config and SQL table required for sharing IMAP folder to anyone. Thanks BigMichi1 <bigmichi1 _at_ bigmichi1.de>.

  • Add missing auth service in Dovecot-2: auth-userdb.

  • Add new LDAP attribute and SQL column required by Dovecot-2 share folder: enabledService=lib-storage (ldap), enablelib-storage=1 (SQL). Thanks moreni <fmoreni _at_ simtrack.com.br> for the report.

  • [mysql & pgsql] Incorrect maildir path while using Postfix built-in 'virtual' as transport.

  • [ldap] Require enabledService=deliver instead of enabledService=smtp for maillist members. Thanks rain6966 <uenuan@gmail> for the report.

Package update:
  • iRedAdmin (open source edition) -> 0.1.8

  • phpMyAdmin -> 3.5.1

2

Re: iRedMail-0.8.1 has been released

Hi ZhangHuangbin,

I installed iRedMail-0.8.1 on fresh installations of both Ubuntu 10.04 and 12.04. In both cases I can not connect to https://xxxx/iredadmin, I only get a blank screen with the message "internal server error".

This is my apache2 error.log on Ubuntu 12.04:

[Sat Jun 09 03:50:25 2012] [notice] Apache/2.2.22 (Ubuntu) configured -- resuming normal operations
[Sat Jun 09 03:50:26 2012] [notice] caught SIGTERM, shutting down
[Sat Jun 09 03:50:27 2012] [notice] Apache/2.2.22 (Ubuntu) PHP/5.3.10-1ubuntu3.1 with Suhosin-Patch configured -- resuming normal operations
[Sat Jun 09 03:51:03 2012] [notice] caught SIGTERM, shutting down
[Sat Jun 09 03:51:04 2012] [warn] mod_wsgi: Compiled for Python/2.7.2+.
[Sat Jun 09 03:51:04 2012] [warn] mod_wsgi: Runtime using Python/2.7.3.
[Sat Jun 09 03:51:05 2012] [notice] Apache/2.2.22 (Ubuntu) PHP/5.3.10-1ubuntu3.1 with Suhosin-Patch mod_wsgi/3.3 Python/2.7.3 configured -- resuming normal operations
[Sat Jun 09 03:52:34 2012] [notice] caught SIGTERM, shutting down
[Sat Jun 09 03:52:35 2012] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Sat Jun 09 03:52:35 2012] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Sat Jun 09 03:52:35 2012] [warn] mod_wsgi: Compiled for Python/2.7.2+.
[Sat Jun 09 03:52:35 2012] [warn] mod_wsgi: Runtime using Python/2.7.3.
[Sat Jun 09 03:52:35 2012] [notice] Apache/2.2.22 (Ubuntu) mod_ssl/2.2.22 OpenSSL/1.0.1 mod_wsgi/3.3 Python/2.7.3 configured -- resuming normal operations
[Sat Jun 09 03:53:07 2012] [error] [client x.x.x.x] Traceback (most recent call last):
[Sat Jun 09 03:53:07 2012] [error] [client x.x.x.x]   File "/usr/lib/pymodules/python2.7/web/application.py", line 242, in process
[Sat Jun 09 03:53:07 2012] [error] [client x.x.x.x]     return self.handle()
[Sat Jun 09 03:53:07 2012] [error] [client x.x.x.x]   File "/usr/lib/pymodules/python2.7/web/application.py", line 233, in handle
[Sat Jun 09 03:53:07 2012] [error] [client x.x.x.x]     return self._delegate(fn, self.fvars, args)
[Sat Jun 09 03:53:07 2012] [error] [client x.x.x.x]   File "/usr/lib/pymodules/python2.7/web/application.py", line 411, in _delegate
[Sat Jun 09 03:53:07 2012] [error] [client x.x.x.x]     mod = __import__(mod, globals(), locals(), [""])
[Sat Jun 09 03:53:07 2012] [error] [client x.x.x.x]   File "/usr/share/apache2/iredadmin/controllers/mysql/basic.py", line 8, in <module>
[Sat Jun 09 03:53:07 2012] [error] [client x.x.x.x]     from libs import __url_latest_ose__, __version_ose__, __no__, __id__
[Sat Jun 09 03:53:07 2012] [error] [client x.x.x.x] ImportError: cannot import name __version_ose__
[Sat Jun 09 03:53:07 2012] [error] [client x.x.x.x]  

Could you figure out the problem? Maybe I have some setting wrong? Thanks for such a great software!

3

Re: iRedMail-0.8.1 has been released

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. smile

4

Re: iRedMail-0.8.1 has been released

Hello,
I have just installed this latest version and getting this error in apache log, when I try access iredadmin (Ubuntu 10.4 and openldap):

[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134] Traceback (most recent call last):
[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134]   File "/usr/lib/pymodules/python2.6/web/application.py", line 242, in process
[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134]     return self.handle()
[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134]   File "/usr/lib/pymodules/python2.6/web/application.py", line 233, in handle
[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134]     return self._delegate(fn, self.fvars, args)
[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134]   File "/usr/lib/pymodules/python2.6/web/application.py", line 412, in _delegate
[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134]     return handle_class(cls)
[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134]   File "/usr/lib/pymodules/python2.6/web/application.py", line 387, in handle_class
[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134]     return tocall(*args)
[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134]   File "/usr/share/apache2/iredadmin/controllers/ldap/basic.py", line 25, in GET
[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134]     # webmaster=session.get('webmaster'),
[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134] NameError: global name 'languages' is not defined
[Sat Jun 09 10:27:15 2012] [error] [client 93.91.48.134]

5 (edited by zeger 2012-06-10 04:04:12)

Re: iRedMail-0.8.1 has been released

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 smile

6

Re: iRedMail-0.8.1 has been released

Thanks zeger. I uploaded iRedMail-0.8.1 which was re-packed with this fix.

7

Re: iRedMail-0.8.1 has been released

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.

8

Re: iRedMail-0.8.1 has been released

Hi sergiovl,

This is a bug in iRedMail-0.8.1.
Debian Wheezy ships Amavisd-new-2.7.x, but iRedMail imports incorrect SQL template. Fixed moment ago:
https://bitbucket.org/zhb/iredmail/chan … 0475d0ed99

You can try to solve it with below steps:

1: Drop database 'amavisd'.
2: Create new database 'amavisd', then create tables with SQL template shipped in iRedMail-0.8.1: samples/amavisd/amavisd-2.7.0.pgsql.

For example:

$ psql -d template1
CREATE DATABASE amavisd WITH TEMPLATE template0 ENCODING 'UTF8';
\c amavisd;
\i /root/iRedMail-0.8.1/samples/amavisd/amavisd-2.7.0.pgsql;
GRANT SELECT,INSERT,UPDATE,DELETE ON maddr,mailaddr,msgrcpt,msgs,policy,quarantine,users,wblist TO amavisd;
GRANT SELECT,UPDATE,USAGE ON maddr_id_seq,mailaddr_id_seq,policy_id_seq,users_id_seq TO amavisd;

= UPDATE =
I uploaded iRedMail-0.8.1 which was re-packed with this fix.

9

Re: iRedMail-0.8.1 has been released

Tanks ZhangHuangbin! Works fine now...

10

Re: iRedMail-0.8.1 has been released

Hi ZhangHuangbin,
I have a question about the upgrade from 0.8.0 to 0.8.1 (previously I have updated the fresh install 0.7.4 to 0.8.0)
I've follow the steps of this guide (http://iredmail.org/wiki/index.php?titl … .8.0-0.8.1) but at the step "Add missing config for IMAP share folder in Dovecot" I can't edit this file /etc/dovecot/dovecot-share-folder.conf because it doesn't exist on my system.
It's normal? What should I do?

The backend is MySql and the OS is CentOS 6.2 x64, the admin panel is iRedAdmin-Pro    v1.4.0 (MySQL)


Many thanks,
Alessio Gattei

11

Re: iRedMail-0.8.1 has been released

agattei wrote:

I can't edit this file /etc/dovecot/dovecot-share-folder.conf because it doesn't exist on my system.

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

12

Re: iRedMail-0.8.1 has been released

Hi,

i'm running iredmail on Freebsd 9.0....i have upgraded from 0.8.0 to 0.8.1 (followed the guide).

I'm confused about this :

[FreeBSD and OpenBSD only] Rotate iRedAPD log file

File: /etc/newsyslog.conf

/var/log/iredapd.log    root:wheel      640  7     *    24    Z "/etc/rc.d/iredapd restart"

If i try this, the following error occurs

Creating and/or trimming log filesnewsyslog: illegal pid file or signal number in config file:
/var/log/iredapd.log    root:wheel      640  7     *    24    Z "/etc/rc.d/iredapd restart"

In newsyslog.conf you can only  use a pid and a sig_num.

Now my question ...is there an other solution to rotate the iredapd-logfile ?

Markus

13

Re: iRedMail-0.8.1 has been released

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

14

Re: iRedMail-0.8.1 has been released

Hi,

i fixed the settings in /etc/newsyslog.conf....the logfile rotate....iredapd is stopping....but restarting not...

Markus

15

Re: iRedMail-0.8.1 has been released

ZhangHuangbin wrote:
agattei wrote:

I can't edit this file /etc/dovecot/dovecot-share-folder.conf because it doesn't exist on my system.

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

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

16 (edited by Tallaril 2012-06-16 07:47:20)

Re: iRedMail-0.8.1 has been released

Hi there,

i don't know if this is just since this version, but i can't find any amavisd.conf nor any chance to increase sa_tag_level.

Could somebody lead me to where it hides?


All the best!

17

Re: iRedMail-0.8.1 has been released

agattei wrote:

no, /etc/dovecto/share-folder.conf doesn't exist.

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. smile

18

Re: iRedMail-0.8.1 has been released

Tallaril wrote:

i don't know if this is just since this version, but i can't find any amavisd.conf nor any chance to increase sa_tag_level.

Hi Tallaril,

May i know which Linux/BSD distribution you're running? And iRedMail version is 0.8.1?
Does one of below exist on your server?

- /etc/amavisd.conf
- /etc/amavisd/amavisd.conf
- /etc/amavis/conf.d/50-user
- /usr/local/etc/amavisd.conf

19 (edited by openbsdnoob 2012-06-26 19:59:37)

Re: iRedMail-0.8.1 has been released

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

20

Re: iRedMail-0.8.1 has been released

Thank you,
I've followed your instruction, but I have a little question about this:

ZhangHuangbin wrote:

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

In my used-quota.conf there is:
connect = host=127.0.0.1 dbname=vmail user=vmailadmin
now in dovecot-share-folder.conf I have to use the same dbname and user, or I have to change to dbname=iredadmin user=iredadmin ?

Many thanks for your patience smile

Alessio

21

Re: iRedMail-0.8.1 has been released

Hi agattei,

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

22

Re: iRedMail-0.8.1 has been released

openbsdnoob wrote:

Hi,

i fixed the settings in /etc/newsyslog.conf....the logfile rotate....iredapd is stopping....but restarting not...

Markus

I have the same issue (FreeBSD). Issuing a kill -HUP (which I assume is what newsyslog does when it rotates) to iredapd's PID does not restart it - it just dies! Any ideas?

Many thanks.

23

Re: iRedMail-0.8.1 has been released

Dear stevekez,

Please refer to this tutorial:
http://www.iredmail.org/wiki/index.php? … D_log_file

WARNING: Above upgrade tutorial is still a DRAFT, please just apply "[FreeBSD only] Fix incorrect rotate setting for iRedAPD log file", don't try others.