Resolved Problem receiving mails and with Roundcube since Debian and Plesk upgrade

[LaurentR2D2]

Server operating system version

Debian 10.13

Plesk version and microupdate number

Plesk 18.0.46

Hello,

I’ve upgraded my server to Debian 10.13, then I’ve upgraded Plesk to 18.0.46. Since then I have two problems :

1) I can’t receive mails from the server. I get a « Connexion to default ports of the mail server expired » from my mail client. I’ve checked the services, and Postfix, Dovecot and SMTP are running. Firewalld doesn't seem to be installed. firewall-cmd doesn't exist. Plesk firewall is active.

2) Roundcube is not working. I had to reinstall it, but the installation process ends with this message :

Preparing to unpack .../plesk-roundcube_1.5.3-v.debian.10+p18.0.46.1+t220905.1648_all.deb ...
Unpacking plesk-roundcube (1.5.3-v.debian.10+p18.0.46.1+t220905.1648) ...
Setting up plesk-roundcube (1.5.3-v.debian.10+p18.0.46.1+t220905.1648) ...
Installing new version of config file /etc/apache2/plesk.conf.d/roundcube.htaccess.inc ...
Installing new version of config file /etc/psa-webmail/roundcube/roundcube.conf ...
Installing new version of config file /usr/share/psa-roundcube/config/mimetypes.php ...
Installing new version of config file /usr/share/psa-roundcube/plugins/managesieve/config.inc.php ...
Installing new version of config file /usr/share/psa-roundcube/plugins/markasjunk/config.inc.php ...
Trying to upgrade Roundcube Web Based mail client configs and DB from '1.4.13' to '1.5.3'... Executing database schema update.
Updating database schema (2020020101)... [FAILED]
ERROR: Error in DDL upgrade 2020020101: [1091] Can't DROP 'user_id_fk_cache'; check that column/key exists

Warning: upgrade Roundcube Web Based mail client configs and DB from '1.4.13' to '1.5.3'. Run /usr/share/psa-roundcube/bin/update.sh manually to complete upgrade.

***** installing problem report *****
Warning: upgrade Roundcube Web Based mail client configs and DB from '1.4.13' to '1.5.3'. Run /usr/share/psa-roundcube/bin/update.sh manually to complete upgrade.
***** installing problem report *****
Warning: upgrade Roundcube Web Based mail client configs and DB from '1.4.13' to '1.5.3'. Run /usr/share/psa-roundcube/bin/update.sh manually to complete upgrade.
STOP plesk-roundcube-1.5.3 installing AT Thu Sep 22 23:05:32 CEST 2022: PROBLEMS FOUND
Lancement des contrôles composants et produits...
Téléchargement du fichier report-update: 0%
Téléchargement du fichier report-update: 100% a été terminé.
Téléchargement du fichier pool/PSA_18.0.46_9656/examiners/py_launcher.sh: 0%
Téléchargement du fichier pool/PSA_18.0.46_9656/examiners/py_launcher.sh: 100% a été terminé.

When I try to run the "/usr/share/psa-roundcube/bin/update.sh" command, I get "/usr/bin/env: ‘php’: No such file or directory".

Thank you

 

[Kaspar]

What MariaDB/MySQL version are you using?

I can't help you with your first issue, for the second issue I suggest uninstalling Roundcube again and to check afterwards if the RC database has been (fully) removed. If not manually remove roundcube database and install RC again.

 

[LaurentR2D2]

What MariaDB/MySQL version are you using?

I can't help you with your first issue, for the second issue I suggest uninstalling Roundcube again and to check afterwards if the RC database has been (fully) removed. If not manually remove roundcube database and install RC again.

I have Mysql 5.5.9999+default. I've tried to uninstall/reinstall Roundcube without success, I have the same error message when I reinstall, and I don't know how to remove manually the Roundcube database

The following packages will be REMOVED:

plesk-roundcube*

0 upgraded, 0 newly installed, 1 to remove and 12 not upgraded.

After this operation, 31.5 MB disk space will be freed.

(Reading database ... (Reading database ... 5%(Reading database ... 10%(Reading database ... 15%(Reading database ... 20%(Reading database ... 25%(Reading database ... 30%(Reading database ... 35%(Reading database ... 40%(Reading database ... 45%(Reading database ... 50%(Reading database ... 55%(Reading database ... 60%(Reading database ... 65%(Reading database ... 70%(Reading database ... 75%(Reading database ... 80%(Reading database ... 85%(Reading database ... 90%(Reading database ... 95%(Reading database ... 100%(Reading database ... 110483 files and directories currently installed.)

Removing plesk-roundcube (1.5.3-v.debian.10+p18.0.46.1+t220905.1648) ...

(Reading database ... (Reading database ... 5%(Reading database ... 10%(Reading database ... 15%(Reading database ... 20%(Reading database ... 25%(Reading database ... 30%(Reading database ... 35%(Reading database ... 40%(Reading database ... 45%(Reading database ... 50%(Reading database ... 55%(Reading database ... 60%(Reading database ... 65%(Reading database ... 70%(Reading database ... 75%(Reading database ... 80%(Reading database ... 85%(Reading database ... 90%(Reading database ... 95%(Reading database ... 100%(Reading database ... 106815 files and directories currently installed.)

Purging configuration files for plesk-roundcube (1.5.3-v.debian.10+p18.0.46.1+t220905.1648) ...

dpkg: warning: while removing plesk-roundcube, directory '/var/log/plesk-roundcube' not empty so not removed

dpkg: warning: while removing plesk-roundcube, directory '/usr/share/psa-roundcube/config' not empty so not removed

dpkg: warning: while removing plesk-roundcube, directory '/etc/psa-webmail/roundcube' not empty so not removed

 

[Kaspar]

I don't know how to remove manually the Roundcube database

Go to Tools & Settings > Database Servers and click the the little icon a right side of the MySQL row to open PhpMyAdmin. Search for the roundcubemail database and make sure it's empty after you've removed RC.

But I think you might be better off contacting Plesk support to help you solve your issues.

 

[LaurentR2D2]

Thank you. I'll try that. Regarding the not being able to connect and get my mails, I've found in the maillog something indicating that the connexion is lost each time Mail try to get the mails, but I don't see why :

Sep 24 01:23:22 server postfix/smtpd[7577]: connect from 11-11-11-11.subs.proxad.net[11.11.11.11]
Sep 24 01:23:23 server postfix/smtpd[7577]: SSL_accept error from 11-11-11-11.subs.proxad.net[11.11.11.11]: lost connection
Sep 24 01:23:23 server postfix/smtpd[7577]: lost connection after STARTTLS from 11-11-11-11.subs.proxad.net[11.11.11.11]
Sep 24 01:23:23 server postfix/smtpd[7577]: disconnect from 11-11-11-11.subs.proxad.net[11.11.11.11] ehlo=1 starttls=0/1 commands=1/2
Sep 24 01:23:23 server postfix/smtpd[7533]: connect from 11-11-11-11.subs.proxad.net[11.11.11.11]
Sep 24 01:23:23 server postfix/smtpd[7584]: warning: dict_nis_init: NIS domain name not set - NIS lookups disabled
Sep 24 01:23:23 server postfix/smtpd[7584]: connect from 11-11-11-11.subs.proxad.net[11.11.11.11]
Sep 24 01:23:23 server postfix/smtpd[7533]: SSL_accept error from 11-11-11-11.subs.proxad.net[11.11.11.11]: lost connection
Sep 24 01:23:23 server postfix/smtpd[7533]: lost connection after CONNECT from 11-11-11-11.subs.proxad.net[11.11.11.11]

 

[LaurentR2D2]

I close this issue. I've made a migration of my server on a new server with a fresh Debian 11 installation, and now everything is working fine Thank you for your answers