- Applied various patches provided by Christian Hammers (MySQL maintainer

   for the Debian project) to fix some architecture-specific problems
   and some bugs


Makefile.am:
   - put current directory (.) at front of SUBDIRS list, so that "distclean" 
     is done last. IF done first, "distclean" in include directory fails
     because config.h is missing, which is removed by distclean in current
     directory. (thanks to "jww" for the patch)
   - make "distclean" in libmysql_r, too (Thanks to Christian Hammers from the
     Debian project for the patch)
bdb/dist/aclocal/mutex.m4:
   - Sparc patch for mutexes/pthreads from Christopher C. Chimelis and
     Ben Collins from Debian (thanks to Christian Hammers from the Debian
     project for forwarding it)
bdb/include/mutex.h:
   - Patch for building on m68k architecture (originally provided
     by Michael Fedrowitz for Debian Linux, thanks to Christian Hammers from
     the Debian project for forwarding it)
ltconfig:
   - A hardcoded "rpath" is forbidden by the Debian policy (thanks to
     Christian Hammers from the Debian project for forwarding this patch)
man/isamchk.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
man/isamlog.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
man/mysql.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
man/mysql_zap.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
man/mysqlaccess.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
man/mysqladmin.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
man/mysqld.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
man/mysqld_multi.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
man/mysqldump.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
   - fixed nroff mistake
man/mysqlshow.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
man/perror.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
man/replace.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
man/safe_mysqld.1:
   - some syntactical correction in the headlines of the manpages for
     apropos(1) (Thanks to Christian Hammers from the Debian project for
     the patch)
scripts/mysql_fix_privilege_tables.sh:
   - fixed some typos
   - script cleanup
scripts/mysqlaccess.sh:
   - make $script_log path less dependent on the shell
scripts/safe_mysqld.sh:
   - applied patch provided by Debian to enhance security (This way all logs 
     and databases are created world-nothing).

3 files changed, 21 insertions, 12 deletions

diff --git a/scripts/mysql_fix_privilege_tables.sh b/scripts/mysql_fix_privilege_tables.sh
index 86312fdab52..1677eaf5f32 100644
--- a/scripts/mysql_fix_privilege_tables.sh
+++ b/scripts/mysql_fix_privilege_tables.sh
@@ -1,23 +1,30 @@
 #!/bin/sh
 
 echo "This scripts updates the mysql.user, mysql.db, mysql.host and the"
-echo "mysql.func table to MySQL 3.22.14 and above."
+echo "mysql.func tables to MySQL 3.22.14 and above."
 echo ""
 echo "This is needed if you want to use the new GRANT functions,"
-echo "CREATE AGGREAGATE FUNCTION or want to use the more secure passwords in 3.23"
+echo "CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23"
 echo ""
-echo "If you get Access denied errors, you should run this script again"
-echo "and give the MySQL root user password as a argument!"
+echo "If you get 'Access denied' errors, you should run this script again"
+echo "and give the MySQL root user password as an argument!"
 
-root_password="$1"
 host="localhost"
+user="root"
+
+if test -z $1 ; then
+  cmd="@bindir@/mysql -f --user=$user --host=$host mysql"
+else
+  root_password="$1"
+  cmd="@bindir@/mysql -f --user=$user --password=$root_password --host=$host mysql"
+fi
 
 # Fix old password format, add File_priv and func table
 echo ""
 echo "If your tables are already up to date or partially up to date you will"
 echo "get some warnings about 'Duplicated column name'. You can safely ignore these!"
 
-@bindir@/mysql -f --user=root --password="$root_password" --host="$host" mysql <<END_OF_DATA
+$cmd <<END_OF_DATA
 alter table user change password password char(16) NOT NULL;
 alter table user add File_priv enum('N','Y') NOT NULL;
 CREATE TABLE if not exists func (
@@ -34,7 +41,7 @@ echo ""
 
 echo "Creating Grant Alter and Index privileges if they don't exists"
 echo "You can ignore any Duplicate column errors"
-@bindir@/mysql --user=root --password="$root_password" --host="$host" mysql <<END_OF_DATA
+$cmd <<END_OF_DATA
 alter table user add Grant_priv enum('N','Y') NOT NULL,add References_priv enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add Alter_priv enum('N','Y') NOT NULL;
 alter table host add Grant_priv enum('N','Y') NOT NULL,add References_priv enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add Alter_priv enum('N','Y') NOT NULL;
 alter table db add Grant_priv enum('N','Y') NOT NULL,add References_priv enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add Alter_priv enum('N','Y') NOT NULL;
@@ -48,7 +55,7 @@ echo ""
 if test $res = 0
 then
   echo "Setting default privileges for the new grant, index and alter privileges"
-  @bindir@/mysql --user=root --password="$root_password" --host="$host" mysql <<END_OF_DATA
+  $cmd <<END_OF_DATA
   UPDATE user SET Grant_priv=File_priv,References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv;
   UPDATE db SET References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv;
   UPDATE host SET References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv;
@@ -62,7 +69,7 @@ fi
 
 echo "Creating the new table and column privilege tables"
 
-@bindir@/mysql -f --user=root --password="$root_password"  --host="$host" mysql <<END_OF_DATA
+$cmd <<END_OF_DATA
 CREATE TABLE IF NOT EXISTS tables_priv (
   Host char(60) DEFAULT '' NOT NULL,
   Db char(60) DEFAULT '' NOT NULL,
@@ -93,7 +100,7 @@ END_OF_DATA
 echo "Changing name of columns_priv.Type -> columns_priv.Column_priv"
 echo "You can ignore any errors from this"
 
-@bindir@/mysql -f --user=root --password="$root_password"  --host="$host" mysql <<END_OF_DATA
+$cmd <<END_OF_DATA
 ALTER TABLE columns_priv change Type Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL;
 END_OF_DATA
 
@@ -104,6 +111,6 @@ END_OF_DATA
 echo "Fixing the func table"
 echo "You can ignore any Duplicate column errors"
 
-@bindir@/mysql --user=root --password=$root_password mysql <<EOF
+$cmd <<EOF
 alter table func add type enum ('function','aggregate') NOT NULL;
 EOF
diff --git a/scripts/mysqlaccess.sh b/scripts/mysqlaccess.sh
index 355eb53d2b5..824dba7b65a 100644
--- a/scripts/mysqlaccess.sh
+++ b/scripts/mysqlaccess.sh
@@ -13,7 +13,7 @@ BEGIN {
 	$script      = $1;
         $script      = 'MySQLAccess' unless $script;
 	$script_conf = "$script.conf";
-	$script_log  = "~/$script.log";
+	$script_log  = $ENV{'HOME'}."/$script.log";
 
 	# ****************************
 	# information on MySQL
diff --git a/scripts/safe_mysqld.sh b/scripts/safe_mysqld.sh
index 67a38e49e01..c1b231eb001 100644
--- a/scripts/safe_mysqld.sh
+++ b/scripts/safe_mysqld.sh
@@ -12,6 +12,8 @@
 
 trap '' 1 2 3 15			# we shouldn't let anyone kill us
 
+umask 007
+
 defaults=
 case "$1" in
     --no-defaults|--defaults-file=*|--defaults-extra-file=*)