ports/67319: [NEW PORT] databases/msql3: Version 3 of the Mini SQL relational database system

Andrey Slusar vasallia at ukr.net
Sat May 29 03:01:19 UTC 2004


>Number:         67319
>Category:       ports
>Synopsis:       [NEW PORT] databases/msql3: Version 3 of the Mini SQL relational database system
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Fri May 28 20:00:36 PDT 2004
>Closed-Date:
>Last-Modified:
>Originator:     Andrey Slusar
>Release:        FreeBSD 5.2-CURRENT i386
>Organization:
Santinel
>Environment:
System: FreeBSD santinel.home.ua 5.2-CURRENT FreeBSD 5.2-CURRENT #1: Fri May 28 16:44:48 EEST 2004 root at santinel.home.ua:/usr/obj/usr/src/sys/ANRAY i386
>Description:

 In README:

What's New
----------

The following features have been added or improved since the second
generation of this product

* Two versions of the server are included in this release: a single
process server similar to the mSQL 2.x server called msql3d, and a 
new multi-process server called msql3_broker.  The broker based server
can handle multiple queries simultaneously by spreading the queries over
a farm of backend procsses.  However, there is a performance overhead
involved so the single procss server should be used unless you
specifically require the extra functionality of the broker based server.

* Several new data types are supported in this release.  Integers of 8
bits, 16 bits, 32 bits and 64 bits are supported using the int8, int16,
int32 and int64 data types.  Native support for Internet Protocol
addresses (IP Version 4 addresses) is also included using the ipv4 type.

* Support for value functions (not aggregate functions) has been
included.  String functions available in this release include UPPER, LOWER,
LENGTH, SUBSTR, TRANSLATE, REPLACE and SOUNDEX.  Numeric functions
included are ABS, CEIL, FLOOR, MOD, SIGN, and POWER

* Support for result tables is now available using the SELECT INTO
construct.  A query such as "SELECT * INTO young FROM staff WHERE age < 30"
would create a new table called 'young' countaining the results of the
specified query.  Please remember that the result tables are not
transient tables.  They must be DROPed if you want to remove them.

* Index range support has been included, as has support for the BETWEEN
operator.  Queries that use range based conditions, such as < <= > >=
and BETWEEN, on an indexed field will now see a significant increase
in performance.

* The code has been modularised to greatly reduce the internal
complexity of the code.  Each module has been reviewed with respect to
efficiency and reliability.  The servers are now smaller, faster, and
more resilient than the 2.x servers.  In fact, in normal benchmark
testing, the single process server is more than twice as fast as the
last of the 2.0.x release servers.

>How-To-Repeat:
	N/A
>Fix:

--- msql3.port begins here ---
# This is a shell archive.  Save it in a file, remove anything before
# this line, and then unpack it by entering "sh file".  Note, it may
# create directories; files and directories will be owned by you and
# have default permissions.
#
# This archive contains:
#
#	/usr/ports/databases/msql3/
#	/usr/ports/databases/msql3/files
#	/usr/ports/databases/msql3/files/patch-setup
#	/usr/ports/databases/msql3/files/patch-config.c
#	/usr/ports/databases/msql3/files/patch-libmsql::Makefile.tmpl
#	/usr/ports/databases/msql3/files/patch-msql.conf
#	/usr/ports/databases/msql3/files/patch-acl.c
#	/usr/ports/databases/msql3/files/patch-run-daemon
#	/usr/ports/databases/msql3/files/patch-main.c
#	/usr/ports/databases/msql3/files/patch-msqld::regexp::Makefile.tmpl
#	/usr/ports/databases/msql3/files/patch-Makefile.tmpl
#	/usr/ports/databases/msql3/files/patch-msqld::main::Makefile.tmpl
#	/usr/ports/databases/msql3/files/msql3.sh
#	/usr/ports/databases/msql3/files/patch-site.mm.in
#	/usr/ports/databases/msql3/files/patch-make-install
#	/usr/ports/databases/msql3/files/patch-msqladmin.c
#	/usr/ports/databases/msql3/scripts
#	/usr/ports/databases/msql3/scripts/customize_scripts
#	/usr/ports/databases/msql3/pkg-deinstall
#	/usr/ports/databases/msql3/pkg-descr
#	/usr/ports/databases/msql3/Makefile
#	/usr/ports/databases/msql3/pkg-plist
#	/usr/ports/databases/msql3/pkg-install
#	/usr/ports/databases/msql3/distinfo
#
echo c - /usr/ports/databases/msql3/
mkdir -p /usr/ports/databases/msql3/ > /dev/null 2>&1
echo c - /usr/ports/databases/msql3/files
mkdir -p /usr/ports/databases/msql3/files > /dev/null 2>&1
echo x - /usr/ports/databases/msql3/files/patch-setup
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-setup << 'END-of-/usr/ports/databases/msql3/files/patch-setup'
X--- setup.old	Sat May 29 00:59:37 2004
X+++ setup	Sat May 29 00:59:58 2004
X@@ -38,18 +38,6 @@
X 	FLEX="0"
X fi
X 
X-
X-CC=cc
X-for I in `echo $PATH | sed "s/:/ /g"`
X-do
X-        if test -x "$I/gcc"
X-        then
X-                CC="$I/gcc"
X-        fi
X-done
X-
X-
X-
X echo
X echo "Using $CC for testing"
X 
END-of-/usr/ports/databases/msql3/files/patch-setup
echo x - /usr/ports/databases/msql3/files/patch-config.c
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-config.c << 'END-of-/usr/ports/databases/msql3/files/patch-config.c'
X--- src/common/config/config.c.orig	Mon Nov  4 01:34:37 2002
X+++ src/common/config/config.c	Tue May  4 17:12:15 2004
X@@ -407,11 +407,11 @@
X 	configLoaded = 1;
X 	if (file)
X 	{
X-		snprintf(buf,sizeof(buf),"%s/%s", INST_DIR, file);
X+		snprintf(buf,sizeof(buf),"%s/etc/msql3/%s", INST_DIR, file);
X 		fp = fopen(buf,"r");
X 		if (!fp)
X 		{
X-			snprintf(buf,sizeof(buf),"%s/%s.conf",INST_DIR,file);
X+			snprintf(buf,sizeof(buf),"%s/etc/msql3/%s.conf",INST_DIR,file);
X 			fp = fopen(buf,"r");
X 		}
X 		if (!fp)
X@@ -425,7 +425,7 @@
X 	}
X 	else
X 	{
X-		snprintf(buf,sizeof(buf),"%s/msql.conf", INST_DIR);
X+		snprintf(buf,sizeof(buf),"%s/etc/msql3/msql.conf", INST_DIR);
X 		fp = fopen(buf,"r");
X 	}
X 
END-of-/usr/ports/databases/msql3/files/patch-config.c
echo x - /usr/ports/databases/msql3/files/patch-libmsql::Makefile.tmpl
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-libmsql::Makefile.tmpl << 'END-of-/usr/ports/databases/msql3/files/patch-libmsql::Makefile.tmpl'
X--- src/libmsql/Makefile.tmpl.old	Fri May 28 01:06:35 2004
X+++ src/libmsql/Makefile.tmpl	Fri May 28 01:06:54 2004
X@@ -1,6 +1,6 @@
X 
X !library_unix libmsql.a libmsql.c,net_client.c,time.c ../common/libc_stuff/strlib.o,../common/libc_stuff/tmpnam.o,../common/libc_stuff/strerror.o,../common/libc_stuff/strptime.o,../common/libc_stuff/snprintf.o,../common/config/config.o,../common/types/type_time.o,../common/types/type_date.o
X 
X-!libinstall libmsql.a $(INST_DIR)/lib/libmsql.a 744 $(ROOT)
X-!install msql.h $(INST_DIR)/include/msql.h 0744
X+!libinstall libmsql.a $(INST_DIR)/lib/libmsql.a 644 $(ROOT)
X+!install msql.h $(INST_DIR)/include/msql.h 0444
X 
END-of-/usr/ports/databases/msql3/files/patch-libmsql::Makefile.tmpl
echo x - /usr/ports/databases/msql3/files/patch-msql.conf
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-msql.conf << 'END-of-/usr/ports/databases/msql3/files/patch-msql.conf'
X--- misc/msql.conf.orig	Mon Nov  4 01:34:36 2002
X+++ misc/msql.conf	Tue May  4 17:34:38 2004
X@@ -18,12 +18,12 @@
X [general]
X 
X Inst_Dir = _INST_
X-DB_Dir = %I/msqldb
X+DB_Dir = /var/db/msql3db
X mSQL_User = daemon
X Admin_User = root
X-Pid_File = %I/msql3d.pid
X+Pid_File = /var/spool/msql/msql3d.pid
X TCP_Port = 1114
X-UNIX_Port = %I/msql3.sock
X+UNIX_Port = /var/spool/msql/msql3.sock
X 
X [system]
X 
X@@ -35,7 +35,7 @@
X Local_Access = True
X Force_Munmap = False
X Query_Log = False
X-Query_Log_File = %I/query.log
X+#Query_Log_File = /var/spool/msql/query.log
X #Update_Log = False
X #Update_Log_File = %I/update.log
X Table_Cache = 8
END-of-/usr/ports/databases/msql3/files/patch-msql.conf
echo x - /usr/ports/databases/msql3/files/patch-acl.c
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-acl.c << 'END-of-/usr/ports/databases/msql3/files/patch-acl.c'
X--- src/msqld/main/acl.c.old	Tue May  4 17:41:51 2004
X+++ src/msqld/main/acl.c	Tue May  4 17:42:14 2004
X@@ -304,7 +304,7 @@
X 	/*
X 	** Open the acl file
X 	*/
X-	(void)snprintf(path,MSQL_PATH_LEN,"%s/msql.acl", 
X+	(void)snprintf(path,MSQL_PATH_LEN,"%s/etc/msql3/msql.acl", 
X 		(char *)configGetCharEntry("general", "inst_dir"));
X 	fp = fopen(path,"r");
X 	if (!fp)
END-of-/usr/ports/databases/msql3/files/patch-acl.c
echo x - /usr/ports/databases/msql3/files/patch-run-daemon
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-run-daemon << 'END-of-/usr/ports/databases/msql3/files/patch-run-daemon'
X--- scripts/run_daemon.orig	Thu Aug 19 07:33:07 1999
X+++ scripts/run_daemon	Sat Jan 27 11:08:59 2001
X@@ -9,24 +9,26 @@
X #
X #					bambi at Bond.edu.au
X 
X-INST_DIR=/usr/local/Minerva
X-ADMIN="you at some.machine"
X+umask 077
X+
X+INST_DIR=%%PREFIX%%
X+ADMIN="root@%%HOSTNAME%%"
X PROG=$1
X 
X-if test ! -d "${INST_DIR}/debug"
X+if test ! -d "/tmp/debug"
X then
X-	mkdir ${INST_DIR}/debug
X+	mkdir /tmp/debug
X fi
X 
X-if test ! -d "${INST_DIR}/debug/${PROG}"
X+if test ! -d "/tmp/debug/${PROG}"
X then
X-	mkdir ${INST_DIR}/debug/${PROG}
X+	mkdir /tmp/debug/${PROG}
X fi
X 
X while :
X do
X-	cd ${INST_DIR}/debug/${PROG}
X-	${INST_DIR}/bin/${PROG} > output 2>&1
X+	cd /tmp/debug/${PROG}
X+	${INST_DIR}/sbin/${PROG} > output 2>&1
X 	echo "Program : ${PROG}
X Time : `date`
X Program Output
X@@ -34,6 +36,6 @@
X 
X " > mail.tmp
X 	cat output >> mail.tmp
X-	/usr/ucb/mail -s "Minerva Daemon Crash Report" ${ADMIN} < mail.tmp
X+	/usr/bin/mail -s "Minerva Daemon Crash Report" ${ADMIN} < mail.tmp
X 	sleep 15
X done
END-of-/usr/ports/databases/msql3/files/patch-run-daemon
echo x - /usr/ports/databases/msql3/files/patch-main.c
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-main.c << 'END-of-/usr/ports/databases/msql3/files/patch-main.c'
X--- src/msqld/main/main.c.old	Tue May  4 17:21:52 2004
X+++ src/msqld/main/main.c	Tue May  4 17:22:26 2004
X@@ -1033,7 +1033,7 @@
X 
X 	if (*confFile == 0)
X 	{
X-		snprintf(confFile,sizeof(confFile),"%s/msql.conf", INST_DIR);
X+		snprintf(confFile,sizeof(confFile),"%s/etc/msql3/msql.conf", INST_DIR);
X 	}
X 	printf("\tLoading configuration from '%s'.\n",confFile);
X 	configLoadFile(confFile);
END-of-/usr/ports/databases/msql3/files/patch-main.c
echo x - /usr/ports/databases/msql3/files/patch-msqld::regexp::Makefile.tmpl
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-msqld::regexp::Makefile.tmpl << 'END-of-/usr/ports/databases/msql3/files/patch-msqld::regexp::Makefile.tmpl'
X--- src/msqld/regexp/Makefile.tmpl.old	Fri May 28 01:02:46 2004
X+++ src/msqld/regexp/Makefile.tmpl	Fri May 28 01:03:44 2004
X@@ -21,8 +21,8 @@
X !library_unix libregexp.a regexp.c,regsub.c
X !library_os2 libregexp.a regexp.c,regsub.c
X 
X-!libinstall libregexp.a $(INST_DIR)/lib/libregexp.a 744 $(ROOT)
X-!install regexp.h $(INST_DIR)/include/regexp.h 744 $(ROOT)
X+!libinstall libregexp.a $(INST_DIR)/lib/libregexp.a 644 $(ROOT)
X+!install regexp.h $(INST_DIR)/include/regexp.h 444 $(ROOT)
X 
X 
X all : libregexp.a
END-of-/usr/ports/databases/msql3/files/patch-msqld::regexp::Makefile.tmpl
echo x - /usr/ports/databases/msql3/files/patch-Makefile.tmpl
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-Makefile.tmpl << 'END-of-/usr/ports/databases/msql3/files/patch-Makefile.tmpl'
X--- src/Makefile.tmpl.orig	Fri Aug 23 01:36:26 2002
X+++ src/Makefile.tmpl	Sat May 29 04:12:49 2004
X@@ -35,22 +35,22 @@
X 	echo
X 
X install ::
X-	@cp ../README* $(INST_DIR);\\
X-	cp makegen/makegen makegen/*.cf makegen/*.mm $(INST_DIR)/makegen;\\
X-	chmod 755 $(INST_DIR)/makegen/*;\\
X-	cp site.mm $(INST_DIR)/makegen;\\
X-        if test -f $(INST_DIR)/msql.conf;\
X+	@cp ../README $(INST_DIR)/share/doc/msql3;\\
X+	cp ../RELEASE_NOTES $(INST_DIR)/share/doc/msql3;\\
X+	cp ../BUGS $(INST_DIR)/share/doc/msql3;\\
X+	cp ../doc/License $(INST_DIR)/share/doc/msql3;\\
X+	cp ../doc/Manual $(INST_DIR)/share/doc/msql3;\\
X+	cp ../doc/Perl $(INST_DIR)/share/doc/msql3;\\
X+	cp ../doc/acl.txt $(INST_DIR)/share/doc/msql3;\\
X+	cp makegen/makegen makegen/*.cf makegen/*.mm $(INST_DIR)/share/msql3/makegen;\\
X+	chmod 755 $(INST_DIR)/share/msql3/makegen/*;\\
X+	cp site.mm $(INST_DIR)/share/msql3/makegen;\\
X+        if test -f $(INST_DIR)/etc/msql3/msql.conf;\
X         then\
X-                rm -f $(INST_DIR)/msql.conf.old;\
X-                mv $(INST_DIR)/msql.conf $(INST_DIR)/msql.conf.old;\
X+                rm -f $(INST_DIR)/etc/msql3/msql.conf.old;\
X+                mv $(INST_DIR)/etc/msql3/msql.conf $(INST_DIR)/etc/msql3/msql.conf.old;\
X         fi;\
X-	sed "s,_INST_,$(INST_DIR),"< ../misc/msql.conf >$(INST_DIR)/msql.conf;\\
X-	echo ;\\
X-	echo ;\\
X-	echo ;\\
X-	echo "Setting directory ownership";\\
X-	chown daemon $(INST_DIR);\\
X-	chown -R daemon $(INST_DIR)/msqldb;\\
X+	sed "s,_INST_,$(INST_DIR),"< ../misc/msql.conf >$(INST_DIR)/etc/msql3/msql.conf;\\
X 	echo ;\\
X 	echo ;\\
X 	echo ;\\
END-of-/usr/ports/databases/msql3/files/patch-Makefile.tmpl
echo x - /usr/ports/databases/msql3/files/patch-msqld::main::Makefile.tmpl
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-msqld::main::Makefile.tmpl << 'END-of-/usr/ports/databases/msql3/files/patch-msqld::main::Makefile.tmpl'
X--- src/msqld/main/Makefile.tmpl.old	Wed May  5 00:17:37 2004
X+++ src/msqld/main/Makefile.tmpl	Wed May  5 00:18:06 2004
X@@ -35,7 +35,7 @@
X 
X !program msql3d yaccer.o,lexer.o,parse.o,process.o,index.o,table.o,regex.o,select.o,sysvar.o,varchar.o,compare.o,distinct.o,acl.o,sort.o,cache.o,util.o,net.o,main.o,funct.o,memory.o,tcp.o,../../common/debug/debug.o,../../common/config/config.o,../../common/libc_stuff/strtoul.o,../../common/libc_stuff/tmpnam.o,../regexp/libregexp.a,../index/libidx.a,../../common/types/libtypes.a,../broker/libbroker.a,../cra/libcra.a,../lock/liblock.a,../../libmsql/libmsql.a
X 
X-!install msql3d $(INST_DIR)/bin/msql3d 0755
X+!install msql3d $(INST_DIR)/sbin/msql3d 0755
X !install msql3_broker $(INST_DIR)/bin/msql3_broker 0755
X 
X 
END-of-/usr/ports/databases/msql3/files/patch-msqld::main::Makefile.tmpl
echo x - /usr/ports/databases/msql3/files/msql3.sh
sed 's/^X//' >/usr/ports/databases/msql3/files/msql3.sh << 'END-of-/usr/ports/databases/msql3/files/msql3.sh'
X#!/bin/sh
X
Xif ! PREFIX=$(expr $0 : "\(/.*\)/etc/rc\.d/$(basename $0)\$"); then
X    echo "$0: Cannot determine the PREFIX" >&2
X    exit 1
Xfi
X
Xcase "$1" in
Xstart)
X	if [ -x ${PREFIX}/sbin/msql3d ]; then
X		su -f msql -c "exec ${PREFIX}/sbin/msql3d" > /dev/null 2>&1 &
X		echo -n ' msql3'
X	fi
X	;;
Xstop)
X	killall msql3d && echo -n ' msql3d' && rm -f ${PREFIX}/etc/msql3/msql3d.pid
X	;;
X*)
X	echo "Usage: `basename $0` {start|stop}" >&2
X	;;
Xesac
X
Xexit 0
END-of-/usr/ports/databases/msql3/files/msql3.sh
echo x - /usr/ports/databases/msql3/files/patch-site.mm.in
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-site.mm.in << 'END-of-/usr/ports/databases/msql3/files/patch-site.mm.in'
X--- conf/site.mm.in.old	Tue May  4 16:50:06 2004
X+++ conf/site.mm.in	Tue May  4 16:53:20 2004
X@@ -3,8 +3,8 @@
X #
X 
X 
X-COMPILER= @CC@ @WALL@
X-INST_DIR= /usr/local/msql3
X+COMPILER= @CC@
X+INST_DIR= $(PREFIX)
X HAVE_DYNAMIC= -DHAVE_DYNAMIC
X CC_ONLY_FLAGS=
X LINK_ONLY_FLAGS= @LINUX_DYNAMIC@
X@@ -33,5 +33,5 @@
X # Directory for pid file
X PID_DIR= @PID_DIR@
X 
X-CFLAGS= -O -I$(TOP)/ $(EXTRA_CFLAGS) -D$(OS_TYPE)
X+CFLAGS+= -I$(TOP)/ $(EXTRA_CFLAGS) -D$(OS_TYPE) -fpic -DPIC
X LDLIBS= -L$(TOP)/lib $(EXTRA_LIB)
END-of-/usr/ports/databases/msql3/files/patch-site.mm.in
echo x - /usr/ports/databases/msql3/files/patch-make-install
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-make-install << 'END-of-/usr/ports/databases/msql3/files/patch-make-install'
X--- scripts/make-install.orig	Mon Feb  5 13:37:55 2001
X+++ scripts/make-install	Sat May 29 01:23:29 2004
X@@ -1,16 +1,12 @@
X #!/bin/sh
X 
X-INST_DIR=$1
X+INST_DIR=$PREFIX
X 
X-scripts/mkinstalldirs 0755    $INST_DIR/bin 
X-scripts/mkinstalldirs 0755    $INST_DIR/include 
X scripts/mkinstalldirs 0755    $INST_DIR/include/common
X-scripts/mkinstalldirs 0755    $INST_DIR/lib
X-scripts/mkinstalldirs 0755    $INST_DIR/msqldb
X-scripts/mkinstalldirs 0755    $INST_DIR/msqldb/.tmp
X-scripts/mkinstalldirs 0755    $INST_DIR/doc
X-scripts/mkinstalldirs 0755    $INST_DIR/www
X-scripts/mkinstalldirs 0755    $INST_DIR/misc
X-scripts/mkinstalldirs 0755    $INST_DIR/makegen
X-scripts/mkinstalldirs 0755    $INST_DIR/modules
X-
X+scripts/mkinstalldirs 0755    $INST_DIR/etc/msql3
X+scripts/mkinstalldirs 0755    /var/spool/msql3
X+scripts/mkinstalldirs 0700    /var/db/msql3db
X+scripts/mkinstalldirs 0700    /var/db/msql3db/.tmp
X+scripts/mkinstalldirs 0755    $INST_DIR/share/doc/msql3
X+scripts/mkinstalldirs 0755    $INST_DIR/share/msql3/makegen
X+/usr/sbin/chown -R msql:msql /var/db/msql3db /var/spool/msql3
END-of-/usr/ports/databases/msql3/files/patch-make-install
echo x - /usr/ports/databases/msql3/files/patch-msqladmin.c
sed 's/^X//' >/usr/ports/databases/msql3/files/patch-msqladmin.c << 'END-of-/usr/ports/databases/msql3/files/patch-msqladmin.c'
X--- src/msqladmin/msqladmin.c.orig	Mon Jan 13 10:16:02 1997
X+++ src/msqladmin/msqladmin.c	Sun Jan 19 14:05:53 1997
X@@ -257,7 +257,7 @@
X 		printf("\tTarget platform \t%s\n\n",TARGET);
X 
X 		printf("Configuration Details :-\n\n");
X-		printf("\tDefault config file\t%s/msql.conf\n",INST_DIR);
X+		printf("\tDefault config file\t%s/etc/msql3/msql.conf\n",INST_DIR);
X 		printf("\tTCP socket         \t%d\n", 
X 			msqlGetIntConf("tcp_port"));
X 		printf("\tUNIX socket        \t%s\n", 
END-of-/usr/ports/databases/msql3/files/patch-msqladmin.c
echo c - /usr/ports/databases/msql3/scripts
mkdir -p /usr/ports/databases/msql3/scripts > /dev/null 2>&1
echo x - /usr/ports/databases/msql3/scripts/customize_scripts
sed 's/^X//' >/usr/ports/databases/msql3/scripts/customize_scripts << 'END-of-/usr/ports/databases/msql3/scripts/customize_scripts'
X#!/usr/bin/perl
X#
X
Xchop( $HOSTNAME=`hostname` );
X
Xsystem( "/usr/bin/perl -pi -e 's|%%PREFIX%%|$ENV{'PREFIX'}|' $ENV{'WRKSRC'}/scripts/run_daemon $ENV{'WRKSRC'}/misc/msql.conf" );
Xsystem( "/usr/bin/perl -pi -e 's|%%HOSTNAME%%|$HOSTNAME|' $ENV{'WRKSRC'}/scripts/run_daemon" );
END-of-/usr/ports/databases/msql3/scripts/customize_scripts
echo x - /usr/ports/databases/msql3/pkg-deinstall
sed 's/^X//' >/usr/ports/databases/msql3/pkg-deinstall << 'END-of-/usr/ports/databases/msql3/pkg-deinstall'
X#!/bin/sh
X# $FreeBSD$
X#
X
Xif [ "$2" != "POST-DEINSTALL" ]; then
X    exit 0
Xfi
X
XUSER=msql
X
Xif pw usershow "${USER}" 2>/dev/null 1>&2; then
X	echo "To delete MSQL user permanently, use 'pw userdel ${USER}'"
Xfi
X
Xexit 0
END-of-/usr/ports/databases/msql3/pkg-deinstall
echo x - /usr/ports/databases/msql3/pkg-descr
sed 's/^X//' >/usr/ports/databases/msql3/pkg-descr << 'END-of-/usr/ports/databases/msql3/pkg-descr'
XThis is version 3 of the Mini SQL (mSQL) relational database system.
XThe software provides a fast and efficient database system that supports
Xa supset of the ANSI SQL query language.  Application programs can use
Xthe mSQL client API library and access mSQL servers both on their local
Xmachine and over TCP/IP networks.
X
XWWW: http://www.hughes.com.au/
END-of-/usr/ports/databases/msql3/pkg-descr
echo x - /usr/ports/databases/msql3/Makefile
sed 's/^X//' >/usr/ports/databases/msql3/Makefile << 'END-of-/usr/ports/databases/msql3/Makefile'
X# New ports collection makefile for:	msql3
X# Date created:		4 May 2004
X# Whom:			Andrey Slusar <vasallia at ukr.net>
X#
X# $FreeBSD$
X#
X
XPORTNAME=	msql
XPORTVERSION=	3.5
XCATEGORIES=	databases
X
XMAINTAINER=	vasallia at ukr.net
XCOMMENT=	Version 3 of the Mini SQL relational database system
X
XINSTALLS_SHLIB=	YES
XUSE_PERL5=	YES
XUSE_REINPLACE=	YES
X
X# Not free for commercial use.
XRESTRICTED=	"restrictive copyright (no commercial use)"
X
XMAKE_ENV+=	WRKSRC=${WRKSRC}
X
Xpost-patch:
X		cd ${FILESDIR}; \
X		${REINPLACE_CMD} -e "s|'bison -y' byacc|byacc 'bison -y'|g" \
X			${WRKSRC}/conf/configure
X
Xdo-configure:
X		cd ${WRKSRC}; ${SETENV} ${MAKE_ENV} ./setup
X		@${SETENV} ${MAKE_ENV} ${PERL} ${SCRIPTDIR}/customize_scripts
X
Xpre-install:
X		@${SETENV} PKG_PREFIX=${PREFIX} ${SH} ${PKGINSTALL} ${PKGNAME} PRE-INSTALL
X
Xpost-install:
X		@${INSTALL_SCRIPT} ${WRKSRC}/scripts/run_daemon ${PREFIX}/bin
X		@for f in msqladmin msqlimport msqlexport; do\
X			${CHGRP} msql ${PREFIX}/bin/${f}; \
X		done
X		${CHGRP} msql ${PREFIX}/sbin/msql3d
X		@${CHMOD} 751 ${PREFIX}/etc/msql3/
X		@${CHOWN} -R msql:msql ${PREFIX}/etc/msql3/
X		@${MKDIR} ${PREFIX}/etc/rc.d
X		@if [ ! -f ${PREFIX}/etc/rc.d/msql3.sh ]; then \
X			${ECHO_MSG} "Installing ${PREFIX}/etc/rc.d/msql3.sh startup file."; \
X			${INSTALL_SCRIPT} -m 751 ${FILESDIR}/msql3.sh \
X				${PREFIX}/etc/rc.d/msql3.sh; \
X		fi
X
X.include <bsd.port.pre.mk>
X
X.if !exists(${DISTDIR}/${DISTNAME}${EXTRACT_SUFX})
XIGNORE="- You must manually obtain ${DISTFILES} from 'http://www.Hughes.com.au/download/' and place it in ${DISTDIR}.  The distribution requires registration prior to use"
X.endif
X
X.include <bsd.port.post.mk>
END-of-/usr/ports/databases/msql3/Makefile
echo x - /usr/ports/databases/msql3/pkg-plist
sed 's/^X//' >/usr/ports/databases/msql3/pkg-plist << 'END-of-/usr/ports/databases/msql3/pkg-plist'
Xbin/msql
Xbin/msql3_broker
Xbin/msqladmin
Xbin/msqldump
Xbin/msqlexplain
Xbin/msqlexport
Xbin/msqlimport
Xbin/relshow
Xbin/run_daemon
Xsbin/msql3d
Xetc/msql3/msql.conf
Xetc/rc.d/msql3.sh
Xinclude/msql.h
Xinclude/regexp.h
Xlib/libmsql.a
Xlib/libregexp.a
Xshare/msql3/makegen/directory.mm
Xshare/msql3/makegen/dll_os2.mm
Xshare/msql3/makegen/install.mm
Xshare/msql3/makegen/lex.mm
Xshare/msql3/makegen/libinstall.mm
Xshare/msql3/makegen/library_os2.mm
Xshare/msql3/makegen/library_unix.mm
Xshare/msql3/makegen/makegen
Xshare/msql3/makegen/makegen.cf
Xshare/msql3/makegen/object.mm
Xshare/msql3/makegen/program.mm
Xshare/msql3/makegen/site.mm
Xshare/msql3/makegen/touch.mm
Xshare/msql3/makegen/yacc.mm
Xshare/doc/msql3/BUGS
Xshare/doc/msql3/README
Xshare/doc/msql3/RELEASE_NOTES
Xshare/doc/msql3/License
Xshare/doc/msql3/Manual
Xshare/doc/msql3/Perl
Xshare/doc/msql3/acl.txt
X at dirrm etc/msql3
X at dirrm share/msql3/makegen
X at dirrm share/msql3
X at dirrm share/doc/msql3
END-of-/usr/ports/databases/msql3/pkg-plist
echo x - /usr/ports/databases/msql3/pkg-install
sed 's/^X//' >/usr/ports/databases/msql3/pkg-install << 'END-of-/usr/ports/databases/msql3/pkg-install'
X#!/bin/sh
X# $FreeBSD$
X#
X
Xif [ "$2" != "PRE-INSTALL" ]; then
X    exit 0
Xfi
X
XUSER=msql
XGROUP=${USER}
XUID=98
XGID=${UID}
X
Xif ! pw groupshow "${GROUP}" 2>/dev/null 1>&2; then
X	if pw groupadd ${GROUP} -g ${GID}; then
X		echo "Added group \"${GROUP}\"."
X	else
X		echo "Adding group \"${GROUP}\" failed..."
X		exit 1
X	fi
Xfi
X
Xif ! pw usershow "${USER}" 2>/dev/null 1>&2; then
X	if pw useradd ${USER} -u ${UID} -g ${GROUP} -h - \
X		-s "/bin/sh" -d "/var/db/msql3db" \
X		-c "mSQL-3 pseudo-user"; \
X	then
X		echo "Added user \"${USER}\"."
X	else
X		echo "Adding user \"${USER}\" failed..."
X		exit 1
X	fi
Xfi
Xexit 0
END-of-/usr/ports/databases/msql3/pkg-install
echo x - /usr/ports/databases/msql3/distinfo
sed 's/^X//' >/usr/ports/databases/msql3/distinfo << 'END-of-/usr/ports/databases/msql3/distinfo'
XMD5 (msql-3.5.tar.gz) = 8dab6a55adc5998c154000f88fba18ba
XSIZE (msql-3.5.tar.gz) = 321460
END-of-/usr/ports/databases/msql3/distinfo
exit
--- msql3.port ends here ---


>Release-Note:
>Audit-Trail:
>Unformatted:



More information about the freebsd-ports-bugs mailing list