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

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

[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.

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

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

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

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]#

“

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

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.

We had an issue where in cPanel server where we had our rDNS settings

were no working. On editing and saving the file from WHM , Rdns worked

Found the issue was due to corrupted named.conf

Below are the steps undertaken to rebuild named.conf

mv /etc/named.conf /etc/named.conf.bak

/usr/local/cpanel/scripts/rebuilddnsconfig

/scripts/restartsrv_named

Now rdns and other records are working fine:)