Category Archives: Mysql

upcp on cPanel failed

while running upcp on cpanel server it stopped with error

Running /usr/local/cpanel/scripts/updatenow --upcp --log=/var/cpanel/updatelogs/update.486871.726225288.1718207292.log --force failed, exited with code 1 (signal = 0)

On checking logs in /var/cpanel/updatelogs/update.486871.726225288.1718207292.log

We see the error

[2024-09-04 13:06:20 -0400] * FATAL: Test install failed: error: Failed dependencies:
[2024-09-04 13:06:20 -0400] libonig.so.5()(64bit) is needed by (installed) alt-php-internal-mbstring-8.2.14-2.el8.x86_64
[2024-09-04 13:06:20 -0400] oniguruma is needed by (installed) alt-php-internal-mbstring-8.2.14-

The fix to this issue on Almalinux was installing oniguruma by command

dnf install oniguruma

now upcp work fine without any issues

Opencart Broken page CSS images missing

We had this issue with one of our customer

Where the opencard was showing broekn site with no images loading and only skeleton page showing up

The issue was due to issue in opencart config.php

/ HTTP
define(‘HTTP_SERVER’, ‘http where http needs to be changed to https for website to work properly

Once changed the website is working without any issues

Virtualizor Panel not opening Softacalous

First check status of virtualizor

ps aux | grep virtualizor

If nothing is showing up in results

Check using command

systemctl status virtualizor

If still now working use command

service virtualizor restart


Stopping php-fpm: php-fpm is stopped
Stopping nginx: nginx is stopped
Stopping php-fpm: php-fpm is stopped
Stopping nginx: nginx is stopped
ERROR! MySQL server PID file could not be found!
/bin/systemctl
Starting php-fpm: Done…
Starting nginx: Done…
Starting MySQL.. SUCCESS!

The public_html folder permission keeps getting reverted in cPanel

The ownership keeps getting changed to user.nobody in cpanel automatically.

on debugging this issue it was found that cpanel has a new feature which was causing this

in

Home /
Server Configuration /Enable File Protect

Disabling it fixed the issue of permission changing automatically


Tweak Settings

Updating “Enable File Protect” from “On” to “Off”.
“Enable File Protect” was updated.
Processing post action for Enable File Protect:
Setting /home permissions to 0711 …
Setting permissions for users …
my247web …
… Done
“Enable File Protect” was updated.
Done.

cPanel PHP 8.3 does not install Ioncube

cpanel latest version which does not include ioncube loader in php 8.3

due to check softacolous does not work

Fix of this issue is to install iocoube loader for PHP 8.3

Below are the steps to be executed

wget -O /usr/local/cpanel/3rdparty/php/unversioned/ioncube/ioncube_loader_lin_8.3.so https://files.virtualizor.com/ioncube/64/ioncube_loader_lin_8.3.so

Check version of Ioncube using below command

/usr/local/cpanel/3rdparty/bin/php –version
PHP 8.3.8 (cli) (built: Jun 11 2024 12:00:31) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.3.8, Copyright (c) Zend Technologies
with the ionCube PHP Loader v13.3.0, Copyright (c) 2002-2024, by ionCube Ltd.

Child failed to make LIVEAPI connection to cPanel.

Softacalous on cpanel was giving error or ioncube loader

Even disabling and reenabling ioncobe from tweak setting didnt fix the issue

Script error: the ionCube Loader for PHP needs to be installed. The ionCube Loader is the industry standard PHP extension for running protected PHP code, and can usually be added easily to a PHP installation. For Loaders please visit: https://get-loader.ioncube.com For an instructional video please see: http://ioncu.be/LV Child failed to make LIVEAPI connection to cPanel.

Reinstalling softacalous should fix the issue

wget -N http://files.softaculous.com/install.sh
chmod 755 install.sh
./install.sh –reinstall

Mysql 8.0 breakdown

Mysql 8.0 was not started on cpanel all of sudden without issue

After googling the issue was found to be with MySQL 8.0.38 release

Run the below 3 commands

yum downgrade mysql-community-* # to downgrade mysql to previous version

/scripts/restartsrv_mysql # Restart mysql

dnf install python3-dnf-plugin-versionlock #install version lock on amla linux

yum versionlock mysql* #lock the mysql version so cpanel wont overwrite it

Mysql should be up and online and version lock will stop cpanel overwritting it on nightly updates until lock is removed

GPT PMBR size mismatch

GPT PMBR size mismatch (41943039 != 262143999) will be corrected by write.
The backup GPT table is not on the end of the device. This problem will be corrected by write

While doing fdisk on server was getting the error mentioned above

The solution to this issue was to use command parted -l

[root@db ~]# parted -l
Warning: Not all of the space available to /dev/vda appears to be used, you can
fix the GPT to use all of the space (an extra 220200960 blocks) or continue with
the current setting?
Fix/Ignore? fix
Model: Virtio Block Device (virtblk)
Disk /dev/vda: 134GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt
Disk Flags:

Number Start End Size File system Name Flags
1 1049kB 13.1GB 13.1GB ext4 Linux filesystem
2 13.1GB 21.5GB 8388MB linux-swap(v1) Linux swap swap

Rebooting the VM after this fixed the issue

Almalinux (FATAL): yum failed 6 times. The installation process cannot continue

While install cpanel on Almalinux 8 had an issue where cpanel was not getting installed and stopping with error

024-03-21 11:12:42 449 307652: Public key for nscd-2.28-236.el8_9.12.x86_64.rpm is not installed. Failing package is: nscd-2.28-236.el8_9.12.x86_64
2024-03-21 11:12:42 449 307652: GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-AlmaLinux
2024-03-21 11:12:42 449 307652: The downloaded packages were saved in cache until the next successful transaction.
2024-03-21 11:12:42 449 307652: You can remove cached packages by executing ‘yum clean packages’.
2024-03-21 11:12:42 449 307652: Error: GPG check FAILED
2024-03-21 11:12:42 449 307652: – ssystem [EXIT_CODE] ‘/usr/bin/yum’ exited with 1
2024-03-21 11:12:42 449 307652: – ssystem [END]
2024-03-21 11:12:42 44 307652: cPanel is here to help! Our technical KnowledgeBase and cPanel Community is just a click away at https://support.cpanel.net/
2024-03-21 11:12:42 453 307652: yum failed 6 times. The installation process cannot continue.

...propagated at /home/cPanelInstall/selfgz307486/Installer.pm line 618.2024-03-21 11:12:42   44 [307540] ( INFO): cPanel is here to help! Our technical KnowledgeBase and cPanel Community is just a click away at https://support.cpanel.net/

2024-03-21 11:12:42 558 307540: ensure_pkgs_install failed: 256

The issue was due to Almalinux updated their GPG keys recently, and it appears the server may not have had the most up-to-date version.

Running command fixed the issue

rpm –import https://repo.almalinux.org/almalinux/RPM-GPG-KEY-AlmaLinux

Now cpanel install is working fine