26 Reply by ZhangHuangbin

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

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

bashir wrote:

If I modify my sources.list file in my Debian 8 server to become Debian 9 Stretch and perform a dist-upgrade will my server safely upgrade without breakages?

I didn't try this upgrade yet, you'd better test it with a virtual machine first.

----

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

27 Reply by ZhangHuangbin

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

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

dsp3 wrote:

Getting lots of these errors from cron backup_mysql.sh after 0.9.6 --> 0.9.7 update:

Please open the backup_mysql.sh, make sure you have correct database names listed in variable "DATABASES=".

28 Reply by ZhangHuangbin

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

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

fsantiago06111979 wrote:

Thanks. I assume I can simply update the affected file(s). But how do I fix existing users?

You have to update SQL column "mailbox.passwordlastchange" to a proper timestamp.

fsantiago06111979 wrote:

also, these scripts as I inspect them now are for importing users from text file. but how does this fix apply to users created using iredadmin? i'm confused and apologize for not understanding this.

iRedAdmin-Pro needs a fix too (and already fixed in development edition, will be available in next release.)
Here's patch for the latest iRedAdmin-Pro-SQL-2.7.0:

diff -r 8fd9b292e7f3 -r f86ec5cef620 libs/sqllib/user.py
--- a/libs/sqllib/user.py    Wed Jul 05 08:28:29 2017 +0800
+++ b/libs/sqllib/user.py    Wed Jul 05 09:43:56 2017 +0800
@@ -587,6 +587,7 @@
               'storagebasedirectory': storageBaseDirectory,
               'storagenode': storageNode,
               'language': preferred_language,
+              'passwordlastchange': iredutils.get_gmttime(),
               'created': iredutils.get_gmttime(),
               'active': 1,
               'local_part': mail_username}

29 Reply by ZhangHuangbin

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

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

Bronko wrote:

Making backup script executable is missing:

Not required, because we run this script with command bash directly ("bash /var/vmail/backup/backup_sogo.sh").

30 Reply by dsp3

  • dsp3
  • Member
  • Offline
  • Registered: 2015-12-23
  • Posts: 104

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

ZhangHuangbin wrote:
dsp3 wrote:

Getting lots of these errors from cron backup_mysql.sh after 0.9.6 --> 0.9.7 update:

Please open the backup_mysql.sh, make sure you have correct database names listed in variable "DATABASES=".

I have the following:

# Databases we should backup.
# Multiple databases MUST be seperated by SPACE.
export DATABASES=" iredadmin mysql vmail amavisd iredapd sogo roundcubemail iredadmin"

As you can see there are two "iredadmin" entries. I will remove the last and retest.

31 Reply by Chrissicom

  • Chrissicom
  • Member
  • Offline
  • Registered: 2015-05-26
  • Posts: 46

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

Fixed: incorrect session.save_path in php-fpm pool config file on RHEL/CentOS

On my CentOS 7 installation the path is indeed "session" and not "sessions" as suggested by the upgrade guide. So this step was not necessary in my opinion.

Also the upgrade of roundcubemail fails when executing 2016112200.sql even though I have granted the roundcube database user the ALTER,CREATE and DROP privileges. Manually executing the script via phpmyadmin worked like a charm, but the upgrade script still tries to run the sql script with an error. The installation works, but this "workaround" is ugly.

Fixed: incorrect freshclam setting UpdateLogFile

LogSyslog should be "yes" and not "true" as suggested by the upgrade tutorial, which should be the default setting.

32 Reply by tayzee (edited by tayzee 2017-07-10 19:40:20)

  • tayzee
  • Member
  • Offline
  • Registered: 2017-02-08
  • Posts: 17

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

Hi All,

Im busy updating my iRedMail setup from 0.9.6 to 0.9.7

My first issue is already coming when I try to update iRedAPD to 2.1 .. I keep on getting the below error, and I have confirmed that my password is correct by looking in the tips file and the backup script which is working. I run the update script and I get this error:
<<< ERROR >>> MySQL root user name or password is incorrect in /root/.my.cnf, please double check.

After digging around for a long while, I discovered that this could be due to Ubuntu applying the auth_socket plugin to my root mysql account. I am not sure if this is the problem or not? Maybe someone can shed some light, but I cant even log into my root mysql account from root, the only way I can login to the root mysql account is to sudo mysql -u root from a normal user.

What are the options here? Do I create another user with full privileges and update the .my.cnf file with those credentials or do I remove the auth_socket plugin and change it to the mysql_native_password plugin?

Thanks,
Tay


<<< EDIT >>>
Just in case anyone else has this problem, I went with my first option of creating a new user with all privileges and this fixed my issue.

33 Reply by ice8 (edited by ice8 2017-08-19 00:59:13)

  • ice8
  • Member
  • Offline
  • Registered: 2016-04-05
  • Posts: 6

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

[updated] I ran the installer and everything was fine except that it overwrote all of my certificate pointers. After verifying that my certificates were in place (they were, in fact unchanged) and making the necessary updates per the how-to in docs section, TLS was failing via web page and mail server. Needless to say, I went back to 0.9.6 build.

Is there a way to upgrade and maintain the certificate settings?

Thanks in advance,
Ian

34 Reply by mejo

  • mejo
  • Member
  • Offline
  • Registered: 2017-05-04
  • Posts: 19

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

ZhangHuangbin wrote:

iRedMail-0.9.7 stable release has been released.

Thanks a lot for the great work on iRedMail, Zhang!

ZhangHuangbin wrote:

Completely drop Apache support. Nginx will be the only one web server shipped by iRedMail.

That's very unfortunate to hear. Any reason why you don't want to support Apache2 anymore? It's still the best fully open source webserver, while Nginx follows an open core model.

ZhangHuangbin wrote:

Integrate a mailing list manager like Mailman or mlmmj (preferred).

Great to hear. I would very much prefer Mailman3 as it's full-featured mailing list manager, but surely it's your decision smile

35 Reply by ZhangHuangbin

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

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

mejo wrote:

I would very much prefer Mailman3 as it's full-featured mailing list manager, but surely it's your decision

I prefer mlmmj: simple, easy to manage, easy to integrate with SQL/LDAP database (although it could be improved to be much better, i will try to post my thoughts later).

A quick update of the mlmmj integration progress:

*) All Linux distributions (supported by iRedMail) and OpenBSD offer mlmmj binary packages, FreeBSD has it in ports tree (but not the latest version).
*) We already have mlmmj integrated with iRedMail, doc will be published later. We will release a beta version of iRedMail for public test.
*) We're working on the mlmmj RESTful API server, core features are 80% done (Add/Delete/Update). Still need some time to write few scripts to help sysadmin manage mailing list account from command line (communicates with RESTful API, of course).

Some more technical details about this RESTful API server:

*) It will be released under GPLv3 when it's considered as stable enough.
*) It's written in Python with web.py web framework.
*) It will be a standalone daemon service, listen on port 7779 by default.

36 Reply by ThASattler

  • ThASattler
  • Member
  • Offline
  • Registered: 2016-10-15
  • Posts: 44

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

After update to 0.9.7 in logwatch mail I get the following error message

--------------------- clam-update Begin ------------------------


No updates detected in the log for the freshclam daemon (the
ClamAV update process).  If the freshclam daemon is not running,
you may need to restart it.  Other options:

A. If you no longer wish to run freshclam, deleting the log file
    (default is freshclam.log, on Debian systems
    /var/log/clamav/freshclam.log) will suppress this error message.

B. If you use a different log file, update the appropriate
    configuration file.  For example:
       echo "LogFile = log_file" >> /etc/logwatch/conf/logfiles/clam-update.conf
    where log_file is the filename of the freshclam log file.

C. If you are logging using syslog, you need to indicate that your
    log file uses the syslog format.  For example:
       echo "*OnlyService = freshclam" >> /etc/logwatch/conf/logfiles/clam-update.conf
       echo "*RemoveHeaders" >> /etc/logwatch/conf/logfiles/clam-update.conf

---------------------- clam-update End -------------------------

And in syslog I get the freshclam logging twice

Sep  7 01:44:50 www freshclam[295]: Received signal: wake up
Sep  7 01:44:50 www freshclam[295]: Received signal: wake up
Sep  7 01:44:50 www freshclam[295]: ClamAV update process started at Thu Sep  7 01:44:50 2017
Sep  7 01:44:50 www freshclam[295]: main.cld is up to date (version: 58, sigs: 4566249, f-level: 60, builder: sigmgr)
Sep  7 01:44:50 www freshclam[295]: daily.cld is up to date (version: 23784, sigs: 1742871, f-level: 63, builder: neo)
Sep  7 01:44:50 www freshclam[295]: bytecode.cld is up to date (version: 309, sigs: 69, f-level: 63, builder: bbaker)
Sep  7 01:44:50 www freshclam[295]: --------------------------------------
Sep  7 01:44:50 www freshclam[295]: ClamAV update process started at Thu Sep  7 01:44:50 2017
Sep  7 01:44:50 www freshclam[295]: main.cld is up to date (version: 58, sigs: 4566249, f-level: 60, builder: sigmgr)
Sep  7 01:44:50 www freshclam[295]: daily.cld is up to date (version: 23784, sigs: 1742871, f-level: 63, builder: neo)
Sep  7 01:44:50 www freshclam[295]: bytecode.cld is up to date (version: 309, sigs: 69, f-level: 63, builder: bbaker)

37 Reply by ZhangHuangbin

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

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

*) Do you have any cron job used to run freshclam under /etc/cron.*?
*) Is service clamav-freshclam running?

38 Reply by ThASattler

  • ThASattler
  • Member
  • Offline
  • Registered: 2016-10-15
  • Posts: 44

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

ZhangHuangbin wrote:

*) Do you have any cron job used to run freshclam under /etc/cron.*?
*) Is service clamav-freshclam running?

There is no cron job to run freshclam.
Service clamav-freshclam is running.

I applied
Fixed: incorrect freshclam setting (http://www.iredmail.org/docs/upgrade.ir … atelogfile). Now in syslog I find the update logs of freshclam twice.

I changed settings in /usr/share/logwatch/default.conf/clam-update.conf to get the logwatch output for clam-update.

LogFile = syslog
*OnlyService = freshclam
*RemoveHeaders

39 Reply by aluisco

  • aluisco
  • Member
  • Offline
  • Registered: 2011-12-27
  • Posts: 8

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

Hello, I have a little question, I got this error when I try to install in a Server with Mysql 5.7 already installed, because the server have many services running just I want to add mail service:

...
apache2 is already the newest version (2.4.25-3+deb9u2).
apache2-utils is already the newest version (2.4.25-3+deb9u2).
apache2-utils set to manually installed.
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
mariadb-client : Depends: mariadb-client-10.1 (>= 10.1.26-0+deb9u1) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
<< ERROR >> Installation failed, please check the terminal output.
<< ERROR >> If you're not sure what the problem is, try to get help in iRedMail
<< ERROR >> forum: http://www.iredmail.org/forum/

How to say iredmail don't install de mariadb-client software and use the mysql5.7 instead???

Regards,

40 Reply by ThASattler

  • ThASattler
  • Member
  • Offline
  • Registered: 2016-10-15
  • Posts: 44

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

ThASattler wrote:

I applied
Fixed: incorrect freshclam setting (http://www.iredmail.org/docs/upgrade.ir … atelogfile). Now in syslog I find the update logs of freshclam twice.

Now I commented out LogSyslog true in "/etc/clamav/freshclam.conf":
#LogSyslog true
And now the update logs in syslog occur only once and not anymore twice.

41 Reply by Nameless (edited by Nameless 2017-10-30 07:35:29)

  • Nameless
  • Member
  • Offline
  • Registered: 2017-10-30
  • Posts: 14

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

I tried upgrading iRedAPD on a Debian Jessie machine, from 0.9.6 to 0.9.7 (ie from iRedAPD 2.0 to 2.1), and I got this error when running the upgrade script:

$ bash upgrade_iredapd.sh
* Detected Linux/BSD distribution: DEBIAN
* Found iRedAPD directory: /opt/iredapd, symbol link of /opt/iRedAPD-2.0
* Found iRedAPD config file: /opt/iredapd/settings.py
CREATE INDEX
ERROR:  syntax error at or near "\"
LINE 11: \i /tmp/wblist_rdns.sql;
         ^
* Checking dependent Python modules:
  + [required] python-sqlalchemy
  + [required] dnspython
* Create directory /opt/iRedAPD-2.1.
* Copying new version to /opt/iRedAPD-2.1
* Copy old config file: settings.py (/opt/iredapd/settings.py -> /opt/iRedAPD-2.1/settings.py)
* Copy custom plugins: /opt/iRedAPD-2.0/plugins/custom_*.py.
* Set correct owner and permission for /opt/iRedAPD-2.1: root:root, 0500.
* Set permission for iRedAPD config file: /opt/iRedAPD-2.1/settings.py -> 0400.
* Re-create symbol link: /opt/iredapd -> /opt/iRedAPD-2.1
* Create symbol link: /opt/iredapd/rc_scripts/iredapd.service -> /etc/systemd/system/multi-user.target.wants//iredapd.service.
* Remove deprecated plugins.
* Rename old plugins.
* Remove all *.pyc files.
* Restarting iRedAPD service.
* Upgrade completed.

< NOTE > If iRedAPD doesn't work as expected, please post your issue in our
< NOTE > online support forum: http://www.iredmail.org/forum/
< NOTE >
< NOTE > * Turn on debug mode: http://www.iredmail.org/docs/debug.iredapd.html
< NOTE > * iRedAPD log file is /var/log/iredapd/iredapd.log.

I'm using PosrgreSQL.

Despite the error, the upgrade seems to have worked. Any ideas? Anything I should be looking out for?

42 Reply by ZhangHuangbin

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

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

Nameless wrote:

* Found iRedAPD config file: /opt/iredapd/settings.py
CREATE INDEX
ERROR:  syntax error at or near "\"
LINE 11: \i /tmp/wblist_rdns.sql;
         ^

SQL table "wblist_rdns" was not created, please create it manually with steps below:

CREATE TABLE wblist_rdns (
    id      SERIAL PRIMARY KEY,
    -- reverse DNS name of sender IP address
    rdns    VARCHAR(255) NOT NULL DEFAULT '',
    -- W=whitelist, B=blacklist
    wb      VARCHAR(10) NOT NULL DEFAULT 'B'
);
CREATE UNIQUE INDEX idx_wblist_rdns_rdns ON wblist_rdns (rdns);
CREATE INDEX idx_wblist_rdns_wb ON wblist_rdns (wb);

Then import SQL template file "/opt/iredapd/SQL/wblist_rdns.sql".

It's a shell scripting error in tools/upgrade_iredapd.sh for PGSQL backend. Fixed moment ago:
https://bitbucket.org/zhb/iredapd/commi … 495a39bdd7

Thank you very much for the feedback. smile

43 Reply by Nameless

  • Nameless
  • Member
  • Offline
  • Registered: 2017-10-30
  • Posts: 14

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

Glad to be of help!

44 Reply by Nameless

  • Nameless
  • Member
  • Offline
  • Registered: 2017-10-30
  • Posts: 14

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

I have one more problem: I tried to upgrade Roundcube to 1.3.1. I downloaded the package and ran the installto.sh script, towards my roundcube 1.2.4 installation (from iRedMail 0.9.6). I had some problems with crypt_gpg at first, but I solved them with the help of the Internet.

The last remaining problem is: my enigma plugin isn't working. I've ran 

php composer.phar update --no-dev

and updated all plugins, including enigma. However, when I go to the "PGP Keys" page in the settings, I get the following error:

Application Error (600): Enigma plugin: Keys directory isn't writeable: /opt/www/roundcubemail/plugins/enigma/home

However, I've set the folder access to be exactly like it was in my 1.2.4 installation of roundcube (I've kept a backup): 

# ll plugins/enigma/home/ -a
total 24
drwxr-xr-x 5 root root 4096 Oct 30 00:01 .
drwxr-xr-x 7 root root 4096 Oct 30 19:22 ..
drwx------ 2 root root 4096 Apr 30  2017 myusername@mydomain.net
-rw-r--r-- 1 root root  164 Sep  4 19:03 .htaccess

Again, this is identical to how the permissions looked before the update, and PGP keys and signing used to work.

Any ideas?

45 Reply by ZhangHuangbin

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

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

Directory /opt/www/roundcubemail/plugins/enigma/home should be writable by web server.

46 Reply by Nameless

  • Nameless
  • Member
  • Offline
  • Registered: 2017-10-30
  • Posts: 14

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

So, it should belong to www-data? I tried that and it works, but I wonder how it worked before, when it belonged to root.

47 Reply by ZhangHuangbin

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

Re: iRedMail-0.9.7 has been released, and European office in Slovenia

Maybe overwrote during upgrading Roundcube?