Attachment #40175 for bug #63176




.if exists(${LOCALBASE}/lib/libpq.so)
LIB_DEPENDS+=	pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
PLIST_SUB+=	PGM=''
WITH_POSTGRESQL=	yes
.else
PLIST_SUB+=	PGM='@comment '
.endif

.if defined(WITH_MYSQL)
	@cd ${WRKSRC}/smsd && ${GMAKE} libmysql.la LOCALBASE=${LOCALBASE}
.endif
.if defined(WITH_POSTGRESQL)
	@cd ${WRKSRC}/smsd && ${GMAKE} libpq.la LOCALBASE=${LOCALBASE}
.endif
.endif

.if defined(WITH_MYSQL)
	${INSTALL_DATA} ${WRKSRC}/smsd/sms.tables.mysql.sql ${PREFIX}/share/smsd/sms.tables.mysql.sql
.endif
.if defined(WITH_POSTGRESQL)
	${INSTALL_DATA} ${WRKSRC}/smsd/sms.tables.pq.sql ${PREFIX}/share/smsd/sms.tables.pq.sql
.endif
.endif

Lines 35-41 Link Here

(-)dns/mydns/Makefile (-2 / +2 lines)
35	CONFIGURE_ARGS+=--with-openssl	35	CONFIGURE_ARGS+=--with-openssl
36	.endif	36	.endif
37		37
38	.if defined(WITH_PGSQL)	38	.if defined(WITH_POSTGRESQL)
39	POSTGRESQL_PORT?= databases/postgresql-client	39	POSTGRESQL_PORT?= databases/postgresql-client
40	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}	40	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
41	CONFIGURE_ARGS+=--without-mysql	41	CONFIGURE_ARGS+=--without-mysql
Lines 50-56 Link Here
50	@${ECHO} ""	50	@${ECHO} ""
51	@${ECHO} "You may use the following build options:"	51	@${ECHO} "You may use the following build options:"
52	@${ECHO} ""	52	@${ECHO} ""
53	@${ECHO} " WITH_PGSQL=yes Build with PostgreSQL support"	53	@${ECHO} " WITH_POSTGRESQL=yes Build with PostgreSQL support"
54	@${ECHO} " WITH_ALIAS=yes Enable server side aliases"	54	@${ECHO} " WITH_ALIAS=yes Enable server side aliases"
55	@${ECHO} " WITH_OPENSSL=yes Enable OpenSSL (needed if MySQL is linked with OpenSSL)"	55	@${ECHO} " WITH_OPENSSL=yes Enable OpenSSL (needed if MySQL is linked with OpenSSL)"
56	@${ECHO} ""	56	@${ECHO} ""

Lines 50-56 Link Here

(-)finance/qhacc/Makefile (-2 / +2 lines)
50	PLIST_SUB+= MYSQL="@comment "	50	PLIST_SUB+= MYSQL="@comment "
51	.endif	51	.endif
52		52
53	.if defined(WITH_PGSQL)	53	.if defined(WITH_POSTGRESQL)
54	POSTGRESQL_PORT?= databases/postgresql7	54	POSTGRESQL_PORT?= databases/postgresql7
55	LIB_DEPENDS+= pq:${PORTSDIR}/${POSTGRESQL_PORT}	55	LIB_DEPENDS+= pq:${PORTSDIR}/${POSTGRESQL_PORT}
56	CONFIGURE_ARGS+= --enable-psql	56	CONFIGURE_ARGS+= --enable-psql
Lines 74-80 Link Here
74	@${ECHO_MSG} "QHacc has the following tunable option(s):"	74	@${ECHO_MSG} "QHacc has the following tunable option(s):"
75	@${ECHO_MSG}	75	@${ECHO_MSG}
76	@${ECHO_MSG} " WITH_MYSQL=yes Turns on MySQL support"	76	@${ECHO_MSG} " WITH_MYSQL=yes Turns on MySQL support"
77	@${ECHO_MSG} " WITH_PGSQL=yes Turns on PostgreSQL support"	77	@${ECHO_MSG} " WITH_POSTGRESQL=yes Turns on PostgreSQL support"
78	@${ECHO_MSG} " WITH_SQLITE=yes Turns on SQLite support"	78	@${ECHO_MSG} " WITH_SQLITE=yes Turns on SQLite support"
79	@${ECHO_MSG}	79	@${ECHO_MSG}
80		80




.endif

# postgresql support requested?
.if defined(WITH_POSTGRESQL)
POSTGRESQL_PORT?=	databases/postgresql7
LIB_DEPENDS+=	pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
CONFIGURE_ARGS+=	--with-pgsql

.endif

# if mysql or ldap are disabled, enable pam
.if !defined(WITH_LDAP) && !defined(WITH_MYSQL) && !defined(WITH_POSTGRESQL)
CONFIGURE_ARGS+=	--with-pam
.endif


	@${ECHO_MSG} "You can use the following additional options:"
	@${ECHO_MSG} "WITH_LDAP=1           - Support for users in LDAP directories"
	@${ECHO_MSG} "WITH_MYSQL=1          - Support for users in MySQL databases"
	@${ECHO_MSG} "WITH_POSTGRESQL=1     - Support for users in PostgreSQL databases"
	@${ECHO_MSG} "WITH_PRIVSEP=1        - Enable privilege separation"
	@${ECHO_MSG} "WITH_LANG=lang        - Enable compilation of language support, lang is one of"
	@${ECHO_MSG} "  english, german, romanian, french, french-funny, polish, spanish,"

Lines 22-28 Link Here

(-)mail/dbmail/Makefile (-2 / +2 lines)
22	USE_GMAKE= YES	22	USE_GMAKE= YES
23	USE_OPENSSL= YES	23	USE_OPENSSL= YES
24		24
25	.if defined(WITH_PGSQL)	25	.if defined(WITH_POSTGRESQL)
26	CONFIGURE_ARGS+= --with-pgsql	26	CONFIGURE_ARGS+= --with-pgsql
27	LIB_DEPENDS+= pq:${PORTSDIR}/databases/postgresql-client	27	LIB_DEPENDS+= pq:${PORTSDIR}/databases/postgresql-client
28	DATABASE= postgresql	28	DATABASE= postgresql
Lines 51-57 Link Here
51	@${ECHO} "You may use the following build options:"	51	@${ECHO} "You may use the following build options:"
52	@${ECHO} " By default dbmail uses MySQL backend database."	52	@${ECHO} " By default dbmail uses MySQL backend database."
53	@${ECHO} " To build dbmail with PostgreSQL as backend database,"	53	@${ECHO} " To build dbmail with PostgreSQL as backend database,"
54	@${ECHO} " define WITH_PGSQL"	54	@${ECHO} " define WITH_POSTGRESQL"
55	@${ECHO} ""	55	@${ECHO} ""
56		56
57	post-patch:	57	post-patch:




.endif

## PostgreSQL Support
OPTIONS+=	POSTGRESQL  "PostgreSQL support" off
#
# PostgreSQL is a powerful SQL database that
# can be used to store user tables.
#
.if defined(WITH_POSTGRESQL)
LIB_DEPENDS+=		pq.3:${PORTSDIR}/databases/postgresql7
CONFIGURE_ARGS+=	--with-pgsql
.endif




# email content scanner support.
#WITHOUT_EXISCAN=	yes

# Define WITH_TCP_WRAPPERS, WITH_MYSQL, and WITH_POSTGRESQL to link against
# libwrap, libmysqlclient and libpq respectively.  Define
# WITH_SASLAUTHD to enable use of the Cyrus SASL authentication daemon.
# Define WITH_MYSQL_VER to specify a particular version of MySQL to

#WITH_TCP_WRAPPERS=	yes
#WITH_MYSQL=		yes
#WITH_MYSQL_VER=	40
#WITH_POSTGRESQL=	yes
#WITH_SASLAUTHD=	yes

# As an alternative to WITH_SASLAUTHD, you can define WITH_PWCHECK to

SEDLIST+=	-e 's,^\# AUTH_SPA=,AUTH_SPA=,'
.endif

.if defined(WITH_POSTGRESQL)
LIB_DEPENDS+=	pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
SEDLIST+=	-e 's,XX_PGSQL_LIBS_XX,-L${LOCALBASE}/lib -lpq,' \
		-e 's,XX_PGSQL_INCLUDE_XX,-I${LOCALBASE}/include/pgsql,' \

SEDLIST+=	-e 's,XX_PGSQL_[^ ]*_XX,,'
.endif

.if !defined(WITH_POSTGRESQL) && !defined(WITH_MYSQL) && !defined(LDAP_LIB_TYPE) && \
    ${WITH_BDB_VER} == 1
SEDLIST+=	-e 's,^LOOKUP_LIBS=,\#LOOKUP_LIBS=,' \
		-e 's,^LOOKUP_INCLUDE=,\#LOOKUP_INCLUDE=,'




# XFree86 to be installed if it is not present.
#WITH_EXIMON=	yes

# Define WITH_TCP_WRAPPERS, WITH_LDAP, WITH_MYSQL, and WITH_POSTGRESQL to
# link against libwrap, an LDAP library (see below), liblibmysqlclient
# and libpq respectively.
#WITH_TCP_WRAPPERS=	yes
#WITH_LDAP=		yes
#WITH_MYSQL=		yes
#WITH_POSTGRESQL=	yes

# Define WITHOUT_IPV6 to exclude IPv6 support from the compiled exim
# binary.  Exim compiled with IPv6 support will still operate on

SEDLIST+=	-e 's,^\# AUTH_PLAINTEXT=,AUTH_PLAINTEXT=,'
.endif

.if defined(WITH_POSTGRESQL)
LIB_DEPENDS+=	pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
SEDLIST+=	-e 's,XX_PGSQL_LIBS_XX,-L${LOCALBASE}/lib -lpq,' \
		-e 's,XX_PGSQL_INCLUDE_XX,-I${LOCALBASE}/include/pgsql,' \

SEDLIST+=	-e 's,^\# HAVE_IPV6=,HAVE_IPV6=,'
.endif

.if !defined(WITH_POSTGRESQL) && !defined(WITH_MYSQL) && !defined(WITH_LDAP)
SEDLIST+=	-e 's,^LOOKUP_LIBS=,\#LOOKUP_LIBS=,' \
		-e 's,^LOOKUP_INCLUDE=,\#LOOKUP_INCLUDE=,'
.endif

Lines 40-46 Link Here

(-)mail/perdition/Makefile (-2 / +2 lines)
40	## WITH_GDBM: Enable gdbm database backend	40	## WITH_GDBM: Enable gdbm database backend
41	## WITH_MYSQL: Enable MySQL database backend	41	## WITH_MYSQL: Enable MySQL database backend
42	## WITH_NIS: Enable NIS database backend	42	## WITH_NIS: Enable NIS database backend
43	## WITH_PGSQL: Enable PostgreSQL database backend	43	## WITH_POSTGRESQL: Enable PostgreSQL database backend
44	## WITH_ODBC: Enable ODBC database backend	44	## WITH_ODBC: Enable ODBC database backend
45	## WITH_OPENLDAP: Enable OpenLDAP database backend	45	## WITH_OPENLDAP: Enable OpenLDAP database backend
46	##	46	##
Lines 110-116 Link Here
110	PLIST_SUB+= MYSQL="@comment "	110	PLIST_SUB+= MYSQL="@comment "
111	.endif	111	.endif
112		112
113	.if defined(WITH_PGSQL)	113	.if defined(WITH_POSTGRESQL)
114	CONFIGURE_ARGS+= --enable-pg	114	CONFIGURE_ARGS+= --enable-pg
115	LIB_DEPENDS+= pq:${PORTSDIR}/databases/postgresql7	115	LIB_DEPENDS+= pq:${PORTSDIR}/databases/postgresql7
116	PLIST_SUB+= PGSQL=""	116	PLIST_SUB+= PGSQL=""

Lines 60-69 Link Here

(-)mail/teapop/Makefile (-2 / +2 lines)
60	## Authentication backend	60	## Authentication backend
61	## WITH_OPENLDAP: add support for authentication through OpenLDAP server	61	## WITH_OPENLDAP: add support for authentication through OpenLDAP server
62	## WITH_MYSQL: enable support for authentication from MySQL database	62	## WITH_MYSQL: enable support for authentication from MySQL database
63	## WITH_PGSQL: enable support for authentication from PostgreSQL database	63	## WITH_POSTGRESQL: enable support for authentication from PostgreSQL database
64	##	64	##
65		65
66	.if defined(WITH_PGSQL)	66	.if defined(WITH_POSTGRESQL)
67	CONFIGURE_ARGS+= --with-pgsql	67	CONFIGURE_ARGS+= --with-pgsql
68	LIB_DEPENDS+= pq:${PORTSDIR}/databases/postgresql7	68	LIB_DEPENDS+= pq:${PORTSDIR}/databases/postgresql7
69	.endif	69	.endif

Lines 62-71 Link Here

(-)mail/teapop-devel/Makefile (-2 / +2 lines)
62	## Authentication backend	62	## Authentication backend
63	## WITH_OPENLDAP: add support for authentication through OpenLDAP server	63	## WITH_OPENLDAP: add support for authentication through OpenLDAP server
64	## WITH_MYSQL: enable support for authentication from MySQL database	64	## WITH_MYSQL: enable support for authentication from MySQL database
65	## WITH_PGSQL: enable support for authentication from PostgreSQL database	65	## WITH_POSTGRESQL: enable support for authentication from PostgreSQL database
66	##	66	##
67		67
68	.if defined(WITH_PGSQL)	68	.if defined(WITH_POSTGRESQL)
69	CONFIGURE_ARGS+= --with-pgsql	69	CONFIGURE_ARGS+= --with-pgsql
70	LIB_DEPENDS+= pq:${PORTSDIR}/databases/postgresql7	70	LIB_DEPENDS+= pq:${PORTSDIR}/databases/postgresql7
71	.endif	71	.endif




CONFIGURE_ARGS+=--enable-debug
.endif

.if defined(WITH_POSTGRESQL)
LIB_DEPENDS+=	pq.3:${PORTSDIR}/databases/postgresql-client
CONFIGURE_ARGS+=--with-pgsql=${LOCALBASE}/include:${LOCALBASE}/lib
STORAGE+=	pgsql

pre-everything::
	@${ECHO}
	@${ECHO} "You can build Jabber with the following options:"
	@${ECHO} "WITH_POSTGRESQL  use PostgreSQL for storage and authentication"
	@${ECHO} "WITH_BDB	   use Berkeley DB for storage and authentication"
	@${ECHO} "WITH_MYSQL	   use MySQL for storage and authentication"
	@${ECHO} "WITH_LDAP	   use LDAP for authentication"
	@${ECHO}

pre-install:

Lines 24-30 Link Here

(-)net/pmacct/Makefile (-1 / +1 lines)
24	PLIST_SUB+= WITH_MYSQL="@comment "	24	PLIST_SUB+= WITH_MYSQL="@comment "
25	.endif	25	.endif
26		26
27	.if defined(WITH_PGSQL)	27	.if defined(WITH_POSTGRESQL)
28	LIB_DEPENDS+= pq.3:${PORTSDIR}/databases/postgresql7	28	LIB_DEPENDS+= pq.3:${PORTSDIR}/databases/postgresql7
29	CONFIGURE_ARGS+=--enable-pgsql	29	CONFIGURE_ARGS+=--enable-pgsql
30	PLIST_SUB+= WITH_PGSQL=""	30	PLIST_SUB+= WITH_PGSQL=""

Lines 19-25 Link Here

(-)security/audit/Makefile (-2 / +2 lines)
19	.if defined(WITH_MYSQL)	19	.if defined(WITH_MYSQL)
20	LIB_DEPENDS+= mysqlclient.10:${PORTSDIR}/databases/mysql323-client	20	LIB_DEPENDS+= mysqlclient.10:${PORTSDIR}/databases/mysql323-client
21	.endif	21	.endif
22	.if defined(WITH_PGSQL)	22	.if defined(WITH_POSTGRESQL)
23	POSTGRESQL_PORT?= databases/postgresql7	23	POSTGRESQL_PORT?= databases/postgresql7
24	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}	24	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
25	.endif	25	.endif
Lines 39-45 Link Here
39	.else	39	.else
40	PLIST_SUB+= MYSQL='@comment '	40	PLIST_SUB+= MYSQL='@comment '
41	.endif	41	.endif
42	.if defined(WITH_PGSQL)	42	.if defined(WITH_POSTGRESQL)
43	CONFIGURE_ARGS+= --with-pgsql \	43	CONFIGURE_ARGS+= --with-pgsql \
44	--with-pgsql-libdir=${LOCALBASE}/lib \	44	--with-pgsql-libdir=${LOCALBASE}/lib \
45	--with-pgsql-incdir=${LOCALBASE}/include	45	--with-pgsql-incdir=${LOCALBASE}/include




CONFIGURE_ARGS+=--with-mysql=${PREFIX}
.endif

.if defined(WITH_POSTGRESQL)
POSTGRESQL_PORT?=	databases/postgresql-client
LIB_DEPENDS+=	pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
CONFIGURE_ARGS+=--with-pgsql=${PREFIX}
.endif

.if defined(WITH_MYSQL) || defined(WITH_POSTGRESQL)
CONFIGURE_ARGS+=--enable-sql
.else
SQL=	"@comment "




.if defined(WITH_MYSQL)
LIB_DEPENDS+=	mysqlclient.10:${PORTSDIR}/databases/mysql323-client
.endif
.if defined(WITH_POSTGRESQL)
POSTGRESQL_PORT?=	databases/postgresql7
LIB_DEPENDS+=	pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
.endif

.if !defined(WITH_MYSQL)
CONFIGURE_ARGS+=	--without-mysql
.endif
.if !defined(WITH_POSTGRESQL)
CONFIGURE_ARGS+=	--without-pgsql
.endif


.if defined(WITH_MYSQL)
MAN8+=	om_mysql.8
.endif
.if defined(WITH_POSTGRESQL)
MAN8+=	om_pgsql.8
.endif
MANCOMPRESSED=	yes

Lines 19-25 Link Here

(-)www/mod_accounting/Makefile (-2 / +2 lines)
19		19
20	MAKE_ARGS+= APXS="${APXS}"	20	MAKE_ARGS+= APXS="${APXS}"
21		21
22	.if defined(WITHOUT_PGSQL)	22	.if defined(WITHOUT_POSTGRESQL)
23	MAKE_ARGS+= WITHOUT_PGSQL=YES	23	MAKE_ARGS+= WITHOUT_PGSQL=YES
24	.else	24	.else
25	LIB_DEPENDS+= pq.3:${PORTSDIR}/databases/postgresql7	25	LIB_DEPENDS+= pq.3:${PORTSDIR}/databases/postgresql7
Lines 36-42 Link Here
36	pre-everything::	36	pre-everything::
37	@${ECHO} ""	37	@${ECHO} ""
38	@${ECHO} " WITHOUT_MYSQL Disable MySQL support"	38	@${ECHO} " WITHOUT_MYSQL Disable MySQL support"
39	@${ECHO} " WITHOUT_PGSQL Disable PostgreSQL support"	39	@${ECHO} " WITHOUT_POSTGRESQL Disable PostgreSQL support"
40	@${ECHO} ""	40	@${ECHO} ""
41		41
42	post-install:	42	post-install:

Lines 26-32 Link Here

(-)www/udmsearch/Makefile (-2 / +2 lines)
26	--sysconfdir=${PREFIX}/etc/udmsearch \	26	--sysconfdir=${PREFIX}/etc/udmsearch \
27	--localstatedir=/var/udmsearch	27	--localstatedir=/var/udmsearch
28		28
29	.if defined(WITH_PGSQL)	29	.if defined(WITH_POSTGRESQL)
30	POSTGRESQL_PORT?= databases/postgresql7	30	POSTGRESQL_PORT?= databases/postgresql7
31	LIB_DEPENDS= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}	31	LIB_DEPENDS= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
32	CONFIGURE_ARGS+= --with-pgsql=${LOCALBASE}/pgsql	32	CONFIGURE_ARGS+= --with-pgsql=${LOCALBASE}/pgsql
Lines 47-53 Link Here
47	@${ECHO_MSG}	47	@${ECHO_MSG}
48	@${ECHO_MSG} "You may alternately build udmsearch with either msql or"	48	@${ECHO_MSG} "You may alternately build udmsearch with either msql or"
49	@${ECHO_MSG} "postgresql support by invoking make with WITH_MSQL=yes or"	49	@${ECHO_MSG} "postgresql support by invoking make with WITH_MSQL=yes or"
50	@${ECHO_MSG} "WITH_PGSQL=yes respectively."	50	@${ECHO_MSG} "WITH_POSTGRESQL=yes respectively."
51	@${ECHO_MSG}	51	@${ECHO_MSG}
52	.endif	52	.endif

Return to bug 63176

Lines 78-84 Link Here

(-)mail/exim/Makefile (-4 / +4 lines)
78	# email content scanner support.	78	# email content scanner support.
79	#WITHOUT_EXISCAN= yes	79	#WITHOUT_EXISCAN= yes
80		80
81	# Define WITH_TCP_WRAPPERS, WITH_MYSQL, and WITH_PGSQL to link against	81	# Define WITH_TCP_WRAPPERS, WITH_MYSQL, and WITH_POSTGRESQL to link against
82	# libwrap, libmysqlclient and libpq respectively. Define	82	# libwrap, libmysqlclient and libpq respectively. Define
83	# WITH_SASLAUTHD to enable use of the Cyrus SASL authentication daemon.	83	# WITH_SASLAUTHD to enable use of the Cyrus SASL authentication daemon.
84	# Define WITH_MYSQL_VER to specify a particular version of MySQL to	84	# Define WITH_MYSQL_VER to specify a particular version of MySQL to
Lines 87-93 Link Here
87	#WITH_TCP_WRAPPERS= yes	87	#WITH_TCP_WRAPPERS= yes
88	#WITH_MYSQL= yes	88	#WITH_MYSQL= yes
89	#WITH_MYSQL_VER= 40	89	#WITH_MYSQL_VER= 40
90	#WITH_PGSQL= yes	90	#WITH_POSTGRESQL= yes
91	#WITH_SASLAUTHD= yes	91	#WITH_SASLAUTHD= yes
92		92
93	# As an alternative to WITH_SASLAUTHD, you can define WITH_PWCHECK to	93	# As an alternative to WITH_SASLAUTHD, you can define WITH_PWCHECK to
Lines 300-306 Link Here
300	SEDLIST+= -e 's,^\# AUTH_SPA=,AUTH_SPA=,'	300	SEDLIST+= -e 's,^\# AUTH_SPA=,AUTH_SPA=,'
301	.endif	301	.endif
302		302
303	.if defined(WITH_PGSQL)	303	.if defined(WITH_POSTGRESQL)
304	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}	304	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
305	SEDLIST+= -e 's,XX_PGSQL_LIBS_XX,-L${LOCALBASE}/lib -lpq,' \	305	SEDLIST+= -e 's,XX_PGSQL_LIBS_XX,-L${LOCALBASE}/lib -lpq,' \
306	-e 's,XX_PGSQL_INCLUDE_XX,-I${LOCALBASE}/include/pgsql,' \	306	-e 's,XX_PGSQL_INCLUDE_XX,-I${LOCALBASE}/include/pgsql,' \
Lines 309-315 Link Here
309	SEDLIST+= -e 's,XX_PGSQL_[^ ]*_XX,,'	309	SEDLIST+= -e 's,XX_PGSQL_[^ ]*_XX,,'
310	.endif	310	.endif
311		311
312	.if !defined(WITH_PGSQL) && !defined(WITH_MYSQL) && !defined(LDAP_LIB_TYPE) && \	312	.if !defined(WITH_POSTGRESQL) && !defined(WITH_MYSQL) && !defined(LDAP_LIB_TYPE) && \
313	${WITH_BDB_VER} == 1	313	${WITH_BDB_VER} == 1
314	SEDLIST+= -e 's,^LOOKUP_LIBS=,\#LOOKUP_LIBS=,' \	314	SEDLIST+= -e 's,^LOOKUP_LIBS=,\#LOOKUP_LIBS=,' \
315	-e 's,^LOOKUP_INCLUDE=,\#LOOKUP_INCLUDE=,'	315	-e 's,^LOOKUP_INCLUDE=,\#LOOKUP_INCLUDE=,'

Lines 88-100 Link Here

(-)security/cyrus-sasl2/Makefile (-2 / +2 lines)
88	CONFIGURE_ARGS+=--with-mysql=${PREFIX}	88	CONFIGURE_ARGS+=--with-mysql=${PREFIX}
89	.endif	89	.endif
90		90
91	.if defined(WITH_PGSQL)	91	.if defined(WITH_POSTGRESQL)
92	POSTGRESQL_PORT?= databases/postgresql-client	92	POSTGRESQL_PORT?= databases/postgresql-client
93	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}	93	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
94	CONFIGURE_ARGS+=--with-pgsql=${PREFIX}	94	CONFIGURE_ARGS+=--with-pgsql=${PREFIX}
95	.endif	95	.endif
96		96
97	.if defined(WITH_MYSQL) \|\| defined(WITH_PGSQL)	97	.if defined(WITH_MYSQL) \|\| defined(WITH_POSTGRESQL)
98	CONFIGURE_ARGS+=--enable-sql	98	CONFIGURE_ARGS+=--enable-sql
99	.else	99	.else
100	SQL= "@comment "	100	SQL= "@comment "

Lines 66-72 Link Here

(-)comms/gnokii/Makefile (-3 / +3 lines)
66	.if exists(${LOCALBASE}/lib/libpq.so)	66	.if exists(${LOCALBASE}/lib/libpq.so)
67	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}	67	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
68	PLIST_SUB+= PGM=''	68	PLIST_SUB+= PGM=''
69	WITH_PGSQL= yes	69	WITH_POSTGRESQL= yes
70	.else	70	.else
71	PLIST_SUB+= PGM='@comment '	71	PLIST_SUB+= PGM='@comment '
72	.endif	72	.endif
Lines 111-117 Link Here
111	.if defined(WITH_MYSQL)	111	.if defined(WITH_MYSQL)
112	@cd ${WRKSRC}/smsd && ${GMAKE} libmysql.la LOCALBASE=${LOCALBASE}	112	@cd ${WRKSRC}/smsd && ${GMAKE} libmysql.la LOCALBASE=${LOCALBASE}
113	.endif	113	.endif
114	.if defined(WITH_PGSQL)	114	.if defined(WITH_POSTGRESQL)
115	@cd ${WRKSRC}/smsd && ${GMAKE} libpq.la LOCALBASE=${LOCALBASE}	115	@cd ${WRKSRC}/smsd && ${GMAKE} libpq.la LOCALBASE=${LOCALBASE}
116	.endif	116	.endif
117	.endif	117	.endif
Lines 135-141 Link Here
135	.if defined(WITH_MYSQL)	135	.if defined(WITH_MYSQL)
136	${INSTALL_DATA} ${WRKSRC}/smsd/sms.tables.mysql.sql ${PREFIX}/share/smsd/sms.tables.mysql.sql	136	${INSTALL_DATA} ${WRKSRC}/smsd/sms.tables.mysql.sql ${PREFIX}/share/smsd/sms.tables.mysql.sql
137	.endif	137	.endif
138	.if defined(WITH_PGSQL)	138	.if defined(WITH_POSTGRESQL)
139	${INSTALL_DATA} ${WRKSRC}/smsd/sms.tables.pq.sql ${PREFIX}/share/smsd/sms.tables.pq.sql	139	${INSTALL_DATA} ${WRKSRC}/smsd/sms.tables.pq.sql ${PREFIX}/share/smsd/sms.tables.pq.sql
140	.endif	140	.endif
141	.endif	141	.endif

Lines 51-57 Link Here

(-)ftp/pure-ftpd/Makefile (-3 / +3 lines)
51	.endif	51	.endif
52		52
53	# postgresql support requested?	53	# postgresql support requested?
54	.if defined(WITH_PGSQL)	54	.if defined(WITH_POSTGRESQL)
55	POSTGRESQL_PORT?= databases/postgresql7	55	POSTGRESQL_PORT?= databases/postgresql7
56	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}	56	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
57	CONFIGURE_ARGS+= --with-pgsql	57	CONFIGURE_ARGS+= --with-pgsql
Lines 63-69 Link Here
63	.endif	63	.endif
64		64
65	# if mysql or ldap are disabled, enable pam	65	# if mysql or ldap are disabled, enable pam
66	.if !defined(WITH_LDAP) && !defined(WITH_MYSQL) && !defined(WITH_PGSQL)	66	.if !defined(WITH_LDAP) && !defined(WITH_MYSQL) && !defined(WITH_POSTGRESQL)
67	CONFIGURE_ARGS+= --with-pam	67	CONFIGURE_ARGS+= --with-pam
68	.endif	68	.endif
69		69
Lines 97-103 Link Here
97	@${ECHO_MSG} "You can use the following additional options:"	97	@${ECHO_MSG} "You can use the following additional options:"
98	@${ECHO_MSG} "WITH_LDAP=1 - Support for users in LDAP directories"	98	@${ECHO_MSG} "WITH_LDAP=1 - Support for users in LDAP directories"
99	@${ECHO_MSG} "WITH_MYSQL=1 - Support for users in MySQL databases"	99	@${ECHO_MSG} "WITH_MYSQL=1 - Support for users in MySQL databases"
100	@${ECHO_MSG} "WITH_PGSQL=1 - Support for users in PostgreSQL databases"	100	@${ECHO_MSG} "WITH_POSTGRESQL=1 - Support for users in PostgreSQL databases"
101	@${ECHO_MSG} "WITH_PRIVSEP=1 - Enable privilege separation"	101	@${ECHO_MSG} "WITH_PRIVSEP=1 - Enable privilege separation"
102	@${ECHO_MSG} "WITH_LANG=lang - Enable compilation of language support, lang is one of"	102	@${ECHO_MSG} "WITH_LANG=lang - Enable compilation of language support, lang is one of"
103	@${ECHO_MSG} " english, german, romanian, french, french-funny, polish, spanish,"	103	@${ECHO_MSG} " english, german, romanian, french, french-funny, polish, spanish,"

Lines 74-85 Link Here

(-)mail/dovecot/Makefile (-2 / +2 lines)
74	.endif	74	.endif
75		75
76	## PostgreSQL Support	76	## PostgreSQL Support
77	OPTIONS+= PGSQL "PostgreSQL support" off	77	OPTIONS+= POSTGRESQL "PostgreSQL support" off
78	#	78	#
79	# PostgreSQL is a powerful SQL database that	79	# PostgreSQL is a powerful SQL database that
80	# can be used to store user tables.	80	# can be used to store user tables.
81	#	81	#
82	.if defined(WITH_PGSQL)	82	.if defined(WITH_POSTGRESQL)
83	LIB_DEPENDS+= pq.3:${PORTSDIR}/databases/postgresql7	83	LIB_DEPENDS+= pq.3:${PORTSDIR}/databases/postgresql7
84	CONFIGURE_ARGS+= --with-pgsql	84	CONFIGURE_ARGS+= --with-pgsql
85	.endif	85	.endif

Lines 38-50 Link Here

(-)mail/exim-old/Makefile (-4 / +4 lines)
38	# XFree86 to be installed if it is not present.	38	# XFree86 to be installed if it is not present.
39	#WITH_EXIMON= yes	39	#WITH_EXIMON= yes
40		40
41	# Define WITH_TCP_WRAPPERS, WITH_LDAP, WITH_MYSQL, and WITH_PGSQL to	41	# Define WITH_TCP_WRAPPERS, WITH_LDAP, WITH_MYSQL, and WITH_POSTGRESQL to
42	# link against libwrap, an LDAP library (see below), liblibmysqlclient	42	# link against libwrap, an LDAP library (see below), liblibmysqlclient
43	# and libpq respectively.	43	# and libpq respectively.
44	#WITH_TCP_WRAPPERS= yes	44	#WITH_TCP_WRAPPERS= yes
45	#WITH_LDAP= yes	45	#WITH_LDAP= yes
46	#WITH_MYSQL= yes	46	#WITH_MYSQL= yes
47	#WITH_PGSQL= yes	47	#WITH_POSTGRESQL= yes
48		48
49	# Define WITHOUT_IPV6 to exclude IPv6 support from the compiled exim	49	# Define WITHOUT_IPV6 to exclude IPv6 support from the compiled exim
50	# binary. Exim compiled with IPv6 support will still operate on	50	# binary. Exim compiled with IPv6 support will still operate on
Lines 158-164 Link Here
158	SEDLIST+= -e 's,^\# AUTH_PLAINTEXT=,AUTH_PLAINTEXT=,'	158	SEDLIST+= -e 's,^\# AUTH_PLAINTEXT=,AUTH_PLAINTEXT=,'
159	.endif	159	.endif
160		160
161	.if defined(WITH_PGSQL)	161	.if defined(WITH_POSTGRESQL)
162	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}	162	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
163	SEDLIST+= -e 's,XX_PGSQL_LIBS_XX,-L${LOCALBASE}/lib -lpq,' \	163	SEDLIST+= -e 's,XX_PGSQL_LIBS_XX,-L${LOCALBASE}/lib -lpq,' \
164	-e 's,XX_PGSQL_INCLUDE_XX,-I${LOCALBASE}/include/pgsql,' \	164	-e 's,XX_PGSQL_INCLUDE_XX,-I${LOCALBASE}/include/pgsql,' \
Lines 171-177 Link Here
171	SEDLIST+= -e 's,^\# HAVE_IPV6=,HAVE_IPV6=,'	171	SEDLIST+= -e 's,^\# HAVE_IPV6=,HAVE_IPV6=,'
172	.endif	172	.endif
173		173
174	.if !defined(WITH_PGSQL) && !defined(WITH_MYSQL) && !defined(WITH_LDAP)	174	.if !defined(WITH_POSTGRESQL) && !defined(WITH_MYSQL) && !defined(WITH_LDAP)
175	SEDLIST+= -e 's,^LOOKUP_LIBS=,\#LOOKUP_LIBS=,' \	175	SEDLIST+= -e 's,^LOOKUP_LIBS=,\#LOOKUP_LIBS=,' \
176	-e 's,^LOOKUP_INCLUDE=,\#LOOKUP_INCLUDE=,'	176	-e 's,^LOOKUP_INCLUDE=,\#LOOKUP_INCLUDE=,'
177	.endif	177	.endif

Lines 32-38 Link Here

(-)net/jabberd/Makefile (-5 / +5 lines)
32	CONFIGURE_ARGS+=--enable-debug	32	CONFIGURE_ARGS+=--enable-debug
33	.endif	33	.endif
34		34
35	.if defined(WITH_PGSQL)	35	.if defined(WITH_POSTGRESQL)
36	LIB_DEPENDS+= pq.3:${PORTSDIR}/databases/postgresql-client	36	LIB_DEPENDS+= pq.3:${PORTSDIR}/databases/postgresql-client
37	CONFIGURE_ARGS+=--with-pgsql=${LOCALBASE}/include:${LOCALBASE}/lib	37	CONFIGURE_ARGS+=--with-pgsql=${LOCALBASE}/include:${LOCALBASE}/lib
38	STORAGE+= pgsql	38	STORAGE+= pgsql
Lines 64-73 Link Here
64	pre-everything::	64	pre-everything::
65	@${ECHO}	65	@${ECHO}
66	@${ECHO} "You can build Jabber with the following options:"	66	@${ECHO} "You can build Jabber with the following options:"
67	@${ECHO} "WITH_PGSQL use PostgreSQL for storage and authentication"	67	@${ECHO} "WITH_POSTGRESQL use PostgreSQL for storage and authentication"
68	@${ECHO} "WITH_BDB use Berkeley DB for storage and authentication"	68	@${ECHO} "WITH_BDB use Berkeley DB for storage and authentication"
69	@${ECHO} "WITH_MYSQL use MySQL for storage and authentication"	69	@${ECHO} "WITH_MYSQL use MySQL for storage and authentication"
70	@${ECHO} "WITH_LDAP use LDAP for authentication"	70	@${ECHO} "WITH_LDAP use LDAP for authentication"
71	@${ECHO}	71	@${ECHO}
72		72
73	pre-install:	73	pre-install:

Lines 20-26 Link Here

(-)sysutils/msyslog/Makefile (-3 / +3 lines)
20	.if defined(WITH_MYSQL)	20	.if defined(WITH_MYSQL)
21	LIB_DEPENDS+= mysqlclient.10:${PORTSDIR}/databases/mysql323-client	21	LIB_DEPENDS+= mysqlclient.10:${PORTSDIR}/databases/mysql323-client
22	.endif	22	.endif
23	.if defined(WITH_PGSQL)	23	.if defined(WITH_POSTGRESQL)
24	POSTGRESQL_PORT?= databases/postgresql7	24	POSTGRESQL_PORT?= databases/postgresql7
25	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}	25	LIB_DEPENDS+= pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
26	.endif	26	.endif
Lines 32-38 Link Here
32	.if !defined(WITH_MYSQL)	32	.if !defined(WITH_MYSQL)
33	CONFIGURE_ARGS+= --without-mysql	33	CONFIGURE_ARGS+= --without-mysql
34	.endif	34	.endif
35	.if !defined(WITH_PGSQL)	35	.if !defined(WITH_POSTGRESQL)
36	CONFIGURE_ARGS+= --without-pgsql	36	CONFIGURE_ARGS+= --without-pgsql
37	.endif	37	.endif
38		38
Lines 42-48 Link Here
42	.if defined(WITH_MYSQL)	42	.if defined(WITH_MYSQL)
43	MAN8+= om_mysql.8	43	MAN8+= om_mysql.8
44	.endif	44	.endif
45	.if defined(WITH_PGSQL)	45	.if defined(WITH_POSTGRESQL)
46	MAN8+= om_pgsql.8	46	MAN8+= om_pgsql.8
47	.endif	47	.endif
48	MANCOMPRESSED= yes	48	MANCOMPRESSED= yes