SQL

Information for Linux System Administration

Virtual Hosting: Proftpd, MySQL on Ubuntu 12.10

vote

This document describes how to install a Proftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota with this setup. This tutorial is based on Ubuntu 12.10. read more...

permapage | score:9776 | -falko, April 24, 2013

Tutorial: Install Nginx, PHP5, PHP-FPM, and MySQL on CentOS 6.4

vote

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a CentOS 6.4 server with PHP5 support (through PHP-FPM) and MySQL support. read more...

permapage | score:9770 | -falko, April 1, 2013

Virtual Users/Domains with Postfix, Courier, MySQL, SquirrelMail (CentOS 6.3)

vote

This document describes how to install a Postfix mail server that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier, so that Courier can authenticate against the same MySQL database Postfix uses. The resulting Postfix server is capable of SMTP-AUTH and TLS and quota. Passwords are stored in encrypted form in the database. In addition to that, this tutorial covers the installation of Amavisd, SpamAssassin and ClamAV so that emails will be scanned for spam and viruses. I will also show how to install SquirrelMail as a webmail interface so that users can read and send emails and change their passwords. read more...

mail this link | permapage | score:9753 | -falko, March 27, 2013

Tutorial: Install Lighttpd, PHP5, MySQL on CentOS 6.4

vote

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a Centos 6.4 server with PHP5 support (through PHP-FPM) and MySQL support. PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites. I use PHP-FPM in this tutorial instead of Lighttpd's spawn-fcgi. read more...

permapage | score:9743 | -falko, April 17, 2013

Tutorial: Install Apache2, PHP5, MySQL on OpenSUSE 12.3

vote

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an OpenSUSE 12.3 server with PHP5 support (mod_php) and MySQL support. read more...

permapage | score:9718 | -falko, April 21, 2013

Install Apache2, PHP5, MySQL on CentOS 5.7

vote

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 5.7 server with PHP5 support (mod_php) and MySQL support. read more...

permapage | score:9683 | -falko, December 11, 2011

Virtual Hosting with PureFTPd, MySQL on CentOS 6.4

vote

This document describes how to install a PureFTPd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota and upload/download bandwidth limits with this setup. Passwords will be stored encrypted as MD5 strings in the database. read more...

permapage | score:9663 | -falko, April 3, 2013

Tutorial: LinOTP on OpenSuSE 12.3 with PostgreSQL

vote

This tutorial describes the installation of LinOTP on OpenSUSE 12.3 using PostgreSQL as a token database. LinOTP is a two factor authentication solution with One Time Passwords. In the following Howto we are showing how to enable SSH authentication with LinOTP. read more...

permapage | score:9589 | -falko, April 12, 2013

Tutorial: Install Lighttpd, PHP5, MySQL on CentOS 6.0

vote

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a CentOS 6.0 server with PHP5 support (through FastCGI) and MySQL support. read more...

permapage | score:9555 | -falko, December 15, 2011

Install Lighttpd, PHP5, MySQL on Scientific Linux 6.3

vote

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a Scientific Linux 6.3 server with PHP5 support (through PHP-FPM) and MySQL support. PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites. I use PHP-FPM in this tutorial instead of Lighttpd's spawn-fcgi. read more...

permapage | score:9538 | -falko, March 28, 2013

Virtual Hosting with PureFTPd and MySQL on Fedora 18

vote

permapage | score:9500 | -falko, February 5, 2013

Tutorial: Install Lighttpd, PHP5, MySQL on Fedora 18

vote

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a Fedora 18 server with PHP5 support (through PHP-FPM) and MySQL support. PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites. I use PHP-FPM in this tutorial instead of Lighttpd's spawn-fcgi. read more...

permapage | score:9456 | -falko, February 22, 2013

Tutorial: Apache2, PHP5, MySQL on Scientific Linux 6.3

vote

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Scientific Linux 6.3 server with PHP5 support (mod_php) and MySQL support. read more...

permapage | score:9425 | -falko, March 5, 2013

Tutorial: Install Nginx, PHP5 and MySQL on Fedora 18

vote

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Fedora 18 server with PHP5 support (through PHP-FPM) and MySQL support. read more...

permapage | score:9412 | -falko, January 25, 2013

Virtual Users and Domains with Postfix, Courier, MySQL, SquirrelMail (Fedora 18)

vote

This document describes how to install a Postfix mail server that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier can authenticate against the same MySQL database Postfix uses. The resulting Postfix server is capable of SMTP-AUTH and TLS and quota. Passwords are stored in encrypted form in the database. In addition to that, this tutorial covers the installation of Amavisd, SpamAssassin and ClamAV so that emails will be scanned for spam and viruses. I will also show how to install SquirrelMail as a webmail interface so that users can read and send emails and change their passwords. read more...

mail this link | permapage | score:9396 | -falko, February 10, 2013

Tutorial: Install Apache2, PHP5, MySQL on OpenSUSE 12.2

vote

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an OpenSUSE 12.2 server with PHP5 support (mod_php) and MySQL support. read more...

permapage | score:9387 | -falko, September 15, 2012

Rsnapshot: Archive, Snapshot, Backup MySQL Databases on Debian

vote

This howto will show you how to install and set up Rsnapshot, enable archiving of snapshots and how to back up MySQL databases on Debian. Rsnapshot is a filesystem snapshot utility for making backups of local and remote systems. Using rsync and hard links, it is possible to keep multiple, full backups instantly available. The disk space required is just a little more than the space of one full backup, plus incrementals. read more...

permapage | score:9384 | -falko, January 14, 2013

Tutorial: Install Apache2, PHP5, MySQL on Ubuntu 12.10

vote

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 12.10 server with PHP5 support (mod_php) and MySQL support. read more...

permapage | score:9384 | -falko, October 28, 2012

Tutorial: Install Nginx, PHP5, MySQL on Scientific Linux 6.3

vote

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Scientific Linux 6.3 server with PHP5 support (through PHP-FPM) and MySQL support. read more...

permapage | score:9383 | -falko, March 7, 2013

Virtual Hosting with vsftpd and MySQL on Ubuntu 12.10

vote

Vsftpd is one of the most secure and fastest FTP servers for Linux. Usually vsftpd is configured to work with system users. This document describes how to install a vsftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. read more...

permapage | score:9358 | -falko, November 28, 2012

More articles...

Large Canvas Abstract Art Prints

Recent headlines

Using Multiple PHP Versions (PHP-FPM FastCGI) With ISPConfig 3 (Ubuntu 12.04)

Install Mplayer and Multimedia codecs on Ubuntu 13.04

Lynis: Security and system auditing tool

ARM-based EMB-2500: Like Raspberry Pi, but much better

Upgrade Ubuntu 12.10 to 13.04

Tutorial: Build an Ubuntu 13.04 Server (Apache2, BIND, Dovecot)

Tutorial: Ubuntu 13.04 Samba Server with tdbsam

Find wasted disk space with the Agedu Unix utility