9.3.0 - watchdog/spamassassin download skipped: md5 checksum match

[srvadm]

After upgrading from 9.2.3 to 9.3.0, I found Horde webmail stopped working; when you you try to access it, you're redirected to default's domain page

Home > Server-wide mail preferences
Available Webmail clients: None

Home > Updates
9.3.0 version shows the red exclamation mark over yellow background:

- Base packages of Plesk: An update is available
- Horde webmail support: Not installed
- Watchdog (System monitoring module) * An update is available
- SpamAssassin support * An update is available

So, I checked Horde and clicked Install button receiving the mail failure report below where you can see the problem seems to be Watchdog & SpamAssassin packages download skipped because of md5 checksum match. I remember somebody reporting the same problem some time ago and it was solved but now we have it again

Thanks in advance

P.S. The report is shortened due the length post limitation, full version attached


Parallels Products Installer 3.5.0 (build at 2009-08-17 16:43 svn rev. 0) started at (timezone CET) Wed Jun 29 05:04:45 2011
Command line args: /usr/local/psa/admin/bin/autoinstaller --enable-xml-output --source-type=plesk --target=/root/psa --select-release-id=PLESK_9_3_0 --notify-email=srvadm@mydomain.com --install-component=base --install-component=watchdog --install-component=spamassassin --install-component=horde

Try to find rcfile...
Autoinstaller rcfile not found.
Opsys detected as: os_vendor=RedHat os_name=Linux version=el5.4 arch=i686 environment=~empty
Final opsys (with overriding) is: os_vendor=RedHat os_name=Linux version=el5.4 arch=i686 environment=~empty
Checking hostname is sucessfull.
Downloading the file products.inf3: 100% done.
Downloading the file plesk.inf3: 10%..20%..30%..43%..52%..62%..70%..80%..93%..100% done.
Downloading the file ppsmbe.inf3: 18%..49%..59%..70%..80%..90%..100% done.
Downloading the file sitebuilder.inf3: 10%..22%..35%..61%..74%..87%..100% done.
Downloading the file sso.inf3: 10%..24%..37%..64%..78%..100% done.
Downloading the file setemplates.inf3: 19%..44%..69%..100% done.
Downloading the file pp-sitebuilder.inf3: 21%..32%..44%..56%..68%..80%..100% done.
Downloading the file billing.inf3: 37%..46%..56%..65%..74%..84%..100% done.
repository: Get brief packages info for all sources
Checking for installed packages...
Downloading the file PSA_9.3.0/plesk-9.3.0-rhel5-i386.inf3: 10%..20%..30%..41%..50%..61%..70%..81%..91%..100% done.
Downloading the file PSA_9.3.0/plesk-patches-9.3.0-rhel5-i386.inf3: 18%..43%..100% done.
repository: Get brief packages info for all sources
Detecting installed product components.
Component plesk/base: mode up2date, installed=1274179028, available=1274179028
Component plesk/base have no older version, so keyupdate not needed
Component plesk/psa-autoinstaller: mode up2date, installed=1250502362, available=1250502362
...
Check package set before installation
Downloading the file PSA_9.3.0/dist-rpm-RedHat-el5-i386/opt/modules/watchdog/psa-watchdog-2.0.3-rhel5.build93091230.06.i586.rpm: skipped because of md5 checksum match.
Downloading the file PSA_9.3.0/dist-rpm-RedHat-el5-i386/opt/mail/psa-spamassassin-9.3.0-rhel5.build93091230.06.i586.rpm: skipped because of md5 checksum match.
Downloading the file PSA_9.3.0/dist-rpm-RedHat-el5-i386/opt/horde/psa-horde-3.1.7-rhel5.build93091230.06.noarch.rpm: 10%..20%..30%..40%..50%..60%..70%..80%..90%..100% done.
Downloading the file PSA_9.3.0/dist-rpm-RedHat-el5-i386/opt/horde/psa-imp-4.1.6-rhel5.build93091230.06.noarch.rpm: 10%..20%..30%..40%..50%..60%..70%..80%..90%..100% done.
Downloading the file PSA_9.3.0/dist-rpm-RedHat-el5-i386/opt/horde/psa-ingo-1.1.5-rhel5.build93091230.06.noarch.rpm: 10%..20%..30%..40%..50%..60%..70%..80%..90%..100% done.
Downloading the file PSA_9.3.0/dist-rpm-RedHat-el5-i386/opt/horde/psa-kronolith-2.1.8-rhel5.build93091230.06.noarch.rpm: 10%..20%..30%..40%..50%..60%..70%..80%..90%..100% done.
Downloading the file PSA_9.3.0/dist-rpm-RedHat-el5-i386/opt/horde/psa-mimp-1.0.2-rhel5.build93091230.06.noarch.rpm: 10%..20%..30%..40%..50%..60%..70%..80%..90%..100% done.
Downloading the file PSA_9.3.0/dist-rpm-RedHat-el5-i386/opt/horde/psa-mnemo-2.1.2-rhel5.build93091230.06.noarch.rpm: 10%..20%..30%..40%..50%..60%..70%..80%..90%..100% done.
Downloading the file PSA_9.3.0/dist-rpm-RedHat-el5-i386/opt/horde/psa-passwd-3.0.1-rhel5.build93091230.06.noarch.rpm: 10%..20%..30%..40%..50%..60%..70%..80%..90%..100% done.
Downloading the file PSA_9.3.0/dist-rpm-RedHat-el5-i386/opt/horde/psa-turba-2.1.7-rhel5.build93091230.06.noarch.rpm: 10%..20%..30%..40%..50%..60%..70%..80%..90%..100% done.
Starting installation of packages
Warning: unresolved requires 'hicolor-icon-theme' from gtk2-2.10.4-20.el5.i386
Installing the package psa-watchdog-2.0.3-rhel5.build93091230.06.i586
package psa-watchdog-2.0.3-rhel5.build93091230.06.i586 is already installed
ERROR: Unable to install the requested packages because either there is
not enough free disk space left, or there are package dependency problems.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please, contact product technical support.


---
Parallels Products Installer.

 

[IgorG]

Warning: unresolved requires 'hicolor-icon-theme' from gtk2-2.10.4-20.el5.i386

Looks like you have installed Gnome on your Plesk server and it is system requires that is not related to Plesk.

Installing the package psa-watchdog-2.0.3-rhel5.build93091230.06.i586
package psa-watchdog-2.0.3-rhel5.build93091230.06.i586 is already installed

Try to remove psa-watchdog package before installation with

# rpm -e psa-watchdog

 

[srvadm]

Thanks a lot for your help! Now webmail is working again. I'll summarize the steps to help others in the same/similar situation:

Remove psa-watchdog package
# rpm -e psa-watchdog
error: "psa-watchdog" specifies multiple packages

# rpm -qa | grep psa-watchdog
psa-watchdog-2.0.3-rhel5.build92091015.22
psa-watchdog-2.0.3-rhel5.build93091230.06

# rpm -e psa-watchdog-2.0.3-rhel5.build92091015.22
# rpm -e psa-watchdog

Plesk: Install SpamAssassin and Horde webmail support

Error accessing webmail: http://webmail.mydomain.com
A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.

Possible causes and solutions: http://kb.odin.com/en/940

In my case the problem was lack of coincidence between password in /etc/psa-webmail/horde/.horde.shadow and horde user in mysql database:
# mysql -uhorde -p`cat /etc/psa-webmail/horde/.horde.shadow` -D horde
ERROR 1045 (28000): Access denied for user 'horde'@'localhost' (using password: YES)

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D mysql
mysql> update user set password=password("THE_PASSWORD_FROM_WEBMAIL.SHADOW") where user="horde";
mysql> FLUSH PRIVILEGES;

That's all