Re: Use of MySQL for lookups

3 msg	Re: Virtual domain aliases
4 msg	address verify vs. virtual_alias_maps
20 msg	Postfix/ClamAV Config Error
4 msg	smtp /dev/poll problem
6 msg	Addresses filtering for only one supported domain
14 msg	Greylist question
1 msg	One transport with AUTH and other transport wit...
7 msg	Is this expected reject behavior for foreign IP...
3 msg	relay_domains and virtual_mailbox_domains not w...
2 msg	Need help debugging a possible content filter p...
11 msg	spam emails with \| in front of the email addresses
9 msg	unexpected domain rewrite (by postfix?)
5 msg	Error receiving email
20 msg	Postfix 2.5-20071111, smtp.gmail.com, bouncing ...
1 msg	Bounce notification configure
45 msg	Re: Recipient validation

Use of MySQL for lookups
\ jekillen (27 Nov 2007)
. \ Steve (27 Nov 2007)

8 msg	proposal: change behavior with respect to recip...
11 msg	OT: Any bad DKIM experiences?
8 msg	hashed spool directories

Subject:	Re: Use of MySQL for lookups
Group:	Postfix-users
From:	Steve
Date:	27 Nov 2007

-------- Original-Nachricht --------
> Datum: Mon, 26 Nov 2007 21:23:14 -0800
> Von: jekillen <jekillen>
> An: postfix-users
> 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