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!

DNS Only Upgrade Fails - MySQL Dependencies

Discussion in 'Bind/DNS/Nameserver' started by Solokron, Mar 23, 2016.

  1. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    850
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    I have ran into this issue before but do not recall the resolution to correct. DNS Only cPanel installation fails as a result of the following:
    Code:
    [20160323.170221]   All files Staged
    [20160323.170221]   Testing if the newly downloaded RPMS can be installed without conflict
    [20160323.170221]   Testing RPM transaction
    [20160323.170222]   error: Failed dependencies:
    [20160323.170222]       MySQL-client is needed by cpanel-php54-horde-5.1.4-1.cp1142.noarch
    [20160323.170222]       MySQL-server is needed by cpanel-php54-horde-5.1.4-1.cp1142.noarch
    [20160323.170222]       MySQL-client is needed by cpanel-php54-webmail-5.1.1-1.cp1142.noarch
    [20160323.170222]       MySQL-server is needed by cpanel-php54-webmail-5.1.1-1.cp1142.noarch
    [20160323.170222] W Exit Code: 196
    [20160323.170222] ***** FATAL: Test install failed: error: Failed dependencies:
    [20160323.170222]       MySQL-client is needed by cpanel-php54-horde-5.1.4-1.cp1142.noarch
    [20160323.170222]       MySQL-server is needed by cpanel-php54-horde-5.1.4-1.cp1142.noarch
    [20160323.170222]       MySQL-client is needed by cpanel-php54-webmail-5.1.1-1.cp1142.noarch
    [20160323.170222]       MySQL-server is needed by cpanel-php54-webmail-5.1.1-1.cp1142.noarch
    [20160323.170222]   The Administrator will be notified to review this output when this script completes
    [20160323.170222] ***** FATAL: Error testing if the RPMs will install: Died at /usr/local/cpanel/scripts/updatenow.static-cpanelsync line 14065.
    [20160323.170222]   see RPM Installation Failures - cPanel Knowledge Base - cPanel Documentation for more information
    [20160323.170222]   The Administrator will be notified to review this output when this script completes
    [20160323.170222] E Detected events which require user notification during updatenow. Will send iContact the log
    [20160323.170222]   Removing staged files and directories for binaries/linux-x86_64, cpanel
    
    Obviously MySQL is not used nor are those files needed for a DNS Only install. What is the resolution to this?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 Solokron, Mar 23, 2016
    Last edited by a moderator: Mar 27, 2016
  2. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    850
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    yum.conf

    exclude=bind-chroot courier* dovecot* exim* filesystem httpd* mod_ssl* mydns* mysql* nsd* php* proftpd* pure-ftpd* ruby* spamassassin* squirrelmail*
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Is this an older version of cPanel DNS-Only that you are upgrading? I believe this issue is addressed in newer versions of cPanel DNS-Only. To complete the update, you can temporarily install MySQL:

    Code:
    /scripts/update_local_rpm_versions --edit target_settings.MySQL50 installed
    /scripts/update_local_rpm_versions --edit target_settings.MySQL51 installed
    /scripts/update_local_rpm_versions --edit target_settings.MySQL55 installed
    /scripts/update_local_rpm_versions --edit target_settings.MySQL56 installed
    /scripts/check_cpanel_rpms --fix --targets=MySQL50,MySQL51,MySQL55,MySQL56 
    
    Then, update cPanel, and uninstall MySQL again:

    Code:
    /scripts/upcp --force
    /scripts/update_local_rpm_versions --edit target_settings.MySQL50 uninstalled
    /scripts/update_local_rpm_versions --edit target_settings.MySQL51 uninstalled
    /scripts/update_local_rpm_versions --edit target_settings.MySQL55 uninstalled
    /scripts/update_local_rpm_versions --edit target_settings.MySQL56 uninstalled
    /scripts/check_cpanel_rpms --fix
    
    The issue should not occur again once you are on a version a recent version of cPanel DNS-Only.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    850
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    Got a little further Now stuck at 11.48:


    Code:
    => Log opened from /usr/local/cpanel/scripts/updatenow (16387) at Fri Mar 25 18:21:41 2016
    [20160325.182141]   Detected version '11.48.5.3' from version file.
    [20160325.182141]   Running version '11.48.5.3' of updatenow.
    [20160325.182141]   Using mirror '208.43.129.162' for host 'httpupdate.cpanel.net'.
    [20160325.182141]   Target version set to '11.54.0.21'
    [20160325.182141]   Target version set to '11.50.5.3'
    [20160325.182141]   Upgrade requested to a version more than 1 LTS away. Will upgrade to next LTS first (11.50.5.3).
    [20160325.182141]   Switching to 11.50.5.3 to determine if we can reach that version without failure.
    [20160325.182141]   Retrieving and staging /cpanelsync/11.50.5.3/cpanel/scripts/updatenow.static.bz2
    [20160325.182141]   Using mirror '208.43.129.162' for host 'httpupdate.cpanel.net'.
    [20160325.182141]   Set permissions on /usr/local/cpanel/scripts/updatenow.static-cpanelsync to 0700
    [20160325.182141]   Become an updatenow.static for version: 11.50.5.3
    => Log closed Fri Mar 25 18:21:41 2016
    ----------------------------------------------------------------------------------------------------
    => Log opened from /usr/local/cpanel/scripts/updatenow.static-cpanelsync (16387) at Fri Mar 25 18:21:43 2016
    [2016-03-25 18:21:43 -0700]   Detected version '11.48.5.3' from version file.
    [2016-03-25 18:21:43 -0700]   Running version '11.50.5.3' of updatenow.
    [2016-03-25 18:21:43 -0700]   Using mirror '208.43.129.162' for host 'httpupdate.cpanel.net'.
    [2016-03-25 18:21:43 -0700]   Target version set to '11.54.0.21'
    [2016-03-25 18:21:43 -0700]   Target version set to '11.50.5.3'
    [2016-03-25 18:21:43 -0700]   Upgrade requested to a version more than 1 LTS away. Will upgrade to next LTS first (11.50.5.3).
    [2016-03-25 18:21:43 -0700]   Checking license
    [2016-03-25 18:21:43 -0700]   DNSONLY detected.
    [2016-03-25 18:21:43 -0700]   Checking that the RPM DB is OK...
    [2016-03-25 18:21:43 -0700]   glibc-2.5-123.el5_11.3
    [2016-03-25 18:21:43 -0700]   glibc-2.5-123.el5_11.3
    [2016-03-25 18:21:43 -0700]   OK: RPM DB is responding to queries
    [2016-03-25 18:21:43 -0700]   Testing if rpm_is_working RPM is installed
    [2016-03-25 18:21:43 -0700]   package rpm_is_working is not installed
    [2016-03-25 18:21:43 -0700]   Testing if it's possible to install a simple RPM
    [2016-03-25 18:21:43 -0700]   Preparing...                ##################################################
    [2016-03-25 18:21:43 -0700]   rpm_is_working              ##################################################
    [2016-03-25 18:21:43 -0700]   Switching to version '11.50.5.3' of updatenow to perform sync.
    [2016-03-25 18:21:45 -0700]   All Needed RPMS are installed.
    [2016-03-25 18:21:45 -0700]   Staging 11.50.5.3 cpanelsync files prior to updating /usr/local/cpanel
    [2016-03-25 18:21:45 -0700]   Staging cpanel changes
    [2016-03-25 18:21:45 -0700]   Retrieving and staging /cpanelsync/11.50.5.3/binaries/linux-c5-x86_64/.cpanelsync.bz2
    [2016-03-25 18:21:45 -0700]   Using mirror '208.43.129.162' for host 'httpupdate.cpanel.net'.
    [2016-03-25 18:21:45 -0700]   Retrieving and staging /cpanelsync/11.50.5.3/cpanel/.cpanelsync.bz2
    [2016-03-25 18:21:47 -0700]   Maximum sync children set to 1 based on 3377M available memory.
    [2016-03-25 18:21:47 -0700]   Staging files for binaries/linux-c5-x86_64
    
    
    
    
    ending with:
    
    
    
    ysql-test/t/union-master.opt
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/union.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/update.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/user_var-binlog.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/user_var.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/variables-big.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/variables-notembedded.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/variables.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/variables_debug.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/view.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/view_grant.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/wait_timeout.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/warnings-master.opt
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/warnings_engine_disabled.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/t/xa.test
    [20160325.174926]      [13084] [20160325.174926]   MySQL56-test,5.6.23,1.cp1148,S.5.....,/usr/share/mysql-test/valgrind.supp
    [20160325.174926]      [13084] [20160325.174926]   
    [20160325.174926]   36% complete
    [20160325.174926]   Processing: Running env auto repair
    [20160325.174926]    - Processing command `/usr/local/cpanel/scripts/vzzo-fixer`
    [20160325.174926]    - Processing command `/usr/local/cpanel/scripts/quota_auto_fix`
    [20160325.174926]      [15658] quota test: check passed
    [20160325.174926]    - Processing command `/usr/local/cpanel/scripts/clear_orphaned_virtfs_mounts --inactiveonly`
    [20160325.174927]   Processing: Cleaning up orphaned filesystem quotas
    [20160325.174927]    - Processing command `/usr/local/cpanel/scripts/cleanquotas`
    [20160325.174927]    - Processing command `/usr/local/cpanel/scripts/autorepair autorepair`
    [20160325.174928]      [15668] Requesting script ... Done
    [20160325.174928]      [15668] Auto Repair is running...Running Auto Repair routines
    [20160325.174928]      [15668] Running autorepair on remove_sendmail_rpm
    [20160325.174928]      [15668] Running autorepair on nsswitch
    [20160325.174928]      [15668] Running autorepair on redhat_pathtools
    [20160325.174928]      [15668] Running autorepair on fix_duplicate_cpanel_rpms
    [20160325.174930]      [15668] Running autorepair on fix_imagick_pecl
    [20160325.174930]      [15668] Running autorepair on abrt_argparse
    [20160325.174930]      [15668] Running autorepair on cpsources_mirror
    [20160325.174930]      [15668] Running autorepair on webmail_scriptaliasmatch
    [20160325.174930]      [15668] Couldn't open /var/cpanel/conf/apache/main for reading: No such file or directory at webmail_scriptaliasmatch line 119, <$apache_config_fh> line 1.
    [20160325.174930]      [15668] Finished running Auto Repair routines
    [20160325.174930]      [15668] ...Auto Repair is done.
    [20160325.174930]   37% complete
    [20160325.174930]    - Processing command `/usr/local/cpanel/scripts/cleanupcheck`
    [20160325.174930]   38% complete
    [20160325.174930]    - Processing command `/usr/local/cpanel/scripts/purge_old_config_caches`
    [20160325.174930]    - Processing command `/usr/local/cpanel/scripts/cleansessions`
    [20160325.174930]    - Processing command `/usr/local/cpanel/scripts/checkbashshell`
    [20160325.174930]    - Processing command `/usr/local/cpanel/scripts/purge_modsec_log`
    [20160325.174931]      [15688] The system could not retrieve the modsec database password from “/var/cpanel/modsec_db_pass”: No such file or directory
    [20160325.174931]   Processing: Rebuilding sprites
    [20160325.174931]    - Processing command `/usr/local/cpanel/bin/sprite_generator --all`
    [20160325.174947]   Setting up cronjobs
    [20160325.174947]   Setting Up update_db_cache Crontab
    [20160325.174947]   Setting Up update_maiman_cache Crontab
    [20160325.174947]   Setting Up optimizefs Crontab
    [20160325.174947]   Setting Up dcpumon Crontab
    [20160325.174947]    - Processing command `crontab /usr/local/cpanel/scripts/.crontab`
    [20160325.174947]    - Processing command `/usr/local/cpanel/scripts/dnsqueuecron`
    [20160325.174947]   39% complete
    [20160325.174949]   56% complete
    [20160325.174949]   57% complete
    [20160325.174949]   
    [20160325.174949] DNSONLY maintenance complete.
    [20160325.174949]   71% complete
    [20160325.174949]   80% complete
    => Log closed Fri Mar 25 17:49:49 2016
    ----------------------------------------------------------------------------------------------------
    => Log opened from cPanel Update (upcp) - Slave (11005) at Fri Mar 25 17:49:49 2016
    [20160325.174949]   Maintenance completed successfully
    [20160325.174950]   95% complete
    [20160325.174950]   Running Standardized hooks
    [20160325.174950]   100% complete
    [20160325.174950]   
    [20160325.174950]       cPanel update completed
    [20160325.174950]   A log of this update is available at /var/cpanel/updatelogs/update.1458952279.log
    [20160325.174950]   Removing upcp pidfile
    [20160325.174950]   
    [20160325.174950] Completed all updates
    => Log closed Fri Mar 25 17:49:50 2016
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    850
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    What a mess this update is. I am surprised the update wizard is not intelligent enough to deal with all of this as it still thinks it is a standard build install. After I got that working receive invalid mail server selection, switched to dovecot, ran again, now receiving:

    Code:
    [2016-03-26 13:45:38 -0700]      [25484] ERROR: specified theme does not exist
    Of course there are no cPanel themes. I am going to force an update again and see how far it gets this time around.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    850
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    We made it! So from 11.40 to 11.54 the following were required:


    Code:
    /scripts/update_local_rpm_versions --edit target_settings.MySQL50 installed
    /scripts/update_local_rpm_versions --edit target_settings.MySQL51 installed
    /scripts/update_local_rpm_versions --edit target_settings.MySQL55 installed
    /scripts/update_local_rpm_versions --edit target_settings.MySQL56 installed
    /scripts/check_cpanel_rpms --fix --targets=MySQL50,MySQL51,MySQL55,MySQL56
    /scripts/upcp --force
    
    vi /var/cpanel/cpanel.conf
    mailserver=dovecot
    /scripts/upcp --force
    /scripts/upcp --force
    
    /scripts/update_local_rpm_versions --edit target_settings.MySQL50 uninstalled
    /scripts/update_local_rpm_versions --edit target_settings.MySQL51 uninstalled
    /scripts/update_local_rpm_versions --edit target_settings.MySQL55 uninstalled
    /scripts/update_local_rpm_versions --edit target_settings.MySQL56 uninstalled
    /scripts/check_cpanel_rpms --fix
    /scripts/upcp --force
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    I am happy to see you were able to complete the update. Thank you for updating us with the outcome.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
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