1 Topic by evenmoreconfused (edited by evenmoreconfused 2024-10-21 05:43:29)

  • evenmoreconfused
  • Member
  • Offline
  • Registered: 2017-06-19
  • Posts: 77

Topic: Roundcube Shows Empty Mailboxes After Upgrade to 1.7.1

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.7.1
- Deployed with iRedMail Easy or the downloadable installer? Installer
- Linux/BSD distribution name and version: Rocky 9.4
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx (of course)
- Manage mail accounts with iRedAdmin-Pro? No
====

Long time user and installation. Today I upgraded our server from 1.6.8 to 1.7.0. Everything seems to have worked properly, but I only tested the basics (unfortunately not Roundcube).

Ten minutes after the above, I upgraded to 1.7.1 (which is basically just a Roundcube upgrade). It appeared to work correctly, although I later noticed a line in the log:

PHP Fatal error:  Uncaught Error: Call to undefined function shell_exec() in /opt/www/roundcubemail-1.5.3/bin/install-jsdeps.sh:36
Stack trace:
#0 {main}
thrown in /opt/www/roundcubemail-1.5.3/bin/install-jsdeps.sh on line 36

Now it seems that any user logging into Roundcube just finds an empty mailbox, and if they then log out, it says:

REQUEST CHECK FAILED
For your protection, access to this resource is secured against CSRF.
If you see this, you probably didn't log out before leaving the web application.

Human interaction is now required to continue.
Please contact your server-administrator.

This failed logout option generates a line in the log:

<42i1ap82> PHP Error: Request security check failed (GET /mail/?_task=logout)

----

However, the messages are still in the store, and IMAP clients like Outlook still are showing everything (including new messages).

I expect I have to discuss this in the Roundcube forum, but I thought I would post here first just in case someone recognized what could have caused this.

Thanks as always for all help,
Paul

----

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

2 Reply by evenmoreconfused

  • evenmoreconfused
  • Member
  • Offline
  • Registered: 2017-06-19
  • Posts: 77

Re: Roundcube Shows Empty Mailboxes After Upgrade to 1.7.1

Additional info: there are a number of errors in the log like this:

ERROR 7f900d954150 -- exec: /usr/local/bin/fail2ban_banned_db cleanup sshd
ERROR 7f900d954150 -- stderr: "ERROR 2002 (HY000): Can't connect to MySQL server on '127.0.0.1' (115)"
ERROR 7f900d954150 -- returned 1
ERROR Failed to stop jail 'sshd' action 'banned_db': Error stopping action Jail('sshd')/banned_db: 'Script error'

There are about ten groups like this before the 1.7.0 > 1.7.1 upgrade, and another fifteen after it. The request in each group varies:

cleanup sshd (shown in example above)
cleanup nginx
cleanup roundcube
cleanup dovecot
cleanup pregreet
Etc

So I restarted the entire OS and these issues went away. No changes were made by me to the database or passwords so I don't know why it couldn't connect to MySQL.

Not sure if this is related to the Roundcube problems or not.

3 Reply by ZhangHuangbin

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

Re: Roundcube Shows Empty Mailboxes After Upgrade to 1.7.1

How did you upgrade Roundcube? You should use the package "roundcubemail-1.6.9-complete.tar.gz" instead of "roundcubemail-1.6.9.tar.gz" for upgrade.

4 Reply by evenmoreconfused

  • evenmoreconfused
  • Member
  • Offline
  • Registered: 2017-06-19
  • Posts: 77

Re: Roundcube Shows Empty Mailboxes After Upgrade to 1.7.1

ZhangHuangbin wrote:

How did you upgrade Roundcube? You should use the package "roundcubemail-1.6.9-complete.tar.gz" instead of "roundcubemail-1.6.9.tar.gz" for upgrade.

Okay, that may be it as I used the latter one.

Can I just redo it with the correct package?

5 Reply by evenmoreconfused (edited by evenmoreconfused 2024-10-21 08:12:02)

  • evenmoreconfused
  • Member
  • Offline
  • Registered: 2017-06-19
  • Posts: 77

Re: Roundcube Shows Empty Mailboxes After Upgrade to 1.7.1

Yes! Thank you!

I should have noticed that all the other roundcube package names in the folder over many years of updates all had -complete in them, but this one didn't.

FWIW one can just rerun the install. It pops up a question about rerunning the same version, but if you answer y, it reinstalls and works properly.

Thanks again,
Paul