Mail Relaying.......................................................................413
Forwarding Email with Aliases
................................................413
Using Fetchmail to Retrieve Mail
.....................................................414
Installing Fetchmail
..............................................................415
Configuring Fetchmail
...........................................................415
Choosing a Mail Delivery Agent
......................................................418
Procmail
.............................................................................419
Spamassassin
.......................................................................419
Squirrelmail
.........................................................................419
Virus Scanners
......................................................................420
Autoresponders
....................................................................420
Alternatives to Microsoft Exchange Server
........................................420
Microsoft Exchange Server/Outlook Client
................................421
CommuniGate Pro
................................................................421
Oracle Beehive
.....................................................................421
Bynari
.................................................................................421
Open-Xchange
.....................................................................421
phpgroupware
......................................................................422
PHProjekt
............................................................................422
Horde
.................................................................................422
Reference
....................................................................................422
20 Proxying and Reverse Proxying 425
What Is a Proxy Server?
.................................................................425
Installing Squid
............................................................................426
Configuring Clients
......................................................................426
Access Control Lists
......................................................................427
Specifying Client IP Addresses
........................................................431
Example Configurations
................................................................432
Reference
....................................................................................433
21 Administering Database Services 435
A Brief Review of Database Basics
....................................................436
How Relational Databases Work
..............................................437
Understanding SQL Basics
......................................................440
Creating Tables
.....................................................................440
Inserting Data into Tables
......................................................441
Retrieving Data from a Database
.............................................442
Choosing a Database: MySQL Versus PostgreSQL
...............................444
Speed
..................................................................................444
Data Locking
.......................................................................445
ACID Compliance in Transaction Processing
Ubuntu Unleashed
xvi