Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 4 Oct 2001 03:56:05 -0700
From:      Sean Chittenden <sean@chittenden.org>
To:        dwcjr@FreeBSD.org
Cc:        ports@freebsd.org
Subject:   postfix + pgsql?
Message-ID:  <20011004035604.N86031@rand.tgd.net>

next in thread | raw e-mail | index | archive | help
	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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20011004035604.N86031>