Hi list, in the appendix you will find a patch against Postfix 2.7.1 which adds write support to Postfix' MySQL client.
If someone like to test it, then he will find Postfix RPMs with MySQL write support for recent versions of *SUSE linux here: http://download.opensuse.org/repositories/home:/rusjako/ To use a MySQL verify db, you have to: - add "address_verify_map = mysql:/etc/postfix/verify.cf" to your main.cf - Content of /etc/postfix/verify.cf: user = postfix password = <secret> dbname = postfix query = SELECT data FROM verify WHERE address='%s' delete = DELETE FROM verify WHERE address='%s' insert = INSERT verify SET address='%s', data='%v' update = UPDATE verify SET data='%v' WHERE address='%s' sequence = SELECT address,data FROM verify - Create the MySQL table postfix.verify: mysql> CREATE TABLE verify( address VARCHAR(255) primary key, data TEXT NOT NULL, created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ); - Grant the rights SELECT, INSERT, DELETE, UPDATE to the user 'postfix' best regards Stefan
postfix-mysql-write-support.patch.gz
Description: GNU Zip compressed data
