PostgreSQL is an open-source database server similar (but different) than MySQL. cPanel has a built-in installer for setting up PostgreSQL easily. Keep in mind that the actual version of PostgreSQL you get depends on your OS version. For instance, CentOS 4 users will likely get version 7, CentOS 5 will get version 8. First, run…
Read moreLately FTP has been a problem for a lot of hosting providers. Especially since the recent influx of Gumblar-related attacks and FTP exploits, some hosting providers are now considering changing their FTP ports as an added measure of security. If you’re on a cPanel server you have a couple extra steps to go through, but…
Read moreI’ve seen several features of cPanel appear to malfunction, and upon reviewing /usr/local/cpanel/logs/error_log, I’d see something similar to this: Out of memory during request for 2180 bytes, total sbrk() is 130234368 bytes! Common places this has been known to occur: In Webmail (Horde and Roundcube) when opening large attachments Using cPanel’s perl module installer You…
Read moreI've experienced from time to time a problem with webmail functioning after cPanel updates, particularly on larger servers. You can reinstall all three webmail applications, while not disrupting user content, with the following commands: Roundcube: /usr/local/cp The WordPress Classroom anel/bin/update-roundcube –force Horde: /usr/local/cpanel/bin/update-horde –force or /scripts/fullhordereset Squirrelmail /usr/local/cpanel/bin/update-squirrelmail –force zp8497586rq…
Read moreCpanel confirmed via email and on their site that SpamAssassin has a bug: “The Quality Assurance team discovered a bug within the SpamAssassin ruleset that will mark messages sent in the year 2010 (that's today) and beyond with a higher spam score than expected. This bug can result in legitimate Girlfriend In A Week mail…
Read moreNote: It is preferred to use mod_wsgi instead of mod_python. If you want to use mod_python in Apache on a cPanel server, you’ll basically need to compile the module manually and load it into the Apache configuration: yum -y install subversion (IF it’s not already installed) svn co https://svn.apache.org/repos/asf/quetzalcoatl/mod_python/trunk mod_python cd mod_python ./configure –with-apxs=/usr/local/apache/bin/apxs make…
Read moreDomainKeys (DKIM) and SPF records are becoming a common, and annoying, demand among email providers, mainly Yahoo and Hotmail. In short, both are methods of email authentication designed to verify email integrity, by linking a sender to a specific server or hostname. In other words, DomainKeys and SPF records specify what servers can send email…
Read moreCPanel has a internal script for using CPAN to install Perl modules. Learn it and love it: /scripts/perlinstaller Most common Perl modules can be installed from WHM ~> Install a Perl Module, or from command line. If you don't know the name of the Perl module you're installing, you may want to use the WHM…
Read moreUpdate: As of cPanel 11.40, you can install shared SSLs on the main/shared IP just as you do any other certificate. It was kind of annoying in the midst of cPanel 11’s release when cPanel discontinued the ability to install an SSL certificate on a shared IP. Sure, you can do it as ‘nobody’, but…
Read moreUs cPanel system admins pity those who neglect to back up their sites and then blame their hosts when something goes awry…especially when cPanel makes it so damn easy to back up your entire account in just a few clicks — And we’re going to tell you how to do it. Of course, we’re not…
Read more