• Mysql

Roundcube from Mysql to Sqlite

By PrasadNaik

September 22, 2020

• Mysql

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

By PrasadNaik

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 PrasadNaik

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 PrasadNaik

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 PrasadNaik

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 PrasadNaik

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

• Mysql

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

By PrasadNaik

June 22, 2020

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-develLoaded 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: 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.netResolving Dependencies–> Running transaction check—> […]

• Mysql

Debian7 404 error

By PrasadNaik

June 19, 2020

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.confroot@debian:/home/nvc# apt-get updateIgn cdrom://[Debian GNU/Linux 7.11.0 Wheezy – Official amd64 DVD Binary-1 20160605-17:36] wheezy Release.gpgIgn cdrom://[Debian GNU/Linux 7.11.0 Wheezy – Official amd64 DVD Binary-1 20160605-17:36] […]

• Mysql

CGI download issue

By PrasadNaik

June 16, 2020

Enable CGI through .htaccess To enable CGI through .htaccess, perform the following steps: Log in to your server as the root user via SSH. Change to the /usr/local/apache/conf/ directory. 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 […]