The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

DNS Only Upgrade Fails - MySQL Dependencies

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

  1. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    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?
     
    #1 Solokron, Mar 23, 2016
    Last edited by a moderator: Mar 27, 2016
  2. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    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*
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    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.
     
  4. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    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
     
  5. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    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.
     
  6. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    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
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page