cPanel - OnlineSupport4u

cPanel

Maildelivery Report blank cPanel/WHM

By Prasad Naik

August 20, 2015

Maildevery Report sometimes does not seem to work in WHM . The issue is due to corruption in exims stats database and tables in it Below is the fix for same #Login to Mysql as root root@host [/var/lib/mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is […]

cPanel

Can’t create new tempfile Mysql

By Prasad Naik

August 14, 2015

While working today came across new error in Mysql ” [myfuncol_student.ow_base_config] error: Can't create new tempfile: './myfuncol_student/ow_base_config.TMD Repairing the Mysql didn’t fix this issue mysql> repair table ow_base_config; +———————————+——–+———-+——————————————————————–+ | Table | Op | Msg_type | Msg_text | +———————————+——–+———-+——————————————————————–+ | myfuncol_student.ow_base_config | repair | error | Can’t create new tempfile: ‘./myfuncol_student/ow_base_config.TMD’ | | myfuncol_student.ow_base_config | […]

cPanel

Blank PHPmyadmin page in cpanel

By Prasad Naik

August 11, 2015

While working with one hosting client we came across an issue where PHPmyadmin was blank On checking logs on /usr/local/cpanel/logs/error_log we could see below error root@hosonline [~]# tail -n 10 /usr/local/cpanel/logs/error_log Cpanel::Server::write_buffer(Cpanel::Server=HASH(0x4abf5d8), “HTTP/1.1 401 Access Denied\x{d}\x{a}Set-Cookie: cprelogin=no; HttpOnl”…) called at /usr/local/cpanel/Cpanel/Server.pm line 1132 Cpanel::Server::write_content_to_socket(Cpanel::Server=HASH(0x4abf5d8), IO::Socket::SSL=GLOB(0x4a9c208), 0, “HTTP/1.1 401 Access Denied\x{d}\x{a}Set-Cookie: cprelogin=no; HttpOnl”…, SCALAR(0x20f8ae8)) called at […]

cPanel

wkhtmltopdf install

By Prasad Naik

July 20, 2015

if you are facing issues with install of wkhtmltopdf please follow below steps Download the zip file using wget root@hostonlinesupport4u.in[/home/online/public_html/onlinesupport4u.in/cgi-bin]# wget http://wkhtmltopdf.googlecode.com/files/wkhtmltopdf-0.9.9-static-amd64.tar.bz2 –2015-07-20 03:15:00– http://wkhtmltopdf.googlecode.com/files/wkhtmltopdf-0.9.9-static-amd64.tar.bz2 Resolving wkhtmltopdf.googlecode.com… 64.233.168.82, 2607:f8b0:4003:c07::52 Connecting to wkhtmltopdf.googlecode.com|64.233.168.82|:80… connected. HTTP request sent, awaiting response… 200 OK Length: 8218260 (7.8M) [application/x-bzip2] Saving to: `wkhtmltopdf-0.9.9-static-amd64.tar.bz2′ 100%[====================================================================================================================================================================================================>] 82,18,260 15.3M/s in 0.5s 2015-07-20 03:15:00 (15.3 […]

cPanel

FTP issue Error: Failed to retrieve directory listing

By Prasad Naik

July 15, 2015

Getting error while doing ftp in cpanel server “Failed to retrieve directory listing” Status: Connecting to 199.162.171.19:21… Status: Connection established, waiting for welcome message… Status: Initializing TLS… Status: Verifying certificate… Status: TLS connection established. Status: Server does not support non-ASCII characters. Status: Connected Status: Retrieving directory listing… Command: PWD Response: 257 “/” is the […]

cPanel

Install ZendGuard on cPanel server

By Prasad Naik

July 13, 2015

To install ZendGuard on cpanel server follow below steps SSH to server as root user and run below script root@online [~]# /scripts/installzendopt Updating digest list Fetching http://httpupdate.cpanel.net/cpanelsync/easy/targz.yaml (connected:0)…….(request attempt 1/12)…Using dns cache file /root/.HttpRequest/httpupdate.cpanel.net……searching for mirrors (mirror search attempt 1/3)……loaded mirror speeds from cache……mirror search success……connecting to 67.222.0.10…@67.222.0.10……connected……receiving…100%……request success……Done Downloading tarball for Zendopt Fetching http://httpupdate.cpanel.net/cpanelsync/easy/targz/Cpanel/Easy/Zendopt.pm.tar.gz.linux-generic-64 […]

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 […]

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 […]

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

cPanel

Mod_Security disable

By Prasad Naik

April 12, 2014

If you want to disable security for one singled domain name you can do it by editing virtualhost in httpd.conf You can add the below setting in apache’s virtualhost for the domain name You need to add below rule to disable mod_security <IfModule mod_security2.c> SecRuleEngine off </IfModule>