26

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.

27

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=".

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

28

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}

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

29

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").

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

30

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

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 (edited by tayzee 2017-07-10 19:40:20)

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 (edited by ice8 Today 00:59:13)

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