cPanel MySQL/MariaBB error: adminbin Cpanel/cpmysql/DBCACHE: exit 11 [SOLVED]

Many cPanel users are experiencing the above error within the cPanel interface recently; The error appears within cPanel, giving the impression that MariaDB/ MySQL is not working. Infect the error is a false positive, MariaDB/MySQL is infect working perfectly fine.

 

 The MySQL server is currently offline.
 adminbin Cpanel/cpmysql/DBCACHE: exit 1

First Check Log in cPanel

/usr/local/cpanel/logs/error_log

You May Get Something Like That

cpanel::cpanel::cptt_exectag("/usr/local/cpanel/base/frontend/paper_lantern/sql/index.html.tt", 1) called at cpanel.pl line 4637
cpanel::cpanel::run_standard_mode() called at cpanel.pl line 929
cpanel::cpanel::script("cpanel::cpanel", "./frontend/paper_lantern/sql/index.html.tt") called at cpanel.pl line 325
[2021-10-26 05:47:41 +0000] info [] The cacheid for the user “thetechp” was reset because it was in the future: Tue Nov 9 08:12:02 2021
[2021-10-26 05:47:41 +0000] info [] The cacheid for the user “thetechp” was reset because it was in the future: Tue Nov 9 08:12:06 2021
[2021-10-26 05:47:41 +0000] info [] The cacheid for the user “agunmyid” was reset because it was in the future: Tue Nov 9 08:06:37 2021

To Fix This Issue

mysqldump MySQL > /root/mysql-backup.sql
Then Go to WHM Click Jetbackup & Restore Old Backup To That User which one is affected   & Get Fix 
/scripts/restartsrv_mysql
Have a Good Day 🙂 

HOW TO INSTALL REDIS AND PHP REDIS ON A CPANEL CENTOS 7 SERVER

This guide will show you how to set up Redis and PHP Redis to dramatically increase the performance of your server.

Redis is an open-source solution that functions as a database of structured cached data that is saved in your server’s RAM. Instead than relying on disk delay, the cache will deliver significantly higher throughput because it is stored in memory.

The guide presupposed that you have a CentOS 7 server with cPanel installed. If you have a Managed Server the installation can be done by our support.

1) Login through SSH and run the following commands :

sudo yum install epel-release yum-utils
sudo yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm
sudo yum-config-manager --enable rem
yum install redis

2) Once installed, you would need to start it:

sudo systemctl start redis
sudo systemctl enable redis
sudo systemctl status redis

The latest command should give you a confirmation of that Redis is running.

sudo systemctl status redis
● redis.service – Redis persistent key-value database
Loaded: loaded (/usr/lib/systemd/system/redis.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/redis.service.d
└─limit.conf
Active: active (running) since Fri 2021-09-17 12:41:53 EDT; 8s ago
Main PID: 17753 (redis-server)
CGroup: /system.slice/redis.service
└─17753 /usr/bin/redis-server 127.0.0.1:6379

It also returns the port being used (here 6379) which you may need for your application.

3) log in to WHM and search in the WHM sidebar for Module Installers. Click on it and then click on Manage PHP PECL.

4) At the next stage, select the PHP version you would like to install Redis For and inside the Module Search type Redis and click on Go

5) Finally, in the search result click on Install and after a few seconds, it should be completed.

That’s it, you have now enabled a Redis Cache on your server.

./

Install cPanel In CentOS

Before Start, We Need to Know What is cPanel
cPanel is an online Linux-based graphical interface (GUI) used as a control panel to simplify website and server management. cPanel allows you to publish websites, manage domains, organize web files, create email accounts, and more.

Let’s Go for Install it in Centos VPS, my VPS run centos 7 ( 8 GB ram, 4 Core CPU)

First, We Need to Login VPS from putty Software, if You Linux User Then use the terminal

For Putty User:

For Linux User:

ssh root@192.168.1.1

After Login Your Just Give This Command

yum update -y

This Command will Update your OS Repo

Then Use cPanel Install Command

cd /home && curl -o latest -L https://securedownloads.cpanel.net/latest && sh latest

Now It will Start Install Auto, you don’t need to press anything

Finally, You have Installed cPanel in your Server Or VPS