mysql-4.1.10 stable port information

Package: mysql
Version: 4.1.10
Revision: 10034
Distribution: 10.4, 10.5
Description: Open Source SQL database
License: GPL/LGPL
Maintainer: None

# Dependencies:
Depends: %N14-shlibs (= %v-%r), %N-client (= %v-%r), daemonic (>= 20010902-1)
BuildDepends: readline5, fink (>= 0.24.12-1)

# Unpack Phase:
Source: mirror:custom:Downloads/MySQL-4.1/%n-%v.tar.gz
Source-MD5: 27b27b74f430aaeb77fb8d4e6f32ac4d
CustomMirror: <<
eur-AR: ftp://mysql.abideweb.com/mirrors/MySQL/
eur-AT: ftp://gd.tuwien.ac.at/db/mysql/
eur-BE: ftp://ftp.belnet.be/mirror/ftp.mysql.com/pub/mysql/
eur-CZ: ftp://ftp.fi.muni.cz/pub/mysql/
eur-CZ: ftp://ftp.gin.cz/pub/MIRRORS/www.mysql.com/
eur-DK: ftp://sunsite.dk/mirrors/mysql/
eur-DE: ftp://ftp.gwdg.de/pub/misc/mysql/
eur-DE: ftp://sunsite.informatik.rwth-aachen.de/pub/mirror/www.mysql.com/
eur-DE: ftp://filepile.tiscali.de/mirror/mysql/
eur-DE: ftp://ftp.fh-wolfenbuettel.de/pub/database/mysql/
eur-FR: ftp://ftp.free.fr/pub/MySQL/
eur-FR: ftp://mir1.ovh.net/ftp.mysql.com/
eur-FR: ftp://ftp.u-paris10.fr/mysql.com/
eur-GR: ftp://ftp.ntua.gr/pub/databases/mysql/
eur-HU: ftp://mysql.tiszanet.hu/pub/mirrors/mysql/
eur-HU: ftp://xenia.sote.hu/pub/mirrors/www.mysql.com/
eur-IE: ftp://ftp.esat.net/mirrors/download.sourceforge.net/pub/mirrors/mysql/
eur-LV: ftp://ftp.linux.lv/pub/software/mysql/
eur-NE: ftp://mirror.widexs.nl/pub/mysql/
eur-PO: ftp://sunsite.icm.edu.pl/pub/unix/mysql/
eur-PL: ftp://darkstar.ist.utl.pt/pub/mysql/
eur-PL: ftp://mirrors2.netvisao.pt/pub/mysql/
eur-PL: ftp://ftp.telepac.pt/pub/mysql/
eur-PL: ftp://ftp.vizzavi.pt/pub/mysql/
eur-RU: ftp://ftp.dn.ru/pub/MySQL/
eur-RU: ftp://ftp.chg.ru/pub/databases/mysql/
eur-SI: ftp://ftp.arnes.si/packages/mysql/
eur-SE: ftp://ftp.sunet.se/pub/unix/databases/relational/mysql/
eur-CH: ftp://sunsite.cnlab-switch.ch/mirror/mysql/
eur-UK: ftp://ftp.plig.org/pub/mysql/
eur-UA: ftp://ftp.tlk-l.net/pub/mirrors/mysql.com/
eur-UA: ftp://mysql.paco.net.ua/
eur-YU: ftp://ftp.linux.org.yu/pub/MySQL/
nam-MX: ftp://mysql.azc.uam.mx/mirrors/mysql/
nam-MX: ftp://mysql.unam.mx/pub/mysql/
nam-US: ftp://mysql.nixc.net/pub/mysql/
nam-US: ftp://ftp.orst.edu/pub/mysql/
nam-US: ftp://mirror.mcs.anl.gov/pub/mysql/
nam-US: ftp://mirror.sit.wisc.edu/mirrors/mysql/
nam-US: ftp://mysql.secsup.org/pub/software/mysql/
sam-AR: ftp://mysql.bannerlandia.com.ar/mirrors/mysql/
sam-BR: ftp://ftp.linorg.usp.br/mysql/
sam-CL: ftp://ftp.psinet.cl/pub/database/mysql/
sam-CR: ftp://mysql.ogmios.co.cr/pub/mysql/
asi-CN: ftp://mysql.ihostunit.com/pub/Mirror/mysql/
asi-CN: ftp://ftp.shellhung.org/pub/Mirror/mysql/
asi-ID: ftp://mysql.incaf.net/
asi-ID: ftp://mysql.mweb.net.id/pub/database/mysql/
asi-ID: ftp://mysql.itb.web.id/pub/MySQL/
asi-JP: ftp://ftp.u-aizu.ac.jp/ftp/pub/dbms/mysql/mysql.com/
asi-SG: ftp://ftp.hjc.edu.sg/mysql/
asi-TW: ftp://mysql.uahrc.se.ntou.edu.tw/
oce-AU: ftp://planetmirror.com/pub/mysql/
<<
# Patch Phase
PatchFile: %n-%v.patch
PatchFile-MD5: 7606fed0372f13d9ca0d6af2196185ca
PatchScript: <<
%{default_script}
perl -pi -e 's,-qlanglvl=ansi,,g' configure
<<

# Compile Phase:
SetCFLAGS: -O3 -fomit-frame-pointer -DFINK_ETC="\"%p/etc/\""
SetCXXFLAGS: -O3 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -DFINK_ETC="\"%p/etc/\""
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
GCC: 4.0

CompileScript: <<
mysql_cv_btype_last_arg_accept=socklen_t F77=no ./configure %c
perl -pi.bak -e 's/CCLD =.*/CCLD = g++/g' isam/Makefile
perl -pi.bak -e 's/CCLD =.*/CCLD = g++/g' myisam/Makefile
make
<<

# 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
mkdir -p %i/share/doc/%n
cd Docs/; cp -R *.html *.ps *.txt INSTALL-BINARY %i/share/doc/%n/
cd %i/lib && ln -s mysql/libmysqlclient.la . && ln -s mysql/libmysqlclient.a . && ln -s mysql/libmysqlclient.dylib .
<<
SplitOff: <<
Description: Open Source SQL database - Development headers and libraries
Package: %N14-dev
Depends: %N14-shlibs (= %v-%r)
BuildDependsOnly: True
Replaces: mysql (<= 3.23.56-1), mysql-dev, mysql12-dev, mysql15-dev, mysql-ssl15-dev
Conflicts: mysql (<= 3.23.56-1), mysql-dev, mysql12-dev, mysql15-dev, mysql-ssl15-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: %N14-shlibs
Replaces: mysql (<= 3.23.51-1)
Files: lib/mysql/libmysqlclient.14.0.0.dylib lib/mysql/libmysqlclient.14.dylib lib/mysql/libmysqlclient_r.14.0.0.dylib lib/mysql/libmysqlclient_r.14.dylib
Shlibs: <<
%p/lib/mysql/libmysqlclient.14.dylib 15.0.0 %n (>= 4.1.7-11)
%p/lib/mysql/libmysqlclient_r.14.dylib 15.0.0 %n (>= 4.1.7-11)
<<
DocFiles: README COPYING
<<
SplitOff3: <<
Description: Open Source SQL database - Client
Package: %N-client
Depends: %N14-shlibs (= %v-%r), readline5-shlibs
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

# 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.
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-4.1.10 stable port .patch

diff -urN mysql-4.0.17.orig/configure mysql-4.0.17/configure
--- mysql-4.0.17.orig/configure Mon Dec 15 06:24:06 2003
+++ mysql-4.0.17/configure Fri Jan 9 07:58:24 2004
@@ -23695,6 +23695,15 @@
fi
;;
*darwin6*)
+ if test "$ac_cv_c_compiler_gnu" = "yes"
+ then
+ FLAGS="-DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH -DFN_NO_CASE_SENCE"
+ CFLAGS="$CFLAGS $FLAGS"
+ CXXFLAGS="$CXXFLAGS $FLAGS"
+ MAX_C_OPTIMIZE="-O"
+ fi
+ ;;
+ *darwin8*)
if test "$ac_cv_c_compiler_gnu" = "yes"
then
FLAGS="-DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DHAVE_BROKEN_REALPATH -DFN_NO_CASE_SENCE"
--- mysql-4.1.7/mysys/default.c~ 2004-10-23 16:28:44.000000000 +0900
+++ mysql-4.1.7/mysys/default.c 2005-02-18 23:17:10.000000000 +0900
@@ -43,6 +43,9 @@
/* Which directories are searched for options (and in which order) */

const char *default_directories[]= {
+#ifdef FINK_ETC
+ FINK_ETC,
+#endif
#ifdef __WIN__
"C:/",
#elif defined(__NETWARE__)

mysql-4.1.10 _unstable_ port .patch