mysql 3.23.55 PortFile

[bchesneau@…]

New Portfile for Mysql 3.23.55. However I've a problem with mysql_install_db after installation. After I execute it I should set new permissions to databases (chown -R mysql /opt/local/var/db/mysql). Don't know why. And if anybody could explain me how to launch mysql_install_db in the Portfile, have no success for now.

The Portfile

# $Id: Portfile,v 1.28 2003/03/03 06:13:24 mij Exp $

PortSystem 1.0 name mysql version 3.23.55 categories databases maintainers bchesneau@… 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-3.23/ \

​ftp://ftp.FreeBSD.org/pub/FreeBSD/distfiles/ \ ​http://distfiles.opendarwin.org/:lt

set filename ${portname}-${portversion}${extract.sufx} extract.only ${filename} distfiles ${filename} depends_lib lib:libdl.1:dlcompat

checksums mysql-3.23.55.tar.gz md5 259196ddc00c94051dceb9e86574d17e

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

configure.env LDFLAGS=-L${prefix}/lib \

CPPFLAGS=-I${prefix}/include

configure.args --localstatedir=${dbdir} --mandir=${prefix}/share/man --infodir=${prefix}/share/info --without-server --libexecdir=${prefix}/sbin --sysconfdir=${prefix}/etc --with-mysqld-user=mysql --with-innodb --without-bench

variant server {

depends_run path:/Library/StartupItems/DarwinPortsStartup:DarwinPortsStartup configure.args --localstatedir=${dbdir} --mandir=${prefix}/share/man --infodir=${prefix}/share/info --libexecdir=${prefix}/sbin --sysconfdir=${prefix}/etc --with-mysqld-user=mysql --with-innodb --without-bench --with-unix-socket-path=${prefix}/var/run

pre-install { system "install -o root -m 775 -d ${dbdir}"

file mkdir ${destroot}${prefix}/var/run file mkdir ${destroot}${prefix}/etc

}

post-install {

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

#system "${destroot}${prefix}/bin/mysql_install_db" #system "chown -R mysql:mysql ${dbdir}"

#system "${destroot}${prefix}/bin/mysql_install_db --force" system "chgrp -R mysql ${dbdir}" system "chown -R mysql ${dbdir}"

system "install -o root -m 755 -d ${destroot}${prefix}/etc/rc.d" set script [open ${destroot}${prefix}/etc/rc.d/mysql.sh w 0755] puts $script "#!/bin/sh" puts $script "${prefix}/bin/safe_mysqld --user=mysql &" close $script system "cd ${workpath}/${worksrcdir} && \

cp support-files/my-medium.cnf ${destroot}${prefix}/etc/my.cnf"

}

}

[bchesneau@…]

Portfile

[michaelm@…]

assigning to current mysql maintainer

[bchesneau@…]

why not install mysql in ${prefix}/mysql to have traditionnal layout of mysql like Postgres package ?

[michaelm@…]

* Bug 398 has been marked as a duplicate of this bug. *

[michaelm@…]

changing ownership is trying to change files in the wrong location, as when post-install executes the files are in destroot. Like tetex this port is partly broken until we get post-deploy actions. the

system "chgrp -R mysql ${dbdir}"

should be

system "chgrp -R mysql ${destroot}${dbdir}"

[bchesneau@…]

Patch that upgrade cvs portfile to 3.23.56

[bchesneau@…]

* This bug has been marked as a duplicate of 612 *

[mike.mclean@…]

There are instances where MySQL 3.23.x series will still be desired and useful. I propose leaving the "databases/mysql" directory and Portfile to build the 3.23.x series and create a new "databases/mysql4" for MySQL 4.x series.

I have a working, darwin tested, 3.23.57 patch (against the cvs Portfile -- CVS version 1.28, installs 3.23.52) that I will upload for consideration.

[mike.mclean@…]

Patch against CVS version to install MySQL 3.23.57

[mij@…]

Committed with some changes. Thanks.