Category Archives: Mysql

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

error while loading shared libraries: libasound.so.2: cannot open shared object file: No such file or directory

I was gettnig error mentioned below

“error while loading shared libraries: libasound.so.2:” on Centos 7 OS

yum -y install alsa-lib-devel fixed the issue

yum -y install alsa-lib-devel
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: www.gtlib.gatech.edu
  • epel: mirror.oss.ou.edu
  • extras: mirror.dal10.us.leaseweb.net
  • nux-dextop: mirror.li.nux.ro
  • updates: mirror.dal10.us.leaseweb.net
    Resolving Dependencies
    –> Running transaction check
    —> Package alsa-lib-devel.x86_64 0:1.1.8-1.el7 will be installed
    –> Processing Dependency: alsa-lib = 1.1.8-1.el7 for package: alsa-lib-devel-1.1.8-1.el7.x86_64
    –> Processing Dependency: libasound.so.2()(64bit) for package: alsa-lib-devel-1.1.8-1.el7.x86_64
    –> Running transaction check
    —> Package alsa-lib.x86_64 0:1.1.8-1.el7 will be installed
    –> Finished Dependency Resolution

Dependencies Resolved

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

Package Arch Version Repository Size

Installing:
alsa-lib-devel x86_64 1.1.8-1.el7 base 963 k
Installing for dependencies:
alsa-lib x86_64 1.1.8-1.el7 base 425 k

Transaction Summary

Install 1 Package (+1 Dependent package)

Total download size: 1.4 M
Installed size: 15 M
Downloading packages:
(1/2): alsa-lib-1.1.8-1.el7.x86_64.rpm | 425 kB 00:00:00

(2/2): alsa-lib-devel-1.1.8-1.el7.x86_64.rpm | 963 kB 00:00:00

Total 3.5 MB/s | 1.4 MB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : alsa-lib-1.1.8-1.el7.x86_64 1/2
Installing : alsa-lib-devel-1.1.8-1.el7.x86_64 2/2
Verifying : alsa-lib-1.1.8-1.el7.x86_64 1/2
Verifying : alsa-lib-devel-1.1.8-1.el7.x86_64 2/2

Installed:
alsa-lib-devel.x86_64 0:1.1.8-1.el7

Dependency Installed:
alsa-lib.x86_64 0:1.1.8-1.el7

Complete!
[root@ok1061 yum.repos.d]#
[root@ok1061 yum.repos.d]#
[root@ok1061 yum.repos.d]# ffmpeg -version
ffmpeg version 2.8.15 Copyright (c) 2000-2018 the FFmpeg developers
built with gcc 4.8.5 (GCC) 20150623 (Red Hat 4.8.5-36)
configuration: –prefix=/usr –bindir=/usr/bin –datadir=/usr/share/ffmpeg –incdir=/usr/include/ffmpeg –libdir=/usr/lib64 –mandir=/usr/share/man –arch=x86_64 –optflags=’-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong –param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic’ –extra-ldflags=’-Wl,-z,relro ‘ –enable-libopencore-amrnb –enable-libopencore-amrwb –enable-libvo-amrwbenc –enable-version3 –enable-bzlib –disable-crystalhd –enable-gnutls –enable-ladspa –enable-libass –enable-libcdio –enable-libdc1394 –enable-libfdk-aac –enable-nonfree –disable-indev=jack –enable-libfreetype –enable-libgsm –enable-libmp3lame –enable-openal –enable-libopenjpeg –enable-libopus –enable-libpulse –enable-libschroedinger –enable-libsoxr –enable-libspeex –enable-libtheora –enable-libvorbis –enable-libv4l2 –enable-libx264 –enable-libx265 –enable-libxvid –enable-x11grab –enable-avfilter –enable-avresample –enable-postproc –enable-pthreads –disable-static –enable-shared –enable-gpl –disable-debug –disable-stripping –shlibdir=/usr/lib64 –enable-runtime-cpudetect
libavutil 54. 31.100 / 54. 31.100
libavcodec 56. 60.100 / 56. 60.100
libavformat 56. 40.101 / 56. 40.101
libavdevice 56. 4.100 / 56. 4.100
libavfilter 5. 40.101 / 5. 40.101
libavresample 2. 1. 0 / 2. 1. 0
libswscale 3. 1.101 / 3. 1.101
libswresample 1. 2.101 / 1. 2.101
libpostproc 53. 3.100 / 53. 3.100
[root@ok1061 yum.repos.d]#

Debian7 404 error

Was working on Debian 7 server and on trying to update using command apt-get update was getting 404 error

I could see 404 error on command apt-get update

root@debian:/home/nvc# vi /etc/resolv.conf
root@debian:/home/nvc# apt-get update
Ign cdrom://[Debian GNU/Linux 7.11.0 Wheezy – Official amd64 DVD Binary-1 20160605-17:36] wheezy Release.gpg
Ign cdrom://[Debian GNU/Linux 7.11.0 Wheezy – Official amd64 DVD Binary-1 20160605-17:36] wheezy Release
Ign cdrom://[Debian GNU/Linux 7.11.0 Wheezy – Official amd64 DVD Binary-1 20160605-17:36] wheezy/contrib amd64 Packages/DiffIndex
Ign cdrom://[Debian GNU/Linux 7.11.0 Wheezy – Official amd64 DVD Binary-1 20160605-17:36] wheezy/main amd64 Packages/DiffIndex
Ign cdrom://[Debian GNU/Linux 7.11.0 Wheezy – Official amd64 DVD Binary-1 20160605-17:36] wheezy/contrib Translation-en_US
Ign cdrom://[Debian GNU/Linux 7.11.0 Wheezy – Official amd64 DVD Binary-1 20160605-17:36] wheezy/main Translation-en_US
Ign http://security.debian.org wheezy/updates Release.gpg
Ign http://security.debian.org wheezy/updates Release
Err http://security.debian.org wheezy/updates/main Sources
404 Not Found [IP: 151.101.128.204 80]
Err http://security.debian.org wheezy/updates/contrib Sources
404 Not Found [IP: 151.101.128.204 80]
Err http://security.debian.org wheezy/updates/main amd64 Packages
404 Not Found [IP: 151.101.128.204 80]
Err http://security.debian.org wheezy/updates/contrib amd64 Packages
404 Not Found [IP: 151.101.128.204 80]
Ign http://security.debian.org wheezy/updates/contrib Translation-en_US
Ign http://security.debian.org wheezy/updates/contrib Translation-en
Ign http://security.debian.org wheezy/updates/main Translation-en_US
Ign http://security.debian.org wheezy/updates/main Translation-en
W: Failed to fetch http://security.debian.org/dists/wheezy/updates/main/source/Sources 404 Not Found [IP: 151.101.128.204 80]

W: Failed to fetch http://security.debian.org/dists/wheezy/updates/contrib/source/Sources 404 Not Found [IP: 151.101.128.204 80]

W: Failed to fetch http://security.debian.org/dists/wheezy/updates/main/binary-amd64/Packages 404 Not Found [IP: 151.101.128.204 80]

W: Failed to fetch http://security.debian.org/dists/wheezy/updates/contrib/binary-amd64/Packages 404 Not Found [IP: 151.101.128.204 80]

E: Some index files failed to download. They have been ignored, or old ones used instead.

The solution to this problem was to be clear

/etc/apt/sources.list and add below entries

cat /etc/apt/sources.list
deb http://archive.debian.org/debian wheezy main
deb http://archive.debian.org/debian-security wheezy/updates main

now apt-get working fine

apt-get install vim
Reading package lists… Done
Building dependency tree
Reading state information… Done
The following extra packages will be installed:
vim-common vim-runtime vim-tiny
Suggested packages:
ctags vim-doc vim-scripts indent
The following NEW packages will be installed:
vim vim-runtime
The following packages will be upgraded:
vim-common vim-tiny
2 upgraded, 2 newly installed, 0 to remove and 122 not upgraded.
Need to get 5,945 kB of archives.
After this operation, 24.8 MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Get:1 http://archive.debian.org/debian-security/ wheezy/updates/main vim-tiny amd64 2:7.3.547-7+deb7u4 [355 kB]
Get:2 http://archive.debian.org/debian-security/ wheezy/updates/main vim-common amd64 2:7.3.547-7+deb7u4 [163 kB]
Get:3 http://archive.debian.org/debian-security/ wheezy/updates/main vim-runtime all 2:7.3.547-7+deb7u4 [4,586 kB]
Get:4 http://archive.debian.org/debian-security/ wheezy/updates/main vim amd64 2:7.3.547-7+deb7u4 [842 kB]
Fetched 5,945 kB in 0s (9,099 kB/s)
Reading changelogs… Done
(Reading database … 31607 files and directories currently installed.)
Preparing to replace vim-tiny 2:7.3.547-7 (using …/vim-tiny_2%3a7.3.547-7+deb7u4_amd64.deb) …
Unpacking replacement vim-tiny …
Preparing to replace vim-common 2:7.3.547-7 (using …/vim-common_2%3a7.3.547-7+deb7u4_amd64.deb) …
Unpacking replacement vim-common …
Selecting previously unselected package vim-runtime.
Unpacking vim-runtime (from …/vim-runtime_2%3a7.3.547-7+deb7u4_all.deb) …
Adding ‘diversion of /usr/share/vim/vim73/doc/help.txt to /usr/share/vim/vim73/doc/help.txt.vim-tiny by vim-runtime’
Adding ‘diversion of /usr/share/vim/vim73/doc/tags to /usr/share/vim/vim73/doc/tags.vim-tiny by vim-runtime’
Selecting previously unselected package vim.
Unpacking vim (from …/vim_2%3a7.3.547-7+deb7u4_amd64.deb) …
Processing triggers for man-db …
Processing triggers for mime-support …
Setting up vim-common (2:7.3.547-7+deb7u4) …
Setting up vim-tiny (2:7.3.547-7+deb7u4) …
Setting up vim-runtime (2:7.3.547-7+deb7u4) …
Processing /usr/share/vim/addons/doc
Setting up vim (2:7.3.547-7+deb7u4) …
update-alternatives: using /usr/bin/vim.basic to provide /usr/bin/vim (vim) in auto mode
update-alternatives: using /usr/bin/vim.basic to provide /usr/bin/vimdiff (vimdiff) in auto mode
update-alternatives: using /usr/bin/vim.basic to provide /usr/bin/rvim (rvim) in auto mode
update-alternatives: using /usr/bin/vim.basic to provide /usr/bin/rview (rview) in auto mode
update-alternatives: using /usr/bin/vim.basic to provide /usr/bin/vi (vi) in auto mode
update-alternatives: using /usr/bin/vim.basic to provide /usr/bin/view (view) in auto mode
update-alternatives: using /usr/bin/vim.basic to provide /usr/bin/ex (ex) in auto mode

CGI download issue

Enable CGI through .htaccess

To enable CGI through .htaccess, perform the following steps:

  1. Log in to your server as the root user via SSH.
  2. Change to the /usr/local/apache/conf/ directory.
  3. Create a backup of your httpd.conf file. For example:

Note: In this example, http-old.conf represents the backup file’s name.

4. Open your http.conf file with a text editor and locate the section of the file that resembles the following example:

1 2 3 4<Directory "/"> Options +ExecCGI +FollowSymLinks +Includes +IncludesNOEXEC +Indexes -MultiViews +SymLinksIfOwnerMatch AllowOverride None </Directory>

  1. Change the AllowOverride line’s value from None to All.

Your server now allows CGI scripts to run in all directories.