mysql-4.0.22 stable port information

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

# Dependencies:
Depends: %N12-shlibs (= %v-%r), %N-client (= %v-%r), daemonic (>= 20010902-1)
BuildDepends: readline5, libxml2, gdbm3, expat1, darwin (>= 7.0-1), libtool14, libncurses5 (>= 5.4-20041023-1006), fink (>= 0.24.12-1)

# Unpack Phase:
Source: mirror:custom:Downloads/MySQL-4.0/%n-%v.tar.gz
Source-MD5: fab53259c3ba9f729a319bf271fc8587
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: f113151edc53e00d932a04355264b5b9

# Compile Phase:
SetCFLAGS: -O3 -fomit-frame-pointer
SetCXXFLAGS: -O3 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti
NoSetLDFLAGS: true
NoSetCXX: true
SetLIBS: -L%p/lib
NoSetMAKEFLAGS: true
SetMAKEFLAGS: -j1
ConfigureParams: --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 --disable-dependency-tracking --enable-thread-safe-client --enable-local-infile
GCC: 4.0

CompileScript: <<
mysql_cv_btype_last_arg_accept=socklen_t F77=no ./configure %c
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 Flags *.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: %N12-dev
Depends: %N12-shlibs (= %v-%r)
BuildDependsOnly: True
Replaces: mysql (<= 3.23.56-1), mysql-dev, mysql14-dev, mysql15-dev
Conflicts: mysql (<= 3.23.56-1), mysql-dev, mysql14-dev, mysql15-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: %N12-shlibs
Replaces: mysql (<= 3.23.51-1)
Depends: readline5-shlibs
Files: lib/mysql/libmysqlclient.12.0.0.dylib lib/mysql/libmysqlclient.12.dylib lib/mysql/libmysqlclient_r.12.0.0.dylib lib/mysql/libmysqlclient_r.12.dylib
Shlibs: <<
%p/lib/mysql/libmysqlclient.12.dylib 13.0.0 %n (>= 4.0.13-1)
%p/lib/mysql/libmysqlclient_r.12.dylib 13.0.0 %n (>= 4.0.22-1013)
<<
DocFiles: README COPYING
<<
SplitOff3: <<
Description: Open Source SQL database - Client
Package: %N-client
Depends: %N12-shlibs (= %v-%r)
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, what you have to do when upgrading to 4.0 from an earlier MySQL
version:

* Run the script mysql_fix_privilege_tables to add new privileges and
features to the MySQL privilege tables.
* Edit any MySQL startup scripts or configure files to not use any of the
deprecated options listed below.
* Convert your old ISAM files to MyISAM files with the command:
mysql_convert_table_format database. Note that this should only be run
if all tables in the given database is ISAM or MyISAM tables. If this is not
the case you should run ALTER TABLE table_name TYPE=MyISAM on all ISAM tables.

MySQL 4.0 will work even if you don't do the above, but you will not be able
to use the new security privileges that MySQL 4.0 and you may run into
problems when upgrading later to MySQL 4.1 or newer. The ISAM file format
still works in MySQL 4.0 but it's deprecated and will be disabled in MySQL 5.0.

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: <<
Changes in version 3.23.56: http://www.mysql.com/doc/en/News-3.23.56.html
Especially note:
Security enhancement: `mysqld' no longer reads options from world-writeable
config files.
Security enhancement: `mysqld' and `mysqld_safe' now only use the first --user
option

Changes in version 3.23.55: http://www.mysql.com/doc/en/News-3.23.55.html
Especially note:
"Make --lower-case-table-names default on MacOSX as the file system is
case insensitive."

Version 3.23.54a-3 adds a -client splitoff.

Version 3.23.54a-2 adds 'NoSetLDFLAGS: true, SetLIBS: -L%p/lib' to enable
old mysql installations to be upgraded. Also makes it possible to set a
different location for the databases in 'my.cnf'

Version 3.23.52 removes passwd dependency - for OSX 10.2 only which has
mysql user.

Built with InnoDB transaction safe table support (http://www.innodb.com/).
You should install and update /sw/var/mysql/my.cnf in order to use InnoDB.

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.0.22 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.0.22 _unstable_ port .patch