public marks

PUBLIC MARKS from falko with tag mysql

July 2010

Installing PowerDNS (With MySQL Backend) And Poweradmin On Debian Lenny | HowtoForge - Linux Howtos and Tutorials

(via)
This article shows how you can install the PowerDNS nameserver (with MySQL backend) and the Poweradmin control panel for PowerDNS on a Debian Lenny system. PowerDNS is a high-performance, authoritative-only nameserver - in the setup described here it will read the DNS records from a MySQL database (similar to MyDNS), although other backends such as PostgreSQL are supported as well. Poweradmin is a web-based control panel for PowerDNS.

June 2010

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Fedora 13 x86_64) | HowtoForge - Linux Howtos and Tutorials

(via)
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 that Postfix uses.

Installing Apache2 With PHP5 And MySQL Support On Fedora 13 (LAMP) | HowtoForge - Linux Howtos and Tutorials

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

Installing Cherokee With PHP5 And MySQL Support On Ubuntu 10.04 | HowtoForge - Linux Howtos and Tutorials

(via)
Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, TLS and SSL encrypted connections, virtual hosts, authentication, on the fly encoding, load balancing, Apache compatible log files, and much more. This tutorial shows how you can install Cherokee on an Ubuntu 10.04 server with PHP5 support (through FastCGI) and MySQL support.

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 10.04) | HowtoForge - Linux Howtos and Tutorials

(via)
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.

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 10.04 (LAMP) | HowtoForge - Linux Howtos and Tutorials

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

The Perfect Server - Fedora 13 x86_64 [ISPConfig 3] | HowtoForge - Linux Howtos and Tutorials

(via)
This tutorial shows how to prepare a Fedora 13 server (x86_64) for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, and many more.

The Perfect Server - Fedora 13 x86_64 [ISPConfig 2] | HowtoForge - Linux Howtos and Tutorials

(via)
This is a detailed description about how to set up a Fedora 13 server that offers all services needed by ISPs and hosters: Apache web server (SSL-capable) with PHP5/Ruby/Python, Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Dovecot POP3/IMAP, Quota, Firewall, etc. This tutorial is written for the 64-bit version of Fedora 13, but should apply to the 32-bit version with very little modifications as well. In the end you should have a system that works reliably, and if you like you can install the free webhosting control panel ISPConfig (i.e., ISPConfig runs on it out of the box).

May 2010

The Perfect Server - CentOS 5.5 x86_64 [ISPConfig 3] | HowtoForge - Linux Howtos and Tutorials

(via)
This tutorial shows how to prepare a CentOS 5.5 x86_64 server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, and many more.

The Perfect Server - CentOS 5.5 x86_64 [ISPConfig 2] | HowtoForge - Linux Howtos and Tutorials

(via)
This tutorial shows how to set up a CentOS 5.5 server (x86_64) that offers all services needed by ISPs and web hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Dovecot POP3/IMAP, Quota, Firewall, etc. This tutorial is written for the 64-bit version of CentOS 5.5, but should apply to the 32-bit version with very little modifications as well. In the end you should have a system that works reliably, and if you like you can install the free webhosting control panel ISPConfig (i.e., ISPConfig runs on it out of the box).

The Perfect Server - Ubuntu 10.04 [ISPConfig 3] | HowtoForge - Linux Howtos and Tutorials

(via)
This tutorial shows how to prepare an Ubuntu 10.04 (Lucid Lynx) server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more.

The Perfect Server - Ubuntu Lucid Lynx (Ubuntu 10.04) [ISPConfig 2] | HowtoForge - Linux Howtos and Tutorials

(via)
This tutorial shows how to set up an Ubuntu Lucid Lynx (Ubuntu 10.04) server that offers all services needed by ISPs and hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Courier POP3/IMAP, Quota, Firewall, etc. In the end you should have a system that works reliably, and if you like you can install the free webhosting control panel ISPConfig 2 (i.e., ISPConfig runs on it out of the box).

March 2010

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Mandriva 2010.0 x86_64) | HowtoForge - Linux Howtos and Tutorials

(via)
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.

February 2010

Creating MySQL Backups With AutoMySQLBackup On Ubuntu 9.10 | HowtoForge - Linux Howtos and Tutorials

(via)
AutoMySQLBackup is a shell script that lets you take daily, weekly and monthly backups of your MySQL databases using mysqldump. It can back up multiple databases, compress the backups, back up remote databases, and email the logs. This tutorial explains how to install and use it on an Ubuntu 9.10 server.

How To Set Up MySQL Database Replication With SSL Encryption On CentOS 5.4 | HowtoForge - Linux Howtos and Tutorials

(via)
This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave). MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures.

Installing Cherokee With PHP5 And MySQL Support On Ubuntu 9.10 | HowtoForge - Linux Howtos and Tutorials

(via)
Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, TLS and SSL encrypted connections, virtual hosts, authentication, on the fly encoding, load balancing, Apache compatible log files, and much more. This tutorial shows how you can install Cherokee on an Ubuntu 9.10 server with PHP5 support (through FastCGI) and MySQL support.

How To Set Up MySQL Database Replication With SSL Encryption On Ubuntu 9.10 | HowtoForge - Linux Howtos and Tutorials

(via)
This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave). MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures.

Installing Nginx With PHP5 And MySQL Support On Fedora 12 | HowtoForge - Linux Howtos and Tutorials

(via)
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 12 server with PHP5 support (through FastCGI) and MySQL support.

January 2010

Installing Apache2 With PHP5 And MySQL Support On Fedora 12 (LAMP) | HowtoForge - Linux Howtos and Tutorials

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

How To Set Up Database Replication In MySQL On Ubuntu 9.10 | HowtoForge - Linux Howtos and Tutorials

(via)
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures.

December 2009

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Fedora 12 x86_64) | HowtoForge - Linux Howtos and Tutorials

(via)
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.

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 9.10) | HowtoForge - Linux Howtos and Tutorials

(via)
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.

The Perfect Server - Mandriva 2010.0 Free (x86_64) [ISPConfig 2] | HowtoForge - Linux Howtos and Tutorials

(via)
This tutorial shows how to set up a Mandriva 2010.0 Free (x86_64) server that offers all services needed by ISPs and hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Dovecot POP3/IMAP, Quota, Firewall, etc. In the end you should have a system that works reliably, and if you like you can install the free webhosting control panel ISPConfig 2 (i.e., ISPConfig runs on it out of the box). This tutorial is written for the 64-bit version of Mandriva 2010.0.

The Perfect Server - OpenSUSE 11.2 x86_64 [ISPConfig 2] | HowtoForge - Linux Howtos and Tutorials

(via)
This is a detailed description about how to set up an OpenSUSE 11.2 server (x86_64) that offers all services needed by ISPs and hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Dovecot POP3/IMAP, Quota, Firewall, etc. In the end you should have a system that works reliably, and if you like you can install the free webhosting control panel ISPConfig 2 (i.e., ISPConfig runs on it out of the box).

The Perfect Server - Fedora 12 x86_64 [ISPConfig 2] | HowtoForge - Linux Howtos and Tutorials

(via)
This is a detailed description about how to set up a Fedora 12 server that offers all services needed by ISPs and hosters: Apache web server (SSL-capable) with PHP5/Ruby/Python, Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Dovecot POP3/IMAP, Quota, Firewall, etc. This tutorial is written for the 64-bit version of Fedora 12, but should apply to the 32-bit version with very little modifications as well. In the end you should have a system that works reliably, and if you like you can install the free webhosting control panel ISPConfig (i.e., ISPConfig runs on it out of the box).