Wols Lists wrote:
On 29/05/17 21:54, Carlos E. R. wrote:
On 2017-05-29 22:10, Wols Lists wrote:
On 29/05/17 19:04, Per Jessen wrote:
what do you want mysql for, in this postfix context?
It's perfectly reasonable to keep many or most of the various postfix tables in mysql. As Anton suggests, perhaps a little overkill for a personal or family setup, but that's a matter of choice.
And, when I was reading the postfix man pages, it was extremely unclear how to configure it any other way ...
postfix in openSUSE comes already configured, using plain text files. You just have to edit them, and use a command to convert to the binary format it finally uses. It is easier to maintain for a small setup.
Except my mail server doesn't run SuSE :-)
And when I edited the text files, I couldn't see any particularly easy way of doing it.
Maybe you were wearing your database programmers blink... glasses ? Using mysql tables with postfix instead of plain hash tables is certainly advanced usage, I would say. Editing/creating a text file and creating the hash table with 'postmap', then using it with postfix: check_recipient_access hash:/etc/postfix/something With mysql - check_recipient_access proxy:mysql:/etc/postfix/something.cf the mysql cf file might have something like : hosts = unix:/var/run/mysql/mysql.sock user = postfix password = password dbname = db_postfix query = select name from mytable where name='%s' and status in (0,1) You'll know what comes next - create mytable, grant access, populate mytable. -- Per Jessen, Zürich (20.4°C) http://www.dns24.ch/ - free dynamic DNS, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org