mysql dans test

8 files changed, 365 insertions, 0 deletions

diff --git a/test/mysql/.footprint b/test/mysql/.footprint
new file mode 100644
index 000000000..7c9879898
--- /dev/null
+++ b/test/mysql/.footprint
@@ -0,0 +1,200 @@
+drwxr-xr-x	root/root	etc/
+-rw-r--r--	root/root	etc/my.cnf
+drwxr-xr-x	root/root	etc/rc.d/
+drwxr-xr-x	root/root	etc/rc.d/init.d/
+-rwxr-xr--	root/root	etc/rc.d/init.d/mysql
+drwxr-xr-x	root/root	etc/rc.d/rc0.d/
+lrwxrwxrwx	root/root	etc/rc.d/rc0.d/K26mysql -> ../init.d/mysql
+drwxr-xr-x	root/root	etc/rc.d/rc1.d/
+lrwxrwxrwx	root/root	etc/rc.d/rc1.d/K26mysql -> ../init.d/mysql
+drwxr-xr-x	root/root	etc/rc.d/rc2.d/
+lrwxrwxrwx	root/root	etc/rc.d/rc2.d/K26mysql -> ../init.d/mysql
+drwxr-xr-x	root/root	etc/rc.d/rc3.d/
+lrwxrwxrwx	root/root	etc/rc.d/rc3.d/S34mysql -> ../init.d/mysql
+drwxr-xr-x	root/root	etc/rc.d/rc4.d/
+lrwxrwxrwx	root/root	etc/rc.d/rc4.d/S34mysql -> ../init.d/mysql
+drwxr-xr-x	root/root	etc/rc.d/rc5.d/
+lrwxrwxrwx	root/root	etc/rc.d/rc5.d/S34mysql -> ../init.d/mysql
+drwxr-xr-x	root/root	etc/rc.d/rc6.d/
+lrwxrwxrwx	root/root	etc/rc.d/rc6.d/K26mysql -> ../init.d/mysql
+drwxr-xr-x	root/root	etc/rc.d/rcsysinit.d/
+drwxr-xr-x	root/root	etc/sysconfig/
+drwxr-xr-x	root/root	usr/
+drwxr-xr-x	root/root	usr/bin/
+-rwxr-xr-x	root/root	usr/bin/innochecksum
+-rwxr-xr-x	root/root	usr/bin/msql2mysql
+-rwxr-xr-x	root/root	usr/bin/my_print_defaults
+-rwxr-xr-x	root/root	usr/bin/myisam_ftdump
+-rwxr-xr-x	root/root	usr/bin/myisamchk
+-rwxr-xr-x	root/root	usr/bin/myisamlog
+-rwxr-xr-x	root/root	usr/bin/myisampack
+-rwxr-xr-x	root/root	usr/bin/mysql_client_test
+-rwxr-xr-x	root/root	usr/bin/mysql_convert_table_format
+-rwxr-xr-x	root/root	usr/bin/mysql_find_rows
+-rwxr-xr-x	root/root	usr/bin/mysql_fix_extensions
+-rwxr-xr-x	root/root	usr/bin/mysql_fix_privilege_tables
+-rwxr-xr-x	root/root	usr/bin/mysql_install_db
+-rwxr-xr-x	root/root	usr/bin/mysql_secure_installation
+-rwxr-xr-x	root/root	usr/bin/mysql_setpermission
+-rwxr-xr-x	root/root	usr/bin/mysql_tzinfo_to_sql
+-rwxr-xr-x	root/root	usr/bin/mysql_waitpid
+-rwxr-xr-x	root/root	usr/bin/mysql_zap
+-rwxr-xr-x	root/root	usr/bin/mysqlaccess
+-rwxr-xr-x	root/root	usr/bin/mysqlbug
+-rwxr-xr-x	root/root	usr/bin/mysqld_multi
+-rwxr-xr-x	root/root	usr/bin/mysqld_safe
+-rwxr-xr-x	root/root	usr/bin/mysqldumpslow
+-rwxr-xr-x	root/root	usr/bin/mysqlhotcopy
+-rwxr-xr-x	root/root	usr/bin/perror
+-rwxr-xr-x	root/root	usr/bin/replace
+-rwxr-xr-x	root/root	usr/bin/resolve_stack_dump
+-rwxr-xr-x	root/root	usr/bin/resolveip
+drwxr-xr-x	root/root	usr/sbin/
+-rwxr-xr-x	root/root	usr/sbin/mysqld
+-rwxr-xr-x	root/root	usr/sbin/mysqlmanager
+drwxr-xr-x	root/root	usr/share/
+drwxr-xr-x	root/root	usr/share/aclocal/
+-rw-r--r--	root/root	usr/share/aclocal/mysql.m4
+drwxr-xr-x	root/root	usr/share/man/
+drwxr-xr-x	root/root	usr/share/man/man1/
+-rw-r--r--	root/root	usr/share/man/man1/comp_err.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/innochecksum.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/msql2mysql.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/my_print_defaults.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/myisam_ftdump.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/myisamchk.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/myisamlog.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/myisampack.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql-stress-test.pl.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql-test-run.pl.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql.server.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_client_test.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_config.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_convert_table_format.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_find_rows.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_fix_extensions.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_fix_privilege_tables.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_install_db.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_secure_installation.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_setpermission.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_tzinfo_to_sql.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_upgrade.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_waitpid.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysql_zap.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqlaccess.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqladmin.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqlbinlog.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqlbug.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqlcheck.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqld_multi.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqld_safe.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqldump.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqldumpslow.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqlhotcopy.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqlimport.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqlman.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqlshow.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqlslap.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/mysqltest.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/perror.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/replace.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/resolve_stack_dump.1.gz
+-rw-r--r--	root/root	usr/share/man/man1/resolveip.1.gz
+drwxr-xr-x	root/root	usr/share/man/man8/
+-rw-r--r--	root/root	usr/share/man/man8/mysqld.8.gz
+-rw-r--r--	root/root	usr/share/man/man8/mysqlmanager.8.gz
+drwxr-xr-x	root/root	usr/share/mysql/
+-rw-r--r--	root/root	usr/share/mysql/binary-configure
+drwxr-xr-x	root/root	usr/share/mysql/charsets/
+-rw-r--r--	root/root	usr/share/mysql/charsets/Index.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/armscii8.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/ascii.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/cp1250.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/cp1251.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/cp1256.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/cp1257.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/cp850.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/cp852.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/cp866.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/dec8.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/geostd8.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/greek.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/hebrew.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/hp8.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/keybcs2.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/koi8r.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/koi8u.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/latin1.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/latin2.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/latin5.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/latin7.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/macce.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/macroman.xml
+-rw-r--r--	root/root	usr/share/mysql/charsets/swe7.xml
+-rw-r--r--	root/root	usr/share/mysql/config.huge.ini
+-rw-r--r--	root/root	usr/share/mysql/config.medium.ini
+-rw-r--r--	root/root	usr/share/mysql/config.small.ini
+drwxr-xr-x	root/root	usr/share/mysql/czech/
+-rw-r--r--	root/root	usr/share/mysql/czech/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/danish/
+-rw-r--r--	root/root	usr/share/mysql/danish/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/dutch/
+-rw-r--r--	root/root	usr/share/mysql/dutch/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/english/
+-rw-r--r--	root/root	usr/share/mysql/english/errmsg.sys
+-rw-r--r--	root/root	usr/share/mysql/errmsg.txt
+drwxr-xr-x	root/root	usr/share/mysql/estonian/
+-rw-r--r--	root/root	usr/share/mysql/estonian/errmsg.sys
+-rw-r--r--	root/root	usr/share/mysql/fill_help_tables.sql
+drwxr-xr-x	root/root	usr/share/mysql/french/
+-rw-r--r--	root/root	usr/share/mysql/french/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/german/
+-rw-r--r--	root/root	usr/share/mysql/german/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/greek/
+-rw-r--r--	root/root	usr/share/mysql/greek/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/hungarian/
+-rw-r--r--	root/root	usr/share/mysql/hungarian/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/italian/
+-rw-r--r--	root/root	usr/share/mysql/italian/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/japanese/
+-rw-r--r--	root/root	usr/share/mysql/japanese/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/korean/
+-rw-r--r--	root/root	usr/share/mysql/korean/errmsg.sys
+-rw-r--r--	root/root	usr/share/mysql/mi_test_all
+-rw-r--r--	root/root	usr/share/mysql/mi_test_all.res
+-rw-r--r--	root/root	usr/share/mysql/my-huge.cnf
+-rw-r--r--	root/root	usr/share/mysql/my-innodb-heavy-4G.cnf
+-rw-r--r--	root/root	usr/share/mysql/my-large.cnf
+-rw-r--r--	root/root	usr/share/mysql/my-medium.cnf
+-rw-r--r--	root/root	usr/share/mysql/my-small.cnf
+-rw-r--r--	root/root	usr/share/mysql/mysql-log-rotate
+-rwxr-xr-x	root/root	usr/share/mysql/mysql.server
+-rw-r--r--	root/root	usr/share/mysql/mysql_fix_privilege_tables.sql
+-rw-r--r--	root/root	usr/share/mysql/mysql_system_tables.sql
+-rw-r--r--	root/root	usr/share/mysql/mysql_system_tables_data.sql
+-rw-r--r--	root/root	usr/share/mysql/mysql_test_data_timezone.sql
+-rwxr-xr-x	root/root	usr/share/mysql/mysqld_multi.server
+-rw-r--r--	root/root	usr/share/mysql/ndb-config-2-node.ini
+drwxr-xr-x	root/root	usr/share/mysql/norwegian-ny/
+-rw-r--r--	root/root	usr/share/mysql/norwegian-ny/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/norwegian/
+-rw-r--r--	root/root	usr/share/mysql/norwegian/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/polish/
+-rw-r--r--	root/root	usr/share/mysql/polish/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/portuguese/
+-rw-r--r--	root/root	usr/share/mysql/portuguese/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/romanian/
+-rw-r--r--	root/root	usr/share/mysql/romanian/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/russian/
+-rw-r--r--	root/root	usr/share/mysql/russian/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/serbian/
+-rw-r--r--	root/root	usr/share/mysql/serbian/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/slovak/
+-rw-r--r--	root/root	usr/share/mysql/slovak/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/spanish/
+-rw-r--r--	root/root	usr/share/mysql/spanish/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/swedish/
+-rw-r--r--	root/root	usr/share/mysql/swedish/errmsg.sys
+drwxr-xr-x	root/root	usr/share/mysql/ukrainian/
+-rw-r--r--	root/root	usr/share/mysql/ukrainian/errmsg.sys
diff --git a/test/mysql/.md5sum b/test/mysql/.md5sum
new file mode 100644
index 000000000..b1738a8dc
--- /dev/null
+++ b/test/mysql/.md5sum
@@ -0,0 +1,3 @@
+4cbf0fc3eb76057f7a8dd52a3e2a58e6  mysql-5.1-gcc45-apicheck.patch
+04f7c1422199c73a88a3d408b9161b63  mysql-5.1.46.tar.gz
+d98ff5376214c095d885cd4be4d3bef7  mysql.nutyx.patch
diff --git a/test/mysql/Pkgfile b/test/mysql/Pkgfile
new file mode 100644
index 000000000..90350d5db
--- /dev/null
+++ b/test/mysql/Pkgfile
@@ -0,0 +1,52 @@
+# Description: Serveur de base de données MySQL
+# URL: http://www.mysql.com
+# Maintainer: NuTyX core team
+# Packager: thierryn1 at hispeed dot ch
+# Depends on: mysqlclient
+
+name=mysql
+version=5.1.46
+release=1
+source=(http://mirror.switch.ch/mirror/mysql/Downloads/MySQL-5.1/$name-$version.tar.gz \
+        mysql.nutyx.patch mysql-5.1-gcc45-apicheck.patch )
+
+build () {
+	source /etc/blfs-bootscripts
+        wget http://www.linuxfromscratch.org/blfs/downloads/svn/$scripts-$scriptsversion.tar.bz2
+        tar xvf $scripts-$scriptsversion.tar.bz2
+#	patch -Np0 -i mysql.nutyx.patch
+	cd $name-$version
+	patch -Np1 -i ../mysql-5.1-gcc45-apicheck.patch 
+	./configure --prefix=/usr \
+                --sysconfdir=/etc \
+                --libexecdir=/usr/sbin \
+                --localstatedir=/srv/mysql \
+                --enable-assembler \
+                --enable-thread-safe-client \
+                --enable-local-infile \
+                --with-unix-socket-path=/var/run/mysql/mysql.sock \
+                --with-extra-charsets=all \
+                --without-debug \
+                --without-readline \
+                --without-docs \
+                --without-bench 
+	make -j2
+	make DESTDIR=$PKG install
+	rm -r $PKG/usr/{mysql-test,sql-bench}
+	for i in mysql mysql_upgrade \
+	mysqladmin mysqlbinlog \
+	mysqlcheck mysqldump mysqlimport mysqlshow \
+	mysqlslap mysqltest mysql_config
+	do rm -r $PKG/usr/bin/$i
+	done
+	rm $PKG/usr/share/mysql/charsets/README
+	mkdir -p $PKG/etc
+	install -v -m644 $PKG/usr/share/mysql/my-medium.cnf \
+	$PKG/etc/my.cnf
+	sed -i -e s/^skip-federated/#skip-federated/ \
+	$PKG/etc/my.cnf
+	cd ../$scripts-$scriptsversion
+	make DESTDIR=$PKG install-mysql
+	# Suppression des librairies
+	rm -r $PKG/usr/{include,lib}
+}
diff --git a/test/mysql/README b/test/mysql/README
new file mode 100644
index 000000000..b0ba4cc38
--- /dev/null
+++ b/test/mysql/README
@@ -0,0 +1,29 @@
+Il est très important de procéder comme ci-dessous pour avoir un serveur mysql sécurisé.
+Installer le serveur mysql en procédant comme ceci
+
+/etc/rc.d/init.d/mysql stop
+
+mysqld_safe --user=mysql 2>&1 >/dev/null &
+
+Noter que le & est très important pour avoir la main en console
+
+On spécifie maintenant un mot de passe pour le root 
+
+mysqladmin -u root password <nouveau-mot-de-passe>
+
+La configuration du serveur est terminée. On peut maintenant l'arrêter.
+
+mysqladmin -p shutdown
+
+Le mot de passe sera demandé.
+
+Lancer le serveur de façon définitive
+
+/etc/rc.d/init.d/mysql start
+
+Aucune erreur ne doit apparaître.
+
+Au prochain lancement de la machine, mysql se lancera correctement.
+
+pour plus d'info: http://www.nutyx.org
+
diff --git a/test/mysql/my.cnf b/test/mysql/my.cnf
new file mode 100644
index 000000000..37070a679
--- /dev/null
+++ b/test/mysql/my.cnf
@@ -0,0 +1,20 @@
+#
+# /etc/my.cnf
+#
+
+[mysqld]
+datadir  = /var/lib/mysql
+user     = daemon
+log      = /var/log/mysqld.log
+pid-file = /var/run/mysqld.pid
+socket   = /tmp/mysql.sock
+port     = 3306
+
+skip-networking
+skip-innodb
+
+[client]
+socket   = /tmp/mysql.sock
+port     = 3306
+
+# End of file
diff --git a/test/mysql/mysql-5.1-gcc45-apicheck.patch b/test/mysql/mysql-5.1-gcc45-apicheck.patch
new file mode 100644
index 000000000..46125c73e
--- /dev/null
+++ b/test/mysql/mysql-5.1-gcc45-apicheck.patch
@@ -0,0 +1,28 @@
+--- mysql-5.1.45/Makefile.am.orig	2010-03-31 10:52:25.000000000 -0400
++++ mysql-5.1.45/Makefile.am	2010-03-31 10:55:05.000000000 -0400
+@@ -312,24 +312,7 @@
+ 	$(MAKE) abi_headers="$^" do_abi_check
+ 
+ do_abi_check:
+-	set -ex; \
+-	for file in $(abi_headers); do \
+-	         @CC@ -E -nostdinc -dI \
+-	                  -I$(top_srcdir)/include \
+-	                  -I$(top_srcdir)/include/mysql \
+-	                  -I$(top_srcdir)/sql \
+-	                  -I$(top_builddir)/include \
+-	                  -I$(top_builddir)/include/mysql \
+-	                  -I$(top_builddir)/sql \
+-	                                 $$file 2>/dev/null | \
+-	                  @SED@ -e '/^# /d' \
+-	                            -e '/^[ 	]*$$/d' \
+-	                            -e '/^#pragma GCC set_debug_pwd/d' \
+-	                            -e '/^#ident/d' > \
+-	                                       $(top_builddir)/abi_check.out; \
+-	                  @DIFF@ -w $$file.pp $(top_builddir)/abi_check.out; \
+-	                  @RM@ $(top_builddir)/abi_check.out; \
+-	done
++	echo "Skipping do_abi_check"
+ 
+ # Don't update the files from bitkeeper
+ %::SCCS/s.%
diff --git a/test/mysql/mysql.nutyx.patch b/test/mysql/mysql.nutyx.patch
new file mode 100644
index 000000000..cc1cdb43e
--- /dev/null
+++ b/test/mysql/mysql.nutyx.patch
@@ -0,0 +1,27 @@
+--- blfs-bootscripts-20090302/blfs/init.d/mysql	2005-08-01 19:29:19.000000000 +0000
++++ blfs-bootscripts-20090302/blfs/init.d/mysql.nutyx	2009-06-26 06:55:05.000000000 +0000
+@@ -5,11 +5,23 @@
+ # Rewritten by Gerard Beekmans  - gerard@linuxfromscratch.org
+ 
+ #$LastChangedBy: bdubbs $
+-#$Date: 2005-08-01 19:29:19 +0000 (Mon, 01 Aug 2005) $
++#$Date: 2005-08-01 14:29:19 -0500 (Mon, 01 Aug 2005) $
+ 
+ . /etc/sysconfig/rc
+ . $rc_functions
+ 
++newgroup=mysql
++newuser=mysql
++newid=40
++
++# check for mysql group or add one
++getent group $newgroup > /dev/null || /usr/sbin/groupadd -g $newid $newgroup
++
++# check for mysql user or add one
++getent passwd $newuser > /dev/null || /usr/sbin/useradd -g $newgroup \
++-u $newid -d /dev/null \
++-s /bin/false -c "MySQL Server" $newuser
++
+ PIDFILE=/srv/mysql/`/bin/hostname`.pid
+ KILLDELAY=20
+ 
diff --git a/test/mysql/post-install b/test/mysql/post-install
new file mode 100755
index 000000000..056fe5500
--- /dev/null
+++ b/test/mysql/post-install
@@ -0,0 +1,6 @@
+#!/bin/sh
+
+
+mysql_install_db --user=mysql
+chgrp mysql /srv/mysql{,/test,/mysql}
+install -m755 -o mysql -g mysql -d /var/run/mysql