Centos - xz compression is not available error when trying to install any package

Generally this issue comes when we install the wrong epel-release package.  I have fixed this issue by using below command

 yum remove epel-release

which removes that wrong package.
 

Vtiger - How to do settings for outgoing server when you don't now about SMTP server details

By doing some minor tweaks in core file we can easily enable default sendmail instead of SMTP settings.

In CRM, open file vtigercrm/modules/Emails/class.phpmailer.php

Changes should be as below:

function IsSMTP() {
$this->Mailer = "smtp"

to

function IsSMTP() {
$this->Mailer = "sendmail"

Now go to outgoing server settings in CRM admin and enter details like below -

Server Name:	mail.yourdomain.com
User Name:	youremail@anydomain.com
Password:	Your password for above email
From Email:	Set as per your choice
Require Authentication:	Set as per your choice

How to turn off auto complete on html form ?

Auto complete on/off is the functionality provided in HTML. The objective of using "Auto-complete off/on" is to control form auto completing your details. By default auto complete is on.
To disable this just add autocomplete = "off" in respective form tag

We can also use auto complete in particular input fields of a form. 

Mysql kill all process listed in process list

Use below steps in terminal to kill all running mysql process -

mysql> select concat('KILL ',id,';') from information_schema.processlist into outfile '/tmp/process.txt';

 

we can also filter process list here by user host etc. by applying them in where clause.

mysql> source /tmp/process.txt;

Generate CSR & Install ssl certfication on linux server

It's 2 Step Process -

Step 1 - Create CSR field and send & receiving your SSL cert from your authority of choice -

Start with below command in terminal - 

openssl req -nodes -newkey rsa:2048 -keyout domain.key -out domain.csr

Linux command - How to create a zip file of whole directory

We can use below linux command to zip archive a directory -

zip -r finename.zip /path/to/folder

How to configure send mail on linux dedicated server

Step 1 - Install Sendmail

          yum install sendmail

It will install sendmail on server. If already installed pleas skip this step

Step 2 - Enable sendmail

     setsebool -P httpd_can_sendmail 1

Step 3 - Start Sendmail Service

          service sendmail start