cPanel Fantastico Install Error : Solved (Warning: mysql_connect() [function.mysql-connect]: Access denied for user @'localhost' (using password: YES) in /tmp/cpanel_phpengine)

I encountered with this error while trying to install Drupal via fantastico in cPanel. This error replicates for wordpress or any other 3rd party application which you try to install via fantastico.

The reason for this error is the password mismatch of cpanel and mysql. To fix this error login to cPanel and take change password under Preferences and change your password to a new one. Make sure that you check the box "Allow MySQL password change" as shown below:

Now retry the installation and this will work. :)

Read more »

djbdns (TinyDns) not starting in Kloxo (Solved / fixed)

After switching from named to tinyDNS in kloxo. The djbdns is not working.
# /etc/init.d/djbdns restart
Stopping Djbdns:
Starting Djbdns:
# /etc/init.d/djbdns status
tinydns is stopped
Also tried to stop and start but still no luck.
 #service djbdns stop
Stopping Djbdns:
# service djbdns start
Starting Djbdns:
service djbdns status
tinydns is stopped

Check if the ip is entered correctly in the following file.
# echo "xxx.xxx.x.xx" >> /var/tinydns/env/IP; chattr +i /var/tinydns/env/IP
# cat /var/tinydns/env/IP
  xxx.xxx.x.xx

Also check if the path is correct in the files /usr/local/lxlabs/kloxo/file/djbdns.init and /etc/init.d/djbdns. Open each file and check the line
Qmailtcp=/usr/local/bin/tcpserver
In my case the location of tcpserver was /usr/bin/tcpserver. Hence i changed this to
Qmailtcp=/usr/bin/tcpserver
Note: Change this is both files.

Now login to kloxo and take Administration --> Servers --> localhost --> Services. Everything should be in green. :)

Read more »

Awstat not Updating in cPanel and Combined error Log

Yesterday I found a strange issue with awstat as it suddenly stopped reporting the data. I could get the past data but not able to get the current data. As usual as a part of debugging i opened the errorlogs and domlogs. I found something strange in the domlogs.  The word "combined" was repeating in the logs:

 # vi /usr/local/apache/domlogs/
combined
combined
combined
combined
combined
combined
combined
combined


After hours of searching and testing i found the solution. I am sharing it below:


Open the apache conf with your favorite editor.
#vi /usr/local/apache/conf/httpd.conf
Search for the line
--------
ErrorLog /usr/local/apache/logs/error_log
--------
Beneth that line add the following:
--------
LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%{Referer}i -> %U" referer
LogFormat "%h %l %u %t \"%r\" %>s %b" common
LogFormat "%{User-agent}i" agent
--------
Save and exit, then run:
--------
/usr/local/cpanel/bin/apache_conf_distiller --update
/usr/local/cpanel/bin/build_apache_conf
restart apache
/scripts/restartsrv_httpd
--------
Awstat started updating itself at last. :)

Read more »

Traffic Summary in Plesk

There are several types of control panels, and each of them offers something unique to the user. cPanel and Plesk are two popular choices.
Plesk was released in 2003. The company is originally a product of SWsoft (after SWsoft acquired Plesk Inc.) but it’s now shipped under Parallels Inc.
Plesk can be used for Windows as well as Linux which is missing in cpanel :)
In my opinion, Plesk control panel is in the top 3 of control panels that are available to dedicated web hosting users.

Open Plesk in browser and navigate to this window.
Plesk > Home > Logs & Statistics > summary report > view traffic history

Read more »

cPanel Log File Locations

This is a shortlist of various log files for various applications on your Cpanel server. I have listed the application / service name and the location of the log files associated with it.

cPanel Installation Logs:
/var/log/cpanel-install-thread0.log
Apache:
/usr/local/apache/logs/access_log
/usr/local/apache/logs/error_log
Apache domlogs:
/usr/local/apache/domlogs/example.com
Apache SUEXEC Logs:
/usr/local/apache/logs/suexec_log
MySQL
/var/lib/mysql/hostname.err
BIND (named) Log:
/var/log/messages
Exim
/var/log/exim_mainlog
/var/log/exim_paniclog
/var/log/exim_rejectlog
Courier or Dovecot IMAP
/var/log/maillog
Tomcat Logs:
/usr/local/jakarta/tomcat/logs/catalina.err
/usr/local/jakarta/tomcat/logs/catalina.out
cPanel Access Log:
/usr/local/cpanel/logs/access_log
cPanel Error Log:
/usr/local/cpanel/logs/error_log
cPanel License Log:
/usr/local/cpanel/logs/license_log
Stats Execution Logs:
/usr/local/cpanel/logs/stats_log
ChkServd (cPanel Monitoring Daemon) Logs:
/var/log/chkservd.log
cPHulkd
/usr/local/cpanel/logs/cphulkd.log
cPanel Backup Logs:
/usr/local/cpanel/logs/cpbackup/*.log
Pure-FTP
/var/log/messages
/var/log/xferlog (symlinked to /usr/local/apache/domlogs/ftpxferlog)
Cron Logs:
/var/log/cron
SSH Logs:
/var/log/secure
ModSecurity:
/usr/local/apache/logs/modsec_audit.log
/usr/local/apache/logs/modsec_debug_log

Read more »

Install the SSL Server Certificate

Install the SSL Server Certificate Files
--------------------------------------------------
Login to cPanel
Click SSL/TLS Manager > Certificates (CRT) > Generate, view, upload or delete SSL certificates
In the Upload a New Certificate section click the Browse button and locate your SSL Server Certificate file your_domain_com.txt.
Click the Upload button.
Click the Go Back link to return to SSL/TLS Manger.

Setup the Domain
-------------------------
Click SSL/TLS Manager > Setup a SSL certificate to work with your site. If this option is not available to you your ISP may have disabled it and you will need to contact them to complete your SSL setup.
From the Domain drop down menu select the domain that will use the SSL Certificate. The system will attempt to Fetch the SSL Certificate and corresponding private key.
Open GeoTrust_Intermediate.txt in Notepad or other simple text editor (not Word). Copy-and-paste all the contents of the GeoTrust_Intermediate.txt file into the Ca Bundle (CABUNDLE) box.
Click on Install Certificate. You should receive a message that the certificate was successfully installed. If you receive an error you may need to contact your web hosting provider for additional support.

Verify Installation:
-----------------------

New To verify if your certificate is installed correctly, use our Certificate Installation Checker.

Test your SSL certificate by using a browser to connect to your server. Use the https protocol directive. For example, if your SSL was issued to secure.mysite.com, enter https://secure.mysite.com into your browser.

Your browser's padlock icon Browser padlock will be displayed in the locked position if your certificate is installed correctly and the server is properly configured for SSL.

Read more »