Initial addition of MySQL, a free SQL database server.

Based on pr 5601 by Ty Sarna, enhancement and upgrade to 3.21.31 by me.

12 files changed, 338 insertions, 0 deletions

diff --git a/databases/mysql/Makefile b/databases/mysql/Makefile
new file mode 100644
index 00000000000..2ebc6c677d5
--- /dev/null
+++ b/databases/mysql/Makefile
@@ -0,0 +1,35 @@
+# $NetBSD: Makefile,v 1.1 1998/06/22 10:55:21 frueauf Exp $
+#
+
+DISTNAME=	mysql-3.21.31
+CATEGORIES=	databases
+MASTER_SITES=	ftp://ftp.digex.net/pub/database/mysql/Downloads/MySQL-3.21/ \
+		ftp://ftp.netcasting.net/pub/mysql/Downloads/MySQL-3.21/
+
+MAINTAINER=	tsarna@endicor.com
+
+ONLY_FOR_ARCH=	i386 alpha
+
+NO_CDROM=	"Restrictive license."
+
+MYSQL_DATADIR?=	/var/mysql
+
+GNU_CONFIGURE=	yes
+CONFIGURE_ARGS+=--enable-shared --localstatedir=${MYSQL_DATADIR} \
+		--without-perl --without-debug
+
+USE_GMAKE=	yes
+USE_PERL5=	yes
+
+INFO_FILES=	mysql.info
+
+MAN1=		mysql.1
+
+pre-install:
+	${INSTALL_DATA} ${WRKSRC}/Docs/mysql.info ${PREFIX}/info
+
+post-install:
+	${LDCONFIG} || ${TRUE}
+	(cd ${WRKSRC}; ./scripts/mysql_install_db)
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/mysql/files/md5 b/databases/mysql/files/md5
new file mode 100644
index 00000000000..7534f9cd5c5
--- /dev/null
+++ b/databases/mysql/files/md5
@@ -0,0 +1 @@
+MD5 (mysql-3.21.31.tar.gz) = f48e7a900b27abdae92ef191fa5109c2
diff --git a/databases/mysql/patches/patch-aa b/databases/mysql/patches/patch-aa
new file mode 100644
index 00000000000..08591c4f94d
--- /dev/null
+++ b/databases/mysql/patches/patch-aa
@@ -0,0 +1,53 @@
+--- client/Makefile.in.orig	Sun May 10 17:25:18 1998
++++ client/Makefile.in	Sun Jun 14 20:15:50 1998
+@@ -149,16 +149,18 @@
+ libmysqlclient_a_LIBADD = $(mysysobjects) $(mystringsobjects) $(dbugobjects)
+ 
+ #  Dirty hack to generate names for shared objects (requires GNUmake)
+-SHLIBOBJS = ${libmysqlclient_a_SOURCES:.c=.o} ${libmysqlclient_a_LIBADD}
++SHLIBOBJS = ${libmysqlclient_a_SOURCES:.c=.so} ${libmysqlclient_a_LIBADD:.o=.so}
++
++SHVERSION = 321.30
+ 
+ CLEANFILES =		$(libmysqlclient_a_LIBADD) $(SHLIBOBJS) \
+-			libmysqlclient.so libmysqlclient.so.@VERSION@
++			libmysqlclient.so libmysqlclient.so.${SHVERSION}
+ 
+ DEFS =			-DUNDEF_THREADS_HACK
+ mkinstalldirs = $(SHELL) $(top_srcdir)/mkinstalldirs
+ CONFIG_HEADER = ../config.h
+ CONFIG_CLEAN_FILES = 
+-LIBRARIES =  $(pkglib_LIBRARIES)
++LIBRARIES =  $(pkglib_LIBRARIES) libmysqlclient.so
+ 
+ CPPFLAGS = @CPPFLAGS@
+ LDFLAGS = @LDFLAGS@
+@@ -540,18 +542,22 @@
+ 
+ shlib: libmysqlclient.so
+ 
+-libmysqlclient.so: libmysqlclient.so.@VERSION@
++libmysqlclient.so: libmysqlclient.so.${SHVERSION}
+ 	-rm -f $@
+ 	ln -s $< $@
+ 
+-libmysqlclient.so.@VERSION@: $(SHLIBOBJS)
+-	$(CC) -shared -Wl,-h,libmysqlclient.so.@SHARED_LIB_VERSION@ -o $@ \
+-	  $(SHLIBOBJS) $(LIBS)
++libmysqlclient.so.${SHVERSION}: libmysqlclient_pic.a
++	$(LD) -x -Bshareable -Bforcearchive libmysqlclient_pic.a -o $@ $(LIBS)
++
++libmysqlclient_pic.a: $(SHLIBOBJS)
++	${AR} cru $@ $(SHLIBOBJS)
++	${RANLIB} $@
+ 
+ install_shlib: libmysqlclient.so
+-	$(INSTALL) libmysqlclient.so.@VERSION@ $(libdir)
++	$(INSTALL) libmysqlclient_pic.a $(libdir)
++	$(INSTALL) libmysqlclient.so.${SHVERSION} $(libdir)
+ 	-rm -f $(libdir)/libmysqlclient.so
+-	ln -s libmysqlclient.so.@VERSION@ $(libdir)/libmysqlclient.so
++	ln -s libmysqlclient.so.${SHVERSION} $(libdir)/libmysqlclient.so
+ 	@echo "ensure $(libdir) is in your LD_LIBRARY_PATH"
+ 	@echo "and run ldconfig"
+ 
diff --git a/databases/mysql/patches/patch-ab b/databases/mysql/patches/patch-ab
new file mode 100644
index 00000000000..b2afb56622c
--- /dev/null
+++ b/databases/mysql/patches/patch-ab
@@ -0,0 +1,61 @@
+--- configure.orig	Wed Jun 10 14:53:21 1998
++++ configure	Sun Jun 21 23:08:27 1998
+@@ -2950,58 +2950,6 @@
+   echo "$ac_t""no" 1>&6
+ fi
+ 
+-
+-# Check for gtty if termio.h doesn't exists
+-if test "$ac_cv_header_termio_h" = "no"
+-then
+-  echo $ac_n "checking for gtty in -lcompat""... $ac_c" 1>&6
+-echo "configure:2959: checking for gtty in -lcompat" >&5
+-ac_lib_var=`echo compat'_'gtty | sed 'y%./+-%__p_%'`
+-if eval "test \"`echo '$''{'ac_cv_lib_$ac_lib_var'+set}'`\" = set"; then
+-  echo $ac_n "(cached) $ac_c" 1>&6
+-else
+-  ac_save_LIBS="$LIBS"
+-LIBS="-lcompat  $LIBS"
+-cat > conftest.$ac_ext <<EOF
+-#line 2967 "configure"
+-#include "confdefs.h"
+-/* Override any gcc2 internal prototype to avoid an error.  */
+-/* We use char because int might match the return type of a gcc2
+-    builtin and then its argument prototype would still apply.  */
+-char gtty();
+-
+-int main() {
+-gtty()
+-; return 0; }
+-EOF
+-if { (eval echo configure:2978: \"$ac_link\") 1>&5; (eval $ac_link) 2>&5; } && test -s conftest; then
+-  rm -rf conftest*
+-  eval "ac_cv_lib_$ac_lib_var=yes"
+-else
+-  echo "configure: failed program was:" >&5
+-  cat conftest.$ac_ext >&5
+-  rm -rf conftest*
+-  eval "ac_cv_lib_$ac_lib_var=no"
+-fi
+-rm -f conftest*
+-LIBS="$ac_save_LIBS"
+-
+-fi
+-if eval "test \"`echo '$ac_cv_lib_'$ac_lib_var`\" = yes"; then
+-  echo "$ac_t""yes" 1>&6
+-    ac_tr_lib=HAVE_LIB`echo compat | sed -e 's/[^a-zA-Z0-9_]/_/g' \
+-    -e 'y/abcdefghijklmnopqrstuvwxyz/ABCDEFGHIJKLMNOPQRSTUVWXYZ/'`
+-  cat >> confdefs.h <<EOF
+-#define $ac_tr_lib 1
+-EOF
+-
+-  LIBS="-lcompat $LIBS"
+-
+-else
+-  echo "$ac_t""no" 1>&6
+-fi
+-
+-fi
+ # We make a special variable for client library's to avoid including
+ # thread libs in the client.
+ LIBS_AFTER_SOCKET=$LIBS
diff --git a/databases/mysql/patches/patch-ac b/databases/mysql/patches/patch-ac
new file mode 100644
index 00000000000..ba73b3891a8
--- /dev/null
+++ b/databases/mysql/patches/patch-ac
@@ -0,0 +1,33 @@
+--- client/get_password.c.orig	Sun Jun 14 16:26:27 1998
++++ client/get_password.c	Sun Jun 14 19:25:24 1998
+@@ -18,8 +18,8 @@
+ #include	<termio.h>
+ #define TERMIO	struct termio
+ #else
+-#include	<sgtty.h>
+-#define TERMIO	struct sgttyb
++#include	<termios.h>
++#define TERMIO	struct termios
+ #endif
+ #ifdef alpha_linux_port
+ #include <asm/ioctls.h>				/* QQ; Fix this in configure */
+@@ -92,13 +92,14 @@
+   get_password(buff,sizeof(buff)-1,fileno(stdin),isatty(fileno(stdout)));
+   ioctl(fileno(stdin),(int) TCSETA, &org);
+ #else
+-  gtty(fileno(stdin), &org);
++  tcgetattr(fileno(stdin), &org);
+   tmp=org;
+-  tmp.sg_flags &= ~ECHO;
+-  tmp.sg_flags |= RAW;
+-  stty(fileno(stdin), &tmp);
++  tmp.c_lflag &= ~(ECHO | ISIG | ICANON);
++  tmp.c_cc[VMIN] = 1;
++  tmp.c_cc[VTIME]= 0;
++  tcsetattr(fileno(stdin), TCSAFLUSH, &tmp);
+   get_password(buff,sizeof(buff)-1,fileno(stdin),isatty(fileno(stdout)));
+-  stty(fileno(stdin), &org);
++  tcsetattr(fileno(stdin), TCSAFLUSH, &org);
+ #endif
+   if (isatty(fileno(stdout)))
+     fputc('\n',stdout);
diff --git a/databases/mysql/patches/patch-ad b/databases/mysql/patches/patch-ad
new file mode 100644
index 00000000000..a638afe3f40
--- /dev/null
+++ b/databases/mysql/patches/patch-ad
@@ -0,0 +1,11 @@
+--- scripts/Makefile.in.orig	Sun Jun 14 21:15:12 1998
++++ scripts/Makefile.in	Sun Jun 14 21:13:41 1998
+@@ -40,7 +40,7 @@
+ INSTALL = @INSTALL@
+ INSTALL_PROGRAM = @INSTALL_PROGRAM@
+ INSTALL_DATA = @INSTALL_DATA@
+-INSTALL_SCRIPT = @INSTALL_SCRIPT@
++INSTALL_SCRIPT = install -c -o root -g wheel -m 555
+ transform = @program_transform_name@
+ 
+ NORMAL_INSTALL = true
diff --git a/databases/mysql/patches/patch-ae b/databases/mysql/patches/patch-ae
new file mode 100644
index 00000000000..fe4f26a8238
--- /dev/null
+++ b/databases/mysql/patches/patch-ae
@@ -0,0 +1,11 @@
+--- bench/Makefile.in.orig	Sun Jun 14 21:34:14 1998
++++ bench/Makefile.in	Sun Jun 14 21:34:45 1998
+@@ -40,7 +40,7 @@
+ INSTALL = @INSTALL@
+ INSTALL_PROGRAM = @INSTALL_PROGRAM@
+ INSTALL_DATA = @INSTALL_DATA@
+-INSTALL_SCRIPT = @INSTALL_SCRIPT@
++INSTALL_SCRIPT = install -c -o root -g wheel -m 555
+ transform = @program_transform_name@
+ 
+ NORMAL_INSTALL = true
diff --git a/databases/mysql/patches/patch-af b/databases/mysql/patches/patch-af
new file mode 100644
index 00000000000..ef971d57520
--- /dev/null
+++ b/databases/mysql/patches/patch-af
@@ -0,0 +1,11 @@
+--- Makefile.in.orig	Sun Jun 14 21:37:07 1998
++++ Makefile.in	Sun Jun 14 21:37:22 1998
+@@ -117,7 +117,7 @@
+ EXTRA_DIST =		INSTALL-SOURCE-GENERIC README \
+ 			PUBLIC INSTALL-SOURCE # Built from source in Docs dir
+ SUBDIRS =		Docs @readline_dir@ client @sql_server_dirs@ \
+-			scripts include tests man @bench_dirs@ @perl_dirs@
++			scripts include tests man # @bench_dirs@ @perl_dirs@
+ 
+ # Relink after clean
+ CLEANFILES =		linked_client_sources
diff --git a/databases/mysql/patches/patch-ag b/databases/mysql/patches/patch-ag
new file mode 100644
index 00000000000..63892b0229b
--- /dev/null
+++ b/databases/mysql/patches/patch-ag
@@ -0,0 +1,11 @@
+--- scripts/mysql_install_db.sh.orig	Sun Jun 14 23:02:32 1998
++++ scripts/mysql_install_db.sh	Sun Jun 14 23:05:16 1998
+@@ -34,7 +34,7 @@
+   echo "@scriptdir@/safe_mysqld -l &"
+   echo
+   echo "Plese report any problems with the @scriptdir@/mysqlbug script"
+-  exit 1
++  exit 0
+ fi
+ 
+ # On IRIX hostname is in /usr/bsd so add this to the path
diff --git a/databases/mysql/pkg/COMMENT b/databases/mysql/pkg/COMMENT
new file mode 100644
index 00000000000..27749462d57
--- /dev/null
+++ b/databases/mysql/pkg/COMMENT
@@ -0,0 +1 @@
+MySQL, a free SQL database server
diff --git a/databases/mysql/pkg/DESCR b/databases/mysql/pkg/DESCR
new file mode 100644
index 00000000000..4693dde9acf
--- /dev/null
+++ b/databases/mysql/pkg/DESCR
@@ -0,0 +1,14 @@
+*MySQL* is a SQL (Structured Query Language) database server.
+SQL is the most popular database language in the world.
+*MySQL* is a client server implementation that consists of a
+server daemon `mysqld' and many different client programs/libraries.
+
+The main goals of *MySQL* are speed and robustness.
+
+The base upon which *MySQL* is built is a set of routines that have
+been used in a highly demanding production environment for many years.
+While *MySQL* is still in development it already offers a rich and
+highly useful function set.
+
+The official way to pronounce *MySQL* is 'My Ess Que Ell' (Not
+MY-SEQUEL).
diff --git a/databases/mysql/pkg/PLIST b/databases/mysql/pkg/PLIST
new file mode 100644
index 00000000000..3becf8e772c
--- /dev/null
+++ b/databases/mysql/pkg/PLIST
@@ -0,0 +1,96 @@
+@comment $NetBSD: PLIST,v 1.1 1998/06/22 10:55:22 frueauf Exp $
+include/mysql/readline.h
+include/mysql/chardefs.h
+include/mysql/keymaps.h
+include/mysql/history.h
+include/mysql/tilde.h
+include/mysql/dbug.h
+include/mysql/m_string.h
+include/mysql/m_ctype.h.in
+include/mysql/my_sys.h
+include/mysql/mysql.h
+include/mysql/mysql_com.h
+include/mysql/errmsg.h
+include/mysql/mysql_version.h
+lib/mysql/libmysqlclient.a
+lib/mysql/libmystrings.a
+lib/mysql/libdbug.a
+lib/mysql/libmysys.a
+lib/mysql/libnisam.a
+lib/mysql/libheap.a
+lib/mysql/libmerge.a
+lib/libmysqlclient_pic.a
+lib/libmysqlclient.so.321.30
+lib/libmysqlclient.so
+bin/mysql
+bin/mysqladmin
+bin/mysqlshow
+bin/mysqldump
+bin/mysqlimport
+bin/replace
+bin/comp_err
+bin/perror
+bin/isamchk
+bin/isamlog
+bin/add_file_priv
+bin/add_long_password
+bin/add_func_table
+bin/make_binary_distribution
+bin/msql2mysql
+bin/mysqlaccess
+bin/mysqlbug
+bin/mysql.server
+bin/safe_mysqld
+bin/mysql_install_db
+bin/zap
+bin/which1
+share/mysql/english/errmsg.sys
+share/mysql/english/errmsg.txt
+share/mysql/swedish/errmsg.sys
+share/mysql/swedish/errmsg.txt
+share/mysql/german/errmsg.sys
+share/mysql/german/errmsg.txt
+share/mysql/french/errmsg.sys
+share/mysql/french/errmsg.txt
+share/mysql/czech/errmsg.sys
+share/mysql/czech/errmsg.txt
+share/mysql/polish/errmsg.sys
+share/mysql/polish/errmsg.txt
+share/mysql/spanish/errmsg.sys
+share/mysql/spanish/errmsg.txt
+share/mysql/norwegian/errmsg.sys
+share/mysql/norwegian/errmsg.txt
+share/mysql/norwegian-ny/errmsg.sys
+share/mysql/norwegian-ny/errmsg.txt
+share/mysql/portuguese/errmsg.sys
+share/mysql/portuguese/errmsg.txt
+share/mysql/dutch/errmsg.sys
+share/mysql/dutch/errmsg.txt
+share/mysql/russian/errmsg.sys
+share/mysql/russian/errmsg.txt
+share/mysql/italian/errmsg.sys
+share/mysql/italian/errmsg.txt
+libexec/mysqld
+man/man1/mysql.1
+@unexec %D/bin/install-info --delete %D/info/mysql.info %D/info/dir
+info/mysql.info
+@exec %D/bin/install-info %D/info/mysql.info %D/info/dir
+@exec %D/bin/mysql_install_db
+@exec /sbin/ldconfig || /usr/bin/true
+@unexec /sbin/ldconfig || /usr/bin/true
+@dirrm include/mysql
+@dirrm lib/mysql
+@dirrm share/mysql/english
+@dirrm share/mysql/swedish
+@dirrm share/mysql/german
+@dirrm share/mysql/french
+@dirrm share/mysql/czech
+@dirrm share/mysql/polish
+@dirrm share/mysql/spanish
+@dirrm share/mysql/norwegian
+@dirrm share/mysql/norwegian-ny
+@dirrm share/mysql/portuguese
+@dirrm share/mysql/dutch
+@dirrm share/mysql/russian
+@dirrm share/mysql/italian
+@dirrm share/mysql