Re: failed upgrade again. 5.5.11 to 5.6.7
Posted: Thu Oct 24, 2019 5:35 am
Hi Benjamin,
My colleage tried the above and this was the output, it said that there was nothing to upgrade.
root@smpnagios-kn-t100 # mysqlcheck -r -f -uroot -pnagiosxi --all-databases
mysqlcheck: Error: Couldn't get table list for database #mysql50#lost+found: Can't read dir of './lost+found/' (errno: 13)
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
nagios.nagios_acknowledgements OK
nagios.nagios_commands OK
nagios.nagios_commenthistory OK
nagios.nagios_comments OK
nagios.nagios_configfiles OK
nagios.nagios_configfilevariables OK
nagios.nagios_conninfo OK
nagios.nagios_contact_addresses OK
nagios.nagios_contact_notificationcommands OK
nagios.nagios_contactgroup_members OK
nagios.nagios_contactgroups OK
nagios.nagios_contactnotificationmethods OK
nagios.nagios_contactnotifications OK
nagios.nagios_contacts OK
nagios.nagios_contactstatus OK
nagios.nagios_customvariables OK
nagios.nagios_customvariablestatus OK
nagios.nagios_dbversion OK
nagios.nagios_downtimehistory OK
nagios.nagios_eventhandlers OK
nagios.nagios_externalcommands OK
nagios.nagios_flappinghistory OK
nagios.nagios_host_contactgroups OK
nagios.nagios_host_contacts OK
nagios.nagios_host_parenthosts OK
nagios.nagios_hostchecks OK
nagios.nagios_hostdependencies OK
nagios.nagios_hostescalation_contactgroups OK
nagios.nagios_hostescalation_contacts OK
nagios.nagios_hostescalations OK
nagios.nagios_hostgroup_members OK
nagios.nagios_hostgroups OK
nagios.nagios_hosts OK
nagios.nagios_hoststatus OK
nagios.nagios_instances OK
^C
root@smpnagios-kn-t100 # echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -uroot -pnagiosxi --table
+--------------------------------------------+------------+
| Table | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements | 0.00 |
| nagios_commands | 0.02 |
| nagios_commenthistory | 0.04 |
| nagios_comments | 0.00 |
| nagios_configfiles | 0.00 |
| nagios_configfilevariables | 0.01 |
| nagios_conninfo | 0.02 |
| nagios_contact_addresses | 0.00 |
| nagios_contact_notificationcommands | 0.01 |
| nagios_contactgroup_members | 0.00 |
| nagios_contactgroups | 0.00 |
| nagios_contactnotificationmethods | 81.41 |
| nagios_contactnotifications | 86.23 |
| nagios_contacts | 0.00 |
| nagios_contactstatus | 0.00 |
| nagios_customvariables | 0.00 |
| nagios_customvariablestatus | 0.00 |
| nagios_dbversion | 0.00 |
| nagios_downtimehistory | 0.00 |
| nagios_eventhandlers | 0.00 |
| nagios_externalcommands | 0.00 |
| nagios_flappinghistory | 0.31 |
| nagios_host_contactgroups | 0.00 |
| nagios_host_contacts | 0.00 |
| nagios_host_parenthosts | 0.00 |
| nagios_hostchecks | 0.00 |
| nagios_hostdependencies | 0.00 |
| nagios_hostescalation_contactgroups | 0.00 |
| nagios_hostescalation_contacts | 0.00 |
| nagios_hostescalations | 0.00 |
| nagios_hostgroup_members | 0.00 |
| nagios_hostgroups | 0.00 |
| nagios_hosts | 0.01 |
| nagios_hoststatus | 0.03 |
| nagios_instances | 0.00 |
| nagios_logentries | 723.08 |
| nagios_notifications | 129.32 |
| nagios_objects | 0.16 |
| nagios_processevents | 0.01 |
| nagios_programstatus | 0.00 |
| nagios_runtimevariables | 0.00 |
| nagios_scheduleddowntime | 0.00 |
| nagios_service_contactgroups | 0.01 |
| nagios_service_contacts | 0.00 |
| nagios_service_parentservices | 0.00 |
| nagios_servicechecks | 0.00 |
| nagios_servicedependencies | 0.00 |
| nagios_serviceescalation_contactgroups | 0.00 |
| nagios_serviceescalation_contacts | 0.00 |
| nagios_serviceescalations | 0.00 |
| nagios_servicegroup_members | 0.02 |
| nagios_servicegroups | 0.00 |
| nagios_services | 0.09 |
| nagios_servicestatus | 0.18 |
| nagios_statehistory | 61.63 |
| nagios_systemcommands | 0.03 |
| nagios_timedeventqueue | 0.00 |
| nagios_timedevents | 0.00 |
| nagios_timeperiod_timeranges | 0.01 |
| nagios_timeperiods | 0.00 |
| tbl_command | 0.03 |
| tbl_contact | 0.01 |
| tbl_contactgroup | 0.01 |
| tbl_contacttemplate | 0.01 |
| tbl_domain | 0.01 |
| tbl_host | 0.01 |
| tbl_hostdependency | 0.00 |
| tbl_hostescalation | 0.00 |
| tbl_hostextinfo | 0.00 |
| tbl_hostgroup | 0.01 |
| tbl_hosttemplate | 0.01 |
| tbl_info | 0.13 |
| tbl_lnkContactToCommandHost | 0.00 |
| tbl_lnkContactToCommandService | 0.00 |
| tbl_lnkContactToContactgroup | 0.00 |
| tbl_lnkContactToContacttemplate | 0.00 |
| tbl_lnkContactToVariabledefinition | 0.00 |
| tbl_lnkContactgroupToContact | 0.00 |
| tbl_lnkContactgroupToContactgroup | 0.00 |
| tbl_lnkContacttemplateToCommandHost | 0.00 |
| tbl_lnkContacttemplateToCommandService | 0.00 |
| tbl_lnkContacttemplateToContactgroup | 0.00 |
| tbl_lnkContacttemplateToContacttemplate | 0.00 |
| tbl_lnkContacttemplateToVariabledefinition | 0.00 |
| tbl_lnkHostToContact | 0.00 |
| tbl_lnkHostToContactgroup | 0.00 |
| tbl_lnkHostToHost | 0.00 |
| tbl_lnkHostToHostgroup | 0.00 |
| tbl_lnkHostToHosttemplate | 0.00 |
| tbl_lnkHostToVariabledefinition | 0.00 |
| tbl_lnkHostdependencyToHost_DH | 0.00 |
| tbl_lnkHostdependencyToHost_H | 0.00 |
| tbl_lnkHostdependencyToHostgroup_DH | 0.00 |
| tbl_lnkHostdependencyToHostgroup_H | 0.00 |
| tbl_lnkHostescalationToContact | 0.00 |
| tbl_lnkHostescalationToContactgroup | 0.00 |
| tbl_lnkHostescalationToHost | 0.00 |
| tbl_lnkHostescalationToHostgroup | 0.00 |
| tbl_lnkHostgroupToHost | 0.00 |
| tbl_lnkHostgroupToHostgroup | 0.00 |
| tbl_lnkHosttemplateToContact | 0.00 |
| tbl_lnkHosttemplateToContactgroup | 0.00 |
| tbl_lnkHosttemplateToHost | 0.00 |
| tbl_lnkHosttemplateToHostgroup | 0.00 |
| tbl_lnkHosttemplateToHosttemplate | 0.00 |
| tbl_lnkHosttemplateToVariabledefinition | 0.00 |
| tbl_lnkServiceToContact | 0.00 |
| tbl_lnkServiceToContactgroup | 0.00 |
| tbl_lnkServiceToHost | 0.00 |
| tbl_lnkServiceToHostgroup | 0.00 |
| tbl_lnkServiceToServicegroup | 0.00 |
| tbl_lnkServiceToServicetemplate | 0.00 |
| tbl_lnkServiceToVariabledefinition | 0.00 |
| tbl_lnkServicedependencyToHost_DH | 0.00 |
| tbl_lnkServicedependencyToHost_H | 0.00 |
| tbl_lnkServicedependencyToHostgroup_DH | 0.00 |
| tbl_lnkServicedependencyToHostgroup_H | 0.00 |
| tbl_lnkServicedependencyToService_DS | 0.00 |
| tbl_lnkServicedependencyToService_S | 0.00 |
| tbl_lnkServiceescalationToContact | 0.00 |
| tbl_lnkServiceescalationToContactgroup | 0.00 |
| tbl_lnkServiceescalationToHost | 0.00 |
| tbl_lnkServiceescalationToHostgroup | 0.00 |
| tbl_lnkServiceescalationToService | 0.00 |
| tbl_lnkServicegroupToService | 0.00 |
| tbl_lnkServicegroupToServicegroup | 0.00 |
| tbl_lnkServicetemplateToContact | 0.00 |
| tbl_lnkServicetemplateToContactgroup | 0.00 |
| tbl_lnkServicetemplateToHost | 0.00 |
| tbl_lnkServicetemplateToHostgroup | 0.00 |
| tbl_lnkServicetemplateToServicegroup | 0.00 |
| tbl_lnkServicetemplateToServicetemplate | 0.00 |
| tbl_lnkServicetemplateToVariabledefinition | 0.00 |
| tbl_lnkTimeperiodToTimeperiod | 0.00 |
| tbl_logbook | 0.00 |
| tbl_mainmenu | 0.00 |
| tbl_service | 0.00 |
| tbl_servicedependency | 0.00 |
| tbl_serviceescalation | 0.00 |
| tbl_serviceextinfo | 0.00 |
| tbl_servicegroup | 0.00 |
| tbl_servicetemplate | 0.02 |
| tbl_settings | 0.00 |
| tbl_submenu | 0.00 |
| tbl_timedefinition | 0.00 |
| tbl_timeperiod | 0.01 |
| tbl_user | 0.01 |
| tbl_variabledefinition | 0.00 |
| xi_auditlog | 0.02 |
| xi_auth_tokens | 0.03 |
| xi_cmp_trapdata | 0.03 |
| xi_cmp_trapdata_log | 0.03 |
| xi_commands | 0.00 |
| xi_events | 0.00 |
| xi_incidents | 0.00 |
| xi_meta | 0.00 |
| xi_options | 0.01 |
| xi_sessions | 0.03 |
| xi_sysstat | 0.01 |
| xi_usermeta | 0.02 |
| xi_users | 0.01 |
+--------------------------------------------+------------+
root@smpnagios-kn-t100 # ./upgrade
Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, security, subscription-manager
Setting up Local Package Process
Examining fping-3.10-1.el6.rf.x86_64.rpm: fping-3.10-1.el6.rf.x86_64
fping-3.10-1.el6.rf.x86_64.rpm: does not update installed package.
Examining freetds-0.91-2.el6.x86_64.rpm: freetds-0.91-2.el6.x86_64
freetds-0.91-2.el6.x86_64.rpm: does not update installed package.
Examining libmcrypt-2.5.8-9.el6.x86_64.rpm: libmcrypt-2.5.8-9.el6.x86_64
libmcrypt-2.5.8-9.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-5.6.7-1.el6.x86_64.rpm: nagiosxi-5.6.7-1.el6.x86_64
nagiosxi-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-mrtg-5.6.7-1.el6.x86_64.rpm: nagiosxi-mrtg-5.6.7-1.el6.x86_64
nagiosxi-mrtg-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nagioscore-5.6.7-1.el6.x86_64.rpm: nagiosxi-nagioscore-5.6.7-1.el6.x86_64
nagiosxi-nagioscore-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nagiosmobile-5.6.7-1.el6.x86_64.rpm: nagiosxi-nagiosmobile-5.6.7-1.el6.x86_64
nagiosxi-nagiosmobile-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nagiosplugins-5.6.7-1.el6.x86_64.rpm: nagiosxi-nagiosplugins-5.6.7-1.el6.x86_64
nagiosxi-nagiosplugins-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nagvis-5.6.7-1.el6.x86_64.rpm: nagiosxi-nagvis-5.6.7-1.el6.x86_64
nagiosxi-nagvis-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-ndoutils-5.6.7-1.el6.x86_64.rpm: nagiosxi-ndoutils-5.6.7-1.el6.x86_64
nagiosxi-ndoutils-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nrds-5.6.7-1.el6.x86_64.rpm: nagiosxi-nrds-5.6.7-1.el6.x86_64
nagiosxi-nrds-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nrpe-5.6.7-1.el6.x86_64.rpm: nagiosxi-nrpe-5.6.7-1.el6.x86_64
nagiosxi-nrpe-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nsca-5.6.7-1.el6.x86_64.rpm: nagiosxi-nsca-5.6.7-1.el6.x86_64
nagiosxi-nsca-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nxti-5.6.7-1.el6.x86_64.rpm: nagiosxi-nxti-5.6.7-1.el6.x86_64
nagiosxi-nxti-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-pnp-5.6.7-1.el6.x86_64.rpm: nagiosxi-pnp-5.6.7-1.el6.x86_64
nagiosxi-pnp-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-shellinabox-5.6.7-1.el6.x86_64.rpm: nagiosxi-shellinabox-5.6.7-1.el6.x86_64
nagiosxi-shellinabox-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-wkhtmltox-5.6.7-1.el6.x86_64.rpm: nagiosxi-wkhtmltox-5.6.7-1.el6.x86_64
nagiosxi-wkhtmltox-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-wmic-5.6.7-1.el6.x86_64.rpm: nagiosxi-wmic-5.6.7-1.el6.x86_64
nagiosxi-wmic-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nmap-6.47-1.x86_64.rpm: 2:nmap-6.47-1.x86_64
nmap-6.47-1.x86_64.rpm: does not update installed package.
Examining perl-Config-IniFiles-2.72-2.el6.noarch.rpm: perl-Config-IniFiles-2.72-2.el6.noarch
perl-Config-IniFiles-2.72-2.el6.noarch.rpm: does not update installed package.
Examining perl-Crypt-DES-2.05-9.el6.x86_64.rpm: perl-Crypt-DES-2.05-9.el6.x86_64
perl-Crypt-DES-2.05-9.el6.x86_64.rpm: does not update installed package.
Examining perl-Crypt-Rijndael-1.09-2.el6.x86_64.rpm: perl-Crypt-Rijndael-1.09-2.el6.x86_64
perl-Crypt-Rijndael-1.09-2.el6.x86_64.rpm: does not update installed package.
Examining perl-Mail-IMAPClient-3.37-1.el6.noarch.rpm: perl-Mail-IMAPClient-3.37-1.el6.noarch
perl-Mail-IMAPClient-3.37-1.el6.noarch.rpm: does not update installed package.
Examining perl-Mail-POP3Client-2.18-6.el6.noarch.rpm: perl-Mail-POP3Client-2.18-6.el6.noarch
perl-Mail-POP3Client-2.18-6.el6.noarch.rpm: does not update installed package.
Examining perl-Math-Calc-Units-1.07-6.el6.noarch.rpm: perl-Math-Calc-Units-1.07-6.el6.noarch
perl-Math-Calc-Units-1.07-6.el6.noarch.rpm: does not update installed package.
Examining perl-Nagios-Monitoring-Plugin-0.51-1.el6.noarch.rpm: perl-Nagios-Monitoring-Plugin-0.51-1.el6.noarch
perl-Nagios-Monitoring-Plugin-0.51-1.el6.noarch.rpm: does not update installed package.
Examining perl-Net-SMTP-TLS-0.12-1.el6.rf.noarch.rpm: perl-Net-SMTP-TLS-0.12-1.el6.rf.noarch
perl-Net-SMTP-TLS-0.12-1.el6.rf.noarch.rpm: does not update installed package.
Examining perl-Net-SNMP-5.2.0-4.el6.noarch.rpm: perl-Net-SNMP-5.2.0-4.el6.noarch
perl-Net-SNMP-5.2.0-4.el6.noarch.rpm: does not update installed package.
Examining perl-Number-Format-1.73-3.el6.noarch.rpm: perl-Number-Format-1.73-3.el6.noarch
perl-Number-Format-1.73-3.el6.noarch.rpm: does not update installed package.
Examining php-mcrypt-5.3.3-5.el6.x86_64.rpm: php-mcrypt-5.3.3-5.el6.x86_64
php-mcrypt-5.3.3-5.el6.x86_64.rpm: does not update installed package.
Examining php-mssql-5.3.3-5.el6.x86_64.rpm: php-mssql-5.3.3-5.el6.x86_64
php-mssql-5.3.3-5.el6.x86_64.rpm: does not update installed package.
Examining php-pear-HTML-Template-IT-1.3.0-2.el5.noarch.rpm: php-pear-HTML-Template-IT-1.3.0-2.el5.noarch
php-pear-HTML-Template-IT-1.3.0-2.el5.noarch.rpm: does not update installed package.
Examining php-pecl-ssh2-0.11.0-7.el6.x86_64.rpm: php-pecl-ssh2-0.11.0-7.el6.x86_64
php-pecl-ssh2-0.11.0-7.el6.x86_64.rpm: does not update installed package.
Examining pymssql-1.0.2-4.el6.x86_64.rpm: pymssql-1.0.2-4.el6.x86_64
pymssql-1.0.2-4.el6.x86_64.rpm: does not update installed package.
Examining python-bson-2.5.2-3.el6.1.x86_64.rpm: python-bson-2.5.2-3.el6.1.x86_64
python-bson-2.5.2-3.el6.1.x86_64.rpm: does not update installed package.
Examining python-pymongo-2.5.2-3.el6.1.x86_64.rpm: python-pymongo-2.5.2-3.el6.1.x86_64
python-pymongo-2.5.2-3.el6.1.x86_64.rpm: does not update installed package.
Nothing to do
Uploading Enabled Repositories Report
Loaded plugins: product-id, subscription-manager
root@smpnagios-kn-t100 #
However, I have checked the logs and I have found that it can't backup the database because it doesn't like the password in the script.
[nagios@smpnagios-kn-t100 tmp]$ vi upgrade.log
No entry for terminal type "unknown";
using dumb terminal settings.
Stopping nagios: No lock file found in /usr/local/nagios/var/nagios.lock
Starting nagios: done.
Backing up Nagios Core...
tar: Removing leading `/' from member names
tar: /usr/local/nagios/var/ndo.sock: socket ignored
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var/debug.log: file changed as we read it
tar: /usr/local/nagios/var: file changed as we read it
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
Backing up the SNMP trap interface configuration files...
Backing up NRDP...
tar: Removing leading `/' from member names
Backing up Nagvis...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Got error: 144: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!
How do you get around this if it doesn't ask you for the password?
Regards,
Paul
My colleage tried the above and this was the output, it said that there was nothing to upgrade.
root@smpnagios-kn-t100 # mysqlcheck -r -f -uroot -pnagiosxi --all-databases
mysqlcheck: Error: Couldn't get table list for database #mysql50#lost+found: Can't read dir of './lost+found/' (errno: 13)
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
nagios.nagios_acknowledgements OK
nagios.nagios_commands OK
nagios.nagios_commenthistory OK
nagios.nagios_comments OK
nagios.nagios_configfiles OK
nagios.nagios_configfilevariables OK
nagios.nagios_conninfo OK
nagios.nagios_contact_addresses OK
nagios.nagios_contact_notificationcommands OK
nagios.nagios_contactgroup_members OK
nagios.nagios_contactgroups OK
nagios.nagios_contactnotificationmethods OK
nagios.nagios_contactnotifications OK
nagios.nagios_contacts OK
nagios.nagios_contactstatus OK
nagios.nagios_customvariables OK
nagios.nagios_customvariablestatus OK
nagios.nagios_dbversion OK
nagios.nagios_downtimehistory OK
nagios.nagios_eventhandlers OK
nagios.nagios_externalcommands OK
nagios.nagios_flappinghistory OK
nagios.nagios_host_contactgroups OK
nagios.nagios_host_contacts OK
nagios.nagios_host_parenthosts OK
nagios.nagios_hostchecks OK
nagios.nagios_hostdependencies OK
nagios.nagios_hostescalation_contactgroups OK
nagios.nagios_hostescalation_contacts OK
nagios.nagios_hostescalations OK
nagios.nagios_hostgroup_members OK
nagios.nagios_hostgroups OK
nagios.nagios_hosts OK
nagios.nagios_hoststatus OK
nagios.nagios_instances OK
^C
root@smpnagios-kn-t100 # echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -uroot -pnagiosxi --table
+--------------------------------------------+------------+
| Table | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements | 0.00 |
| nagios_commands | 0.02 |
| nagios_commenthistory | 0.04 |
| nagios_comments | 0.00 |
| nagios_configfiles | 0.00 |
| nagios_configfilevariables | 0.01 |
| nagios_conninfo | 0.02 |
| nagios_contact_addresses | 0.00 |
| nagios_contact_notificationcommands | 0.01 |
| nagios_contactgroup_members | 0.00 |
| nagios_contactgroups | 0.00 |
| nagios_contactnotificationmethods | 81.41 |
| nagios_contactnotifications | 86.23 |
| nagios_contacts | 0.00 |
| nagios_contactstatus | 0.00 |
| nagios_customvariables | 0.00 |
| nagios_customvariablestatus | 0.00 |
| nagios_dbversion | 0.00 |
| nagios_downtimehistory | 0.00 |
| nagios_eventhandlers | 0.00 |
| nagios_externalcommands | 0.00 |
| nagios_flappinghistory | 0.31 |
| nagios_host_contactgroups | 0.00 |
| nagios_host_contacts | 0.00 |
| nagios_host_parenthosts | 0.00 |
| nagios_hostchecks | 0.00 |
| nagios_hostdependencies | 0.00 |
| nagios_hostescalation_contactgroups | 0.00 |
| nagios_hostescalation_contacts | 0.00 |
| nagios_hostescalations | 0.00 |
| nagios_hostgroup_members | 0.00 |
| nagios_hostgroups | 0.00 |
| nagios_hosts | 0.01 |
| nagios_hoststatus | 0.03 |
| nagios_instances | 0.00 |
| nagios_logentries | 723.08 |
| nagios_notifications | 129.32 |
| nagios_objects | 0.16 |
| nagios_processevents | 0.01 |
| nagios_programstatus | 0.00 |
| nagios_runtimevariables | 0.00 |
| nagios_scheduleddowntime | 0.00 |
| nagios_service_contactgroups | 0.01 |
| nagios_service_contacts | 0.00 |
| nagios_service_parentservices | 0.00 |
| nagios_servicechecks | 0.00 |
| nagios_servicedependencies | 0.00 |
| nagios_serviceescalation_contactgroups | 0.00 |
| nagios_serviceescalation_contacts | 0.00 |
| nagios_serviceescalations | 0.00 |
| nagios_servicegroup_members | 0.02 |
| nagios_servicegroups | 0.00 |
| nagios_services | 0.09 |
| nagios_servicestatus | 0.18 |
| nagios_statehistory | 61.63 |
| nagios_systemcommands | 0.03 |
| nagios_timedeventqueue | 0.00 |
| nagios_timedevents | 0.00 |
| nagios_timeperiod_timeranges | 0.01 |
| nagios_timeperiods | 0.00 |
| tbl_command | 0.03 |
| tbl_contact | 0.01 |
| tbl_contactgroup | 0.01 |
| tbl_contacttemplate | 0.01 |
| tbl_domain | 0.01 |
| tbl_host | 0.01 |
| tbl_hostdependency | 0.00 |
| tbl_hostescalation | 0.00 |
| tbl_hostextinfo | 0.00 |
| tbl_hostgroup | 0.01 |
| tbl_hosttemplate | 0.01 |
| tbl_info | 0.13 |
| tbl_lnkContactToCommandHost | 0.00 |
| tbl_lnkContactToCommandService | 0.00 |
| tbl_lnkContactToContactgroup | 0.00 |
| tbl_lnkContactToContacttemplate | 0.00 |
| tbl_lnkContactToVariabledefinition | 0.00 |
| tbl_lnkContactgroupToContact | 0.00 |
| tbl_lnkContactgroupToContactgroup | 0.00 |
| tbl_lnkContacttemplateToCommandHost | 0.00 |
| tbl_lnkContacttemplateToCommandService | 0.00 |
| tbl_lnkContacttemplateToContactgroup | 0.00 |
| tbl_lnkContacttemplateToContacttemplate | 0.00 |
| tbl_lnkContacttemplateToVariabledefinition | 0.00 |
| tbl_lnkHostToContact | 0.00 |
| tbl_lnkHostToContactgroup | 0.00 |
| tbl_lnkHostToHost | 0.00 |
| tbl_lnkHostToHostgroup | 0.00 |
| tbl_lnkHostToHosttemplate | 0.00 |
| tbl_lnkHostToVariabledefinition | 0.00 |
| tbl_lnkHostdependencyToHost_DH | 0.00 |
| tbl_lnkHostdependencyToHost_H | 0.00 |
| tbl_lnkHostdependencyToHostgroup_DH | 0.00 |
| tbl_lnkHostdependencyToHostgroup_H | 0.00 |
| tbl_lnkHostescalationToContact | 0.00 |
| tbl_lnkHostescalationToContactgroup | 0.00 |
| tbl_lnkHostescalationToHost | 0.00 |
| tbl_lnkHostescalationToHostgroup | 0.00 |
| tbl_lnkHostgroupToHost | 0.00 |
| tbl_lnkHostgroupToHostgroup | 0.00 |
| tbl_lnkHosttemplateToContact | 0.00 |
| tbl_lnkHosttemplateToContactgroup | 0.00 |
| tbl_lnkHosttemplateToHost | 0.00 |
| tbl_lnkHosttemplateToHostgroup | 0.00 |
| tbl_lnkHosttemplateToHosttemplate | 0.00 |
| tbl_lnkHosttemplateToVariabledefinition | 0.00 |
| tbl_lnkServiceToContact | 0.00 |
| tbl_lnkServiceToContactgroup | 0.00 |
| tbl_lnkServiceToHost | 0.00 |
| tbl_lnkServiceToHostgroup | 0.00 |
| tbl_lnkServiceToServicegroup | 0.00 |
| tbl_lnkServiceToServicetemplate | 0.00 |
| tbl_lnkServiceToVariabledefinition | 0.00 |
| tbl_lnkServicedependencyToHost_DH | 0.00 |
| tbl_lnkServicedependencyToHost_H | 0.00 |
| tbl_lnkServicedependencyToHostgroup_DH | 0.00 |
| tbl_lnkServicedependencyToHostgroup_H | 0.00 |
| tbl_lnkServicedependencyToService_DS | 0.00 |
| tbl_lnkServicedependencyToService_S | 0.00 |
| tbl_lnkServiceescalationToContact | 0.00 |
| tbl_lnkServiceescalationToContactgroup | 0.00 |
| tbl_lnkServiceescalationToHost | 0.00 |
| tbl_lnkServiceescalationToHostgroup | 0.00 |
| tbl_lnkServiceescalationToService | 0.00 |
| tbl_lnkServicegroupToService | 0.00 |
| tbl_lnkServicegroupToServicegroup | 0.00 |
| tbl_lnkServicetemplateToContact | 0.00 |
| tbl_lnkServicetemplateToContactgroup | 0.00 |
| tbl_lnkServicetemplateToHost | 0.00 |
| tbl_lnkServicetemplateToHostgroup | 0.00 |
| tbl_lnkServicetemplateToServicegroup | 0.00 |
| tbl_lnkServicetemplateToServicetemplate | 0.00 |
| tbl_lnkServicetemplateToVariabledefinition | 0.00 |
| tbl_lnkTimeperiodToTimeperiod | 0.00 |
| tbl_logbook | 0.00 |
| tbl_mainmenu | 0.00 |
| tbl_service | 0.00 |
| tbl_servicedependency | 0.00 |
| tbl_serviceescalation | 0.00 |
| tbl_serviceextinfo | 0.00 |
| tbl_servicegroup | 0.00 |
| tbl_servicetemplate | 0.02 |
| tbl_settings | 0.00 |
| tbl_submenu | 0.00 |
| tbl_timedefinition | 0.00 |
| tbl_timeperiod | 0.01 |
| tbl_user | 0.01 |
| tbl_variabledefinition | 0.00 |
| xi_auditlog | 0.02 |
| xi_auth_tokens | 0.03 |
| xi_cmp_trapdata | 0.03 |
| xi_cmp_trapdata_log | 0.03 |
| xi_commands | 0.00 |
| xi_events | 0.00 |
| xi_incidents | 0.00 |
| xi_meta | 0.00 |
| xi_options | 0.01 |
| xi_sessions | 0.03 |
| xi_sysstat | 0.01 |
| xi_usermeta | 0.02 |
| xi_users | 0.01 |
+--------------------------------------------+------------+
root@smpnagios-kn-t100 # ./upgrade
Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, security, subscription-manager
Setting up Local Package Process
Examining fping-3.10-1.el6.rf.x86_64.rpm: fping-3.10-1.el6.rf.x86_64
fping-3.10-1.el6.rf.x86_64.rpm: does not update installed package.
Examining freetds-0.91-2.el6.x86_64.rpm: freetds-0.91-2.el6.x86_64
freetds-0.91-2.el6.x86_64.rpm: does not update installed package.
Examining libmcrypt-2.5.8-9.el6.x86_64.rpm: libmcrypt-2.5.8-9.el6.x86_64
libmcrypt-2.5.8-9.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-5.6.7-1.el6.x86_64.rpm: nagiosxi-5.6.7-1.el6.x86_64
nagiosxi-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-mrtg-5.6.7-1.el6.x86_64.rpm: nagiosxi-mrtg-5.6.7-1.el6.x86_64
nagiosxi-mrtg-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nagioscore-5.6.7-1.el6.x86_64.rpm: nagiosxi-nagioscore-5.6.7-1.el6.x86_64
nagiosxi-nagioscore-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nagiosmobile-5.6.7-1.el6.x86_64.rpm: nagiosxi-nagiosmobile-5.6.7-1.el6.x86_64
nagiosxi-nagiosmobile-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nagiosplugins-5.6.7-1.el6.x86_64.rpm: nagiosxi-nagiosplugins-5.6.7-1.el6.x86_64
nagiosxi-nagiosplugins-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nagvis-5.6.7-1.el6.x86_64.rpm: nagiosxi-nagvis-5.6.7-1.el6.x86_64
nagiosxi-nagvis-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-ndoutils-5.6.7-1.el6.x86_64.rpm: nagiosxi-ndoutils-5.6.7-1.el6.x86_64
nagiosxi-ndoutils-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nrds-5.6.7-1.el6.x86_64.rpm: nagiosxi-nrds-5.6.7-1.el6.x86_64
nagiosxi-nrds-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nrpe-5.6.7-1.el6.x86_64.rpm: nagiosxi-nrpe-5.6.7-1.el6.x86_64
nagiosxi-nrpe-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nsca-5.6.7-1.el6.x86_64.rpm: nagiosxi-nsca-5.6.7-1.el6.x86_64
nagiosxi-nsca-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-nxti-5.6.7-1.el6.x86_64.rpm: nagiosxi-nxti-5.6.7-1.el6.x86_64
nagiosxi-nxti-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-pnp-5.6.7-1.el6.x86_64.rpm: nagiosxi-pnp-5.6.7-1.el6.x86_64
nagiosxi-pnp-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-shellinabox-5.6.7-1.el6.x86_64.rpm: nagiosxi-shellinabox-5.6.7-1.el6.x86_64
nagiosxi-shellinabox-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-wkhtmltox-5.6.7-1.el6.x86_64.rpm: nagiosxi-wkhtmltox-5.6.7-1.el6.x86_64
nagiosxi-wkhtmltox-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nagiosxi-wmic-5.6.7-1.el6.x86_64.rpm: nagiosxi-wmic-5.6.7-1.el6.x86_64
nagiosxi-wmic-5.6.7-1.el6.x86_64.rpm: does not update installed package.
Examining nmap-6.47-1.x86_64.rpm: 2:nmap-6.47-1.x86_64
nmap-6.47-1.x86_64.rpm: does not update installed package.
Examining perl-Config-IniFiles-2.72-2.el6.noarch.rpm: perl-Config-IniFiles-2.72-2.el6.noarch
perl-Config-IniFiles-2.72-2.el6.noarch.rpm: does not update installed package.
Examining perl-Crypt-DES-2.05-9.el6.x86_64.rpm: perl-Crypt-DES-2.05-9.el6.x86_64
perl-Crypt-DES-2.05-9.el6.x86_64.rpm: does not update installed package.
Examining perl-Crypt-Rijndael-1.09-2.el6.x86_64.rpm: perl-Crypt-Rijndael-1.09-2.el6.x86_64
perl-Crypt-Rijndael-1.09-2.el6.x86_64.rpm: does not update installed package.
Examining perl-Mail-IMAPClient-3.37-1.el6.noarch.rpm: perl-Mail-IMAPClient-3.37-1.el6.noarch
perl-Mail-IMAPClient-3.37-1.el6.noarch.rpm: does not update installed package.
Examining perl-Mail-POP3Client-2.18-6.el6.noarch.rpm: perl-Mail-POP3Client-2.18-6.el6.noarch
perl-Mail-POP3Client-2.18-6.el6.noarch.rpm: does not update installed package.
Examining perl-Math-Calc-Units-1.07-6.el6.noarch.rpm: perl-Math-Calc-Units-1.07-6.el6.noarch
perl-Math-Calc-Units-1.07-6.el6.noarch.rpm: does not update installed package.
Examining perl-Nagios-Monitoring-Plugin-0.51-1.el6.noarch.rpm: perl-Nagios-Monitoring-Plugin-0.51-1.el6.noarch
perl-Nagios-Monitoring-Plugin-0.51-1.el6.noarch.rpm: does not update installed package.
Examining perl-Net-SMTP-TLS-0.12-1.el6.rf.noarch.rpm: perl-Net-SMTP-TLS-0.12-1.el6.rf.noarch
perl-Net-SMTP-TLS-0.12-1.el6.rf.noarch.rpm: does not update installed package.
Examining perl-Net-SNMP-5.2.0-4.el6.noarch.rpm: perl-Net-SNMP-5.2.0-4.el6.noarch
perl-Net-SNMP-5.2.0-4.el6.noarch.rpm: does not update installed package.
Examining perl-Number-Format-1.73-3.el6.noarch.rpm: perl-Number-Format-1.73-3.el6.noarch
perl-Number-Format-1.73-3.el6.noarch.rpm: does not update installed package.
Examining php-mcrypt-5.3.3-5.el6.x86_64.rpm: php-mcrypt-5.3.3-5.el6.x86_64
php-mcrypt-5.3.3-5.el6.x86_64.rpm: does not update installed package.
Examining php-mssql-5.3.3-5.el6.x86_64.rpm: php-mssql-5.3.3-5.el6.x86_64
php-mssql-5.3.3-5.el6.x86_64.rpm: does not update installed package.
Examining php-pear-HTML-Template-IT-1.3.0-2.el5.noarch.rpm: php-pear-HTML-Template-IT-1.3.0-2.el5.noarch
php-pear-HTML-Template-IT-1.3.0-2.el5.noarch.rpm: does not update installed package.
Examining php-pecl-ssh2-0.11.0-7.el6.x86_64.rpm: php-pecl-ssh2-0.11.0-7.el6.x86_64
php-pecl-ssh2-0.11.0-7.el6.x86_64.rpm: does not update installed package.
Examining pymssql-1.0.2-4.el6.x86_64.rpm: pymssql-1.0.2-4.el6.x86_64
pymssql-1.0.2-4.el6.x86_64.rpm: does not update installed package.
Examining python-bson-2.5.2-3.el6.1.x86_64.rpm: python-bson-2.5.2-3.el6.1.x86_64
python-bson-2.5.2-3.el6.1.x86_64.rpm: does not update installed package.
Examining python-pymongo-2.5.2-3.el6.1.x86_64.rpm: python-pymongo-2.5.2-3.el6.1.x86_64
python-pymongo-2.5.2-3.el6.1.x86_64.rpm: does not update installed package.
Nothing to do
Uploading Enabled Repositories Report
Loaded plugins: product-id, subscription-manager
root@smpnagios-kn-t100 #
However, I have checked the logs and I have found that it can't backup the database because it doesn't like the password in the script.
[nagios@smpnagios-kn-t100 tmp]$ vi upgrade.log
No entry for terminal type "unknown";
using dumb terminal settings.
Stopping nagios: No lock file found in /usr/local/nagios/var/nagios.lock
Starting nagios: done.
Backing up Nagios Core...
tar: Removing leading `/' from member names
tar: /usr/local/nagios/var/ndo.sock: socket ignored
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var/debug.log: file changed as we read it
tar: /usr/local/nagios/var: file changed as we read it
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
Backing up the SNMP trap interface configuration files...
Backing up NRDP...
tar: Removing leading `/' from member names
Backing up Nagvis...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Got error: 144: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!
How do you get around this if it doesn't ask you for the password?
Regards,
Paul