How to Convert InnoDB to innodb_file_per_table and Shrink ibdata1

  Years ago, MySQL started allowing InnoDB to possess separate tablespace per table instead of a massive unified ibdata1 file.  Tablespace is basically a logical storage area that contains table information – references, if you will.  Every table, regardless of the storage engine, has one, and without it the table will be unrecognizable to MySQL.  MyISAM…

Read more

Correcting Perl Scalar::List::Util Errors on CentOS 5

  We started getting some reports from users on CentOS 5 trying to run EasyApache and being unable to due to the following error: Undefined subroutine &Scalar::Util::readonly called at /usr/lib/perl5/site_perl/5.8.8/IO/Uncompress/Base.pm line 1104. We found that this is due to an outdated Scalar::Util module that was unable to be loaded properly by system Perl.  To fix this,…

Read more

cPanel Configuration Clusters and Security Considerations

  cPanel 11.44 introduces a new feature fresh from their feature request system that now allows server administrators to deploy the configuration of one server to multiple servers in what the they call a “configuration cluster”.  It will start by offering this capability to just the cPanel update preferences, but will eventually be expanded to work…

Read more

OpenSSL Heartbleed Bug and What You Need to Know

  Over the past few days, we have received an overwhelming number of questions about the OpenSSL Heartbleed bug and how cPanel system administrators should be handling this. First of all, if you haven’t read Codenomicon’s write-up on the bug, which thoroughly explains what it is, you should look visit heartbleed.com. Because their website already…

Read more

Fix for “Missing owner for domain X, force lookup to root”

  On recent cPanel versions, rebuilding the Apache conf returns the following non-fatal error: root@savannah [~]# /scripts/rebuildhttpdconf info [rebuildhttpdconf] Missing owner for domain savannah.tcaserversolutions.com, force lookup to root Built /usr/local/apache/conf/httpd.conf OK   The error does not adversely effect the way the httpd.conf file is built, but the presence of the unnecessary info message can be…

Read more

Implementing Mandrill with Exim on cPanel

  Mandrill is a transactional email service run by MailChimp, comparable to SendGrid.  It comes stock with a powerful API for fast implementation into applications for sending email reliably over SMTP, but it can also be used as a smart host for all of your server’s outgoing email. The below instructions cover how to do…

Read more

Unable to Change Shell via WHM or CLI

  When trying to change a user’s shell via WHM, you may occasionally see the following error: Shell could not be modified As shown below: Attempting to change the shell via command line fails as well: # chsh -s /bin/bash myuser Changing shell for myuser. setpwnam: File exists Shell *NOT* changed.  Try again later. This means there is…

Read more

cPanel 11.42 Cheat Sheet

  In 2010, we released our first cPanel cheat sheet for version 11.25.  Admittedly, we haven’t been keeping up with the times.  A lot has changed with cPanel over the last few years and an update is well overdue. Though labeled for version 11.42, the new cheat sheet is verified to be accurate for the…

Read more

How to FSCK a Linux Filesystem

  There comes a time in every sysadmin’s life where filesystem errors just…happen.  Luckily, these are somewhat easy to fix, assuming you don’t have a greater problem involving physical hardware damage. First, you need to know the name of the disk device having the problem.  Do a quick df to see what device the affected…

Read more

Log in