Resolved Help! mail not working after failed update to Plesk Obsidian

[gregconway]

Hi all,

I was upgrading the last of our Linux servers to Plesk Obsidian.
All the other upgrades went smoothly but the upgrade here crashed out.
The box is running CentOS 6.

The mail service no longer works.

if I check the mail server logs I see -

dovecot_authdb_plesk[4584]: No such user '[email protected]' in mail authorization database

When I go to view mailbox configuration within the Plesk GUI for any domain I see the following error -

Type Smb_Exception
Message DB query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'apsServiceAccountInstanceId' in 'field list', query was: select `id`, `mail_name`, `postbox`, `account_id`, `perm_id`, `redirect`, `redir_addr`, `mail_group`, `autoresponder`, `spamfilter`, `virusfilter`, `mbox_quota`, `description`, `dom_id`, `userId`, `apsServiceAccountInstanceId`, `apsAntivirusServiceInstanceId`, `apsAntispamServiceInstanceId` from `mail` where `id`=2
File Name.php
Line 39

Any suggestions what I can do here?

I'll have a server full of screaming users who can't receive emails in about eight hours time!

Thanks for any help!

Greg.

 

[gregconway]

A bit more info on what exactly is failing!

/usr/local/psa/admin/sbin/mchk
==> Checking for: mailsrv_conf_init... ok
==> Checking for: mail_handlers_init... ok
==> Checking for: mailsrv_entities_dump... ok
==> Checking for: mail_admin_aliases... ok
==> Checking for: mail_auth_dump... fail
==> Checking for: mailman_lists_dump... ok
==> Checking for: mail_kav8_restore... ok
==> Checking for: mail_responder_restore... fail
==> Checking for: mail_imap_restore... fail
==> Checking for: mail_spam_restore... ok
==> Checking for: mail_grey_restore... ok
==> Checking for: mail_mailbox_restore... ok
==> Checking for: mail_spf_restore... ok
==> Checking for: mail_dk_restore... ok
==> Checking for: mail_dmarc_restore... ok
==> Checking for: mail_drweb_restore... not found, skipped
==> Checking for: mail_outgoing_restore... fail
==> Checking for: mail_transport_restore... ok
Errors occured in mail restore procedure
Some utilities have exited with errors:
/usr/lib64/plesk-9.0/remote_mail_restore/mail_auth_dump
/usr/lib64/plesk-9.0/mail_responder_restore
/usr/lib64/plesk-9.0/remote_mail_restore/mail_imap_restore
/usr/lib64/plesk-9.0/remote_mail_restore/mail_outgoing_restore

 

[gregconway]

This was where it all started. I get this error when I try and use the autoinstaller -

Running rpm_check_debug
Fatal error during packages installation: [u'ERROR with rpm_check_debug vs depsolve:', 'plesk-service-node-utilities >= 18.0 is needed by plesk-core-18.0-2.centos.6+p18.0.20.0+t191018.1854.x86_64', 'psa-libpam-plesk is needed by plesk-core-18.0-2.centos.6+p18.0.20.0+t191018.1854.x86_64', 'plesk-service-node-utilities >= 18.0 is needed by psa-mail-driver-common-18.0-2.centos.6+p18.0.20.0+t191018.1712.x86_64', 'plesk-service-node-utilities >= 18.0 is needed by plesk-web-hosting-18.0-2.centos.6+p18.0.20.0+t191018.1712.x86_64', 'plesk-service-node-utilities >= 18.0 is needed by psa-spamassassin-18.0-2.centos.6+p18.0.20.0+t191018.1712.x86_64', u'Please report this error at My View - CentOS Bug Tracker']
YumRPMCheckError: [u'ERROR with rpm_check_debug vs depsolve:', 'plesk-service-node-utilities >= 18.0 is needed by plesk-core-18.0-2.centos.6+p18.0.20.0+t191018.1854.x86_64', 'psa-libpam-plesk is needed by plesk-core-18.0-2.centos.6+p18.0.20.0+t191018.1854.x86_64', 'plesk-service-node-utilities >= 18.0 is needed by psa-mail-driver-common-18.0-2.centos.6+p18.0.20.0+t191018.1712.x86_64', 'plesk-service-node-utilities >= 18.0 is needed by plesk-web-hosting-18.0-2.centos.6+p18.0.20.0+t191018.1712.x86_64', 'plesk-service-node-utilities >= 18.0 is needed by psa-spamassassin-18.0-2.centos.6+p18.0.20.0+t191018.1712.x86_64', u'Please report this error at My View - CentOS Bug Tracker']

ERROR: Failed to run the Yum utility.
The Yum utility failed to install the required packages.
Attention! Your software might be inoperable.
Visit Plesk Help Center to search for a solution.

 

[gregconway]

I completed outstanding yum transactions with yum-complete-transactions.

I cleaned out the dupes with package-cleanup --cleandupes.

I was then able to re-run the plesk autoinstaller. Finally it made it past the rpm stage and presumably finished the aborted upgrade.

I was then able to run mchk which fixed all the mail components.

Time for a quick heart attack before bed!