Install SSL on Zimbra Mail

This tutorial helps you setup SSL on Zimbra Mail. Step 1 Install SSL Packages using following command: # yum install mod_ssl openssl Step 2 First we generate csr and key file using below command: # openssl req

How to Install Tripwire on CentOS

Tripwire is a host-based intrusion detection system (HIDS). It works by collecting details about your computer’s file-system and configuration. This software can keep track of many different file system data points in order to detect changes. Tripwire

List all triggers and views

Here is simple query to find list of triggers on chosen database Example:  SHOW TRIGGERS; If you want like to find list of views for particular database, then here you can go with. Syntax: SHOW FULL TABLES IN

List tables which has fulltext index

If you have to get list of tables for specific database which table has FULLTEXT index use following command: # SELECT TABLE_NAME FROM information_Schema.STATISTICS WHERE table_schema = 'DATABASE_NAME' AND index_type = 'FULLTEXT' ORDER BY index_name; Example: SELECT TABLE_NAME FROM information_Schema.STATISTICS

Convert any video using FFMPEG

Always we need something which simplify our task/job. Here I have attached code which can convert video using ffmpeg. # ffmpeg -i /path/to/inputfilename /path/to/outputfilename Example: ffmpeg -i /usr/local/public_html/abc.flv  /usr/local/public_html/abc.mp4 It will convert abc.flv file to abc.mp4 without any