summaryrefslogtreecommitdiff
blob: d217ecad563ff0ee5159ae9b1ebf33d1bb85aba8 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
# Copyright 1999-2002 Gentoo Technologies, Inc.
# Distributed under the terms of the GNU General Public License, v2 or later
# $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/mysql-3.23.49-r2.ebuild,v 1.2 2002/07/23 03:05:05 rphillips Exp $

# NB: Databases are now in /var/lib/mysql vs. the old /var/mysql.  If you are
# upgrading from a recent mysql version, you should be able to simply move your
# databases into the new directory, but to be absolutely *safe* you should:
# - dump all of your databases
# - stop mysql if it is running
# - delete the old /var/mysql directory
# - emerge this ebuild
# - run /usr/bin/mysql_install_db or ebuild this-ebuild.ebuild config
# - start up mysql
# - re-create all of your databases
# - re-load your data
# If you are *not* upgrading, then you can just emerge this ebuild and
# either run /usr/bin/mysql_install_db or ebuild this-ebuild.ebuild config :)

DESCRIPTION="A fast, multi-threaded, multi-user SQL database server."
HOMEPAGE="http://www.mysql.com/"

S=${WORKDIR}/${P}
SRC_URI="http://www.kernelnotes.de/MySQL/Downloads/MySQL-3.23/${P}.tar.gz
	ftp://mysql.valueclick.com/pub/mysql/Downloads/MySQL-3.23/${P}.tar.gz
	http://mysql.he.net/Downloads/MySQL-3.23/${P}.tar.gz
	http://web.tryc.on.ca/mysql/Downloads/MySQL-3.23/${P}.tar.gz
	ftp://ftp.sunet.se/pub/unix/databases/relational/mysql/Downloads/MySQL-3.23/${P}.tar.gz"

RDEPEND="virtual/glibc readline? ( >=sys-libs/readline-4.1 ) >=sys-libs/ncurses-5.1 >=sys-libs/zlib-1.1.3"
DEPEND="${RDEPEND} tcpd? ( >=sys-apps/tcp-wrappers-7.6 ) sys-devel/perl sys-apps/procps"
LICENSE="GPL-2"
SLOT="0"
KEYWORDS="x86"

src_unpack() {

	unpack ${A} ; cd ${S}
	# Gentoo 1.3+ uses db 4.0.x by default..
	if [[ "${COMPILER}" != "gcc3" ]]; then
	# for -ldb-3.2 instead of -ldb, because gentoo has -ldb1 instead
	echo "blep"
	patch -p1 < ${FILESDIR}/mysql-3.23-db-3.2.3.diff || die
	fi
	# required for qmail-mysql
	patch -p0 < ${FILESDIR}/mysql-3.23-nisam.h.diff || die
	# zap startup script messages
	patch -p1 < ${FILESDIR}/mysql-3.23-install-db-sh.diff || die
	# zap binary distribution stuff
	patch -p1 < ${FILESDIR}/mysql-3.23-safe-mysqld-sh.diff || die
	# for correct hardcoded sysconf directory
	patch -p1 < ${FILESDIR}/mysql-3.23-my-print-defaults.diff || die

	aclocal || die
	automake || die
	autoconf || die
}

src_compile() {

	local myconf
	# means use the system readline
	use readline && myconf="${myconf} --without-readline"
	if [[ "${COMPILER}" != "gcc3" ]]; then
		echo "jsqkdk"
		use berkdb && myconf="${myconf} --with-berkeley-db --with-berkeley-db-includes=/usr/include/db3 --with-berkeley-db-libs=/usr/lib"
	else
		echo "bleh"
		use berkdb && myconf="${myconf} --with-berkeley-db"
	fi
	use berkdb || myconf="${myconf} --without-berkeley-db"
	use static && myconf="${myconf} --with-mysqld-ldflags=-all-static --disable-shared"
	use static || myconf="${myconf} --enable-shared --enable-static"
	use tcpd && myconf="${myconf} --with-libwrap"
	use innodb && myconf="${myconf} --with-innodb"

	if [ "$DEBUG" == "true" ] ; then
		myconf="${myconf} --with-debug"
	else
		myconf="${myconf} --without-debug"
	fi

	# CXX must be g++ because gcc|c++ does not find /usr/lib/gcc-lib/libstc+++.so.
	# the compiler flags are needed to address stability issues.
	CC=gcc \
	CFLAGS="${CFLAGS/-O?/} -O2 -fomit-frame-pointer" \
	CXX=g++ \
	CXXFLAGS="${CXXFLAGS/-O?/} -O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti" \
	./configure \
		--prefix=/usr \
		--libdir=/usr/lib \
		--exec-prefix=/usr \
		--datadir=/usr/share \
		--libexecdir=/usr/sbin \
		--sysconfdir=/etc/mysql \
		--mandir=/usr/share/man \
		--infodir=/usr/share/info \
		--includedir=/usr/include \
		--localstatedir=/var/lib/mysql \
		--with-raid \
		--with-low-memory \
		--enable-assembler \
		--with-charset=latin1 \
		--with-mysqld-user=mysql \
		--with-extra-charsets=all \
		--enable-thread-safe-client \
		--with-client-ldflags=-lstdc++ \
		--with-comment="${PF}.ebuild package" \
		--with-unix-socket-path=/var/run/mysqld/mysqld.sock \
		--host=${CHOST} ${myconf} || die "bad ./configure"

	make || die "compile problem"
}

src_install() {

	dodir /var/lib/mysql /var/run/mysqld /var/log/mysql
	make install DESTDIR=${D} benchdir_root=/usr/share/mysql || die

	# eeek, not sure whats going on here.. are these needed by anything?
	use innodb && ( insinto /usr/lib/mysql ; doins ${WORKDIR}/../libs/* )

	# move client libs, install a couple of missing headers
	mv ${D}/usr/lib/mysql/libmysqlclient*.so* ${D}/usr/lib
	dosym ../libmysqlclient.so /usr/lib/mysql/libmysqlclient.so
	insinto /usr/include/mysql ; doins include/{my_config.h,my_dir.h}

	# convenience links
	dosym /usr/bin/mysqlcheck /usr/bin/mysqlanalyze
	dosym /usr/bin/mysqlcheck /usr/bin/mysqlrepair
	dosym /usr/bin/mysqlcheck /usr/bin/mysqloptimize

	# while my broom gently sweeps...
	rm -f ${D}/usr/share/mysql/binary-configure
	rm -f ${D}/usr/share/mysql/mysql.server
	rm -f ${D}/usr/share/mysql/make_binary_distribution
	rm -f ${D}/usr/share/mysql/mi_test_all*
	rm -f ${D}/usr/share/mysql/mysql-log-rotate
	rm -f ${D}/usr/share/mysql/mysql*.spec
	rm -f ${D}/usr/share/mysql/my-*.cnf

	dodoc README COPYING COPYING.LIB MIRRORS Docs/{manual.ps,manual.txt}
	docinto conf-samples ; dodoc support-files/my-*.cnf
	docinto html ; dodoc Docs/*.html

	insinto /etc/mysql
	doins ${FILESDIR}/my.cnf scripts/mysqlaccess.conf
	exeinto /etc/init.d ; newexe ${FILESDIR}/mysql.rc6 mysql
}

pkg_config() {

	if [ ! -d ${ROOT}/var/lib/mysql/mysql ] ; then
		einfo "Press ENTER to create the mysql database and set proper"
		einfo "permissions on it, or Control-C to abort now..."
		read
		${ROOT}/usr/bin/mysql_install_db #>>/var/log/mysql/mysql.err 2>&1
	else
		einfo "Hmm, it appears as though you already have the mysql"
		einfo "database in place.  If you are having problems trying"
		einfo "to start mysqld, perhaps you need to manually run"
		einfo "/usr/bin/mysql_install_db and/or check your config"
		einfo "file(s) and/or database(s) and/or logfile(s) :>"
	fi

	# ensure permissions on these just in case...
	chown -R mysql ${ROOT}/var/lib/mysql ${ROOT}/var/run/mysqld
}

pkg_prerm() {

	if [ "$ROOT" = "/" ] && [ -e /dev/shm/.init.d/started/mysql ] ; then
		/etc/init.d/mysql stop
	fi
}

pkg_preinst() {

	if [ "$ROOT" = "/" ] && [ -e /dev/shm/.init.d/started/mysql ] ; then
		/etc/init.d/mysql stop
	fi
}

pkg_postinst() {

	# NB:  most of this stuff has been integrated into Gentoo's baselayout
	# now, for convenience.  So Ill remove it soon.  Shouldnt hurt to leave
	# it here for a few more versions though...

	# ensure the following arrangement:
	# /etc/passwd: mysql:x:60:60:mysql:/var/lib/mysql:/dev/null
	# /etc/group:  mysql::60:
	#
	# creating mysql group if he isn't already there
	if ! grep -q ^mysql: /etc/group ; then
		#echo Adding system group: mysql.
		groupadd -g 60 mysql || die "problem adding group mysql"
	fi
	# creating mysql user if he isn't already there
	if ! grep -q ^mysql: /etc/passwd ; then
		#echo Adding system user: mysql.
		useradd -g mysql -s /dev/null -d /var/lib/mysql -c "mysql" mysql
		assert "problem adding user mysql"
	fi
	# modifying him if he was already there
	usermod -c "mysql" mysql || die "usermod problem"
	usermod -d "/var/lib/mysql" mysql || die "usermod problem"
	usermod -g "mysql" mysql || die "usermod problem"
	usermod -s "/dev/null" mysql || die "usermod problem"

	# ensure sane permissions on existing databases and /var/run/mysqld
	chown mysql.mysql ${ROOT}/var/lib/mysql ${ROOT}/var/run/mysqld
	find ${ROOT}/var/lib/mysql -not \( -group root -or -group mysql \) -exec chgrp mysql {} \;

	# get these proper and ready to go
	touch ${ROOT}/var/log/mysql/mysql.log ${ROOT}/var/log/mysql/mysql.err
	chown mysql.mysql ${ROOT}/var/log/mysql/mysql.log ${ROOT}/var/log/mysql/mysql.err
	chmod 0600 ${ROOT}/var/log/mysql/mysql.log ${ROOT}/var/log/mysql/mysql.err
}