diff options
-rw-r--r-- | extra/mysql/.footprint | 201 | ||||
-rw-r--r-- | extra/mysql/.md5sum | 2 | ||||
-rw-r--r-- | extra/mysql/Pkgfile | 52 | ||||
-rw-r--r-- | extra/mysql/README | 42 | ||||
-rw-r--r-- | extra/mysql/my.cnf | 20 | ||||
-rw-r--r-- | extra/mysql/mysql.nutyx.patch | 27 |
6 files changed, 344 insertions, 0 deletions
diff --git a/extra/mysql/.footprint b/extra/mysql/.footprint new file mode 100644 index 000000000..22510901b --- /dev/null +++ b/extra/mysql/.footprint @@ -0,0 +1,201 @@ +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/make_win_bin_dist.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/extra/mysql/.md5sum b/extra/mysql/.md5sum new file mode 100644 index 000000000..d043bac4c --- /dev/null +++ b/extra/mysql/.md5sum @@ -0,0 +1,2 @@ +18e694c4ecbe851fe8e21e1668116c46 mysql-5.1.36.tar.gz +d98ff5376214c095d885cd4be4d3bef7 mysql.nutyx.patch diff --git a/extra/mysql/Pkgfile b/extra/mysql/Pkgfile new file mode 100644 index 000000000..d0127b09b --- /dev/null +++ b/extra/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: ncurses, zlib, mysqlclient + +name=mysql +version=5.1.36 +release=1 +source=(http://mirror.switch.ch/mirror/mysql/Downloads/MySQL-5.1/$name-$version.tar.gz \ + mysql.nutyx.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 + ./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 \ + --with-berkeley-db \ + --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/extra/mysql/README b/extra/mysql/README new file mode 100644 index 000000000..01fb5925d --- /dev/null +++ b/extra/mysql/README @@ -0,0 +1,42 @@ +Il est très important de procéder comme ci-dessous pour avoir un serveur mysql +fonctionnel. +Installer le serveur mysql en procédant comme ceci + +/etc/rc.d/init.d/mysql start +/etc/rc.d/init.d/mysql stop + +On commence par installer les tables necessaire au bon fonctionnement de mysql. + +mysql_install_db --user=mysql + +On change les attributs des dossiers + +chgrp -v mysql /srv/mysql{,/test,/mysql} + +Pour pouvoir configurer le serveur il faut le lancer de cette façon: + +install -v -m755 -o mysql -g mysql -d /var/run/mysql +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/extra/mysql/my.cnf b/extra/mysql/my.cnf new file mode 100644 index 000000000..37070a679 --- /dev/null +++ b/extra/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/extra/mysql/mysql.nutyx.patch b/extra/mysql/mysql.nutyx.patch new file mode 100644 index 000000000..cc1cdb43e --- /dev/null +++ b/extra/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 + |