Ticket #768: portfile-mysql4

PortSystem 1.0
name                    mysql4
version                 4.0.14
categories              databases
maintainers             bchesneau@mac.com       
description             Multithreaded SQL database server
long_description        MySQL is an open-source, multi-threaded SQL database \
                        with a command syntax very similar to mSQL.
homepage                http://www.mysql.com/
platforms               darwin
master_sites    ftp://ftp.sunet.se/pub/unix/databases/relational/mysql/Downloads/MySQL-4.0 \
                                http://mysql-mirror.free.fr/Downloads/MySQL-4.0 \
                                ftp://ftp.FreeBSD.org/pub/FreeBSD/distfiles

set filename            mysql-${version}${extract.sufx}
distfiles               ${filename}
distname                mysql-${version}
extract.only            ${filename}
checksums               mysql-4.0.14.tar.gz md5 9764f09c89692345d3b7800ab014f822

variant darwin {
        depends_lib-append              lib:libdl.1:dlcompat
}

set dbdir               ${prefix}/var/db/mysql

configure.env           LDFLAGS=-L${prefix}/lib\\ -lncurses \
                        CPPFLAGS=-I${prefix}/include

configure.args          --localstatedir=${dbdir} --without-server --sysconfdir=${prefix}/etc --without-bench

variant innodb {
        configure.args-append --with-innodb
}

variant server  {
        depends_run path:/Library/StartupItems/DarwinPortsStartup:DarwinPortsStartup
        configure.args  --localstatedir=${dbdir} --sysconfdir=${prefix}/etc --without-bench --with-innodb --with-unix-socket-path=${prefix}/var/run/mysqld/mysqld.sock 
        
        pre-destroot    { 
                system "install -o mysql -g mysql -m 775 -d ${destroot}${dbdir}" 
                file mkdir ${destroot}${prefix}/var/run
                file mkdir ${destroot}${prefix}/var/run/mysqld
                file mkdir ${destroot}${prefix}/var/logs
                file mkdir ${destroot}${prefix}/var/log/mysql
                system "touch ${destroot}${prefix}/var/run/mysqld/.turd \
                ${destroot}${prefix}/var/log/mysql/.turd"  
        system "chown mysql:mysql ${destroot}${prefix}/var/log/mysql"
        system "chown mysql:mysql ${destroot}${prefix}/var/run/mysqld"
        }

        post-destroot {
                addgroup mysql
                set gid [existsgroup mysql]
                adduser mysql gid=${gid} realname=MySQL\ Server

                system "install -o root -m 755 -d ${destroot}${prefix}/etc/rc.d"
                
                system "install -o root -m 755 -c ${portpath}/files/mysql4.sh ${destroot}${prefix}/etc/rc.d/"
                reinplace "s|__PREFIX|${prefix}|g" ${destroot}${prefix}/etc/rc.d/mysql4.sh
                
                system "cp ${portpath}/files/my.cnf ${destroot}${prefix}/etc/my.cnf"
                reinplace "s|__PREFIX|${prefix}|g" ${destroot}${prefix}/etc/my.cnf
        }
}