How to install MySQL server 5.6 or 5.7 on Debian 7 and 8

Debian provides MySQL server 5.5 with both wheezy and jessie but the latest GA (Generally Available) releases are 5.6 and 5.7 with some enhancements and added features, including support for InnoDB Full-text search.

Here’s how to install MySQL server 5.6 or 5.7 on Debian based Linux distros (including wheezy, jessie and Ubuntu):

1. Download the MySQL APT repository config tool (you can see more details here: http://dev.mysql.com/downloads/repo/apt/)

wget http://dev.mysql.com/get/mysql-apt-config_0.7.3-1_all.deb

Continue reading

How to install Percona Server (MySql Server replacement) on squeeze

Percona Server is an enhanced drop-in replacement for MySQL. Persona server is free open source solution, offering better performance, scalability, features, and instrumentation. Self-tuning algorithms and support for extremely high-performance hardware make it the clear choice for organizations that demand excellent performance and reliability from their MySQL database server.

You can upgrade from MySql server and still use the same tools and application without any change, including phpMyAdmin. If you currently have a running MySql server please make backups of the configuration and databases before upgrading.

1. Remove MySql Server

apt-get remove mysql-server-core-5.1 mysql-server-5.1 mysql-server
Continue reading

Installing PowerDNS with MySql backend

The PowerDNS Nameserver is a modern, advanced and high performance authoritative-only nameserver. It is written from scratch and conforms to all relevant DNS standards documents. Furthermore, PowerDNS interfaces with almost any database.

This tutorial has been tested and is working on Debian etch and lenny

1. Install the PowerDNS server and MySql backend using apt

apt-get install pdns-server pdns-backend-mysql
Continue reading

Install and configure MailWatch monitoring tool for MailScanner

MailWatch for MailScanner is a web-based front-end to MailScanner written in PHP, MySQL and JpGraph. It comes with a CustomConfig module for MailScanner which causes MailScanner to log all message data (excluding body text) to a MySQL database which is then queried by MailWatch for reporting and statistics.

1. Install Apache2, MySql server and PHP5 with required modules. You may already have some or all of these packages installed.

apt-get install apache2 php5-cli php5 mysql-server libdbd-mysql-perl php5-gd php5-mysql libapache2-mod-php5
Continue reading

Installing Courier POP3 and IMAP daemon with MySql backend

The Courier mail transfer agent (MTA) is an integrated mail/groupware server based on open commodity protocols, such as ESMTP, IMAP, POP3, LDAP, SSL, and HTTP. Courier provides ESMTP, IMAP, POP3, webmail, and mailing list services within a single, consistent, framework. In this tutorial we’ll only use the Courier POP3 and IMAP services.

It’s assumed that you have already installed and configured Postfix according to this tutorial: Installing Postfix with MySql backend and SASL for SMTP authentication

1. Install required packages

apt-get install courier-authdaemon courier-authlib-mysql courier-pop courier-pop-ssl courier-imap courier-imap-ssl
Continue reading

Installing Postfix with MySql backend and SASL for SMTP authentication

Postfix is a free and open source mail transfer agent (MTA). It is intended as a fast, easy-to-administer, and secure alternative to the widely-used Sendmail MTA.

Install and configure Postfix

1. Install Postfix and SASL

apt-get install postfix postfix-mysql libsasl2-modules-sql sasl2-bin libsasl2-2 postfix-tls libpam-mysql
> Internet Site
> host.domain.com
Continue reading