diff options
46 files changed, 1040 insertions, 2118 deletions
diff --git a/databases/Makefile b/databases/Makefile index 809c0c4d4b5e..d3292f675206 100644 --- a/databases/Makefile +++ b/databases/Makefile @@ -39,7 +39,8 @@ SUBDIR += erserver SUBDIR += evolution-data-server SUBDIR += fastdb - SUBDIR += firebird + SUBDIR += firebird-server + SUBDIR += firebird-client SUBDIR += firebird-devel SUBDIR += fireprofile SUBDIR += fpc-ibase diff --git a/databases/firebird-client/Makefile b/databases/firebird-client/Makefile index 37c91e1cdc08..8e3dbe715a05 100644 --- a/databases/firebird-client/Makefile +++ b/databases/firebird-client/Makefile @@ -1,82 +1,19 @@ -# New ports collection makefile for: Firebird -# Date created: 20 December 2000 -# Whom: Geoffrey C. Speicher <geoff@sea-incorporated.com> +# New ports collection makefile for: firebird-client +# Date created: 2005 Mar 03 +# Whom: Renato Botelho <renato@galle.com.br> # # $FreeBSD$ # PORTNAME= firebird -PORTVERSION= 1.5.2 -CATEGORIES= databases -MASTER_SITES= ${MASTER_SITE_SOURCEFORGE} -MASTER_SITE_SUBDIR=firebird -DISTNAME= firebird-1.5.2.4731 +PKGNAMESUFFIX= -client -MAINTAINER= freebsd@galle.com.br -COMMENT= The open-source InterBase(tm) 6.0 spin-off (Classic version) +COMMENT= The open-source InterBase(tm) 6.0 spin-off (client) -USE_BISON= yes -USE_BZIP2= yes -USE_GMAKE= yes -GNU_CONFIGURE= yes -USE_LIBTOOL_VER= 15 -USE_AUTOCONF_VER= 259 -USE_GCC= 3.4 +MASTERDIR= ${.CURDIR}/../firebird-server -PLIST_SUB= FIREBIRD_VERSION=${PORTVERSION} +PLIST= ${PKGDIR}/pkg-plist.client -# Don't use ld for linking, use gcc -LD= gcc +CLIENT_ONLY= yes -CONFLICTS= firebird-devel-[0-9]* - -WRKSRC= ${WRKDIR}/${DISTNAME} -INSTALLS_SHLIB= yes -LDCONFIG_DIRS= %%PREFIX%%/firebird/lib -MSG_FILE= ${PKGDIR}/pkg-message -PKGMESSAGE= ${WRKDIR}/pkg-message -USE_REINPLACE= yes - -ONLY_FOR_ARCHS= i386 - -.include <bsd.port.pre.mk> - -pre-everything:: - @${ECHO_MSG} "NOTE: If the work directory is on an NFS mount, you will" - @${ECHO_MSG} "require NFS client locking support for the build to" - @${ECHO_MSG} "succeed. Currently this is only available on FreeBSD 5.0" - @${ECHO_MSG} "or greater." - @${ECHO_MSG} - @${ECHO_MSG} "WARNING: The on-disk structure of the databases has" - @${ECHO_MSG} "changed since version 1.0.x." - @${ECHO_MSG} "Cancel this installation now and backup your databases" - @${ECHO_MSG} "if you have not already done so." -.if !defined(BATCH) - @sleep 10 -.endif - -patch-autotools: - @${DO_NADA} - -run-autotools: - @${DO_NADA} - -do-configure: - @(cd ${WRKSRC} && ${SETENV} CC=${CC} CXX=${CXX} MAKE=${GMAKE} \ - ${AUTOTOOLS_VARS} ./autogen.sh --prefix=${PREFIX}/firebird \ - --with-lock-manager --with-editline) - -do-build: - @( \ - ${SED} 's|%%PREFIX%%|${PREFIX}|g' ${MSG_FILE} > ${PKGMESSAGE}; \ - cd ${WRKSRC}; \ - ${SETENV} CC=${CC} CXX=${CXX} ${GMAKE} all; \ - ) - -post-install: - @( \ - ${INSTALL_DATA} ${FILESDIR}/RELNOTES ${PREFIX}/firebird; \ - ${CAT} ${PKGMESSAGE}; \ - ) - -.include <bsd.port.post.mk> +.include "${MASTERDIR}/Makefile" diff --git a/databases/firebird-client/distinfo b/databases/firebird-client/distinfo deleted file mode 100644 index 1f1dd8283c09..000000000000 --- a/databases/firebird-client/distinfo +++ /dev/null @@ -1,2 +0,0 @@ -MD5 (firebird-1.5.2.4731.tar.bz2) = fea53ed5213cff4bd96513fb1a6c0ca2 -SIZE (firebird-1.5.2.4731.tar.bz2) = 4764015 diff --git a/databases/firebird-client/files/RELNOTES b/databases/firebird-client/files/RELNOTES deleted file mode 100644 index 818320129f53..000000000000 --- a/databases/firebird-client/files/RELNOTES +++ /dev/null @@ -1,108 +0,0 @@ -Firebird 1.5.1 FreeBSD Release Notes 19-Jul-2004 --------------------------------------- -FB-V1.5.1.4481 Firebird 1.5 Release - - Welcome to the FreeBSD Firebird port! - - Firebird is installed SUID with owner and group `firebird'. -This does affect where you can and cannot create databases when -connecting remotely, as well as which existing databases you can -access. If you want a database to be available remotely, be sure -it's readable and writeable to group firebird. - - There may be times when you manage to get your system into a -state where using any of the Firebird utilites (isql, gbak, gsec, -etc.) gives you the message "semget failed". One surefire way to -do this is to build and install the port. :) If this happens, -make sure that the lock manager is not running and its semaphores -have been removed. The former can be accomplished with 'ps ax -|grep fb' and 'kill'; the latter with 'ipcs -s' and 'ipcrm -s'. - - For example, after building and installing the port, you will -probably go through something like this: - -# isql /usr/local/firebird/security.fdb -Statement failed, SQLCODE = -902 - -operating system directive semget failed --No such file or directory - -# ipcs -s -Semaphores: -T ID KEY MODE OWNER GROUP -s 1310720 252034728 --rw-rw-rw- root wheel - -# ipcrm -s 1310720 - -and you should be in business. - - Once this is done, you should be able to connect normally to -databases. Your first connection will restart the lock manager. - - There may be times, however, when you still get "semget failed" -even though the lock manager is not running and the semaphores have -been cleaned up. There seems to be a conflict with this release -and the PostgreSQL 7 release as installed from the ports collection. -If you're having trouble with Firebird and you're running PostgreSQL, -try stopping PostgreSQL: - - /usr/local/etc/rc.d/pgsql.sh stop - -and see if that helps. Alternatively, increase the value of SEMMNS -by 48 in your kernel configuration file. This can be found by getting -the current value with 'sysctl -a | grep semmns'. You can either add -this to your kernel config, or add the following line to /boot/loader.conf: - - kern.ipc.semmns=X - -where is is the current value plus 48. If this doesn't resolve the issue, -try adding 48 again. - - Please note that as of RC8, the libgds.so symlink now points to -libfbembed.so. This has been done to resolve compatability issues with -older versions of Firebird. The FreeBSD port of RC7 had libgds.so -pointing to libfbclient.so. libfbclient.so is a remote access-only -shared library with threaded support, which requires target applications -to link with a threaded library such as libc_r.so, libpthread.so or libthr.so. - - Super Server support in Firebird 1.5 for FreeBSD is not currently -available due to the Firebird code using POSIX threads APIs not available -in FreeBSD 4.x or not yet complete in FreeBSD 5.x. This issue will become -more important once the scalability issues of Super Server have been -resolved. - - This installation has already inserted the necessary line to -/etc/inetd.conf so that you can connect to Firebird across the network. -However you may need to add the remote host to /etc/hosts.equiv. For -example, to allow the local machine to make connections to Firebird -using TCP, the following command needs running: - - echo localhost >> /etc/hosts.equiv - -Please note that adding machines to /etc/hosts.equiv can reduce the -security of your system. If in doubt, try connecting to Firebird with -a username and password already defined in security.fdb. For example: - -gsec -> add myuser -pass mypass -> quit -isql -u myuser -p mypass localhost:/usr/local/firebird/examples/employee.fdb - -This should reduce the need for hosts defined in /etc/hosts.equiv. - - Complete documentation for InterBase(tm) is available (free of -charge) from http://www.interbase.com/ in PDF format. While -InterBase and Firebird are two distinct entities, all InterBase -documentation is pertinent to Firebird. More information on Firebird -and InterBase can be found at the following: - - http://sourceforge.net/projects/firebird/ - http://www.ibphoenix.com/ - http://www.interbase2000.org/ - http://www.firebirdsql.org/ - - Please also see the doc directory in the Firebird package for -documentation specific to Firebird. - -Chris Knight -<chris@e-easy.com.au> diff --git a/databases/firebird-client/files/patch-src::extern::editline::makelist b/databases/firebird-client/files/patch-src::extern::editline::makelist deleted file mode 100644 index 870f3cfdaece..000000000000 --- a/databases/firebird-client/files/patch-src::extern::editline::makelist +++ /dev/null @@ -1,11 +0,0 @@ ---- src/extern/editline/makelist.orig Mon May 24 04:24:25 2004 -+++ src/extern/editline/makelist Fri Jul 23 17:09:43 2004 -@@ -145,7 +145,7 @@ - # - -fh) - cat $FILES | $AWK '/el_action_t/ { print $3 }' | \ -- sort | tr '[a-z]' '[A-Z]' | $AWK ' -+ sort | tr '[:lower:]' '[:upper:]' | $AWK ' - BEGIN { - printf("/* Automatically generated file, do not edit */\n"); - printf("#ifndef _h_fcns_c\n#define _h_fcns_c\n"); diff --git a/databases/firebird-client/files/patch-src::install::arch-specific::freebsd::install.sh.in b/databases/firebird-client/files/patch-src::install::arch-specific::freebsd::install.sh.in deleted file mode 100644 index 03df0f2e369c..000000000000 --- a/databases/firebird-client/files/patch-src::install::arch-specific::freebsd::install.sh.in +++ /dev/null @@ -1,42 +0,0 @@ ---- src/install/arch-specific/freebsd/install.sh.in.orig Tue Apr 26 07:14:26 2005 -+++ src/install/arch-specific/freebsd/install.sh.in Tue Apr 26 07:15:05 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 -@@ -284,25 +277,6 @@ - [ -f aliases.conf ] || install -o $fbUID -g $fbGID -m 444 aliases.conf.sample aliases.conf - [ -f firebird.conf ] || install -o $fbUID -g $fbGID -m 444 firebird.conf.sample firebird.conf - [ -f security.fdb ] || install -o $fbUID -g $fbGID -m 660 security.fdb.sample security.fdb -- --# remove any existing gds service --cp /etc/services /etc/services.old --cp /etc/inetd.conf /etc/inetd.conf.old --cat /etc/services |grep -v gds_db >/etc/services.new --cat /etc/inetd.conf |grep -v gds_db >/etc/inetd.conf.new --mv /etc/services.new /etc/services --mv /etc/inetd.conf.new /etc/inetd.conf -- --# add the gds service and restart inetd --cat >>/etc/services <<EOF --gds_db 3050/tcp #InterBase Database Remote Protocol --EOF --cat >>/etc/inetd.conf <<EOF --gds_db stream tcp nowait firebird $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-client/pkg-descr b/databases/firebird-client/pkg-descr deleted file mode 100644 index dbeba43f543f..000000000000 --- a/databases/firebird-client/pkg-descr +++ /dev/null @@ -1,15 +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. - -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-client/pkg-install b/databases/firebird-client/pkg-install deleted file mode 100644 index e716ae8fa917..000000000000 --- a/databases/firebird-client/pkg-install +++ /dev/null @@ -1,145 +0,0 @@ -#!/bin/sh - -# $FreeBSD$ - -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.1 libgds.so.1 - -cd $PKG_PREFIX/firebird/bin -for i in `ls` -do - chmod ug=rx,o= $i -done - -chmod a=rx isql qli - -# SUID is needed for running server programs. -for i in fb_lock_mgr gds_drop fb_inet_server -do - if [ -f $i ]; then - chmod ug=rx,o= $i - chmod ug+s $i - fi -done - - -cd $PKG_PREFIX/firebird - -# Lock files - -for i in isc_init1 isc_lock1 isc_event1 -do - FileName=$i.`hostname` - touch $FileName - chmod uga=rw $FileName - chown firebird:firebird $FileName -done - -touch firebird.log -chown firebird:firebird firebird.log -chmod ug=rw,o= firebird.log -chmod a=r firebird.msg README -chown root:wheel *.sample -chmod ug=r,o= *.sample - -# make databases writable by firebird only -# local database connections are not a good idea -chmod ug=rw,o= examples/*.fdb -chmod ug=rw,o= help/*.fdb -chmod ug=rw,o= security.fdb - -chmod 444 aliases.conf firebird.conf -chmod 660 security.fdb - -# shared lib startup script -if [ -d $PKG_PREFIX/etc/rc.d ]; then - ( - echo "#!/bin/sh"; echo "[ -d $PKG_PREFIX/firebird/lib ] && /sbin/ldconfig -m $PKG_PREFIX/firebird/lib" - ) > $PKG_PREFIX/etc/rc.d/000.firebird.sh - chmod a=rx $PKG_PREFIX/etc/rc.d/000.firebird.sh -fi -;; - -esac diff --git a/databases/firebird-client/pkg-plist b/databases/firebird-client/pkg-plist deleted file mode 100644 index b6212232a3a4..000000000000 --- a/databases/firebird-client/pkg-plist +++ /dev/null @@ -1,130 +0,0 @@ -etc/rc.d/000.firebird.sh -firebird/README -firebird/RELNOTES -firebird/UDF/fbudf.so -firebird/UDF/fbudf.sql -firebird/UDF/ib_udf.so -firebird/UDF/ib_udf.sql -firebird/WhatsNew -@unexec if cmp -s %D/firebird/aliases.conf %D/firebird/aliases.conf.sample; then rm -f %D/firebird/aliases.conf; fi -firebird/aliases.conf.sample -@exec [ -f %B/aliases.conf ] || cp %B/%f %B/aliases.conf -firebird/bin/fb_inet_server -firebird/bin/fb_lock_mgr -firebird/bin/fb_lock_print -firebird/bin/gbak -firebird/bin/gdef -firebird/bin/gds_drop -firebird/bin/gfix -firebird/bin/gpre -firebird/bin/gsec -firebird/bin/gstat -firebird/bin/isql -firebird/bin/qli -firebird/doc/README.NTSecurity -firebird/doc/README.Win32LibraryInstallation.txt -firebird/doc/README.build.mingw.html -firebird/doc/README.build.msvc.html -firebird/doc/README.install.Solaris_on_Intel -firebird/doc/README.instsvc -firebird/doc/README.makefiles -firebird/doc/README.user -firebird/doc/README.user.embedded -firebird/doc/README.user.troubleshooting -firebird/doc/sql.extensions/README.aggregate_tracking -firebird/doc/sql.extensions/README.case -firebird/doc/sql.extensions/README.coalesce -firebird/doc/sql.extensions/README.context_variables -firebird/doc/sql.extensions/README.data_types -firebird/doc/sql.extensions/README.exception_handling -firebird/doc/sql.extensions/README.execute_statement -firebird/doc/sql.extensions/README.explicit_locks -firebird/doc/sql.extensions/README.nullif -firebird/doc/sql.extensions/README.order_by_expressions_nulls -firebird/doc/sql.extensions/README.savepoints -firebird/doc/sql.extensions/README.universal_triggers -firebird/examples/align.h -firebird/examples/api1.c -firebird/examples/api10.c -firebird/examples/api11.c -firebird/examples/api12.c -firebird/examples/api13.c -firebird/examples/api14.e -firebird/examples/api15.c -firebird/examples/api16.c -firebird/examples/api16t.c -firebird/examples/api2.c -firebird/examples/api3.c -firebird/examples/api4.c -firebird/examples/api5.c -firebird/examples/api6.c -firebird/examples/api7.c -firebird/examples/api8.c -firebird/examples/api9.c -firebird/examples/api9f.c -firebird/examples/api9f.sql -firebird/examples/apifull.c -firebird/examples/dyn1.e -firebird/examples/dyn2.e -firebird/examples/dyn3.e -firebird/examples/dyn4.e -firebird/examples/dyn5.e -firebird/examples/dynfull.e -firebird/examples/employe2.sql -firebird/examples/employee.fdb -firebird/examples/employee.gbk -firebird/examples/example.h -firebird/examples/readme -firebird/examples/stat1.e -firebird/examples/stat10.e -firebird/examples/stat11.e -firebird/examples/stat12.e -firebird/examples/stat12t.e -firebird/examples/stat2.e -firebird/examples/stat3.e -firebird/examples/stat4.e -firebird/examples/stat5.e -firebird/examples/stat6.e -firebird/examples/stat7.e -firebird/examples/stat8.e -firebird/examples/stat9.e -firebird/examples/udf.sql -firebird/examples/udflib.c -@unexec if cmp -s %D/firebird/firebird.conf %D/firebird/firebird.conf.sample; then rm -f %D/firebird/firebird.conf; fi -firebird/firebird.conf.sample -@exec [ -f %B/firebird.conf ] || cp %B/%f %B/firebird.conf -@unexec [ -s %D/firebird/firebird.log ] || rm -f %D/firebird/firebird.log -firebird/firebird.msg -firebird/help/help.fdb -firebird/include/blr.h -firebird/include/gds.h -firebird/include/ib_util.h -firebird/include/ibase.h -firebird/include/iberror.h -firebird/include/perf.h -firebird/intl/fbintl -@unexec rm -f %D/firebird/isc_event1.`hostname` -@unexec rm -f %D/firebird/isc_init1.`hostname` -@unexec rm -f %D/firebird/isc_lock1.`hostname` -firebird/lib/libfbclient.so -firebird/lib/libfbclient.so.1 -firebird/lib/libfbclient.so.%%FIREBIRD_VERSION%% -firebird/lib/libfbembed.so -firebird/lib/libfbembed.so.1 -firebird/lib/libfbembed.so.%%FIREBIRD_VERSION%% -firebird/lib/libgds.so -firebird/lib/libgds.so.1 -firebird/lib/libib_util.so -@unexec if cmp -s %D/firebird/security.fdb %D/firebird/security.fdb.sample; then rm -f %D/firebird/security.fdb; fi -firebird/security.fdb.sample -@exec [ -f %B/security.fdb ] || cp %B/%f %B/security.fdb -@dirrm firebird/UDF -@dirrm firebird/bin -@dirrm firebird/doc/sql.extensions -@dirrm firebird/doc -@dirrm firebird/examples -@dirrm firebird/help -@dirrm firebird/include -@dirrm firebird/intl -@dirrm firebird/lib -@dirrm firebird diff --git a/databases/firebird-server/Makefile b/databases/firebird-server/Makefile index 37c91e1cdc08..4519c1ce46ba 100644 --- a/databases/firebird-server/Makefile +++ b/databases/firebird-server/Makefile @@ -5,16 +5,18 @@ # $FreeBSD$ # -PORTNAME= firebird +PORTNAME?= firebird PORTVERSION= 1.5.2 -CATEGORIES= databases +CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_SOURCEFORGE} MASTER_SITE_SUBDIR=firebird +PKGNAMESUFFIX?= -server DISTNAME= firebird-1.5.2.4731 -MAINTAINER= freebsd@galle.com.br -COMMENT= The open-source InterBase(tm) 6.0 spin-off (Classic version) +MAINTAINER= renato@galle.com.br +COMMENT?= The open-source InterBase(tm) 6.0 spin-off (Classic version) +USE_REINPLACE= yes USE_BISON= yes USE_BZIP2= yes USE_GMAKE= yes @@ -28,19 +30,48 @@ PLIST_SUB= FIREBIRD_VERSION=${PORTVERSION} # Don't use ld for linking, use gcc LD= gcc -CONFLICTS= firebird-devel-[0-9]* +# Don't strip binary files +STRIP= + +ONLY_FOR_ARCHS= i386 WRKSRC= ${WRKDIR}/${DISTNAME} -INSTALLS_SHLIB= yes -LDCONFIG_DIRS= %%PREFIX%%/firebird/lib -MSG_FILE= ${PKGDIR}/pkg-message + +.if !defined(CLIENT_ONLY) +# Server part stuff +LIB_DEPENDS+= fbembed.1:${PORTSDIR}/databases/firebird-client + +AUTOGENARGS= --prefix=${PREFIX}/firebird \ + --with-lock-manager + +ALL_TARGET= firebird_boot ref_databases msgs intl otherfiles \ + inet_server extlib + +# Use own user and group when install server part +BINOWN= firebird +BINGRP= firebird +BINMODE= 550 +SHAREOWN= firebird +SHAREGRP= firebird + PKGMESSAGE= ${WRKDIR}/pkg-message -USE_REINPLACE= yes +PKGINSTALL= ${WRKDIR}/pkg-install -ONLY_FOR_ARCHS= i386 +CONFLICTS= firebird-devel-[0-9]* +.else +# Client part stuff +AUTOGENARGS= --prefix=${PREFIX} \ + --with-editline + +ALL_TARGET= firebird_basic libfbembed embed_gfix embed_gbak embed_isql embed_gpre \ + embed_util embed_gdef embed_qli libfbclient extlib + +INSTALLS_SHLIB= yes +.endif .include <bsd.port.pre.mk> +.if !defined(CLIENT_ONLY) pre-everything:: @${ECHO_MSG} "NOTE: If the work directory is on an NFS mount, you will" @${ECHO_MSG} "require NFS client locking support for the build to" @@ -55,6 +86,33 @@ pre-everything:: @sleep 10 .endif +post-patch: + @${REINPLACE_CMD} -e 's|^\(LINK_OPTS +=.*\)$$|\1 -L${LOCALBASE}/lib|' \ + ${WRKSRC}/builds/posix/Makefile.in.inet_server + +post-build: + ${SED} 's|%%PREFIX%%|${PREFIX}|g' \ + < ${FILESDIR}/pkg-message.in \ + > ${PKGMESSAGE} + + ${SED} -e 's|%%PREFIX%%|${PREFIX}/firebird|g' \ + < ${FILESDIR}/pkg-install.in \ + > ${PKGINSTALL} + + ${SED} -e "s|%%PREFIX%%|${PREFIX}/firebird|g" \ + < ${FILESDIR}/aliases.conf.in \ + > ${WRKDIR}/aliases.conf + +pre-install: + ${SETENV} PKG_PREFIX="${PREFIX}" PKG_DESTDIR="${DESTDIR}" ${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL + +post-install: + ${SETENV} PKG_PREFIX="${PREFIX}" PKG_DESTDIR="${DESTDIR}" ${SH} ${PKGINSTALL} ${PORTNAME} POST-INSTALL + @${ECHO_MSG} + @${CAT} ${PKGMESSAGE} + @${ECHO_MSG} +.endif + patch-autotools: @${DO_NADA} @@ -63,20 +121,81 @@ run-autotools: do-configure: @(cd ${WRKSRC} && ${SETENV} CC=${CC} CXX=${CXX} MAKE=${GMAKE} \ - ${AUTOTOOLS_VARS} ./autogen.sh --prefix=${PREFIX}/firebird \ - --with-lock-manager --with-editline) + ${AUTOTOOLS_VARS} ./autogen.sh ${AUTOGENARGS}) -do-build: - @( \ - ${SED} 's|%%PREFIX%%|${PREFIX}|g' ${MSG_FILE} > ${PKGMESSAGE}; \ - cd ${WRKSRC}; \ - ${SETENV} CC=${CC} CXX=${CXX} ${GMAKE} all; \ - ) +post-configure: + @${REINPLACE_CMD} -e 's|__attribute__ ((__unused__));||' \ + ${WRKSRC}/src/dsql/parse.cpp -post-install: - @( \ - ${INSTALL_DATA} ${FILESDIR}/RELNOTES ${PREFIX}/firebird; \ - ${CAT} ${PKGMESSAGE}; \ - ) +do-install: +.if !defined(CLIENT_ONLY) + + ${MKDIR} ${PREFIX}/firebird + ${CHOWN} ${BINOWN}:${BINGRP} ${PREFIX}/firebird + +.for f in UDF bin help intl + ${MKDIR} ${PREFIX}/firebird/${f} + ${CHOWN} ${BINOWN}:${BINGRP} ${PREFIX}/firebird/${f} +.endfor + + ${INSTALL_DATA} ${WRKDIR}/aliases.conf ${PREFIX}/firebird/aliases.conf.sample + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/misc/firebird.conf ${PREFIX}/firebird/firebird.conf.sample + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/security.fdb ${PREFIX}/firebird/security.fdb.sample + ${CHMOD} 660 ${PREFIX}/firebird/security.fdb.sample + + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/firebird.msg ${PREFIX}/firebird/firebird.msg + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/help/help.fdb ${PREFIX}/firebird/help + +.for f in ib_udf.so fbudf.so + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/UDF/${f} ${PREFIX}/firebird/UDF +.endfor + +.for f in src/extlib/ib_udf.sql src/extlib/fbudf/fbudf.sql + ${INSTALL_SCRIPT} ${WRKSRC}/${f} ${PREFIX}/firebird/UDF +.endfor + +.for f in fb_inet_server fb_lock_mgr + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/bin/${f} ${PREFIX}/firebird/bin + ${CHMOD} u+s ${PREFIX}/firebird/bin/${f} +.endfor + + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/intl/libfbintl.so ${PREFIX}/firebird/intl/fbintl + + ${INSTALL_DATA} ${FILESDIR}/RELNOTES ${PREFIX}/firebird + +.else + +.for dir in include share/doc/firebird \ + share/doc/firebird/sql.extensions share/examples/firebird + ${MKDIR} ${PREFIX}/${dir} +.endfor + +.for f in fb_lock_print gbak gdef gds_drop gfix gpre gsec gstat isql qli + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/bin/${f} ${PREFIX}/bin +.endfor + + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libfbclient.so.${PORTVERSION} ${PREFIX}/lib + ${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libfbclient.so.1 + ${LN} -fs libfbclient.so.1 ${PREFIX}/lib/libfbclient.so + + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libfbembed.so.${PORTVERSION} ${PREFIX}/lib + ${LN} -fs libfbembed.so.${PORTVERSION} ${PREFIX}/lib/libfbembed.so.1 + ${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libfbembed.so + + ${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libgds.so.1 + ${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libgds.so + + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libib_util.so ${PREFIX}/lib + + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/include/*.h ${PREFIX}/include + + ${INSTALL_DATA} ${WRKSRC}/doc/WhatsNew ${PREFIX}/share/doc/firebird + ${INSTALL_DATA} ${WRKSRC}/doc/README.* ${PREFIX}/share/doc/firebird + ${INSTALL_DATA} ${WRKSRC}/doc/README.user ${PREFIX}/share/doc/firebird/README + ${INSTALL_DATA} ${WRKSRC}/doc/sql.extensions/README.* ${PREFIX}/share/doc/firebird/sql.extensions + + # Install examples + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/examples/v5/* ${PREFIX}/share/examples/firebird +.endif .include <bsd.port.post.mk> diff --git a/databases/firebird-server/files/aliases.conf.in b/databases/firebird-server/files/aliases.conf.in new file mode 100644 index 000000000000..05a28980b909 --- /dev/null +++ b/databases/firebird-server/files/aliases.conf.in @@ -0,0 +1,8 @@ +# +# List of known database aliases +# ------------------------------ +# +# Examples: +# +# employee = %%PREFIX%%/examples/employee.fdb +# diff --git a/databases/firebird-server/files/patch-builds::posix::Makefile.in.inet_server b/databases/firebird-server/files/patch-builds::posix::Makefile.in.inet_server new file mode 100644 index 000000000000..8dcddef34a6a --- /dev/null +++ b/databases/firebird-server/files/patch-builds::posix::Makefile.in.inet_server @@ -0,0 +1,20 @@ +--- builds/posix/Makefile.in.inet_server.orig Fri Sep 17 20:34:21 2004 ++++ builds/posix/Makefile.in.inet_server Wed Mar 2 16:09:41 2005 +@@ -39,6 +39,8 @@ + + @SET_MAKE@ + ++LINK_OPTS += ++ + SERVER_Files = server_stub.cpp + SERVER_Sources = $(addprefix remote/, $(SERVER_Files)) + SERVER_Objects = $(addprefix $(OBJ)/, $(addsuffix .o, $(basename $(SERVER_Sources)))) +@@ -51,7 +53,7 @@ + + # SD: We don't need to rebuild fb_inet_server every time libfbembed.so changed, + # but we must ensure it's existance +-fb_inet_server : $(LIBFBEMBED_SO) $(FB_CLASSIC_SERVER) ++fb_inet_server : $(FB_CLASSIC_SERVER) + + $(FB_CLASSIC_SERVER): $(SERVER_Objects) + $(LD) $(LINK_OPTS) $^ -o $@ $(FBEMBED_LINK) $(LIB_GUI) $(LINK_LIBS) diff --git a/databases/firebird-server/files/patch-src::install::arch-specific::freebsd::install.sh.in b/databases/firebird-server/files/patch-src::install::arch-specific::freebsd::install.sh.in deleted file mode 100644 index 03df0f2e369c..000000000000 --- a/databases/firebird-server/files/patch-src::install::arch-specific::freebsd::install.sh.in +++ /dev/null @@ -1,42 +0,0 @@ ---- src/install/arch-specific/freebsd/install.sh.in.orig Tue Apr 26 07:14:26 2005 -+++ src/install/arch-specific/freebsd/install.sh.in Tue Apr 26 07:15:05 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 -@@ -284,25 +277,6 @@ - [ -f aliases.conf ] || install -o $fbUID -g $fbGID -m 444 aliases.conf.sample aliases.conf - [ -f firebird.conf ] || install -o $fbUID -g $fbGID -m 444 firebird.conf.sample firebird.conf - [ -f security.fdb ] || install -o $fbUID -g $fbGID -m 660 security.fdb.sample security.fdb -- --# remove any existing gds service --cp /etc/services /etc/services.old --cp /etc/inetd.conf /etc/inetd.conf.old --cat /etc/services |grep -v gds_db >/etc/services.new --cat /etc/inetd.conf |grep -v gds_db >/etc/inetd.conf.new --mv /etc/services.new /etc/services --mv /etc/inetd.conf.new /etc/inetd.conf -- --# add the gds service and restart inetd --cat >>/etc/services <<EOF --gds_db 3050/tcp #InterBase Database Remote Protocol --EOF --cat >>/etc/inetd.conf <<EOF --gds_db stream tcp nowait firebird $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-server/files/pkg-install.in b/databases/firebird-server/files/pkg-install.in new file mode 100644 index 000000000000..d442ff99ee3f --- /dev/null +++ b/databases/firebird-server/files/pkg-install.in @@ -0,0 +1,70 @@ +#!/bin/sh + +PATH=/sbin:/usr/sbin:/usr/local/sbin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin:%%PREFIX%%/bin +PREFIX=%%PREFIX%% +DB_DIR=%%PREFIX%% + +USER=firebird +GROUP=${USER} +UID=3050 +GID=${UID} +HOME=${DB_DIR} +DESCR="Firebird Database Administrator" + +case $2 in +PRE-INSTALL) + if pw group show "${GROUP}" 2> /dev/null; then + echo "You already have a group \"${GROUP}\", so I will use it." + else + if pw groupadd ${GROUP} -g ${GID}; then + echo "Added group \"${GROUP}\"." + else + echo "Adding group \"${GROUP}\" failed..." + exit 1 + fi + fi + + if pw user show "${USER}" 2> /dev/null; then + echo "You already have a user \"${USER}\", so I will use it." + + if pw usermod ${USER} -d ${HOME}; then + echo "Changed home directory of \"${USER}\" to \"${HOME}\"" + else + echo "Changing home directory of \"${USER}\" to \"${HOME}\" failed..." + exit 1 + fi + else + if pw useradd ${USER} -u ${UID} -g ${GROUP} -h - -d ${NOME} -s /sbin/nologin -c "${DESCR}" ; then + echo "Added user \"${USER}\"." + else + echo "Adding user \"${USER}\" failed..." + exit 1 + fi + fi + ;; + +POST-INSTALL) + for f in isc_init1.`hostname` isc_lock1.`hostname` isc_event1.`hostname` firebird.log + do + touch ${PREFIX}/${f} + chown ${USER}:${GROUP} ${PREFIX}/$f + chmod 660 ${PREFIX}/${f} + done + + # add the gds service and restart inetd + cat /etc/services | grep -v gds_db > /etc/services.new + cat >>/etc/services.new <<EOF +gds_db 3050/tcp #InterBase Database Remote Protocol +EOF + mv /etc/services.new /etc/services + + cat /etc/inetd.conf | grep -v gds_db > /etc/inetd.conf.new + cat >>/etc/inetd.conf.new <<EOF +gds_db stream tcp nowait firebird ${PREFIX}/bin/fb_inet_server fb_inet_server +EOF + mv /etc/inetd.conf.new /etc/inetd.conf + + if [ -f /var/run/inetd.pid ]; then + kill -HUP `cat /var/run/inetd.pid` + fi +esac diff --git a/databases/firebird/pkg-message b/databases/firebird-server/files/pkg-message.in index 02894da409f2..2cab9049eba5 100644 --- a/databases/firebird/pkg-message +++ b/databases/firebird-server/files/pkg-message.in @@ -1,20 +1,8 @@ - --------------------------------------------------------- -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. +Firebird is now installed. A symbolic link from +/usr/interbase -> %%PREFIX%%/firebird may be needed +for compatibility with existing programs that use +Firebird. The symbolic link can be created with: @@ -32,4 +20,3 @@ before doing anything serious with Firebird. See %%PREFIX%%/firebird/RELNOTES for more. --------------------------------------------------------- - diff --git a/databases/firebird-server/pkg-install b/databases/firebird-server/pkg-install deleted file mode 100644 index e716ae8fa917..000000000000 --- a/databases/firebird-server/pkg-install +++ /dev/null @@ -1,145 +0,0 @@ -#!/bin/sh - -# $FreeBSD$ - -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.1 libgds.so.1 - -cd $PKG_PREFIX/firebird/bin -for i in `ls` -do - chmod ug=rx,o= $i -done - -chmod a=rx isql qli - -# SUID is needed for running server programs. -for i in fb_lock_mgr gds_drop fb_inet_server -do - if [ -f $i ]; then - chmod ug=rx,o= $i - chmod ug+s $i - fi -done - - -cd $PKG_PREFIX/firebird - -# Lock files - -for i in isc_init1 isc_lock1 isc_event1 -do - FileName=$i.`hostname` - touch $FileName - chmod uga=rw $FileName - chown firebird:firebird $FileName -done - -touch firebird.log -chown firebird:firebird firebird.log -chmod ug=rw,o= firebird.log -chmod a=r firebird.msg README -chown root:wheel *.sample -chmod ug=r,o= *.sample - -# make databases writable by firebird only -# local database connections are not a good idea -chmod ug=rw,o= examples/*.fdb -chmod ug=rw,o= help/*.fdb -chmod ug=rw,o= security.fdb - -chmod 444 aliases.conf firebird.conf -chmod 660 security.fdb - -# shared lib startup script -if [ -d $PKG_PREFIX/etc/rc.d ]; then - ( - echo "#!/bin/sh"; echo "[ -d $PKG_PREFIX/firebird/lib ] && /sbin/ldconfig -m $PKG_PREFIX/firebird/lib" - ) > $PKG_PREFIX/etc/rc.d/000.firebird.sh - chmod a=rx $PKG_PREFIX/etc/rc.d/000.firebird.sh -fi -;; - -esac diff --git a/databases/firebird-server/pkg-plist b/databases/firebird-server/pkg-plist index b6212232a3a4..43e32f04ced0 100644 --- a/databases/firebird-server/pkg-plist +++ b/databases/firebird-server/pkg-plist @@ -1,130 +1,28 @@ -etc/rc.d/000.firebird.sh -firebird/README firebird/RELNOTES firebird/UDF/fbudf.so firebird/UDF/fbudf.sql firebird/UDF/ib_udf.so firebird/UDF/ib_udf.sql -firebird/WhatsNew @unexec if cmp -s %D/firebird/aliases.conf %D/firebird/aliases.conf.sample; then rm -f %D/firebird/aliases.conf; fi firebird/aliases.conf.sample @exec [ -f %B/aliases.conf ] || cp %B/%f %B/aliases.conf firebird/bin/fb_inet_server firebird/bin/fb_lock_mgr -firebird/bin/fb_lock_print -firebird/bin/gbak -firebird/bin/gdef -firebird/bin/gds_drop -firebird/bin/gfix -firebird/bin/gpre -firebird/bin/gsec -firebird/bin/gstat -firebird/bin/isql -firebird/bin/qli -firebird/doc/README.NTSecurity -firebird/doc/README.Win32LibraryInstallation.txt -firebird/doc/README.build.mingw.html -firebird/doc/README.build.msvc.html -firebird/doc/README.install.Solaris_on_Intel -firebird/doc/README.instsvc -firebird/doc/README.makefiles -firebird/doc/README.user -firebird/doc/README.user.embedded -firebird/doc/README.user.troubleshooting -firebird/doc/sql.extensions/README.aggregate_tracking -firebird/doc/sql.extensions/README.case -firebird/doc/sql.extensions/README.coalesce -firebird/doc/sql.extensions/README.context_variables -firebird/doc/sql.extensions/README.data_types -firebird/doc/sql.extensions/README.exception_handling -firebird/doc/sql.extensions/README.execute_statement -firebird/doc/sql.extensions/README.explicit_locks -firebird/doc/sql.extensions/README.nullif -firebird/doc/sql.extensions/README.order_by_expressions_nulls -firebird/doc/sql.extensions/README.savepoints -firebird/doc/sql.extensions/README.universal_triggers -firebird/examples/align.h -firebird/examples/api1.c -firebird/examples/api10.c -firebird/examples/api11.c -firebird/examples/api12.c -firebird/examples/api13.c -firebird/examples/api14.e -firebird/examples/api15.c -firebird/examples/api16.c -firebird/examples/api16t.c -firebird/examples/api2.c -firebird/examples/api3.c -firebird/examples/api4.c -firebird/examples/api5.c -firebird/examples/api6.c -firebird/examples/api7.c -firebird/examples/api8.c -firebird/examples/api9.c -firebird/examples/api9f.c -firebird/examples/api9f.sql -firebird/examples/apifull.c -firebird/examples/dyn1.e -firebird/examples/dyn2.e -firebird/examples/dyn3.e -firebird/examples/dyn4.e -firebird/examples/dyn5.e -firebird/examples/dynfull.e -firebird/examples/employe2.sql -firebird/examples/employee.fdb -firebird/examples/employee.gbk -firebird/examples/example.h -firebird/examples/readme -firebird/examples/stat1.e -firebird/examples/stat10.e -firebird/examples/stat11.e -firebird/examples/stat12.e -firebird/examples/stat12t.e -firebird/examples/stat2.e -firebird/examples/stat3.e -firebird/examples/stat4.e -firebird/examples/stat5.e -firebird/examples/stat6.e -firebird/examples/stat7.e -firebird/examples/stat8.e -firebird/examples/stat9.e -firebird/examples/udf.sql -firebird/examples/udflib.c @unexec if cmp -s %D/firebird/firebird.conf %D/firebird/firebird.conf.sample; then rm -f %D/firebird/firebird.conf; fi firebird/firebird.conf.sample @exec [ -f %B/firebird.conf ] || cp %B/%f %B/firebird.conf @unexec [ -s %D/firebird/firebird.log ] || rm -f %D/firebird/firebird.log firebird/firebird.msg firebird/help/help.fdb -firebird/include/blr.h -firebird/include/gds.h -firebird/include/ib_util.h -firebird/include/ibase.h -firebird/include/iberror.h -firebird/include/perf.h firebird/intl/fbintl @unexec rm -f %D/firebird/isc_event1.`hostname` @unexec rm -f %D/firebird/isc_init1.`hostname` @unexec rm -f %D/firebird/isc_lock1.`hostname` -firebird/lib/libfbclient.so -firebird/lib/libfbclient.so.1 -firebird/lib/libfbclient.so.%%FIREBIRD_VERSION%% -firebird/lib/libfbembed.so -firebird/lib/libfbembed.so.1 -firebird/lib/libfbembed.so.%%FIREBIRD_VERSION%% -firebird/lib/libgds.so -firebird/lib/libgds.so.1 -firebird/lib/libib_util.so @unexec if cmp -s %D/firebird/security.fdb %D/firebird/security.fdb.sample; then rm -f %D/firebird/security.fdb; fi firebird/security.fdb.sample @exec [ -f %B/security.fdb ] || cp %B/%f %B/security.fdb @dirrm firebird/UDF @dirrm firebird/bin -@dirrm firebird/doc/sql.extensions -@dirrm firebird/doc -@dirrm firebird/examples @dirrm firebird/help -@dirrm firebird/include @dirrm firebird/intl -@dirrm firebird/lib @dirrm firebird diff --git a/databases/firebird-server/pkg-plist.client b/databases/firebird-server/pkg-plist.client new file mode 100644 index 000000000000..3f302be5fd42 --- /dev/null +++ b/databases/firebird-server/pkg-plist.client @@ -0,0 +1,99 @@ +bin/fb_lock_print +bin/gbak +bin/gdef +bin/gds_drop +bin/gfix +bin/gpre +bin/gsec +bin/gstat +bin/isql +bin/qli +include/blr.h +include/gds.h +include/ib_util.h +include/ibase.h +include/iberror.h +include/perf.h +lib/libfbclient.so +lib/libfbclient.so.1 +lib/libfbclient.so.%%FIREBIRD_VERSION%% +lib/libfbembed.so +lib/libfbembed.so.1 +lib/libfbembed.so.%%FIREBIRD_VERSION%% +lib/libgds.so +lib/libgds.so.1 +lib/libib_util.so +%%DOCSDIR%%/README.NTSecurity +%%DOCSDIR%%/README.Win32LibraryInstallation.txt +%%DOCSDIR%%/README.build.mingw.html +%%DOCSDIR%%/README.build.msvc.html +%%DOCSDIR%%/README.install.Solaris_on_Intel +%%DOCSDIR%%/README.instsvc +%%DOCSDIR%%/README.makefiles +%%DOCSDIR%%/README.user +%%DOCSDIR%%/README.user.embedded +%%DOCSDIR%%/README.user.troubleshooting +%%DOCSDIR%%/README +%%DOCSDIR%%/WhatsNew +%%DOCSDIR%%/sql.extensions/README.aggregate_tracking +%%DOCSDIR%%/sql.extensions/README.case +%%DOCSDIR%%/sql.extensions/README.coalesce +%%DOCSDIR%%/sql.extensions/README.context_variables +%%DOCSDIR%%/sql.extensions/README.data_types +%%DOCSDIR%%/sql.extensions/README.exception_handling +%%DOCSDIR%%/sql.extensions/README.execute_statement +%%DOCSDIR%%/sql.extensions/README.explicit_locks +%%DOCSDIR%%/sql.extensions/README.nullif +%%DOCSDIR%%/sql.extensions/README.order_by_expressions_nulls +%%DOCSDIR%%/sql.extensions/README.savepoints +%%DOCSDIR%%/sql.extensions/README.universal_triggers +%%EXAMPLESDIR%%/align.h +%%EXAMPLESDIR%%/api1.c +%%EXAMPLESDIR%%/api10.c +%%EXAMPLESDIR%%/api11.c +%%EXAMPLESDIR%%/api12.c +%%EXAMPLESDIR%%/api13.c +%%EXAMPLESDIR%%/api14.e +%%EXAMPLESDIR%%/api15.c +%%EXAMPLESDIR%%/api16.c +%%EXAMPLESDIR%%/api16t.c +%%EXAMPLESDIR%%/api2.c +%%EXAMPLESDIR%%/api3.c +%%EXAMPLESDIR%%/api4.c +%%EXAMPLESDIR%%/api5.c +%%EXAMPLESDIR%%/api6.c +%%EXAMPLESDIR%%/api7.c +%%EXAMPLESDIR%%/api8.c +%%EXAMPLESDIR%%/api9.c +%%EXAMPLESDIR%%/api9f.c +%%EXAMPLESDIR%%/api9f.sql +%%EXAMPLESDIR%%/apifull.c +%%EXAMPLESDIR%%/dyn1.e +%%EXAMPLESDIR%%/dyn2.e +%%EXAMPLESDIR%%/dyn3.e +%%EXAMPLESDIR%%/dyn4.e +%%EXAMPLESDIR%%/dyn5.e +%%EXAMPLESDIR%%/dynfull.e +%%EXAMPLESDIR%%/employe2.sql +%%EXAMPLESDIR%%/employee.fdb +%%EXAMPLESDIR%%/employee.gbk +%%EXAMPLESDIR%%/example.h +%%EXAMPLESDIR%%/readme +%%EXAMPLESDIR%%/stat1.e +%%EXAMPLESDIR%%/stat10.e +%%EXAMPLESDIR%%/stat11.e +%%EXAMPLESDIR%%/stat12.e +%%EXAMPLESDIR%%/stat12t.e +%%EXAMPLESDIR%%/stat2.e +%%EXAMPLESDIR%%/stat3.e +%%EXAMPLESDIR%%/stat4.e +%%EXAMPLESDIR%%/stat5.e +%%EXAMPLESDIR%%/stat6.e +%%EXAMPLESDIR%%/stat7.e +%%EXAMPLESDIR%%/stat8.e +%%EXAMPLESDIR%%/stat9.e +%%EXAMPLESDIR%%/udf.sql +%%EXAMPLESDIR%%/udflib.c +@dirrm %%DOCSDIR%%/sql.extensions +@dirrm %%DOCSDIR%% +@dirrm %%EXAMPLESDIR%% diff --git a/databases/firebird/Makefile b/databases/firebird/Makefile deleted file mode 100644 index 37c91e1cdc08..000000000000 --- a/databases/firebird/Makefile +++ /dev/null @@ -1,82 +0,0 @@ -# New ports collection makefile for: Firebird -# Date created: 20 December 2000 -# Whom: Geoffrey C. Speicher <geoff@sea-incorporated.com> -# -# $FreeBSD$ -# - -PORTNAME= firebird -PORTVERSION= 1.5.2 -CATEGORIES= databases -MASTER_SITES= ${MASTER_SITE_SOURCEFORGE} -MASTER_SITE_SUBDIR=firebird -DISTNAME= firebird-1.5.2.4731 - -MAINTAINER= freebsd@galle.com.br -COMMENT= The open-source InterBase(tm) 6.0 spin-off (Classic version) - -USE_BISON= yes -USE_BZIP2= yes -USE_GMAKE= yes -GNU_CONFIGURE= yes -USE_LIBTOOL_VER= 15 -USE_AUTOCONF_VER= 259 -USE_GCC= 3.4 - -PLIST_SUB= FIREBIRD_VERSION=${PORTVERSION} - -# Don't use ld for linking, use gcc -LD= gcc - -CONFLICTS= firebird-devel-[0-9]* - -WRKSRC= ${WRKDIR}/${DISTNAME} -INSTALLS_SHLIB= yes -LDCONFIG_DIRS= %%PREFIX%%/firebird/lib -MSG_FILE= ${PKGDIR}/pkg-message -PKGMESSAGE= ${WRKDIR}/pkg-message -USE_REINPLACE= yes - -ONLY_FOR_ARCHS= i386 - -.include <bsd.port.pre.mk> - -pre-everything:: - @${ECHO_MSG} "NOTE: If the work directory is on an NFS mount, you will" - @${ECHO_MSG} "require NFS client locking support for the build to" - @${ECHO_MSG} "succeed. Currently this is only available on FreeBSD 5.0" - @${ECHO_MSG} "or greater." - @${ECHO_MSG} - @${ECHO_MSG} "WARNING: The on-disk structure of the databases has" - @${ECHO_MSG} "changed since version 1.0.x." - @${ECHO_MSG} "Cancel this installation now and backup your databases" - @${ECHO_MSG} "if you have not already done so." -.if !defined(BATCH) - @sleep 10 -.endif - -patch-autotools: - @${DO_NADA} - -run-autotools: - @${DO_NADA} - -do-configure: - @(cd ${WRKSRC} && ${SETENV} CC=${CC} CXX=${CXX} MAKE=${GMAKE} \ - ${AUTOTOOLS_VARS} ./autogen.sh --prefix=${PREFIX}/firebird \ - --with-lock-manager --with-editline) - -do-build: - @( \ - ${SED} 's|%%PREFIX%%|${PREFIX}|g' ${MSG_FILE} > ${PKGMESSAGE}; \ - cd ${WRKSRC}; \ - ${SETENV} CC=${CC} CXX=${CXX} ${GMAKE} all; \ - ) - -post-install: - @( \ - ${INSTALL_DATA} ${FILESDIR}/RELNOTES ${PREFIX}/firebird; \ - ${CAT} ${PKGMESSAGE}; \ - ) - -.include <bsd.port.post.mk> diff --git a/databases/firebird/distinfo b/databases/firebird/distinfo deleted file mode 100644 index 1f1dd8283c09..000000000000 --- a/databases/firebird/distinfo +++ /dev/null @@ -1,2 +0,0 @@ -MD5 (firebird-1.5.2.4731.tar.bz2) = fea53ed5213cff4bd96513fb1a6c0ca2 -SIZE (firebird-1.5.2.4731.tar.bz2) = 4764015 diff --git a/databases/firebird/files/RELNOTES b/databases/firebird/files/RELNOTES deleted file mode 100644 index 818320129f53..000000000000 --- a/databases/firebird/files/RELNOTES +++ /dev/null @@ -1,108 +0,0 @@ -Firebird 1.5.1 FreeBSD Release Notes 19-Jul-2004 --------------------------------------- -FB-V1.5.1.4481 Firebird 1.5 Release - - Welcome to the FreeBSD Firebird port! - - Firebird is installed SUID with owner and group `firebird'. -This does affect where you can and cannot create databases when -connecting remotely, as well as which existing databases you can -access. If you want a database to be available remotely, be sure -it's readable and writeable to group firebird. - - There may be times when you manage to get your system into a -state where using any of the Firebird utilites (isql, gbak, gsec, -etc.) gives you the message "semget failed". One surefire way to -do this is to build and install the port. :) If this happens, -make sure that the lock manager is not running and its semaphores -have been removed. The former can be accomplished with 'ps ax -|grep fb' and 'kill'; the latter with 'ipcs -s' and 'ipcrm -s'. - - For example, after building and installing the port, you will -probably go through something like this: - -# isql /usr/local/firebird/security.fdb -Statement failed, SQLCODE = -902 - -operating system directive semget failed --No such file or directory - -# ipcs -s -Semaphores: -T ID KEY MODE OWNER GROUP -s 1310720 252034728 --rw-rw-rw- root wheel - -# ipcrm -s 1310720 - -and you should be in business. - - Once this is done, you should be able to connect normally to -databases. Your first connection will restart the lock manager. - - There may be times, however, when you still get "semget failed" -even though the lock manager is not running and the semaphores have -been cleaned up. There seems to be a conflict with this release -and the PostgreSQL 7 release as installed from the ports collection. -If you're having trouble with Firebird and you're running PostgreSQL, -try stopping PostgreSQL: - - /usr/local/etc/rc.d/pgsql.sh stop - -and see if that helps. Alternatively, increase the value of SEMMNS -by 48 in your kernel configuration file. This can be found by getting -the current value with 'sysctl -a | grep semmns'. You can either add -this to your kernel config, or add the following line to /boot/loader.conf: - - kern.ipc.semmns=X - -where is is the current value plus 48. If this doesn't resolve the issue, -try adding 48 again. - - Please note that as of RC8, the libgds.so symlink now points to -libfbembed.so. This has been done to resolve compatability issues with -older versions of Firebird. The FreeBSD port of RC7 had libgds.so -pointing to libfbclient.so. libfbclient.so is a remote access-only -shared library with threaded support, which requires target applications -to link with a threaded library such as libc_r.so, libpthread.so or libthr.so. - - Super Server support in Firebird 1.5 for FreeBSD is not currently -available due to the Firebird code using POSIX threads APIs not available -in FreeBSD 4.x or not yet complete in FreeBSD 5.x. This issue will become -more important once the scalability issues of Super Server have been -resolved. - - This installation has already inserted the necessary line to -/etc/inetd.conf so that you can connect to Firebird across the network. -However you may need to add the remote host to /etc/hosts.equiv. For -example, to allow the local machine to make connections to Firebird -using TCP, the following command needs running: - - echo localhost >> /etc/hosts.equiv - -Please note that adding machines to /etc/hosts.equiv can reduce the -security of your system. If in doubt, try connecting to Firebird with -a username and password already defined in security.fdb. For example: - -gsec -> add myuser -pass mypass -> quit -isql -u myuser -p mypass localhost:/usr/local/firebird/examples/employee.fdb - -This should reduce the need for hosts defined in /etc/hosts.equiv. - - Complete documentation for InterBase(tm) is available (free of -charge) from http://www.interbase.com/ in PDF format. While -InterBase and Firebird are two distinct entities, all InterBase -documentation is pertinent to Firebird. More information on Firebird -and InterBase can be found at the following: - - http://sourceforge.net/projects/firebird/ - http://www.ibphoenix.com/ - http://www.interbase2000.org/ - http://www.firebirdsql.org/ - - Please also see the doc directory in the Firebird package for -documentation specific to Firebird. - -Chris Knight -<chris@e-easy.com.au> diff --git a/databases/firebird/files/patch-src::extern::editline::makelist b/databases/firebird/files/patch-src::extern::editline::makelist deleted file mode 100644 index 870f3cfdaece..000000000000 --- a/databases/firebird/files/patch-src::extern::editline::makelist +++ /dev/null @@ -1,11 +0,0 @@ ---- src/extern/editline/makelist.orig Mon May 24 04:24:25 2004 -+++ src/extern/editline/makelist Fri Jul 23 17:09:43 2004 -@@ -145,7 +145,7 @@ - # - -fh) - cat $FILES | $AWK '/el_action_t/ { print $3 }' | \ -- sort | tr '[a-z]' '[A-Z]' | $AWK ' -+ sort | tr '[:lower:]' '[:upper:]' | $AWK ' - BEGIN { - printf("/* Automatically generated file, do not edit */\n"); - printf("#ifndef _h_fcns_c\n#define _h_fcns_c\n"); diff --git a/databases/firebird/files/patch-src::install::arch-specific::freebsd::install.sh.in b/databases/firebird/files/patch-src::install::arch-specific::freebsd::install.sh.in deleted file mode 100644 index 03df0f2e369c..000000000000 --- a/databases/firebird/files/patch-src::install::arch-specific::freebsd::install.sh.in +++ /dev/null @@ -1,42 +0,0 @@ ---- src/install/arch-specific/freebsd/install.sh.in.orig Tue Apr 26 07:14:26 2005 -+++ src/install/arch-specific/freebsd/install.sh.in Tue Apr 26 07:15:05 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 -@@ -284,25 +277,6 @@ - [ -f aliases.conf ] || install -o $fbUID -g $fbGID -m 444 aliases.conf.sample aliases.conf - [ -f firebird.conf ] || install -o $fbUID -g $fbGID -m 444 firebird.conf.sample firebird.conf - [ -f security.fdb ] || install -o $fbUID -g $fbGID -m 660 security.fdb.sample security.fdb -- --# remove any existing gds service --cp /etc/services /etc/services.old --cp /etc/inetd.conf /etc/inetd.conf.old --cat /etc/services |grep -v gds_db >/etc/services.new --cat /etc/inetd.conf |grep -v gds_db >/etc/inetd.conf.new --mv /etc/services.new /etc/services --mv /etc/inetd.conf.new /etc/inetd.conf -- --# add the gds service and restart inetd --cat >>/etc/services <<EOF --gds_db 3050/tcp #InterBase Database Remote Protocol --EOF --cat >>/etc/inetd.conf <<EOF --gds_db stream tcp nowait firebird $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/pkg-descr b/databases/firebird/pkg-descr deleted file mode 100644 index dbeba43f543f..000000000000 --- a/databases/firebird/pkg-descr +++ /dev/null @@ -1,15 +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. - -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/pkg-install b/databases/firebird/pkg-install deleted file mode 100644 index e716ae8fa917..000000000000 --- a/databases/firebird/pkg-install +++ /dev/null @@ -1,145 +0,0 @@ -#!/bin/sh - -# $FreeBSD$ - -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.1 libgds.so.1 - -cd $PKG_PREFIX/firebird/bin -for i in `ls` -do - chmod ug=rx,o= $i -done - -chmod a=rx isql qli - -# SUID is needed for running server programs. -for i in fb_lock_mgr gds_drop fb_inet_server -do - if [ -f $i ]; then - chmod ug=rx,o= $i - chmod ug+s $i - fi -done - - -cd $PKG_PREFIX/firebird - -# Lock files - -for i in isc_init1 isc_lock1 isc_event1 -do - FileName=$i.`hostname` - touch $FileName - chmod uga=rw $FileName - chown firebird:firebird $FileName -done - -touch firebird.log -chown firebird:firebird firebird.log -chmod ug=rw,o= firebird.log -chmod a=r firebird.msg README -chown root:wheel *.sample -chmod ug=r,o= *.sample - -# make databases writable by firebird only -# local database connections are not a good idea -chmod ug=rw,o= examples/*.fdb -chmod ug=rw,o= help/*.fdb -chmod ug=rw,o= security.fdb - -chmod 444 aliases.conf firebird.conf -chmod 660 security.fdb - -# shared lib startup script -if [ -d $PKG_PREFIX/etc/rc.d ]; then - ( - echo "#!/bin/sh"; echo "[ -d $PKG_PREFIX/firebird/lib ] && /sbin/ldconfig -m $PKG_PREFIX/firebird/lib" - ) > $PKG_PREFIX/etc/rc.d/000.firebird.sh - chmod a=rx $PKG_PREFIX/etc/rc.d/000.firebird.sh -fi -;; - -esac diff --git a/databases/firebird/pkg-plist b/databases/firebird/pkg-plist deleted file mode 100644 index b6212232a3a4..000000000000 --- a/databases/firebird/pkg-plist +++ /dev/null @@ -1,130 +0,0 @@ -etc/rc.d/000.firebird.sh -firebird/README -firebird/RELNOTES -firebird/UDF/fbudf.so -firebird/UDF/fbudf.sql -firebird/UDF/ib_udf.so -firebird/UDF/ib_udf.sql -firebird/WhatsNew -@unexec if cmp -s %D/firebird/aliases.conf %D/firebird/aliases.conf.sample; then rm -f %D/firebird/aliases.conf; fi -firebird/aliases.conf.sample -@exec [ -f %B/aliases.conf ] || cp %B/%f %B/aliases.conf -firebird/bin/fb_inet_server -firebird/bin/fb_lock_mgr -firebird/bin/fb_lock_print -firebird/bin/gbak -firebird/bin/gdef -firebird/bin/gds_drop -firebird/bin/gfix -firebird/bin/gpre -firebird/bin/gsec -firebird/bin/gstat -firebird/bin/isql -firebird/bin/qli -firebird/doc/README.NTSecurity -firebird/doc/README.Win32LibraryInstallation.txt -firebird/doc/README.build.mingw.html -firebird/doc/README.build.msvc.html -firebird/doc/README.install.Solaris_on_Intel -firebird/doc/README.instsvc -firebird/doc/README.makefiles -firebird/doc/README.user -firebird/doc/README.user.embedded -firebird/doc/README.user.troubleshooting -firebird/doc/sql.extensions/README.aggregate_tracking -firebird/doc/sql.extensions/README.case -firebird/doc/sql.extensions/README.coalesce -firebird/doc/sql.extensions/README.context_variables -firebird/doc/sql.extensions/README.data_types -firebird/doc/sql.extensions/README.exception_handling -firebird/doc/sql.extensions/README.execute_statement -firebird/doc/sql.extensions/README.explicit_locks -firebird/doc/sql.extensions/README.nullif -firebird/doc/sql.extensions/README.order_by_expressions_nulls -firebird/doc/sql.extensions/README.savepoints -firebird/doc/sql.extensions/README.universal_triggers -firebird/examples/align.h -firebird/examples/api1.c -firebird/examples/api10.c -firebird/examples/api11.c -firebird/examples/api12.c -firebird/examples/api13.c -firebird/examples/api14.e -firebird/examples/api15.c -firebird/examples/api16.c -firebird/examples/api16t.c -firebird/examples/api2.c -firebird/examples/api3.c -firebird/examples/api4.c -firebird/examples/api5.c -firebird/examples/api6.c -firebird/examples/api7.c -firebird/examples/api8.c -firebird/examples/api9.c -firebird/examples/api9f.c -firebird/examples/api9f.sql -firebird/examples/apifull.c -firebird/examples/dyn1.e -firebird/examples/dyn2.e -firebird/examples/dyn3.e -firebird/examples/dyn4.e -firebird/examples/dyn5.e -firebird/examples/dynfull.e -firebird/examples/employe2.sql -firebird/examples/employee.fdb -firebird/examples/employee.gbk -firebird/examples/example.h -firebird/examples/readme -firebird/examples/stat1.e -firebird/examples/stat10.e -firebird/examples/stat11.e -firebird/examples/stat12.e -firebird/examples/stat12t.e -firebird/examples/stat2.e -firebird/examples/stat3.e -firebird/examples/stat4.e -firebird/examples/stat5.e -firebird/examples/stat6.e -firebird/examples/stat7.e -firebird/examples/stat8.e -firebird/examples/stat9.e -firebird/examples/udf.sql -firebird/examples/udflib.c -@unexec if cmp -s %D/firebird/firebird.conf %D/firebird/firebird.conf.sample; then rm -f %D/firebird/firebird.conf; fi -firebird/firebird.conf.sample -@exec [ -f %B/firebird.conf ] || cp %B/%f %B/firebird.conf -@unexec [ -s %D/firebird/firebird.log ] || rm -f %D/firebird/firebird.log -firebird/firebird.msg -firebird/help/help.fdb -firebird/include/blr.h -firebird/include/gds.h -firebird/include/ib_util.h -firebird/include/ibase.h -firebird/include/iberror.h -firebird/include/perf.h -firebird/intl/fbintl -@unexec rm -f %D/firebird/isc_event1.`hostname` -@unexec rm -f %D/firebird/isc_init1.`hostname` -@unexec rm -f %D/firebird/isc_lock1.`hostname` -firebird/lib/libfbclient.so -firebird/lib/libfbclient.so.1 -firebird/lib/libfbclient.so.%%FIREBIRD_VERSION%% -firebird/lib/libfbembed.so -firebird/lib/libfbembed.so.1 -firebird/lib/libfbembed.so.%%FIREBIRD_VERSION%% -firebird/lib/libgds.so -firebird/lib/libgds.so.1 -firebird/lib/libib_util.so -@unexec if cmp -s %D/firebird/security.fdb %D/firebird/security.fdb.sample; then rm -f %D/firebird/security.fdb; fi -firebird/security.fdb.sample -@exec [ -f %B/security.fdb ] || cp %B/%f %B/security.fdb -@dirrm firebird/UDF -@dirrm firebird/bin -@dirrm firebird/doc/sql.extensions -@dirrm firebird/doc -@dirrm firebird/examples -@dirrm firebird/help -@dirrm firebird/include -@dirrm firebird/intl -@dirrm firebird/lib -@dirrm firebird diff --git a/databases/firebird2-server/Makefile b/databases/firebird2-server/Makefile index 37c91e1cdc08..4519c1ce46ba 100644 --- a/databases/firebird2-server/Makefile +++ b/databases/firebird2-server/Makefile @@ -5,16 +5,18 @@ # $FreeBSD$ # -PORTNAME= firebird +PORTNAME?= firebird PORTVERSION= 1.5.2 -CATEGORIES= databases +CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_SOURCEFORGE} MASTER_SITE_SUBDIR=firebird +PKGNAMESUFFIX?= -server DISTNAME= firebird-1.5.2.4731 -MAINTAINER= freebsd@galle.com.br -COMMENT= The open-source InterBase(tm) 6.0 spin-off (Classic version) +MAINTAINER= renato@galle.com.br +COMMENT?= The open-source InterBase(tm) 6.0 spin-off (Classic version) +USE_REINPLACE= yes USE_BISON= yes USE_BZIP2= yes USE_GMAKE= yes @@ -28,19 +30,48 @@ PLIST_SUB= FIREBIRD_VERSION=${PORTVERSION} # Don't use ld for linking, use gcc LD= gcc -CONFLICTS= firebird-devel-[0-9]* +# Don't strip binary files +STRIP= + +ONLY_FOR_ARCHS= i386 WRKSRC= ${WRKDIR}/${DISTNAME} -INSTALLS_SHLIB= yes -LDCONFIG_DIRS= %%PREFIX%%/firebird/lib -MSG_FILE= ${PKGDIR}/pkg-message + +.if !defined(CLIENT_ONLY) +# Server part stuff +LIB_DEPENDS+= fbembed.1:${PORTSDIR}/databases/firebird-client + +AUTOGENARGS= --prefix=${PREFIX}/firebird \ + --with-lock-manager + +ALL_TARGET= firebird_boot ref_databases msgs intl otherfiles \ + inet_server extlib + +# Use own user and group when install server part +BINOWN= firebird +BINGRP= firebird +BINMODE= 550 +SHAREOWN= firebird +SHAREGRP= firebird + PKGMESSAGE= ${WRKDIR}/pkg-message -USE_REINPLACE= yes +PKGINSTALL= ${WRKDIR}/pkg-install -ONLY_FOR_ARCHS= i386 +CONFLICTS= firebird-devel-[0-9]* +.else +# Client part stuff +AUTOGENARGS= --prefix=${PREFIX} \ + --with-editline + +ALL_TARGET= firebird_basic libfbembed embed_gfix embed_gbak embed_isql embed_gpre \ + embed_util embed_gdef embed_qli libfbclient extlib + +INSTALLS_SHLIB= yes +.endif .include <bsd.port.pre.mk> +.if !defined(CLIENT_ONLY) pre-everything:: @${ECHO_MSG} "NOTE: If the work directory is on an NFS mount, you will" @${ECHO_MSG} "require NFS client locking support for the build to" @@ -55,6 +86,33 @@ pre-everything:: @sleep 10 .endif +post-patch: + @${REINPLACE_CMD} -e 's|^\(LINK_OPTS +=.*\)$$|\1 -L${LOCALBASE}/lib|' \ + ${WRKSRC}/builds/posix/Makefile.in.inet_server + +post-build: + ${SED} 's|%%PREFIX%%|${PREFIX}|g' \ + < ${FILESDIR}/pkg-message.in \ + > ${PKGMESSAGE} + + ${SED} -e 's|%%PREFIX%%|${PREFIX}/firebird|g' \ + < ${FILESDIR}/pkg-install.in \ + > ${PKGINSTALL} + + ${SED} -e "s|%%PREFIX%%|${PREFIX}/firebird|g" \ + < ${FILESDIR}/aliases.conf.in \ + > ${WRKDIR}/aliases.conf + +pre-install: + ${SETENV} PKG_PREFIX="${PREFIX}" PKG_DESTDIR="${DESTDIR}" ${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL + +post-install: + ${SETENV} PKG_PREFIX="${PREFIX}" PKG_DESTDIR="${DESTDIR}" ${SH} ${PKGINSTALL} ${PORTNAME} POST-INSTALL + @${ECHO_MSG} + @${CAT} ${PKGMESSAGE} + @${ECHO_MSG} +.endif + patch-autotools: @${DO_NADA} @@ -63,20 +121,81 @@ run-autotools: do-configure: @(cd ${WRKSRC} && ${SETENV} CC=${CC} CXX=${CXX} MAKE=${GMAKE} \ - ${AUTOTOOLS_VARS} ./autogen.sh --prefix=${PREFIX}/firebird \ - --with-lock-manager --with-editline) + ${AUTOTOOLS_VARS} ./autogen.sh ${AUTOGENARGS}) -do-build: - @( \ - ${SED} 's|%%PREFIX%%|${PREFIX}|g' ${MSG_FILE} > ${PKGMESSAGE}; \ - cd ${WRKSRC}; \ - ${SETENV} CC=${CC} CXX=${CXX} ${GMAKE} all; \ - ) +post-configure: + @${REINPLACE_CMD} -e 's|__attribute__ ((__unused__));||' \ + ${WRKSRC}/src/dsql/parse.cpp -post-install: - @( \ - ${INSTALL_DATA} ${FILESDIR}/RELNOTES ${PREFIX}/firebird; \ - ${CAT} ${PKGMESSAGE}; \ - ) +do-install: +.if !defined(CLIENT_ONLY) + + ${MKDIR} ${PREFIX}/firebird + ${CHOWN} ${BINOWN}:${BINGRP} ${PREFIX}/firebird + +.for f in UDF bin help intl + ${MKDIR} ${PREFIX}/firebird/${f} + ${CHOWN} ${BINOWN}:${BINGRP} ${PREFIX}/firebird/${f} +.endfor + + ${INSTALL_DATA} ${WRKDIR}/aliases.conf ${PREFIX}/firebird/aliases.conf.sample + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/misc/firebird.conf ${PREFIX}/firebird/firebird.conf.sample + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/security.fdb ${PREFIX}/firebird/security.fdb.sample + ${CHMOD} 660 ${PREFIX}/firebird/security.fdb.sample + + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/firebird.msg ${PREFIX}/firebird/firebird.msg + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/help/help.fdb ${PREFIX}/firebird/help + +.for f in ib_udf.so fbudf.so + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/UDF/${f} ${PREFIX}/firebird/UDF +.endfor + +.for f in src/extlib/ib_udf.sql src/extlib/fbudf/fbudf.sql + ${INSTALL_SCRIPT} ${WRKSRC}/${f} ${PREFIX}/firebird/UDF +.endfor + +.for f in fb_inet_server fb_lock_mgr + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/bin/${f} ${PREFIX}/firebird/bin + ${CHMOD} u+s ${PREFIX}/firebird/bin/${f} +.endfor + + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/intl/libfbintl.so ${PREFIX}/firebird/intl/fbintl + + ${INSTALL_DATA} ${FILESDIR}/RELNOTES ${PREFIX}/firebird + +.else + +.for dir in include share/doc/firebird \ + share/doc/firebird/sql.extensions share/examples/firebird + ${MKDIR} ${PREFIX}/${dir} +.endfor + +.for f in fb_lock_print gbak gdef gds_drop gfix gpre gsec gstat isql qli + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/bin/${f} ${PREFIX}/bin +.endfor + + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libfbclient.so.${PORTVERSION} ${PREFIX}/lib + ${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libfbclient.so.1 + ${LN} -fs libfbclient.so.1 ${PREFIX}/lib/libfbclient.so + + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libfbembed.so.${PORTVERSION} ${PREFIX}/lib + ${LN} -fs libfbembed.so.${PORTVERSION} ${PREFIX}/lib/libfbembed.so.1 + ${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libfbembed.so + + ${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libgds.so.1 + ${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libgds.so + + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libib_util.so ${PREFIX}/lib + + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/include/*.h ${PREFIX}/include + + ${INSTALL_DATA} ${WRKSRC}/doc/WhatsNew ${PREFIX}/share/doc/firebird + ${INSTALL_DATA} ${WRKSRC}/doc/README.* ${PREFIX}/share/doc/firebird + ${INSTALL_DATA} ${WRKSRC}/doc/README.user ${PREFIX}/share/doc/firebird/README + ${INSTALL_DATA} ${WRKSRC}/doc/sql.extensions/README.* ${PREFIX}/share/doc/firebird/sql.extensions + + # Install examples + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/examples/v5/* ${PREFIX}/share/examples/firebird +.endif .include <bsd.port.post.mk> diff --git a/databases/firebird2-server/files/aliases.conf.in b/databases/firebird2-server/files/aliases.conf.in new file mode 100644 index 000000000000..05a28980b909 --- /dev/null +++ b/databases/firebird2-server/files/aliases.conf.in @@ -0,0 +1,8 @@ +# +# List of known database aliases +# ------------------------------ +# +# Examples: +# +# employee = %%PREFIX%%/examples/employee.fdb +# diff --git a/databases/firebird2-server/files/patch-builds::posix::Makefile.in.inet_server b/databases/firebird2-server/files/patch-builds::posix::Makefile.in.inet_server new file mode 100644 index 000000000000..8dcddef34a6a --- /dev/null +++ b/databases/firebird2-server/files/patch-builds::posix::Makefile.in.inet_server @@ -0,0 +1,20 @@ +--- builds/posix/Makefile.in.inet_server.orig Fri Sep 17 20:34:21 2004 ++++ builds/posix/Makefile.in.inet_server Wed Mar 2 16:09:41 2005 +@@ -39,6 +39,8 @@ + + @SET_MAKE@ + ++LINK_OPTS += ++ + SERVER_Files = server_stub.cpp + SERVER_Sources = $(addprefix remote/, $(SERVER_Files)) + SERVER_Objects = $(addprefix $(OBJ)/, $(addsuffix .o, $(basename $(SERVER_Sources)))) +@@ -51,7 +53,7 @@ + + # SD: We don't need to rebuild fb_inet_server every time libfbembed.so changed, + # but we must ensure it's existance +-fb_inet_server : $(LIBFBEMBED_SO) $(FB_CLASSIC_SERVER) ++fb_inet_server : $(FB_CLASSIC_SERVER) + + $(FB_CLASSIC_SERVER): $(SERVER_Objects) + $(LD) $(LINK_OPTS) $^ -o $@ $(FBEMBED_LINK) $(LIB_GUI) $(LINK_LIBS) diff --git a/databases/firebird2-server/files/patch-src::install::arch-specific::freebsd::install.sh.in b/databases/firebird2-server/files/patch-src::install::arch-specific::freebsd::install.sh.in deleted file mode 100644 index 03df0f2e369c..000000000000 --- a/databases/firebird2-server/files/patch-src::install::arch-specific::freebsd::install.sh.in +++ /dev/null @@ -1,42 +0,0 @@ ---- src/install/arch-specific/freebsd/install.sh.in.orig Tue Apr 26 07:14:26 2005 -+++ src/install/arch-specific/freebsd/install.sh.in Tue Apr 26 07:15:05 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 -@@ -284,25 +277,6 @@ - [ -f aliases.conf ] || install -o $fbUID -g $fbGID -m 444 aliases.conf.sample aliases.conf - [ -f firebird.conf ] || install -o $fbUID -g $fbGID -m 444 firebird.conf.sample firebird.conf - [ -f security.fdb ] || install -o $fbUID -g $fbGID -m 660 security.fdb.sample security.fdb -- --# remove any existing gds service --cp /etc/services /etc/services.old --cp /etc/inetd.conf /etc/inetd.conf.old --cat /etc/services |grep -v gds_db >/etc/services.new --cat /etc/inetd.conf |grep -v gds_db >/etc/inetd.conf.new --mv /etc/services.new /etc/services --mv /etc/inetd.conf.new /etc/inetd.conf -- --# add the gds service and restart inetd --cat >>/etc/services <<EOF --gds_db 3050/tcp #InterBase Database Remote Protocol --EOF --cat >>/etc/inetd.conf <<EOF --gds_db stream tcp nowait firebird $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/firebird2-server/files/pkg-install.in b/databases/firebird2-server/files/pkg-install.in new file mode 100644 index 000000000000..d442ff99ee3f --- /dev/null +++ b/databases/firebird2-server/files/pkg-install.in @@ -0,0 +1,70 @@ +#!/bin/sh + +PATH=/sbin:/usr/sbin:/usr/local/sbin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin:%%PREFIX%%/bin +PREFIX=%%PREFIX%% +DB_DIR=%%PREFIX%% + +USER=firebird +GROUP=${USER} +UID=3050 +GID=${UID} +HOME=${DB_DIR} +DESCR="Firebird Database Administrator" + +case $2 in +PRE-INSTALL) + if pw group show "${GROUP}" 2> /dev/null; then + echo "You already have a group \"${GROUP}\", so I will use it." + else + if pw groupadd ${GROUP} -g ${GID}; then + echo "Added group \"${GROUP}\"." + else + echo "Adding group \"${GROUP}\" failed..." + exit 1 + fi + fi + + if pw user show "${USER}" 2> /dev/null; then + echo "You already have a user \"${USER}\", so I will use it." + + if pw usermod ${USER} -d ${HOME}; then + echo "Changed home directory of \"${USER}\" to \"${HOME}\"" + else + echo "Changing home directory of \"${USER}\" to \"${HOME}\" failed..." + exit 1 + fi + else + if pw useradd ${USER} -u ${UID} -g ${GROUP} -h - -d ${NOME} -s /sbin/nologin -c "${DESCR}" ; then + echo "Added user \"${USER}\"." + else + echo "Adding user \"${USER}\" failed..." + exit 1 + fi + fi + ;; + +POST-INSTALL) + for f in isc_init1.`hostname` isc_lock1.`hostname` isc_event1.`hostname` firebird.log + do + touch ${PREFIX}/${f} + chown ${USER}:${GROUP} ${PREFIX}/$f + chmod 660 ${PREFIX}/${f} + done + + # add the gds service and restart inetd + cat /etc/services | grep -v gds_db > /etc/services.new + cat >>/etc/services.new <<EOF +gds_db 3050/tcp #InterBase Database Remote Protocol +EOF + mv /etc/services.new /etc/services + + cat /etc/inetd.conf | grep -v gds_db > /etc/inetd.conf.new + cat >>/etc/inetd.conf.new <<EOF +gds_db stream tcp nowait firebird ${PREFIX}/bin/fb_inet_server fb_inet_server +EOF + mv /etc/inetd.conf.new /etc/inetd.conf + + if [ -f /var/run/inetd.pid ]; then + kill -HUP `cat /var/run/inetd.pid` + fi +esac diff --git a/databases/firebird-client/pkg-message b/databases/firebird2-server/files/pkg-message.in index 02894da409f2..2cab9049eba5 100644 --- a/databases/firebird-client/pkg-message +++ b/databases/firebird2-server/files/pkg-message.in @@ -1,20 +1,8 @@ - --------------------------------------------------------- -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. +Firebird is now installed. A symbolic link from +/usr/interbase -> %%PREFIX%%/firebird may be needed +for compatibility with existing programs that use +Firebird. The symbolic link can be created with: @@ -32,4 +20,3 @@ before doing anything serious with Firebird. See %%PREFIX%%/firebird/RELNOTES for more. --------------------------------------------------------- - diff --git a/databases/firebird2-server/pkg-install b/databases/firebird2-server/pkg-install deleted file mode 100644 index e716ae8fa917..000000000000 --- a/databases/firebird2-server/pkg-install +++ /dev/null @@ -1,145 +0,0 @@ -#!/bin/sh - -# $FreeBSD$ - -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.1 libgds.so.1 - -cd $PKG_PREFIX/firebird/bin -for i in `ls` -do - chmod ug=rx,o= $i -done - -chmod a=rx isql qli - -# SUID is needed for running server programs. -for i in fb_lock_mgr gds_drop fb_inet_server -do - if [ -f $i ]; then - chmod ug=rx,o= $i - chmod ug+s $i - fi -done - - -cd $PKG_PREFIX/firebird - -# Lock files - -for i in isc_init1 isc_lock1 isc_event1 -do - FileName=$i.`hostname` - touch $FileName - chmod uga=rw $FileName - chown firebird:firebird $FileName -done - -touch firebird.log -chown firebird:firebird firebird.log -chmod ug=rw,o= firebird.log -chmod a=r firebird.msg README -chown root:wheel *.sample -chmod ug=r,o= *.sample - -# make databases writable by firebird only -# local database connections are not a good idea -chmod ug=rw,o= examples/*.fdb -chmod ug=rw,o= help/*.fdb -chmod ug=rw,o= security.fdb - -chmod 444 aliases.conf firebird.conf -chmod 660 security.fdb - -# shared lib startup script -if [ -d $PKG_PREFIX/etc/rc.d ]; then - ( - echo "#!/bin/sh"; echo "[ -d $PKG_PREFIX/firebird/lib ] && /sbin/ldconfig -m $PKG_PREFIX/firebird/lib" - ) > $PKG_PREFIX/etc/rc.d/000.firebird.sh - chmod a=rx $PKG_PREFIX/etc/rc.d/000.firebird.sh -fi -;; - -esac diff --git a/databases/firebird2-server/pkg-message b/databases/firebird2-server/pkg-message deleted file mode 100644 index 02894da409f2..000000000000 --- a/databases/firebird2-server/pkg-message +++ /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%%/firebird /usr/interbase - -It is STRONGLY recommended that you change the SYSDBA -password with: - -% cd %%PREFIX%%/firebird -% gsec -user SYSDBA -pass masterkey -GSEC> modify SYSDBA -pw newpassword -GSEC> quit - -before doing anything serious with Firebird. - -See %%PREFIX%%/firebird/RELNOTES for more. ---------------------------------------------------------- - diff --git a/databases/firebird2-server/pkg-plist b/databases/firebird2-server/pkg-plist index b6212232a3a4..43e32f04ced0 100644 --- a/databases/firebird2-server/pkg-plist +++ b/databases/firebird2-server/pkg-plist @@ -1,130 +1,28 @@ -etc/rc.d/000.firebird.sh -firebird/README firebird/RELNOTES firebird/UDF/fbudf.so firebird/UDF/fbudf.sql firebird/UDF/ib_udf.so firebird/UDF/ib_udf.sql -firebird/WhatsNew @unexec if cmp -s %D/firebird/aliases.conf %D/firebird/aliases.conf.sample; then rm -f %D/firebird/aliases.conf; fi firebird/aliases.conf.sample @exec [ -f %B/aliases.conf ] || cp %B/%f %B/aliases.conf firebird/bin/fb_inet_server firebird/bin/fb_lock_mgr -firebird/bin/fb_lock_print -firebird/bin/gbak -firebird/bin/gdef -firebird/bin/gds_drop -firebird/bin/gfix -firebird/bin/gpre -firebird/bin/gsec -firebird/bin/gstat -firebird/bin/isql -firebird/bin/qli -firebird/doc/README.NTSecurity -firebird/doc/README.Win32LibraryInstallation.txt -firebird/doc/README.build.mingw.html -firebird/doc/README.build.msvc.html -firebird/doc/README.install.Solaris_on_Intel -firebird/doc/README.instsvc -firebird/doc/README.makefiles -firebird/doc/README.user -firebird/doc/README.user.embedded -firebird/doc/README.user.troubleshooting -firebird/doc/sql.extensions/README.aggregate_tracking -firebird/doc/sql.extensions/README.case -firebird/doc/sql.extensions/README.coalesce -firebird/doc/sql.extensions/README.context_variables -firebird/doc/sql.extensions/README.data_types -firebird/doc/sql.extensions/README.exception_handling -firebird/doc/sql.extensions/README.execute_statement -firebird/doc/sql.extensions/README.explicit_locks -firebird/doc/sql.extensions/README.nullif -firebird/doc/sql.extensions/README.order_by_expressions_nulls -firebird/doc/sql.extensions/README.savepoints -firebird/doc/sql.extensions/README.universal_triggers -firebird/examples/align.h -firebird/examples/api1.c -firebird/examples/api10.c -firebird/examples/api11.c -firebird/examples/api12.c -firebird/examples/api13.c -firebird/examples/api14.e -firebird/examples/api15.c -firebird/examples/api16.c -firebird/examples/api16t.c -firebird/examples/api2.c -firebird/examples/api3.c -firebird/examples/api4.c -firebird/examples/api5.c -firebird/examples/api6.c -firebird/examples/api7.c -firebird/examples/api8.c -firebird/examples/api9.c -firebird/examples/api9f.c -firebird/examples/api9f.sql -firebird/examples/apifull.c -firebird/examples/dyn1.e -firebird/examples/dyn2.e -firebird/examples/dyn3.e -firebird/examples/dyn4.e -firebird/examples/dyn5.e -firebird/examples/dynfull.e -firebird/examples/employe2.sql -firebird/examples/employee.fdb -firebird/examples/employee.gbk -firebird/examples/example.h -firebird/examples/readme -firebird/examples/stat1.e -firebird/examples/stat10.e -firebird/examples/stat11.e -firebird/examples/stat12.e -firebird/examples/stat12t.e -firebird/examples/stat2.e -firebird/examples/stat3.e -firebird/examples/stat4.e -firebird/examples/stat5.e -firebird/examples/stat6.e -firebird/examples/stat7.e -firebird/examples/stat8.e -firebird/examples/stat9.e -firebird/examples/udf.sql -firebird/examples/udflib.c @unexec if cmp -s %D/firebird/firebird.conf %D/firebird/firebird.conf.sample; then rm -f %D/firebird/firebird.conf; fi firebird/firebird.conf.sample @exec [ -f %B/firebird.conf ] || cp %B/%f %B/firebird.conf @unexec [ -s %D/firebird/firebird.log ] || rm -f %D/firebird/firebird.log firebird/firebird.msg firebird/help/help.fdb -firebird/include/blr.h -firebird/include/gds.h -firebird/include/ib_util.h -firebird/include/ibase.h -firebird/include/iberror.h -firebird/include/perf.h firebird/intl/fbintl @unexec rm -f %D/firebird/isc_event1.`hostname` @unexec rm -f %D/firebird/isc_init1.`hostname` @unexec rm -f %D/firebird/isc_lock1.`hostname` -firebird/lib/libfbclient.so -firebird/lib/libfbclient.so.1 -firebird/lib/libfbclient.so.%%FIREBIRD_VERSION%% -firebird/lib/libfbembed.so -firebird/lib/libfbembed.so.1 -firebird/lib/libfbembed.so.%%FIREBIRD_VERSION%% -firebird/lib/libgds.so -firebird/lib/libgds.so.1 -firebird/lib/libib_util.so @unexec if cmp -s %D/firebird/security.fdb %D/firebird/security.fdb.sample; then rm -f %D/firebird/security.fdb; fi firebird/security.fdb.sample @exec [ -f %B/security.fdb ] || cp %B/%f %B/security.fdb @dirrm firebird/UDF @dirrm firebird/bin -@dirrm firebird/doc/sql.extensions -@dirrm firebird/doc -@dirrm firebird/examples @dirrm firebird/help -@dirrm firebird/include @dirrm firebird/intl -@dirrm firebird/lib @dirrm firebird diff --git a/databases/firebird2-server/pkg-plist.client b/databases/firebird2-server/pkg-plist.client new file mode 100644 index 000000000000..3f302be5fd42 --- /dev/null +++ b/databases/firebird2-server/pkg-plist.client @@ -0,0 +1,99 @@ +bin/fb_lock_print +bin/gbak +bin/gdef +bin/gds_drop +bin/gfix +bin/gpre +bin/gsec +bin/gstat +bin/isql +bin/qli +include/blr.h +include/gds.h +include/ib_util.h +include/ibase.h +include/iberror.h +include/perf.h +lib/libfbclient.so +lib/libfbclient.so.1 +lib/libfbclient.so.%%FIREBIRD_VERSION%% +lib/libfbembed.so +lib/libfbembed.so.1 +lib/libfbembed.so.%%FIREBIRD_VERSION%% +lib/libgds.so +lib/libgds.so.1 +lib/libib_util.so +%%DOCSDIR%%/README.NTSecurity +%%DOCSDIR%%/README.Win32LibraryInstallation.txt +%%DOCSDIR%%/README.build.mingw.html +%%DOCSDIR%%/README.build.msvc.html +%%DOCSDIR%%/README.install.Solaris_on_Intel +%%DOCSDIR%%/README.instsvc +%%DOCSDIR%%/README.makefiles +%%DOCSDIR%%/README.user +%%DOCSDIR%%/README.user.embedded +%%DOCSDIR%%/README.user.troubleshooting +%%DOCSDIR%%/README +%%DOCSDIR%%/WhatsNew +%%DOCSDIR%%/sql.extensions/README.aggregate_tracking +%%DOCSDIR%%/sql.extensions/README.case +%%DOCSDIR%%/sql.extensions/README.coalesce +%%DOCSDIR%%/sql.extensions/README.context_variables +%%DOCSDIR%%/sql.extensions/README.data_types +%%DOCSDIR%%/sql.extensions/README.exception_handling +%%DOCSDIR%%/sql.extensions/README.execute_statement +%%DOCSDIR%%/sql.extensions/README.explicit_locks +%%DOCSDIR%%/sql.extensions/README.nullif +%%DOCSDIR%%/sql.extensions/README.order_by_expressions_nulls +%%DOCSDIR%%/sql.extensions/README.savepoints +%%DOCSDIR%%/sql.extensions/README.universal_triggers +%%EXAMPLESDIR%%/align.h +%%EXAMPLESDIR%%/api1.c +%%EXAMPLESDIR%%/api10.c +%%EXAMPLESDIR%%/api11.c +%%EXAMPLESDIR%%/api12.c +%%EXAMPLESDIR%%/api13.c +%%EXAMPLESDIR%%/api14.e +%%EXAMPLESDIR%%/api15.c +%%EXAMPLESDIR%%/api16.c +%%EXAMPLESDIR%%/api16t.c +%%EXAMPLESDIR%%/api2.c +%%EXAMPLESDIR%%/api3.c +%%EXAMPLESDIR%%/api4.c +%%EXAMPLESDIR%%/api5.c +%%EXAMPLESDIR%%/api6.c +%%EXAMPLESDIR%%/api7.c +%%EXAMPLESDIR%%/api8.c +%%EXAMPLESDIR%%/api9.c +%%EXAMPLESDIR%%/api9f.c +%%EXAMPLESDIR%%/api9f.sql +%%EXAMPLESDIR%%/apifull.c +%%EXAMPLESDIR%%/dyn1.e +%%EXAMPLESDIR%%/dyn2.e +%%EXAMPLESDIR%%/dyn3.e +%%EXAMPLESDIR%%/dyn4.e +%%EXAMPLESDIR%%/dyn5.e +%%EXAMPLESDIR%%/dynfull.e +%%EXAMPLESDIR%%/employe2.sql +%%EXAMPLESDIR%%/employee.fdb +%%EXAMPLESDIR%%/employee.gbk +%%EXAMPLESDIR%%/example.h +%%EXAMPLESDIR%%/readme +%%EXAMPLESDIR%%/stat1.e +%%EXAMPLESDIR%%/stat10.e +%%EXAMPLESDIR%%/stat11.e +%%EXAMPLESDIR%%/stat12.e +%%EXAMPLESDIR%%/stat12t.e +%%EXAMPLESDIR%%/stat2.e +%%EXAMPLESDIR%%/stat3.e +%%EXAMPLESDIR%%/stat4.e +%%EXAMPLESDIR%%/stat5.e +%%EXAMPLESDIR%%/stat6.e +%%EXAMPLESDIR%%/stat7.e +%%EXAMPLESDIR%%/stat8.e +%%EXAMPLESDIR%%/stat9.e +%%EXAMPLESDIR%%/udf.sql +%%EXAMPLESDIR%%/udflib.c +@dirrm %%DOCSDIR%%/sql.extensions +@dirrm %%DOCSDIR%% +@dirrm %%EXAMPLESDIR%% diff --git a/databases/firebird20-server/Makefile b/databases/firebird20-server/Makefile index 37c91e1cdc08..4519c1ce46ba 100644 --- a/databases/firebird20-server/Makefile +++ b/databases/firebird20-server/Makefile @@ -5,16 +5,18 @@ # $FreeBSD$ # -PORTNAME= firebird +PORTNAME?= firebird PORTVERSION= 1.5.2 -CATEGORIES= databases +CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_SOURCEFORGE} MASTER_SITE_SUBDIR=firebird +PKGNAMESUFFIX?= -server DISTNAME= firebird-1.5.2.4731 -MAINTAINER= freebsd@galle.com.br -COMMENT= The open-source InterBase(tm) 6.0 spin-off (Classic version) +MAINTAINER= renato@galle.com.br +COMMENT?= The open-source InterBase(tm) 6.0 spin-off (Classic version) +USE_REINPLACE= yes USE_BISON= yes USE_BZIP2= yes USE_GMAKE= yes @@ -28,19 +30,48 @@ PLIST_SUB= FIREBIRD_VERSION=${PORTVERSION} # Don't use ld for linking, use gcc LD= gcc -CONFLICTS= firebird-devel-[0-9]* +# Don't strip binary files +STRIP= + +ONLY_FOR_ARCHS= i386 WRKSRC= ${WRKDIR}/${DISTNAME} -INSTALLS_SHLIB= yes -LDCONFIG_DIRS= %%PREFIX%%/firebird/lib -MSG_FILE= ${PKGDIR}/pkg-message + +.if !defined(CLIENT_ONLY) +# Server part stuff +LIB_DEPENDS+= fbembed.1:${PORTSDIR}/databases/firebird-client + +AUTOGENARGS= --prefix=${PREFIX}/firebird \ + --with-lock-manager + +ALL_TARGET= firebird_boot ref_databases msgs intl otherfiles \ + inet_server extlib + +# Use own user and group when install server part +BINOWN= firebird +BINGRP= firebird +BINMODE= 550 +SHAREOWN= firebird +SHAREGRP= firebird + PKGMESSAGE= ${WRKDIR}/pkg-message -USE_REINPLACE= yes +PKGINSTALL= ${WRKDIR}/pkg-install -ONLY_FOR_ARCHS= i386 +CONFLICTS= firebird-devel-[0-9]* +.else +# Client part stuff +AUTOGENARGS= --prefix=${PREFIX} \ + --with-editline + +ALL_TARGET= firebird_basic libfbembed embed_gfix embed_gbak embed_isql embed_gpre \ + embed_util embed_gdef embed_qli libfbclient extlib + +INSTALLS_SHLIB= yes +.endif .include <bsd.port.pre.mk> +.if !defined(CLIENT_ONLY) pre-everything:: @${ECHO_MSG} "NOTE: If the work directory is on an NFS mount, you will" @${ECHO_MSG} "require NFS client locking support for the build to" @@ -55,6 +86,33 @@ pre-everything:: @sleep 10 .endif +post-patch: + @${REINPLACE_CMD} -e 's|^\(LINK_OPTS +=.*\)$$|\1 -L${LOCALBASE}/lib|' \ + ${WRKSRC}/builds/posix/Makefile.in.inet_server + +post-build: + ${SED} 's|%%PREFIX%%|${PREFIX}|g' \ + < ${FILESDIR}/pkg-message.in \ + > ${PKGMESSAGE} + + ${SED} -e 's|%%PREFIX%%|${PREFIX}/firebird|g' \ + < ${FILESDIR}/pkg-install.in \ + > ${PKGINSTALL} + + ${SED} -e "s|%%PREFIX%%|${PREFIX}/firebird|g" \ + < ${FILESDIR}/aliases.conf.in \ + > ${WRKDIR}/aliases.conf + +pre-install: + ${SETENV} PKG_PREFIX="${PREFIX}" PKG_DESTDIR="${DESTDIR}" ${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL + +post-install: + ${SETENV} PKG_PREFIX="${PREFIX}" PKG_DESTDIR="${DESTDIR}" ${SH} ${PKGINSTALL} ${PORTNAME} POST-INSTALL + @${ECHO_MSG} + @${CAT} ${PKGMESSAGE} + @${ECHO_MSG} +.endif + patch-autotools: @${DO_NADA} @@ -63,20 +121,81 @@ run-autotools: do-configure: @(cd ${WRKSRC} && ${SETENV} CC=${CC} CXX=${CXX} MAKE=${GMAKE} \ - ${AUTOTOOLS_VARS} ./autogen.sh --prefix=${PREFIX}/firebird \ - --with-lock-manager --with-editline) + ${AUTOTOOLS_VARS} ./autogen.sh ${AUTOGENARGS}) -do-build: - @( \ - ${SED} 's|%%PREFIX%%|${PREFIX}|g' ${MSG_FILE} > ${PKGMESSAGE}; \ - cd ${WRKSRC}; \ - ${SETENV} CC=${CC} CXX=${CXX} ${GMAKE} all; \ - ) +post-configure: + @${REINPLACE_CMD} -e 's|__attribute__ ((__unused__));||' \ + ${WRKSRC}/src/dsql/parse.cpp -post-install: - @( \ - ${INSTALL_DATA} ${FILESDIR}/RELNOTES ${PREFIX}/firebird; \ - ${CAT} ${PKGMESSAGE}; \ - ) +do-install: +.if !defined(CLIENT_ONLY) + + ${MKDIR} ${PREFIX}/firebird + ${CHOWN} ${BINOWN}:${BINGRP} ${PREFIX}/firebird + +.for f in UDF bin help intl + ${MKDIR} ${PREFIX}/firebird/${f} + ${CHOWN} ${BINOWN}:${BINGRP} ${PREFIX}/firebird/${f} +.endfor + + ${INSTALL_DATA} ${WRKDIR}/aliases.conf ${PREFIX}/firebird/aliases.conf.sample + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/misc/firebird.conf ${PREFIX}/firebird/firebird.conf.sample + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/security.fdb ${PREFIX}/firebird/security.fdb.sample + ${CHMOD} 660 ${PREFIX}/firebird/security.fdb.sample + + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/firebird.msg ${PREFIX}/firebird/firebird.msg + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/help/help.fdb ${PREFIX}/firebird/help + +.for f in ib_udf.so fbudf.so + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/UDF/${f} ${PREFIX}/firebird/UDF +.endfor + +.for f in src/extlib/ib_udf.sql src/extlib/fbudf/fbudf.sql + ${INSTALL_SCRIPT} ${WRKSRC}/${f} ${PREFIX}/firebird/UDF +.endfor + +.for f in fb_inet_server fb_lock_mgr + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/bin/${f} ${PREFIX}/firebird/bin + ${CHMOD} u+s ${PREFIX}/firebird/bin/${f} +.endfor + + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/intl/libfbintl.so ${PREFIX}/firebird/intl/fbintl + + ${INSTALL_DATA} ${FILESDIR}/RELNOTES ${PREFIX}/firebird + +.else + +.for dir in include share/doc/firebird \ + share/doc/firebird/sql.extensions share/examples/firebird + ${MKDIR} ${PREFIX}/${dir} +.endfor + +.for f in fb_lock_print gbak gdef gds_drop gfix gpre gsec gstat isql qli + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/bin/${f} ${PREFIX}/bin +.endfor + + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libfbclient.so.${PORTVERSION} ${PREFIX}/lib + ${LN} -fs libfbclient.so.${PORTVERSION} ${PREFIX}/lib/libfbclient.so.1 + ${LN} -fs libfbclient.so.1 ${PREFIX}/lib/libfbclient.so + + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libfbembed.so.${PORTVERSION} ${PREFIX}/lib + ${LN} -fs libfbembed.so.${PORTVERSION} ${PREFIX}/lib/libfbembed.so.1 + ${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libfbembed.so + + ${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libgds.so.1 + ${LN} -fs libfbembed.so.1 ${PREFIX}/lib/libgds.so + + ${INSTALL_PROGRAM} ${WRKSRC}/gen/firebird/lib/libib_util.so ${PREFIX}/lib + + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/include/*.h ${PREFIX}/include + + ${INSTALL_DATA} ${WRKSRC}/doc/WhatsNew ${PREFIX}/share/doc/firebird + ${INSTALL_DATA} ${WRKSRC}/doc/README.* ${PREFIX}/share/doc/firebird + ${INSTALL_DATA} ${WRKSRC}/doc/README.user ${PREFIX}/share/doc/firebird/README + ${INSTALL_DATA} ${WRKSRC}/doc/sql.extensions/README.* ${PREFIX}/share/doc/firebird/sql.extensions + + # Install examples + ${INSTALL_DATA} ${WRKSRC}/gen/firebird/examples/v5/* ${PREFIX}/share/examples/firebird +.endif .include <bsd.port.post.mk> diff --git a/databases/firebird20-server/files/aliases.conf.in b/databases/firebird20-server/files/aliases.conf.in new file mode 100644 index 000000000000..05a28980b909 --- /dev/null +++ b/databases/firebird20-server/files/aliases.conf.in @@ -0,0 +1,8 @@ +# +# List of known database aliases +# ------------------------------ +# +# Examples: +# +# employee = %%PREFIX%%/examples/employee.fdb +# diff --git a/databases/firebird20-server/files/patch-builds::posix::Makefile.in.inet_server b/databases/firebird20-server/files/patch-builds::posix::Makefile.in.inet_server new file mode 100644 index 000000000000..8dcddef34a6a --- /dev/null +++ b/databases/firebird20-server/files/patch-builds::posix::Makefile.in.inet_server @@ -0,0 +1,20 @@ +--- builds/posix/Makefile.in.inet_server.orig Fri Sep 17 20:34:21 2004 ++++ builds/posix/Makefile.in.inet_server Wed Mar 2 16:09:41 2005 +@@ -39,6 +39,8 @@ + + @SET_MAKE@ + ++LINK_OPTS += ++ + SERVER_Files = server_stub.cpp + SERVER_Sources = $(addprefix remote/, $(SERVER_Files)) + SERVER_Objects = $(addprefix $(OBJ)/, $(addsuffix .o, $(basename $(SERVER_Sources)))) +@@ -51,7 +53,7 @@ + + # SD: We don't need to rebuild fb_inet_server every time libfbembed.so changed, + # but we must ensure it's existance +-fb_inet_server : $(LIBFBEMBED_SO) $(FB_CLASSIC_SERVER) ++fb_inet_server : $(FB_CLASSIC_SERVER) + + $(FB_CLASSIC_SERVER): $(SERVER_Objects) + $(LD) $(LINK_OPTS) $^ -o $@ $(FBEMBED_LINK) $(LIB_GUI) $(LINK_LIBS) diff --git a/databases/firebird20-server/files/patch-src::install::arch-specific::freebsd::install.sh.in b/databases/firebird20-server/files/patch-src::install::arch-specific::freebsd::install.sh.in deleted file mode 100644 index 03df0f2e369c..000000000000 --- a/databases/firebird20-server/files/patch-src::install::arch-specific::freebsd::install.sh.in +++ /dev/null @@ -1,42 +0,0 @@ ---- src/install/arch-specific/freebsd/install.sh.in.orig Tue Apr 26 07:14:26 2005 -+++ src/install/arch-specific/freebsd/install.sh.in Tue Apr 26 07:15:05 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 -@@ -284,25 +277,6 @@ - [ -f aliases.conf ] || install -o $fbUID -g $fbGID -m 444 aliases.conf.sample aliases.conf - [ -f firebird.conf ] || install -o $fbUID -g $fbGID -m 444 firebird.conf.sample firebird.conf - [ -f security.fdb ] || install -o $fbUID -g $fbGID -m 660 security.fdb.sample security.fdb -- --# remove any existing gds service --cp /etc/services /etc/services.old --cp /etc/inetd.conf /etc/inetd.conf.old --cat /etc/services |grep -v gds_db >/etc/services.new --cat /etc/inetd.conf |grep -v gds_db >/etc/inetd.conf.new --mv /etc/services.new /etc/services --mv /etc/inetd.conf.new /etc/inetd.conf -- --# add the gds service and restart inetd --cat >>/etc/services <<EOF --gds_db 3050/tcp #InterBase Database Remote Protocol --EOF --cat >>/etc/inetd.conf <<EOF --gds_db stream tcp nowait firebird $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/firebird20-server/files/pkg-install.in b/databases/firebird20-server/files/pkg-install.in new file mode 100644 index 000000000000..d442ff99ee3f --- /dev/null +++ b/databases/firebird20-server/files/pkg-install.in @@ -0,0 +1,70 @@ +#!/bin/sh + +PATH=/sbin:/usr/sbin:/usr/local/sbin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin:%%PREFIX%%/bin +PREFIX=%%PREFIX%% +DB_DIR=%%PREFIX%% + +USER=firebird +GROUP=${USER} +UID=3050 +GID=${UID} +HOME=${DB_DIR} +DESCR="Firebird Database Administrator" + +case $2 in +PRE-INSTALL) + if pw group show "${GROUP}" 2> /dev/null; then + echo "You already have a group \"${GROUP}\", so I will use it." + else + if pw groupadd ${GROUP} -g ${GID}; then + echo "Added group \"${GROUP}\"." + else + echo "Adding group \"${GROUP}\" failed..." + exit 1 + fi + fi + + if pw user show "${USER}" 2> /dev/null; then + echo "You already have a user \"${USER}\", so I will use it." + + if pw usermod ${USER} -d ${HOME}; then + echo "Changed home directory of \"${USER}\" to \"${HOME}\"" + else + echo "Changing home directory of \"${USER}\" to \"${HOME}\" failed..." + exit 1 + fi + else + if pw useradd ${USER} -u ${UID} -g ${GROUP} -h - -d ${NOME} -s /sbin/nologin -c "${DESCR}" ; then + echo "Added user \"${USER}\"." + else + echo "Adding user \"${USER}\" failed..." + exit 1 + fi + fi + ;; + +POST-INSTALL) + for f in isc_init1.`hostname` isc_lock1.`hostname` isc_event1.`hostname` firebird.log + do + touch ${PREFIX}/${f} + chown ${USER}:${GROUP} ${PREFIX}/$f + chmod 660 ${PREFIX}/${f} + done + + # add the gds service and restart inetd + cat /etc/services | grep -v gds_db > /etc/services.new + cat >>/etc/services.new <<EOF +gds_db 3050/tcp #InterBase Database Remote Protocol +EOF + mv /etc/services.new /etc/services + + cat /etc/inetd.conf | grep -v gds_db > /etc/inetd.conf.new + cat >>/etc/inetd.conf.new <<EOF +gds_db stream tcp nowait firebird ${PREFIX}/bin/fb_inet_server fb_inet_server +EOF + mv /etc/inetd.conf.new /etc/inetd.conf + + if [ -f /var/run/inetd.pid ]; then + kill -HUP `cat /var/run/inetd.pid` + fi +esac diff --git a/databases/firebird-server/pkg-message b/databases/firebird20-server/files/pkg-message.in index 02894da409f2..2cab9049eba5 100644 --- a/databases/firebird-server/pkg-message +++ b/databases/firebird20-server/files/pkg-message.in @@ -1,20 +1,8 @@ - --------------------------------------------------------- -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. +Firebird is now installed. A symbolic link from +/usr/interbase -> %%PREFIX%%/firebird may be needed +for compatibility with existing programs that use +Firebird. The symbolic link can be created with: @@ -32,4 +20,3 @@ before doing anything serious with Firebird. See %%PREFIX%%/firebird/RELNOTES for more. --------------------------------------------------------- - diff --git a/databases/firebird20-server/pkg-install b/databases/firebird20-server/pkg-install deleted file mode 100644 index e716ae8fa917..000000000000 --- a/databases/firebird20-server/pkg-install +++ /dev/null @@ -1,145 +0,0 @@ -#!/bin/sh - -# $FreeBSD$ - -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.1 libgds.so.1 - -cd $PKG_PREFIX/firebird/bin -for i in `ls` -do - chmod ug=rx,o= $i -done - -chmod a=rx isql qli - -# SUID is needed for running server programs. -for i in fb_lock_mgr gds_drop fb_inet_server -do - if [ -f $i ]; then - chmod ug=rx,o= $i - chmod ug+s $i - fi -done - - -cd $PKG_PREFIX/firebird - -# Lock files - -for i in isc_init1 isc_lock1 isc_event1 -do - FileName=$i.`hostname` - touch $FileName - chmod uga=rw $FileName - chown firebird:firebird $FileName -done - -touch firebird.log -chown firebird:firebird firebird.log -chmod ug=rw,o= firebird.log -chmod a=r firebird.msg README -chown root:wheel *.sample -chmod ug=r,o= *.sample - -# make databases writable by firebird only -# local database connections are not a good idea -chmod ug=rw,o= examples/*.fdb -chmod ug=rw,o= help/*.fdb -chmod ug=rw,o= security.fdb - -chmod 444 aliases.conf firebird.conf -chmod 660 security.fdb - -# shared lib startup script -if [ -d $PKG_PREFIX/etc/rc.d ]; then - ( - echo "#!/bin/sh"; echo "[ -d $PKG_PREFIX/firebird/lib ] && /sbin/ldconfig -m $PKG_PREFIX/firebird/lib" - ) > $PKG_PREFIX/etc/rc.d/000.firebird.sh - chmod a=rx $PKG_PREFIX/etc/rc.d/000.firebird.sh -fi -;; - -esac diff --git a/databases/firebird20-server/pkg-message b/databases/firebird20-server/pkg-message deleted file mode 100644 index 02894da409f2..000000000000 --- a/databases/firebird20-server/pkg-message +++ /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%%/firebird /usr/interbase - -It is STRONGLY recommended that you change the SYSDBA -password with: - -% cd %%PREFIX%%/firebird -% gsec -user SYSDBA -pass masterkey -GSEC> modify SYSDBA -pw newpassword -GSEC> quit - -before doing anything serious with Firebird. - -See %%PREFIX%%/firebird/RELNOTES for more. ---------------------------------------------------------- - diff --git a/databases/firebird20-server/pkg-plist b/databases/firebird20-server/pkg-plist index b6212232a3a4..43e32f04ced0 100644 --- a/databases/firebird20-server/pkg-plist +++ b/databases/firebird20-server/pkg-plist @@ -1,130 +1,28 @@ -etc/rc.d/000.firebird.sh -firebird/README firebird/RELNOTES firebird/UDF/fbudf.so firebird/UDF/fbudf.sql firebird/UDF/ib_udf.so firebird/UDF/ib_udf.sql -firebird/WhatsNew @unexec if cmp -s %D/firebird/aliases.conf %D/firebird/aliases.conf.sample; then rm -f %D/firebird/aliases.conf; fi firebird/aliases.conf.sample @exec [ -f %B/aliases.conf ] || cp %B/%f %B/aliases.conf firebird/bin/fb_inet_server firebird/bin/fb_lock_mgr -firebird/bin/fb_lock_print -firebird/bin/gbak -firebird/bin/gdef -firebird/bin/gds_drop -firebird/bin/gfix -firebird/bin/gpre -firebird/bin/gsec -firebird/bin/gstat -firebird/bin/isql -firebird/bin/qli -firebird/doc/README.NTSecurity -firebird/doc/README.Win32LibraryInstallation.txt -firebird/doc/README.build.mingw.html -firebird/doc/README.build.msvc.html -firebird/doc/README.install.Solaris_on_Intel -firebird/doc/README.instsvc -firebird/doc/README.makefiles -firebird/doc/README.user -firebird/doc/README.user.embedded -firebird/doc/README.user.troubleshooting -firebird/doc/sql.extensions/README.aggregate_tracking -firebird/doc/sql.extensions/README.case -firebird/doc/sql.extensions/README.coalesce -firebird/doc/sql.extensions/README.context_variables -firebird/doc/sql.extensions/README.data_types -firebird/doc/sql.extensions/README.exception_handling -firebird/doc/sql.extensions/README.execute_statement -firebird/doc/sql.extensions/README.explicit_locks -firebird/doc/sql.extensions/README.nullif -firebird/doc/sql.extensions/README.order_by_expressions_nulls -firebird/doc/sql.extensions/README.savepoints -firebird/doc/sql.extensions/README.universal_triggers -firebird/examples/align.h -firebird/examples/api1.c -firebird/examples/api10.c -firebird/examples/api11.c -firebird/examples/api12.c -firebird/examples/api13.c -firebird/examples/api14.e -firebird/examples/api15.c -firebird/examples/api16.c -firebird/examples/api16t.c -firebird/examples/api2.c -firebird/examples/api3.c -firebird/examples/api4.c -firebird/examples/api5.c -firebird/examples/api6.c -firebird/examples/api7.c -firebird/examples/api8.c -firebird/examples/api9.c -firebird/examples/api9f.c -firebird/examples/api9f.sql -firebird/examples/apifull.c -firebird/examples/dyn1.e -firebird/examples/dyn2.e -firebird/examples/dyn3.e -firebird/examples/dyn4.e -firebird/examples/dyn5.e -firebird/examples/dynfull.e -firebird/examples/employe2.sql -firebird/examples/employee.fdb -firebird/examples/employee.gbk -firebird/examples/example.h -firebird/examples/readme -firebird/examples/stat1.e -firebird/examples/stat10.e -firebird/examples/stat11.e -firebird/examples/stat12.e -firebird/examples/stat12t.e -firebird/examples/stat2.e -firebird/examples/stat3.e -firebird/examples/stat4.e -firebird/examples/stat5.e -firebird/examples/stat6.e -firebird/examples/stat7.e -firebird/examples/stat8.e -firebird/examples/stat9.e -firebird/examples/udf.sql -firebird/examples/udflib.c @unexec if cmp -s %D/firebird/firebird.conf %D/firebird/firebird.conf.sample; then rm -f %D/firebird/firebird.conf; fi firebird/firebird.conf.sample @exec [ -f %B/firebird.conf ] || cp %B/%f %B/firebird.conf @unexec [ -s %D/firebird/firebird.log ] || rm -f %D/firebird/firebird.log firebird/firebird.msg firebird/help/help.fdb -firebird/include/blr.h -firebird/include/gds.h -firebird/include/ib_util.h -firebird/include/ibase.h -firebird/include/iberror.h -firebird/include/perf.h firebird/intl/fbintl @unexec rm -f %D/firebird/isc_event1.`hostname` @unexec rm -f %D/firebird/isc_init1.`hostname` @unexec rm -f %D/firebird/isc_lock1.`hostname` -firebird/lib/libfbclient.so -firebird/lib/libfbclient.so.1 -firebird/lib/libfbclient.so.%%FIREBIRD_VERSION%% -firebird/lib/libfbembed.so -firebird/lib/libfbembed.so.1 -firebird/lib/libfbembed.so.%%FIREBIRD_VERSION%% -firebird/lib/libgds.so -firebird/lib/libgds.so.1 -firebird/lib/libib_util.so @unexec if cmp -s %D/firebird/security.fdb %D/firebird/security.fdb.sample; then rm -f %D/firebird/security.fdb; fi firebird/security.fdb.sample @exec [ -f %B/security.fdb ] || cp %B/%f %B/security.fdb @dirrm firebird/UDF @dirrm firebird/bin -@dirrm firebird/doc/sql.extensions -@dirrm firebird/doc -@dirrm firebird/examples @dirrm firebird/help -@dirrm firebird/include @dirrm firebird/intl -@dirrm firebird/lib @dirrm firebird diff --git a/databases/firebird20-server/pkg-plist.client b/databases/firebird20-server/pkg-plist.client new file mode 100644 index 000000000000..3f302be5fd42 --- /dev/null +++ b/databases/firebird20-server/pkg-plist.client @@ -0,0 +1,99 @@ +bin/fb_lock_print +bin/gbak +bin/gdef +bin/gds_drop +bin/gfix +bin/gpre +bin/gsec +bin/gstat +bin/isql +bin/qli +include/blr.h +include/gds.h +include/ib_util.h +include/ibase.h +include/iberror.h +include/perf.h +lib/libfbclient.so +lib/libfbclient.so.1 +lib/libfbclient.so.%%FIREBIRD_VERSION%% +lib/libfbembed.so +lib/libfbembed.so.1 +lib/libfbembed.so.%%FIREBIRD_VERSION%% +lib/libgds.so +lib/libgds.so.1 +lib/libib_util.so +%%DOCSDIR%%/README.NTSecurity +%%DOCSDIR%%/README.Win32LibraryInstallation.txt +%%DOCSDIR%%/README.build.mingw.html +%%DOCSDIR%%/README.build.msvc.html +%%DOCSDIR%%/README.install.Solaris_on_Intel +%%DOCSDIR%%/README.instsvc +%%DOCSDIR%%/README.makefiles +%%DOCSDIR%%/README.user +%%DOCSDIR%%/README.user.embedded +%%DOCSDIR%%/README.user.troubleshooting +%%DOCSDIR%%/README +%%DOCSDIR%%/WhatsNew +%%DOCSDIR%%/sql.extensions/README.aggregate_tracking +%%DOCSDIR%%/sql.extensions/README.case +%%DOCSDIR%%/sql.extensions/README.coalesce +%%DOCSDIR%%/sql.extensions/README.context_variables +%%DOCSDIR%%/sql.extensions/README.data_types +%%DOCSDIR%%/sql.extensions/README.exception_handling +%%DOCSDIR%%/sql.extensions/README.execute_statement +%%DOCSDIR%%/sql.extensions/README.explicit_locks +%%DOCSDIR%%/sql.extensions/README.nullif +%%DOCSDIR%%/sql.extensions/README.order_by_expressions_nulls +%%DOCSDIR%%/sql.extensions/README.savepoints +%%DOCSDIR%%/sql.extensions/README.universal_triggers +%%EXAMPLESDIR%%/align.h +%%EXAMPLESDIR%%/api1.c +%%EXAMPLESDIR%%/api10.c +%%EXAMPLESDIR%%/api11.c +%%EXAMPLESDIR%%/api12.c +%%EXAMPLESDIR%%/api13.c +%%EXAMPLESDIR%%/api14.e +%%EXAMPLESDIR%%/api15.c +%%EXAMPLESDIR%%/api16.c +%%EXAMPLESDIR%%/api16t.c +%%EXAMPLESDIR%%/api2.c +%%EXAMPLESDIR%%/api3.c +%%EXAMPLESDIR%%/api4.c +%%EXAMPLESDIR%%/api5.c +%%EXAMPLESDIR%%/api6.c +%%EXAMPLESDIR%%/api7.c +%%EXAMPLESDIR%%/api8.c +%%EXAMPLESDIR%%/api9.c +%%EXAMPLESDIR%%/api9f.c +%%EXAMPLESDIR%%/api9f.sql +%%EXAMPLESDIR%%/apifull.c +%%EXAMPLESDIR%%/dyn1.e +%%EXAMPLESDIR%%/dyn2.e +%%EXAMPLESDIR%%/dyn3.e +%%EXAMPLESDIR%%/dyn4.e +%%EXAMPLESDIR%%/dyn5.e +%%EXAMPLESDIR%%/dynfull.e +%%EXAMPLESDIR%%/employe2.sql +%%EXAMPLESDIR%%/employee.fdb +%%EXAMPLESDIR%%/employee.gbk +%%EXAMPLESDIR%%/example.h +%%EXAMPLESDIR%%/readme +%%EXAMPLESDIR%%/stat1.e +%%EXAMPLESDIR%%/stat10.e +%%EXAMPLESDIR%%/stat11.e +%%EXAMPLESDIR%%/stat12.e +%%EXAMPLESDIR%%/stat12t.e +%%EXAMPLESDIR%%/stat2.e +%%EXAMPLESDIR%%/stat3.e +%%EXAMPLESDIR%%/stat4.e +%%EXAMPLESDIR%%/stat5.e +%%EXAMPLESDIR%%/stat6.e +%%EXAMPLESDIR%%/stat7.e +%%EXAMPLESDIR%%/stat8.e +%%EXAMPLESDIR%%/stat9.e +%%EXAMPLESDIR%%/udf.sql +%%EXAMPLESDIR%%/udflib.c +@dirrm %%DOCSDIR%%/sql.extensions +@dirrm %%DOCSDIR%% +@dirrm %%EXAMPLESDIR%% |