Verisign SSL Certificates

Verisign SSL Certificates You have generated a certificate request (CSR and private key) using plesk. You would like to know how to complete the certificate request process. The Verisign digital certificate can be downloaded in the X.509 format as three files. The three files are designated as: 1) End Entity Certificate 2) First Intermediate Certificate … Read more

Migrate MySQL from Slaved Drive

Migrate MySQL from Slaved Drive 1. Mount the slave drive. We’ll assume you mounted it at /media/slave Find the drive: sdb is the drive – the slaved drive after the reinstall Check to see if it is ext3 or ext4 Mount according to ext3 or ext4 Add to fstab 2. Edit the MySQL config file … Read more

Optimize Mysql

Did you know that mysql comes with configuration files for better optimization? These files are located at: /usr/share/doc/mysql-server-5.1.71/my-huge.cnf /usr/share/doc/mysql-server-5.1.71/my-innodb-heavy-4G.cnf /usr/share/doc/mysql-server-5.1.71/my-large.cnf /usr/share/doc/mysql-server-5.1.71/my-medium.cnf /usr/share/doc/mysql-server-5.1.71/my-small.cnf /usr/share/man/man5/openssl.cnf.5ssl.gz Or /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf Stop mysql # service mysqld stop Stopping mysqld: [ OK ] backup the original my.cnf file. # mv /etc/my.cnf /etc/my.cnf.original Move the new config file to … Read more

Mytop

Install the repository CentOS 5.x rpm -Uhv http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm CentOS 6.x 64 bit rpm -Uhv http://apt.sw.be/redhat/el6/en/i386/rpmforge/RPMS/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm Install mytop yum -y install mytop Configuration Odds are, you will get an error initially running this program unless you configure it first. whereis mytop Example: /usr/bin/mytop or /usr/local/bin/mytop nano /usr/bin/mytop or nano /usr/local/bin/mytop Locate the following lines: my %config … Read more

Install SSL Certificate in Plesk

CSRs can actually be generated within Plesk by following the steps I have listed below. I have also included the steps on how to install your SSL after getting it from the SSL provider. Please feel free to let us know if you are in need of anything else or have any further questions. How … Read more

Debugging sleeping connections with MySQL

Have you ever seen connection in the SHOW PROCESSLIST output which is in “Sleep” state for a long time and you have no idea why this would happen ? I see if frequently with web applications and it is often indication of trouble. Not only it means you may run out of MySQL connections quicker … Read more

ClamAV on CentOS

ClamAV is a free anti-virus program available for Linux operating systems.This will explain how to Install ClamAV on CentOS 6 64. Install the epel repository First, determine the most current version of the repository that is available. Using a web browser, visit http://download.fedoraproject.org/pub/epel/6/x86_64/ Note you can substitute the CentOS version ( /6/ ) with your … Read more

Dark Leach Virus

This root level compromise seems to affect CentOS 5.x and < Plesk 10.4. This affects Apache directly and requires a reinstallation. Slaving the original drive to migrate the files is acceptible since it affects the OS files themselves, but clamscan is still highly recommended. To determine if a server has this compromise: Plesk [bash] fgrep ... Read more