[CPANEL-27658] cPanel update fails with PostgreSQL error

[m.eid]

I've tried o retry update the system and the error has disappeared but new one appeared

[2019-05-30 03:20:24 +0300] E [/usr/local/cpanel/bin/postgrescheck] The “/usr/local/cpanel/bin/postgrescheck --check-auth --reset-pass-on-fail” command (process 23260) reported error number 1 when it ended.
...
[2019-05-30 03:20:36 +0300] - Finished command `/usr/local/cpanel/bin/cloudlinux_update` in 0.046 seconds
[2019-05-30 03:20:36 +0300] Processing: Updating plugins data cache
[2019-05-30 03:20:36 +0300] - Processing command `/usr/local/cpanel/bin/refresh_plugin_cache`
[2019-05-30 03:20:36 +0300] - Finished command `/usr/local/cpanel/bin/refresh_plugin_cache` in 0.025 seconds
[2019-05-30 03:20:36 +0300] Processing: Ensuring SSL certificate information for CCS is up to date.
[2019-05-30 03:20:36 +0300] - Processing command `/usr/local/cpanel/scripts/ccs-check --run --ssl`
[2019-05-30 03:20:36 +0300] [/usr/local/cpanel/scripts/ccs-check] SSL information updated.
[2019-05-30 03:20:36 +0300] - Finished command `/usr/local/cpanel/scripts/ccs-check --run --ssl` in 0.057 seconds
[2019-05-30 03:20:36 +0300] Processing: Ensure cpanel-plugins yum repo exists
[2019-05-30 03:20:36 +0300] - Finished in 0.019 seconds
[2019-05-30 03:20:36 +0300] Processing: Checking and provisioning LiteSpeed if licensed
[2019-05-30 03:20:36 +0300] - Processing command `/usr/local/cpanel/scripts/litespeed-check --run`
[2019-05-30 03:20:56 +0300] [/usr/local/cpanel/scripts/litespeed-check] No license found for LiteSpeed Web Server in cPanel Store.
[2019-05-30 03:20:56 +0300] - Finished command `/usr/local/cpanel/scripts/litespeed-check --run` in 20.516 seconds
[2019-05-30 03:20:56 +0300] Processing: Checking End Of Life for current version.
[2019-05-30 03:20:56 +0300] - Finished in 0.071 seconds
[2019-05-30 03:20:56 +0300] Processing:
[2019-05-30 03:20:56 +0300] Maintenance complete. [state=post]
=> Log closed Thu May 30 03:20:56 2019
----------------------------------------------------------------------------------------------------
=> Log opened from cPanel Update (upcp) - Slave (22017) at Thu May 30 03:20:56 2019

 

[m.eid]

Hello @PCZero and @m.eid,

The EA4 Yum repo issues are now fixed and the following commands should succeed:

yum clean all
/scripts/upcp

Let us know of any additional issues.

Thank you.

It was resolved, but this error appeared after
/scripts/upcp

/usr/local/cpanel/bin/postgrescheck --check-auth --reset-pass-on-fail

 

[cPanelMichael]

Hello @m.eid,

Can you open a support ticket so we can take a closer look? Post the ticket number here once it's opened and we'll link this thread to it.

Thank you.

 

[m.eid]

Hello @m.eid,

Can you open a support ticket so we can take a closer look? Post the ticket number here once it's opened and we'll link this thread to it.

Thank you.

Actually, I've uninstalled it by this command since I don't need it, is there any issue with that?
yum remove postgresql

 

[cPanelMichael]

Hello @m.eid,

I've moved this issue into a separate thread.

Actually, I've uninstalled it by this command since I don't need it, is there any issue with that?
yum remove postgresql

Can you verify how PostgreSQL was previously installed on the affected system?

Thank you.

 

[m.eid]

I think it has been installed when I rebuilt the RPM, cause it wan't there before

 

[m.eid]

I've fount it, it was installed with "Calendar and Contacts Server [EXPERIMENTAL]" add on, I've uninstalled it since don't need it
Thank you

 

[cPanelMichael]

Hello @m.eid,

Thank you for providing the additional information.

PostgreSQL is a required dependency for the Calendar and Contacts Server plugin, and this plugin's installation process automatically installs the required PostgreSQL RPMs on servers where PostgreSQL was not previously installed. While the required PostgreSQL RPMs are automatically installed, PostgreSQL is not automatically restarted during the Calendar and Contacts Server plugin installation process. This leads to the following errors during subsequent cPanel updates:

[2019-05-30 11:39:49 -0500] - Processing command `/usr/local/cpanel/bin/postgrescheck --check-auth --reset-pass-on-fail`
[2019-05-30 11:39:49 -0500] [/usr/local/cpanel/bin/postgrescheck] 0
[2019-05-30 11:39:49 -0500] E [/usr/local/cpanel/bin/postgrescheck] The "/usr/local/cpanel/bin/postgrescheck --check-auth --reset-pass-on-fail" command (process 1559) reported error number 1 when it ended.
[2019-05-30 11:39:49 -0500] The Administrator will be notified to review this output when this script completes
[2019-05-30 11:39:49 -0500] - Finished command `/usr/local/cpanel/bin/postgrescheck --check-auth --reset-pass-on-fail` in 0.282 seconds

And:

[2019-05-30 11:39:53 -0500] E Pre Maintenance ended, however it did not exit cleanly (256). The following events were logged: "bin/postgrescheck", Please check the logs for an indication of what happened

Internal case CPANEL-27658 is now open to address this issue. I'll monitor the case and update this thread with more information as it becomes available.

In the meantime, the temporary workaround is to restart PostgreSQL, and start the cPanel update process again:

/scripts/restartsrv_postgresql
/scripts/upcp

Thank you.

 

[m.eid]

Actually I've uninstall the plugin at all, since it is tagged with experimental , so will install it after final release of the plugin.
Thank you for your help :D