Error from MySQL query: DBD::mysql::db do failed: Can’t find any matching row in the user table

cPanel

Error from MySQL query: DBD::mysql::db do failed: Can’t find any matching row in the user table

By Prasad Naik

June 21, 2015

Have you been getting below error “Error from MySQL query: DBD::mysql::db do failed: Can’t find any matching row in the user table” To fix this issue follow below method, Please remove the following entry from /etc/my.cnf and then restart MySQL: skip-name-resolve The restart mysql using /scripts/restartsrv_mysql This fixes the issue

cPanel

upcp cpanel error

By Prasad Naik

June 20, 2015

While running a upcp –force in cPanel server got below error [2015-06-20 13:48:48 -0400] see http://go.cpanel.net/rpmcheckfailed for more information [2015-06-20 13:48:48 -0400] The Administrator will be notified to review this output when this script completes => Log closed Sat Jun 20 13:48:48 2015 [2015-06-20 13:49:13 -0400] 17% complete [2015-06-20 13:49:13 -0400] E Running `/usr/local/cpanel/scripts/updatenow –upcp […]

Linux

kernel panic not syncing attempt to kill init

By Prasad Naik

April 2, 2015

Creating a New Initial RAM Disk If you have changed a motherboard or moved a disk to a different system it may fail to boot due to the lack of appropriate drivers in the initial RAM disk image (initramfs for CentOS 6, initrd for CentOS 5). Boot in Rescue Mode 1.Boot from a CentOS installation […]

cPanel

SVNManager error in Softaculous

By Prasad Naik

March 22, 2015

SVNManager in Softaculous give erros while installing Came across this in a support request The following errors were found : – The SVN config directory does not exist. – The SVN password file does not exist. – The SVN access file does not exist.The solution is before installing svnmanager run: su – username svnadmin create […]

Mysql

VM creation has failed. Reason: No ploop support in the kernel, or kernel is way too old. Make sure you have OpenVZ kernel 042stab058.7 or later running, and kernel ploop modules loaded.

By Prasad Naik

March 17, 2015

VM creation has failed. Reason: No ploop support in the kernel, or kernel is way too old. Make sure you have OpenVZ kernel 042stab058.7 or later running, and kernel ploop modules loaded. Creation of container private area failed SOlusi : cek file berikut : It seems you are using EL5 kernel. Edit /etc/vz/vz.conf change: VE_LAYOUT=ploop […]

Mysql

email trace in cpanel shows invalid date

By Prasad Naik

March 17, 2015

We tried to repair the smtp table in the eximstats database and it showed the following result. myisamchk: error: ‘/var/lib/mysql/eximstats/smtp.MYI’ is not a MyISAM-table Fix: ls -al /usr/local/cpanel/etc/eximstats_db.sql mysqladmin drop eximstats mysqladmin create eximstats mysql eximstats < /usr/local/cpanel/etc/eximstats_db.sql

Mysql

make: *** [ffmpeg_frame.lo] Error 1 ffmpeg

By Prasad Naik

March 17, 2015

This error occurs due to a missing file ‘ffmpeg_frame.lo‘ in the ffmpeg-php source, while your ffmpeg-php source may contain the file named ‘ffmpeg_frame.loT‘. – To Resolve this issue you just need to rename the ‘ffmpeg_frame.loT‘ to ‘ffmpeg_frame.lo‘ and make again

Mysql

Setup Smartd monitoring on Linux

By Prasad Naik

March 17, 2015

Want to get an alert when hard drive in server is going bad A tool called SMARTD is available in lInux which is free You need to use below steps to install and configure it #yum install smartmontools #service smartd start #chkconfig smartd on #smartctl -a /dev/sda Now Open smartd config file and […]

Mysql

Invalid date in Email Trace cpanel

By Prasad Naik

March 17, 2015

When checking the email trace option in cpanel, it reported an invalid date error. We got the following log from our cpanel error log file about what is causing the issue. What do I do when cpanel email trace not working, how can I fix it look no further we have the problem solved for […]

cPanel

rejected by non-SMTP ACL: failed to expand ACL string Exim

By Prasad Naik

March 17, 2015

If you have been getting error in exim while sending emails “rejected by non-SMTP ACL: failed to expand ACL string” Use the below fix where you need to rebuild exim config and also cop root@shared [/]# /scripts/buildeximconf Configuration file passes test! New configuration file was installed. warn [buildeximconf] Could not find /etc/exim.pl warn [buildeximconf] Could […]

cPanel

Check if Hard drive is SATA or SSD

By Prasad Naik

September 10, 2014

[root@host.onlinesupport4u.in ~]# cat /sys/block/sda/queue/rotational Result is 0 if the drive is SSD [root@host.onlinesupport4u.in ~]# cat /sys/block/sda/queue/rotational Result is 1 if drive is SATA

Mysql

cPanel :: upcp failed, exited with code 25

By Prasad Naik

September 4, 2014

I noticed below error while updating cPanel to latest one of the server: Running `/usr/local/cpanel/scripts/updatenow --upcp --log=/var/cpanel/updatelogs/update.9320814564.log` failed, exited with code 25 (signal = 0) Below was the OS installed on the server : root@onlinesupport[~]# cat /etc/redhat-release CentOS release 6.5 (Final) root@onlinesupport [~]# Further found that the cPanel config had the OS information missing as […]