Attachment #52346 for bug #79337

View | Details | Raw Unified | Return to bug 79337
Collapse All | Expand All

Lines 66-72 Link Here

(-)./databases/clip/Makefile (-2 / +2 lines)
66	PLIST_SUB+= PGSQL="@comment "	66	PLIST_SUB+= PGSQL="@comment "
67	.endif	67	.endif
68		68
69	.if defined(WITH_FIREBIRD) \|\| exists(${LOCALBASE}/firebird/include/ibase.h)	69	.if defined(WITH_FIREBIRD) \|\| exists(${LOCALBASE}/include/ibase.h)
70	LIB_DEPENDS+= gds.1:${PORTSDIR}/${FIREBIRD_PORT}	70	LIB_DEPENDS+= gds.1:${PORTSDIR}/${FIREBIRD_PORT}
71	PLIST_SUB+= IBASE=""	71	PLIST_SUB+= IBASE=""
72	.else	72	.else
Lines 89-95 Link Here
89		89
90	PKGMESSAGE= ${WRKDIR}/pkg-message	90	PKGMESSAGE= ${WRKDIR}/pkg-message
91		91
92	FIREBIRD_PORT?= databases/firebird	92	FIREBIRD_PORT?= databases/firebird-client
93		93
94	BIN2STRIP= bdbf clip clip_bl clip_blank clip_cld clip_conv clip_dbf2txt \	94	BIN2STRIP= bdbf clip clip_bl clip_blank clip_cld clip_conv clip_dbf2txt \
95	clip_dbg clip_fl clip_hashextract clip_hindex clip_hseek \	95	clip_dbg clip_fl clip_hashextract clip_hindex clip_hseek \

Lines 5-11 Link Here

(-)./databases/clip/files/patch-cliplibs::clip-interbase::Makefile (-1 / +1 lines)
5	#	5	#
6		6
7	-IBROOT=/opt/interbase	7	-IBROOT=/opt/interbase
8	+IBROOT=/usr/local/firebird	8	+IBROOT=/usr/local
9		9
10	ifdef CLIPROOT	10	ifdef CLIPROOT
11	include $(CLIPROOT)/include/Makefile.inc	11	include $(CLIPROOT)/include/Makefile.inc




# New ports collection makefile for:	Firebird
# Date created:		20 December 2000
# Whom:			Geoffrey C. Speicher <geoff@sea-incorporated.com>
#
# $FreeBSD: ports/databases/firebird/Makefile,v 1.36 2005/02/14 17:26:19 vs Exp $
#

PORTNAME=	firebird
PORTVERSION=	1.5.2
CATEGORIES=	databases
MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
MASTER_SITE_SUBDIR=firebird
DISTNAME=	firebird-1.5.2.4731

MAINTAINER=	renato@galle.com.br
COMMENT=	The open-source InterBase(tm) 6.0 spin-off (Classic version)

USE_BISON=	yes
USE_BZIP2=	yes
USE_GMAKE=	yes
GNU_CONFIGURE=	yes
USE_LIBTOOL_VER=	15
USE_AUTOCONF_VER=	259
USE_GCC=	3.4

PLIST_SUB=	FIREBIRD_VERSION=${PORTVERSION}

# Don't use ld for linking, use gcc
LD=	gcc

CONFLICTS=	firebird-devel-[0-9]*

WRKSRC=		${WRKDIR}/${DISTNAME}
INSTALLS_SHLIB=	yes
LDCONFIG_DIRS=	%%PREFIX%%/firebird/lib
MSG_FILE=	${PKGDIR}/pkg-message
PKGMESSAGE=	${WRKDIR}/pkg-message
USE_REINPLACE=	yes

ONLY_FOR_ARCHS=	i386

.include <bsd.port.pre.mk>

pre-everything::
	@${ECHO_MSG} "NOTE: If the work directory is on an NFS mount, you will"
	@${ECHO_MSG} "require NFS client locking support for the build to"
	@${ECHO_MSG} "succeed. Currently this is only available on FreeBSD 5.0"
	@${ECHO_MSG} "or greater."
	@${ECHO_MSG}
	@${ECHO_MSG} "WARNING: The on-disk structure of the databases has"
	@${ECHO_MSG} "changed since version 1.0.x."
	@${ECHO_MSG} "Cancel this installation now and backup your databases"
	@${ECHO_MSG} "if you have not already done so."
.if !defined(BATCH)
	@sleep 10
.endif

patch-autotools:
	@${DO_NADA}

run-autotools:
	@${DO_NADA}

do-configure:
	@(cd ${WRKSRC} && ${SETENV} CC=${CC} CXX=${CXX} MAKE=${GMAKE}	\
	${AUTOTOOLS_VARS} ./autogen.sh --prefix=${PREFIX}/firebird	\
	--with-lock-manager --with-editline)

do-build:
	@(								\
	${SED} 's|%%PREFIX%%|${PREFIX}|g' ${MSG_FILE} > ${PKGMESSAGE};	\
	cd ${WRKSRC};							\
	${SETENV} CC=${CC} CXX=${CXX} ${GMAKE} all;			\
	)

post-install:
	@(								\
	${INSTALL_DATA} ${FILESDIR}/RELNOTES ${PREFIX}/firebird;	\
	${CAT} ${PKGMESSAGE};						\
	)

.include <bsd.port.post.mk>

Lines 1-2 Link Here

(-)./databases/firebird/distinfo (-2 lines)
1	MD5 (firebird-1.5.2.4731.tar.bz2) = fea53ed5213cff4bd96513fb1a6c0ca2
2	SIZE (firebird-1.5.2.4731.tar.bz2) = 4764015




Firebird 1.5.1 FreeBSD Release Notes                    19-Jul-2004
--------------------------------------
FB-V1.5.1.4481 Firebird 1.5 Release

    Welcome to the FreeBSD Firebird port!

    Firebird is installed SUID with owner and group `firebird'.
This does affect where you can and cannot create databases when
connecting remotely, as well as which existing databases you can
access.  If you want a database to be available remotely, be sure
it's readable and writeable to group firebird.

    There may be times when you manage to get your system into a
state where using any of the Firebird utilites (isql, gbak, gsec,
etc.) gives you the message "semget failed".  One surefire way to
do this is to build and install the port.  :)  If this happens,
make sure that the lock manager is not running and its semaphores
have been removed.  The former can be accomplished with 'ps ax
|grep fb' and 'kill'; the latter with 'ipcs -s' and 'ipcrm -s'.

    For example, after building and installing the port, you will
probably go through something like this:

# isql /usr/local/firebird/security.fdb
Statement failed, SQLCODE = -902

operating system directive semget failed
-No such file or directory

# ipcs -s
Semaphores:
T     ID     KEY        MODE       OWNER    GROUP
s 1310720  252034728 --rw-rw-rw-     root    wheel

# ipcrm -s 1310720

and you should be in business.

    Once this is done, you should be able to connect normally to
databases.  Your first connection will restart the lock manager.

    There may be times, however, when you still get "semget failed"
even though the lock manager is not running and the semaphores have
been cleaned up.  There seems to be a conflict with this release
and the PostgreSQL 7 release as installed from the ports collection.
If you're having trouble with Firebird and you're running PostgreSQL,
try stopping PostgreSQL:

	/usr/local/etc/rc.d/pgsql.sh stop

and see if that helps. Alternatively, increase the value of SEMMNS
by 48 in your kernel configuration file. This can be found by getting
the current value with 'sysctl -a | grep semmns'. You can either add
this to your kernel config, or add the following line to /boot/loader.conf:

	kern.ipc.semmns=X

where is is the current value plus 48. If this doesn't resolve the issue,
try adding 48 again. 

    Please note that as of RC8, the libgds.so symlink now points to
libfbembed.so. This has been done to resolve compatability issues with
older versions of Firebird. The FreeBSD port of RC7 had libgds.so
pointing to libfbclient.so. libfbclient.so is a remote access-only
shared library with threaded support, which requires target applications
to link with a threaded library such as libc_r.so, libpthread.so or libthr.so.

    Super Server support in Firebird 1.5 for FreeBSD is not currently
available due to the Firebird code using POSIX threads APIs not available
in FreeBSD 4.x or not yet complete in FreeBSD 5.x. This issue will become
more important once the scalability issues of Super Server have been
resolved.

    This installation has already inserted the necessary line to
/etc/inetd.conf so that you can connect to Firebird across the network.
However you may need to add the remote host to /etc/hosts.equiv. For
example, to allow the local machine to make connections to Firebird
using TCP, the following command needs running:

	echo localhost >> /etc/hosts.equiv

Please note that adding machines to /etc/hosts.equiv can reduce the
security of your system. If in doubt, try connecting to Firebird with
a username and password already defined in security.fdb. For example:

gsec
> add myuser -pass mypass
> quit
isql -u myuser -p mypass localhost:/usr/local/firebird/examples/employee.fdb

This should reduce the need for hosts defined in /etc/hosts.equiv.

    Complete documentation for InterBase(tm) is available (free of
charge) from http://www.interbase.com/ in PDF format.  While
InterBase and Firebird are two distinct entities, all InterBase
documentation is pertinent to Firebird.  More information on Firebird
and InterBase can be found at the following:

	http://sourceforge.net/projects/firebird/
	http://www.ibphoenix.com/
	http://www.interbase2000.org/
	http://www.firebirdsql.org/

    Please also see the doc directory in the Firebird package for
documentation specific to Firebird.

Chris Knight
<chris@e-easy.com.au>

Lines 1-11 Link Here

(-)./databases/firebird/files/patch-src::extern::editline::makelist (-11 lines)
1	--- src/extern/editline/makelist.orig Mon May 24 04:24:25 2004
2	+++ src/extern/editline/makelist Fri Jul 23 17:09:43 2004
3	@@ -145,7 +145,7 @@
4	#
5	-fh)
6	cat $FILES \| $AWK '/el_action_t/ { print $3 }' \| \
7	- sort \| tr '[a-z]' '[A-Z]' \| $AWK '
8	+ sort \| tr '[:lower:]' '[:upper:]' \| $AWK '
9	BEGIN {
10	printf("/* Automatically generated file, do not edit */\n");
11	printf("#ifndef _h_fcns_c\n#define _h_fcns_c\n");




The open-source InterBase(tm) 6.0 spin-off (Classic server version)

InterBase is a world-class DBMS with a history too rich to detail
here.  Once selling for several thousands of dollars per license,
some very big players use it worldwide.  Inprise has open-sourced
InterBase 6.0, and a lively bunch of folks has charged themselves
with seeing that it lives on through the Firebird project.

For more information on Firebird and InterBase, see:

WWW: http://sourceforge.net/projects/firebird/
WWW: http://www.ibphoenix.com/
WWW: http://www.interbase2000.org/
WWW: http://www.interbase.com/
WWW: http://www.firebirdsql.org/




#!/bin/sh

# $FreeBSD: ports/databases/firebird/pkg-install,v 1.9 2004/01/16 18:37:14 clement Exp $

PATH=/bin:/usr/bin:/usr/sbin

case $2 in
PRE-INSTALL)

if [ -d $PKG_PREFIX/firebird ]; then
	if [ -d $PKG_PREFIX/firebird.old ]; then
		rm -rf $PKG_PREFIX/firebird.old
	fi
	cp -Rp $PKG_PREFIX/firebird $PKG_PREFIX/firebird.old
fi

if [ `id -u` -ne 0 ]; then
	echo; echo "You must be root to run this step!"; echo; echo
  exit 1
fi

nofbuid=0
fbUID=`id -u firebird 2>/dev/null`
if [ $? -ne 0 ]; then
	fbUID=90
	while [ ! -z `id -un $fbUID 2>/dev/null` ]
	do
		fbUID=$(($fbUID+1))
	done
	nofbuid=1
fi

fbGID=`pw groupshow firebird 2>/dev/null`
if [ $? -ne 0 ]; then
	fbGID=90
	while [ ! -z `id -gn $fbGID 2>/dev/null` ]
	do
		fbGID=$(($fbGID+1))
	done
	echo "firebird:*:$fbGID:" >> /etc/group
else
	fbGID=`echo $fbGID | awk -F: '{print $3}'`
fi

echo "firebird user using uid $fbUID"
echo "firebird user using gid $fbGID"

if which -s pw; then
	if [ $nofbuid -ne 0 ]; then
		pw useradd firebird -u $fbUID -g $fbGID -h - -s /bin/sh \
		-d $PKG_PREFIX/firebird -c "Firebird Database Administrator"
	fi
else
	echo -n "unable to create user firebird - please create it manually,"
	echo " before reinstalling this package."
	exit 1
fi
;;

POST-INSTALL)
chown -R firebird:firebird $PKG_PREFIX/firebird
chmod -R o= $PKG_PREFIX/firebird

# Now fix up the mess.

# fix up directories
for i in `find $PKG_PREFIX/firebird -print`
do
	FileName=$i
	if [ -d $FileName ]; then
		chmod u=rwx,go=rx $FileName
	fi
done

# make lib ldconfig-compatible
chown -R root:wheel $PKG_PREFIX/firebird/lib

# make the following read-only
chmod -R a=r $PKG_PREFIX/firebird/WhatsNew
for i in `find $PKG_PREFIX/firebird/doc -type f -print`
do
	chmod a=r $i
done
chmod -R a=r $PKG_PREFIX/firebird/examples/*
chmod -R a=r $PKG_PREFIX/firebird/include/*
chmod -R a=r $PKG_PREFIX/firebird/intl/*
#chmod -R a=r $PKG_PREFIX/firebird/misc/*

chmod -R ug=rx,o= $PKG_PREFIX/firebird/UDF/*
chmod -R ug=rx,o= $PKG_PREFIX/firebird/intl/fbintl
chmod -R a=rx $PKG_PREFIX/firebird/lib/*

cd $PKG_PREFIX/firebird/lib
ln -sf libfbembed.so libgds.so
ln -sf libfbembed.so.1 libgds.so.1

cd $PKG_PREFIX/firebird/bin
for i in `ls`
do
	chmod ug=rx,o= $i
done

chmod a=rx isql qli

# SUID is needed for running server programs.
for i in fb_lock_mgr gds_drop fb_inet_server
do
	if [ -f $i ]; then
		chmod ug=rx,o= $i
		chmod ug+s $i
	fi
done


cd $PKG_PREFIX/firebird

# Lock files

for i in isc_init1 isc_lock1 isc_event1
do
	FileName=$i.`hostname`
	touch $FileName
	chmod uga=rw $FileName
	chown firebird:firebird $FileName
done

touch firebird.log
chown firebird:firebird firebird.log
chmod ug=rw,o= firebird.log
chmod a=r firebird.msg README
chown root:wheel *.sample
chmod ug=r,o= *.sample

# make databases writable by firebird only
# local database connections are not a good idea
chmod ug=rw,o= examples/*.fdb
chmod ug=rw,o= help/*.fdb
chmod ug=rw,o= security.fdb

chmod 444 aliases.conf firebird.conf
chmod 660 security.fdb

# remove any existing gds service
cp /etc/services /etc/services.old
cp /etc/inetd.conf /etc/inetd.conf.old
cat /etc/services |grep -v gds_db >/etc/services.new
cat /etc/inetd.conf |grep -v gds_db >/etc/inetd.conf.new
mv /etc/services.new /etc/services
mv /etc/inetd.conf.new /etc/inetd.conf

# add the gds service and restart inetd
cat >>/etc/services <<EOF
gds_db		 3050/tcp  #InterBase Database Remote Protocol
EOF
cat >>/etc/inetd.conf <<EOF
gds_db	stream	tcp	nowait	firebird	$PKG_PREFIX/firebird/bin/fb_inet_server  fb_inet_server
EOF
if [ -f /var/run/inetd.pid ]; then
	kill -HUP `cat /var/run/inetd.pid`
fi

# shared lib startup script
if [ -d $PKG_PREFIX/etc/rc.d ]; then
	(
	echo "#!/bin/sh"; echo "[ -d $PKG_PREFIX/firebird/lib ] && /sbin/ldconfig -m $PKG_PREFIX/firebird/lib"
	) > $PKG_PREFIX/etc/rc.d/000.firebird.sh
  chmod a=rx $PKG_PREFIX/etc/rc.d/000.firebird.sh
fi
;;

esac





---------------------------------------------------------
Firebird is now installed.  A symbolic link from
/usr/interbase -> %%PREFIX%%/firebird may be needed
for compatibility with existing programs that use
Firebird.

The symbolic link can be created with:

% ln -s %%PREFIX%%/firebird /usr/interbase

It is STRONGLY recommended that you change the SYSDBA
password with:

% cd %%PREFIX%%/firebird
% gsec -user SYSDBA -pass masterkey
GSEC> modify SYSDBA -pw newpassword
GSEC> quit

before doing anything serious with Firebird.

See %%PREFIX%%/firebird/RELNOTES for more.
---------------------------------------------------------





etc/rc.d/000.firebird.sh
firebird/README
firebird/RELNOTES
firebird/UDF/fbudf.so
firebird/UDF/fbudf.sql
firebird/UDF/ib_udf.so
firebird/UDF/ib_udf.sql
firebird/WhatsNew
@unexec if cmp -s %D/firebird/aliases.conf %D/firebird/aliases.conf.sample; then rm -f %D/firebird/aliases.conf; fi
firebird/aliases.conf.sample
@exec [ -f %B/aliases.conf ] || cp %B/%f %B/aliases.conf
firebird/bin/fb_inet_server
firebird/bin/fb_lock_mgr
firebird/bin/fb_lock_print
firebird/bin/gbak
firebird/bin/gdef
firebird/bin/gds_drop
firebird/bin/gfix
firebird/bin/gpre
firebird/bin/gsec
firebird/bin/gstat
firebird/bin/isql
firebird/bin/qli
firebird/doc/README.NTSecurity
firebird/doc/README.Win32LibraryInstallation.txt
firebird/doc/README.build.mingw.html
firebird/doc/README.build.msvc.html
firebird/doc/README.install.Solaris_on_Intel
firebird/doc/README.instsvc
firebird/doc/README.makefiles
firebird/doc/README.user
firebird/doc/README.user.embedded
firebird/doc/README.user.troubleshooting
firebird/doc/sql.extensions/README.aggregate_tracking
firebird/doc/sql.extensions/README.case
firebird/doc/sql.extensions/README.coalesce
firebird/doc/sql.extensions/README.context_variables
firebird/doc/sql.extensions/README.data_types
firebird/doc/sql.extensions/README.exception_handling
firebird/doc/sql.extensions/README.execute_statement
firebird/doc/sql.extensions/README.explicit_locks
firebird/doc/sql.extensions/README.nullif
firebird/doc/sql.extensions/README.order_by_expressions_nulls
firebird/doc/sql.extensions/README.savepoints
firebird/doc/sql.extensions/README.universal_triggers
firebird/examples/align.h
firebird/examples/api1.c
firebird/examples/api10.c
firebird/examples/api11.c
firebird/examples/api12.c
firebird/examples/api13.c
firebird/examples/api14.e
firebird/examples/api15.c
firebird/examples/api16.c
firebird/examples/api16t.c
firebird/examples/api2.c
firebird/examples/api3.c
firebird/examples/api4.c
firebird/examples/api5.c
firebird/examples/api6.c
firebird/examples/api7.c
firebird/examples/api8.c
firebird/examples/api9.c
firebird/examples/api9f.c
firebird/examples/api9f.sql
firebird/examples/apifull.c
firebird/examples/dyn1.e
firebird/examples/dyn2.e
firebird/examples/dyn3.e
firebird/examples/dyn4.e
firebird/examples/dyn5.e
firebird/examples/dynfull.e
firebird/examples/employe2.sql
firebird/examples/employee.fdb
firebird/examples/employee.gbk
firebird/examples/example.h
firebird/examples/readme
firebird/examples/stat1.e
firebird/examples/stat10.e
firebird/examples/stat11.e
firebird/examples/stat12.e
firebird/examples/stat12t.e
firebird/examples/stat2.e
firebird/examples/stat3.e
firebird/examples/stat4.e
firebird/examples/stat5.e
firebird/examples/stat6.e
firebird/examples/stat7.e
firebird/examples/stat8.e
firebird/examples/stat9.e
firebird/examples/udf.sql
firebird/examples/udflib.c
@unexec if cmp -s %D/firebird/firebird.conf %D/firebird/firebird.conf.sample; then rm -f %D/firebird/firebird.conf; fi
firebird/firebird.conf.sample
@exec [ -f %B/firebird.conf ] || cp %B/%f %B/firebird.conf
@unexec [ -s %D/firebird/firebird.log ] || rm -f %D/firebird/firebird.log
firebird/firebird.msg
firebird/help/help.fdb
firebird/include/blr.h
firebird/include/gds.h
firebird/include/ib_util.h
firebird/include/ibase.h
firebird/include/iberror.h
firebird/include/perf.h
firebird/intl/fbintl
@unexec rm -f %D/firebird/isc_event1.`hostname`
@unexec rm -f %D/firebird/isc_init1.`hostname`
@unexec rm -f %D/firebird/isc_lock1.`hostname`
firebird/lib/libfbclient.so
firebird/lib/libfbclient.so.1
firebird/lib/libfbclient.so.%%FIREBIRD_VERSION%%
firebird/lib/libfbembed.so
firebird/lib/libfbembed.so.1
firebird/lib/libfbembed.so.%%FIREBIRD_VERSION%%
firebird/lib/libgds.so
firebird/lib/libgds.so.1
firebird/lib/libib_util.so
@unexec if cmp -s %D/firebird/security.fdb %D/firebird/security.fdb.sample; then rm -f %D/firebird/security.fdb; fi
firebird/security.fdb.sample
@exec [ -f %B/security.fdb ] || cp %B/%f %B/security.fdb
@dirrm firebird/UDF
@dirrm firebird/bin
@dirrm firebird/doc/sql.extensions
@dirrm firebird/doc
@dirrm firebird/examples
@dirrm firebird/help
@dirrm firebird/include
@dirrm firebird/intl
@dirrm firebird/lib
@dirrm firebird




# New ports collection makefile for:	firebird-client
# Date created:				2005 Mar 03
# Whom:					Renato Botelho <renato@galle.com.br>
#
# $FreeBSD$
#

PORTNAME=	firebird
PKGNAMESUFFIX=	-client

COMMENT=	The open-source InterBase(tm) 6.0 spin-off (client)

MASTERDIR=	${.CURDIR}/../firebird-server

PLIST=		${PKGDIR}/pkg-plist.client

CLIENT_ONLY=	yes

.include "${MASTERDIR}/Makefile"




# New ports collection makefile for:	Firebird
# Date created:		20 December 2000
# Whom:			Geoffrey C. Speicher <geoff@sea-incorporated.com>
#
# $FreeBSD: ports/databases/firebird/Makefile,v 1.36 2005/02/14 17:26:19 vs Exp $
#

PORTNAME?=	firebird
PORTVERSION=	1.5.2
CATEGORIES?=	databases
MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
MASTER_SITE_SUBDIR=firebird
PKGNAMESUFFIX?=	-server
DISTNAME=	firebird-1.5.2.4731

MAINTAINER=	renato@galle.com.br
COMMENT?=	The open-source InterBase(tm) 6.0 spin-off (Classic version)

USE_REINPLACE=	yes
USE_BISON=	yes
USE_BZIP2=	yes
USE_GMAKE=	yes
GNU_CONFIGURE=	yes
USE_LIBTOOL_VER=	15
USE_AUTOCONF_VER=	259
USE_GCC=	3.4

PLIST_SUB=	FIREBIRD_VERSION=${PORTVERSION}

# Don't use ld for linking, use gcc
LD=	gcc

# Don't strip binary files
STRIP=

ONLY_FOR_ARCHS=	i386

WRKSRC=		${WRKDIR}/${DISTNAME}

.if !defined(CLIENT_ONLY)
# Server part stuff
LIB_DEPENDS+=	fbembed.1:${PORTSDIR}/databases/firebird-client

AUTOGENARGS=	--prefix=${PREFIX}/firebird \
		--with-lock-manager

ALL_TARGET=	firebird_boot ref_databases msgs intl otherfiles \
		inet_server extlib

# Use own user and group when install server part
BINOWN=		firebird
BINGRP=		firebird
BINMODE=	550
SHAREOWN=	firebird
SHAREGRP=	firebird

PKGMESSAGE=	${WRKDIR}/pkg-message
PKGINSTALL=	${WRKDIR}/pkg-install

CONFLICTS=	firebird-devel-[0-9]*
.else
# Client part stuff
AUTOGENARGS=	--prefix=${PREFIX} \
		--with-editline

ALL_TARGET=	firebird_basic libfbembed embed_gfix embed_gbak embed_isql embed_gpre \
		embed_util embed_gdef embed_qli libfbclient extlib

INSTALLS_SHLIB=	yes
.endif

.include <bsd.port.pre.mk>

.if !defined(CLIENT_ONLY)
pre-everything::
	@${ECHO_MSG} "NOTE: If the work directory is on an NFS mount, you will"
	@${ECHO_MSG} "require NFS client locking support for the build to"
	@${ECHO_MSG} "succeed. Currently this is only available on FreeBSD 5.0"
	@${ECHO_MSG} "or greater."
	@${ECHO_MSG}
	@${ECHO_MSG} "WARNING: The on-disk structure of the databases has"
	@${ECHO_MSG} "changed since version 1.0.x."
	@${ECHO_MSG} "Cancel this installation now and backup your databases"
	@${ECHO_MSG} "if you have not already done so."
.if !defined(BATCH)
	@sleep 10
.endif

post-patch:
	@${REINPLACE_CMD} -e 's|^\(LINK_OPTS +=.*\)$$|\1 -L${LOCALBASE}/lib|' \
		${WRKSRC}/builds/posix/Makefile.in.inet_server

post-build:
	${SED} 's|%%PREFIX%%|${PREFIX}|g' \
		< ${FILESDIR}/pkg-message.in \
		> ${PKGMESSAGE}

	${SED} -e 's|%%PREFIX%%|${PREFIX}/firebird|g' \
		< ${FILESDIR}/pkg-install.in \
		> ${PKGINSTALL}

	${SED} -e "s|%%PREFIX%%|${PREFIX}/firebird|g" \
		< ${FILESDIR}/aliases.conf.in \
		> ${WRKDIR}/aliases.conf

pre-install:
	${SETENV} PKG_PREFIX="${PREFIX}" PKG_DESTDIR="${DESTDIR}" ${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL

post-install:
	${SETENV} PKG_PREFIX="${PREFIX}" PKG_DESTDIR="${DESTDIR}" ${SH} ${PKGINSTALL} ${PORTNAME} POST-INSTALL
	@${ECHO_MSG}
	@${CAT} ${PKGMESSAGE}
	@${ECHO_MSG}
.endif

patch-autotools:
	@${DO_NADA}

run-autotools:
	@${DO_NADA}

do-configure:
	@(cd ${WRKSRC} && ${SETENV} CC=${CC} CXX=${CXX} MAKE=${GMAKE}	\
	${AUTOTOOLS_VARS} ./autogen.sh ${AUTOGENARGS})

post-configure:
	@${REINPLACE_CMD} -e 's|__attribute__ ((__unused__));||' \
		${WRKSRC}/src/dsql/parse.cpp

do-install:
.if !defined(CLIENT_ONLY)

	${MKDIR} ${PREFIX}/firebird
	${CHOWN} ${BINOWN}:${BINGRP} ${PREFIX}/firebird

.for f in UDF bin help intl
	${MKDIR} ${PREFIX}/firebird/${f}
	${CHOWN} ${BINOWN}:${BINGRP} ${PREFIX}/firebird/${f}
.endfor

	${INSTALL_DATA} ${WRKDIR}/aliases.conf ${PREFIX}/firebird/aliases.conf.sample
	${INSTALL_DATA} ${WRKSRC}/gen/firebird/misc/firebird.conf ${PREFIX}/firebird/firebird.conf.sample
	${INSTALL_DATA} ${WRKSRC}/gen/firebird/security.fdb ${PREFIX}/firebird/security.fdb.sample
	${CHMOD} 660 ${PREFIX}/firebird/security.fdb.sample

	${INSTALL_DATA} ${WRKSRC}/gen/firebird/firebird.msg ${PREFIX}/firebird/firebird.msg
	${INSTALL_DATA} ${WRKSRC}/gen/firebird/help/help.fdb ${PREFIX}/firebird/help

.for f in ib_udf.so fbudf.so
	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/UDF/${f} ${PREFIX}/firebird/UDF
.endfor

.for f in src/extlib/ib_udf.sql src/extlib/fbudf/fbudf.sql
	${INSTALL_SCRIPT} ${WRKSRC}/${f} ${PREFIX}/firebird/UDF
.endfor

.for f in fb_inet_server fb_lock_mgr
	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/bin/${f} ${PREFIX}/firebird/bin
	${CHMOD} u+s ${PREFIX}/firebird/bin/${f}
.endfor

	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/intl/libfbintl.so ${PREFIX}/firebird/intl/fbintl

	${INSTALL_DATA} ${FILESDIR}/RELNOTES ${PREFIX}/firebird

.else

.for dir in include share/doc/firebird \
	  share/doc/firebird/sql.extensions share/examples/firebird
	${MKDIR} ${PREFIX}/${dir}
.endfor

.for f in fb_lock_print gbak gdef gds_drop gfix gpre gsec gstat isql qli
	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/bin/${f} ${PREFIX}/bin
.endfor

	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libfbclient.so.${PORTVERSION} ${PREFIX}/lib
	${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libfbclient.so.1
	${LN} -fs libfbclient.so.1 ${PREFIX}/lib/libfbclient.so

	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libfbembed.so.${PORTVERSION} ${PREFIX}/lib
	${LN} -fs libfbembed.so.${PORTVERSION} ${PREFIX}/lib/libfbembed.so.1
	${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libfbembed.so

	${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libgds.so.1
	${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libgds.so

	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libib_util.so ${PREFIX}/lib

	${INSTALL_DATA} ${WRKSRC}/gen/firebird/include/*.h ${PREFIX}/include

	${INSTALL_DATA} ${WRKSRC}/doc/WhatsNew ${PREFIX}/share/doc/firebird
	${INSTALL_DATA} ${WRKSRC}/doc/README.* ${PREFIX}/share/doc/firebird
	${INSTALL_DATA} ${WRKSRC}/doc/README.user ${PREFIX}/share/doc/firebird/README
	${INSTALL_DATA} ${WRKSRC}/doc/sql.extensions/README.* ${PREFIX}/share/doc/firebird/sql.extensions

	# Install examples
	${INSTALL_DATA} ${WRKSRC}/gen/firebird/examples/v5/* ${PREFIX}/share/examples/firebird
.endif

.include <bsd.port.post.mk>

Line 0 Link Here

(-)./databases/firebird-server/distinfo (+2 lines)
	1	MD5 (firebird-1.5.2.4731.tar.bz2) = fea53ed5213cff4bd96513fb1a6c0ca2
	2	SIZE (firebird-1.5.2.4731.tar.bz2) = 4764015




Firebird 1.5.1 FreeBSD Release Notes                    19-Jul-2004
--------------------------------------
FB-V1.5.1.4481 Firebird 1.5 Release

    Welcome to the FreeBSD Firebird port!

    Firebird is installed SUID with owner and group `firebird'.
This does affect where you can and cannot create databases when
connecting remotely, as well as which existing databases you can
access.  If you want a database to be available remotely, be sure
it's readable and writeable to group firebird.

    There may be times when you manage to get your system into a
state where using any of the Firebird utilites (isql, gbak, gsec,
etc.) gives you the message "semget failed".  One surefire way to
do this is to build and install the port.  :)  If this happens,
make sure that the lock manager is not running and its semaphores
have been removed.  The former can be accomplished with 'ps ax
|grep fb' and 'kill'; the latter with 'ipcs -s' and 'ipcrm -s'.

    For example, after building and installing the port, you will
probably go through something like this:

# isql /usr/local/firebird/security.fdb
Statement failed, SQLCODE = -902

operating system directive semget failed
-No such file or directory

# ipcs -s
Semaphores:
T     ID     KEY        MODE       OWNER    GROUP
s 1310720  252034728 --rw-rw-rw-     root    wheel

# ipcrm -s 1310720

and you should be in business.

    Once this is done, you should be able to connect normally to
databases.  Your first connection will restart the lock manager.

    There may be times, however, when you still get "semget failed"
even though the lock manager is not running and the semaphores have
been cleaned up.  There seems to be a conflict with this release
and the PostgreSQL 7 release as installed from the ports collection.
If you're having trouble with Firebird and you're running PostgreSQL,
try stopping PostgreSQL:

	/usr/local/etc/rc.d/pgsql.sh stop

and see if that helps. Alternatively, increase the value of SEMMNS
by 48 in your kernel configuration file. This can be found by getting
the current value with 'sysctl -a | grep semmns'. You can either add
this to your kernel config, or add the following line to /boot/loader.conf:

	kern.ipc.semmns=X

where is is the current value plus 48. If this doesn't resolve the issue,
try adding 48 again. 

    Please note that as of RC8, the libgds.so symlink now points to
libfbembed.so. This has been done to resolve compatability issues with
older versions of Firebird. The FreeBSD port of RC7 had libgds.so
pointing to libfbclient.so. libfbclient.so is a remote access-only
shared library with threaded support, which requires target applications
to link with a threaded library such as libc_r.so, libpthread.so or libthr.so.

    Super Server support in Firebird 1.5 for FreeBSD is not currently
available due to the Firebird code using POSIX threads APIs not available
in FreeBSD 4.x or not yet complete in FreeBSD 5.x. This issue will become
more important once the scalability issues of Super Server have been
resolved.

    This installation has already inserted the necessary line to
/etc/inetd.conf so that you can connect to Firebird across the network.
However you may need to add the remote host to /etc/hosts.equiv. For
example, to allow the local machine to make connections to Firebird
using TCP, the following command needs running:

	echo localhost >> /etc/hosts.equiv

Please note that adding machines to /etc/hosts.equiv can reduce the
security of your system. If in doubt, try connecting to Firebird with
a username and password already defined in security.fdb. For example:

gsec
> add myuser -pass mypass
> quit
isql -u myuser -p mypass localhost:/usr/local/firebird/examples/employee.fdb

This should reduce the need for hosts defined in /etc/hosts.equiv.

    Complete documentation for InterBase(tm) is available (free of
charge) from http://www.interbase.com/ in PDF format.  While
InterBase and Firebird are two distinct entities, all InterBase
documentation is pertinent to Firebird.  More information on Firebird
and InterBase can be found at the following:

	http://sourceforge.net/projects/firebird/
	http://www.ibphoenix.com/
	http://www.interbase2000.org/
	http://www.firebirdsql.org/

    Please also see the doc directory in the Firebird package for
documentation specific to Firebird.

Chris Knight
<chris@e-easy.com.au>

Line 0 Link Here

(-)./databases/firebird-server/files/aliases.conf.in (+8 lines)
	1	#
	2	# List of known database aliases
	3	# ------------------------------
	4	#
	5	# Examples:
	6	#
	7	# employee = %%PREFIX%%/examples/employee.fdb
	8	#




--- builds/posix/Makefile.in.inet_server.orig	Fri Sep 17 20:34:21 2004
+++ builds/posix/Makefile.in.inet_server	Wed Mar  2 16:09:41 2005
@@ -39,6 +39,8 @@
 
 @SET_MAKE@
 
+LINK_OPTS +=
+
 SERVER_Files = server_stub.cpp 
 SERVER_Sources = $(addprefix remote/, $(SERVER_Files))
 SERVER_Objects = $(addprefix $(OBJ)/, $(addsuffix .o, $(basename $(SERVER_Sources))))
@@ -51,7 +53,7 @@
 
 # SD: We don't need to rebuild fb_inet_server every time libfbembed.so changed,
 #     but we must ensure it's existance
-fb_inet_server : $(LIBFBEMBED_SO) $(FB_CLASSIC_SERVER)
+fb_inet_server : $(FB_CLASSIC_SERVER)
 
 $(FB_CLASSIC_SERVER):	$(SERVER_Objects)
 	$(LD) $(LINK_OPTS) $^ -o $@ $(FBEMBED_LINK) $(LIB_GUI) $(LINK_LIBS) 

Line 0 Link Here

(-)./databases/firebird-server/files/patch-src::extern::editline::makelist (+11 lines)
	1	--- src/extern/editline/makelist.orig Mon May 24 04:24:25 2004
	2	+++ src/extern/editline/makelist Fri Jul 23 17:09:43 2004
	3	@@ -145,7 +145,7 @@
	4	#
	5	-fh)
	6	cat $FILES \| $AWK '/el_action_t/ { print $3 }' \| \
	7	- sort \| tr '[a-z]' '[A-Z]' \| $AWK '
	8	+ sort \| tr '[:lower:]' '[:upper:]' \| $AWK '
	9	BEGIN {
	10	printf("/* Automatically generated file, do not edit */\n");
	11	printf("#ifndef _h_fcns_c\n#define _h_fcns_c\n");




#!/bin/sh

PATH=/sbin:/usr/sbin:/usr/local/sbin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin:%%PREFIX%%/bin
PREFIX=%%PREFIX%%
DB_DIR=%%PREFIX%%

USER=firebird
GROUP=${USER}
UID=3050
GID=${UID}
HOME=${DB_DIR}
DESCR="Firebird Database Administrator"

case $2 in
PRE-INSTALL)
	if pw group show "${GROUP}" 2> /dev/null; then
		echo "You already have a group \"${GROUP}\", so I will use it."
	else
		if pw groupadd ${GROUP} -g ${GID}; then
			echo "Added group \"${GROUP}\"."
		else
			echo "Adding group \"${GROUP}\" failed..."
			exit 1
		fi
	fi

	if pw user show "${USER}" 2> /dev/null; then
		echo "You already have a user \"${USER}\", so I will use it."

		if pw usermod ${USER} -d ${HOME}; then
			echo "Changed home directory of \"${USER}\" to \"${HOME}\""
		else
			echo "Changing home directory of \"${USER}\" to \"${HOME}\" failed..."
			exit 1
		fi
	else
		if pw useradd ${USER} -u ${UID} -g ${GROUP} -h - -d ${NOME} -s /sbin/nologin -c "${DESCR}" ; then
			echo "Added user \"${USER}\"."
		else
			echo "Adding user \"${USER}\" failed..."
			exit 1
		fi
	fi
        ;;

POST-INSTALL)
	for f in isc_init1.`hostname` isc_lock1.`hostname` isc_event1.`hostname` firebird.log
	do
		touch ${PREFIX}/${f}
		chown ${USER}:${GROUP} ${PREFIX}/$f
		chmod 660 ${PREFIX}/${f}
	done

	# add the gds service and restart inetd
	cat /etc/services | grep -v gds_db > /etc/services.new
	cat >>/etc/services.new <<EOF
gds_db          3050/tcp  #InterBase Database Remote Protocol
EOF
	mv /etc/services.new /etc/services

	cat /etc/inetd.conf | grep -v gds_db > /etc/inetd.conf.new
	cat >>/etc/inetd.conf.new <<EOF
gds_db  stream  tcp     nowait  firebird        ${PREFIX}/bin/fb_inet_server  fb_inet_server
EOF
	mv /etc/inetd.conf.new /etc/inetd.conf

	if [ -f /var/run/inetd.pid ]; then
	        kill -HUP `cat /var/run/inetd.pid`
	fi
esac




---------------------------------------------------------
Firebird is now installed.  A symbolic link from
/usr/interbase -> %%PREFIX%%/firebird may be needed
for compatibility with existing programs that use
Firebird.

The symbolic link can be created with:

% ln -s %%PREFIX%%/firebird /usr/interbase

It is STRONGLY recommended that you change the SYSDBA
password with:

% cd %%PREFIX%%/firebird
% gsec -user SYSDBA -pass masterkey
GSEC> modify SYSDBA -pw newpassword
GSEC> quit

before doing anything serious with Firebird.

See %%PREFIX%%/firebird/RELNOTES for more.
---------------------------------------------------------




The open-source InterBase(tm) 6.0 spin-off (Classic server version)

InterBase is a world-class DBMS with a history too rich to detail
here.  Once selling for several thousands of dollars per license,
some very big players use it worldwide.  Inprise has open-sourced
InterBase 6.0, and a lively bunch of folks has charged themselves
with seeing that it lives on through the Firebird project.

For more information on Firebird and InterBase, see:

WWW: http://sourceforge.net/projects/firebird/
WWW: http://www.ibphoenix.com/
WWW: http://www.interbase2000.org/
WWW: http://www.interbase.com/
WWW: http://www.firebirdsql.org/




firebird/RELNOTES
firebird/UDF/fbudf.so
firebird/UDF/fbudf.sql
firebird/UDF/ib_udf.so
firebird/UDF/ib_udf.sql
@unexec if cmp -s %D/firebird/aliases.conf %D/firebird/aliases.conf.sample; then rm -f %D/firebird/aliases.conf; fi
firebird/aliases.conf.sample
@exec [ -f %B/aliases.conf ] || cp %B/%f %B/aliases.conf
firebird/bin/fb_inet_server
firebird/bin/fb_lock_mgr
@unexec if cmp -s %D/firebird/firebird.conf %D/firebird/firebird.conf.sample; then rm -f %D/firebird/firebird.conf; fi
firebird/firebird.conf.sample
@exec [ -f %B/firebird.conf ] || cp %B/%f %B/firebird.conf
@unexec [ -s %D/firebird/firebird.log ] || rm -f %D/firebird/firebird.log
firebird/firebird.msg
firebird/help/help.fdb
firebird/intl/fbintl
@unexec rm -f %D/firebird/isc_event1.`hostname`
@unexec rm -f %D/firebird/isc_init1.`hostname`
@unexec rm -f %D/firebird/isc_lock1.`hostname`
@unexec if cmp -s %D/firebird/security.fdb %D/firebird/security.fdb.sample; then rm -f %D/firebird/security.fdb; fi
firebird/security.fdb.sample
@exec [ -f %B/security.fdb ] || cp %B/%f %B/security.fdb
@dirrm firebird/UDF
@dirrm firebird/bin
@dirrm firebird/help
@dirrm firebird/intl
@dirrm firebird




bin/fb_lock_print
bin/gbak
bin/gdef
bin/gds_drop
bin/gfix
bin/gpre
bin/gsec
bin/gstat
bin/isql
bin/qli
include/blr.h
include/gds.h
include/ib_util.h
include/ibase.h
include/iberror.h
include/perf.h
lib/libfbclient.so
lib/libfbclient.so.1
lib/libfbclient.so.%%FIREBIRD_VERSION%%
lib/libfbembed.so
lib/libfbembed.so.1
lib/libfbembed.so.%%FIREBIRD_VERSION%%
lib/libgds.so
lib/libgds.so.1
lib/libib_util.so
%%DOCSDIR%%/README.NTSecurity
%%DOCSDIR%%/README.Win32LibraryInstallation.txt
%%DOCSDIR%%/README.build.mingw.html
%%DOCSDIR%%/README.build.msvc.html
%%DOCSDIR%%/README.install.Solaris_on_Intel
%%DOCSDIR%%/README.instsvc
%%DOCSDIR%%/README.makefiles
%%DOCSDIR%%/README.user
%%DOCSDIR%%/README.user.embedded
%%DOCSDIR%%/README.user.troubleshooting
%%DOCSDIR%%/README
%%DOCSDIR%%/WhatsNew
%%DOCSDIR%%/sql.extensions/README.aggregate_tracking
%%DOCSDIR%%/sql.extensions/README.case
%%DOCSDIR%%/sql.extensions/README.coalesce
%%DOCSDIR%%/sql.extensions/README.context_variables
%%DOCSDIR%%/sql.extensions/README.data_types
%%DOCSDIR%%/sql.extensions/README.exception_handling
%%DOCSDIR%%/sql.extensions/README.execute_statement
%%DOCSDIR%%/sql.extensions/README.explicit_locks
%%DOCSDIR%%/sql.extensions/README.nullif
%%DOCSDIR%%/sql.extensions/README.order_by_expressions_nulls
%%DOCSDIR%%/sql.extensions/README.savepoints
%%DOCSDIR%%/sql.extensions/README.universal_triggers
%%EXAMPLESDIR%%/align.h
%%EXAMPLESDIR%%/api1.c
%%EXAMPLESDIR%%/api10.c
%%EXAMPLESDIR%%/api11.c
%%EXAMPLESDIR%%/api12.c
%%EXAMPLESDIR%%/api13.c
%%EXAMPLESDIR%%/api14.e
%%EXAMPLESDIR%%/api15.c
%%EXAMPLESDIR%%/api16.c
%%EXAMPLESDIR%%/api16t.c
%%EXAMPLESDIR%%/api2.c
%%EXAMPLESDIR%%/api3.c
%%EXAMPLESDIR%%/api4.c
%%EXAMPLESDIR%%/api5.c
%%EXAMPLESDIR%%/api6.c
%%EXAMPLESDIR%%/api7.c
%%EXAMPLESDIR%%/api8.c
%%EXAMPLESDIR%%/api9.c
%%EXAMPLESDIR%%/api9f.c
%%EXAMPLESDIR%%/api9f.sql
%%EXAMPLESDIR%%/apifull.c
%%EXAMPLESDIR%%/dyn1.e
%%EXAMPLESDIR%%/dyn2.e
%%EXAMPLESDIR%%/dyn3.e
%%EXAMPLESDIR%%/dyn4.e
%%EXAMPLESDIR%%/dyn5.e
%%EXAMPLESDIR%%/dynfull.e
%%EXAMPLESDIR%%/employe2.sql
%%EXAMPLESDIR%%/employee.fdb
%%EXAMPLESDIR%%/employee.gbk
%%EXAMPLESDIR%%/example.h
%%EXAMPLESDIR%%/readme
%%EXAMPLESDIR%%/stat1.e
%%EXAMPLESDIR%%/stat10.e
%%EXAMPLESDIR%%/stat11.e
%%EXAMPLESDIR%%/stat12.e
%%EXAMPLESDIR%%/stat12t.e
%%EXAMPLESDIR%%/stat2.e
%%EXAMPLESDIR%%/stat3.e
%%EXAMPLESDIR%%/stat4.e
%%EXAMPLESDIR%%/stat5.e
%%EXAMPLESDIR%%/stat6.e
%%EXAMPLESDIR%%/stat7.e
%%EXAMPLESDIR%%/stat8.e
%%EXAMPLESDIR%%/stat9.e
%%EXAMPLESDIR%%/udf.sql
%%EXAMPLESDIR%%/udflib.c
@dirrm %%DOCSDIR%%/sql.extensions
@dirrm %%DOCSDIR%%
@dirrm %%EXAMPLESDIR%%

Lines 17-23 Link Here

(-)./databases/kinterbasdb/Makefile (-1 / +1 lines)
17	MAINTAINER= rud@cs.uni-magdeburg.de	17	MAINTAINER= rud@cs.uni-magdeburg.de
18	COMMENT= Python extension for Firebird/Interbase(R) relational databases	18	COMMENT= Python extension for Firebird/Interbase(R) relational databases
19		19
20	LIB_DEPENDS= gds.1:${PORTSDIR}/databases/firebird	20	LIB_DEPENDS= gds.1:${PORTSDIR}/databases/firebird-client
21	RUN_DEPENDS= ${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py:${PORTSDIR}/lang/py-mx-base	21	RUN_DEPENDS= ${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py:${PORTSDIR}/lang/py-mx-base
22		22
23	WRKSRC= ${WRKDIR}/${PORTNAME}-${PORTVERSION}	23	WRKSRC= ${WRKDIR}/${PORTNAME}-${PORTVERSION}

Lines 51-57 Link Here

(-)./databases/libgda2/Makefile (-3 / +3 lines)
51	WITH_LDAP=yes	51	WITH_LDAP=yes
52	.endif	52	.endif
53		53
54	.if exists(${LOCALBASE}/firebird/lib/libgds.so.1)	54	.if exists(${LOCALBASE}/lib/libgds.so.1)
55	WITH_FIREBIRD= yes	55	WITH_FIREBIRD= yes
56	.endif	56	.endif
57		57
Lines 103-110 Link Here
103	.endif	103	.endif
104		104
105	.if !defined(WITHOUT_FIREBIRD) && defined(WITH_FIREBIRD)	105	.if !defined(WITHOUT_FIREBIRD) && defined(WITH_FIREBIRD)
106	LIB_DEPENDS+= gds.1:${PORTSDIR}/databases/firebird	106	LIB_DEPENDS+= gds.1:${PORTSDIR}/databases/firebird-client
107	CONFIGURE_ARGS+= --with-firebird=${LOCALBASE}/firebird	107	CONFIGURE_ARGS+= --with-firebird=${LOCALBASE}
108	PLIST_SUB+= FIREBIRD:=""	108	PLIST_SUB+= FIREBIRD:=""
109	.else	109	.else
110	CONFIGURE_ARGS+= --without-interbase	110	CONFIGURE_ARGS+= --without-interbase




MAINTAINER=	skv@FreeBSD.org
COMMENT=	DBI driver for InterBase RDBMS server

LIB_DEPENDS=	gds:${PORTSDIR}/databases/firebird-client

PERL_CONFIGURE=	yes

post-patch:
		@${PERL} -pi -e 's,%%IB_BASE%%,${LOCALBASE},g' \
			${WRKSRC}/Makefile.PL

MAN3=		Bundle::DBD::InterBase.3 DBD::InterBase.3 DBD::InterBase::FAQ.3

Lines 18-24 Link Here

(-)./databases/qt-ibase-plugin/Makefile (-1 / +1 lines)
18		18
19	DB= ibase	19	DB= ibase
20		20
21	LIB_DEPENDS+= gds:${PORTSDIR}/databases/firebird \	21	LIB_DEPENDS+= gds:${PORTSDIR}/databases/firebird-client \
22	qt-mt:${PORTSDIR}/x11-toolkits/qt33	22	qt-mt:${PORTSDIR}/x11-toolkits/qt33
23		23
24	USE_BZIP2= yes	24	USE_BZIP2= yes

Lines 2-11 Link Here

(-)./databases/qt-ibase-plugin/files/Makefile.bsd (-2 / +1 lines)
2		2
3	VPATH= ${PLUGIN}:${DRIVER}	3	VPATH= ${PLUGIN}:${DRIVER}
4	CXXFLAGS+= -I${PLUGIN} -I${DRIVER} \	4	CXXFLAGS+= -I${PLUGIN} -I${DRIVER} \
5	-I${LOCALBASE}/firebird/include \
6	-I${LOCALBASE}/include -I${X11BASE}/include \	5	-I${LOCALBASE}/include -I${X11BASE}/include \
7	${PTHREAD_CFLAGS} -DQT_THREAD_SUPPORT	6	${PTHREAD_CFLAGS} -DQT_THREAD_SUPPORT
8	LDADD= -L${X11BASE}/lib -L${LOCALBASE}/firebird/lib ${PTHREAD_LIBS} -lqt-mt -lgds	7	LDADD= -L${X11BASE}/lib -L${LOCALBASE}/lib ${PTHREAD_LIBS} -lqt-mt -lgds
9	SRCS= qsql_${DB}.cpp main.cpp	8	SRCS= qsql_${DB}.cpp main.cpp
10		9
11	LIBDIR= ${PREFIX}/lib/plugins/sqldrivers	10	LIBDIR= ${PREFIX}/lib/plugins/sqldrivers




MAINTAINER=	skv@FreeBSD.org
COMMENT=	Ruby interface to Interbase library

LIB_DEPENDS=	gds:${PORTSDIR}/databases/firebird-client

WRKSRC=		${WRKDIR}/${PORTNAME}

USE_RUBY=	yes
USE_RUBY_EXTCONF=	yes

CONFIGURE_ARGS=	--with-interbase-include-dir="${LOCALBASE}/include" \
		--with-interbase-lib-dir="${LOCALBASE}/lib"
INSTALL_TARGET=	site-install

DOCS_EN=	README

Lines 69-76 Link Here

(-)./databases/sqlrelay/Makefile (-2 / +2 lines)
69	.endif	69	.endif
70		70
71	.if defined(WITH_INTERBASE) && ${WITH_INTERBASE:L} != no	71	.if defined(WITH_INTERBASE) && ${WITH_INTERBASE:L} != no
72	LIB_DEPENDS+= gds.1:${PORTSDIR}/databases/firebird	72	LIB_DEPENDS+= gds.1:${PORTSDIR}/databases/firebird-client
73	CONFIGURE_ARGS+= --with-interbase-prefix="${LOCALBASE}/firebird"	73	CONFIGURE_ARGS+= --with-interbase-prefix="${LOCALBASE}"
74	IF_INTERBASE= ""	74	IF_INTERBASE= ""
75	.else	75	.else
76	CONFIGURE_ARGS+= --disable-interbase	76	CONFIGURE_ARGS+= --disable-interbase

Lines 25-31 Link Here

(-)./lang/fpc/Makefile (-1 / +1 lines)
25		25
26	.include <bsd.port.pre.mk>	26	.include <bsd.port.pre.mk>
27		27
28	LIB_DEPENDS+= gds.1:${PORTSDIR}/databases/firebird	28	LIB_DEPENDS+= gds.1:${PORTSDIR}/databases/firebird-client
29	.if ${OSVERSION} < 470000	29	.if ${OSVERSION} < 470000
30	EXTRACT_DEPENDS+= gtar:${PORTSDIR}/archivers/gtar	30	EXTRACT_DEPENDS+= gtar:${PORTSDIR}/archivers/gtar
31	TAR= ${LOCALBASE}/bin/gtar	31	TAR= ${LOCALBASE}/bin/gtar

Lines 142-150 Link Here

(-)./lang/php4/Makefile.ext (-2 / +2 lines)
142	.endif	142	.endif
143		143
144	.if ${PHP_MODNAME} == "interbase"	144	.if ${PHP_MODNAME} == "interbase"
145	LIB_DEPENDS+= gds.1:${PORTSDIR}/databases/firebird	145	LIB_DEPENDS+= gds.1:${PORTSDIR}/databases/firebird-client
146		146
147	CONFIGURE_ARGS+=--with-interbase=${LOCALBASE}/firebird	147	CONFIGURE_ARGS+=--with-interbase=${LOCALBASE}
148	.endif	148	.endif
149		149
150	.if ${PHP_MODNAME} == "ldap"	150	.if ${PHP_MODNAME} == "ldap"

Lines 136-144 Link Here

(-)./lang/php5/Makefile.ext (-2 / +2 lines)
136	.endif	136	.endif
137		137
138	.if ${PHP_MODNAME} == "interbase"	138	.if ${PHP_MODNAME} == "interbase"
139	LIB_DEPENDS+= gds.1:${PORTSDIR}/databases/firebird	139	LIB_DEPENDS+= gds.1:${PORTSDIR}/databases/firebird-client
140		140
141	CONFIGURE_ARGS+=--with-interbase=${LOCALBASE}/firebird	141	CONFIGURE_ARGS+=--with-interbase=${LOCALBASE}
142	.endif	142	.endif
143		143
144	.if ${PHP_MODNAME} == "ldap"	144	.if ${PHP_MODNAME} == "ldap"

Return to bug 79337

Lines 1-82 Link Here

(-)./databases/firebird/Makefile (-82 lines)
1	# New ports collection makefile for: Firebird
2	# Date created: 20 December 2000
3	# Whom: Geoffrey C. Speicher <geoff@sea-incorporated.com>
4	#
5	# $FreeBSD: ports/databases/firebird/Makefile,v 1.36 2005/02/14 17:26:19 vs Exp $
6	#
7
8	PORTNAME= firebird
9	PORTVERSION= 1.5.2
10	CATEGORIES= databases
11	MASTER_SITES= ${MASTER_SITE_SOURCEFORGE}
12	MASTER_SITE_SUBDIR=firebird
13	DISTNAME= firebird-1.5.2.4731
14
15	MAINTAINER= renato@galle.com.br
16	COMMENT= The open-source InterBase(tm) 6.0 spin-off (Classic version)
17
18	USE_BISON= yes
19	USE_BZIP2= yes
20	USE_GMAKE= yes
21	GNU_CONFIGURE= yes
22	USE_LIBTOOL_VER= 15
23	USE_AUTOCONF_VER= 259
24	USE_GCC= 3.4
25
26	PLIST_SUB= FIREBIRD_VERSION=${PORTVERSION}
27
28	# Don't use ld for linking, use gcc
29	LD= gcc
30
31	CONFLICTS= firebird-devel-[0-9]*
32
33	WRKSRC= ${WRKDIR}/${DISTNAME}
34	INSTALLS_SHLIB= yes
35	LDCONFIG_DIRS= %%PREFIX%%/firebird/lib
36	MSG_FILE= ${PKGDIR}/pkg-message
37	PKGMESSAGE= ${WRKDIR}/pkg-message
38	USE_REINPLACE= yes
39
40	ONLY_FOR_ARCHS= i386
41
42	.include <bsd.port.pre.mk>
43
44	pre-everything::
45	@${ECHO_MSG} "NOTE: If the work directory is on an NFS mount, you will"
46	@${ECHO_MSG} "require NFS client locking support for the build to"
47	@${ECHO_MSG} "succeed. Currently this is only available on FreeBSD 5.0"
48	@${ECHO_MSG} "or greater."
49	@${ECHO_MSG}
50	@${ECHO_MSG} "WARNING: The on-disk structure of the databases has"
51	@${ECHO_MSG} "changed since version 1.0.x."
52	@${ECHO_MSG} "Cancel this installation now and backup your databases"
53	@${ECHO_MSG} "if you have not already done so."
54	.if !defined(BATCH)
55	@sleep 10
56	.endif
57
58	patch-autotools:
59	@${DO_NADA}
60
61	run-autotools:
62	@${DO_NADA}
63
64	do-configure:
65	@(cd ${WRKSRC} && ${SETENV} CC=${CC} CXX=${CXX} MAKE=${GMAKE} \
66	${AUTOTOOLS_VARS} ./autogen.sh --prefix=${PREFIX}/firebird \
67	--with-lock-manager --with-editline)
68
69	do-build:
70	@( \
71	${SED} 's\|%%PREFIX%%\|${PREFIX}\|g' ${MSG_FILE} > ${PKGMESSAGE}; \
72	cd ${WRKSRC}; \
73	${SETENV} CC=${CC} CXX=${CXX} ${GMAKE} all; \
74	)
75
76	post-install:
77	@( \
78	${INSTALL_DATA} ${FILESDIR}/RELNOTES ${PREFIX}/firebird; \
79	${CAT} ${PKGMESSAGE}; \
80	)
81
82	.include <bsd.port.post.mk>

Lines 1-108 Link Here

(-)./databases/firebird/files/RELNOTES (-108 lines)
1	Firebird 1.5.1 FreeBSD Release Notes 19-Jul-2004
2	--------------------------------------
3	FB-V1.5.1.4481 Firebird 1.5 Release
4
5	Welcome to the FreeBSD Firebird port!
6
7	Firebird is installed SUID with owner and group `firebird'.
8	This does affect where you can and cannot create databases when
9	connecting remotely, as well as which existing databases you can
10	access. If you want a database to be available remotely, be sure
11	it's readable and writeable to group firebird.
12
13	There may be times when you manage to get your system into a
14	state where using any of the Firebird utilites (isql, gbak, gsec,
15	etc.) gives you the message "semget failed". One surefire way to
16	do this is to build and install the port. :) If this happens,
17	make sure that the lock manager is not running and its semaphores
18	have been removed. The former can be accomplished with 'ps ax
19	\|grep fb' and 'kill'; the latter with 'ipcs -s' and 'ipcrm -s'.
20
21	For example, after building and installing the port, you will
22	probably go through something like this:
23
24	# isql /usr/local/firebird/security.fdb
25	Statement failed, SQLCODE = -902
26
27	operating system directive semget failed
28	-No such file or directory
29
30	# ipcs -s
31	Semaphores:
32	T ID KEY MODE OWNER GROUP
33	s 1310720 252034728 --rw-rw-rw- root wheel
34
35	# ipcrm -s 1310720
36
37	and you should be in business.
38
39	Once this is done, you should be able to connect normally to
40	databases. Your first connection will restart the lock manager.
41
42	There may be times, however, when you still get "semget failed"
43	even though the lock manager is not running and the semaphores have
44	been cleaned up. There seems to be a conflict with this release
45	and the PostgreSQL 7 release as installed from the ports collection.
46	If you're having trouble with Firebird and you're running PostgreSQL,
47	try stopping PostgreSQL:
48
49	/usr/local/etc/rc.d/pgsql.sh stop
50
51	and see if that helps. Alternatively, increase the value of SEMMNS
52	by 48 in your kernel configuration file. This can be found by getting
53	the current value with 'sysctl -a \| grep semmns'. You can either add
54	this to your kernel config, or add the following line to /boot/loader.conf:
55
56	kern.ipc.semmns=X
57
58	where is is the current value plus 48. If this doesn't resolve the issue,
59	try adding 48 again.
60
61	Please note that as of RC8, the libgds.so symlink now points to
62	libfbembed.so. This has been done to resolve compatability issues with
63	older versions of Firebird. The FreeBSD port of RC7 had libgds.so
64	pointing to libfbclient.so. libfbclient.so is a remote access-only
65	shared library with threaded support, which requires target applications
66	to link with a threaded library such as libc_r.so, libpthread.so or libthr.so.
67
68	Super Server support in Firebird 1.5 for FreeBSD is not currently
69	available due to the Firebird code using POSIX threads APIs not available
70	in FreeBSD 4.x or not yet complete in FreeBSD 5.x. This issue will become
71	more important once the scalability issues of Super Server have been
72	resolved.
73
74	This installation has already inserted the necessary line to
75	/etc/inetd.conf so that you can connect to Firebird across the network.
76	However you may need to add the remote host to /etc/hosts.equiv. For
77	example, to allow the local machine to make connections to Firebird
78	using TCP, the following command needs running:
79
80	echo localhost >> /etc/hosts.equiv
81
82	Please note that adding machines to /etc/hosts.equiv can reduce the
83	security of your system. If in doubt, try connecting to Firebird with
84	a username and password already defined in security.fdb. For example:
85
86	gsec
87	> add myuser -pass mypass
88	> quit
89	isql -u myuser -p mypass localhost:/usr/local/firebird/examples/employee.fdb
90
91	This should reduce the need for hosts defined in /etc/hosts.equiv.
92
93	Complete documentation for InterBase(tm) is available (free of
94	charge) from http://www.interbase.com/ in PDF format. While
95	InterBase and Firebird are two distinct entities, all InterBase
96	documentation is pertinent to Firebird. More information on Firebird
97	and InterBase can be found at the following:
98
99	http://sourceforge.net/projects/firebird/
100	http://www.ibphoenix.com/
101	http://www.interbase2000.org/
102	http://www.firebirdsql.org/
103
104	Please also see the doc directory in the Firebird package for
105	documentation specific to Firebird.
106
107	Chris Knight
108	<chris@e-easy.com.au>

Lines 1-15 Link Here

(-)./databases/firebird/pkg-descr (-15 lines)
1	The open-source InterBase(tm) 6.0 spin-off (Classic server version)
2
3	InterBase is a world-class DBMS with a history too rich to detail
4	here. Once selling for several thousands of dollars per license,
5	some very big players use it worldwide. Inprise has open-sourced
6	InterBase 6.0, and a lively bunch of folks has charged themselves
7	with seeing that it lives on through the Firebird project.
8
9	For more information on Firebird and InterBase, see:
10
11	WWW: http://sourceforge.net/projects/firebird/
12	WWW: http://www.ibphoenix.com/
13	WWW: http://www.interbase2000.org/
14	WWW: http://www.interbase.com/
15	WWW: http://www.firebirdsql.org/

Lines 1-171 Link Here

(-)./databases/firebird/pkg-install (-171 lines)
1	#!/bin/sh
2
3	# $FreeBSD: ports/databases/firebird/pkg-install,v 1.9 2004/01/16 18:37:14 clement Exp $
4
5	PATH=/bin:/usr/bin:/usr/sbin
6
7	case $2 in
8	PRE-INSTALL)
9
10	if [ -d $PKG_PREFIX/firebird ]; then
11	if [ -d $PKG_PREFIX/firebird.old ]; then
12	rm -rf $PKG_PREFIX/firebird.old
13	fi
14	cp -Rp $PKG_PREFIX/firebird $PKG_PREFIX/firebird.old
15	fi
16
17	if [ `id -u` -ne 0 ]; then
18	echo; echo "You must be root to run this step!"; echo; echo
19	exit 1
20	fi
21
22	nofbuid=0
23	fbUID=`id -u firebird 2>/dev/null`
24	if [ $? -ne 0 ]; then
25	fbUID=90
26	while [ ! -z `id -un $fbUID 2>/dev/null` ]
27	do
28	fbUID=$(($fbUID+1))
29	done
30	nofbuid=1
31	fi
32
33	fbGID=`pw groupshow firebird 2>/dev/null`
34	if [ $? -ne 0 ]; then
35	fbGID=90
36	while [ ! -z `id -gn $fbGID 2>/dev/null` ]
37	do
38	fbGID=$(($fbGID+1))
39	done
40	echo "firebird:*:$fbGID:" >> /etc/group
41	else
42	fbGID=`echo $fbGID \| awk -F: '{print $3}'`
43	fi
44
45	echo "firebird user using uid $fbUID"
46	echo "firebird user using gid $fbGID"
47
48	if which -s pw; then
49	if [ $nofbuid -ne 0 ]; then
50	pw useradd firebird -u $fbUID -g $fbGID -h - -s /bin/sh \
51	-d $PKG_PREFIX/firebird -c "Firebird Database Administrator"
52	fi
53	else
54	echo -n "unable to create user firebird - please create it manually,"
55	echo " before reinstalling this package."
56	exit 1
57	fi
58	;;
59
60	POST-INSTALL)
61	chown -R firebird:firebird $PKG_PREFIX/firebird
62	chmod -R o= $PKG_PREFIX/firebird
63
64	# Now fix up the mess.
65
66	# fix up directories
67	for i in `find $PKG_PREFIX/firebird -print`
68	do
69	FileName=$i
70	if [ -d $FileName ]; then
71	chmod u=rwx,go=rx $FileName
72	fi
73	done
74
75	# make lib ldconfig-compatible
76	chown -R root:wheel $PKG_PREFIX/firebird/lib
77
78	# make the following read-only
79	chmod -R a=r $PKG_PREFIX/firebird/WhatsNew
80	for i in `find $PKG_PREFIX/firebird/doc -type f -print`
81	do
82	chmod a=r $i
83	done
84	chmod -R a=r $PKG_PREFIX/firebird/examples/*
85	chmod -R a=r $PKG_PREFIX/firebird/include/*
86	chmod -R a=r $PKG_PREFIX/firebird/intl/*
87	#chmod -R a=r $PKG_PREFIX/firebird/misc/*
88
89	chmod -R ug=rx,o= $PKG_PREFIX/firebird/UDF/*
90	chmod -R ug=rx,o= $PKG_PREFIX/firebird/intl/fbintl
91	chmod -R a=rx $PKG_PREFIX/firebird/lib/*
92
93	cd $PKG_PREFIX/firebird/lib
94	ln -sf libfbembed.so libgds.so
95	ln -sf libfbembed.so.1 libgds.so.1
96
97	cd $PKG_PREFIX/firebird/bin
98	for i in `ls`
99	do
100	chmod ug=rx,o= $i
101	done
102
103	chmod a=rx isql qli
104
105	# SUID is needed for running server programs.
106	for i in fb_lock_mgr gds_drop fb_inet_server
107	do
108	if [ -f $i ]; then
109	chmod ug=rx,o= $i
110	chmod ug+s $i
111	fi
112	done
113
114
115	cd $PKG_PREFIX/firebird
116
117	# Lock files
118
119	for i in isc_init1 isc_lock1 isc_event1
120	do
121	FileName=$i.`hostname`
122	touch $FileName
123	chmod uga=rw $FileName
124	chown firebird:firebird $FileName
125	done
126
127	touch firebird.log
128	chown firebird:firebird firebird.log
129	chmod ug=rw,o= firebird.log
130	chmod a=r firebird.msg README
131	chown root:wheel *.sample
132	chmod ug=r,o= *.sample
133
134	# make databases writable by firebird only
135	# local database connections are not a good idea
136	chmod ug=rw,o= examples/*.fdb
137	chmod ug=rw,o= help/*.fdb
138	chmod ug=rw,o= security.fdb
139
140	chmod 444 aliases.conf firebird.conf
141	chmod 660 security.fdb
142
143	# remove any existing gds service
144	cp /etc/services /etc/services.old
145	cp /etc/inetd.conf /etc/inetd.conf.old
146	cat /etc/services \|grep -v gds_db >/etc/services.new
147	cat /etc/inetd.conf \|grep -v gds_db >/etc/inetd.conf.new
148	mv /etc/services.new /etc/services
149	mv /etc/inetd.conf.new /etc/inetd.conf
150
151	# add the gds service and restart inetd
152	cat >>/etc/services <<EOF
153	gds_db 3050/tcp #InterBase Database Remote Protocol
154	EOF
155	cat >>/etc/inetd.conf <<EOF
156	gds_db stream tcp nowait firebird $PKG_PREFIX/firebird/bin/fb_inet_server fb_inet_server
157	EOF
158	if [ -f /var/run/inetd.pid ]; then
159	kill -HUP `cat /var/run/inetd.pid`
160	fi
161
162	# shared lib startup script
163	if [ -d $PKG_PREFIX/etc/rc.d ]; then
164	(
165	echo "#!/bin/sh"; echo "[ -d $PKG_PREFIX/firebird/lib ] && /sbin/ldconfig -m $PKG_PREFIX/firebird/lib"
166	) > $PKG_PREFIX/etc/rc.d/000.firebird.sh
167	chmod a=rx $PKG_PREFIX/etc/rc.d/000.firebird.sh
168	fi
169	;;
170
171	esac

Lines 1-24 Link Here

(-)./databases/firebird/pkg-message (-24 lines)
1
2	---------------------------------------------------------
3	Firebird is now installed. A symbolic link from
4	/usr/interbase -> %%PREFIX%%/firebird may be needed
5	for compatibility with existing programs that use
6	Firebird.
7
8	The symbolic link can be created with:
9
10	% ln -s %%PREFIX%%/firebird /usr/interbase
11
12	It is STRONGLY recommended that you change the SYSDBA
13	password with:
14
15	% cd %%PREFIX%%/firebird
16	% gsec -user SYSDBA -pass masterkey
17	GSEC> modify SYSDBA -pw newpassword
18	GSEC> quit
19
20	before doing anything serious with Firebird.
21
22	See %%PREFIX%%/firebird/RELNOTES for more.
23	---------------------------------------------------------
24

Lines 1-130 Link Here

(-)./databases/firebird/pkg-plist (-130 lines)
1	etc/rc.d/000.firebird.sh
2	firebird/README
3	firebird/RELNOTES
4	firebird/UDF/fbudf.so
5	firebird/UDF/fbudf.sql
6	firebird/UDF/ib_udf.so
7	firebird/UDF/ib_udf.sql
8	firebird/WhatsNew
9	@unexec if cmp -s %D/firebird/aliases.conf %D/firebird/aliases.conf.sample; then rm -f %D/firebird/aliases.conf; fi
10	firebird/aliases.conf.sample
11	@exec [ -f %B/aliases.conf ] \|\| cp %B/%f %B/aliases.conf
12	firebird/bin/fb_inet_server
13	firebird/bin/fb_lock_mgr
14	firebird/bin/fb_lock_print
15	firebird/bin/gbak
16	firebird/bin/gdef
17	firebird/bin/gds_drop
18	firebird/bin/gfix
19	firebird/bin/gpre
20	firebird/bin/gsec
21	firebird/bin/gstat
22	firebird/bin/isql
23	firebird/bin/qli
24	firebird/doc/README.NTSecurity
25	firebird/doc/README.Win32LibraryInstallation.txt
26	firebird/doc/README.build.mingw.html
27	firebird/doc/README.build.msvc.html
28	firebird/doc/README.install.Solaris_on_Intel
29	firebird/doc/README.instsvc
30	firebird/doc/README.makefiles
31	firebird/doc/README.user
32	firebird/doc/README.user.embedded
33	firebird/doc/README.user.troubleshooting
34	firebird/doc/sql.extensions/README.aggregate_tracking
35	firebird/doc/sql.extensions/README.case
36	firebird/doc/sql.extensions/README.coalesce
37	firebird/doc/sql.extensions/README.context_variables
38	firebird/doc/sql.extensions/README.data_types
39	firebird/doc/sql.extensions/README.exception_handling
40	firebird/doc/sql.extensions/README.execute_statement
41	firebird/doc/sql.extensions/README.explicit_locks
42	firebird/doc/sql.extensions/README.nullif
43	firebird/doc/sql.extensions/README.order_by_expressions_nulls
44	firebird/doc/sql.extensions/README.savepoints
45	firebird/doc/sql.extensions/README.universal_triggers
46	firebird/examples/align.h
47	firebird/examples/api1.c
48	firebird/examples/api10.c
49	firebird/examples/api11.c
50	firebird/examples/api12.c
51	firebird/examples/api13.c
52	firebird/examples/api14.e
53	firebird/examples/api15.c
54	firebird/examples/api16.c
55	firebird/examples/api16t.c
56	firebird/examples/api2.c
57	firebird/examples/api3.c
58	firebird/examples/api4.c
59	firebird/examples/api5.c
60	firebird/examples/api6.c
61	firebird/examples/api7.c
62	firebird/examples/api8.c
63	firebird/examples/api9.c
64	firebird/examples/api9f.c
65	firebird/examples/api9f.sql
66	firebird/examples/apifull.c
67	firebird/examples/dyn1.e
68	firebird/examples/dyn2.e
69	firebird/examples/dyn3.e
70	firebird/examples/dyn4.e
71	firebird/examples/dyn5.e
72	firebird/examples/dynfull.e
73	firebird/examples/employe2.sql
74	firebird/examples/employee.fdb
75	firebird/examples/employee.gbk
76	firebird/examples/example.h
77	firebird/examples/readme
78	firebird/examples/stat1.e
79	firebird/examples/stat10.e
80	firebird/examples/stat11.e
81	firebird/examples/stat12.e
82	firebird/examples/stat12t.e
83	firebird/examples/stat2.e
84	firebird/examples/stat3.e
85	firebird/examples/stat4.e
86	firebird/examples/stat5.e
87	firebird/examples/stat6.e
88	firebird/examples/stat7.e
89	firebird/examples/stat8.e
90	firebird/examples/stat9.e
91	firebird/examples/udf.sql
92	firebird/examples/udflib.c
93	@unexec if cmp -s %D/firebird/firebird.conf %D/firebird/firebird.conf.sample; then rm -f %D/firebird/firebird.conf; fi
94	firebird/firebird.conf.sample
95	@exec [ -f %B/firebird.conf ] \|\| cp %B/%f %B/firebird.conf
96	@unexec [ -s %D/firebird/firebird.log ] \|\| rm -f %D/firebird/firebird.log
97	firebird/firebird.msg
98	firebird/help/help.fdb
99	firebird/include/blr.h
100	firebird/include/gds.h
101	firebird/include/ib_util.h
102	firebird/include/ibase.h
103	firebird/include/iberror.h
104	firebird/include/perf.h
105	firebird/intl/fbintl
106	@unexec rm -f %D/firebird/isc_event1.`hostname`
107	@unexec rm -f %D/firebird/isc_init1.`hostname`
108	@unexec rm -f %D/firebird/isc_lock1.`hostname`
109	firebird/lib/libfbclient.so
110	firebird/lib/libfbclient.so.1
111	firebird/lib/libfbclient.so.%%FIREBIRD_VERSION%%
112	firebird/lib/libfbembed.so
113	firebird/lib/libfbembed.so.1
114	firebird/lib/libfbembed.so.%%FIREBIRD_VERSION%%
115	firebird/lib/libgds.so
116	firebird/lib/libgds.so.1
117	firebird/lib/libib_util.so
118	@unexec if cmp -s %D/firebird/security.fdb %D/firebird/security.fdb.sample; then rm -f %D/firebird/security.fdb; fi
119	firebird/security.fdb.sample
120	@exec [ -f %B/security.fdb ] \|\| cp %B/%f %B/security.fdb
121	@dirrm firebird/UDF
122	@dirrm firebird/bin
123	@dirrm firebird/doc/sql.extensions
124	@dirrm firebird/doc
125	@dirrm firebird/examples
126	@dirrm firebird/help
127	@dirrm firebird/include
128	@dirrm firebird/intl
129	@dirrm firebird/lib
130	@dirrm firebird

Line 0 Link Here

(-)./databases/firebird-client/Makefile (+19 lines)
	1	# New ports collection makefile for: firebird-client
	2	# Date created: 2005 Mar 03
	3	# Whom: Renato Botelho <renato@galle.com.br>
	4	#
	5	# $FreeBSD$
	6	#
	7
	8	PORTNAME= firebird
	9	PKGNAMESUFFIX= -client
	10
	11	COMMENT= The open-source InterBase(tm) 6.0 spin-off (client)
	12
	13	MASTERDIR= ${.CURDIR}/../firebird-server
	14
	15	PLIST= ${PKGDIR}/pkg-plist.client
	16
	17	CLIENT_ONLY= yes
	18
	19	.include "${MASTERDIR}/Makefile"

Line 0 Link Here

(-)./databases/firebird-server/Makefile (+201 lines)
		1	# New ports collection makefile for: Firebird
		2	# Date created: 20 December 2000
		3	# Whom: Geoffrey C. Speicher <geoff@sea-incorporated.com>
		4	#
		5	# $FreeBSD: ports/databases/firebird/Makefile,v 1.36 2005/02/14 17:26:19 vs Exp $
		6	#
		7
		8	PORTNAME?= firebird
		9	PORTVERSION= 1.5.2
		10	CATEGORIES?= databases
		11	MASTER_SITES= ${MASTER_SITE_SOURCEFORGE}
		12	MASTER_SITE_SUBDIR=firebird
		13	PKGNAMESUFFIX?= -server
		14	DISTNAME= firebird-1.5.2.4731
		15
		16	MAINTAINER= renato@galle.com.br
		17	COMMENT?= The open-source InterBase(tm) 6.0 spin-off (Classic version)
		18
		19	USE_REINPLACE= yes
		20	USE_BISON= yes
		21	USE_BZIP2= yes
		22	USE_GMAKE= yes
		23	GNU_CONFIGURE= yes
		24	USE_LIBTOOL_VER= 15
		25	USE_AUTOCONF_VER= 259
		26	USE_GCC= 3.4
		27
		28	PLIST_SUB= FIREBIRD_VERSION=${PORTVERSION}
		29
		30	# Don't use ld for linking, use gcc
		31	LD= gcc
		32
		33	# Don't strip binary files
		34	STRIP=
		35
		36	ONLY_FOR_ARCHS= i386
		37
		38	WRKSRC= ${WRKDIR}/${DISTNAME}
		39
		40	.if !defined(CLIENT_ONLY)
		41	# Server part stuff
		42	LIB_DEPENDS+= fbembed.1:${PORTSDIR}/databases/firebird-client
		43
		44	AUTOGENARGS= --prefix=${PREFIX}/firebird \
		45	--with-lock-manager
		46
		47	ALL_TARGET= firebird_boot ref_databases msgs intl otherfiles \
		48	inet_server extlib
		49
		50	# Use own user and group when install server part
		51	BINOWN= firebird
		52	BINGRP= firebird
		53	BINMODE= 550
		54	SHAREOWN= firebird
		55	SHAREGRP= firebird
		56
		57	PKGMESSAGE= ${WRKDIR}/pkg-message
		58	PKGINSTALL= ${WRKDIR}/pkg-install
		59
		60	CONFLICTS= firebird-devel-[0-9]*
		61	.else
		62	# Client part stuff
		63	AUTOGENARGS= --prefix=${PREFIX} \
		64	--with-editline
65
66	ALL_TARGET= firebird_basic libfbembed embed_gfix embed_gbak embed_isql embed_gpre \
67	embed_util embed_gdef embed_qli libfbclient extlib
68
69	INSTALLS_SHLIB= yes
70	.endif
71
72	.include <bsd.port.pre.mk>
73
74	.if !defined(CLIENT_ONLY)
75	pre-everything::
76	@${ECHO_MSG} "NOTE: If the work directory is on an NFS mount, you will"
77	@${ECHO_MSG} "require NFS client locking support for the build to"
78	@${ECHO_MSG} "succeed. Currently this is only available on FreeBSD 5.0"
79	@${ECHO_MSG} "or greater."
80	@${ECHO_MSG}
81	@${ECHO_MSG} "WARNING: The on-disk structure of the databases has"
82	@${ECHO_MSG} "changed since version 1.0.x."
83	@${ECHO_MSG} "Cancel this installation now and backup your databases"
84	@${ECHO_MSG} "if you have not already done so."
85	.if !defined(BATCH)
86	@sleep 10
87	.endif
88
89	post-patch:
90	@${REINPLACE_CMD} -e 's\|^\(LINK_OPTS +=.*\)$$\|\1 -L${LOCALBASE}/lib\|' \
91	${WRKSRC}/builds/posix/Makefile.in.inet_server
92
93	post-build:
94	${SED} 's\|%%PREFIX%%\|${PREFIX}\|g' \
95	< ${FILESDIR}/pkg-message.in \
96	> ${PKGMESSAGE}
97
98	${SED} -e 's\|%%PREFIX%%\|${PREFIX}/firebird\|g' \
99	< ${FILESDIR}/pkg-install.in \
100	> ${PKGINSTALL}
101
102	${SED} -e "s\|%%PREFIX%%\|${PREFIX}/firebird\|g" \
103	< ${FILESDIR}/aliases.conf.in \
104	> ${WRKDIR}/aliases.conf
105
106	pre-install:
107	${SETENV} PKG_PREFIX="${PREFIX}" PKG_DESTDIR="${DESTDIR}" ${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
108
109	post-install:
110	${SETENV} PKG_PREFIX="${PREFIX}" PKG_DESTDIR="${DESTDIR}" ${SH} ${PKGINSTALL} ${PORTNAME} POST-INSTALL
111	@${ECHO_MSG}
112	@${CAT} ${PKGMESSAGE}
113	@${ECHO_MSG}
114	.endif
115
116	patch-autotools:
117	@${DO_NADA}
118
119	run-autotools:
120	@${DO_NADA}
121
122	do-configure:
123	@(cd ${WRKSRC} && ${SETENV} CC=${CC} CXX=${CXX} MAKE=${GMAKE} \
124	${AUTOTOOLS_VARS} ./autogen.sh ${AUTOGENARGS})
125
126	post-configure:
127	@${REINPLACE_CMD} -e 's\|__attribute__ ((__unused__));\|\|' \
128	${WRKSRC}/src/dsql/parse.cpp
129
130	do-install:
131	.if !defined(CLIENT_ONLY)
132
133	${MKDIR} ${PREFIX}/firebird
134	${CHOWN} ${BINOWN}:${BINGRP} ${PREFIX}/firebird
135
136	.for f in UDF bin help intl
137	${MKDIR} ${PREFIX}/firebird/${f}
138	${CHOWN} ${BINOWN}:${BINGRP} ${PREFIX}/firebird/${f}
139	.endfor
140
141	${INSTALL_DATA} ${WRKDIR}/aliases.conf ${PREFIX}/firebird/aliases.conf.sample
142	${INSTALL_DATA} ${WRKSRC}/gen/firebird/misc/firebird.conf ${PREFIX}/firebird/firebird.conf.sample
143	${INSTALL_DATA} ${WRKSRC}/gen/firebird/security.fdb ${PREFIX}/firebird/security.fdb.sample
144	${CHMOD} 660 ${PREFIX}/firebird/security.fdb.sample
145
146	${INSTALL_DATA} ${WRKSRC}/gen/firebird/firebird.msg ${PREFIX}/firebird/firebird.msg
147	${INSTALL_DATA} ${WRKSRC}/gen/firebird/help/help.fdb ${PREFIX}/firebird/help
148
149	.for f in ib_udf.so fbudf.so
150	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/UDF/${f} ${PREFIX}/firebird/UDF
151	.endfor
152
153	.for f in src/extlib/ib_udf.sql src/extlib/fbudf/fbudf.sql
154	${INSTALL_SCRIPT} ${WRKSRC}/${f} ${PREFIX}/firebird/UDF
155	.endfor
156
157	.for f in fb_inet_server fb_lock_mgr
158	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/bin/${f} ${PREFIX}/firebird/bin
159	${CHMOD} u+s ${PREFIX}/firebird/bin/${f}
160	.endfor
161
162	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/intl/libfbintl.so ${PREFIX}/firebird/intl/fbintl
163
164	${INSTALL_DATA} ${FILESDIR}/RELNOTES ${PREFIX}/firebird
165
166	.else
167
168	.for dir in include share/doc/firebird \
169	share/doc/firebird/sql.extensions share/examples/firebird
170	${MKDIR} ${PREFIX}/${dir}
171	.endfor
172
173	.for f in fb_lock_print gbak gdef gds_drop gfix gpre gsec gstat isql qli
174	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/bin/${f} ${PREFIX}/bin
175	.endfor
176
177	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libfbclient.so.${PORTVERSION} ${PREFIX}/lib
178	${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libfbclient.so.1
179	${LN} -fs libfbclient.so.1 ${PREFIX}/lib/libfbclient.so
180
181	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libfbembed.so.${PORTVERSION} ${PREFIX}/lib
182	${LN} -fs libfbembed.so.${PORTVERSION} ${PREFIX}/lib/libfbembed.so.1
183	${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libfbembed.so
184
185	${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libgds.so.1
186	${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libgds.so
187
188	${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libib_util.so ${PREFIX}/lib
189
190	${INSTALL_DATA} ${WRKSRC}/gen/firebird/include/*.h ${PREFIX}/include
191
192	${INSTALL_DATA} ${WRKSRC}/doc/WhatsNew ${PREFIX}/share/doc/firebird
193	${INSTALL_DATA} ${WRKSRC}/doc/README.* ${PREFIX}/share/doc/firebird
194	${INSTALL_DATA} ${WRKSRC}/doc/README.user ${PREFIX}/share/doc/firebird/README
195	${INSTALL_DATA} ${WRKSRC}/doc/sql.extensions/README.* ${PREFIX}/share/doc/firebird/sql.extensions
196
197	# Install examples
198	${INSTALL_DATA} ${WRKSRC}/gen/firebird/examples/v5/* ${PREFIX}/share/examples/firebird
199	.endif
200
201	.include <bsd.port.post.mk>

Line 0 Link Here

(-)./databases/firebird-server/files/RELNOTES (+108 lines)
		1	Firebird 1.5.1 FreeBSD Release Notes 19-Jul-2004
		2	--------------------------------------
		3	FB-V1.5.1.4481 Firebird 1.5 Release
		4
		5	Welcome to the FreeBSD Firebird port!
		6
		7	Firebird is installed SUID with owner and group `firebird'.
		8	This does affect where you can and cannot create databases when
		9	connecting remotely, as well as which existing databases you can
		10	access. If you want a database to be available remotely, be sure
		11	it's readable and writeable to group firebird.
		12
		13	There may be times when you manage to get your system into a
		14	state where using any of the Firebird utilites (isql, gbak, gsec,
		15	etc.) gives you the message "semget failed". One surefire way to
		16	do this is to build and install the port. :) If this happens,
		17	make sure that the lock manager is not running and its semaphores
		18	have been removed. The former can be accomplished with 'ps ax
		19	\|grep fb' and 'kill'; the latter with 'ipcs -s' and 'ipcrm -s'.
		20
		21	For example, after building and installing the port, you will
		22	probably go through something like this:
		23
		24	# isql /usr/local/firebird/security.fdb
		25	Statement failed, SQLCODE = -902
		26
		27	operating system directive semget failed
		28	-No such file or directory
		29
		30	# ipcs -s
		31	Semaphores:
		32	T ID KEY MODE OWNER GROUP
		33	s 1310720 252034728 --rw-rw-rw- root wheel
		34
		35	# ipcrm -s 1310720
		36
		37	and you should be in business.
		38
		39	Once this is done, you should be able to connect normally to
		40	databases. Your first connection will restart the lock manager.
		41
		42	There may be times, however, when you still get "semget failed"
		43	even though the lock manager is not running and the semaphores have
		44	been cleaned up. There seems to be a conflict with this release
		45	and the PostgreSQL 7 release as installed from the ports collection.
		46	If you're having trouble with Firebird and you're running PostgreSQL,
		47	try stopping PostgreSQL:
		48
		49	/usr/local/etc/rc.d/pgsql.sh stop
		50
		51	and see if that helps. Alternatively, increase the value of SEMMNS
		52	by 48 in your kernel configuration file. This can be found by getting
		53	the current value with 'sysctl -a \| grep semmns'. You can either add
		54	this to your kernel config, or add the following line to /boot/loader.conf:
		55
		56	kern.ipc.semmns=X
		57
		58	where is is the current value plus 48. If this doesn't resolve the issue,
		59	try adding 48 again.
		60
		61	Please note that as of RC8, the libgds.so symlink now points to
		62	libfbembed.so. This has been done to resolve compatability issues with
		63	older versions of Firebird. The FreeBSD port of RC7 had libgds.so
		64	pointing to libfbclient.so. libfbclient.so is a remote access-only
65	shared library with threaded support, which requires target applications
66	to link with a threaded library such as libc_r.so, libpthread.so or libthr.so.
67
68	Super Server support in Firebird 1.5 for FreeBSD is not currently
69	available due to the Firebird code using POSIX threads APIs not available
70	in FreeBSD 4.x or not yet complete in FreeBSD 5.x. This issue will become
71	more important once the scalability issues of Super Server have been
72	resolved.
73
74	This installation has already inserted the necessary line to
75	/etc/inetd.conf so that you can connect to Firebird across the network.
76	However you may need to add the remote host to /etc/hosts.equiv. For
77	example, to allow the local machine to make connections to Firebird
78	using TCP, the following command needs running:
79
80	echo localhost >> /etc/hosts.equiv
81
82	Please note that adding machines to /etc/hosts.equiv can reduce the
83	security of your system. If in doubt, try connecting to Firebird with
84	a username and password already defined in security.fdb. For example:
85
86	gsec
87	> add myuser -pass mypass
88	> quit
89	isql -u myuser -p mypass localhost:/usr/local/firebird/examples/employee.fdb
90
91	This should reduce the need for hosts defined in /etc/hosts.equiv.
92
93	Complete documentation for InterBase(tm) is available (free of
94	charge) from http://www.interbase.com/ in PDF format. While
95	InterBase and Firebird are two distinct entities, all InterBase
96	documentation is pertinent to Firebird. More information on Firebird
97	and InterBase can be found at the following:
98
99	http://sourceforge.net/projects/firebird/
100	http://www.ibphoenix.com/
101	http://www.interbase2000.org/
102	http://www.firebirdsql.org/
103
104	Please also see the doc directory in the Firebird package for
105	documentation specific to Firebird.
106
107	Chris Knight
108	<chris@e-easy.com.au>

Line 0 Link Here

(-)./databases/firebird-server/files/patch-builds::posix::Makefile.in.inet_server (+20 lines)
	1	--- builds/posix/Makefile.in.inet_server.orig Fri Sep 17 20:34:21 2004
	2	+++ builds/posix/Makefile.in.inet_server Wed Mar 2 16:09:41 2005
	3	@@ -39,6 +39,8 @@
	4
	5	@SET_MAKE@
	6
	7	+LINK_OPTS +=
	8	+
	9	SERVER_Files = server_stub.cpp
	10	SERVER_Sources = $(addprefix remote/, $(SERVER_Files))
	11	SERVER_Objects = $(addprefix $(OBJ)/, $(addsuffix .o, $(basename $(SERVER_Sources))))
	12	@@ -51,7 +53,7 @@
	13
	14	# SD: We don't need to rebuild fb_inet_server every time libfbembed.so changed,
	15	# but we must ensure it's existance
	16	-fb_inet_server : $(LIBFBEMBED_SO) $(FB_CLASSIC_SERVER)
	17	+fb_inet_server : $(FB_CLASSIC_SERVER)
	18
	19	$(FB_CLASSIC_SERVER): $(SERVER_Objects)
	20	$(LD) $(LINK_OPTS) $^ -o $@ $(FBEMBED_LINK) $(LIB_GUI) $(LINK_LIBS)

Line 0 Link Here

(-)./databases/firebird-server/files/pkg-install.in (+70 lines)
		1	#!/bin/sh
		2
		3	PATH=/sbin:/usr/sbin:/usr/local/sbin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin:%%PREFIX%%/bin
		4	PREFIX=%%PREFIX%%
		5	DB_DIR=%%PREFIX%%
		6
		7	USER=firebird
		8	GROUP=${USER}
		9	UID=3050
		10	GID=${UID}
		11	HOME=${DB_DIR}
		12	DESCR="Firebird Database Administrator"
		13
		14	case $2 in
		15	PRE-INSTALL)
		16	if pw group show "${GROUP}" 2> /dev/null; then
		17	echo "You already have a group \"${GROUP}\", so I will use it."
		18	else
		19	if pw groupadd ${GROUP} -g ${GID}; then
		20	echo "Added group \"${GROUP}\"."
		21	else
		22	echo "Adding group \"${GROUP}\" failed..."
		23	exit 1
		24	fi
		25	fi
		26
		27	if pw user show "${USER}" 2> /dev/null; then
		28	echo "You already have a user \"${USER}\", so I will use it."
		29
		30	if pw usermod ${USER} -d ${HOME}; then
		31	echo "Changed home directory of \"${USER}\" to \"${HOME}\""
		32	else
		33	echo "Changing home directory of \"${USER}\" to \"${HOME}\" failed..."
		34	exit 1
		35	fi
		36	else
		37	if pw useradd ${USER} -u ${UID} -g ${GROUP} -h - -d ${NOME} -s /sbin/nologin -c "${DESCR}" ; then
		38	echo "Added user \"${USER}\"."
		39	else
		40	echo "Adding user \"${USER}\" failed..."
		41	exit 1
		42	fi
		43	fi
		44	;;
		45
		46	POST-INSTALL)
		47	for f in isc_init1.`hostname` isc_lock1.`hostname` isc_event1.`hostname` firebird.log
		48	do
		49	touch ${PREFIX}/${f}
		50	chown ${USER}:${GROUP} ${PREFIX}/$f
		51	chmod 660 ${PREFIX}/${f}
		52	done
		53
		54	# add the gds service and restart inetd
		55	cat /etc/services \| grep -v gds_db > /etc/services.new
		56	cat >>/etc/services.new <<EOF
		57	gds_db 3050/tcp #InterBase Database Remote Protocol
		58	EOF
		59	mv /etc/services.new /etc/services
		60
		61	cat /etc/inetd.conf \| grep -v gds_db > /etc/inetd.conf.new
		62	cat >>/etc/inetd.conf.new <<EOF
		63	gds_db stream tcp nowait firebird ${PREFIX}/bin/fb_inet_server fb_inet_server
		64	EOF
65	mv /etc/inetd.conf.new /etc/inetd.conf
66
67	if [ -f /var/run/inetd.pid ]; then
68	kill -HUP `cat /var/run/inetd.pid`
69	fi
70	esac

Line 0 Link Here

(-)./databases/firebird-server/pkg-descr (+15 lines)
	1	The open-source InterBase(tm) 6.0 spin-off (Classic server version)
	2
	3	InterBase is a world-class DBMS with a history too rich to detail
	4	here. Once selling for several thousands of dollars per license,
	5	some very big players use it worldwide. Inprise has open-sourced
	6	InterBase 6.0, and a lively bunch of folks has charged themselves
	7	with seeing that it lives on through the Firebird project.
	8
	9	For more information on Firebird and InterBase, see:
	10
	11	WWW: http://sourceforge.net/projects/firebird/
	12	WWW: http://www.ibphoenix.com/
	13	WWW: http://www.interbase2000.org/
	14	WWW: http://www.interbase.com/
	15	WWW: http://www.firebirdsql.org/

Line 0 Link Here

(-)./databases/firebird-server/pkg-plist (+28 lines)
	1	firebird/RELNOTES
	2	firebird/UDF/fbudf.so
	3	firebird/UDF/fbudf.sql
	4	firebird/UDF/ib_udf.so
	5	firebird/UDF/ib_udf.sql
	6	@unexec if cmp -s %D/firebird/aliases.conf %D/firebird/aliases.conf.sample; then rm -f %D/firebird/aliases.conf; fi
	7	firebird/aliases.conf.sample
	8	@exec [ -f %B/aliases.conf ] \|\| cp %B/%f %B/aliases.conf
	9	firebird/bin/fb_inet_server
	10	firebird/bin/fb_lock_mgr
	11	@unexec if cmp -s %D/firebird/firebird.conf %D/firebird/firebird.conf.sample; then rm -f %D/firebird/firebird.conf; fi
	12	firebird/firebird.conf.sample
	13	@exec [ -f %B/firebird.conf ] \|\| cp %B/%f %B/firebird.conf
	14	@unexec [ -s %D/firebird/firebird.log ] \|\| rm -f %D/firebird/firebird.log
	15	firebird/firebird.msg
	16	firebird/help/help.fdb
	17	firebird/intl/fbintl
	18	@unexec rm -f %D/firebird/isc_event1.`hostname`
	19	@unexec rm -f %D/firebird/isc_init1.`hostname`
	20	@unexec rm -f %D/firebird/isc_lock1.`hostname`
	21	@unexec if cmp -s %D/firebird/security.fdb %D/firebird/security.fdb.sample; then rm -f %D/firebird/security.fdb; fi
	22	firebird/security.fdb.sample
	23	@exec [ -f %B/security.fdb ] \|\| cp %B/%f %B/security.fdb
	24	@dirrm firebird/UDF
	25	@dirrm firebird/bin
	26	@dirrm firebird/help
	27	@dirrm firebird/intl
	28	@dirrm firebird

Line 0 Link Here

(-)./databases/firebird-server/pkg-plist.client (+99 lines)
		1	bin/fb_lock_print
		2	bin/gbak
		3	bin/gdef
		4	bin/gds_drop
		5	bin/gfix
		6	bin/gpre
		7	bin/gsec
		8	bin/gstat
		9	bin/isql
		10	bin/qli
		11	include/blr.h
		12	include/gds.h
		13	include/ib_util.h
		14	include/ibase.h
		15	include/iberror.h
		16	include/perf.h
		17	lib/libfbclient.so
		18	lib/libfbclient.so.1
		19	lib/libfbclient.so.%%FIREBIRD_VERSION%%
		20	lib/libfbembed.so
		21	lib/libfbembed.so.1
		22	lib/libfbembed.so.%%FIREBIRD_VERSION%%
		23	lib/libgds.so
		24	lib/libgds.so.1
		25	lib/libib_util.so
		26	%%DOCSDIR%%/README.NTSecurity
		27	%%DOCSDIR%%/README.Win32LibraryInstallation.txt
		28	%%DOCSDIR%%/README.build.mingw.html
		29	%%DOCSDIR%%/README.build.msvc.html
		30	%%DOCSDIR%%/README.install.Solaris_on_Intel
		31	%%DOCSDIR%%/README.instsvc
		32	%%DOCSDIR%%/README.makefiles
		33	%%DOCSDIR%%/README.user
		34	%%DOCSDIR%%/README.user.embedded
		35	%%DOCSDIR%%/README.user.troubleshooting
		36	%%DOCSDIR%%/README
		37	%%DOCSDIR%%/WhatsNew
		38	%%DOCSDIR%%/sql.extensions/README.aggregate_tracking
		39	%%DOCSDIR%%/sql.extensions/README.case
		40	%%DOCSDIR%%/sql.extensions/README.coalesce
		41	%%DOCSDIR%%/sql.extensions/README.context_variables
		42	%%DOCSDIR%%/sql.extensions/README.data_types
		43	%%DOCSDIR%%/sql.extensions/README.exception_handling
		44	%%DOCSDIR%%/sql.extensions/README.execute_statement
		45	%%DOCSDIR%%/sql.extensions/README.explicit_locks
		46	%%DOCSDIR%%/sql.extensions/README.nullif
		47	%%DOCSDIR%%/sql.extensions/README.order_by_expressions_nulls
		48	%%DOCSDIR%%/sql.extensions/README.savepoints
		49	%%DOCSDIR%%/sql.extensions/README.universal_triggers
		50	%%EXAMPLESDIR%%/align.h
		51	%%EXAMPLESDIR%%/api1.c
		52	%%EXAMPLESDIR%%/api10.c
		53	%%EXAMPLESDIR%%/api11.c
		54	%%EXAMPLESDIR%%/api12.c
		55	%%EXAMPLESDIR%%/api13.c
		56	%%EXAMPLESDIR%%/api14.e
		57	%%EXAMPLESDIR%%/api15.c
		58	%%EXAMPLESDIR%%/api16.c
		59	%%EXAMPLESDIR%%/api16t.c
		60	%%EXAMPLESDIR%%/api2.c
		61	%%EXAMPLESDIR%%/api3.c
		62	%%EXAMPLESDIR%%/api4.c
		63	%%EXAMPLESDIR%%/api5.c
		64	%%EXAMPLESDIR%%/api6.c
65	%%EXAMPLESDIR%%/api7.c
66	%%EXAMPLESDIR%%/api8.c
67	%%EXAMPLESDIR%%/api9.c
68	%%EXAMPLESDIR%%/api9f.c
69	%%EXAMPLESDIR%%/api9f.sql
70	%%EXAMPLESDIR%%/apifull.c
71	%%EXAMPLESDIR%%/dyn1.e
72	%%EXAMPLESDIR%%/dyn2.e
73	%%EXAMPLESDIR%%/dyn3.e
74	%%EXAMPLESDIR%%/dyn4.e
75	%%EXAMPLESDIR%%/dyn5.e
76	%%EXAMPLESDIR%%/dynfull.e
77	%%EXAMPLESDIR%%/employe2.sql
78	%%EXAMPLESDIR%%/employee.fdb
79	%%EXAMPLESDIR%%/employee.gbk
80	%%EXAMPLESDIR%%/example.h
81	%%EXAMPLESDIR%%/readme
82	%%EXAMPLESDIR%%/stat1.e
83	%%EXAMPLESDIR%%/stat10.e
84	%%EXAMPLESDIR%%/stat11.e
85	%%EXAMPLESDIR%%/stat12.e
86	%%EXAMPLESDIR%%/stat12t.e
87	%%EXAMPLESDIR%%/stat2.e
88	%%EXAMPLESDIR%%/stat3.e
89	%%EXAMPLESDIR%%/stat4.e
90	%%EXAMPLESDIR%%/stat5.e
91	%%EXAMPLESDIR%%/stat6.e
92	%%EXAMPLESDIR%%/stat7.e
93	%%EXAMPLESDIR%%/stat8.e
94	%%EXAMPLESDIR%%/stat9.e
95	%%EXAMPLESDIR%%/udf.sql
96	%%EXAMPLESDIR%%/udflib.c
97	@dirrm %%DOCSDIR%%/sql.extensions
98	@dirrm %%DOCSDIR%%
99	@dirrm %%EXAMPLESDIR%%

Lines 16-27 Link Here

(-)./databases/p5-DBD-InterBase/Makefile (-2 / +2 lines)
16	MAINTAINER= skv@FreeBSD.org	16	MAINTAINER= skv@FreeBSD.org
17	COMMENT= DBI driver for InterBase RDBMS server	17	COMMENT= DBI driver for InterBase RDBMS server
18		18
19	LIB_DEPENDS= gds:${PORTSDIR}/databases/firebird	19	LIB_DEPENDS= gds:${PORTSDIR}/databases/firebird-client
20		20
21	PERL_CONFIGURE= yes	21	PERL_CONFIGURE= yes
22		22
23	post-patch:	23	post-patch:
24	@${PERL} -pi -e 's,%%IB_BASE%%,${PREFIX}/firebird,g' \	24	@${PERL} -pi -e 's,%%IB_BASE%%,${LOCALBASE},g' \
25	${WRKSRC}/Makefile.PL	25	${WRKSRC}/Makefile.PL
26		26
27	MAN3= Bundle::DBD::InterBase.3 DBD::InterBase.3 DBD::InterBase::FAQ.3	27	MAN3= Bundle::DBD::InterBase.3 DBD::InterBase.3 DBD::InterBase::FAQ.3

Lines 15-29 Link Here

(-)./databases/ruby-interbase/Makefile (-3 / +3 lines)
15	MAINTAINER= skv@FreeBSD.org	15	MAINTAINER= skv@FreeBSD.org
16	COMMENT= Ruby interface to Interbase library	16	COMMENT= Ruby interface to Interbase library
17		17
18	LIB_DEPENDS= gds:${PORTSDIR}/databases/firebird	18	LIB_DEPENDS= gds:${PORTSDIR}/databases/firebird-client
19		19
20	WRKSRC= ${WRKDIR}/${PORTNAME}	20	WRKSRC= ${WRKDIR}/${PORTNAME}
21		21
22	USE_RUBY= yes	22	USE_RUBY= yes
23	USE_RUBY_EXTCONF= yes	23	USE_RUBY_EXTCONF= yes
24		24
25	CONFIGURE_ARGS= --with-interbase-include-dir="${LOCALBASE}/firebird/include" \	25	CONFIGURE_ARGS= --with-interbase-include-dir="${LOCALBASE}/include" \
26	--with-interbase-lib-dir="${LOCALBASE}/firebird/lib"	26	--with-interbase-lib-dir="${LOCALBASE}/lib"
27	INSTALL_TARGET= site-install	27	INSTALL_TARGET= site-install
28		28
29	DOCS_EN= README	29	DOCS_EN= README