Date: Sat, 29 May 2004 05:52:36 +0300 From: Andrey Slusar <vasallia@ukr.net> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/67319: [NEW PORT] databases/msql3: Version 3 of the Mini SQL relational database system Message-ID: <E1BTtxc-000Cjv-If@santinel.home.ua> Resent-Message-ID: <200405290300.i4T30aHm044605@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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@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@Bond.edu.au X X-INST_DIR=/usr/local/Minerva X-ADMIN="you@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@ukr.net> X# X# $FreeBSD$ X# X XPORTNAME= msql XPORTVERSION= 3.5 XCATEGORIES= databases X XMAINTAINER= vasallia@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@dirrm etc/msql3 X@dirrm share/msql3/makegen X@dirrm share/msql3 X@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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?E1BTtxc-000Cjv-If>