Debian/Ubuntu Tips and Tricks

Debuntu

Debian/Ubuntu Tips and Tricks

How-To: Virtual emails accounts with Postfix and Dovecot — page 3

Posted by chantra on 18th January 2009

This entry is part 2 of 3 in the series How-To: Virtual emails accounts with Postfix and Dovecot

5. Configuring Dovecot

Dovecot has its SQL configuration gathered in a separated file: /etc/dovecot/dovecot-sql.conf, so let's edit edit with our settings:

# vi /etc/dovecot/dovecot-sql.conf

Read the rest of this entry »

Tags: , , , ,
Posted in Administration, HowTo, Networking | 1 Comment »

How-To: Virtual emails accounts with Postfix and Dovecot — page 2

Posted by chantra on 18th January 2009

This entry is part 2 of 3 in the series How-To: Virtual emails accounts with Postfix and Dovecot

4. Configuring Postfix

4.1. main.cf and master.cf

Your postfix main.cf file should look like:

Read the rest of this entry »

Tags: , , , ,
Posted in Administration, HowTo, Networking | 1 Comment »

How-To: Virtual emails accounts with Postfix and Dovecot

Posted by chantra on 18th January 2009

This entry is part 1 of 3 in the series How-To: Virtual emails accounts with Postfix and Dovecot

This tutorial will explain how to run a mail server with virtual domains and users using a MySQL backend to store email informations.
Postfix will be our SMTP server, Dovecot will be handling IMAP (optionally one could configure POP3 also) so that users can retrieve their email.

Another tutorial will cover SPAM fighting using DSPAM based on this implementation (yet to be done).

This tutorial was done on Debian Etch using postfix 2.3.8-2etch4 and 1.0.rc15-2etch4.

Read the rest of this entry »

Tags: , , , ,
Posted in Administration, HowTo, Networking | 2 Comments »

How-To: Apache2 authentication using MySQL backend — page 2

Posted by chantra on 17th December 2008

This entry is part 1 of 2 in the series How-To: Apache2 authentication using MySQL backend

3. Creating users

Here we will be using sha1 password. To create a password, you can use the following command:

# echo -n 'password' | sha1sum
5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8 -

Read the rest of this entry »

Tags: , , ,
Posted in Administration, HowTo, HTTP, Networking, System | 5 Comments »

How-To: Apache2 authentication using MySQL backend

Posted by chantra on 17th December 2008

This entry is part 1 of 2 in the series How-To: Apache2 authentication using MySQL backend

this tutorial will explain how to use a MySQL backend in order to authentication users against your Apache website.

To achieve this we will use Apache2 and its auth_mysql module.

Read the rest of this entry »

Tags: , , ,
Posted in Administration, HowTo, HTTP, Networking, System | 1 Comment »

How-To: FTP Virtual Host with ProFTPD and MySQL — page 2

Posted by chantra on 22nd May 2007

This entry is part 2 of 2 in the series How-To: FTP Virtual Host with ProFTPD and MySQL

4. Configure ProFTPd:

ProFTPd main configuration file is /etc/proftpd/proftpd.conf. On Debian, proFTPd over the capability of including files from the main configuration file. Thus, we are going to create a file call /etc/proftpd/mysql.conf which we will include from the main file.
This has the advantage that if the new config is not working, we can easily comment our include and fall back to the previous config.

So, get ready with your favorite text editor, edit /etc/proftpd/mysql.conf and put the following inside:

Read the rest of this entry »

Tags: , ,
Posted in Administration, HowTo, Networking, System | No Comments »

How-To: FTP Virtual Host with ProFTPD and MySQL

Posted by chantra on 21st May 2007

This entry is part 1 of 2 in the series How-To: FTP Virtual Host with ProFTPD and MySQL

Using ProFTPD and its SQL module for MySQL, it is possible to give FTP access to non system users.
By doing so, one can give access to a Virtual User which is only allowed to use the FTP service.

This Tutorial will show how to create and populate the user and group tables as well as configure proftpd in order to use the MySQL backend.

Read the rest of this entry »

Tags: , ,
Posted in Administration, HowTo, Networking, System | No Comments »

How-To create a MySQL database and set privileges to a user

Posted by chantra on 21st May 2007

MySQL is a widely spread SQL database management system mainly used on LAMP (Linux/Apache/MySQL/PHP) projects.

In order to be able to use a database, one needs to create: a new database, give access permission to the database server to a database user and finally grant all right to that specific database to this user.

This tutorial will explain how to create a new database and give a user the appropriate grant permissions.

Read the rest of this entry »

Tags: , ,
Posted in Administration, HowTo, System | 10 Comments »

How To: Optimize MySQL response time

Posted by chantra on 21st July 2006

High loaded website can get slow to respond when a lot of different visitors visit sites querying the same mysql database server, making it slow to respond.

There is many ways you can improve mysql server response time: by modifying the cache size, stopping dns resolution ....

Let's see how to do that.

Read the rest of this entry »

Tags: ,
Posted in Administration, HowTo, Networking, System | 2 Comments »