Re: Use of MySQL for lookups

From: Steve (no email)
Date: Tue Nov 27 2007 - 01:11:44 EST

  • Next message: Tony Earnshaw: "Re: OT: Any bad DKIM experiences?"

    -------- 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
    

  • Next message: Tony Earnshaw: "Re: OT: Any bad DKIM experiences?"





    Hosted Email Solutions

    Invaluement Anti-Spam DNSBLs



    Powered By FreeBSD   Powered By FreeBSD