NagiosXi SQL Error – Table is marked as crashed and should be repaired

Root Cause:- Nagios is constantly read and write to the mysql database, killing the mysqld process will cause the database table crashed.

Below are the most common action cause the database table crashed

  • power outages,
  • running out of disk space
  • improper shutting down

You will see similar error log show in mysqld.log

You also will see SQL Error show on the NagiosXi Page

Solution:-

You can repair the nagios and nagiosql databases by running the following commands in the command line as the root user:

Above script will repair both databases (nagios and nagiosql)

How to install a Debian update manually?

As a best practice, we should keep all the server patch with latest update. This tutorial tells i will demonstrate how to patch your Debian server with the latest updates. You need to use either apt-get command or apt command to apply patches to Debian Linux server.

Step:

i. Connect to your Debian system via SSH. Once you are in the terminal, enter the following commands:-

apt-get update

apt-get update command is used to download package information from all configured sources

Continue reading

How to offline Patch VMware vCenter Server Appliance (VCSA)

Due to most recenty VMware released two vulnerabilities in vCenter Server as well as VMware ESXi hypervisor, we received a lot of customer request us to perform vCenter and Hypervisor patching.

Below are the table show fixed vCenter version

Affected Product VersionFixed Version
vCenter Server 6.56.5 U3n
vCenter Server 6.76.7 U3l
vCenter Server 7.07.0 U1c

Here i going to write the simple vCenter patching tutorial to demonstrate the steps.

Download vCenter Server Patch

Download the Patched from VMware product patches page – https://my.vmware.com/group/vmware/patch#search

After that, upload it to a local or shared datastore.

Continue reading