From owner-freebsd-ports Thu Oct 4 3:56:12 2001 Delivered-To: freebsd-ports@freebsd.org Received: from mail.tgd.net (rand.tgd.net [64.81.67.117]) by hub.freebsd.org (Postfix) with SMTP id 1544737B403 for ; Thu, 4 Oct 2001 03:56:07 -0700 (PDT) Received: (qmail 89084 invoked by uid 1001); 4 Oct 2001 10:56:05 -0000 Date: Thu, 4 Oct 2001 03:56:05 -0700 From: Sean Chittenden To: dwcjr@FreeBSD.org Cc: ports@freebsd.org Subject: postfix + pgsql? Message-ID: <20011004035604.N86031@rand.tgd.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline X-PGP-Key: 0x1EDDFAAD X-PGP-Fingerprint: C665 A17F 9A56 286C 5CFB 1DEA 9F4F 5CEF 1EDD FAAD X-Web-Homepage: http://sean.chittenden.org/ Sender: owner-freebsd-ports@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org Howdy. The patch below allows for a postgresql maps in postfix: very cool, IMHO. The patch applies against the postfix installation that comes in the freebsd ports (3 hunks fail from previous patches and are _extremely_ easy to apply by hand). http://www.mat.cc/postfix/ http://www.mat.cc/postfix/postfix-pg.snapshot-20010228.patch The proceedure that I step through: make configure cd work fetch http://www.mat.cc/postfix/postfix-pg.snapshot-20010228.patch ln -s postfix-20010228-pl05 snapshot-20010228 patch -p0 < postfix-pg.snapshot-20010228.patch cd postfix-20010228-pl05/src/util [apply rejected hunks (rej included below)] cd ../../.. [edit Makefile.inc to add pgsql opts (diff included)] make post-patch make make install In the Makefile.inc I've ommitted the build dependencies because I have postgres installed, but that'd probably be a nicety to add in. I've noticed that if I"ve compiled in kerberos support into postgres, that I need to include '/usr/local/lib/libkrb5.a -lkrb5' into the POSTFIX_AUXLIBS. # diff -u Makefile.inc.orig Makefile.inc --- Makefile.inc.orig Thu Oct 4 03:40:25 2001 +++ Makefile.inc Thu Oct 4 03:44:00 2001 @@ -30,6 +30,8 @@ DISTFILES+= ${DISTNAME}.tar.gz pfixtls-0.7.9-20010228-pl04-0.9.6b.tar.gz EXTRA_PATCHES+= ${WRKDIR}/pfixtls-0.7.9-20010228-pl04-0.9.6b/pfixtls.diff PATCH_STRIP= -p1 +POSTFIX_CCARGS+= -DHAS_PGSQL -I/usr/local/include/pgsql +POSTFIX_AUXLIBS+= /usr/local/lib/libpq.a -lcrypt PLIST_SUB+= SUB_PCRE="" PLIST_SUB+= SUB_SASL="" PLIST_SUB+= SUB_TLS="" # cat work/snapshot-20010228/src/util/Makefile.in.rej *************** *** 23,29 **** clean_env.c watchdog.c spawn_command.c duplex_pipe.c sane_rename.c \ sane_link.c unescape.c timed_read.c timed_write.c dict_tcp.c \ hex_quote.c dict_alloc.c rand_sleep.c sane_time.c dict_debug.c \ - sane_socketpair.c OBJS = argv.o argv_split.o attr.o basename.o binhash.o chroot_uid.o \ close_on_exec.o concatenate.o dict.o dict_db.o dict_dbm.o \ dict_env.o dict_ht.o dict_ldap.o dict_mysql.o dict_ni.o dict_nis.o \ --- 23,29 ---- clean_env.c watchdog.c spawn_command.c duplex_pipe.c sane_rename.c \ sane_link.c unescape.c timed_read.c timed_write.c dict_tcp.c \ hex_quote.c dict_alloc.c rand_sleep.c sane_time.c dict_debug.c \ + sane_socketpair.c dict_pgsql.c OBJS = argv.o argv_split.o attr.o basename.o binhash.o chroot_uid.o \ close_on_exec.o concatenate.o dict.o dict_db.o dict_dbm.o \ dict_env.o dict_ht.o dict_ldap.o dict_mysql.o dict_ni.o dict_nis.o \ *************** *** 48,54 **** clean_env.o watchdog.o spawn_command.o duplex_pipe.o sane_rename.o \ sane_link.o unescape.o timed_read.o timed_write.o dict_tcp.o \ hex_quote.o dict_alloc.o rand_sleep.o sane_time.o dict_debug.o \ - sane_socketpair.o HDRS = argv.h attr.h binhash.h chroot_uid.h connect.h dict.h dict_db.h \ dict_dbm.h dict_env.h dict_ht.h dict_ldap.h dict_mysql.h \ dict_ni.h dict_nis.h dict_nisplus.h dir_forest.h events.h \ --- 48,54 ---- clean_env.o watchdog.o spawn_command.o duplex_pipe.o sane_rename.o \ sane_link.o unescape.o timed_read.o timed_write.o dict_tcp.o \ hex_quote.o dict_alloc.o rand_sleep.o sane_time.o dict_debug.o \ + sane_socketpair.o dict_pgsql.o HDRS = argv.h attr.h binhash.h chroot_uid.h connect.h dict.h dict_db.h \ dict_dbm.h dict_env.h dict_ht.h dict_ldap.h dict_mysql.h \ dict_ni.h dict_nis.h dict_nisplus.h dir_forest.h events.h \ *************** *** 64,70 **** vbuf.h vbuf_print.h vstream.h vstring.h vstring_vstream.h \ dict_unix.h dict_pcre.h dict_regexp.h mac_expand.h clean_env.h \ watchdog.h spawn_command.h sane_fsops.h dict_tcp.h hex_quote.h \ - sane_time.h sane_socketpair.h TESTSRC = fifo_open.c fifo_rdwr_bug.c fifo_rdonly_bug.c select_bug.c \ stream_test.c dup2_pass_on_exec.c WARN = -W -Wformat -Wimplicit -Wmissing-prototypes \ --- 64,70 ---- vbuf.h vbuf_print.h vstream.h vstring.h vstring_vstream.h \ dict_unix.h dict_pcre.h dict_regexp.h mac_expand.h clean_env.h \ watchdog.h spawn_command.h sane_fsops.h dict_tcp.h hex_quote.h \ + sane_time.h sane_socketpair.h dict_pgsql.h TESTSRC = fifo_open.c fifo_rdwr_bug.c fifo_rdonly_bug.c select_bug.c \ stream_test.c dup2_pass_on_exec.c WARN = -W -Wformat -Wimplicit -Wmissing-prototypes \ -- Sean Chittenden To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-ports" in the body of the message