1

Topic: iRedmail on Ubuntu 24.04 LTS

Greetings!

Now that Ubuntu 24.04 LTS is officially out, I wonder if a new update to iRedmail to support that will be out soon? Any ETA?

Thanks!

----

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

2

Re: iRedmail on Ubuntu 24.04 LTS

hifall wrote:

Greetings!

Now that Ubuntu 24.04 LTS is officially out, I wonder if a new update to iRedmail to support that will be out soon? Any ETA?

Thanks!

I don't know about ETA, but for Ubuntu 22.04 LTS, it was very quick.

Sogo support was missing, and it took a lot of time to be updated.
It could be the bottle neck, indeed.

3

Re: iRedmail on Ubuntu 24.04 LTS

Unfortunately, SOGo is not available on Ubuntu 24.04 yet, i just reported this in bug tracker, hope SOGo team will build packages for 24.04 shortly:
https://bugs.sogo.nu/view.php?id=5967

Should we wait for SOGo team, or release new iRedMail version first?

4

Re: iRedmail on Ubuntu 24.04 LTS

Seems i'm always the one who pushed SOGo team to build packages for new distro releases:

- Ubuntu 18.04: https://bugs.sogo.nu/view.php?id=4459
- Debian 10: https://bugs.sogo.nu/view.php?id=4775
- RHEL/CentOS 8: https://bugs.sogo.nu/view.php?id=4829
- Ubuntu 20.04: https://bugs.sogo.nu/view.php?id=5015
- Debian 11: https://bugs.sogo.nu/view.php?id=5380
- Ubuntu 22.04: https://bugs.sogo.nu/view.php?id=5511
- CentOS Stream / Rocky / Alma 9: https://bugs.sogo.nu/view.php?id=5633
- Ubuntu 24.04: https://bugs.sogo.nu/view.php?id=5967

5

Re: iRedmail on Ubuntu 24.04 LTS

ZhangHuangbin wrote:

Seems i'm always the one who pushed SOGo team to build packages for new distro releases:

- Ubuntu 18.04: https://bugs.sogo.nu/view.php?id=4459
- Debian 10: https://bugs.sogo.nu/view.php?id=4775
- RHEL/CentOS 8: https://bugs.sogo.nu/view.php?id=4829
- Ubuntu 20.04: https://bugs.sogo.nu/view.php?id=5015
- Debian 11: https://bugs.sogo.nu/view.php?id=5380
- Ubuntu 22.04: https://bugs.sogo.nu/view.php?id=5511
- CentOS Stream / Rocky / Alma 9: https://bugs.sogo.nu/view.php?id=5633
- Ubuntu 24.04: https://bugs.sogo.nu/view.php?id=5967

You encourage them to improve themselves... they should be grateful to you! smile

6

Re: iRedmail on Ubuntu 24.04 LTS

Hello !

I tried to install iRedMail 1.6.8 on a freshly installed Ubuntu 24.04 X64 server.

Some problems :

"Reading state information...
Package netcat is a virtual package provided by:
  netcat-traditional 1.10-48.1
  netcat-openbsd 1.226-1ubuntu2

E: Unable to locate package libclamunrar9
E: Package 'netcat' has no installation candidate
<< ERROR >> Installation failed, please check the terminal output.
<< ERROR >> If you're not sure what the problem is, try to get help in iRedMail"

After that, i have deleted the folder and then downloaded the git clone and after a bash iRedMail.sh I have :
"
[ INFO ] Validate downloaded source tarballs ...
misc/iRedAdmin-2.5.tar.gz: OK
misc/mlmmjadmin-3.2.1.tar.gz: OK
sha256sum: misc/iRedAPD-5.6.0.tar.gz: No such file or directory
misc/iRedAPD-5.6.0.tar.gz: FAILED open or read
misc/netdata-v1.45.4.gz.run: OK
misc/roundcubemail-1.6.6-complete.tar.gz: OK
sha256sum: WARNING: 1 listed file could not be read
    [ FAILED ]
<< ERROR >> Package verification failed. Script exit ...
"

Any ideas ?

Thank you ;-)


"

7

Re: iRedmail on Ubuntu 24.04 LTS

There is support for 24.04 now. Update the PPA in /etc/apt/sources.list/

I would hold off though for Sogo. Direct upgrade from 22.04 to 24.04 works but requires iRedMail to be running the latest and www.conf in /etc/php/8.3/fpm/pool.d requires to be replaced with the original from /etc/php/8.1/fpm/pool.d
Postfix / Dovecot works perfectly fine.

Regards.

8

Re: iRedmail on Ubuntu 24.04 LTS

SOGo is available on Ubuntu 24.04 now, but we're still waiting for Fail2ban, it's broken:
https://bugs.launchpad.net/ubuntu/+sour … ug/2055114

9

Re: iRedmail on Ubuntu 24.04 LTS

ZhangHuangbin wrote:

SOGo is available on Ubuntu 24.04 now, but we're still waiting for Fail2ban, it's broken:
https://bugs.launchpad.net/ubuntu/+sour … ug/2055114

Thought I’d mention. Roundcube 1.6 is also broken. Password Change gets a Database error when changing Password in Roundcube. 1.5 is fine though.

Regards

10

Re: iRedmail on Ubuntu 24.04 LTS

jackb wrote:

Thought I’d mention. Roundcube 1.6 is also broken. Password Change gets a Database error when changing Password in Roundcube. 1.5 is fine though.

Is this server (ubuntu 24.04) upgraded from Ubuntu 22.04 or a fresh installation?
I did a quick check on a fresh server, changing password in Roundcube works fine.

11 (edited by jackb 2024-05-29 16:42:23)

Re: iRedmail on Ubuntu 24.04 LTS

ZhangHuangbin wrote:
jackb wrote:

Thought I’d mention. Roundcube 1.6 is also broken. Password Change gets a Database error when changing Password in Roundcube. 1.5 is fine though.

Is this server (ubuntu 24.04) upgraded from Ubuntu 22.04 or a fresh installation?
I did a quick check on a fresh server, changing password in Roundcube works fine.

The Server was originally deployed back in 2020 using iRedmail 1.3.1, still running Ubuntu Server 20.04 as we speak, wasn't until i made a clone and attempted to upgrade to 22.04 from 20.04 there were problems.

MariaDB reports Got an error reading communication packets which i resolved by adding the following,

/etc/mysql/my.cnf

[mysqld]
log_warnings=1

/etc/mysql/mariadb.cnf

[client-server]
# Port or socket location where to connect
# port = 3306
socket = /run/mysqld/mysqld.sock

Dovecot on another hand has the following which is I removed,

Dovecot.conf
metric imap_command_finished {
    event_name = imap_command_finished
}

This is as far as I got, the Production Server is still running 20.04 running the latest packages and iRedMail same with Roundcube 1.6.7 but Password Plugin in Roundcube is broken.

When changing Password in Rouncube it mentions about there is a Syntax Error, changing Password via iRedMail Admin works though. Reverting back to 1.5 fixes the problem.

Regards

12

Re: iRedmail on Ubuntu 24.04 LTS

jackb wrote:

When changing Password in Rouncube it mentions about there is a Syntax Error,

What's the original error message reported on Roundcube web UI?
And any related error log in /var/log/maillog and /var/log/nginx/*.log?

13 (edited by jackb 2024-06-07 04:02:12)

Re: iRedmail on Ubuntu 24.04 LTS

ZhangHuangbin wrote:
jackb wrote:

When changing Password in Rouncube it mentions about there is a Syntax Error,

What's the original error message reported on Roundcube web UI?
And any related error log in /var/log/maillog and /var/log/nginx/*.log?

Good evening,

Sorry for a slow reply. Okay so going back through the errors, this is the error I am seeing in mail.log

B Error: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%D,passwordlastchange=NOW() WHERE username=@my.domain'' at line 1

I do not see much in Nginx Logs,

I will post back in a few days though,

Regards

14

Re: iRedmail on Ubuntu 24.04 LTS

Good evening,

After a fresh new install of Ubuntu server 24.04 (Amd64), the same problems are the same :
[ INFO ] Installing package(s): python3-setuptools python3-pip python3-wheel python3-requests uwsgi uwsgi-plugin-python3 postfix postfix-pcre libsasl2-modules mariadb-client mariadb-server postfix-mysql libdbd-mysql-perl php-cli php-fpm php-json php-gd php-curl mcrypt php-intl php-xml php-mbstring php-zip php-mysql nginx-full dovecot-imapd dovecot-pop3d dovecot-lmtpd dovecot-managesieved dovecot-sieve dovecot-mysql amavisd-new libcrypt-openssl-rsa-perl libmail-dkim-perl clamav-freshclam clamav-daemon spamassassin altermime arj nomarch cpio lzop cabextract p7zip-full rpm libmail-spf-perl unrar-free pax lrzip gpg-agent libclamunrar9 mlmmj python3-pymysql python3-sqlalchemy python3-dnspython python3-pymysql python3-jinja2 python3-netifaces python3-bcrypt python3-dnspython python3-simplejson python3-pymysql fail2ban geoip-bin geoip-database zlib1g libuuid1 libmnl0 curl lm-sensors netcat bzip2 acl patch cron tofrodos logwatch unzip bsdutils liblz4-tool rsyslog nftables
Reading package lists...
Building dependency tree...
Reading state information...
Package netcat is a virtual package provided by:
  netcat-traditional 1.10-48
  netcat-openbsd 1.226-1ubuntu2

E: Unable to locate package libclamunrar9
E: Package 'netcat' has no installation candidate
<< 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: https://forum.iredmail.org/


The same problem with : netcat and libclamunrar9

15

Re: iRedmail on Ubuntu 24.04 LTS

Bellum Gallicum wrote:

After a fresh new install of Ubuntu server 24.04 (Amd64), the same problems are the same :

iRedMail 1.6.8 doesn't support Ubuntu 24.04 yet.
You can download the latest development edition for testing:
https://github.com/iredmail/iRedMail

We're going to release new iRedMail shortly.

16

Re: iRedmail on Ubuntu 24.04 LTS

Any news, or forecast, for the release date to support Ubuntu 24.04 ?

I installed development edition from github, everything is ok, including sogo.   
Fail2ban still complaining, but I downloaded last version from their website and installed manually, it works.

I tested migrations from an old CentOS server and everithing seems ok, but I prefer waiting for official support before going to production.

17

Re: iRedmail on Ubuntu 24.04 LTS

it is safe to use development edition, it doesn't include stuff which is unstable or in testing, and mostly has most recent fixes and even security updates

18

Re: iRedmail on Ubuntu 24.04 LTS

Cthulhu wrote:

it is safe to use development edition, it doesn't include stuff which is unstable or in testing, and mostly has most recent fixes and even security updates

Don't run development edition please.
Changes made in development may be reverted, and you don't know the differences between your deployment and final release, there's no upgrade tutorial for development edition.

19

Re: iRedmail on Ubuntu 24.04 LTS

ms2504 wrote:

Fail2ban still complaining, but I downloaded last version from their website and installed manually, it works.

Maybe we should tag new iRedMail release first and re-tag when fail2ban is fixed?

20

Re: iRedmail on Ubuntu 24.04 LTS

ZhangHuangbin wrote:
jackb wrote:

When changing Password in Rouncube it mentions about there is a Syntax Error,

What's the original error message reported on Roundcube web UI?
And any related error log in /var/log/maillog and /var/log/nginx/*.log?

Hey, Back to post the problem with Password change in Roundcube, When changing Password I get a error saying Password could not be saved. Here is the log from /var/log/mail.log

roundcube: <1hqk058k> DB Error: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%D,passwordlastchange=NOW() WHERE username='user@domain.co.uk'' at line 1 (SQL Query: UPDATE mailbox SET password=%D,passwordlastchange=NOW() WHERE username='user@domain.co.uk') in /opt/www/roundcubemail-1.4.7/program/lib/Roundcube/rcube_db.php on line 577 (POST /mail/?_task=settings&_action=plugin.password-save)

Regards

21

Re: iRedmail on Ubuntu 24.04 LTS

Hi just to let you know, I have resolved the problem. I had to change a few things in /opt/www/roundcubemail/plugins/config.inc.php. As this config isn't updated when you upgrade Roundcube it requires fixes. This is on Ubuntu 20.04 but should also work in 22.04 if you upgraded Roundcube to 1.6.3 from older versions of Roundcube i.e Roundcube 1.5.7 for example.

Changes needed.
$config['password_algorithm'] = 'clear';
to
$config['password_algorithm'] = "ssha512";

$config['password_algorithm_prefix'] = '';
to
$config['password_algorithm_prefix'] = "{SSHA512}";

$config['password_query'] = "UPDATE mailbox SET password=%D,passwordlastchange=NOW() WHERE username=%u";
to
$config['password_query'] = "UPDATE mailbox SET password=%P,passwordlastchange=NOW() WHERE username=%u";

That's all what's needed.

Of course if you are doing a direct upgrade like i am from 20.04 to 22.04 these fixes will need to be applied.

Regards

22

Re: iRedmail on Ubuntu 24.04 LTS

Upgrading Roundcube will keep config files, no idea why you lost them.

23 (edited by jackb 2024-08-19 09:38:58)

Re: iRedmail on Ubuntu 24.04 LTS

ZhangHuangbin wrote:

Upgrading Roundcube will keep config files, no idea why you lost them.

Yeah. Checking the date of the config for Password was last modified back in 20 Apr 2016. Maybe the file was out of date but it is different to the latest deployment of IRedMail so maybe things changed since then.

Problem has been resolved.

Regards

24

Re: iRedmail on Ubuntu 24.04 LTS

How did you upgrade Roundcube? Do you use the `bin/installto.sh` script shipped in Roundcube?

cd /path/to/new/roundcubemail/
./bin/installto.sh /path/to/OLD/roundcubemail/

25 (edited by jackb 2024-08-14 09:50:04)

Re: iRedmail on Ubuntu 24.04 LTS

ZhangHuangbin wrote:

How did you upgrade Roundcube? Do you use the `bin/installto.sh` script shipped in Roundcube?

cd /path/to/new/roundcubemail/
./bin/installto.sh /path/to/OLD/roundcubemail/

Yep that is how I update. The SQL DB settings I listed above you can see the differences. Other people in the forum has listed problems too. I did a comparison between my config and latest config in IRedMail 1.7.0 and found there were differences. I made the changes and it fixed them.

It seems that latest version 1.6+ of roundcube uses different SQL config than 1.5.

$config['password_query'] = "UPDATE mailbox SET password=%D,passwordlastchange=NOW() WHERE username=%u";
to
$config['password_query'] = "UPDATE mailbox SET password=%P,passwordlastchange=NOW() WHERE username=%u