Category: cPanel

How to backup the database of a cPanel account using AWS S3 bucket

Install and Use AWS CLI for backup 1.Check python version #python --version 2.Download the AWS CLI Bundled Installer #curl "https://s3.amazonaws.com/aws-cli/awscli-bundle.zip" -o "awscli-bundle.zip" 3.Unzip and install #unzip awscli-bundle.zip #./awscli-bundle/install -i /usr/local/aws -b /usr/local/bin/aws 4.Installed Version Check #/usr/local/bin/aws --version 5.Configuring AWS Bucket #aws configure Or can configure at location #/root/.aws/credentials in file. aws_access_key_id = **************** aws_secret_access_key = … Continue reading How to backup the database of a cPanel account using AWS S3 bucket →

How to enable HttpOnly flag in Apache – cPanel

We can mitigate most common XSS attacks using HttpOnly and Secure flag with our cookie. Without having HttpOnly and Secure flag in the HTTP response header, it is possible to steal or manipulate web application session and cookies. The steps to enable HttpOnly and Secure flag Go to : Home > Service Configuration > Apache … Continue reading How to enable HttpOnly flag in Apache – cPanel →

Unable to add plugins from wordpress admin dashboard

After login to wordpress dashboard and tried to add new plugins It shows An unexpected error occurred. Something may be wrong with WordPress.org or this server’s configuration. If you continue to have problems, please try the support forums. While checking the logs the following error was getting generated [Fri Jan 03 08:16:46.573487 2020] [ssl:error] [pid … Continue reading Unable to add plugins from wordpress admin dashboard →

cPanel to interworx transfer fails due to space issue with /tmp folder

The interworx import works by writing the file in the /tmp directory by default and the large sized accounts cannot be written into /tmp due to space issues. So we need to manually change the directory path ( dir path) in the interworx default configuration file. /home/interworx/iworx.ini +++++ # vi /home/interworx/iworx.ini [dir] cron=”/var/spool/cron” domainkeys=”/etc/domainkeys” log=”/var/log” … Continue reading cPanel to interworx transfer fails due to space issue with /tmp folder →

[Cpanel::TailWatch::Eximstats] [SQLERR] Could not execute query, logging SQL to /var/cpanel/sql

The following error was generating to client related to eximstats sqlite database [Cpanel::TailWatch::Eximstats] [ERR] SQL Failed with error ((XID f82uy4) The system received an error from the “SQLite” database “/var/cpanel/eximstats_db.sqlite3”: SQLITE_CONSTRAINT (UNIQUE constraint failed: smtp.sendunixtime, smtp.msgid, smtp.email, smtp.deliveredto, smtp.router)): INSERT INTO smtp (sendunixtime,msgid,email,processed,transport_method,transport_is_remote,host,ip,deliveredto,router,deliveryuser,deliverydomain,counteddomain,countedtime,countedhour) VALUES(‘1575787697′,’1idqMb-00hujj-Ah’,’root@server.bunny.tech’,’2′,’dovecot_virtual_delivery’,’0′,’localhost’,’127.0.0.1′,’queue@bunny.tech’,’virtual_user’,’bunny’,’bunny.tech’,”,’0′,’0′) [9035] [2019-12-17 17:47:50] [Cpanel::TailWatch::Eximstats] [SQLERR] Could not execute query, logging SQL … Continue reading [Cpanel::TailWatch::Eximstats] [SQLERR] Could not execute query, logging SQL to /var/cpanel/sql →

softaculous php version not detected while upgrading and Installing Drupal in a cPanel server

Fix For upgradation issue # cd /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/hooks # cp -p pre_upgrade.txt pre_upgrade.php # vi pre_upgrade.php function __pre_upgrade($installation){ global $soft, $software, $globals; // Do stuff here e.g. is as follows if($soft == 26){ /* Do things only if its WordPress */ } $version = '5.6.16'; define('php_version', $version); } For installation issue # cp -p pre_install.txt pre_install.php … Continue reading softaculous php version not detected while upgrading and Installing Drupal in a cPanel server →