To disable foreign key constraints when you want to truncate a table: Use FOREIGN_KEY_CHECKS and remember to enable it when you’re done:

Remove server name from Apache headers:- It is essential to remove Apache server header to hide Apache server information and protect your website from malicious attackers. Here’s how to remove server name from Apache response header using htaccess. You can use it to hide the Apache version and server type… Continue Reading Hide server details and disable TLSV1.0 and TLSV1.1

How to enable exec() function in PHP-FPM Date: 02-10-2021 Step 1: Log in to the server via SSH. Step 2: Check the PHP version of the server by using the below command.# php -v Step 3: If your domain using PHP version 7.3, open the PHP-FPM configuration file. # vi… Continue Reading How to enable exec() function in PHP-FPM

Sometimes we may delete the cPanel account accidentally. May be we will be having the backups enabled but still inorder to get the latest backup before termination, you can use the below script. Go to the below path/usr/local/cpanel/scripts Create a file with name “prekillacct”vi prekillacct Install AWS CLI in the… Continue Reading Script to backup the cPanel account to S3 before the termination

When you get the above error, please follow the below steps. 1) Checked the file where the Javaheapmemory needs to be increased. Developers can help you on this. 2) After identifying the file, increase it accordingly. For example:- If the current value is 2048m then increase it to 4096m. Issue… Continue Reading java.lang.OutOfMemoryError: Java heap space

CHECK_NRPE: Error – Could not complete SSL handshake Date: 18-09-2021 When you add a server to Nagios monitoring server getting this error. You can follow the below steps. Step 1: Log in to the nrpe client-server via SSH.Step 2: Run the below command.# vim /etc/nagios/nrpe.cfgStep3: Add the Nagios server IP… Continue Reading CHECK_NRPE: Error – Could not complete SSL handshake

MySQL replication should work without problems even if the servers are restarted, databases created and removed, data flowing in and out. Sometimes, however, there are errors that are breaking the replication process. It is good to know once such situation appears. Please find the bash script below which gives the… Continue Reading MySQL replication status alerts with bash script

Inroder to avoid giving the PEM key to the user or employee and adding the user or employee key in the servers, Amazon introduced Amazon EC2 instance connect. Whenever employee leaves the company simply delete the IAM user, no need to go to each server, search for his or her… Continue Reading SSH access through IAM with EC2 instance connect.

How to set up Gitlab Backups within Amazon S3 Bucket Date: 30-08-2021 Step 1: Log in to the GitLab server via SSH as root. Step 2: Use the following command to create the backup if you’ve installed GitLab with the Omnibus package.# gitlab-rake gitlab:backup:create Step 3: This backup creates an… Continue Reading How to set up Gitlab Backups within Amazon S3 Bucket

If you face the above error in any of your RDS replicas, please follow the below steps. When you face this issue you will also see the lag between your master and replica. The status of the “Replication state” will be in “error” state. Check the status of the slave… Continue Reading Read Replica Replication Error – SQLError