[CPANEL-27658] cPanel update fails with PostgreSQL error

m.eid

• May 29, 2019 19:22

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

  • May 30, 2019 00:32

  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
  

  0
• 

  cPanelMichael

  • May 30, 2019 00:38

  Hello @m.eid, Can you open a

  0
• 

  m.eid

  • May 30, 2019 00:40

  Hello @m.eid, Can you open a

  0
• 

  cPanelMichael

  • May 30, 2019 00:48

  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.

  0
• 

  m.eid

  • May 30, 2019 00:57

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

  0
• 

  m.eid

  • May 30, 2019 01:06

  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

  0
• 

  cPanelMichael

  • May 30, 2019 18:53

  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.

  0
• 

  m.eid

  • May 30, 2019 19:33

  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

  0

Please sign in to leave a comment.