mysql stable port information

Package: mysql
Version: 5.0.27
Revision: 1001
Description: Open Source SQL database
License: GPL/LGPL
Maintainer: ASARI Takashi

# Dependencies:
Depends: %N15-shlibs (= %v-%r), %N-client (= %v-%r), daemonic (>= 20010902-1), passwd
BuildDepends: readline5 (>= 5.0-1004), system-openssl-dev, fink (>= 0.24.12)

# Unpack Phase:
Source: mirror:custom:Downloads/MySQL-5.0/%n-%v.tar.gz
Source-MD5: 584d423440a9d9c859678e3d4f2690b3
#SHA1: 656de9c03f07c2371f40277076ec2fc6eac51ec8
CustomMirror: <<
# Some country codes not in /sw/lib/fink/mirror/_keys
eur-AM: http://mysql.mirrors.arminco.com/
eur-AT: http://gd.tuwien.ac.at/db/mysql/
eur-AT: ftp://gd.tuwien.ac.at/db/mysql/
eur-BE: http://mysql.belnet.be/
eur-BE: ftp://ftp.belnet.be/mirror/ftp.mysql.com/pub/mysql/
eur-BE: http://mysql.easynet.be/
eur-BE: ftp://ftp.easynet.be/mysql/
eur-BE: http://mysql.skynet.be/
eur-BE: ftp://ftp.mysql.skynet.be/pub/ftp.mysql.com/
eur-BA: http://mysql.blic.net/
eur-BG: http://mysql.online.bg/
eur-BG: ftp://mysql.online.bg/
eur-CZ: http://mysql.linux.cz/
eur-CZ: ftp://ftp.fi.muni.cz/pub/mysql/
eur-DK: http://mysql.mirrors.cybercity.dk/
eur-DK: http://mirrors.dotsrc.org/mysql/
eur-DK: ftp://mirrors.dotsrc.org/mysql/
eur-FI: http://mysql.tonnikala.org/
eur-FR: http://mir2.ovh.net/ftp.mysql.com/
eur-FR: ftp://mir1.ovh.net/ftp.mysql.com/
eur-FR: http://mysql.crihan.fr/
eur-FR: ftp://ftp.inria.fr/pub/MySQL/
eur-FR: http://ftp.club-internet.fr/mirrors/ftp.mysql.com/
eur-FR: ftp://ftp.club-internet.fr/pub/mirrors/ftp.mysql.com/
eur-FR: http://mirrors.ircam.fr/pub/mysql/
eur-FR: ftp://mirrors.ircam.fr/pub/mysql/
eur-DE: http://sunsite.informatik.rwth-aachen.de/mysql/
eur-DE: ftp://sunsite.informatik.rwth-aachen.de/pub/mirror/www.mysql.com/
eur-DE: http://ftp.gwdg.de/pub/misc/mysql/
eur-DE: ftp://ftp.gwdg.de/pub/misc/mysql/
eur-DE: ftp://ftp.fu-berlin.de/unix/databases/mysql/
eur-DE: http://ftp.plusline.de/mysql/
eur-DE: ftp://ftp.plusline.de/pub/mysql/
eur-GR: http://mirrors.ntua.gr/MySQL/
eur-GR: ftp://ftp.ntua.gr/pub/databases/mysql/
eur-GR: http://mirrors.ee.teiath.gr/mysql/
eur-GR: ftp://mirrors.ee.teiath.gr/pub/mysql/
eur-HU: http://mysql.sote.hu/
eur-HU: ftp://xenia.sote.hu/pub/mirrors/www.mysql.com/
eur-HU: http://mysql.mirrors.crysys.hit.bme.hu/
eur-HU: ftp://ftp.crysys.hu/pub/mysql/
eur-IS: http://mysql.rhnet.is/
eur-IS: ftp://ftp.rhnet.is/pub/mysql/
eur-IE: http://ftp.heanet.ie/mirrors/www.mysql.com/
eur-IE: ftp://ftp.heanet.ie/mirrors/www.mysql.com/
eur-IT: http://mirror.tomato.it/mysql/
eur-IT: http://na.mirror.garr.it/mirrors/MySQL/
eur-IT: ftp://na.mirror.garr.it/mirrors/MySQL/
eur-NL: http://mysql.proserve.nl/
eur-NL: ftp://mysql.proserve.nl/pub/mysql/Downloads
eur-NL: http://ftp.snt.utwente.nl/pub/software/mysql/
eur-NL: ftp://ftp.snt.utwente.nl/pub/software/mysql/
eur-PL: http://sunsite.icm.edu.pl/mysql/
eur-PL: ftp://sunsite.icm.edu.pl/pub/unix/mysql/
eur-PL: http://ftp.tpnet.pl/vol/d3/ftp.mysql.com/
eur-PL: ftp://ftp.tpnet.pl/d3/ftp.mysql.com/
eur-PT: http://mysql.nfsi.pt/
eur-PT: ftp://ftp.nfsi.pt/pub/mysql/
eur-PT: http://mysql.netvisao.pt/
eur-PT: ftp://mirrors2.netvisao.pt/mysql/
eur-PT: http://lisa.gov.pt/ftp/mysql/
eur-PT: ftp://ftp.roedu.net/pub/mirrors/ftp.mysql.com/
eur-RO: ftp://mirrors.fibernet.ro/1/MySQL/
eur-RU: http://mysql.directnet.ru/
eur-RU: ftp://ftp.dn.ru/pub/MySQL/
eur-RU: http://mysql.dn.ru/
eur-RU: http://mysql.mix.su/
eur-RU: ftp://mysql.mix.su/
eur-SI: http://mirrors.bevc.net/mysql/
eur-SI: ftp://ftp.bevc.net/mirrors/mysql/
eur-SI: http://ftp.arnes.si/mysql/
eur-SI: ftp://ftp.arnes.si/packages/mysql/
eur-SI: http://www.wsection.com/mysql/
eur-ES: http://mysql.rediris.es/
eur-ES: ftp://ftp.rediris.es/mirror/mysql/
eur-SE: http://ftp.sunet.se/pub/unix/databases/relational/mysql/
eur-SE: ftp://ftp.sunet.se/pub/unix/databases/relational/mysql/
eur-SE: http://mysql.dataphone.se/
eur-SE: ftp://mirror2.dataphone.se/pub/mysql/
eur-CH: http://mirror.switch.ch/ftp/mirror/mysql/
eur-CH: ftp://mirror.switch.ch/mirror/mysql/
eur-CH: ftp://ftp.solnet.ch/mirror/mysql/
eur-TR: http://mysql.progen.com.tr/
eur-UA: http://mysql.net.ua/
eur-UA: ftp://ftp.tlk-l.net/pub/mirrors/mysql.com/
eur-UA: http://mysql.infocom.ua/
eur-UK: http://www.mirrorservice.org/sites/ftp.mysql.com/
eur-UK: ftp://ftp.mirrorservice.org/sites/ftp.mysql.com/
eur-UK: http://mirrors.dedipower.com/www.mysql.com/
eur-UK: http://www.mirror.ac.uk/mirror/www.mysql.org/
eur-UK: ftp://ftp.mirror.ac.uk/mirror/www.mysql.org/
nam-CA: http://mysql.serenitynet.com/
nam-CA: ftp://ftp.mysql.serenitynet.com/
nam-PR: http://mirrors.hpcf.upr.edu/mysql/
nam-US: http://mysql.he.net/
nam-US: http://mirror.services.wisc.edu/mysql/
nam-US: ftp://mirror.services.wisc.edu/mirrors/mysql/
nam-US: http://mysql.mirrors.pair.com/
nam-US: http://mysql.orst.edu/
nam-US: ftp://ftp.orst.edu/pub/mysql/
nam-US: ftp://mirror.mcs.anl.gov/pub/mysql/
nam-US: http://mysql.mirror.redwire.net/
nam-US: ftp://mysql.mirror.redwire.net/pub/mysql/
nam-US: http://mysql.binarycompass.org/
nam-US: http://mysql.mirrors.hoobly.com/
nam-US: http://mirror.trouble-free.net/mysql_mirror/
nam-US: http://mirrors.24-7-solutions.net/pub/mysql/
nam-US: ftp://mirrors.24-7-solutions.net/pub/mysql/
nam-US: http://www.stathy.com/mysql/
nam-US: ftp://www.stathy.com/mysql/
nam-US: http://mirror.x10.com/mirror/mysql/
nam-US: ftp://mirror.x10.com/mysql/
sam-AR: http://mysql.localhost.net.ar/
sam-BR: http://www.linorg.usp.br/mysql/
sam-BR: ftp://ftp.linorg.usp.br/mysql/
sam-BR: ftp://ftp.pucpr.br/mysql/
sam-BR: http://mirrors.uol.com.br/pub/mysql/
sam-CL: http://mysql.vision.cl/
sam-CL: http://mysql.tecnoera.com/
asi-IN: http://mysqlmirror.netandhost.in/
asi-ID: http://komo.padinet.com/mysql/
asi-ID: ftp://komo.padinet.com/mysql/
asi-JP: http://mirror.mysql-partners-jp.biz/
asi-JP: http://ftp.iij.ad.jp/pub/db/mysql/
asi-JP: ftp://ftp.iij.ad.jp/pub/db/mysql/
asi-SG: http://mysql.oss.eznetsols.org/
asi-SG: ftp://ftp.oss.eznetsols.org/mysql/
asi-KR: http://mysql.byungsoo.net/
asi-KR: ftp://mysql.byungsoo.net/pub/mysql/
asi-KR: http://mysql.holywar.net/
asi-KR: http://mysql.new21.com/
asi-TW: http://mysql.isu.edu.tw/
asi-TW: http://mysql.cs.pu.edu.tw/
asi-TW: ftp://ftp.cs.pu.edu.tw/Unix/mysql/
asi-TW: http://ftp.stu.edu.tw/pub/Unix/Database/Mysql/
asi-TW: ftp://ftp.stu.edu.tw/pub/Unix/Database/Mysql/
aus-AU: http://mysql.planetmirror.com/
aus-AU: ftp://ftp.planetmirror.com/pub/mysql/
aus-AU: http://mysql.mirrors.ilisys.com.au/
aus-NZ: http://mysql.inspire.net.nz/
aus-NZ: ftp://mysql.inspire.net.nz/mysql/
afr-ZA: ftp://ftp.is.co.za/mirrors/mysql/
<<
# Patch Phase
PatchFile: %n.patch
PatchFile-MD5: 30355e41bfbe7d51b37336dd65c5eb6a
PatchScript: /usr/bin/sed "s|@PREFIX@|%p|g" %{PatchFile} | /usr/bin/patch -p1

# Compile Phase:
SetCFLAGS: -O3 -fomit-frame-pointer
SetCXXFLAGS: -O3 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti
SetCPPFLAGS: -I%p/lib/system-openssl/include
SetLDFLAGS: -L%p/lib/system-openssl/lib
#NoSetLDFLAGS: true
#NoSetCXX: true
#SetLIBS: -L%p/lib
#NoSetMAKEFLAGS: true
SetMAKEFLAGS: -j1
ConfigureParams: <<
--disable-dependency-tracking \
--with-innodb \
--without-readline \
--with-mysqld-user=mysql \
--with-extra-charsets=complex \
--mandir=%p/share/man \
--infodir=%p/share/info \
--localstatedir=%p/var/mysql \
--libexecdir=%p/sbin \
--sysconfdir=%p/etc \
--with-embedded-server \
--enable-thread-safe-client \
--enable-local-infile \
\
--with-openssl
<<
GCC: 4.0

InfoTest: <<
TestScript: make test || exit 2
<<

# Install Phase:
InstallScript: <<
make install DESTDIR=%d benchdir_root=%p/share/mysql libsdir=%p/lib/mysql
mkdir -p %i/var/mysql
chmod 700 %i/var/mysql
chown mysql %i/var/mysql
ln -s mysql/libmysqlclient.la %i/lib
ln -s mysql/libmysqlclient.a %i/lib
ln -s mysql/libmysqlclient.dylib %i/lib
<<
SplitOff: <<
Description: Open Source SQL database - Development headers and libraries
Package: %N15-dev
Depends: %N15-shlibs (= %v-%r)
BuildDependsOnly: True
Replaces: mysql (<= 3.23.56-1), mysql-dev, mysql12-dev, mysql14-dev
Conflicts: mysql (<= 3.23.56-1), mysql-dev, mysql12-dev, mysql14-dev
Files: <<
include
lib/mysql/*.a
lib/mysql/*.la
lib/mysql/libmysqlclient.dylib
lib/mysql/libmysqlclient_r.dylib
bin/mysql_config
lib/libmysqlclient.*
<<
DocFiles: README COPYING
<<
SplitOff2: <<
Description: Open Source SQL database - Shared libraries
Package: %N15-shlibs
Replaces: mysql (<= 3.23.51-1)
Files: <<
lib/mysql/libmysqlclient.15.0.0.dylib
lib/mysql/libmysqlclient.15.dylib
lib/mysql/libmysqlclient_r.15.0.0.dylib
lib/mysql/libmysqlclient_r.15.dylib
<<
Shlibs: <<
%p/lib/mysql/libmysqlclient.15.dylib 16.0.0 %n (>= 5.0.15-1)
%p/lib/mysql/libmysqlclient_r.15.dylib 16.0.0 %n (>= 5.0.15-1)
<<
DocFiles: README COPYING
<<
SplitOff3: <<
Description: Open Source SQL database - Client
Package: %N-client
Depends: %N15-shlibs (= %v-%r), readline5-shlibs (>= 5.0-1004)
Conflicts: mysql (<= 3.23.54a-2)
Files: <<
bin/mysql
bin/mysql_find_rows
bin/mysqlaccess
bin/mysqladmin
bin/mysqlbug
bin/mysqlcheck
bin/mysqldump
bin/mysqldumpslow
bin/mysqlimport
bin/mysqlshow
share/man/man1/mysql.1
share/man/man1/mysqlaccess.1
share/man/man1/mysqladmin.1
share/man/man1/mysqldump.1
share/man/man1/mysqlshow.1
<<
DocFiles: README COPYING
<<
DocFiles: README COPYING Docs/INSTALL-BINARY

# Build Phase:
InfoDocs: mysql.info
PostInstScript: <<
# determine directory where databases are living
data_dir=$(my_print_defaults mysqld | grep datadir | cut -d= -f2)
if [ -z "$data_dir" ]; then
data_dir=%p/var/mysql
fi

# create initial database
# it is safe to call mysql_install_db even if a db is already present
%p/bin/mysql_install_db --user=mysql
chown -R mysql:mysql $data_dir/mysql $data_dir/test

# update daemonic init script if necessary
daemonic install mysql
<<
PreRmScript: <<
# clean up
if [ $1 != "upgrade" ]; then
daemonic remove mysql
fi
<<
DaemonicFile: <<

MySQL database server
MySQL database server


%p/bin/mysqld_safe



<<

# Additional Data:
DescUsage: <<
The package creates the administrative tables on installation. Be sure
to set a MySQL root password using mysqladmin:
'mysqladmin -u root password your-new-password' or
'mysqladmin -u root -h localhost -p password your-new-password'
#
In general, you should do the following when upgrading to MySQL 4.1 from 4.0:

Important note: MySQL 4.1 stores table names and column names in UTF8. If you
have table names or column names that use characters outside of the standard
7-bit US-ASCII range, you may have to do a mysqldump of your tables in MySQL
4.0 and restore them after upgrading to MySQL 4.1. The symptom for this
problem is that you get a table not found error when trying to access your
tables. In this case, you should be able to downgrade back to MySQL 4.0 and
access your data.

After upgrading, update the grant tables to have the new longer Password
column that is needed for more secure handling of passwords. The procedure
uses mysql_fix_privilege_tables and is described in section 2.10.7 Upgrading
the Grant Tables. If you don't do this, MySQL will not us the new more
secure protocol to authenticate.

You can start the MySQL server manually using
'mysqld_safe --user=mysql &'
or you can run 'daemonic enable mysql' to create a StartupItem for it.
All of these must be done as root.
<<
DescPackaging: <<
The MySQL benchmark suite is stowed away in /share/mysql.

The InnoDB package revision by Andrei Verovski.
http://homepage.mac.com/macgurutemple/downloads.html

Previous package revisions by Christoph Pfisterer and Peter O'Gorman.
http://fink.sourceforge.net
<<
DescPort: <<
Supports Darwin out of the box, although the libtool scripts are
updated to build shared libraries. Version 3.23.47 fixes shutdown
problem on MacOS X/Darwin platform.

The 'without-readline' configure flag needs to be there to use the
readline from fink instead of the bundled copy.
<<
Homepage: http://www.mysql.com/

mysql stable port .patch

diff -Naur mysql-5.0.13-rc/mysys/default.c mysql-5.0.13-rc.fink/mysys/default.c
--- mysql-5.0.13-rc/mysys/default.c 2005-09-23 04:39:57.000000000 +0900
+++ mysql-5.0.13-rc.fink/mysys/default.c 2005-10-16 02:13:52.000000000 +0900
@@ -980,6 +980,8 @@
{
const char *env, **ptr= default_directories;

+ *ptr++= "@PREFIX@/etc/";
+
#ifdef __WIN__
*ptr++= "C:/";

diff -Naur mysql-5.0.13-rc/scripts/mysqld_safe.sh mysql-5.0.13-rc.fink/scripts/mysqld_safe.sh
--- mysql-5.0.13-rc/scripts/mysqld_safe.sh 2005-09-23 04:40:24.000000000 +0900
+++ mysql-5.0.13-rc.fink/scripts/mysqld_safe.sh 2005-10-16 02:18:56.000000000 +0900
@@ -132,22 +132,24 @@
# Second, try to find the data directory
#

-# Try where the binary installs put it
-if test -d $MY_BASEDIR_VERSION/data/mysql
-then
- DATADIR=$MY_BASEDIR_VERSION/data
- if test -z "$defaults" -a -r "$DATADIR/my.cnf"
- then
- defaults="--defaults-extra-file=$DATADIR/my.cnf"
- fi
-# Next try where the source installs put it
-elif test -d $MY_BASEDIR_VERSION/var/mysql
-then
- DATADIR=$MY_BASEDIR_VERSION/var
-# Or just give up and use our compiled-in default
-else
+# Fink's MySQL uses @PREFIX@/var/lib by default..
+
+# # Try where the binary installs put it
+# if test -d $MY_BASEDIR_VERSION/data/mysql
+# then
+# DATADIR=$MY_BASEDIR_VERSION/data
+# if test -z "$defaults" -a -r "$DATADIR/my.cnf"
+# then
+# defaults="--defaults-extra-file=$DATADIR/my.cnf"
+# fi
+# # Next try where the source installs put it
+# elif test -d $MY_BASEDIR_VERSION/var/mysql
+# then
+# DATADIR=$MY_BASEDIR_VERSION/var
+# # Or just give up and use our compiled-in default
+# else
DATADIR=@localstatedir@
-fi
+# fi

if test -z "$MYSQL_HOME"
then
From: msvensson at mysql dot com
Date: December 22 2006 12:38am
Subject: bk commit into 5.0 tree (msvensson:1.2353) BUG#23125

Below is the list of changes that have just been committed into a local
5.0 repository of msvensson. When msvensson does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2006-12-22 00:38:34+01:00, msvensson@stripped +5 -0
Bug #23125 [patch] trigger test fails when run as root
- Skip tests using chmod when running as root

mysql-test/t/information_schema_chmod.test@stripped, 2006-12-22 00:38:30+01:00, msvensson@stripped +2 -2
Use mysqltest builtin "chmode"

mysql-test/t/mysqltest.test@stripped, 2006-12-22 00:38:30+01:00, msvensson@stripped +3 -0
Dont run as root - test chmod

mysql-test/t/rpl_rotate_logs.test@stripped, 2006-12-22 00:38:30+01:00, msvensson@stripped +5 -3
Use mysqltest builtin "chmode"
Use 'write_file' and 'chmod' instead of system

mysql-test/t/trigger.test@stripped, 2006-12-22 00:38:30+01:00, msvensson@stripped +10 -4
Don't run as root
Use 'write_file' and 'chmod'

mysql-test/t/varbinary.test@stripped, 2006-12-22 00:38:31+01:00, msvensson@stripped +4 -0
Don't run as root

# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: msvensson
# Host: pilot.mysql.com
# Root: /home/msvensson/mysql/mysql-5.0-maint

--- 1.56/mysql-test/t/trigger.test 2006-11-13 23:38:34 +01:00
+++ 1.57/mysql-test/t/trigger.test 2006-12-22 00:38:30 +01:00
@@ -1,3 +1,7 @@
+# This test uses chmod, can't be run with root permissions
+-- source include/not_as_root.inc
+
+
#
# Basic triggers test
#
@@ -1138,8 +1142,10 @@
event_object_table, action_statement from information_schema.triggers
where event_object_schema = 'test';
# Trick which makes update of second .TRN file impossible
-system echo dummy >$MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~;
-system chmod 000 $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~;
+write_file $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~;
+dummy
+EOF
+chmod 0000 $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~;
--error 1
rename table t1 to t2;
# 't1' should be still there and triggers should work correctly
@@ -1148,8 +1154,8 @@
select trigger_schema, trigger_name, event_object_schema,
event_object_table, action_statement from information_schema.triggers
where event_object_schema = 'test';
-system chmod 600 $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~;
-system rm $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~;
+chmod 0600 $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~;
+remove_file $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~;
# Let us check that updates to .TRN files were rolled back too
drop trigger t1_bi;
drop trigger t1_ai;

--- 1.49/mysql-test/t/mysqltest.test 2006-11-30 10:56:30 +01:00
+++ 1.50/mysql-test/t/mysqltest.test 2006-12-22 00:38:30 +01:00
@@ -1,6 +1,9 @@
# This test should work in embedded server after mysqltest is fixed
-- source include/not_embedded.inc

+# This test uses chmod, can't be run with root permissions
+-- source include/not_as_root.inc
+
# ============================================================================
#
# Test of mysqltest itself

--- 1.11/mysql-test/t/varbinary.test 2006-11-29 23:03:43 +01:00
+++ 1.12/mysql-test/t/varbinary.test 2006-12-22 00:38:31 +01:00
@@ -1,3 +1,7 @@
+# This test uses chmod, can't be run with root permissions
+-- source include/not_as_root.inc
+
+
# Initialise
--disable_warnings
drop table if exists t1;

--- 1.2/mysql-test/t/information_schema_chmod.test 2006-05-23 10:52:46 +02:00
+++ 1.3/mysql-test/t/information_schema_chmod.test 2006-12-22 00:38:30 +01:00
@@ -17,7 +17,7 @@
#
create database mysqltest;
create table mysqltest.t1(a int);
---exec chmod -r $MYSQLTEST_VARDIR/master-data/mysqltest
+chmod 0000 $MYSQLTEST_VARDIR/master-data/mysqltest;
select table_schema from information_schema.tables where table_schema='mysqltest';
---exec chmod +r $MYSQLTEST_VARDIR/master-data/mysqltest
+exec chmod 0777 $MYSQLTEST_VARDIR/master-data/mysqltest;
drop database mysqltest;

--- 1.65/mysql-test/t/rpl_rotate_logs.test 2006-04-24 10:21:04 +02:00
+++ 1.66/mysql-test/t/rpl_rotate_logs.test 2006-12-22 00:38:30 +01:00
@@ -17,8 +17,10 @@
drop table if exists t1, t2, t3, t4;
--enable_warnings
connect (slave,localhost,root,,test,$SLAVE_MYPORT,slave.sock);
-system cat /dev/null > $MYSQLTEST_VARDIR/slave-data/master.info;
-system chmod 000 $MYSQLTEST_VARDIR/slave-data/master.info;
+# Create empty file
+write_file $MYSQLTEST_VARDIR/slave-data/master.info;
+EOF
+chmod 0000 $MYSQLTEST_VARDIR/slave-data/master.info;
connection slave;
--disable_warnings
drop table if exists t1, t2, t3, t4;
@@ -29,7 +31,7 @@
--replace_result $MYSQL_TEST_DIR TESTDIR
--error 1105,1105,29
start slave;
-system chmod 600 $MYSQLTEST_VARDIR/slave-data/master.info;
+chmod 0600 $MYSQLTEST_VARDIR/slave-data/master.info;
# It will fail again because the file is empty so the slave cannot get valuable
# info about how to connect to the master from it (failure in
# init_strvar_from_file() in init_master_info()).
From: kent at mysql dot com
Date: January 2 2007 11:01am
Subject: bk commit into 5.0 tree (kent:1.2357) BUG#25359

Below is the list of changes that have just been committed into a local
5.0 repository of kent. When kent does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2007-01-02 11:01:48+01:00, kent@stripped +1 -0
view.result:
Temporary work around for bug#25359

mysql-test/r/view.result@stripped, 2007-01-02 11:01:39+01:00, kent@stripped +4 -4
Temporary work around for bug#25359

# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: kent
# Host: kent-amd64.(none)
# Root: /home/kent/bk/main/mysql-5.0

--- 1.184/mysql-test/r/view.result 2007-01-02 11:01:54 +01:00
+++ 1.185/mysql-test/r/view.result 2007-01-02 11:01:54 +01:00
@@ -2686,12 +2686,12 @@
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select (year(now()) - year(`t1`.`DOB`)) AS `Age` from `t1` having (`Age` < 75)
SELECT (year(now())-year(DOB)) AS Age FROM t1 HAVING Age < 75;
Age
-42
-38
+43
+39
SELECT * FROM v1;
Age
-42
-38
+43
+39
DROP VIEW v1;
DROP TABLE t1;
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a char(6) DEFAULT 'xxx');

mysql _unstable_ port information

Info2:<<
Package: mysql%type_pkg[-ssl]
Version: 5.0.38
Revision: 1005
Description: Open Source SQL database
License: GPL/LGPL
Maintainer: Todai Fink Team
Type: -ssl (.)

# Dependencies:
Depends: %N15-shlibs (= %v-%r), %N-client (= %v-%r), daemonic (>= 20010902-1)
BuildDepends: readline5 (>= 5.0-1004), fink (>= 0.25)
Conflicts: %{Ni}, %{Ni}-ssl
Replaces: %{Ni}, %{Ni}-ssl

# Unpack Phase:
# Source: mirror:custom:Downloads/MySQL-5.0/%{ni}-%v.tar.gz
# For Enterprise Server
Source: ftp://ftp.%{ni}.com/pub/%{ni}/src/%{ni}-%v.tar.gz
Source-MD5: 9abf789eb57b7c21294ae50eb4a94462
CustomMirror: <<
# Some country codes not in /sw/lib/fink/mirror/_keys
eur-AM: http://mysql.mirrors.arminco.com/
eur-AT: http://gd.tuwien.ac.at/db/mysql/
eur-AT: ftp://gd.tuwien.ac.at/db/mysql/
eur-BE: http://mysql.belnet.be/
eur-BE: ftp://ftp.belnet.be/mirror/ftp.mysql.com/pub/mysql/
eur-BE: http://mysql.easynet.be/
eur-BE: ftp://ftp.easynet.be/mysql/
eur-BE: http://mysql.skynet.be/
eur-BE: ftp://ftp.mysql.skynet.be/pub/ftp.mysql.com/
eur-BA: http://mysql.blic.net/
eur-BG: http://mysql.online.bg/
eur-BG: ftp://mysql.online.bg/
eur-CZ: http://mysql.linux.cz/
eur-CZ: ftp://ftp.fi.muni.cz/pub/mysql/
eur-DK: http://mysql.borsen.dk/
eur-DK: http://mysql.mirrors.cybercity.dk/
eur-DK: http://mirrors.dotsrc.org/mysql/
eur-DK: ftp://mirrors.dotsrc.org/mysql/
eur-FI: http://mysql.tonnikala.org/
eur-FR: http://mir2.ovh.net/ftp.mysql.com/
eur-FR: ftp://mir1.ovh.net/ftp.mysql.com/
eur-FR: http://mysql.crihan.fr/
eur-FR: ftp://ftp.inria.fr/pub/MySQL/
eur-FR: http://ftp.club-internet.fr/mirrors/ftp.mysql.com/
eur-FR: ftp://ftp.club-internet.fr/pub/mirrors/ftp.mysql.com/
eur-FR: http://mirrors.ircam.fr/pub/mysql/
eur-FR: ftp://mirrors.ircam.fr/pub/mysql/
eur-DE: http://sunsite.informatik.rwth-aachen.de/mysql/
eur-DE: ftp://sunsite.informatik.rwth-aachen.de/pub/mirror/www.mysql.com/
eur-DE: http://ftp.gwdg.de/pub/misc/mysql/
eur-DE: ftp://ftp.gwdg.de/pub/misc/mysql/
eur-DE: ftp://ftp.fu-berlin.de/unix/databases/mysql/
eur-DE: http://ftp.plusline.de/mysql/
eur-DE: ftp://ftp.plusline.de/pub/mysql/
eur-GR: http://mirrors.ntua.gr/MySQL/
eur-GR: ftp://ftp.ntua.gr/pub/databases/mysql/
eur-GR: http://mirrors.ee.teiath.gr/mysql/
eur-GR: ftp://mirrors.ee.teiath.gr/pub/mysql/
eur-HU: http://mysql.sote.hu/
eur-HU: ftp://xenia.sote.hu/pub/mirrors/www.mysql.com/
eur-HU: http://mysql.mirrors.crysys.hit.bme.hu/
eur-HU: ftp://ftp.crysys.hu/pub/mysql/
eur-IS: http://mysql.rhnet.is/
eur-IS: ftp://ftp.rhnet.is/pub/mysql/
eur-IE: http://ftp.heanet.ie/mirrors/www.mysql.com/
eur-IE: ftp://ftp.heanet.ie/mirrors/www.mysql.com/
eur-IT: http://mirror.tomato.it/mysql/
eur-IT: http://na.mirror.garr.it/mirrors/MySQL/
eur-IT: ftp://na.mirror.garr.it/mirrors/MySQL/
eur-NL: http://mysql.proserve.nl/
eur-NL: ftp://mysql.proserve.nl/pub/mysql/Downloads
eur-NL: http://ftp.snt.utwente.nl/pub/software/mysql/
eur-NL: ftp://ftp.snt.utwente.nl/pub/software/mysql/
eur-PL: http://sunsite.icm.edu.pl/mysql/
eur-PL: ftp://sunsite.icm.edu.pl/pub/unix/mysql/
eur-PT: http://mysql.nfsi.pt/
eur-PT: ftp://ftp.nfsi.pt/pub/mysql/
eur-PT: http://mysql.netvisao.pt/
eur-PT: ftp://mirrors2.netvisao.pt/mysql/
eur-PT: http://lisa.gov.pt/ftp/mysql/
eur-PT: ftp://ftp.roedu.net/pub/mirrors/ftp.mysql.com/
eur-RO: ftp://mirrors.fibernet.ro/1/MySQL/
eur-RO: http://mysql.ran.ro/
eur-RO: ftp://ftp.ran.ro/pub/mirrors/ftp.mysql.com/
eur-RU: http://mysql.directnet.ru/
eur-RU: ftp://ftp.dn.ru/pub/MySQL/
eur-RU: http://mysql.dn.ru/
eur-RU: http://mysql.mix.su/
eur-RU: ftp://mysql.mix.su/
eur-SI: http://mirrors.bevc.net/mysql/
eur-SI: ftp://ftp.bevc.net/mirrors/mysql/
eur-SI: http://ftp.arnes.si/mysql/
eur-SI: ftp://ftp.arnes.si/packages/mysql/
eur-SI: http://www.wsection.com/mysql/
eur-ES: http://mysql.rediris.es/
eur-ES: ftp://ftp.rediris.es/mirror/mysql/
eur-SE: http://mysql.dataphone.se/
eur-SE: ftp://mirror2.dataphone.se/pub/mysql/
eur-CH: http://mirror.switch.ch/ftp/mirror/mysql/
eur-CH: ftp://mirror.switch.ch/mirror/mysql/
eur-CH: ftp://ftp.solnet.ch/mirror/mysql/
eur-TR: http://mysql.progen.com.tr/
eur-UA: http://mysql.net.ua/
eur-UA: ftp://ftp.tlk-l.net/pub/mirrors/mysql.com/
eur-UA: http://mysql.infocom.ua/
eur-UK: http://mysql.mirror.anlx.net/
eur-UK: http://www.mirrorservice.org/sites/ftp.mysql.com/
eur-UK: ftp://ftp.mirrorservice.org/sites/ftp.mysql.com/
eur-UK: http://mirrors.dedipower.com/www.mysql.com/
eur-UK: http://www.mirror.ac.uk/mirror/www.mysql.org/
eur-UK: ftp://ftp.mirror.ac.uk/mirror/www.mysql.org/
nam-CA: http://mysql.serenitynet.com/
nam-CA: ftp://ftp.mysql.serenitynet.com/
nam-PR: http://mirrors.hpcf.upr.edu/mysql/
nam-US: http://mirror.trouble-free.net/mysql_mirror/
nam-US: http://mysql.binarycompass.org/
nam-US: http://mysql.he.net/
nam-US: http://www.stathy.com/mysql/
nam-US: ftp://www.stathy.com/mysql/
nam-US: http://mysql.mirrors.hoobly.com/
nam-US: ftp://mirror.mcs.anl.gov/pub/mysql/
nam-US: http://mysql.mirrors.pair.com/
nam-US: http://mirror.x10.com/mirror/mysql/
nam-US: ftp://mirror.x10.com/mysql/
nam-US: http://mirror.services.wisc.edu/mysql/
nam-US: ftp://mirror.services.wisc.edu/mirrors/mysql/
nam-US: http://mirrors.24-7-solutions.net/pub/mysql/
nam-US: ftp://mirrors.24-7-solutions.net/pub/mysql/
nam-US: http://mysql.orst.edu/
nam-US: ftp://ftp.orst.edu/pub/mysql/
nam-US: http://mysql.mirror.redwire.net/
nam-US: ftp://mysql.mirror.redwire.net/pub/mysql/
sam-AR: http://mysql.localhost.net.ar/
sam-BR: ftp://ftp.pucpr.br/mysql/
sam-BR: http://mirrors.uol.com.br/pub/mysql/
sam-CL: http://mysql.vision.cl/
sam-CL: http://mysql.tecnoera.com/
asi-IN: http://mysqlmirror.netandhost.in/
asi-ID: http://komo.padinet.com/mysql/
asi-ID: ftp://komo.padinet.com/mysql/
asi-JP: http://mirror.mysql-partners-jp.biz/
asi-JP: http://ftp.iij.ad.jp/pub/db/mysql/
asi-JP: ftp://ftp.iij.ad.jp/pub/db/mysql/
asi-SG: http://mysql.oss.eznetsols.org/
asi-SG: ftp://ftp.oss.eznetsols.org/mysql/
asi-KR: http://mysql.byungsoo.net/
asi-KR: ftp://mysql.byungsoo.net/pub/mysql/
asi-KR: http://mysql.holywar.net/
asi-KR: http://mysql.new21.com/
asi-TW: http://mysql.isu.edu.tw/
asi-TW: http://mysql.cs.pu.edu.tw/
asi-TW: ftp://ftp.cs.pu.edu.tw/Unix/mysql/
asi-TW: http://ftp.stu.edu.tw/pub/Unix/Database/Mysql/
asi-TW: ftp://ftp.stu.edu.tw/pub/Unix/Database/Mysql/
aus-AU: http://mysql.planetmirror.com/
aus-AU: ftp://ftp.planetmirror.com/pub/mysql/
aus-AU: http://mysql.mirrors.ilisys.com.au/
aus-NZ: http://mysql.inspire.net.nz/
aus-NZ: ftp://mysql.inspire.net.nz/mysql/
afr-ZA: ftp://ftp.is.co.za/mirrors/mysql/
<<
# Patch Phase
PatchFile: %{ni}.patch
PatchFile-MD5: a8deb268b18c5cd38be857c9290562fc
PatchScript: /usr/bin/sed "s|@PREFIX@|%p|g" %{PatchFile} | /usr/bin/patch -p1

# Compile Phase:
# See BUILD/compile-ppc-max
SetCFLAGS: -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -O3 -fno-omit-frame-pointer -g
SetCXXFLAGS: -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -O3 -fno-omit-frame-pointer -g
NoSetMAKEFLAGS: true
SetMAKEFLAGS: -j1
ConfigureParams: <<
--enable-assembler \
--with-extra-charsets=complex \
--enable-thread-safe-client \
--with-big-tables \
--with-innodb \
--with-archive-storage-engine \
--with-big-tables \
--with-blackhole-storage-engine \
--with-federated-storage-engine \
--with-csv-storage-engine \
--with-embedded-server \
--enable-local-infile \
--with-ndbcluster \
\
--without-readline \
--disable-dependency-tracking \
--with-mysqld-user=mysql \
(%type_pkg[-ssl]) --with-yassl \
\
--mandir=%p/share/man \
--infodir=%p/share/info \
--localstatedir=%p/var/mysql \
--libexecdir=%p/sbin \
--sysconfdir=%p/etc
<<
GCC: 4.0

InfoTest: <<
TestScript: [[ "$UID" -eq 0 ]] && { chown -R nobody. ./mysql-test && /usr/bin/sudo -u nobody make test-force || exit 2; } || { make test-force || exit 2; }
<<

# Install Phase:
InstallScript: <<
make install DESTDIR=%d benchdir_root=%p/share/mysql libsdir=%p/lib/mysql
ln -s mysql/libmysqlclient.la %i/lib
ln -s mysql/libmysqlclient.a %i/lib
ln -s mysql/libmysqlclient.dylib %i/lib

# Remove %p/bin/test, which is also included in coreutils.
rm -f %i/bin/test
<<
SplitOff: <<
Description: Open Source SQL database - Development headers and libraries
Package: %N15-dev
Depends: %N15-shlibs (= %v-%r)
BuildDependsOnly: True
Conflicts: %{Ni} (<= 3.23.56-1), %{Ni}-dev, %{Ni}12-dev, %{Ni}14-dev, %{Ni}15-dev, %{Ni}-ssl15-dev
Replaces: %{Ni} (<< 5.0.38-1004), %{Ni}-ssl (<< 5.0.38-1004), %{Ni}-dev, %{Ni}12-dev, %{Ni}14-dev, %{Ni}15-dev, %{Ni}-ssl15-dev
Files: <<
include
lib/mysql/*.a
lib/mysql/*.la
lib/mysql/libmysqlclient.dylib
lib/mysql/libmysqlclient_r.dylib
lib/mysql/libndbclient.dylib
bin/mysql_config
lib/libmysqlclient.*
share/man/man1/mysql_config.1
<<
DocFiles: README COPYING
<<
SplitOff2: <<
Description: Open Source SQL database - Shared libraries
Package: %N15-shlibs
Conflicts: %{Ni}15-shlibs, %{Ni}-ssl15-shilbs
Replaces: %{Ni} (<< 5.0.38-1004), %{Ni}-ssl (<< 5.0.38-1004), %{Ni}15-shlibs, %{Ni}-ssl15-shilbs
Files: <<
lib/mysql/libmysqlclient.15.0.0.dylib
lib/mysql/libmysqlclient.15.dylib
lib/mysql/libmysqlclient_r.15.0.0.dylib
lib/mysql/libmysqlclient_r.15.dylib
lib/mysql/libndbclient.2.0.0.dylib
lib/mysql/libndbclient.2.dylib
<<
Shlibs: <<
%p/lib/mysql/libmysqlclient.15.dylib 16.0.0 %n (>= 5.0.15-1)
%p/lib/mysql/libmysqlclient_r.15.dylib 16.0.0 %n (>= 5.0.15-1)
%p/lib/mysql/libndbclient.2.dylib 3.0.0 %n (>= 5.0.38-1004)
<<
DocFiles: README COPYING
<<
SplitOff3: <<
Description: Open Source SQL database - Client
Package: %N-client
Depends: %N15-shlibs (= %v-%r), readline5-shlibs (>= 5.0-1004)
Conflicts: %{Ni} (<= 3.23.54a-2), %{Ni}-client, %{Ni}-ssl-client
Replaces: %{Ni} (<= 5.0.38-1001), %{Ni}-ssl (<= 5.0.38-1001), %{Ni}-client, %{Ni}-ssl-client
Files: <<
bin/myisam_ftdump
bin/mysql
bin/mysql_client_test
bin/mysql_client_test_embedded
bin/mysql_explain_log
bin/mysql_find_rows
bin/mysql_fix_extensions
bin/mysql_tableinfo
bin/mysql_waitpid
bin/mysqlaccess
bin/mysqladmin
bin/mysqlbug
bin/mysqlcheck
bin/mysqldump
bin/mysqldumpslow
bin/mysqlimport
bin/mysqlshow
bin/mysqltest_embedded
bin/mysqltestmanager
bin/mysqltestmanager-pwgen
bin/mysqltestmanagerc
share/man/man1/mysql.1
share/man/man1/mysqlaccess.1
share/man/man1/mysqladmin.1
share/man/man1/mysqlcheck.1
share/man/man1/mysqldump.1
share/man/man1/mysqlimport.1
share/man/man1/mysqlshow.1
share/man/man1/myisam_ftdump.1
share/man/man1/mysql_explain_log.1
share/man/man8/mysqlmanager.8
<<
DocFiles: README COPYING
<<
DocFiles: README COPYING

# Build Phase:
InfoDocs: mysql.info
PostInstScript: <<
/usr/bin/install -o mysql -g mysql -m 700 -d %p/var/mysql

# determine directory where databases are living
data_dir=$(my_print_defaults mysqld | grep datadir | cut -d= -f2)
if [ -z "$data_dir" ]; then
data_dir=%p/var/mysql
fi

if [[ -e "$data_dir"/mysql || -e "$data_dir"/test ]]; then
echo "$data_dir/mysql found. If you're upgrading from older version"
echo "of MySQL, you should run %p/bin/mysql_upgrade_shell script."
echo "See: http://dev.mysql.com/doc/refman/5.0/en/upgrade.html"
else
# create initial database
%p/bin/mysql_install_db --user=mysql
chown -R mysql:mysql $data_dir/mysql $data_dir/test
fi

# update daemonic init script if necessary
daemonic install mysql
<<
PreRmScript: <<
# clean up
if [ $1 != "upgrade" ]; then
daemonic remove mysql
fi
<<
DaemonicName: mysql
DaemonicFile: <<

MySQL database server
MySQL database server


%p/bin/mysqld_safe



<<

# Additional Data:
DescUsage: <<
The package creates the administrative tables on installation. Be sure
to set a MySQL root password using mysqladmin:
'mysqladmin -u root password your-new-password' or
'mysqladmin -u root -h localhost -p password your-new-password'
#
If you are upgrading from MySQL 4.1, you should update your tables using
'mysql_upgrade_shell' script. For more information about upgrading,
please read "2.4.16. Upgrading MySQL" in MySQL 5.0 Reference Manual.
#
You can start the MySQL server manually using
'mysqld_safe --user=mysql &'
or you can run 'daemonic enable mysql' to create a StartupItem for it.
All of these must be done as root.
<<
DescPackaging: <<
The MySQL benchmark suite is stowed away in /share/mysql.

The InnoDB package revision by Andrei Verovski.
http://homepage.mac.com/macgurutemple/downloads.html

Previous package revisions by Christoph Pfisterer and Peter O'Gorman.
<<
DescPort: <<
Supports Darwin out of the box, although the libtool scripts are
updated to build shared libraries. Version 3.23.47 fixes shutdown
problem on MacOS X/Darwin platform.

The 'without-readline' configure flag needs to be there to use the
readline from fink instead of the bundled copy.

It is being considered that installation directory for MySQL from
%p to %p/lib/mysql, in order to avoid having utility programs
like "perror", or "replace" in %p/bin. Maybe their names are too
much neutral.

mysql-ssl15-dev and mysql-ssl15-shlibs are named such, by mistake.
It's not impossible to rename them, but just left as they are.
<<
Homepage: http://dev.mysql.com/
<<

mysql _unstable_ port .patch

diff -Naur mysql-5.0.13-rc/mysys/default.c mysql-5.0.13-rc.fink/mysys/default.c
--- mysql-5.0.13-rc/mysys/default.c 2005-09-23 04:39:57.000000000 +0900
+++ mysql-5.0.13-rc.fink/mysys/default.c 2005-10-16 02:13:52.000000000 +0900
@@ -980,6 +980,8 @@
{
const char *env, **ptr= default_directories;

+ *ptr++= "@PREFIX@/etc/";
+
#ifdef __WIN__
*ptr++= "C:/";

diff -Naur mysql-5.0.13-rc/scripts/mysqld_safe.sh mysql-5.0.13-rc.fink/scripts/mysqld_safe.sh
--- mysql-5.0.13-rc/scripts/mysqld_safe.sh 2005-09-23 04:40:24.000000000 +0900
+++ mysql-5.0.13-rc.fink/scripts/mysqld_safe.sh 2005-10-16 02:18:56.000000000 +0900
@@ -132,22 +132,24 @@
# Second, try to find the data directory
#

-# Try where the binary installs put it
-if test -d $MY_BASEDIR_VERSION/data/mysql
-then
- DATADIR=$MY_BASEDIR_VERSION/data
- if test -z "$defaults" -a -r "$DATADIR/my.cnf"
- then
- defaults="--defaults-extra-file=$DATADIR/my.cnf"
- fi
-# Next try where the source installs put it
-elif test -d $MY_BASEDIR_VERSION/var/mysql
-then
- DATADIR=$MY_BASEDIR_VERSION/var
-# Or just give up and use our compiled-in default
-else
+# Fink's MySQL uses @PREFIX@/var/lib by default..
+
+# # Try where the binary installs put it
+# if test -d $MY_BASEDIR_VERSION/data/mysql
+# then
+# DATADIR=$MY_BASEDIR_VERSION/data
+# if test -z "$defaults" -a -r "$DATADIR/my.cnf"
+# then
+# defaults="--defaults-extra-file=$DATADIR/my.cnf"
+# fi
+# # Next try where the source installs put it
+# elif test -d $MY_BASEDIR_VERSION/var/mysql
+# then
+# DATADIR=$MY_BASEDIR_VERSION/var
+# # Or just give up and use our compiled-in default
+# else
DATADIR=@localstatedir@
-fi
+# fi

if test -z "$MYSQL_HOME"
then