Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

In Progress [CPANEL-27658] cPanel update fails with PostgreSQL error

Discussion in 'General Discussion' started by m.eid, May 29, 2019.

Tags:
  1. m.eid

    m.eid Well-Known Member

    Joined:
    Jun 4, 2014
    Messages:
    52
    Likes Received:
    7
    Trophy Points:
    83
    Location:
    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
     
  2. m.eid

    m.eid Well-Known Member

    Joined:
    Jun 4, 2014
    Messages:
    52
    Likes Received:
    7
    Trophy Points:
    83
    Location:
    Jordan
    cPanel Access Level:
    Root Administrator
    Twitter:
    It was resolved, but this error appeared after
    /scripts/upcp
    Code:
    /usr/local/cpanel/bin/postgrescheck --check-auth --reset-pass-on-fail
     
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,528
    Likes Received:
    2,180
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. m.eid

    m.eid Well-Known Member

    Joined:
    Jun 4, 2014
    Messages:
    52
    Likes Received:
    7
    Trophy Points:
    83
    Location:
    Jordan
    cPanel Access Level:
    Root Administrator
    Twitter:
    Actually, I've uninstalled it by this command since I don't need it, is there any issue with that?
    yum remove postgresql
     
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,528
    Likes Received:
    2,180
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @m.eid,

    I've moved this issue into a separate thread.

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

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cPanelMichael, May 29, 2019
    Last edited: May 30, 2019
  6. m.eid

    m.eid Well-Known Member

    Joined:
    Jun 4, 2014
    Messages:
    52
    Likes Received:
    7
    Trophy Points:
    83
    Location:
    Jordan
    cPanel Access Level:
    Root Administrator
    Twitter:
    I think it has been installed when I rebuilt the RPM, cause it wan't there before
     
  7. m.eid

    m.eid Well-Known Member

    Joined:
    Jun 4, 2014
    Messages:
    52
    Likes Received:
    7
    Trophy Points:
    83
    Location:
    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
     
  8. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,528
    Likes Received:
    2,180
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. m.eid

    m.eid Well-Known Member

    Joined:
    Jun 4, 2014
    Messages:
    52
    Likes Received:
    7
    Trophy Points:
    83
    Location:
    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
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice