DNS Only Upgrade Fails - MySQL Dependencies

[Solokron]

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:

[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?

 

[Solokron]

yum.conf

exclude=bind-chroot courier* dovecot* exim* filesystem httpd* mod_ssl* mydns* mysql* nsd* php* proftpd* pure-ftpd* ruby* spamassassin* squirrelmail*

 

[cPanelMichael]

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:

/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:

/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.

 

[Solokron]

Got a little further Now stuck at 11.48:

=> 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

 

[Solokron]

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:

[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.

 

[Solokron]

We made it! So from 11.40 to 11.54 the following were required:

/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

 

[cPanelMichael]

I am happy to see you were able to complete the update. Thank you for updating us with the outcome.

Thank you.