Category Archives: Mysql

email trace in cpanel shows invalid date

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

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

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

Setup Smartd monitoring on Linux

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 add the entry as mentioned
vi /etc/smartd.conf

DEVICESCAN -a -o on -S on -n standby,q -s (S/../.././02|L/../../6/03) -W 4,35,40 -m  emaild

Now you should get an alert for any error if any from SMARTD

Invalid date in Email Trace cpanel

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

Once you have logged in as ROOT you can now copy and paste this line in

mysql eximstats < /usr/local/cpanel/etc/eximstats_db.sql

now close out putty and the the email trace feature will be up and running.

cPanel :: upcp failed, exited with code 25

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 below :

root@linuxbabu [~]# cat /var/cpanel/sysinfo.config
# This values in this file are calculated and updated if necessary nightly. If you wish to override
# these values, populate lock= with a comma delimited list of keys you don't want updated.
# This will allow you to change those values to suit your needs.
#
# Example: if you set lock like this, then rpm_dist and rpm_arch will not be updated nightly:
# lock=rpm_dist,rpm_arch
#
ises=2
lock=
release=6.5
rpm_arch=x86_64
rpm_dist=centos
rpm_dist_ver=unknown
root@linuxbabu [~]#

I corrected the OS rpm_dist_ver under the config file and the upcp worked fine :

root@onlinesupport [~]# cat /var/cpanel/sysinfo.config | grep rpm_dist_ver
rpm_dist_ver=6
root@onlinesupport [~]#

Cpanel Error “EasyApache is currently upgrading your Apache and PHP installation.”

Configure PHP and suEXEC
EasyApache is currently upgrading your Apache and PHP installation.
Please wait for this process to finish before changing your PHP and Suexec settings.

root@as [~]# cd /usr/local/apache
root@as [/usr/local/apache]# ls
./                                        cgi-bin/       etc@      logs/
../                                       conf/          htdocs/   man/
AN_EASYAPACHE_BUILD_IS_CURRENTLY_RUNNING  conf_pre_ea3/  icons/    manual/
bin/                                      domlogs/       include/  modules/
build/                                    error/         lib/

root@as [/usr/local/apache]# rm AN_EASYAPACHE_BUILD_IS_CURRENTLY_RUNNING
rm: remove regular empty file `AN_EASYAPACHE_BUILD_IS_CURRENTLY_RUNNING'? y
root@as [/usr/local/apache]#

Too many open files: could not open transfer log file

This is an error which is usually thrown by the server when there is a failure to start apache. The above description can be found in the error logs of the server.

Solutions:

Step 1: Open file /etc/init.d/httpd OR /usr/sbin/apachectl

Step 2: Add `ulimit -n 65536`

{The error usually occurs due to the lower number of file descriptors.}

To check the limit of file descriptors over the server described within the file /proc/sys/fs/file-max, run the following command:

# cat /proc/sys/fs/file-max
1024

If the value found in fs.file-max small, you must increase it by running the following command:

# echo “65535 > /proc/sys/fs/file-max

To save these settings for future reboots to keep the values, you may add it to the file /etc/sysctl.conf.

# Maximum number of open files permitted
fs.file-max = 65535

To load new values from the sysctl.conf file, run:

# sysctl -p /etc/sysctl.conf

Now you must restart httpd service by running the following command:

/etc/init.d/httpd restart

Hypervm License error

Are you getting license error on Hypervm

Below are the steps to fix this issue

#remove the below file

rm -f  /usr/local/lxlabs/hypervm/httpdocs/htmllib/phplib/lib/licenselib.php

download below file

wget www.profivps.hu/installapps/licenselib.php_

rename the above file

mv  /usr/local/lxlabs/hypervm/httpdocs/htmllib/phplib/lib/licenselib.php_                                              /usr/local/lxlabs/hypervm/httpdocs/htmllib/phplib/lib/licenselib.php

Now License issue should be resolved