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 <>
> An:
> Betreff: Use of MySQL for lookups
> Hello;
> 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
Steve
-- Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten Browser-Versionen downloaden: http://www.gmx.net/de/go/browser
|
|
|