[CPANEL-27658] cPanel update fails with PostgreSQL error

m.eid

Well-Known Member
Jun 4, 2014
54
6
83
Jordan
cPanel Access Level
Root Administrator
Twitter
I've tried o retry update the system and the error has disappeared but new one appeared

Code:
[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

Well-Known Member
Jun 4, 2014
54
6
83
Jordan
cPanel Access Level
Root Administrator
Twitter
Hello @PCZero and @m.eid,

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

Code:
yum clean all
/scripts/upcp
Let us know of any additional issues.

Thank you.
It was resolved, but this error appeared after
/scripts/upcp
Code:
/usr/local/cpanel/bin/postgrescheck --check-auth --reset-pass-on-fail
 

m.eid

Well-Known Member
Jun 4, 2014
54
6
83
Jordan
cPanel Access Level
Root Administrator
Twitter
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

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
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.
 
Last edited:

m.eid

Well-Known Member
Jun 4, 2014
54
6
83
Jordan
cPanel Access Level
Root Administrator
Twitter
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

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
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:

Code:
[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:

Code:
[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:

Code:
/scripts/restartsrv_postgresql
/scripts/upcp
Thank you.
 

m.eid

Well-Known Member
Jun 4, 2014
54
6
83
Jordan
cPanel Access Level
Root Administrator
Twitter
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