Add Firebird 2.0.0 (RC4)

author: skv <skv@FreeBSD.org> 2006-09-18 23:20:04 +0800
committer: skv <skv@FreeBSD.org> 2006-09-18 23:20:04 +0800
commit: 564178a4172be5efcd24281408bd2870970931da (patch)
tree: 9f680c3a0e5ca1f70980f0d8ffb3516bb21ca9ce /databases
parent: 024018f7ae0f0f2c7bac78542fc6bf86a817a000 (diff)
download: freebsd-ports-gnome-564178a4172be5efcd24281408bd2870970931da.tar.gz
freebsd-ports-gnome-564178a4172be5efcd24281408bd2870970931da.tar.zst
freebsd-ports-gnome-564178a4172be5efcd24281408bd2870970931da.zip
57 files changed, 593 insertions, 1412 deletions
diff --git a/databases/Makefile b/databases/Makefile
index 8482dd8d1e81..67e93a92d879 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -41,9 +41,10 @@
     SUBDIR += erserver
     SUBDIR += evolution-data-server
     SUBDIR += fastdb
-    SUBDIR += firebird-server
     SUBDIR += firebird-client
-    SUBDIR += firebird-devel
+    SUBDIR += firebird-server
+    SUBDIR += firebird2-client
+    SUBDIR += firebird2-server
     SUBDIR += fireprofile
     SUBDIR += flamerobin
     SUBDIR += fpc-gdbm
diff --git a/databases/firebird-devel/Makefile b/databases/firebird-devel/Makefile
deleted file mode 100644
index 07c53fea341a..000000000000
--- a/databases/firebird-devel/Makefile
+++ /dev/null
@@ -1,77 +0,0 @@
-# New ports collection makefile for:	Firebird-devel
-# Date created:		03 December 2001
-# Whom:			Chris Knight <chris@e-easy.com.au>
-#
-# $FreeBSD$
-#
-
-PORTNAME=	firebird
-PORTVERSION=	2.0.a3
-PORTREVISION=	1
-CATEGORIES=	databases
-MASTER_SITES=	http://www.ramenzoni.com.br/~garga/firebird/ \
-		http://www.galle.com.br/~garga/firebird/ \
-		http://www.brainsoft.com.br/~garga/firebird/
-MASTER_SITE_SUBDIR=	firebird
-PKGNAMESUFFIX=	-devel
-DISTNAME=	firebird2-20050726
-
-MAINTAINER=	skv@FreeBSD.org
-COMMENT=	The open-source InterBase(tm) 6.0 spin-off (Classic version)
-
-USE_BZIP2=		yes
-USE_GMAKE=		yes
-USE_AUTOTOOLS=	autoconf:259:env libtool:15:env
-GNU_CONFIGURE=		yes
-USE_GCC=		3.4
-
-DOCSDIR=	${PREFIX}/firebird/doc
-
-CONFLICTS=	firebird-client-1.*
-
-WRKSRC=		${WRKDIR}/firebird2
-USE_LDCONFIG=	${PREFIX}/firebird/lib
-SUB_FILES=	pkg-message pkg-install
-
-ONLY_FOR_ARCHS=	i386
-
-.include <bsd.port.pre.mk>
-
-.if ${OSVERSION} < 500000
-BROKEN=	Does not build on FreeBSD-4.x
-.endif
-
-pre-everything::
-	@${ECHO_MSG} "WARNING: The on-disk structure of the databases has"
-	@${ECHO_MSG} "changed since version 1.5.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} 's,InstallPrefix/etc,${LOCALBASE}/etc,g' \
-		${WRKSRC}/builds/install/arch-specific/freebsd/install.sh.in
-
-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:
-	@(								\
-	cd ${WRKSRC};							\
-	${SETENV} CC=${CC} CXX=${CXX} ${GMAKE} all;			\
-	)
-
-post-install:
-.if !defined(NOPORTDOCS)
-	@${MKDIR} ${DOCSDIR}/sql.extensions
-	${INSTALL_DATA} ${WRKSRC}/doc/README.* ${DOCSDIR}
-	${INSTALL_DATA} ${WRKSRC}/doc/sql.extensions/* \
-		${DOCSDIR}/sql.extensions
-.endif
-	@${CAT} ${PKGMESSAGE}
-
-.include <bsd.port.post.mk>
diff --git a/databases/firebird-devel/distinfo b/databases/firebird-devel/distinfo
deleted file mode 100644
index b6a430f60394..000000000000
--- a/databases/firebird-devel/distinfo
+++ /dev/null
@@ -1,3 +0,0 @@
-MD5 (firebird2-20050726.tar.bz2) = e95d68eef0e8faee73a9a6111debb723
-SHA256 (firebird2-20050726.tar.bz2) = 9321db92b6ece0f224c0e059a11fcd4175ccde0038ed2173b4d700b99e3fe51f
-SIZE (firebird2-20050726.tar.bz2) = 11774960
diff --git a/databases/firebird-devel/files/RELNOTES b/databases/firebird-devel/files/RELNOTES
deleted file mode 100644
index 78b29d6a2a54..000000000000
--- a/databases/firebird-devel/files/RELNOTES
+++ /dev/null
@@ -1,79 +0,0 @@
-Firebird 1.0-RC1 FreeBSD Release Notes                     06-Dec-2001
---------------------------------------
-FB-T6.2.567 Firebird Release Candidate 1
-
-Welcome to the FreeBSD Firebird port!  Users should note that there
-was a package called `firebird-1.0.tgz' released in mid-August
-2000.  Unfortunately, that package was released before Firebird
-version numbering conventions were established, so although the
-version number would suggest that it is newer than the current
-release, it is certainly not.  Users of the August 1.0 package
-should upgrade to 0.9_4 or later, which has fixed many bugs and
-security problems, including the recently-discovered back door.
-
-    Firebird originally required a running copy of Firebird (or
-InterBase) in order to build itself.  This port uses a boot kit to
-overcome that, so that it does not require itself to build.
-Unfortunately, the side effect of this is that if you have a lock
-manager running from an already-installed version of Firebird or
-InterBase, this port will not build.
-
-    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 gds' 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/interbase/isc4.gdb
-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.
-
-    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/
-
-Chris Knight
-<chris@aims.com.au>
diff --git a/databases/firebird-devel/files/patch-builds::install::arch-specific::freebsd::install.sh.in b/databases/firebird-devel/files/patch-builds::install::arch-specific::freebsd::install.sh.in
deleted file mode 100644
index 54823e8859f7..000000000000
--- a/databases/firebird-devel/files/patch-builds::install::arch-specific::freebsd::install.sh.in
+++ /dev/null
@@ -1,112 +0,0 @@
---- builds/install/arch-specific/freebsd/install.sh.in.orig	Fri May 27 19:14:45 2005
-+++ builds/install/arch-specific/freebsd/install.sh.in	Mon Aug  8 15:50:33 2005
-@@ -55,13 +55,6 @@
- InstallFirebirdPrefix=@prefix@
- InstallPrefix=${InstallFirebirdPrefix%/firebird}
- 
--if [ -d $InstallFirebirdPrefix ]; then
--	if [ -d $InstallPrefix/firebird.old ]; then
--		rm -rf $InstallPrefix/firebird.old
--	fi
--	cp -Rp $InstallFirebirdPrefix $InstallPrefix/firebird.old
--fi
--
- if [ `id -u` -ne 0 ]; then
- 	echo; echo "You must be root to run this step!"; echo; echo
- 	exit 1
-@@ -113,13 +106,12 @@
- 
- mkdir -p $DestDir 
- mkdir $DestDir/bin 
--mkdir $DestDir/examples 
- mkdir $DestDir/help 
- mkdir $DestDir/include 
- mkdir $DestDir/intl 
- mkdir $DestDir/lib
--mkdir $DestDir/doc 
--mkdir $DestDir/doc/sql.extensions 
-+#mkdir $DestDir/doc 
-+#mkdir $DestDir/doc/sql.extensions 
- mkdir $DestDir/UDF 
- #mkdir $DestDir/misc
- 
-@@ -143,18 +135,6 @@
- #cp $BuiltFBDir/bin/CSrestoreRootRunUser.sh $DestDir/bin
- #cp $BuiltFBDir/bin/changeDBAPassword.sh $DestDir/bin
- 
--# Copy examples only if we have them
--
--exampleFiles=`find $BuiltFBDir/examples/v5 -type f -print`
--if [ -z "$exampleFiles" ]; then
--	echo "Example files have not been built!"
--else
--	for i in $exampleFiles
--	do
--		cp $i $DestDir/examples
--	done
--fi
--
- copyIfExists $BuiltFBDir/help/help.gbak $DestDir/help 
- cp $BuiltFBDir/help/help.fdb $DestDir/help 
- 
-@@ -184,8 +164,8 @@
- 	    
- # Note that this copies files from outside the build tree.
- #cp $BuildRootDir/doc/*.pdf $DestDir/doc
--cp $BuildRootDir/doc/README.* $DestDir/doc
--cp $BuildRootDir/doc/sql.extensions/* $DestDir/doc/sql.extensions
-+#cp $BuildRootDir/doc/README.* $DestDir/doc
-+#cp $BuildRootDir/doc/sql.extensions/* $DestDir/doc/sql.extensions
- cp $BuildRootDir/doc/WhatsNew $DestDir/WhatsNew
- cp $BuildRootDir/doc/README.user $DestDir/README
- 
-@@ -219,11 +199,11 @@
- chown -R root:wheel $InstallFirebirdPrefix/lib
- 
- # make the following read-only
--chmod -R a=r $InstallFirebirdPrefix/WhatsNew
--for i in `find $InstallFirebirdPrefix/doc -type f -print`
--do
--	chmod a=r $i
--done
-+#chmod -R a=r $InstallFirebirdPrefix/WhatsNew
-+#for i in `find $InstallFirebirdPrefix/doc -type f -print`
-+#do
-+#	chmod a=r $i
-+#done
- #chmod -R a=r $InstallFirebirdPrefix/examples/*
- chmod -R a=r $InstallFirebirdPrefix/include/*
- chmod -R a=r $InstallFirebirdPrefix/intl/*
-@@ -276,32 +256,12 @@
- 
- # 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
- 
- # install the samples if they don't exist
- [ -f aliases.conf ] || install -o firebird -g firebird -m 440 aliases.conf.sample aliases.conf
- [ -f firebird.conf ] || install -o firebird -g firebird -m 440 firebird.conf.sample firebird.conf
- [ -f security2.fdb ] || install -o firebird -g firebird -m 660 security2.fdb.sample security2.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	$InstallFirebirdPrefix/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 $InstallPrefix/etc/rc.d ]; then
diff --git a/databases/firebird-devel/files/patch-builds::posix::prefix.freebsd b/databases/firebird-devel/files/patch-builds::posix::prefix.freebsd
deleted file mode 100644
index b327c257885a..000000000000
--- a/databases/firebird-devel/files/patch-builds::posix::prefix.freebsd
+++ /dev/null
@@ -1,11 +0,0 @@
---- builds/posix/prefix.freebsd.orig	Mon Aug  8 12:08:47 2005
-+++ builds/posix/prefix.freebsd	Mon Aug  8 12:10:25 2005
-@@ -20,6 +20,8 @@
- 
- OS_ServerFiles=inet_server.cpp
- 
-+LINK_OPTS+=-Wl,-rpath,../gen/firebird/lib
-+
- PROD_FLAGS=-O -fno-builtin -DNDEBUG -DFREEBSD -pipe -MMD -fPIC
- DEV_FLAGS=-ggdb -DFREEBSD -pipe -MMD -p -fPIC -Wall
- EMBED_UTIL_TARGETS=gstat gds_drop gds_relay gsec nbackup fb_lock_print
diff --git a/databases/firebird-devel/files/pkg-install.in b/databases/firebird-devel/files/pkg-install.in
deleted file mode 100644
index 6e86be04a227..000000000000
--- a/databases/firebird-devel/files/pkg-install.in
+++ /dev/null
@@ -1,138 +0,0 @@
-#!/bin/sh
-
-# $FreeBSD: /tmp/pcvs/ports/databases/firebird-devel/files/Attic/pkg-install.in,v 1.2 2006-07-19 15:39:52 garga Exp $
-
-PATH=/bin:/usr/bin:/usr/sbin
-
-case $2 in
-PRE-INSTALL)
-
-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.2 libgds.so.2
-
-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= security2.fdb
-
-chmod 444 aliases.conf firebird.conf
-chmod 660 security2.fdb
-
-;;
-
-esac
diff --git a/databases/firebird-devel/files/pkg-message.in b/databases/firebird-devel/files/pkg-message.in
deleted file mode 100644
index 64888f8271f4..000000000000
--- a/databases/firebird-devel/files/pkg-message.in
+++ /dev/null
@@ -1,35 +0,0 @@
-
----------------------------------------------------------
-Firebird is now installed.
-
-To start the server add the following line to /etc/services:
-
-gds_db		3050/tcp  #InterBase Database Remote Protocol
-
-And add the following line to /etc/inetd.conf
-
-gds_db	stream	tcp	nowait	firebird	%%PREFIX%%/firebird/bin/fb_inet_server  fb_inet_server
-
-And finally restart inetd.
-
-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%% /usr/interbase
-
-It is STRONGLY recommended that you change the SYSDBA
-password with:
-
-% cd %%PREFIX%%
-% gsec -user SYSDBA -pass masterkey
-GSEC> modify SYSDBA -pw newpassword
-GSEC> quit
-
-before doing anything serious with Firebird.
-
-See %%PREFIX%%/firebird/RELNOTES for more.
----------------------------------------------------------
-
diff --git a/databases/firebird-devel/pkg-descr b/databases/firebird-devel/pkg-descr
deleted file mode 100644
index bbceac30b7f9..000000000000
--- a/databases/firebird-devel/pkg-descr
+++ /dev/null
@@ -1,22 +0,0 @@
-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.
-
-Note that as of Firebird 0.9_4, the locksmith back door has
-been closed.
-
-For more information on the locksmith back door, see:
-
-WWW:	https://www.kb.cert.org/vuls/id/247371
-
-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/
diff --git a/databases/firebird-devel/pkg-plist b/databases/firebird-devel/pkg-plist
deleted file mode 100644
index 4ea431204c46..000000000000
--- a/databases/firebird-devel/pkg-plist
+++ /dev/null
@@ -1,106 +0,0 @@
-@comment $FreeBSD$
-firebird/README
-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/gsplit
-firebird/bin/gstat
-firebird/bin/isql
-firebird/bin/qli
-%%PORTDOCS%%%%DOCSDIR%%/README.NTSecurity
-%%PORTDOCS%%%%DOCSDIR%%/README.Optimizer.txt
-%%PORTDOCS%%%%DOCSDIR%%/README.Win32LibraryInstallation.txt
-%%PORTDOCS%%%%DOCSDIR%%/README.build.mingw.html
-%%PORTDOCS%%%%DOCSDIR%%/README.build.msvc.html
-%%PORTDOCS%%%%DOCSDIR%%/README.coding.style
-%%PORTDOCS%%%%DOCSDIR%%/README.intl
-%%PORTDOCS%%%%DOCSDIR%%/README.instsvc
-%%PORTDOCS%%%%DOCSDIR%%/README.isql_enhancements.txt
-%%PORTDOCS%%%%DOCSDIR%%/README.makefiles
-%%PORTDOCS%%%%DOCSDIR%%/README.performance_monitoring
-%%PORTDOCS%%%%DOCSDIR%%/README.sha1
-%%PORTDOCS%%%%DOCSDIR%%/README.user
-%%PORTDOCS%%%%DOCSDIR%%/README.user.embedded
-%%PORTDOCS%%%%DOCSDIR%%/README.user.troubleshooting
-%%PORTDOCS%%%%DOCSDIR%%/README.xnet
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.PSQL_stack_trace.txt
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.aggregate_tracking
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.case
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.coalesce
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.context_variables
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.context_variables2
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.cursors
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.data_type_results_of_aggregations.txt
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.data_types
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.ddl.txt
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.default_parameters
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.derived_tables.txt
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.distinct
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.exception_handling
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.execute_block
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.execute_statement
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.explicit_locks
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.expression_indices
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.iif
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.keywords
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.leave_labels
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.length
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.null_value
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.nullif
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.order_by_expressions_nulls
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.plan
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.returning
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.rows
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.savepoints
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.select_expressions
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.sequence_generators
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.trim
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.universal_triggers
-%%PORTDOCS%%%%DOCSDIR%%/sql.extensions/README.view_updates
-%%PORTDOCS%%@dirrm %%DOCSDIR%%/sql.extensions
-%%PORTDOCS%%@dirrm %%DOCSDIR%%
-@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 rm -f %D/firebird/firebird.log
-firebird/firebird.msg
-firebird/help/help.fdb
-firebird/include/blr.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.2
-firebird/lib/libfbclient.so.2.0.0
-firebird/lib/libfbembed.so
-firebird/lib/libfbembed.so.2
-firebird/lib/libfbembed.so.2.0.0
-firebird/lib/libib_util.so
-firebird/security2.fdb.sample
-firebird/security2.fdb
-@dirrm firebird/UDF
-@dirrm firebird/bin
-@dirrm firebird/help
-@dirrm firebird/include
-@dirrm firebird/intl
-@dirrm firebird/lib
-@dirrmtry firebird
diff --git a/databases/firebird-server/Makefile b/databases/firebird-server/Makefile
index 11662b78d616..eebdd65394d9 100644
--- a/databases/firebird-server/Makefile
+++ b/databases/firebird-server/Makefile
@@ -37,6 +37,7 @@ LD=	${CC}
 STRIP=
 
 ONLY_FOR_ARCHS=	i386 amd64
+CONFLICTS=	firebird-client-2* firebird-server-2*
 
 WRKSRC=		${WRKDIR}/${DISTNAME}
 
@@ -58,8 +59,6 @@ SUID_BIN=	fb_inet_server fb_lock_mgr gds_drop
 UTIL_BIN=	fb_lock_print gbak gdef gfix gsec gstat
 UDF_SO=		ib_udf.so fbudf.so
 UDF_SQL=	src/extlib/ib_udf.sql src/extlib/fbudf/fbudf.sql
-
-CONFLICTS=	firebird-devel-[0-9]*
 .else
 # Client part stuff
 AUTOGENARGS=	--with-editline
@@ -69,7 +68,7 @@ ALL_TARGET=	firebird_basic libfbembed embed_isql embed_gpre \
 #ALL_TARGET=	firebird_basic libfbembed libfbclient \
 #		client_gpre client_gdef client_isql client_qli extlib
 
-INSTALLS_SHLIB=	yes
+USE_LDCONFIG=	yes
 CLIENT_BIN=	gpre isql qli
 
 CONFIGURE_ENV+=	PTHREAD_CFLAGS="${PTHREAD_CFLAGS}" PTHREAD_LIBS="${PTHREAD_LIBS}"
@@ -100,16 +99,18 @@ pre-everything::
 .endif
 
 .if !defined(CLIENT_ONLY)
-pre-install:
+pre-su-install:
 	@${SETENV} PKG_PREFIX="${PREFIX}" ${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 
-post-install:
+post-su-install:
 	@${SETENV} PKG_PREFIX="${PREFIX}" ${SH} ${PKGINSTALL} ${PORTNAME} POST-INSTALL
 	@${CAT} ${PKGMESSAGE}
 .endif
 
 .ifndef WITHOUT_IPC_CLEANUP
 pre-build:
+	@if [ `${ID} -u` -eq 0 ]; then \
+	${ECHO_MSG} "==> Please do not build ${PORTNAME} as 'root' because this may cause conflicts with SysV semaphores of running services."; exit 1; fi
 	[ -f ${WRKDIR}/ipcs.pre.build ] || /usr/bin/ipcs -s | ${TAIL} -n +3 | \
 		${GREP} -F `${ID} -un` | ${CAT} > ${WRKDIR}/ipcs.pre.build
 
diff --git a/databases/firebird2-server/Makefile b/databases/firebird2-server/Makefile
index 11662b78d616..e43e14ed379d 100644
--- a/databases/firebird2-server/Makefile
+++ b/databases/firebird2-server/Makefile
@@ -1,27 +1,30 @@
-# New ports collection makefile for:	Firebird
-# Date created:		20 December 2000
-# Whom:			Geoffrey C. Speicher <geoff@sea-incorporated.com>
+# New ports collection makefile for:	firebird2-server
+# Date created:		15 August 2006
+# Whom:			Sergey Skvortsov <skv@protey.ru>
 #
 # $FreeBSD$
 #
 
 PORTNAME?=	firebird
-PORTVERSION=	1.5.3
+PORTVERSION=	2.0.0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
 MASTER_SITE_SUBDIR=firebird
 PKGNAMESUFFIX?=	-server
-DISTNAME=	firebird-1.5.3.4870
+DISTNAME=	Firebird-2.0.0.12724-ReleaseCandidate4
 
 MAINTAINER=	skv@FreeBSD.org
-COMMENT?=	The open-source InterBase(tm) 6.0 spin-off (Classic version)
+COMMENT?=	Firebird-2 relational database (server)
+
+UNIQUENAME?=	${PORTNAME}2
 
 USE_BISON=	yes
 USE_BZIP2=	yes
 USE_GMAKE=	yes
 GNU_CONFIGURE=	yes
 USE_AUTOTOOLS=	autoconf:259 aclocal:19 libtool:15
-ACLOCAL_ARGS=	--acdir=${ACLOCAL_DIR} -I ${LOCALBASE}/share/aclocal
+ACLOCAL_ARGS=	--acdir=${ACLOCAL_DIR} -I ${LOCALBASE}/share/aclocal \
+		-I ${WRKSRC}/m4
 USE_GCC=	3.4+
 
 LOCALSTATEDIR=	/var/db/firebird
@@ -37,14 +40,15 @@ LD=	${CC}
 STRIP=
 
 ONLY_FOR_ARCHS=	i386 amd64
+CONFLICTS=	firebird-client-1* firebird-server-1*
 
-WRKSRC=		${WRKDIR}/${DISTNAME}
+WRKSRC=		${WRKDIR}/${DISTNAME:C/^F/f/}
 
 INSTALL_FB=	${INSTALL} ${COPY} -g firebird
 
 .if !defined(CLIENT_ONLY)
 # Server part stuff
-LIB_DEPENDS+=	fbembed.1:${PORTSDIR}/databases/firebird-client
+LIB_DEPENDS+=	fbembed.2:${PORTSDIR}/databases/firebird2-client
 
 AUTOGENARGS=	--with-lock-manager
 
@@ -55,13 +59,13 @@ SUB_FILES=	pkg-install pkg-message aliases.conf
 SUB_LIST+=	LOCALSTATEDIR=${LOCALSTATEDIR}
 
 SUID_BIN=	fb_inet_server fb_lock_mgr gds_drop
-UTIL_BIN=	fb_lock_print gbak gdef gfix gsec gstat
-UDF_SO=		ib_udf.so fbudf.so
-UDF_SQL=	src/extlib/ib_udf.sql src/extlib/fbudf/fbudf.sql
-
-CONFLICTS=	firebird-devel-[0-9]*
+UTIL_BIN=	fb_lock_print gbak gdef gfix gsec gstat nbackup
+UDF_SO=		ib_udf.so
+UDF_SQL=	src/extlib/ib_udf2.sql
 .else
 # Client part stuff
+LIB_DEPENDS=	icuuc.34:${PORTSDIR}/devel/icu
+
 AUTOGENARGS=	--with-editline
 
 ALL_TARGET=	firebird_basic libfbembed embed_isql embed_gpre \
@@ -69,10 +73,15 @@ ALL_TARGET=	firebird_basic libfbembed embed_isql embed_gpre \
 #ALL_TARGET=	firebird_basic libfbembed libfbclient \
 #		client_gpre client_gdef client_isql client_qli extlib
 
-INSTALLS_SHLIB=	yes
+USE_LDCONFIG=	yes
 CLIENT_BIN=	gpre isql qli
 
-CONFIGURE_ENV+=	PTHREAD_CFLAGS="${PTHREAD_CFLAGS}" PTHREAD_LIBS="${PTHREAD_LIBS}"
+CFLAGS+=	-I${LOCALBASE}/include
+LDFLAGS+=	-L${LOCALBASE}/lib
+
+CONFIGURE_ENV+=	CFLAGS="${CFLAGS}" LDFLAGS="${LDFLAGS}" \
+		PTHREAD_CFLAGS="${PTHREAD_CFLAGS}" \
+		PTHREAD_LIBS="${PTHREAD_LIBS}"
 
 .if !defined(NOPORTDOCS)
 PORTDOCS=	*
@@ -81,17 +90,19 @@ PORTDOCS=	*
 
 MAKE_ENV+=	CC=${CC} CXX=${CXX} FIREBIRD_TMP="${WRKDIR}" FIREBIRD_LOCK="${WRKDIR}"
 
+post-extract:
+	@${RM} -rf ${WRKSRC}/extern/icu
+
+post-patch:
+	@${MKDIR} ${WRKSRC}/m4
+	${CP} ${FILESDIR}/*.m4 ${WRKSRC}/m4
+
 .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} "changed since version 1.x."
 	@${ECHO_MSG} "Cancel this installation now and backup your databases"
 	@${ECHO_MSG} "if you have not already done so."
 .if !defined(BATCH)
@@ -100,16 +111,18 @@ pre-everything::
 .endif
 
 .if !defined(CLIENT_ONLY)
-pre-install:
+pre-su-install:
 	@${SETENV} PKG_PREFIX="${PREFIX}" ${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 
-post-install:
+post-su-install:
 	@${SETENV} PKG_PREFIX="${PREFIX}" ${SH} ${PKGINSTALL} ${PORTNAME} POST-INSTALL
 	@${CAT} ${PKGMESSAGE}
 .endif
 
 .ifndef WITHOUT_IPC_CLEANUP
 pre-build:
+	@if [ `${ID} -u` -eq 0 ]; then \
+	${ECHO_MSG} "==> Please do not build ${PORTNAME} as 'root' because this may cause conflicts with SysV semaphores of running services."; exit 1; fi
 	[ -f ${WRKDIR}/ipcs.pre.build ] || /usr/bin/ipcs -s | ${TAIL} -n +3 | \
 		${GREP} -F `${ID} -un` | ${CAT} > ${WRKDIR}/ipcs.pre.build
 
@@ -125,7 +138,9 @@ do-configure:
 	${AUTOTOOLS_VARS} ./autogen.sh --localstatedir=${LOCALSTATEDIR} \
 		--prefix=${LOCALSTATEDIR} --exec-prefix=${PREFIX} \
 		--libexecdir=${LIBEXECDIR} \
-		--sysconfdir=${CONFDIR} --datadir=${DATADIR} ${AUTOGENARGS})
+		--sysconfdir=${CONFDIR} --datadir=${DATADIR} \
+		--with-icu-config=${LOCALBASE}/bin/icu-config \
+		${AUTOGENARGS})
 
 post-configure:
 	@${REINPLACE_CMD} -e 's|__attribute__ ((__unused__));||' \
@@ -137,10 +152,13 @@ do-install:
 	${INSTALL_PROGRAM} ${UTIL_BIN:S!^!${WRKSRC}/gen/firebird/bin/!} ${PREFIX}/bin
 
 	${INSTALL_PROGRAM} -o firebird -g firebird -m 6550 \
-		${SUID_BIN:S!^!${WRKSRC}/gen/firebird/bin/!} ${PREFIX}/sbin
+		${SUID_BIN:S!^!${WRKSRC}/gen/firebird/bin/!} ${PREFIX}/bin
 
 	@${MKDIR} ${CONFDIR}
 	${INSTALL_DATA} ${WRKDIR}/aliases.conf ${CONFDIR}/aliases.conf.sample
+.if !exists(${CONFDIR}/aliases.conf)
+	${INSTALL_DATA} ${WRKDIR}/aliases.conf ${CONFDIR}/aliases.conf
+.endif
 
 	${MKDIR} ${LIBEXECDIR}/udf ${LOCALSTATEDIR}/help ${LIBEXECDIR}/intl
 
@@ -149,19 +167,17 @@ do-install:
 	${INSTALL_FB} -m 0555 ${UDF_SO:S!^!${WRKSRC}/gen/firebird/UDF/!} ${LIBEXECDIR}/udf
 	${INSTALL_FB} -m 0444 ${UDF_SQL:S!^!${WRKSRC}/!} ${LIBEXECDIR}/udf
 
-.if !exists(${LOCALSTATEDIR}/security.fdb)
-	${INSTALL_FB} -m 0660 -o firebird ${WRKSRC}/gen/firebird/security.fdb \
-		${LOCALSTATEDIR}/security.fdb
+.if !exists(${LOCALSTATEDIR}/security2.fdb)
+	${INSTALL_FB} -m 0660 -o firebird ${WRKSRC}/gen/firebird/security2.fdb \
+		${LOCALSTATEDIR}/security2.fdb
 .endif
-	${INSTALL_FB} -m 0660 -o firebird ${WRKSRC}/gen/firebird/security.fdb \
-		${LOCALSTATEDIR}/security.fdb.sample
+	${INSTALL_FB} -m 0660 -o firebird ${WRKSRC}/gen/firebird/security2.fdb \
+		${LOCALSTATEDIR}/security2.fdb.sample
 
 	${INSTALL_FB} -m 0440 ${WRKSRC}/gen/firebird/help/help.fdb \
 		${LOCALSTATEDIR}/help
 
 	${INSTALL_FB} -m 0555 ${WRKSRC}/gen/firebird/intl/libfbintl.so ${LIBEXECDIR}/intl/fbintl
-
-	${INSTALL_DATA} ${FILESDIR}/RELNOTES ${LOCALSTATEDIR}
 .else
 # defined CLIENT_ONLY
 	${INSTALL_PROGRAM} ${CLIENT_BIN:S!^!${WRKSRC}/gen/firebird/bin/!} \
@@ -180,13 +196,14 @@ do-install:
 		${WRKSRC}/gen/firebird/lib/libfbembed.so.${PORTVERSION} \
 		${PREFIX}/lib
 
-	${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libfbclient.so.1
-	${LN} -fs libfbclient.so.1 ${PREFIX}/lib/libfbclient.so
+	${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libfbclient.so.2
+	${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libfbclient.so
 
-	${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
+	${LN} -fs libfbembed.so.${PORTVERSION} ${PREFIX}/lib/libfbembed.so.2
+	${LN} -fs libfbembed.so.${PORTVERSION} ${PREFIX}/lib/libfbembed.so
+
+	${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libgds.so.2
+	${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libgds.so
 
 	@${MKDIR} ${PREFIX}/include
 	${INSTALL_DATA} ${WRKSRC}/gen/firebird/include/*.h ${PREFIX}/include
@@ -200,10 +217,6 @@ do-install:
 	${INSTALL_DATA} ${WRKSRC}/doc/README.user ${DOCSDIR}/README
 	${INSTALL_DATA} ${WRKSRC}/doc/sql.extensions/README.* ${DOCSDIR}/sql.extensions
 .endif
-
-	@${ECHO_MSG} "===>   Installing examples for ${PKGNAME}"
-	@${MKDIR} ${EXAMPLESDIR}
-	${INSTALL_DATA} ${WRKSRC}/gen/firebird/examples/v5/* ${EXAMPLESDIR}
 .endif
 
 .include <bsd.port.post.mk>
diff --git a/databases/firebird2-server/distinfo b/databases/firebird2-server/distinfo
index ca162a069ca5..e23ebea85b9a 100644
--- a/databases/firebird2-server/distinfo
+++ b/databases/firebird2-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (firebird-1.5.3.4870.tar.bz2) = 559d005ab6622274f9448687f930393c
-SHA256 (firebird-1.5.3.4870.tar.bz2) = 16880405d6e321a70e80c6e6fb4ed8429a692c43b8a7b59a676cf7d2162d2023
-SIZE (firebird-1.5.3.4870.tar.bz2) = 5055973
+MD5 (Firebird-2.0.0.12724-ReleaseCandidate4.tar.bz2) = c955612c692484b3da84e8c3e518afe6
+SHA256 (Firebird-2.0.0.12724-ReleaseCandidate4.tar.bz2) = 16c88b35de8c85ea39e2289876dab9e15e6a7a8be3ce14ca492ca63873221da1
+SIZE (Firebird-2.0.0.12724-ReleaseCandidate4.tar.bz2) = 12471842
diff --git a/databases/firebird2-server/files/RELNOTES b/databases/firebird2-server/files/RELNOTES
deleted file mode 100644
index 87a8c5de91bf..000000000000
--- a/databases/firebird2-server/files/RELNOTES
+++ /dev/null
@@ -1,108 +0,0 @@
-Firebird 1.5.3 FreeBSD Release Notes
---------------------------------------
-FB-V1.5.3.4870 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 /var/db/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/share/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>
diff --git a/databases/firebird2-server/files/aliases.conf.in b/databases/firebird2-server/files/aliases.conf.in
index 92b5b620c07a..ded23bfd70cb 100644
--- a/databases/firebird2-server/files/aliases.conf.in
+++ b/databases/firebird2-server/files/aliases.conf.in
@@ -5,5 +5,5 @@
 # Examples:
 #
 # employee = %%EXAMPLESDIR%%/employee.fdb
-# security = /var/db/firebird/security.fdb
+# security = /var/db/firebird/security2.fdb
 #
diff --git a/databases/firebird2-server/files/icu.m4 b/databases/firebird2-server/files/icu.m4
new file mode 100644
index 000000000000..37d0f8a08c40
--- /dev/null
+++ b/databases/firebird2-server/files/icu.m4
@@ -0,0 +1,46 @@
+dnl AM_PATH_ICU([MINIMUM-VERSION])
+dnl Adds support for ICU
+AC_DEFUN([AM_PATH_ICU],
+[
+  rast_lib_icu_major="$1"
+  rast_lib_icu_minor="$2"
+  rast_lib_icu_version="$1.$2"
+
+  AC_ARG_WITH(icu-config,
+  AC_HELP_STRING([--with-icu-config=PATH],[path to icu-config]),
+  [
+      AC_MSG_RESULT(using $withval for icu-config)
+      ICU_CONFIG="$withval"
+  ], [
+      AC_PATH_PROG(ICU_CONFIG, icu-config, no)
+  ])
+  HAVE_ICU="no"
+  if test "$ICU_CONFIG" != "no"; then
+    AC_MSG_CHECKING([ICU version])    
+    ICU_VERSION="`$ICU_CONFIG --version`"
+    if test $? -eq 0; then
+      changequote(<<, >>)
+      ICU_MAJOR=`expr "$ICU_VERSION" : '\(.*\)\..*'`
+      ICU_MINOR=`expr "$ICU_VERSION" : '.*\.\(.*\)'`
+      changequote([, ])
+      if expr "$ICU_MAJOR" '>' "$rast_lib_icu_major" > /dev/null ||
+         ( expr "$ICU_MAJOR" '=' "$rast_lib_icu_major" > /dev/null &&
+           expr "$ICU_MINOR" '>=' "$rast_lib_icu_minor" > /dev/null ); then
+        AC_MSG_RESULT([$ICU_VERSION])
+
+        ICU_CPPFLAGS=`$ICU_CONFIG --cppflags`
+        ICU_LIBS=`$ICU_CONFIG --ldflags-libsonly`
+        ICU_LDFLAGS=`$ICU_CONFIG --ldflags-searchpath`
+        AC_SUBST(ICU_CPPFLAGS)
+        AC_SUBST(ICU_LIBS)
+        AC_SUBST(ICU_LDFLAGS)
+        HAVE_ICU="yes"
+      else
+        AC_MSG_WARN([$ICU_VERSION is too old; $rast_lib_icu_version is required])
+      fi
+    else
+      AC_MSG_WARN([icu-config --version failed])
+    fi
+  fi
+  AC_SUBST(HAVE_ICU)
+])
diff --git a/databases/firebird2-server/files/patch-amd64 b/databases/firebird2-server/files/patch-amd64
deleted file mode 100644
index 1f4d465389b3..000000000000
--- a/databases/firebird2-server/files/patch-amd64
+++ /dev/null
@@ -1,76 +0,0 @@
---- src/jrd/common.h.orig	Mon Jan 23 20:52:45 2006
-+++ src/jrd/common.h	Mon Jan 23 20:54:36 2006
-@@ -273,8 +273,14 @@
- 
- #define UNIX  1
- #define IEEE  1
-+
-+#ifdef AMD64
-+#define IMPLEMENTATION  isc_info_db_impl_freebsd_amd64 /* 67  next higher unique n
-+umber, See you later  */
-+#else
- #define I386  1
- #define IMPLEMENTATION    isc_info_db_impl_freebsd   /* 61 */
-+#endif
- 
- #define QUADFORMAT "ll"
- #define QUADCONST(n) (n##LL)
---- src/jrd/ibase.h.orig	Mon Jan 23 20:51:38 2006
-+++ src/jrd/ibase.h	Mon Jan 23 20:52:08 2006
-@@ -1577,6 +1577,8 @@
- 	isc_info_db_impl_linux_sparc = 65,
- 	isc_info_db_impl_linux_amd64 = 66,
- 
-+	isc_info_db_impl_freebsd_amd64 = 67,
-+
- 	isc_info_db_impl_last_value   /* Leave this LAST! */
-     };
- 
---- src/jrd/pag.cpp.orig	Sat Mar 26 07:07:11 2005
-+++ src/jrd/pag.cpp	Mon Jan 23 21:27:49 2006
-@@ -143,8 +143,9 @@
- static const int CLASS_NETBSD_I386 = 22;  // NetBSD/i386
- static const int CLASS_DARWIN_PPC = 23;   // Darwin/PowerPC
- static const int CLASS_LINUX_AMD64 = 24;  // LINUX on AMD64 systems
-+static const int CLASS_FREEBSD_AMD64 = 25;// FreeBSD/amd64
- 
--static const int CLASS_MAX10 = CLASS_LINUX_AMD64;
-+static const int CLASS_MAX10 = CLASS_FREEBSD_AMD64;
- 
- // ARCHITECTURE COMPATIBILITY CLASSES
- 
-@@ -188,7 +189,8 @@
- 	archIntel86, // CLASS_FREEBSD_I386
-     archIntel86, // CLASS_NETBSD_I386
- 	archUnknown, // CLASS_DARWIN_PPC
--	archUnknown  // CLASS_LINUX_AMD64
-+	archUnknown, // CLASS_LINUX_AMD64
-+	archUnknown  // CLASS_FREEBSD_AMD64
- };
- 
- #ifdef sun
-@@ -239,7 +241,12 @@
- #endif
- 
- #ifdef FREEBSD
-+#ifdef i386
- #define CLASS           CLASS_FREEBSD_I386
-+#endif
-+#ifdef AMD64
-+#define CLASS           CLASS_FREEBSD_AMD64
-+#endif
- #endif
- 
- #ifdef NETBSD
---- src/jrd/utl.cpp.orig	Mon Jan 23 20:56:00 2006
-+++ src/jrd/utl.cpp	Mon Jan 23 20:56:37 2006
-@@ -255,7 +255,8 @@
-     "Firebird/Darwin/PowerPC",	/* 63 */
-     "Firebird/SINIX-Z",	/* 64 */
-     "Firebird/linux Sparc",	/* 65 */
--    "Firebird/linux AMD64"	/* 66 */
-+    "Firebird/linux AMD64",	/* 66 */
-+    "Firebird/FreeBSD/amd64"	/* 67 */
- };
- 
- 
diff --git a/databases/firebird20-server/files/patch-src%install%misc%firebird.conf b/databases/firebird2-server/files/patch-builds%install%misc%firebird.conf
index 4f8f1b416285..d0105af83cf6 100644
--- a/databases/firebird20-server/files/patch-src%install%misc%firebird.conf
+++ b/databases/firebird2-server/files/patch-builds%install%misc%firebird.conf
@@ -1,5 +1,5 @@
---- src/install/misc/firebird.conf.orig	Fri Sep 30 17:13:47 2005
-+++ src/install/misc/firebird.conf	Wed Mar 15 17:03:43 2006
+--- builds/install/misc/firebird.conf.orig	Tue Aug 15 22:38:52 2006
++++ builds/install/misc/firebird.conf	Tue Aug 15 22:39:24 2006
 @@ -60,7 +60,7 @@
  #
  # Type: string
@@ -9,7 +9,7 @@
  
  
  # ----------------------------
-@@ -126,7 +126,7 @@
+@@ -125,7 +125,7 @@
  #
  # Type: string (special format)
  #
diff --git a/databases/firebird2-server/files/patch-builds%make.new%config%config.h.in b/databases/firebird2-server/files/patch-builds%make.new%config%config.h.in
deleted file mode 100644
index 1ad510c8f674..000000000000
--- a/databases/firebird2-server/files/patch-builds%make.new%config%config.h.in
+++ /dev/null
@@ -1,20 +0,0 @@
---- builds/make.new/config/config.h.in.orig	Sun Jul  6 05:07:48 2003
-+++ builds/make.new/config/config.h.in	Thu Mar 16 19:15:02 2006
-@@ -172,6 +172,7 @@
- #undef PowerPC
- #undef sparc
- #undef i386
-+#undef AMD64
- #undef mips
- #undef alpha
- 
-@@ -190,5 +191,9 @@
- #undef SINIXZ
- 
- #define FB_PREFIX "/usr/local/firebird"
-+#define FB_EXEC_PREFIX	"/usr/local"
-+#define FB_CONF_PREFIX	"/usr/local/etc/firebird"
-+#define FB_MSG_PREFIX	"/usr/local/libdata/firebird"
-+#define FB_LIBEXEC_PREFIX	"/usr/local/libexec/firebird"
- 
- #endif
diff --git a/databases/firebird2-server/files/patch-builds%posix%Makefile.in.firebird b/databases/firebird2-server/files/patch-builds%posix%Makefile.in.firebird
new file mode 100644
index 000000000000..31a0b95ec4f7
--- /dev/null
+++ b/databases/firebird2-server/files/patch-builds%posix%Makefile.in.firebird
@@ -0,0 +1,35 @@
+--- builds/posix/Makefile.in.firebird.orig	Sun Dec 18 20:56:17 2005
++++ builds/posix/Makefile.in.firebird	Wed Sep 13 20:31:13 2006
+@@ -186,7 +186,6 @@
+ # 
+ 
+ external_libraries:
+-	$(MAKE) -f $(GEN_ROOT)/Makefile.extern.icu
+ ifeq ($(EDITLINE_FLG),Y)
+ 	$(MAKE) -f $(GEN_ROOT)/Makefile.extern.editline
+ endif
+@@ -515,12 +514,12 @@
+ #___________________________________________________________________________
+ # 
+ .PHONY: clean clean_objects clean_dependancies clean_extern_objects clean_build \
+-		clean_gpre_gen clean_icu clean_dbs clean_examples clean_makefiles \
++		clean_gpre_gen clean_dbs clean_examples clean_makefiles \
+ 		clean_editline clean_all
+ 
+ 
+ clean: clean_objects clean_dependancies clean_extern_objects clean_build \
+-		clean_gpre_gen clean_icu clean_dbs clean_examples
++		clean_gpre_gen clean_dbs clean_examples
+ 
+ ifeq ($(EDITLINE_FLG),Y)
+ clean: clean_editline
+@@ -542,9 +541,6 @@
+ 
+ clean_editline:
+ 	-make -C $(ROOT)/extern/editline clean
+-
+-clean_icu:
+-	-make -C $(ROOT)/extern/icu/source clean
+ 
+ clean_objects:
+ 	$(RM) `find $(TMP_ROOT)/ -type f -name '*.o' -print`
diff --git a/databases/firebird2-server/files/patch-builds%posix%make.defaults b/databases/firebird2-server/files/patch-builds%posix%make.defaults
index f7d4bc6362f3..bef124859a91 100644
--- a/databases/firebird2-server/files/patch-builds%posix%make.defaults
+++ b/databases/firebird2-server/files/patch-builds%posix%make.defaults
@@ -1,6 +1,6 @@
---- builds/posix/make.defaults.orig	Thu Mar 16 19:49:57 2006
-+++ builds/posix/make.defaults	Thu Mar 16 19:51:18 2006
-@@ -94,7 +94,7 @@
+--- builds/posix/make.defaults.orig	Wed Dec 28 09:58:28 2005
++++ builds/posix/make.defaults	Wed Aug 16 16:26:16 2006
+@@ -102,7 +102,7 @@
  CHMOD=			chmod
  CHMOD_6=		chmod 666
  CHMOD_7=		chmod 777
@@ -9,3 +9,13 @@
  MV=			mv -f
  TOUCH=			touch
  CP=			cp
+@@ -180,9 +180,6 @@
+ 
+ LIBFBSTATIC_A = $(LIB)/libfbstatic.a
+ LIBEDITLINE_A = $(LIB)/libeditline.a
+-LIBICU_SO = $(LIB)/$(LIB_PREFIX)icuuc.$(SHRLIB_EXT) \
+-			$(LIB)/$(LIB_PREFIX)icudata.$(SHRLIB_EXT) \
+-			$(LIB)/$(LIB_PREFIX)icui18n.$(SHRLIB_EXT)
+ 
+ # Shared library name for usage inside of the UDF
+ IbUtilLibraryName = $(LIB_PREFIX)ib_util.$(SHRLIB_EXT)
diff --git a/databases/firebird2-server/files/patch-builds%posix%make.rules b/databases/firebird2-server/files/patch-builds%posix%make.rules
new file mode 100644
index 000000000000..4131aff1f052
--- /dev/null
+++ b/databases/firebird2-server/files/patch-builds%posix%make.rules
@@ -0,0 +1,20 @@
+--- builds/posix/make.rules.orig	Wed Dec 28 09:58:28 2005
++++ builds/posix/make.rules	Thu Sep 14 17:29:08 2006
+@@ -33,7 +33,7 @@
+ 
+ 
+ # Please don't use compiler/platform specific flags here - nmcc 02-Nov-2002
+-CFLAGS:= $(CFLAGS) -I$(SRC_ROOT)/include/gen -I$(SRC_ROOT)/include -I$(SRC_ROOT)/vulcan -I$(ROOT)/extern/icu/source/common -I$(ROOT)/extern/icu/source/i18n -DNAMESPACE=Vulcan
++CFLAGS:= $(CFLAGS) -I$(SRC_ROOT)/include/gen -I$(SRC_ROOT)/include -I$(SRC_ROOT)/vulcan @ICU_CPPFLAGS@ -DNAMESPACE=Vulcan
+ 
+ ifeq ($(IsProdTypeBuild),Y)
+   CFLAGS:= $(CFLAGS) $(PROD_FLAGS) -DPROD_BUILD
+@@ -75,7 +75,7 @@
+ STATICEXE_LINK = @CXX@
+ 
+ LINK_LIBS = @LIBS@ @EDITLINE_A@
+-ICU_LIBS = -licuuc -licudata -licui18n
++ICU_LIBS = @ICU_LIBS@ @ICU_LDFLAGS@
+ STATICLINK_LIBS = @LIBS@ @EDITLINE_A@
+ SO_LINK_LIBS = @LIBS@
+ 
diff --git a/databases/firebird2-server/files/patch-configure.in b/databases/firebird2-server/files/patch-configure.in
index ce1a65467bb9..4e09407641e4 100644
--- a/databases/firebird2-server/files/patch-configure.in
+++ b/databases/firebird2-server/files/patch-configure.in
@@ -1,30 +1,45 @@
---- configure.in.orig	Wed Dec 14 10:29:08 2005
-+++ configure.in	Thu Mar 16 18:38:55 2006
-@@ -49,6 +49,16 @@
-     SHRLIB_EXT=dylib
-     ;;
- 
-+  amd64-*-freebsd*)
-+    MAKEFILE_PREFIX=freebsd 
-+    PLATFORM=FREEBSD
-+    AC_DEFINE(FREEBSD)
-+    AC_DEFINE(AMD64)
-+    LOCK_MANAGER_FLG=Y
-+    EDITLINE_FLG=N
-+    SHRLIB_EXT=so
-+    ;;
-+
-   *-*-freebsd*)
-     MAKEFILE_PREFIX=freebsd 
-     PLATFORM=FREEBSD
-@@ -612,6 +622,10 @@
+--- configure.in.orig	Tue Apr 25 21:07:23 2006
++++ configure.in	Thu Sep 14 19:30:42 2006
+@@ -423,9 +423,10 @@
+ AC_CHECK_LIB(curses, main)
+ dnl AC_CHECK_LIB(termcap, main)
+ if test "$EDITLINE_FLG" = "Y"; then
+-  AC_SUBST(EDITLINE_A, -leditline)
++  AC_SUBST(EDITLINE_A, "-ledit -lreadline")
+ fi
+ AC_CHECK_LIB(stdc++, main,,, $LIBS)
++AM_PATH_ICU(3, 4)
+ 
+ 
+ dnl Check for functions
+@@ -696,6 +697,10 @@
  AC_SUBST(NEW_FIREBIRD_DIR)
  
- AC_DEFINE_UNQUOTED(FB_PREFIX, $(if test "x$prefix" = "xNONE" ; then echo \"$ac_default_prefix\"; else echo \"$prefix\"; fi))
-+AC_DEFINE_UNQUOTED(FB_EXEC_PREFIX, "$exec_prefix")
-+AC_DEFINE_UNQUOTED(FB_CONF_PREFIX, "$sysconfdir")
-+AC_DEFINE_UNQUOTED(FB_MSG_PREFIX, "$datadir")
-+AC_DEFINE_UNQUOTED(FB_LIBEXEC_PREFIX, "$libexecdir")
+ AC_DEFINE_UNQUOTED(FB_PREFIX, $(if test "x$prefix" = "xNONE" ; then echo \"$ac_default_prefix\"; else echo \"$prefix\"; fi), [Installation path prefix])
++AC_DEFINE_UNQUOTED(FB_EXEC_PREFIX, "$exec_prefix", [Executables path prefix])
++AC_DEFINE_UNQUOTED(FB_CONF_PREFIX, "$sysconfdir", [Single-machine data path prefix])
++AC_DEFINE_UNQUOTED(FB_MSG_PREFIX, "$datadir", [Architecture-independent data path prefix])
++AC_DEFINE_UNQUOTED(FB_LIBEXEC_PREFIX, "$libexecdir", [Program executables path prefix])
  
  AC_CONFIG_COMMANDS(,,[
- dnl ### GEN ### directories for preprocessed cpp, databases and output
+ dnl # rebuild version header if needed
+@@ -1004,19 +1009,11 @@
+ gen/Makefile.install:builds/install/arch-specific/${INSTALL_PREFIX}/Makefile.in
+ Makefile:Makefile.in
+ gen/Makefile.extern.editline:${MAKE_SRC_DIR}/Makefile.in.extern.editline
+-gen/Makefile.extern.icu:${MAKE_SRC_DIR}/Makefile.in.extern.icu
+ )
+ 
+ 
+ 
+-if test "$PROD_BUILD_FLG" = N; then
+-  DEBUG_ICU=--enable-debug
+-fi
+-
+ AC_OUTPUT
+-(cd extern/icu/source
+-chmod +x runConfigureICU configure install-sh
+-./runConfigureICU "$ICU_PLATFORM" "$DEBUG_ICU" --prefix=`pwd`/..)
+ 
+ 
+ dnl Print out the build configuration (the most interesting thing)
diff --git a/databases/firebird2-server/files/patch-src%common%config%config.cpp b/databases/firebird2-server/files/patch-src%common%config%config.cpp
index 34645c66ca09..b05adf508983 100644
--- a/databases/firebird2-server/files/patch-src%common%config%config.cpp
+++ b/databases/firebird2-server/files/patch-src%common%config%config.cpp
@@ -1,11 +1,11 @@
---- src/common/config/config.cpp.orig	Wed Mar 15 14:17:53 2006
-+++ src/common/config/config.cpp	Wed Mar 15 14:18:30 2006
-@@ -106,7 +106,7 @@
+--- src/common/config/config.cpp.orig	Tue Aug 15 22:53:43 2006
++++ src/common/config/config.cpp	Tue Aug 15 22:54:38 2006
+@@ -111,7 +111,7 @@
  	{TYPE_STRING,		"RemoteBindAddress",		(ConfigValue) 0},
  	{TYPE_STRING,		"ExternalFileAccess",		(ConfigValue) "None"},	// location(s) of external files for tables
  	{TYPE_STRING,		"DatabaseAccess",			(ConfigValue) "Full"},	// location(s) of databases
 -	{TYPE_STRING,		"UdfAccess",				(ConfigValue) "Restrict UDF"},	// location(s) of UDFs
-+	{TYPE_STRING,		"UdfAccess",				(ConfigValue) "Restrict " FB_LIBEXEC_PREFIX "/udf"},	// location(s) of UDFs
++	{TYPE_STRING,		"UdfAccess",				(ConfigValue) "Restrict " FB_LIBEXEC_PREFIX "/UDF"},	// location(s) of UDFs
  	{TYPE_STRING,		"TempDirectories",			(ConfigValue) 0},
- 	{TYPE_BOOLEAN,		"BugcheckAbort",			(ConfigValue) false},	// whether to abort() engine when internal error is found
- 	{TYPE_BOOLEAN,		"OldColumnNaming",			(ConfigValue) false}	// if true use old column naming rules
+ #ifdef DEV_BUILD
+  	{TYPE_BOOLEAN,		"BugcheckAbort",			(ConfigValue) true},	// whether to abort() engine when internal error is found
diff --git a/databases/firebird2-server/files/patch-src%jrd%db_alias.cpp b/databases/firebird2-server/files/patch-src%jrd%db_alias.cpp
index 8c0e56b144da..27f7d6dc114d 100644
--- a/databases/firebird2-server/files/patch-src%jrd%db_alias.cpp
+++ b/databases/firebird2-server/files/patch-src%jrd%db_alias.cpp
@@ -1,13 +1,13 @@
---- src/jrd/db_alias.cpp.orig	Mon Aug 18 01:16:41 2003
-+++ src/jrd/db_alias.cpp	Mon Jul 25 15:07:45 2005
-@@ -37,8 +37,8 @@
+--- src/jrd/db_alias.cpp.orig	Tue Aug 15 23:07:31 2006
++++ src/jrd/db_alias.cpp	Tue Aug 15 23:10:08 2006
+@@ -33,8 +33,8 @@
  
- bool ResolveDatabaseAlias(const char* alias, char* database)
+ bool ResolveDatabaseAlias(const string& alias, string& database)
  {
--	TEXT alias_filename[MAXPATHLEN];
--	gds__prefix(alias_filename, const_cast<char*>(ALIAS_FILE));
-+	TEXT alias_filename[MAXPATHLEN] = FB_CONF_PREFIX "/";
-+	strlcat(alias_filename, ALIAS_FILE, MAXPATHLEN);
+-	string alias_filename;
+-	Firebird::Prefix(alias_filename, ALIAS_FILE);
++	string alias_filename = string(FB_CONF_PREFIX)
++		+ PathUtils::dir_sep + ALIAS_FILE;
  	ConfigFile aliasConfig(false);
- 	aliasConfig.setConfigFile(alias_filename);
+ 	aliasConfig.setConfigFilePath(alias_filename);
  
diff --git a/databases/firebird2-server/files/patch-src%jrd%gds.cpp b/databases/firebird2-server/files/patch-src%jrd%gds.cpp
index b1c47c40439a..f22bc183629e 100644
--- a/databases/firebird2-server/files/patch-src%jrd%gds.cpp
+++ b/databases/firebird2-server/files/patch-src%jrd%gds.cpp
@@ -1,11 +1,11 @@
---- src/jrd/gds.cpp.orig	Mon Jan 23 15:04:44 2006
-+++ src/jrd/gds.cpp	Mon Jan 23 15:07:20 2006
-@@ -3697,7 +3697,7 @@
- 		Firebird::string msgPrefix(getenv(FB_MSG_ENV) ? getenv(FB_MSG_ENV) : "");
- 		if (msgPrefix.length() == 0) 
+--- src/jrd/gds.cpp.orig	Tue Aug 15 22:49:37 2006
++++ src/jrd/gds.cpp	Tue Aug 15 22:50:14 2006
+@@ -3734,7 +3734,7 @@
+ 		Firebird::PathName msgPrefix;
+ 		if (!fb_utils::readenv(FB_MSG_ENV, msgPrefix))
  		{
 -			msgPrefix = prefix;
 +			msgPrefix = FB_MSG_PREFIX;
  		}
- 		copyTo(msgPrefix, ib_prefix_msg_val, sizeof(ib_prefix_msg_val));
+ 		msgPrefix.copyTo(ib_prefix_msg_val, sizeof(ib_prefix_msg_val));
  		ib_prefix_msg = ib_prefix_msg_val;
diff --git a/databases/firebird2-server/files/patch-src%jrd%os%config_root.h b/databases/firebird2-server/files/patch-src%jrd%os%config_root.h
new file mode 100644
index 000000000000..976da187b36a
--- /dev/null
+++ b/databases/firebird2-server/files/patch-src%jrd%os%config_root.h
@@ -0,0 +1,11 @@
+--- src/jrd/os/config_root.h.orig	Tue Aug 15 22:57:33 2006
++++ src/jrd/os/config_root.h	Tue Aug 15 22:57:53 2006
+@@ -76,7 +76,7 @@
+ 	{
+ 		GetRoot();
+ 		install_dir = root_dir;
+-		config_file = root_dir + string(CONFIG_FILE);
++		config_file = string(FB_CONF_PREFIX) + PathUtils::dir_sep + string(CONFIG_FILE);
+ 	}
+ 
+ 
diff --git a/databases/firebird2-server/files/patch-src%jrd%os%posix%config_root.cpp b/databases/firebird2-server/files/patch-src%jrd%os%posix%config_root.cpp
deleted file mode 100644
index 3af960c1599e..000000000000
--- a/databases/firebird2-server/files/patch-src%jrd%os%posix%config_root.cpp
+++ /dev/null
@@ -1,10 +0,0 @@
---- src/jrd/os/posix/config_root.cpp.orig	Mon Jul 25 15:19:18 2005
-+++ src/jrd/os/posix/config_root.cpp	Mon Jul 25 15:19:49 2005
-@@ -152,6 +152,6 @@
- 
- const char *ConfigRoot::getConfigFile() const
- {
--	static string file = root_dir + string(CONFIG_FILE);
-+	static string file = string(FB_CONF_PREFIX) + PathUtils::dir_sep + string(CONFIG_FILE);
- 	return file.c_str();
- }
diff --git a/databases/firebird2-server/files/patch-src%jrd%plugin_manager.cpp b/databases/firebird2-server/files/patch-src%jrd%plugin_manager.cpp
index 808568121478..7a2ffab72408 100644
--- a/databases/firebird2-server/files/patch-src%jrd%plugin_manager.cpp
+++ b/databases/firebird2-server/files/patch-src%jrd%plugin_manager.cpp
@@ -1,24 +1,20 @@
---- src/jrd/plugin_manager.cpp.orig	Wed Mar 15 14:25:42 2006
-+++ src/jrd/plugin_manager.cpp	Wed Mar 15 14:39:12 2006
-@@ -47,9 +47,7 @@
+--- src/jrd/plugin_manager.cpp.orig	Tue Aug 15 23:11:04 2006
++++ src/jrd/plugin_manager.cpp	Tue Aug 15 23:12:01 2006
+@@ -64,7 +64,7 @@
  void PluginManager::loadAllPlugins()
  {
- 	Firebird::list<Path>::iterator pathItr;
--	char fb_lib_path[MAXPATHLEN];
--	gds__prefix(fb_lib_path, "");
--	Firebird::string fbLibPath(fb_lib_path);
-+	Firebird::string fbLibPath(FB_LIBEXEC_PREFIX);
- 	Firebird::string checkDir;
+ 	Firebird::PathName checkDir;
+-	const Firebird::PathName fbLibPath = Config::getRootDirectory();
++	const Firebird::PathName fbLibPath = FB_LIBEXEC_PREFIX;
  	
- 	for(pathItr = searchPaths.begin(); pathItr != searchPaths.end(); ++pathItr)
-@@ -114,9 +112,7 @@
- 
- PluginManager::Module *PluginManager::loadPluginModule(const Firebird::string& name)
+ 	for (spIterator pathItr = searchPaths.begin(); pathItr != searchPaths.end(); ++pathItr)
+ 	{
+@@ -131,7 +131,7 @@
+ PluginManager::Module *PluginManager::loadPluginModule(const Firebird::PathName& name)
  {
--	char fb_lib_path[MAXPATHLEN];
--	gds__prefix(fb_lib_path, "");
--	Firebird::string fbLibPath(fb_lib_path);
-+	Firebird::string fbLibPath(FB_LIBEXEC_PREFIX);
- 	Firebird::string checkPath;
- 	Firebird::list<Path>::iterator itr;
+ 	Firebird::PathName checkPath;
+-	const Firebird::PathName fbLibPath = Config::getRootDirectory();
++	const Firebird::PathName fbLibPath = FB_LIBEXEC_PREFIX;
  	
+ 	// Check to see if the module name was specified as a relative path
+ 	//	from one of our search paths.  This only makes sense if the name
diff --git a/databases/firebird2-server/files/patch-src%jrd%svc.cpp b/databases/firebird2-server/files/patch-src%jrd%svc.cpp
index 42b12339bc36..ed93b6d68d13 100644
--- a/databases/firebird2-server/files/patch-src%jrd%svc.cpp
+++ b/databases/firebird2-server/files/patch-src%jrd%svc.cpp
@@ -1,12 +1,13 @@
---- src/jrd/svc.cpp.orig	Tue Jan 24 17:11:48 2006
-+++ src/jrd/svc.cpp	Tue Jan 24 17:27:22 2006
-@@ -1902,7 +1902,8 @@
+--- src/jrd/svc.cpp.orig	Tue Aug 15 23:06:16 2006
++++ src/jrd/svc.cpp	Tue Aug 15 23:06:50 2006
+@@ -1742,8 +1742,8 @@
+ 	TEXT service_path[MAXPATHLEN];
  
- #ifndef SUPERSERVER
  	if (serv->serv_executable) {
 -		gds__prefix(service_path, serv->serv_executable);
+-		service->svc_flags = SVC_forked;
 +		strlcpy(service_path, FB_EXEC_PREFIX "/", MAXPATHLEN);
 +		strlcat(service_path, serv->serv_executable, MAXPATHLEN);
- 		service->svc_flags = SVC_forked;
  		service_fork(service_path, service);
  	}
+ 
diff --git a/databases/firebird2-server/files/patch-src%lock%lock.cpp b/databases/firebird2-server/files/patch-src%lock%lock.cpp
index 7f550183e379..279324733739 100644
--- a/databases/firebird2-server/files/patch-src%lock%lock.cpp
+++ b/databases/firebird2-server/files/patch-src%lock%lock.cpp
@@ -1,15 +1,16 @@
---- src/lock/lock.cpp.orig	Mon Mar 29 08:35:49 2004
-+++ src/lock/lock.cpp	Wed Jul 27 14:01:51 2005
-@@ -2800,7 +2800,11 @@
+--- src/lock/lock.cpp.orig	Fri Feb  3 16:13:23 2006
++++ src/lock/lock.cpp	Wed Aug 16 12:41:32 2006
+@@ -2708,7 +2708,12 @@
  #ifdef DEBUG_MANAGER
  	gds__prefix(string, DEBUG_MANAGER);
  #else
 -	gds__prefix(string, LOCK_MANAGER);
 +	if (! getenv("FIREBIRD")) {
-+		strlcpy(string, FB_EXEC_PREFIX "/s" LOCK_MANAGER, MAXPATHLEN);
-+	}else	{
++		strlcpy(string, FB_EXEC_PREFIX "/", MAXPATHLEN);
++		strlcat(string, LOCK_MANAGER, MAXPATHLEN);
++	} else	{
 +		gds__prefix(string, LOCK_MANAGER);
 +	}
  #endif
  	if (statistics(string, &stat_buf) == -1) {
- 		sprintf (errorstring, "can't start lock manager: %s", string);
+ 		// bug() fills the vector with this address, it must be static.
diff --git a/databases/firebird2-server/pkg-descr b/databases/firebird2-server/pkg-descr
index ba570031da86..ed76025f94b8 100644
--- a/databases/firebird2-server/pkg-descr
+++ b/databases/firebird2-server/pkg-descr
@@ -4,10 +4,9 @@ offers excellent concurrency, high performance, and powerful language
 support for stored procedures and triggers.  It has been used in
 production systems, under a variety of names since 1981.
 
-For more information on Firebird and InterBase, see:
+Firebird is completely free of any registration, licensing or deployment
+fees.  It may be deployed freely for use with any third-party software,
+whether commercial or not.
 
 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/
diff --git a/databases/firebird2-server/pkg-plist b/databases/firebird2-server/pkg-plist
index 0667577533bd..0f09cdcc03b2 100644
--- a/databases/firebird2-server/pkg-plist
+++ b/databases/firebird2-server/pkg-plist
@@ -1,18 +1,17 @@
 @comment $FreeBSD$
+bin/fb_inet_server
+bin/fb_lock_mgr
 bin/fb_lock_print
 bin/gbak
 bin/gdef
+bin/gds_drop
 bin/gfix
 bin/gsec
 bin/gstat
+bin/nbackup
 libexec/firebird/intl/fbintl
-libexec/firebird/udf/fbudf.so
-libexec/firebird/udf/fbudf.sql
 libexec/firebird/udf/ib_udf.so
-libexec/firebird/udf/ib_udf.sql
-sbin/fb_inet_server
-sbin/fb_lock_mgr
-sbin/gds_drop
+libexec/firebird/udf/ib_udf2.sql
 @unexec (cmp -s %D/%%CONFDIR%%/aliases.conf %D/%%CONFDIR%%/aliases.conf.sample && rm -f %D/%%CONFDIR%%/aliases.conf) || true
 %%CONFDIR%%/aliases.conf.sample
 @exec [ -f %B/aliases.conf ] || cp %B/%f %B/aliases.conf
@@ -21,10 +20,9 @@ sbin/gds_drop
 @dirrm libexec/firebird/udf
 @dirrm libexec/firebird
 @cwd /
-@unexec (cmp -s %D/%%LOCALSTATEDIR%%/security.fdb %D/%%LOCALSTATEDIR%%/security.fdb.sample && rm -f %D/%%LOCALSTATEDIR%%/security.fdb) || true
-%%LOCALSTATEDIR%%/security.fdb.sample
-@exec [ -f %D/%%LOCALSTATEDIR%%/security.fdb ] || cp %D/%F %D/%%LOCALSTATEDIR%%/security.fdb
-%%LOCALSTATEDIR%%/RELNOTES
+@unexec (cmp -s %D/%%LOCALSTATEDIR%%/security2.fdb %D/%%LOCALSTATEDIR%%/security2.fdb.sample && rm -f %D/%%LOCALSTATEDIR%%/security2.fdb) || true
+%%LOCALSTATEDIR%%/security2.fdb.sample
+@exec [ -f %D/%%LOCALSTATEDIR%%/security2.fdb ] || cp %D/%F %D/%%LOCALSTATEDIR%%/security2.fdb
 %%LOCALSTATEDIR%%/help/help.fdb
 @unexec [ -s %D/%%LOCALSTATEDIR%%/firebird.log ] || rm -f %D/%%LOCALSTATEDIR%%/firebird.log
 @unexec rm -f %D/%%LOCALSTATEDIR%%/isc_event1.`hostname`
diff --git a/databases/firebird2-server/pkg-plist.client b/databases/firebird2-server/pkg-plist.client
index 8b61d85d22d4..71995b46b9f3 100644
--- a/databases/firebird2-server/pkg-plist.client
+++ b/databases/firebird2-server/pkg-plist.client
@@ -3,19 +3,18 @@ bin/gpre
 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.2
 lib/libfbclient.so.%%FIREBIRD_VERSION%%
 lib/libfbembed.so
-lib/libfbembed.so.1
+lib/libfbembed.so.2
 lib/libfbembed.so.%%FIREBIRD_VERSION%%
 lib/libgds.so
-lib/libgds.so.1
+lib/libgds.so.2
 lib/libib_util.so
 @unexec if cmp -s %D/%%CONFDIR%%/firebird.conf %D/%%CONFDIR%%/firebird.conf.sample; then rm -f %D/%%CONFDIR%%/firebird.conf; fi
 %%CONFDIR%%/firebird.conf.sample
@@ -24,53 +23,4 @@ lib/libib_util.so
 %%DATADIR%%/de_DE.msg
 %%DATADIR%%/firebird.msg
 %%DATADIR%%/fr_FR.msg
-%%DATADIR%%/ja_JP.msg
 @dirrm %%DATADIR%%
-%%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 %%EXAMPLESDIR%%
diff --git a/databases/firebird20-server/Makefile b/databases/firebird20-server/Makefile
index 11662b78d616..e43e14ed379d 100644
--- a/databases/firebird20-server/Makefile
+++ b/databases/firebird20-server/Makefile
@@ -1,27 +1,30 @@
-# New ports collection makefile for:	Firebird
-# Date created:		20 December 2000
-# Whom:			Geoffrey C. Speicher <geoff@sea-incorporated.com>
+# New ports collection makefile for:	firebird2-server
+# Date created:		15 August 2006
+# Whom:			Sergey Skvortsov <skv@protey.ru>
 #
 # $FreeBSD$
 #
 
 PORTNAME?=	firebird
-PORTVERSION=	1.5.3
+PORTVERSION=	2.0.0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
 MASTER_SITE_SUBDIR=firebird
 PKGNAMESUFFIX?=	-server
-DISTNAME=	firebird-1.5.3.4870
+DISTNAME=	Firebird-2.0.0.12724-ReleaseCandidate4
 
 MAINTAINER=	skv@FreeBSD.org
-COMMENT?=	The open-source InterBase(tm) 6.0 spin-off (Classic version)
+COMMENT?=	Firebird-2 relational database (server)
+
+UNIQUENAME?=	${PORTNAME}2
 
 USE_BISON=	yes
 USE_BZIP2=	yes
 USE_GMAKE=	yes
 GNU_CONFIGURE=	yes
 USE_AUTOTOOLS=	autoconf:259 aclocal:19 libtool:15
-ACLOCAL_ARGS=	--acdir=${ACLOCAL_DIR} -I ${LOCALBASE}/share/aclocal
+ACLOCAL_ARGS=	--acdir=${ACLOCAL_DIR} -I ${LOCALBASE}/share/aclocal \
+		-I ${WRKSRC}/m4
 USE_GCC=	3.4+
 
 LOCALSTATEDIR=	/var/db/firebird
@@ -37,14 +40,15 @@ LD=	${CC}
 STRIP=
 
 ONLY_FOR_ARCHS=	i386 amd64
+CONFLICTS=	firebird-client-1* firebird-server-1*
 
-WRKSRC=		${WRKDIR}/${DISTNAME}
+WRKSRC=		${WRKDIR}/${DISTNAME:C/^F/f/}
 
 INSTALL_FB=	${INSTALL} ${COPY} -g firebird
 
 .if !defined(CLIENT_ONLY)
 # Server part stuff
-LIB_DEPENDS+=	fbembed.1:${PORTSDIR}/databases/firebird-client
+LIB_DEPENDS+=	fbembed.2:${PORTSDIR}/databases/firebird2-client
 
 AUTOGENARGS=	--with-lock-manager
 
@@ -55,13 +59,13 @@ SUB_FILES=	pkg-install pkg-message aliases.conf
 SUB_LIST+=	LOCALSTATEDIR=${LOCALSTATEDIR}
 
 SUID_BIN=	fb_inet_server fb_lock_mgr gds_drop
-UTIL_BIN=	fb_lock_print gbak gdef gfix gsec gstat
-UDF_SO=		ib_udf.so fbudf.so
-UDF_SQL=	src/extlib/ib_udf.sql src/extlib/fbudf/fbudf.sql
-
-CONFLICTS=	firebird-devel-[0-9]*
+UTIL_BIN=	fb_lock_print gbak gdef gfix gsec gstat nbackup
+UDF_SO=		ib_udf.so
+UDF_SQL=	src/extlib/ib_udf2.sql
 .else
 # Client part stuff
+LIB_DEPENDS=	icuuc.34:${PORTSDIR}/devel/icu
+
 AUTOGENARGS=	--with-editline
 
 ALL_TARGET=	firebird_basic libfbembed embed_isql embed_gpre \
@@ -69,10 +73,15 @@ ALL_TARGET=	firebird_basic libfbembed embed_isql embed_gpre \
 #ALL_TARGET=	firebird_basic libfbembed libfbclient \
 #		client_gpre client_gdef client_isql client_qli extlib
 
-INSTALLS_SHLIB=	yes
+USE_LDCONFIG=	yes
 CLIENT_BIN=	gpre isql qli
 
-CONFIGURE_ENV+=	PTHREAD_CFLAGS="${PTHREAD_CFLAGS}" PTHREAD_LIBS="${PTHREAD_LIBS}"
+CFLAGS+=	-I${LOCALBASE}/include
+LDFLAGS+=	-L${LOCALBASE}/lib
+
+CONFIGURE_ENV+=	CFLAGS="${CFLAGS}" LDFLAGS="${LDFLAGS}" \
+		PTHREAD_CFLAGS="${PTHREAD_CFLAGS}" \
+		PTHREAD_LIBS="${PTHREAD_LIBS}"
 
 .if !defined(NOPORTDOCS)
 PORTDOCS=	*
@@ -81,17 +90,19 @@ PORTDOCS=	*
 
 MAKE_ENV+=	CC=${CC} CXX=${CXX} FIREBIRD_TMP="${WRKDIR}" FIREBIRD_LOCK="${WRKDIR}"
 
+post-extract:
+	@${RM} -rf ${WRKSRC}/extern/icu
+
+post-patch:
+	@${MKDIR} ${WRKSRC}/m4
+	${CP} ${FILESDIR}/*.m4 ${WRKSRC}/m4
+
 .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} "changed since version 1.x."
 	@${ECHO_MSG} "Cancel this installation now and backup your databases"
 	@${ECHO_MSG} "if you have not already done so."
 .if !defined(BATCH)
@@ -100,16 +111,18 @@ pre-everything::
 .endif
 
 .if !defined(CLIENT_ONLY)
-pre-install:
+pre-su-install:
 	@${SETENV} PKG_PREFIX="${PREFIX}" ${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 
-post-install:
+post-su-install:
 	@${SETENV} PKG_PREFIX="${PREFIX}" ${SH} ${PKGINSTALL} ${PORTNAME} POST-INSTALL
 	@${CAT} ${PKGMESSAGE}
 .endif
 
 .ifndef WITHOUT_IPC_CLEANUP
 pre-build:
+	@if [ `${ID} -u` -eq 0 ]; then \
+	${ECHO_MSG} "==> Please do not build ${PORTNAME} as 'root' because this may cause conflicts with SysV semaphores of running services."; exit 1; fi
 	[ -f ${WRKDIR}/ipcs.pre.build ] || /usr/bin/ipcs -s | ${TAIL} -n +3 | \
 		${GREP} -F `${ID} -un` | ${CAT} > ${WRKDIR}/ipcs.pre.build
 
@@ -125,7 +138,9 @@ do-configure:
 	${AUTOTOOLS_VARS} ./autogen.sh --localstatedir=${LOCALSTATEDIR} \
 		--prefix=${LOCALSTATEDIR} --exec-prefix=${PREFIX} \
 		--libexecdir=${LIBEXECDIR} \
-		--sysconfdir=${CONFDIR} --datadir=${DATADIR} ${AUTOGENARGS})
+		--sysconfdir=${CONFDIR} --datadir=${DATADIR} \
+		--with-icu-config=${LOCALBASE}/bin/icu-config \
+		${AUTOGENARGS})
 
 post-configure:
 	@${REINPLACE_CMD} -e 's|__attribute__ ((__unused__));||' \
@@ -137,10 +152,13 @@ do-install:
 	${INSTALL_PROGRAM} ${UTIL_BIN:S!^!${WRKSRC}/gen/firebird/bin/!} ${PREFIX}/bin
 
 	${INSTALL_PROGRAM} -o firebird -g firebird -m 6550 \
-		${SUID_BIN:S!^!${WRKSRC}/gen/firebird/bin/!} ${PREFIX}/sbin
+		${SUID_BIN:S!^!${WRKSRC}/gen/firebird/bin/!} ${PREFIX}/bin
 
 	@${MKDIR} ${CONFDIR}
 	${INSTALL_DATA} ${WRKDIR}/aliases.conf ${CONFDIR}/aliases.conf.sample
+.if !exists(${CONFDIR}/aliases.conf)
+	${INSTALL_DATA} ${WRKDIR}/aliases.conf ${CONFDIR}/aliases.conf
+.endif
 
 	${MKDIR} ${LIBEXECDIR}/udf ${LOCALSTATEDIR}/help ${LIBEXECDIR}/intl
 
@@ -149,19 +167,17 @@ do-install:
 	${INSTALL_FB} -m 0555 ${UDF_SO:S!^!${WRKSRC}/gen/firebird/UDF/!} ${LIBEXECDIR}/udf
 	${INSTALL_FB} -m 0444 ${UDF_SQL:S!^!${WRKSRC}/!} ${LIBEXECDIR}/udf
 
-.if !exists(${LOCALSTATEDIR}/security.fdb)
-	${INSTALL_FB} -m 0660 -o firebird ${WRKSRC}/gen/firebird/security.fdb \
-		${LOCALSTATEDIR}/security.fdb
+.if !exists(${LOCALSTATEDIR}/security2.fdb)
+	${INSTALL_FB} -m 0660 -o firebird ${WRKSRC}/gen/firebird/security2.fdb \
+		${LOCALSTATEDIR}/security2.fdb
 .endif
-	${INSTALL_FB} -m 0660 -o firebird ${WRKSRC}/gen/firebird/security.fdb \
-		${LOCALSTATEDIR}/security.fdb.sample
+	${INSTALL_FB} -m 0660 -o firebird ${WRKSRC}/gen/firebird/security2.fdb \
+		${LOCALSTATEDIR}/security2.fdb.sample
 
 	${INSTALL_FB} -m 0440 ${WRKSRC}/gen/firebird/help/help.fdb \
 		${LOCALSTATEDIR}/help
 
 	${INSTALL_FB} -m 0555 ${WRKSRC}/gen/firebird/intl/libfbintl.so ${LIBEXECDIR}/intl/fbintl
-
-	${INSTALL_DATA} ${FILESDIR}/RELNOTES ${LOCALSTATEDIR}
 .else
 # defined CLIENT_ONLY
 	${INSTALL_PROGRAM} ${CLIENT_BIN:S!^!${WRKSRC}/gen/firebird/bin/!} \
@@ -180,13 +196,14 @@ do-install:
 		${WRKSRC}/gen/firebird/lib/libfbembed.so.${PORTVERSION} \
 		${PREFIX}/lib
 
-	${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libfbclient.so.1
-	${LN} -fs libfbclient.so.1 ${PREFIX}/lib/libfbclient.so
+	${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libfbclient.so.2
+	${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libfbclient.so
 
-	${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
+	${LN} -fs libfbembed.so.${PORTVERSION} ${PREFIX}/lib/libfbembed.so.2
+	${LN} -fs libfbembed.so.${PORTVERSION} ${PREFIX}/lib/libfbembed.so
+
+	${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libgds.so.2
+	${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libgds.so
 
 	@${MKDIR} ${PREFIX}/include
 	${INSTALL_DATA} ${WRKSRC}/gen/firebird/include/*.h ${PREFIX}/include
@@ -200,10 +217,6 @@ do-install:
 	${INSTALL_DATA} ${WRKSRC}/doc/README.user ${DOCSDIR}/README
 	${INSTALL_DATA} ${WRKSRC}/doc/sql.extensions/README.* ${DOCSDIR}/sql.extensions
 .endif
-
-	@${ECHO_MSG} "===>   Installing examples for ${PKGNAME}"
-	@${MKDIR} ${EXAMPLESDIR}
-	${INSTALL_DATA} ${WRKSRC}/gen/firebird/examples/v5/* ${EXAMPLESDIR}
 .endif
 
 .include <bsd.port.post.mk>
diff --git a/databases/firebird20-server/distinfo b/databases/firebird20-server/distinfo
index ca162a069ca5..e23ebea85b9a 100644
--- a/databases/firebird20-server/distinfo
+++ b/databases/firebird20-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (firebird-1.5.3.4870.tar.bz2) = 559d005ab6622274f9448687f930393c
-SHA256 (firebird-1.5.3.4870.tar.bz2) = 16880405d6e321a70e80c6e6fb4ed8429a692c43b8a7b59a676cf7d2162d2023
-SIZE (firebird-1.5.3.4870.tar.bz2) = 5055973
+MD5 (Firebird-2.0.0.12724-ReleaseCandidate4.tar.bz2) = c955612c692484b3da84e8c3e518afe6
+SHA256 (Firebird-2.0.0.12724-ReleaseCandidate4.tar.bz2) = 16c88b35de8c85ea39e2289876dab9e15e6a7a8be3ce14ca492ca63873221da1
+SIZE (Firebird-2.0.0.12724-ReleaseCandidate4.tar.bz2) = 12471842
diff --git a/databases/firebird20-server/files/RELNOTES b/databases/firebird20-server/files/RELNOTES
deleted file mode 100644
index 87a8c5de91bf..000000000000
--- a/databases/firebird20-server/files/RELNOTES
+++ /dev/null
@@ -1,108 +0,0 @@
-Firebird 1.5.3 FreeBSD Release Notes
---------------------------------------
-FB-V1.5.3.4870 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 /var/db/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/share/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>
diff --git a/databases/firebird20-server/files/aliases.conf.in b/databases/firebird20-server/files/aliases.conf.in
index 92b5b620c07a..ded23bfd70cb 100644
--- a/databases/firebird20-server/files/aliases.conf.in
+++ b/databases/firebird20-server/files/aliases.conf.in
@@ -5,5 +5,5 @@
 # Examples:
 #
 # employee = %%EXAMPLESDIR%%/employee.fdb
-# security = /var/db/firebird/security.fdb
+# security = /var/db/firebird/security2.fdb
 #
diff --git a/databases/firebird20-server/files/icu.m4 b/databases/firebird20-server/files/icu.m4
new file mode 100644
index 000000000000..37d0f8a08c40
--- /dev/null
+++ b/databases/firebird20-server/files/icu.m4
@@ -0,0 +1,46 @@
+dnl AM_PATH_ICU([MINIMUM-VERSION])
+dnl Adds support for ICU
+AC_DEFUN([AM_PATH_ICU],
+[
+  rast_lib_icu_major="$1"
+  rast_lib_icu_minor="$2"
+  rast_lib_icu_version="$1.$2"
+
+  AC_ARG_WITH(icu-config,
+  AC_HELP_STRING([--with-icu-config=PATH],[path to icu-config]),
+  [
+      AC_MSG_RESULT(using $withval for icu-config)
+      ICU_CONFIG="$withval"
+  ], [
+      AC_PATH_PROG(ICU_CONFIG, icu-config, no)
+  ])
+  HAVE_ICU="no"
+  if test "$ICU_CONFIG" != "no"; then
+    AC_MSG_CHECKING([ICU version])    
+    ICU_VERSION="`$ICU_CONFIG --version`"
+    if test $? -eq 0; then
+      changequote(<<, >>)
+      ICU_MAJOR=`expr "$ICU_VERSION" : '\(.*\)\..*'`
+      ICU_MINOR=`expr "$ICU_VERSION" : '.*\.\(.*\)'`
+      changequote([, ])
+      if expr "$ICU_MAJOR" '>' "$rast_lib_icu_major" > /dev/null ||
+         ( expr "$ICU_MAJOR" '=' "$rast_lib_icu_major" > /dev/null &&
+           expr "$ICU_MINOR" '>=' "$rast_lib_icu_minor" > /dev/null ); then
+        AC_MSG_RESULT([$ICU_VERSION])
+
+        ICU_CPPFLAGS=`$ICU_CONFIG --cppflags`
+        ICU_LIBS=`$ICU_CONFIG --ldflags-libsonly`
+        ICU_LDFLAGS=`$ICU_CONFIG --ldflags-searchpath`
+        AC_SUBST(ICU_CPPFLAGS)
+        AC_SUBST(ICU_LIBS)
+        AC_SUBST(ICU_LDFLAGS)
+        HAVE_ICU="yes"
+      else
+        AC_MSG_WARN([$ICU_VERSION is too old; $rast_lib_icu_version is required])
+      fi
+    else
+      AC_MSG_WARN([icu-config --version failed])
+    fi
+  fi
+  AC_SUBST(HAVE_ICU)
+])
diff --git a/databases/firebird20-server/files/patch-amd64 b/databases/firebird20-server/files/patch-amd64
deleted file mode 100644
index 1f4d465389b3..000000000000
--- a/databases/firebird20-server/files/patch-amd64
+++ /dev/null
@@ -1,76 +0,0 @@
---- src/jrd/common.h.orig	Mon Jan 23 20:52:45 2006
-+++ src/jrd/common.h	Mon Jan 23 20:54:36 2006
-@@ -273,8 +273,14 @@
- 
- #define UNIX  1
- #define IEEE  1
-+
-+#ifdef AMD64
-+#define IMPLEMENTATION  isc_info_db_impl_freebsd_amd64 /* 67  next higher unique n
-+umber, See you later  */
-+#else
- #define I386  1
- #define IMPLEMENTATION    isc_info_db_impl_freebsd   /* 61 */
-+#endif
- 
- #define QUADFORMAT "ll"
- #define QUADCONST(n) (n##LL)
---- src/jrd/ibase.h.orig	Mon Jan 23 20:51:38 2006
-+++ src/jrd/ibase.h	Mon Jan 23 20:52:08 2006
-@@ -1577,6 +1577,8 @@
- 	isc_info_db_impl_linux_sparc = 65,
- 	isc_info_db_impl_linux_amd64 = 66,
- 
-+	isc_info_db_impl_freebsd_amd64 = 67,
-+
- 	isc_info_db_impl_last_value   /* Leave this LAST! */
-     };
- 
---- src/jrd/pag.cpp.orig	Sat Mar 26 07:07:11 2005
-+++ src/jrd/pag.cpp	Mon Jan 23 21:27:49 2006
-@@ -143,8 +143,9 @@
- static const int CLASS_NETBSD_I386 = 22;  // NetBSD/i386
- static const int CLASS_DARWIN_PPC = 23;   // Darwin/PowerPC
- static const int CLASS_LINUX_AMD64 = 24;  // LINUX on AMD64 systems
-+static const int CLASS_FREEBSD_AMD64 = 25;// FreeBSD/amd64
- 
--static const int CLASS_MAX10 = CLASS_LINUX_AMD64;
-+static const int CLASS_MAX10 = CLASS_FREEBSD_AMD64;
- 
- // ARCHITECTURE COMPATIBILITY CLASSES
- 
-@@ -188,7 +189,8 @@
- 	archIntel86, // CLASS_FREEBSD_I386
-     archIntel86, // CLASS_NETBSD_I386
- 	archUnknown, // CLASS_DARWIN_PPC
--	archUnknown  // CLASS_LINUX_AMD64
-+	archUnknown, // CLASS_LINUX_AMD64
-+	archUnknown  // CLASS_FREEBSD_AMD64
- };
- 
- #ifdef sun
-@@ -239,7 +241,12 @@
- #endif
- 
- #ifdef FREEBSD
-+#ifdef i386
- #define CLASS           CLASS_FREEBSD_I386
-+#endif
-+#ifdef AMD64
-+#define CLASS           CLASS_FREEBSD_AMD64
-+#endif
- #endif
- 
- #ifdef NETBSD
---- src/jrd/utl.cpp.orig	Mon Jan 23 20:56:00 2006
-+++ src/jrd/utl.cpp	Mon Jan 23 20:56:37 2006
-@@ -255,7 +255,8 @@
-     "Firebird/Darwin/PowerPC",	/* 63 */
-     "Firebird/SINIX-Z",	/* 64 */
-     "Firebird/linux Sparc",	/* 65 */
--    "Firebird/linux AMD64"	/* 66 */
-+    "Firebird/linux AMD64",	/* 66 */
-+    "Firebird/FreeBSD/amd64"	/* 67 */
- };
- 
- 
diff --git a/databases/firebird2-server/files/patch-src%install%misc%firebird.conf b/databases/firebird20-server/files/patch-builds%install%misc%firebird.conf
index 4f8f1b416285..d0105af83cf6 100644
--- a/databases/firebird2-server/files/patch-src%install%misc%firebird.conf
+++ b/databases/firebird20-server/files/patch-builds%install%misc%firebird.conf
@@ -1,5 +1,5 @@
---- src/install/misc/firebird.conf.orig	Fri Sep 30 17:13:47 2005
-+++ src/install/misc/firebird.conf	Wed Mar 15 17:03:43 2006
+--- builds/install/misc/firebird.conf.orig	Tue Aug 15 22:38:52 2006
++++ builds/install/misc/firebird.conf	Tue Aug 15 22:39:24 2006
 @@ -60,7 +60,7 @@
  #
  # Type: string
@@ -9,7 +9,7 @@
  
  
  # ----------------------------
-@@ -126,7 +126,7 @@
+@@ -125,7 +125,7 @@
  #
  # Type: string (special format)
  #
diff --git a/databases/firebird20-server/files/patch-builds%make.new%config%config.h.in b/databases/firebird20-server/files/patch-builds%make.new%config%config.h.in
deleted file mode 100644
index 1ad510c8f674..000000000000
--- a/databases/firebird20-server/files/patch-builds%make.new%config%config.h.in
+++ /dev/null
@@ -1,20 +0,0 @@
---- builds/make.new/config/config.h.in.orig	Sun Jul  6 05:07:48 2003
-+++ builds/make.new/config/config.h.in	Thu Mar 16 19:15:02 2006
-@@ -172,6 +172,7 @@
- #undef PowerPC
- #undef sparc
- #undef i386
-+#undef AMD64
- #undef mips
- #undef alpha
- 
-@@ -190,5 +191,9 @@
- #undef SINIXZ
- 
- #define FB_PREFIX "/usr/local/firebird"
-+#define FB_EXEC_PREFIX	"/usr/local"
-+#define FB_CONF_PREFIX	"/usr/local/etc/firebird"
-+#define FB_MSG_PREFIX	"/usr/local/libdata/firebird"
-+#define FB_LIBEXEC_PREFIX	"/usr/local/libexec/firebird"
- 
- #endif
diff --git a/databases/firebird20-server/files/patch-builds%posix%Makefile.in.firebird b/databases/firebird20-server/files/patch-builds%posix%Makefile.in.firebird
new file mode 100644
index 000000000000..31a0b95ec4f7
--- /dev/null
+++ b/databases/firebird20-server/files/patch-builds%posix%Makefile.in.firebird
@@ -0,0 +1,35 @@
+--- builds/posix/Makefile.in.firebird.orig	Sun Dec 18 20:56:17 2005
++++ builds/posix/Makefile.in.firebird	Wed Sep 13 20:31:13 2006
+@@ -186,7 +186,6 @@
+ # 
+ 
+ external_libraries:
+-	$(MAKE) -f $(GEN_ROOT)/Makefile.extern.icu
+ ifeq ($(EDITLINE_FLG),Y)
+ 	$(MAKE) -f $(GEN_ROOT)/Makefile.extern.editline
+ endif
+@@ -515,12 +514,12 @@
+ #___________________________________________________________________________
+ # 
+ .PHONY: clean clean_objects clean_dependancies clean_extern_objects clean_build \
+-		clean_gpre_gen clean_icu clean_dbs clean_examples clean_makefiles \
++		clean_gpre_gen clean_dbs clean_examples clean_makefiles \
+ 		clean_editline clean_all
+ 
+ 
+ clean: clean_objects clean_dependancies clean_extern_objects clean_build \
+-		clean_gpre_gen clean_icu clean_dbs clean_examples
++		clean_gpre_gen clean_dbs clean_examples
+ 
+ ifeq ($(EDITLINE_FLG),Y)
+ clean: clean_editline
+@@ -542,9 +541,6 @@
+ 
+ clean_editline:
+ 	-make -C $(ROOT)/extern/editline clean
+-
+-clean_icu:
+-	-make -C $(ROOT)/extern/icu/source clean
+ 
+ clean_objects:
+ 	$(RM) `find $(TMP_ROOT)/ -type f -name '*.o' -print`
diff --git a/databases/firebird20-server/files/patch-builds%posix%make.defaults b/databases/firebird20-server/files/patch-builds%posix%make.defaults
index f7d4bc6362f3..bef124859a91 100644
--- a/databases/firebird20-server/files/patch-builds%posix%make.defaults
+++ b/databases/firebird20-server/files/patch-builds%posix%make.defaults
@@ -1,6 +1,6 @@
---- builds/posix/make.defaults.orig	Thu Mar 16 19:49:57 2006
-+++ builds/posix/make.defaults	Thu Mar 16 19:51:18 2006
-@@ -94,7 +94,7 @@
+--- builds/posix/make.defaults.orig	Wed Dec 28 09:58:28 2005
++++ builds/posix/make.defaults	Wed Aug 16 16:26:16 2006
+@@ -102,7 +102,7 @@
  CHMOD=			chmod
  CHMOD_6=		chmod 666
  CHMOD_7=		chmod 777
@@ -9,3 +9,13 @@
  MV=			mv -f
  TOUCH=			touch
  CP=			cp
+@@ -180,9 +180,6 @@
+ 
+ LIBFBSTATIC_A = $(LIB)/libfbstatic.a
+ LIBEDITLINE_A = $(LIB)/libeditline.a
+-LIBICU_SO = $(LIB)/$(LIB_PREFIX)icuuc.$(SHRLIB_EXT) \
+-			$(LIB)/$(LIB_PREFIX)icudata.$(SHRLIB_EXT) \
+-			$(LIB)/$(LIB_PREFIX)icui18n.$(SHRLIB_EXT)
+ 
+ # Shared library name for usage inside of the UDF
+ IbUtilLibraryName = $(LIB_PREFIX)ib_util.$(SHRLIB_EXT)
diff --git a/databases/firebird20-server/files/patch-builds%posix%make.rules b/databases/firebird20-server/files/patch-builds%posix%make.rules
new file mode 100644
index 000000000000..4131aff1f052
--- /dev/null
+++ b/databases/firebird20-server/files/patch-builds%posix%make.rules
@@ -0,0 +1,20 @@
+--- builds/posix/make.rules.orig	Wed Dec 28 09:58:28 2005
++++ builds/posix/make.rules	Thu Sep 14 17:29:08 2006
+@@ -33,7 +33,7 @@
+ 
+ 
+ # Please don't use compiler/platform specific flags here - nmcc 02-Nov-2002
+-CFLAGS:= $(CFLAGS) -I$(SRC_ROOT)/include/gen -I$(SRC_ROOT)/include -I$(SRC_ROOT)/vulcan -I$(ROOT)/extern/icu/source/common -I$(ROOT)/extern/icu/source/i18n -DNAMESPACE=Vulcan
++CFLAGS:= $(CFLAGS) -I$(SRC_ROOT)/include/gen -I$(SRC_ROOT)/include -I$(SRC_ROOT)/vulcan @ICU_CPPFLAGS@ -DNAMESPACE=Vulcan
+ 
+ ifeq ($(IsProdTypeBuild),Y)
+   CFLAGS:= $(CFLAGS) $(PROD_FLAGS) -DPROD_BUILD
+@@ -75,7 +75,7 @@
+ STATICEXE_LINK = @CXX@
+ 
+ LINK_LIBS = @LIBS@ @EDITLINE_A@
+-ICU_LIBS = -licuuc -licudata -licui18n
++ICU_LIBS = @ICU_LIBS@ @ICU_LDFLAGS@
+ STATICLINK_LIBS = @LIBS@ @EDITLINE_A@
+ SO_LINK_LIBS = @LIBS@
+ 
diff --git a/databases/firebird20-server/files/patch-configure.in b/databases/firebird20-server/files/patch-configure.in
index ce1a65467bb9..4e09407641e4 100644
--- a/databases/firebird20-server/files/patch-configure.in
+++ b/databases/firebird20-server/files/patch-configure.in
@@ -1,30 +1,45 @@
---- configure.in.orig	Wed Dec 14 10:29:08 2005
-+++ configure.in	Thu Mar 16 18:38:55 2006
-@@ -49,6 +49,16 @@
-     SHRLIB_EXT=dylib
-     ;;
- 
-+  amd64-*-freebsd*)
-+    MAKEFILE_PREFIX=freebsd 
-+    PLATFORM=FREEBSD
-+    AC_DEFINE(FREEBSD)
-+    AC_DEFINE(AMD64)
-+    LOCK_MANAGER_FLG=Y
-+    EDITLINE_FLG=N
-+    SHRLIB_EXT=so
-+    ;;
-+
-   *-*-freebsd*)
-     MAKEFILE_PREFIX=freebsd 
-     PLATFORM=FREEBSD
-@@ -612,6 +622,10 @@
+--- configure.in.orig	Tue Apr 25 21:07:23 2006
++++ configure.in	Thu Sep 14 19:30:42 2006
+@@ -423,9 +423,10 @@
+ AC_CHECK_LIB(curses, main)
+ dnl AC_CHECK_LIB(termcap, main)
+ if test "$EDITLINE_FLG" = "Y"; then
+-  AC_SUBST(EDITLINE_A, -leditline)
++  AC_SUBST(EDITLINE_A, "-ledit -lreadline")
+ fi
+ AC_CHECK_LIB(stdc++, main,,, $LIBS)
++AM_PATH_ICU(3, 4)
+ 
+ 
+ dnl Check for functions
+@@ -696,6 +697,10 @@
  AC_SUBST(NEW_FIREBIRD_DIR)
  
- AC_DEFINE_UNQUOTED(FB_PREFIX, $(if test "x$prefix" = "xNONE" ; then echo \"$ac_default_prefix\"; else echo \"$prefix\"; fi))
-+AC_DEFINE_UNQUOTED(FB_EXEC_PREFIX, "$exec_prefix")
-+AC_DEFINE_UNQUOTED(FB_CONF_PREFIX, "$sysconfdir")
-+AC_DEFINE_UNQUOTED(FB_MSG_PREFIX, "$datadir")
-+AC_DEFINE_UNQUOTED(FB_LIBEXEC_PREFIX, "$libexecdir")
+ AC_DEFINE_UNQUOTED(FB_PREFIX, $(if test "x$prefix" = "xNONE" ; then echo \"$ac_default_prefix\"; else echo \"$prefix\"; fi), [Installation path prefix])
++AC_DEFINE_UNQUOTED(FB_EXEC_PREFIX, "$exec_prefix", [Executables path prefix])
++AC_DEFINE_UNQUOTED(FB_CONF_PREFIX, "$sysconfdir", [Single-machine data path prefix])
++AC_DEFINE_UNQUOTED(FB_MSG_PREFIX, "$datadir", [Architecture-independent data path prefix])
++AC_DEFINE_UNQUOTED(FB_LIBEXEC_PREFIX, "$libexecdir", [Program executables path prefix])
  
  AC_CONFIG_COMMANDS(,,[
- dnl ### GEN ### directories for preprocessed cpp, databases and output
+ dnl # rebuild version header if needed
+@@ -1004,19 +1009,11 @@
+ gen/Makefile.install:builds/install/arch-specific/${INSTALL_PREFIX}/Makefile.in
+ Makefile:Makefile.in
+ gen/Makefile.extern.editline:${MAKE_SRC_DIR}/Makefile.in.extern.editline
+-gen/Makefile.extern.icu:${MAKE_SRC_DIR}/Makefile.in.extern.icu
+ )
+ 
+ 
+ 
+-if test "$PROD_BUILD_FLG" = N; then
+-  DEBUG_ICU=--enable-debug
+-fi
+-
+ AC_OUTPUT
+-(cd extern/icu/source
+-chmod +x runConfigureICU configure install-sh
+-./runConfigureICU "$ICU_PLATFORM" "$DEBUG_ICU" --prefix=`pwd`/..)
+ 
+ 
+ dnl Print out the build configuration (the most interesting thing)
diff --git a/databases/firebird20-server/files/patch-src%common%config%config.cpp b/databases/firebird20-server/files/patch-src%common%config%config.cpp
index 34645c66ca09..b05adf508983 100644
--- a/databases/firebird20-server/files/patch-src%common%config%config.cpp
+++ b/databases/firebird20-server/files/patch-src%common%config%config.cpp
@@ -1,11 +1,11 @@
---- src/common/config/config.cpp.orig	Wed Mar 15 14:17:53 2006
-+++ src/common/config/config.cpp	Wed Mar 15 14:18:30 2006
-@@ -106,7 +106,7 @@
+--- src/common/config/config.cpp.orig	Tue Aug 15 22:53:43 2006
++++ src/common/config/config.cpp	Tue Aug 15 22:54:38 2006
+@@ -111,7 +111,7 @@
  	{TYPE_STRING,		"RemoteBindAddress",		(ConfigValue) 0},
  	{TYPE_STRING,		"ExternalFileAccess",		(ConfigValue) "None"},	// location(s) of external files for tables
  	{TYPE_STRING,		"DatabaseAccess",			(ConfigValue) "Full"},	// location(s) of databases
 -	{TYPE_STRING,		"UdfAccess",				(ConfigValue) "Restrict UDF"},	// location(s) of UDFs
-+	{TYPE_STRING,		"UdfAccess",				(ConfigValue) "Restrict " FB_LIBEXEC_PREFIX "/udf"},	// location(s) of UDFs
++	{TYPE_STRING,		"UdfAccess",				(ConfigValue) "Restrict " FB_LIBEXEC_PREFIX "/UDF"},	// location(s) of UDFs
  	{TYPE_STRING,		"TempDirectories",			(ConfigValue) 0},
- 	{TYPE_BOOLEAN,		"BugcheckAbort",			(ConfigValue) false},	// whether to abort() engine when internal error is found
- 	{TYPE_BOOLEAN,		"OldColumnNaming",			(ConfigValue) false}	// if true use old column naming rules
+ #ifdef DEV_BUILD
+  	{TYPE_BOOLEAN,		"BugcheckAbort",			(ConfigValue) true},	// whether to abort() engine when internal error is found
diff --git a/databases/firebird20-server/files/patch-src%jrd%db_alias.cpp b/databases/firebird20-server/files/patch-src%jrd%db_alias.cpp
index 8c0e56b144da..27f7d6dc114d 100644
--- a/databases/firebird20-server/files/patch-src%jrd%db_alias.cpp
+++ b/databases/firebird20-server/files/patch-src%jrd%db_alias.cpp
@@ -1,13 +1,13 @@
---- src/jrd/db_alias.cpp.orig	Mon Aug 18 01:16:41 2003
-+++ src/jrd/db_alias.cpp	Mon Jul 25 15:07:45 2005
-@@ -37,8 +37,8 @@
+--- src/jrd/db_alias.cpp.orig	Tue Aug 15 23:07:31 2006
++++ src/jrd/db_alias.cpp	Tue Aug 15 23:10:08 2006
+@@ -33,8 +33,8 @@
  
- bool ResolveDatabaseAlias(const char* alias, char* database)
+ bool ResolveDatabaseAlias(const string& alias, string& database)
  {
--	TEXT alias_filename[MAXPATHLEN];
--	gds__prefix(alias_filename, const_cast<char*>(ALIAS_FILE));
-+	TEXT alias_filename[MAXPATHLEN] = FB_CONF_PREFIX "/";
-+	strlcat(alias_filename, ALIAS_FILE, MAXPATHLEN);
+-	string alias_filename;
+-	Firebird::Prefix(alias_filename, ALIAS_FILE);
++	string alias_filename = string(FB_CONF_PREFIX)
++		+ PathUtils::dir_sep + ALIAS_FILE;
  	ConfigFile aliasConfig(false);
- 	aliasConfig.setConfigFile(alias_filename);
+ 	aliasConfig.setConfigFilePath(alias_filename);
  
diff --git a/databases/firebird20-server/files/patch-src%jrd%gds.cpp b/databases/firebird20-server/files/patch-src%jrd%gds.cpp
index b1c47c40439a..f22bc183629e 100644
--- a/databases/firebird20-server/files/patch-src%jrd%gds.cpp
+++ b/databases/firebird20-server/files/patch-src%jrd%gds.cpp
@@ -1,11 +1,11 @@
---- src/jrd/gds.cpp.orig	Mon Jan 23 15:04:44 2006
-+++ src/jrd/gds.cpp	Mon Jan 23 15:07:20 2006
-@@ -3697,7 +3697,7 @@
- 		Firebird::string msgPrefix(getenv(FB_MSG_ENV) ? getenv(FB_MSG_ENV) : "");
- 		if (msgPrefix.length() == 0) 
+--- src/jrd/gds.cpp.orig	Tue Aug 15 22:49:37 2006
++++ src/jrd/gds.cpp	Tue Aug 15 22:50:14 2006
+@@ -3734,7 +3734,7 @@
+ 		Firebird::PathName msgPrefix;
+ 		if (!fb_utils::readenv(FB_MSG_ENV, msgPrefix))
  		{
 -			msgPrefix = prefix;
 +			msgPrefix = FB_MSG_PREFIX;
  		}
- 		copyTo(msgPrefix, ib_prefix_msg_val, sizeof(ib_prefix_msg_val));
+ 		msgPrefix.copyTo(ib_prefix_msg_val, sizeof(ib_prefix_msg_val));
  		ib_prefix_msg = ib_prefix_msg_val;
diff --git a/databases/firebird20-server/files/patch-src%jrd%os%config_root.h b/databases/firebird20-server/files/patch-src%jrd%os%config_root.h
new file mode 100644
index 000000000000..976da187b36a
--- /dev/null
+++ b/databases/firebird20-server/files/patch-src%jrd%os%config_root.h
@@ -0,0 +1,11 @@
+--- src/jrd/os/config_root.h.orig	Tue Aug 15 22:57:33 2006
++++ src/jrd/os/config_root.h	Tue Aug 15 22:57:53 2006
+@@ -76,7 +76,7 @@
+ 	{
+ 		GetRoot();
+ 		install_dir = root_dir;
+-		config_file = root_dir + string(CONFIG_FILE);
++		config_file = string(FB_CONF_PREFIX) + PathUtils::dir_sep + string(CONFIG_FILE);
+ 	}
+ 
+ 
diff --git a/databases/firebird20-server/files/patch-src%jrd%os%posix%config_root.cpp b/databases/firebird20-server/files/patch-src%jrd%os%posix%config_root.cpp
deleted file mode 100644
index 3af960c1599e..000000000000
--- a/databases/firebird20-server/files/patch-src%jrd%os%posix%config_root.cpp
+++ /dev/null
@@ -1,10 +0,0 @@
---- src/jrd/os/posix/config_root.cpp.orig	Mon Jul 25 15:19:18 2005
-+++ src/jrd/os/posix/config_root.cpp	Mon Jul 25 15:19:49 2005
-@@ -152,6 +152,6 @@
- 
- const char *ConfigRoot::getConfigFile() const
- {
--	static string file = root_dir + string(CONFIG_FILE);
-+	static string file = string(FB_CONF_PREFIX) + PathUtils::dir_sep + string(CONFIG_FILE);
- 	return file.c_str();
- }
diff --git a/databases/firebird20-server/files/patch-src%jrd%plugin_manager.cpp b/databases/firebird20-server/files/patch-src%jrd%plugin_manager.cpp
index 808568121478..7a2ffab72408 100644
--- a/databases/firebird20-server/files/patch-src%jrd%plugin_manager.cpp
+++ b/databases/firebird20-server/files/patch-src%jrd%plugin_manager.cpp
@@ -1,24 +1,20 @@
---- src/jrd/plugin_manager.cpp.orig	Wed Mar 15 14:25:42 2006
-+++ src/jrd/plugin_manager.cpp	Wed Mar 15 14:39:12 2006
-@@ -47,9 +47,7 @@
+--- src/jrd/plugin_manager.cpp.orig	Tue Aug 15 23:11:04 2006
++++ src/jrd/plugin_manager.cpp	Tue Aug 15 23:12:01 2006
+@@ -64,7 +64,7 @@
  void PluginManager::loadAllPlugins()
  {
- 	Firebird::list<Path>::iterator pathItr;
--	char fb_lib_path[MAXPATHLEN];
--	gds__prefix(fb_lib_path, "");
--	Firebird::string fbLibPath(fb_lib_path);
-+	Firebird::string fbLibPath(FB_LIBEXEC_PREFIX);
- 	Firebird::string checkDir;
+ 	Firebird::PathName checkDir;
+-	const Firebird::PathName fbLibPath = Config::getRootDirectory();
++	const Firebird::PathName fbLibPath = FB_LIBEXEC_PREFIX;
  	
- 	for(pathItr = searchPaths.begin(); pathItr != searchPaths.end(); ++pathItr)
-@@ -114,9 +112,7 @@
- 
- PluginManager::Module *PluginManager::loadPluginModule(const Firebird::string& name)
+ 	for (spIterator pathItr = searchPaths.begin(); pathItr != searchPaths.end(); ++pathItr)
+ 	{
+@@ -131,7 +131,7 @@
+ PluginManager::Module *PluginManager::loadPluginModule(const Firebird::PathName& name)
  {
--	char fb_lib_path[MAXPATHLEN];
--	gds__prefix(fb_lib_path, "");
--	Firebird::string fbLibPath(fb_lib_path);
-+	Firebird::string fbLibPath(FB_LIBEXEC_PREFIX);
- 	Firebird::string checkPath;
- 	Firebird::list<Path>::iterator itr;
+ 	Firebird::PathName checkPath;
+-	const Firebird::PathName fbLibPath = Config::getRootDirectory();
++	const Firebird::PathName fbLibPath = FB_LIBEXEC_PREFIX;
  	
+ 	// Check to see if the module name was specified as a relative path
+ 	//	from one of our search paths.  This only makes sense if the name
diff --git a/databases/firebird20-server/files/patch-src%jrd%svc.cpp b/databases/firebird20-server/files/patch-src%jrd%svc.cpp
index 42b12339bc36..ed93b6d68d13 100644
--- a/databases/firebird20-server/files/patch-src%jrd%svc.cpp
+++ b/databases/firebird20-server/files/patch-src%jrd%svc.cpp
@@ -1,12 +1,13 @@
---- src/jrd/svc.cpp.orig	Tue Jan 24 17:11:48 2006
-+++ src/jrd/svc.cpp	Tue Jan 24 17:27:22 2006
-@@ -1902,7 +1902,8 @@
+--- src/jrd/svc.cpp.orig	Tue Aug 15 23:06:16 2006
++++ src/jrd/svc.cpp	Tue Aug 15 23:06:50 2006
+@@ -1742,8 +1742,8 @@
+ 	TEXT service_path[MAXPATHLEN];
  
- #ifndef SUPERSERVER
  	if (serv->serv_executable) {
 -		gds__prefix(service_path, serv->serv_executable);
+-		service->svc_flags = SVC_forked;
 +		strlcpy(service_path, FB_EXEC_PREFIX "/", MAXPATHLEN);
 +		strlcat(service_path, serv->serv_executable, MAXPATHLEN);
- 		service->svc_flags = SVC_forked;
  		service_fork(service_path, service);
  	}
+ 
diff --git a/databases/firebird20-server/files/patch-src%lock%lock.cpp b/databases/firebird20-server/files/patch-src%lock%lock.cpp
index 7f550183e379..279324733739 100644
--- a/databases/firebird20-server/files/patch-src%lock%lock.cpp
+++ b/databases/firebird20-server/files/patch-src%lock%lock.cpp
@@ -1,15 +1,16 @@
---- src/lock/lock.cpp.orig	Mon Mar 29 08:35:49 2004
-+++ src/lock/lock.cpp	Wed Jul 27 14:01:51 2005
-@@ -2800,7 +2800,11 @@
+--- src/lock/lock.cpp.orig	Fri Feb  3 16:13:23 2006
++++ src/lock/lock.cpp	Wed Aug 16 12:41:32 2006
+@@ -2708,7 +2708,12 @@
  #ifdef DEBUG_MANAGER
  	gds__prefix(string, DEBUG_MANAGER);
  #else
 -	gds__prefix(string, LOCK_MANAGER);
 +	if (! getenv("FIREBIRD")) {
-+		strlcpy(string, FB_EXEC_PREFIX "/s" LOCK_MANAGER, MAXPATHLEN);
-+	}else	{
++		strlcpy(string, FB_EXEC_PREFIX "/", MAXPATHLEN);
++		strlcat(string, LOCK_MANAGER, MAXPATHLEN);
++	} else	{
 +		gds__prefix(string, LOCK_MANAGER);
 +	}
  #endif
  	if (statistics(string, &stat_buf) == -1) {
- 		sprintf (errorstring, "can't start lock manager: %s", string);
+ 		// bug() fills the vector with this address, it must be static.
diff --git a/databases/firebird20-server/pkg-descr b/databases/firebird20-server/pkg-descr
index ba570031da86..ed76025f94b8 100644
--- a/databases/firebird20-server/pkg-descr
+++ b/databases/firebird20-server/pkg-descr
@@ -4,10 +4,9 @@ offers excellent concurrency, high performance, and powerful language
 support for stored procedures and triggers.  It has been used in
 production systems, under a variety of names since 1981.
 
-For more information on Firebird and InterBase, see:
+Firebird is completely free of any registration, licensing or deployment
+fees.  It may be deployed freely for use with any third-party software,
+whether commercial or not.
 
 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/
diff --git a/databases/firebird20-server/pkg-plist b/databases/firebird20-server/pkg-plist
index 0667577533bd..0f09cdcc03b2 100644
--- a/databases/firebird20-server/pkg-plist
+++ b/databases/firebird20-server/pkg-plist
@@ -1,18 +1,17 @@
 @comment $FreeBSD$
+bin/fb_inet_server
+bin/fb_lock_mgr
 bin/fb_lock_print
 bin/gbak
 bin/gdef
+bin/gds_drop
 bin/gfix
 bin/gsec
 bin/gstat
+bin/nbackup
 libexec/firebird/intl/fbintl
-libexec/firebird/udf/fbudf.so
-libexec/firebird/udf/fbudf.sql
 libexec/firebird/udf/ib_udf.so
-libexec/firebird/udf/ib_udf.sql
-sbin/fb_inet_server
-sbin/fb_lock_mgr
-sbin/gds_drop
+libexec/firebird/udf/ib_udf2.sql
 @unexec (cmp -s %D/%%CONFDIR%%/aliases.conf %D/%%CONFDIR%%/aliases.conf.sample && rm -f %D/%%CONFDIR%%/aliases.conf) || true
 %%CONFDIR%%/aliases.conf.sample
 @exec [ -f %B/aliases.conf ] || cp %B/%f %B/aliases.conf
@@ -21,10 +20,9 @@ sbin/gds_drop
 @dirrm libexec/firebird/udf
 @dirrm libexec/firebird
 @cwd /
-@unexec (cmp -s %D/%%LOCALSTATEDIR%%/security.fdb %D/%%LOCALSTATEDIR%%/security.fdb.sample && rm -f %D/%%LOCALSTATEDIR%%/security.fdb) || true
-%%LOCALSTATEDIR%%/security.fdb.sample
-@exec [ -f %D/%%LOCALSTATEDIR%%/security.fdb ] || cp %D/%F %D/%%LOCALSTATEDIR%%/security.fdb
-%%LOCALSTATEDIR%%/RELNOTES
+@unexec (cmp -s %D/%%LOCALSTATEDIR%%/security2.fdb %D/%%LOCALSTATEDIR%%/security2.fdb.sample && rm -f %D/%%LOCALSTATEDIR%%/security2.fdb) || true
+%%LOCALSTATEDIR%%/security2.fdb.sample
+@exec [ -f %D/%%LOCALSTATEDIR%%/security2.fdb ] || cp %D/%F %D/%%LOCALSTATEDIR%%/security2.fdb
 %%LOCALSTATEDIR%%/help/help.fdb
 @unexec [ -s %D/%%LOCALSTATEDIR%%/firebird.log ] || rm -f %D/%%LOCALSTATEDIR%%/firebird.log
 @unexec rm -f %D/%%LOCALSTATEDIR%%/isc_event1.`hostname`
diff --git a/databases/firebird20-server/pkg-plist.client b/databases/firebird20-server/pkg-plist.client
index 8b61d85d22d4..71995b46b9f3 100644
--- a/databases/firebird20-server/pkg-plist.client
+++ b/databases/firebird20-server/pkg-plist.client
@@ -3,19 +3,18 @@ bin/gpre
 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.2
 lib/libfbclient.so.%%FIREBIRD_VERSION%%
 lib/libfbembed.so
-lib/libfbembed.so.1
+lib/libfbembed.so.2
 lib/libfbembed.so.%%FIREBIRD_VERSION%%
 lib/libgds.so
-lib/libgds.so.1
+lib/libgds.so.2
 lib/libib_util.so
 @unexec if cmp -s %D/%%CONFDIR%%/firebird.conf %D/%%CONFDIR%%/firebird.conf.sample; then rm -f %D/%%CONFDIR%%/firebird.conf; fi
 %%CONFDIR%%/firebird.conf.sample
@@ -24,53 +23,4 @@ lib/libib_util.so
 %%DATADIR%%/de_DE.msg
 %%DATADIR%%/firebird.msg
 %%DATADIR%%/fr_FR.msg
-%%DATADIR%%/ja_JP.msg
 @dirrm %%DATADIR%%
-%%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 %%EXAMPLESDIR%%
author	skv <skv@FreeBSD.org>	2006-09-18 23:20:04 +0800
committer	skv <skv@FreeBSD.org>	2006-09-18 23:20:04 +0800
commit	564178a4172be5efcd24281408bd2870970931da (patch)
tree	9f680c3a0e5ca1f70980f0d8ffb3516bb21ca9ce /databases
parent	024018f7ae0f0f2c7bac78542fc6bf86a817a000 (diff)
download	freebsd-ports-gnome-564178a4172be5efcd24281408bd2870970931da.tar.gz freebsd-ports-gnome-564178a4172be5efcd24281408bd2870970931da.tar.zst freebsd-ports-gnome-564178a4172be5efcd24281408bd2870970931da.zip