• Mysql

Install Brotli on Apache 2.4 on cPanel

By Prasad Naik

October 28, 2020

[root@server /]# yum install brotliLoaded plugins: fastestmirror, getpagespeed, universal-hooksLoading mirror speeds from cached hostfileepel/x86_64/metalink | 8.6 kB 00:00:00 EA4: 208.74.123.61 cpanel-addons-production-feed: 208.74.123.61 cpanel-plugins: 208.74.123.61 base: mirrors.radwebhosting.com epel: pubmirror2.math.uh.edu extras: centos.mirror.lstn.net updates: repos.dfw.quadranet.comResolving Dependencies–> Running transaction check—> Package brotli.x86_64 0:1.0.7-5.el7 will be installed–> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================================================ Package Arch Version Repository Size Installing:brotli x86_64 […]

• Mysql

WHMCS client area blank

By Prasad Naik

October 27, 2020

I was having an issue where WHMCS admin panel was working fine However client area was showing blank page So I enabled error logging in WHMCS in configuration.php file using below paraneter $display_errors = true; and tried accessing WHMCS client area It showed Memory error which was a PHP memory issue Increasing PHP memory fixed […]

• Mysql

Too many concurrent SMTP connections errors exim

By Prasad Naik

October 12, 2020

The default value for smtp_Accept_max in exim.conf is 30 in cpanel You need to login to WHM > Home »Service Configuration »Exim Configuration Manager >> Advanced Editor Search for parameter smtp_Accept_max and change the value to 100 and save this will save file and restart exim and resolve the issue

• Mysql

error: libcare:3 bad rotation count ‘5

By Prasad Naik

October 10, 2020

Got an error from Anacron below error error: libcare:3 bad rotation count ‘5 # keep 5 last archives’error: found error in /var/log/libcare/*.log , skipping The fix to this issue was open file /etc/logrotate.d/libcare /var/log/libcare/*.log { daily rotate 5 #keep 5 last archives missingok # it's ok if there is no such file notifempty # do […]

• Mysql

Cannot open /var/log/sa/sa09: No such file or directory

By Prasad Naik

October 9, 2020

Have been getting emails on below error “Cannot open /var/log/sa/sa09: No such file or directory” The solution is to reinstall cronie-anacron using command yum reinstall cronie-anacron Loaded plugins: fastestmirror, universal-hooksLoading mirror speeds from cached hostfile EA4: 208.74.123.61 cpanel-addons-production-feed: 208.74.123.61 cpanel-plugins: 208.74.123.61 base: mirror.oss.ou.edu extras: mirror.oss.ou.edu updates: mirror.netdepot.comEA4 | 2.9 kB 00:00:00cpanel-addons-production-feed | 2.9 kB 00:00:00cpanel-plugins […]

• Mysql

Error Couldn’t find device with uuid

By Prasad Naik

September 23, 2020

Got an error while working on a LVM system [root@ok1x40 daily]# vgsWARNING: Device for PV zwUwUP-OyCI-O3T4-c4l5-YCUV-8wpX-3UIA0x not found or rejected by a filter.WARNING: Device for PV zwUwUP-OyCI-O3T4-c4l5-YCUV-8wpX-3UIA0x not found or rejected by a filter.Couldn’t find device with uuid zwUwUP-OyCI-O3T4-c4l5-YCUV-8wpX-3UIA0x.VG #PV #LV #SN Attr VSize VFreevg 1 1 0 wz-pn- <9.88g 0vg 1 16 0 wz–n- […]

• Mysql

Roundcube from Mysql to Sqlite

By Prasad Naik

September 22, 2020

• Mysql

YumRepo Error: All mirror URLs are not using ftp, http[s] or file.

By Prasad Naik

September 2, 2020

Have been getting below error on one of the Centos 5 VM where yum is not working and giving below error yum update kernelLoaded plugins: fastestmirrorLoading mirror speeds from cached hostfileYumRepo Error: All mirror URLs are not using ftp, http[s] or file.Eg. Invalid release/repo/arch combination/removing mirrorlist with no valid mirrors: /var/cache/yum/base/mirrorlist.txtError: Cannot find a valid […]

• Mysql

Error restoring a particular database

By Prasad Naik

August 29, 2020

[root@OK1053 mysql]# mysql uulimain_testagain < /home/uulimain/public_html/uulimain_testagain.sqlERROR 1067 (42000) at line 242: Invalid default value for ‘up_to_date_as_of’ For this error need to cross check the mysql version of database backup from where is imported and also the mysql version on the current server, if both are same database will restore.

• Mysql

The MySQL Connection could not be established. Joomla

By Prasad Naik

July 9, 2020

While instaling Joomla using softaculous was getting error The MySQL Connection could not be established Mysql was working fine issue was with Mysql not supporting more then 16 characters in database name. in advanded setting I changed database name which resolved this issue

• Mysql

Activating lvgroup

By Prasad Naik

July 8, 2020

lvscaninactive ‘/dev/vg1/vsv1001-d8pixocsw0jjt67p-28scn37pgayace8e’ [801.00 GiB] inherit Use below command to activate the lvgroup lvchange -a y /dev/vg1/vsv1001-d8pixocsw0jjt67p-28scn37pgayace8e [root@OK10XX qemu]# lvscanACTIVE ‘/dev/vg1/vsv1001-d8pixocsw0jjt67p-28scn37pgayace8e’ [801.00 GiB] inherit

• Mysql

FFMPEG and PHPFFMPEG installlation on Centos 7

By Prasad Naik

June 24, 2020

yum install epel-release yum localinstall –nogpgcheck https://download1.rpmfusion.org/free/el/rpmfusion-free-release-7.noarch.rpm yum install ffmpeg ffmpeg-devel mkdir /root/source cd /root/source/ git clone https://github.com/tony2001/ffmpeg-php.git cd ffmpeg-php/ /opt/cpanel/ea-php56/root/usr/bin/phpize ./configure –with-php-config=/opt/cpanel/ea-php56/root/usr/bin/php-config nake && make install Add line extension=ffmpeg.so in php.ini and restarted httpd