Category Archives: Mysql

error: libcare:3 bad rotation count ‘5

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 nothing if file is empty
compress
}

Remove line "#keep 5 last archives" and save file

This fixes the issue

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

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-hooks
Loading 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.com
    EA4 | 2.9 kB 00:00:00
    cpanel-addons-production-feed | 2.9 kB 00:00:00
    cpanel-plugins | 2.9 kB 00:00:00
    MariaDB101 | 2.9 kB 00:00:00
    Resolving Dependencies
    There are unfinished transactions remaining. You might consider running yum-complete-transaction, or “yum-complete-transaction –cleanup-only” and “yum history redo last”, first to finish them. If those don’t work you’ll have to try removing/installing packages by hand (maybe package-cleanup can help).
    –> Running transaction check
    —> Package cronie-anacron.x86_64 0:1.4.11-23.el7 will be reinstalled
    –> Finished Dependency Resolution

Dependencies Resolved

============================================================================================================================================================================================================

Package Arch Version Repository Size

Reinstalling:
cronie-anacron x86_64 1.4.11-23.el7 base 36 k

Transaction Summary

Reinstall 1 Package

Total download size: 36 k
Installed size: 41 k
Is this ok [y/d/N]: y
Downloading packages:
cronie-anacron-1.4.11-23.el7.x86_64.rpm | 36 kB 00:00:15
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : cronie-anacron-1.4.11-23.el7.x86_64 1/1
Verifying : cronie-anacron-1.4.11-23.el7.x86_64 1/1

Installed:
cronie-anacron.x86_64 0:1.4.11-23.el7

Complete!

Error Couldn’t find device with uuid

Got an error while working on a LVM system

[root@ok1x40 daily]# vgs
WARNING: 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 VFree
vg 1 1 0 wz-pn- <9.88g 0
vg 1 16 0 wz–n- 1.86t <710.23g

It looked like some issue in Logical Volume..

lvs
WARNING: Device for PV KdplBp-AHJU-a9nD-Cv3N-V1Dl-acFu-M1oiQ0 not found or rejected by a filter.
WARNING: Device for PV KdplBp-AHJU-a9nD-Cv3N-V1Dl-acFu-M1oiQ0 not found or rejected by a filter.
Couldn’t find device with uuid KdplBp-AHJU-a9nD-Cv3N-V1Dl-acFu-M1oiQ0.
LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert
configuration vg -wi—–p- <14.88g
root vg -wi-ao—- <48.83g
swap vg -wi-ao—- 15.62g
tmp vg -wi-ao—- 1.00g
vsv1001-deqpg1f97cuqzllv-darhc65toodnoiui vg -wi-ao—- 403.00g
vsv1002-d9ty0zwjje9ticwc-plaognhtcimj2tza vg -wi-ao—- 150.00g
vsv1004-d3nvtg9syf3rzavo-ps55iqd91vmnoytn vg -wi-ao—- 10.00g
vsv1005-dxrby0mvwwes6y4i-qktbrsa2vsfgonip vg -wi-ao—- 10.00g
vsv1006-duver6l3z0elsem6-e5yeqjhnlqccv2le vg -wi-ao—- 10.00g
vsv1007-d7h7wgusx2j5iqio-hqrlux8q9a3uk6xj vg -wi-ao—- 20.00g
vsv1009-drn5od5wnepqauvh-rstq5mmff8lmcezb vg -wi-ao—- 95.00g
vsv1010-d0kngqlyhr3mfhjy-hp0fbxcr5bmvkdeg vg -wi-ao—- 90.00g
vsv1017-dmkzi0yoa1y8biuz-swjnad3tpe0wynef vg -wi-ao—- 250.00g
vsv1018-drohpkk0xl1xgrar-acglf0q089m0c8ic vg -wi-a—– 15.00g
vsv1018-dylb8pcyjrcomdqc-tafjzcwmstyqdu1t vg -wi-a—– 56.00g
vsv1020-dzh3wi7fy2sgpckv-4r02v2bksy4lxdgu vg -wi-a—– 10.00g

I dont see any drive having same UUID as shown as missing

So went ahead and rescanned using 

 vgscan

now all things looks good

lvscan
ACTIVE '/dev/vg/swap' [15.62 GiB] inherit
ACTIVE '/dev/vg/tmp' [1.00 GiB] inherit
ACTIVE '/dev/vg/root' [<48.83 GiB] inherit
ACTIVE '/dev/vg/vsv1001-deqpg1f97cuqzllv-darhc65toodnoiui' [403.00 GiB] inherit
ACTIVE '/dev/vg/vsv1002-d9ty0zwjje9ticwc-plaognhtcimj2tza' [150.00 GiB] inherit
ACTIVE '/dev/vg/vsv1004-d3nvtg9syf3rzavo-ps55iqd91vmnoytn' [10.00 GiB] inherit
ACTIVE '/dev/vg/vsv1005-dxrby0mvwwes6y4i-qktbrsa2vsfgonip' [10.00 GiB] inherit
ACTIVE '/dev/vg/vsv1006-duver6l3z0elsem6-e5yeqjhnlqccv2le' [10.00 GiB] inherit
ACTIVE '/dev/vg/vsv1007-d7h7wgusx2j5iqio-hqrlux8q9a3uk6xj' [20.00 GiB] inherit
ACTIVE '/dev/vg/vsv1009-drn5od5wnepqauvh-rstq5mmff8lmcezb' [95.00 GiB] inherit
ACTIVE '/dev/vg/vsv1010-d0kngqlyhr3mfhjy-hp0fbxcr5bmvkdeg' [90.00 GiB] inherit
ACTIVE Original '/dev/vg/vsv1017-dmkzi0yoa1y8biuz-swjnad3tpe0wynef' [250.00 GiB] inherit
ACTIVE '/dev/vg/vsv1018-dylb8pcyjrcomdqc-tafjzcwmstyqdu1t' [56.00 GiB] inherit
ACTIVE '/dev/vg/vsv1020-dzh3wi7fy2sgpckv-4r02v2bksy4lxdgu' [10.00 GiB] inherit
ACTIVE '/dev/vg/vsv1018-drohpkk0xl1xgrar-acglf0q089m0c8ic' [15.00 GiB] inherit
ACTIVE '/dev/vg/vsv1018-dsm0mwrudbywwyld-5ijzvvkhs8qmci3t' [10.00 GiB] inherit
ACTIVE Snapshot '/dev/vg/backup-v1017-0-xlg20' [25.00 GiB] inherit
[root@ok1140 ~]#
[root@ok1140 ~]#

Roundcube from Mysql to Sqlite 

As new cPanel versions come with Sqlite

While migrating from old server which has Mysql format to new Sqlite server

You need to convert to sqlite to preserve data and migrate without issues

Below is the command used on old server to convert Mysql ro sqlite for roundcube

/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite

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

Have been getting below error on one of the Centos 5 VM

where yum is not working and giving below error

yum update kernel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
YumRepo 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.txt
Error: Cannot find a valid baseurl for repo: base

uname -a
Linux vps.spring.com 2.6.32-042stab120.11 #1 SMP Wed Nov 16 12:05:45 MSK 2016 i686 i686 i386 GNU/Linux


root@vps [/]# cat /etc/redhat-release
CentOS release 5.11 (Final)

go to

cd /etc/yum.repos.d/

mv CentOS-Base.repo CentOS-Base.repo=bkp

vi CentOS-Base.repo

add below entries

[base]
name=CentOS-$releasever - Base
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
baseurl=http://vault.centos.org/5.11/os/$basearch
gpgcheck=1
gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-CentOS-5
exclude=redhat-logos

yum clean all

yum update

This has resolved the issue associated with yum on Centos 5

Error restoring a particular database

[root@OK1053 mysql]# mysql uulimain_testagain < /home/uulimain/public_html/uulimain_testagain.sql
ERROR 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.

Activating lvgroup

lvscan
inactive ‘/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]# lvscan
ACTIVE ‘/dev/vg1/vsv1001-d8pixocsw0jjt67p-28scn37pgayace8e’ [801.00 GiB] inherit

FFMPEG and PHPFFMPEG installlation on Centos 7

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