From: Steve (no email)
Date: Tue Nov 27 2007 - 01:11:44 EST
-------- Original-Nachricht --------
> Datum: Mon, 26 Nov 2007 21:23:14 -0800
> Von: jekillen <>
> Betreff: Use of MySQL for lookups
> I am reading Postfix-Cyrus-Web-cyradm-HOWTO and
> am reading the section on configuring MySQL.
> With respect to the following configuration example:
> # mysql config file for canonical lookups on postfix
> # comments are ok.
> # the user name and password to log into the mysql server
> hosts = localhost
> user = mail
> password = secret
> # the database name on the servers
> dbname = mail
> # the table name
> table = virtual
> select_field = alias
> where_field = username
> # Return the first match only
> additional_conditions = and status = '1' limit 1
> How does this table get created?
The webcyradm package has SQL files with the instructions to create the database. You need to execute that in order to get the database, tables and the structure.
> Is that something
> that Postfix does if it does not exist?
No. Postfix does not create non existent structures in MySQL. It is your job to do that.
> Other wise
> I would need a table description to manually create it
> as well as other MySQL lookup tables.
Look inside the webcyradm package. It has the needed SQL commands.
> The same is true for PAM_MySQL.
> I have experience using MySQL with php in web
> context, and have it installed and running on
> machines to be use as mail servers.
> Perhaps there is specific documentation references?
> Thanks in advance;
> Jeff K
-- Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten Browser-Versionen downloaden: http://www.gmx.net/de/go/browser