Category: Plesk

Convert Existing MySQL Database to Innodb

  Converting existing MySQL Database Tables from MyISAM to InnoDB can be done from PHPMyAdmin but if there are too many tables the following script will help you to convert all the tables of a particular database to InnoDB Pre-requisites: 1. This tutorial assumes that you have .my.cnf configured with MySQL credentials for auto-login 2. […]

SSL Installation on Tomcat Server

  Generate CSR for Tomcat Server: 1. Generate the private key with the below command keytool -genkey -alias website -keyalg RSA -keysize 2048 -keystore example_com.jks -dname “,OU=IT, O=Example Pvt Ltd, L=Hyderabad, ST=Telangana, C=IN” 2. Generate the CSR using the below command keytool -certreq -alias website -file example_com.csr -keystore example_com.jks 3. Once the certificate is signed, […]

Install PEAR/PHP Mail function

  PHP Mail function should be installed on your server if you want to send emails from your code, to install 1. Install Pear package (if it is not already installed) by running Debian/Ubuntu: apt-get install php-pear Redhat/CentOS: yum install php-pear 2. Once the pear installation is complete or if you have PEAR already installed, […]

Error: “An error occured” in Joomla admin section

  After installing the latest version of Joomla you may sometimes notice the below error in the “admin” section. Error An error occured Screenshot:   Fix: This happens because of the incorrect/low MySQL “sort_buffer_size”, to fix this edit the “my.cnf” file vi /etc/my.cnf Add the below line to the end of the file sort_buffer_size = […]

Restrict WordPress Admin to Specific IP’s

It is always advised to restrict wordpress admin section to specific IP to avoid brutforce attacks, to configure it add the below code in the .htaccess file of your wordpress domain   <IfModule mod_rewrite.c> RewriteEngine on RewriteCond %{REQUEST_URI} ^(.*)?wp-login\.php(.*)$ [OR] RewriteCond %{REQUEST_URI} ^(.*)?wp-admin$ RewriteCond %{REMOTE_ADDR} !^$ RewriteCond %{REMOTE_ADDR} !^$ RewriteRule ^(.*)$ – [R=403,L] </IfModule> © 2016