/[gentoo-x86]/eclass/mysql.eclass
Gentoo

Diff of /eclass/mysql.eclass

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

Revision 1.22 Revision 1.32
1# Copyright 1999-2005 Gentoo Foundation 1# Copyright 1999-2006 Gentoo Foundation
2# Distributed under the terms of the GNU General Public License v2 2# Distributed under the terms of the GNU General Public License v2
3# $Header: /var/cvsroot/gentoo-x86/eclass/mysql.eclass,v 1.22 2006/03/03 09:28:58 vivo Exp $ 3# $Header: /var/cvsroot/gentoo-x86/eclass/mysql.eclass,v 1.32 2006/05/31 20:45:49 chtekk Exp $
4 4
5# Author: Francesco Riosa <vivo at gentoo.org> 5# Author: Francesco Riosa <vivo@gentoo.org>
6# Maintainer: Francesco Riosa <vivo at gentoo.org> 6# Maintainer: Luca Longinotti <chtekk@gentoo.org>
7
8# Both MYSQL_VERSION_ID and MYSQL_PATCHSET_REV must be set in the ebuild too
9# Note that MYSQL_VERSION_ID must be empty !!!
10
11# MYSQL_VERSION_ID will be:
12# major * 10e6 + minor * 10e4 + micro * 10e2 + gentoo revision number, all [0..99]
13# This is an important part, because many of the choices the MySQL ebuild will do
14# depend on this variable.
15# In particular, the code below transforms a $PVR like "5.0.18-r3" in "5001803"
16
17if [[ -z "${MYSQL_VERSION_ID}" ]] ; then
18 tpv=( ${PV//[-._]/ } ) ; tpv[3]="${PVR:${#PV}}" ; tpv[3]="${tpv[3]##*-r}"
19 for vatom in 0 1 2 3 ; do
20 # pad to length 2
21 tpv[${vatom}]="00${tpv[${vatom}]}"
22 MYSQL_VERSION_ID="${MYSQL_VERSION_ID}${tpv[${vatom}]:0-2}"
23 done
24 # strip leading "0" (otherwise it's considered an octal number by BASH)
25 MYSQL_VERSION_ID=${MYSQL_VERSION_ID##"0"}
26fi
27
28DEPEND="${DEPEND}
29 >=sys-libs/readline-4.1
30 berkdb? ( sys-apps/ed )
31 ssl? ( >=dev-libs/openssl-0.9.6d )
32 userland_GNU? ( sys-process/procps )
33 >=sys-libs/zlib-1.2.3
34 >=sys-apps/texinfo-4.7-r1
35 >=sys-apps/sed-4"
36
37RDEPEND="${DEPEND} selinux? ( sec-policy/selinux-mysql )"
38
39# dev-perl/DBD-mysql is needed by some scripts installed by MySQL
40PDEPEND="perl? ( >=dev-perl/DBD-mysql-2.9004 )"
7 41
8inherit eutils flag-o-matic gnuconfig autotools mysql_fx 42inherit eutils flag-o-matic gnuconfig autotools mysql_fx
9 43
10#major, minor only in the slot
11SLOT=$(( ${MYSQL_VERSION_ID} / 10000 ))
12
13# shorten the path because the socket path length must be shorter than 107 chars 44# Shorten the path because the socket path length must be shorter than 107 chars
14# and we will run a mysql server during test phase 45# and we will run a mysql server during test phase
15S="${WORKDIR}/${PN}" 46S="${WORKDIR}/${PN}"
16 47
48# Define $MY_FIXED_PV for MySQL patchsets
49MY_FIXED_PV="${PV/_alpha/}"
50MY_FIXED_PV="${MY_FIXED_PV/_beta/}"
51MY_FIXED_PV="${MY_FIXED_PV/_rc/}"
52
53# Define correct SRC_URIs
54SRC_URI="mirror://mysql/Downloads/MySQL-${PV%.*}/${P/_/-}.tar.gz"
55if [[ -n "${MYSQL_PATCHSET_REV}" ]] ; then
56 MYSQL_PATCHSET_FILENAME="${PN}-patchset-${MY_FIXED_PV}-r${MYSQL_PATCHSET_REV}.tar.bz2"
57 # We add the Gentoo mirror here, as we only use primaryuri for the MySQL tarball
58 SRC_URI="${SRC_URI} mirror://gentoo/${MYSQL_PATCHSET_FILENAME} http://gentoo.longitekk.com/${MYSQL_PATCHSET_FILENAME}"
59fi
60
17DESCRIPTION="A fast, multi-threaded, multi-user SQL database server" 61DESCRIPTION="A fast, multi-threaded, multi-user SQL database server."
18HOMEPAGE="http://www.mysql.com/" 62HOMEPAGE="http://www.mysql.com/"
19NEWP="${P/_/-}" 63SLOT="0"
20SRC_URI="mirror://mysql/Downloads/MySQL-${PV%.*}/${NEWP}.tar.gz
21 mirror://gentoo/mysql-extras-${MY_EXTRAS_VER}.tar.bz2"
22LICENSE="GPL-2" 64LICENSE="GPL-2"
23IUSE="big-tables berkdb debug embedded minimal perl selinux srvdir ssl static" 65IUSE="big-tables berkdb debug embedded minimal perl selinux srvdir ssl static"
24RESTRICT="primaryuri confcache" 66RESTRICT="primaryuri confcache"
25DEPEND="app-admin/eselect-mysql" 67
68mysql_version_is_at_least "4.01.00.00" \
69&& IUSE="${IUSE} latin1"
26 70
27mysql_version_is_at_least "4.01.03.00" \ 71mysql_version_is_at_least "4.01.03.00" \
28&& IUSE="${IUSE} cluster extraengine" 72&& IUSE="${IUSE} cluster extraengine"
29 73
30mysql_version_is_at_least "5.00.00.00" \ 74mysql_version_is_at_least "5.00.00.00" \
34&& IUSE="${IUSE} max-idx-128" 78&& IUSE="${IUSE} max-idx-128"
35 79
36mysql_version_is_at_least "5.01.00.00" \ 80mysql_version_is_at_least "5.01.00.00" \
37&& IUSE="${IUSE} innodb" 81&& IUSE="${IUSE} innodb"
38 82
39EXPORT_FUNCTIONS pkg_setup src_unpack src_compile src_install pkg_preinst pkg_postinst pkg_config pkg_prerm pkg_postrm 83EXPORT_FUNCTIONS pkg_setup src_unpack src_compile src_install pkg_preinst \
84 pkg_postinst pkg_config pkg_postrm
40 85
41# void mysql_init_vars() 86# void mysql_init_vars()
42# 87#
43# initialize global variables 88# Initialize global variables
44# 2005-11-19 <vivo at gentoo.org> 89# 2005-11-19 <vivo@gentoo.org>
90
45mysql_init_vars() { 91mysql_init_vars() {
46
47 if [[ ${SLOT} -eq 0 ]] ; then
48 MY_SUFFIX=""
49 else
50 MY_SUFFIX=${MY_SUFFIX:-"-${SLOT}"}
51 fi
52 MY_SHAREDSTATEDIR=${MY_SHAREDSTATEDIR:-"/usr/share/mysql${MY_SUFFIX}"} 92 MY_SHAREDSTATEDIR=${MY_SHAREDSTATEDIR="/usr/share/mysql"}
53 MY_SYSCONFDIR=${MY_SYSCONFDIR="/etc/mysql${MY_SUFFIX}"} 93 MY_SYSCONFDIR=${MY_SYSCONFDIR="/etc/mysql"}
54 MY_LIBDIR=${MY_LIBDIR="/usr/$(get_libdir)/mysql${MY_SUFFIX}"} 94 MY_LIBDIR=${MY_LIBDIR="/usr/$(get_libdir)/mysql"}
55 MY_LOCALSTATEDIR=${MY_LOCALSTATEDIR="/var/lib/mysql${MY_SUFFIX}"} 95 MY_LOCALSTATEDIR=${MY_LOCALSTATEDIR="/var/lib/mysql"}
56 MY_LOGDIR=${MY_LOGDIR="/var/log/mysql${MY_SUFFIX}"} 96 MY_LOGDIR=${MY_LOGDIR="/var/log/mysql"}
57 MY_INCLUDEDIR=${MY_INCLUDEDIR="/usr/include/mysql${MY_SUFFIX}"} 97 MY_INCLUDEDIR=${MY_INCLUDEDIR="/usr/include/mysql"}
58 98
59 if [ -z "${DATADIR}" ]; then 99 if [[ -z "${DATADIR}" ]] ; then
60 DATADIR="" 100 DATADIR=""
61 if [ -f "${MY_SYSCONFDIR}/my.cnf" ] ; then 101 if [[ -f "${MY_SYSCONFDIR}/my.cnf" ]] ; then
62 DATADIR=`"my_print_defaults${MY_SUFFIX}" mysqld 2>/dev/null | sed -ne '/datadir/s|^--datadir=||p' | tail -n1` 102 DATADIR=`"my_print_defaults" mysqld 2>/dev/null \
103 | sed -ne '/datadir/s|^--datadir=||p' \
104 | tail -n1`
63 if [ -z "${DATADIR}" ]; then 105 if [[ -z "${DATADIR}" ]] ; then
64 if useq "srvdir" ; then 106 if useq "srvdir" ; then
65 DATADIR="${ROOT}/srv/localhost/mysql${MY_SUFFIX}/datadir" 107 DATADIR="${ROOT}/srv/localhost/mysql/datadir"
66 else 108 else
67 DATADIR=`grep ^datadir "${MY_SYSCONFDIR}/my.cnf" | sed -e 's/.*=\s*//'` 109 DATADIR=`grep ^datadir "${MY_SYSCONFDIR}/my.cnf" \
110 | sed -e 's/.*=\s*//'`
68 fi 111 fi
69 fi 112 fi
70 fi 113 fi
71 if [ -z "${DATADIR}" ]; then 114 if [[ -z "${DATADIR}" ]] ; then
72 if useq "srvdir" ; then 115 if useq "srvdir" ; then
73 DATADIR="${ROOT}/srv/localhost/mysql${MY_SUFFIX}/datadir" 116 DATADIR="${ROOT}/srv/localhost/mysql/datadir"
74 else 117 else
75 DATADIR="${MY_LOCALSTATEDIR}" 118 DATADIR="${MY_LOCALSTATEDIR}"
76 fi 119 fi
77 einfo "Using default DATADIR" 120 einfo "Using default DATADIR"
78 fi 121 fi
79 einfo "MySQL DATADIR is ${DATADIR}" 122 einfo "MySQL DATADIR is ${DATADIR}"
80 123
81 if [ -z "${PREVIOUS_DATADIR}" ] ; then 124 if [[ -z "${PREVIOUS_DATADIR}" ]] ; then
82 if [ -a "${DATADIR}" ] ; then 125 if [[ -e "${DATADIR}" ]] ; then
83 ewarn "Previous datadir found, it's YOUR job to change" 126 ewarn "Previous datadir found, it's YOUR job to change"
84 ewarn "ownership and have care of it" 127 ewarn "ownership and take care of it"
85 PREVIOUS_DATADIR="yes" 128 PREVIOUS_DATADIR="yes"
86 export PREVIOUS_DATADIR
87 else 129 else
88 PREVIOUS_DATADIR="no" 130 PREVIOUS_DATADIR="no"
89 export PREVIOUS_DATADIR
90 fi 131 fi
91 fi 132 export PREVIOUS_DATADIR
92 fi 133 fi
134 fi
93 135
94 export MY_SUFFIX MY_SHAREDSTATEDIR MY_SYSCONFDIR 136 export MY_SHAREDSTATEDIR MY_SYSCONFDIR
95 export MY_LIBDIR MY_LOCALSTATEDIR MY_LOGDIR 137 export MY_LIBDIR MY_LOCALSTATEDIR MY_LOGDIR
96 export MY_INCLUDEDIR 138 export MY_INCLUDEDIR
97 export DATADIR 139 export DATADIR
98} 140}
99 141
100mysql_pkg_setup() { 142mysql_pkg_setup() {
101
102 enewgroup mysql 60 || die "problem adding group mysql" 143 enewgroup mysql 60 || die "problem adding 'mysql' group"
103 enewuser mysql 60 -1 /dev/null mysql \ 144 enewuser mysql 60 -1 /dev/null mysql || die "problem adding 'mysql' user"
104 || die "problem adding user mysql" 145
146 # Check for USE flag problems in pkg_setup
147 if useq "static" && useq "ssl" ; then
148 eerror "MySQL does not support being built statically with SSL support enabled!"
149 die "MySQL does not support being built statically with SSL support enabled!"
150 fi
151
152 if ! mysql_version_is_at_least "5.00.00.00" \
153 && useq "raid" \
154 && useq "static" ; then
155 eerror "USE flags 'raid' and 'static' conflict, you cannot build MySQL statically"
156 eerror "with RAID support enabled."
157 die "USE flags 'raid' and 'static' conflict!"
158 fi
159
160 if mysql_version_is_at_least "4.01.03.00" \
161 && ( useq "cluster" || useq "extraengine" ) \
162 && useq "minimal" ; then
163 eerror "USE flags 'cluster' and 'extraengine' conflict with 'minimal' USE flag!"
164 die "USE flags 'cluster' and 'extraengine' conflict with 'minimal' USE flag!"
165 fi
105} 166}
106 167
107mysql_src_unpack() { 168mysql_src_unpack() {
108 169 # Initialize the proper variables first
109 mysql_init_vars 170 mysql_init_vars
110 171
111 if useq static && useq ssl; then
112 local msg="MySQL does not support building statically with SSL support"
113 eerror "${msg}"
114 die "${msg}"
115 fi
116
117 if mysql_version_is_at_least "4.01.03.00" \
118 && useq cluster \
119 || useq extraengine \
120 && useq minimal ; then
121 die "USEs cluster, extraengine conflicts with \"minimal\""
122 fi
123
124 unpack ${A} || die 172 unpack ${A}
125 173
126 mv -f "${WORKDIR}/${NEWP}" "${S}" 174 mv -f "${WORKDIR}/${P/_/-}" "${S}"
127 cd "${S}" 175 cd "${S}"
128 176
129 EPATCH_SUFFIX="patch" 177 # Apply the patches for this MySQL version
130 mkdir -p "${EPATCH_SOURCE}" || die "unable to create epatch directory" 178 if [[ -d "${WORKDIR}/${MY_FIXED_PV}" ]] ; then
131 mysql_mv_patches 179 EPATCH_SOURCE="${WORKDIR}/${MY_FIXED_PV}" EPATCH_SUFFIX="patch" epatch
132 epatch || die "failed to apply all patches" 180 fi
133 181
134 # additional check, remove bundled zlib 182 # Additional checks, remove bundled zlib
135 rm -f "${S}/zlib/"*.[ch] 183 rm -f "${S}/zlib/"*.[ch]
136 sed -i -e "s/zlib\/Makefile dnl/dnl zlib\/Makefile/" "${S}/configure.in" 184 sed -i -e "s/zlib\/Makefile dnl/dnl zlib\/Makefile/" "${S}/configure.in"
137 rm -f scripts/mysqlbug 185 rm -f "scripts/mysqlbug"
138 186
139 # Make charsets install in the right place 187 # Make charsets install in the right place
140 find . -name 'Makefile.am' \
141 -exec sed --in-place -e 's!$(pkgdatadir)!'${MY_SHAREDSTATEDIR}'!g' {} \; 188 find . -name 'Makefile.am' -exec sed --in-place -e 's!$(pkgdatadir)!'${MY_SHAREDSTATEDIR}'!g' {} \;
142 189
143 # Manage mysqlmanager 190 # Manage mysqlmanager
144 mysql_version_is_at_least "5.00.15.00" \ 191 mysql_version_is_at_least "5.00.15.00" \
145 && sed -i -e "s!@GENTOO_EXT@!${MY_SUFFIX}!g" \ 192 && sed -i -e "s!@GENTOO_EXT@!!g" -e "s!@GENTOO_SOCK_PATH@!var/run/mysqld!g" "${S}/server-tools/instance-manager/Makefile.am"
146 -e "s!@GENTOO_SOCK_PATH@!var/run/mysqld!g" \
147 "${S}/server-tools/instance-manager/Makefile.am"
148 193
194 if mysql_version_is_at_least "4.01.00.00" ; then
149 # remove what need to be recreated, so we are sure it's actually done 195 # Remove what needs to be recreated, so we're sure it's actually done
150 find . -name Makefile -o -name Makefile.in -o -name configure -exec rm -f {} \; 196 find . -name Makefile \
197 -o -name Makefile.in \
198 -o -name configure \
199 -exec rm -f {} \;
151 rm ltmain.sh 200 rm -f "ltmain.sh"
201 fi
152 202
153 local rebuilddirlist d buildstep bdbdir 203 local rebuilddirlist bdbdir d
154 204
155 if mysql_version_is_at_least "5.01.00.00" ; then 205 if mysql_version_is_at_least "5.01.00.00" ; then
156 rebuilddirlist=". storage/innobase" 206 rebuilddirlist=". storage/innobase"
157 bdbdir='storage/bdb/dist' 207 bdbdir='storage/bdb/dist'
158 else 208 else
159 rebuilddirlist=". innobase" 209 rebuilddirlist=". innobase"
160 bdbdir='bdb/dist' 210 bdbdir='bdb/dist'
161 fi 211 fi
162 212
163 for d in ${rebuilddirlist}; do 213 for d in ${rebuilddirlist} ; do
164 einfo "reconfiguring dir \"${d}\"" 214 einfo "Reconfiguring dir '${d}'"
165 pushd "${d}" &>/dev/null 215 pushd "${d}" &>/dev/null
166 AT_GNUCONF_UPDATE="yes" eautoreconf 216 AT_GNUCONF_UPDATE="yes" eautoreconf
167 popd &>/dev/null 217 popd &>/dev/null
168 done 218 done
169 219
170 #TODO berkdb in 5.1 need to be worked on 220 # TODO: berkdb in MySQL 5.1 needs to be worked on
221 if useq "berkdb" \
222 && ! mysql_check_version_range "4.00.00.00 to 4.00.99.99" \
171 if useq berkdb && ! mysql_check_version_range "5.01.00.00 to 5.01.08.99" 223 && ! mysql_check_version_range "5.01.00.00 to 5.01.08.99" ; then
172 then
173 [[ -w "${bdbdir}/ltmain.sh" ]] && cp -f ltmain.sh "${bdbdir}/ltmain.sh" 224 [[ -w "${bdbdir}/ltmain.sh" ]] && cp -f "ltmain.sh" "${bdbdir}/ltmain.sh"
174 pushd "${bdbdir}" && sh s_all || die "failed bdb reconfigure" &>/dev/null 225 pushd "${bdbdir}" \
226 && sh s_all \
227 || die "Failed bdb reconfigure" \
228 &>/dev/null
175 popd &>/dev/null 229 popd &>/dev/null
176 fi 230 fi
177
178} 231}
179 232
180mysql_src_compile() { 233mysql_src_compile() {
181 234 # Make sure the vars are correctly initialized
182 mysql_init_vars 235 mysql_init_vars
236
183 local myconf 237 local myconf
184 238
185 if useq static ; then 239 if useq "static" ; then
186 myconf="${myconf} --with-mysqld-ldflags=-all-static" 240 myconf="${myconf} --with-mysqld-ldflags=-all-static"
187 myconf="${myconf} --with-client-ldflags=-all-static" 241 myconf="${myconf} --with-client-ldflags=-all-static"
188 myconf="${myconf} --disable-shared" 242 myconf="${myconf} --disable-shared"
189 else 243 else
190 myconf="${myconf} --enable-shared --enable-static" 244 myconf="${myconf} --enable-shared --enable-static"
191 fi 245 fi
192 246
193 #myconf="${myconf} `use_with tcpd libwrap`"
194 myconf="${myconf} --without-libwrap" 247 myconf="${myconf} --without-libwrap"
195 248
196 if useq ssl ; then 249 if useq "ssl" ; then
197 # --with-vio is not needed anymore, it's on by default and 250 # --with-vio is not needed anymore, it's on by default and
198 # has been removed from configure 251 # has been removed from configure
199 mysql_version_is_at_least "5.00.04.00" || myconf="${myconf} --with-vio" 252 mysql_version_is_at_least "5.00.04.00" || myconf="${myconf} --with-vio"
200 if mysql_version_is_at_least "5.00.06.00" ; then 253 if mysql_version_is_at_least "5.00.06.00" ; then
201 # yassl-0.96 is young break with gcc-4.0 || amd64 254 # yassl-0.96 is still young and breaks with GCC-4.X or amd64
202 #myconf="${myconf} --with-yassl" 255 # myconf="${myconf} --with-yassl"
203 myconf="${myconf} --with-openssl" 256 myconf="${myconf} --with-openssl"
204 else 257 else
205 myconf="${myconf} --with-openssl" 258 myconf="${myconf} --with-openssl"
206 fi 259 fi
207 else 260 else
208 myconf="${myconf} --without-openssl" 261 myconf="${myconf} --without-openssl"
209 fi 262 fi
210 263
211 if useq debug; then 264 if useq "debug" ; then
212 myconf="${myconf} --with-debug=full" 265 myconf="${myconf} --with-debug=full"
213 else 266 else
214 myconf="${myconf} --without-debug" 267 myconf="${myconf} --without-debug"
215 mysql_version_is_at_least "4.01.03.00" && useq cluster && myconf="${myconf} --without-ndb-debug"
216 fi
217 268
218 # benchmarking stuff needs perl 269 mysql_version_is_at_least "4.01.03.00" && useq "cluster" \
219 # and shouldn't be bothered with on minimal builds
220 if useq perl && ! useq minimal; then
221 myconf="${myconf} --with-bench"
222 else
223 myconf="${myconf} --without-bench" 270 && myconf="${myconf} --without-ndb-debug"
224 fi 271 fi
225 272
226 # these are things we exclude from a minimal build 273 # These are things we exclude from a minimal build.
227 # note that the server actually does get built and installed 274 # Note that the server actually does get built and installed,
228 # but we then delete it before packaging. 275 # but we then delete it.
229 local minimal_exclude_list="server embedded-server extra-tools innodb" 276 local minimal_exclude_list="server embedded-server extra-tools innodb bench"
277
230 if ! useq minimal; then 278 if ! useq "minimal" ; then
231 for i in ${minimal_exclude_list}; do 279 myconf="${myconf} --with-server"
280 myconf="${myconf} --with-extra-tools"
281
282 if ! mysql_version_is_at_least "5.00.00.00" ; then
283 if useq "raid" ; then
232 myconf="${myconf} --with-${i}" 284 myconf="${myconf} --with-raid"
233 done 285 else
234
235 if useq static ; then
236 myconf="${myconf} --without-raid" 286 myconf="${myconf} --without-raid"
237 ewarn "disabling raid support, has problem with static" 287 fi
288 fi
289
290 if mysql_version_is_at_least "4.01.00.00" && ! useq "latin1" ; then
291 myconf="${myconf} --with-charset=utf8"
292 myconf="${myconf} --with-collation=utf8_general_ci"
238 else 293 else
294 myconf="${myconf} --with-charset=latin1"
295 myconf="${myconf} --with-collation=latin1_swedish_ci"
296 fi
297
298 # Optional again with MySQL 5.1
239 if mysql_version_is_at_least "5.00.00.00" ; then 299 if mysql_version_is_at_least "5.01.00.00" ; then
300 if useq "innodb" ; then
240 myconf="${myconf} --without-raid" 301 myconf="${myconf} --with-innodb"
241 else 302 else
242 myconf="${myconf} `use_with raid`" 303 myconf="${myconf} --without-innodb"
243 fi 304 fi
244 fi 305 fi
245 306
246 if ! mysql_version_is_at_least "5.00.00.00" ; then
247 if mysql_version_is_at_least "4.01.00.00" ; then
248 myconf="${myconf} --with-charset=utf8"
249 myconf="${myconf} --with-collation=utf8_general_ci"
250 else
251 myconf="${myconf} --with-charset=latin1"
252 myconf="${myconf} --with-collation=latin1_swedish_ci"
253 fi
254 fi
255
256 # optional again from 2005-12-05
257 if mysql_version_is_at_least "5.01.00.00" ; then
258 myconf="${myconf} $(use_with innodb)"
259 else
260 myconf="${myconf} --with-innodb"
261 fi
262
263 # lots of chars 307 # Lots of charsets
264 myconf="${myconf} --with-extra-charsets=all" 308 myconf="${myconf} --with-extra-charsets=all"
265 309
266 #The following fix is due to a bug with bdb on sparc's. See: 310 # The following fix is due to a bug with bdb on SPARC's. See:
267 #http://www.geocrawler.com/mail/msg.php3?msg_id=4754814&list=8 311 # http://www.geocrawler.com/mail/msg.php3?msg_id=4754814&list=8
268 # it comes down to non-64-bit safety problems 312 # It comes down to non-64-bit safety problems.
269 if useq sparc || useq alpha || useq hppa || useq mips || useq amd64 \ 313 if useq "sparc" || useq "alpha" || useq "hppa" || useq "mips" || useq "amd64" ; then
270 || mysql_check_version_range "5.01.00.00 to 5.01.06.99"
271 then
272 ewarn "bdb berkeley-db disabled due to arch or version" 314 ewarn "bdb berkeley-db disabled due to incompatible arch"
273 myconf="${myconf} --without-berkeley-db" 315 myconf="${myconf} --without-berkeley-db"
274 else 316 else
275 #TODO berkdb in 5.1 need to be worked on 317 # TODO: berkdb in MySQL 5.1 needs to be worked on
276 useq berkdb && \
277 ! mysql_check_version_range "5.01.00.00 to 5.01.08.99" \ 318 if useq "berkdb" && ! mysql_check_version_range "5.01.00.00 to 5.01.08.99" ; then
278 && myconf="${myconf} --with-berkeley-db=./bdb" \ 319 myconf="${myconf} --with-berkeley-db=./bdb"
320 else
279 || myconf="${myconf} --without-berkeley-db" 321 myconf="${myconf} --without-berkeley-db"
322 fi
280 fi 323 fi
281 324
282 if mysql_version_is_at_least "4.01.03.00" ; then 325 if mysql_version_is_at_least "4.01.03.00" ; then
283 #myconf="${myconf} $(use_with geometry)"
284 myconf="${myconf} --with-geometry" 326 myconf="${myconf} --with-geometry"
327
328 if useq "cluster" ; then
329 myconf="${myconf} --with-ndbcluster"
330 else
285 myconf="${myconf} $(use_with cluster ndbcluster)" 331 myconf="${myconf} --without-ndbcluster"
286 fi 332 fi
333 fi
287 334
288 mysql_version_is_at_least "4.01.11.00" && myconf="${myconf} `use_with big-tables`" 335 if useq "big-tables" ; then
336 myconf="${myconf} --with-big-tables"
337 else
338 myconf="${myconf} --without-big-tables"
339 fi
289 340
290 mysql_version_is_at_least "5.01.06.00" && myconf="${myconf} --with-ndb-binlog" 341 mysql_version_is_at_least "5.01.06.00" \
342 && myconf="${myconf} --with-ndb-binlog"
291 343
292 if useq embedded ; then 344 if useq "embedded" ; then
293 #REMIND, need the privilege control enabled ?
294 myconf="${myconf} --without-embedded-privilege-control" 345 myconf="${myconf} --with-embedded-privilege-control"
295 myconf="${myconf} --with-embedded-server" 346 myconf="${myconf} --with-embedded-server"
296 else 347 else
297 myconf="${myconf} --without-embedded-privilege-control" 348 myconf="${myconf} --without-embedded-privilege-control"
298 myconf="${myconf} --without-embedded-server" 349 myconf="${myconf} --without-embedded-server"
299 fi 350 fi
351
352 # Benchmarking stuff needs Perl
353 if useq "perl" ; then
354 myconf="${myconf} --with-bench"
355 else
356 myconf="${myconf} --without-bench"
357 fi
300 else 358 else
301 for i in ${minimal_exclude_list}; do 359 for i in ${minimal_exclude_list} ; do
302 myconf="${myconf} --without-${i}" 360 myconf="${myconf} --without-${i}"
303 done 361 done
304 myconf="${myconf} --without-berkeley-db" 362 myconf="${myconf} --without-berkeley-db"
305 myconf="${myconf} --with-extra-charsets=none" 363 myconf="${myconf} --with-extra-charsets=none"
306 fi 364 fi
307 365
308 if mysql_version_is_at_least "4.01.03.00" && useq extraengine; then 366 if mysql_version_is_at_least "4.01.03.00" && useq "extraengine" ; then
309 # http://dev.mysql.com/doc/mysql/en/archive-storage-engine.html 367 # http://dev.mysql.com/doc/mysql/en/archive-storage-engine.html
310 myconf="${myconf} --with-archive-storage-engine" 368 myconf="${myconf} --with-archive-storage-engine"
369
311 # http://dev.mysql.com/doc/mysql/en/csv-storage-engine.html 370 # http://dev.mysql.com/doc/mysql/en/csv-storage-engine.html
312
313 mysql_version_is_at_least "4.01.04.00" \
314 && myconf="${myconf} --with-csv-storage-engine" 371 myconf="${myconf} --with-csv-storage-engine"
315 372
316 mysql_version_is_at_least "4.01.11.00" \ 373 # http://dev.mysql.com/doc/mysql/en/blackhole-storage-engine.html
317 && myconf="${myconf} --with-blackhole-storage-engine" 374 myconf="${myconf} --with-blackhole-storage-engine"
318 375
376 # http://dev.mysql.com/doc/mysql/en/federated-storage-engine.html
319 # http://dev.mysql.com/doc/mysql/en/federated-description.html 377 # http://dev.mysql.com/doc/mysql/en/federated-description.html
320 # http://dev.mysql.com/doc/mysql/en/federated-limitations.html 378 # http://dev.mysql.com/doc/mysql/en/federated-limitations.html
321 if mysql_version_is_at_least "5.00.03.00" ; then 379 if mysql_version_is_at_least "5.00.03.00" ; then
322 einfo "before to use federated engine be sure to read" 380 einfo "Before using the Federated storage engine, please be sure to read"
323 einfo "http://dev.mysql.com/doc/refman/5.0/en/federated-limitations.html" 381 einfo "http://dev.mysql.com/doc/mysql/en/federated-limitations.html"
324 myconf="${myconf} --with-federated-storage-engine" 382 myconf="${myconf} --with-federated-storage-engine"
383 fi
325 384
326 # http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html 385 # http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html
327 if mysql_version_is_at_least "5.01.00.00" ; then 386 if mysql_version_is_at_least "5.01.00.00" ; then
328 myconf="${myconf} --with-partition" 387 myconf="${myconf} --with-partition"
329 fi 388 fi
330 fi
331
332 fi 389 fi
333 390
334 mysql_version_is_at_least "5.00.18.00" \ 391 mysql_version_is_at_least "5.00.18.00" \
335 && useq "max-idx-128" \ 392 && useq "max-idx-128" \
336 && myconf="${myconf} --with-max-indexes=128" 393 && myconf="${myconf} --with-max-indexes=128"
337 394
338 if mysql_version_is_at_least "5.01.05.00" ; then 395 mysql_version_is_at_least "5.01.05.00" \
339 myconf="${myconf} --with-row-based-replication" 396 && myconf="${myconf} --with-row-based-replication"
340 fi
341 397
398 # TODO: Rechek again later, there were problems with assembler enabled
399 # and some combination of USE flags with MySQL 5.1
400 if mysql_check_version_range "5.01.00.00 to 5.01.08.99" ; then
401 myconf="${myconf} --disable-assembler"
402 else
403 myconf="${myconf} --enable-assembler"
404 fi
405
342 #Bug #114895,Bug #110149 406 # Bug #114895, bug #110149
343 filter-flags "-O" "-O[01]" 407 filter-flags "-O" "-O[01]"
408
344 #glibc-2.3.2_pre fix; bug #16496 409 # glib-2.3.2_pre fix, bug #16496
345 append-flags "-DHAVE_ERRNO_AS_DEFINE=1" 410 append-flags "-DHAVE_ERRNO_AS_DEFINE=1"
346 411
347 #the compiler flags are as per their "official" spec ;) 412 # The compiler flags are as their "official" spec says ;)
348 #CFLAGS="${CFLAGS/-O?/} -O3" \ 413 # CFLAGS="${CFLAGS/-O?/} -O3"
349 export CXXFLAGS="${CXXFLAGS} -felide-constructors -fno-exceptions -fno-rtti" 414 export CXXFLAGS="${CXXFLAGS} -felide-constructors -fno-exceptions -fno-rtti"
350 mysql_version_is_at_least "5.00.00.00" \ 415 mysql_version_is_at_least "5.00.00.00" \
351 && export CXXFLAGS="${CXXFLAGS} -fno-implicit-templates" 416 && export CXXFLAGS="${CXXFLAGS} -fno-implicit-templates"
352 417
353 econf \ 418 econf \
354 --program-suffix="${MY_SUFFIX}" \
355 --libexecdir="/usr/sbin" \ 419 --libexecdir="/usr/sbin" \
356 --sysconfdir="${MY_SYSCONFDIR}" \ 420 --sysconfdir="${MY_SYSCONFDIR}" \
357 --localstatedir="${MY_LOCALSTATEDIR}" \ 421 --localstatedir="${MY_LOCALSTATEDIR}" \
358 --sharedstatedir="${MY_SHAREDSTATEDIR}" \ 422 --sharedstatedir="${MY_SHAREDSTATEDIR}" \
359 --libdir="${MY_LIBDIR}" \ 423 --libdir="${MY_LIBDIR}" \
360 --includedir="${MY_INCLUDEDIR}" \ 424 --includedir="${MY_INCLUDEDIR}" \
361 --with-low-memory \ 425 --with-low-memory \
362 --enable-assembler \
363 --enable-local-infile \ 426 --enable-local-infile \
364 --with-mysqld-user=mysql \ 427 --with-mysqld-user=mysql \
365 --with-client-ldflags=-lstdc++ \ 428 --with-client-ldflags=-lstdc++ \
366 --enable-thread-safe-client \ 429 --enable-thread-safe-client \
367 --with-comment="Gentoo Linux ${PF}" \ 430 --with-comment="Gentoo Linux ${PF}" \
368 --with-unix-socket-path="/var/run/mysqld/mysqld.sock" \ 431 --with-unix-socket-path="/var/run/mysqld/mysqld.sock" \
369 --with-lib-ccflags="-fPIC" \
370 --without-readline \ 432 --without-readline \
371 --without-docs \ 433 --without-docs \
372 ${myconf} || die "bad ./configure" 434 ${myconf} || die "bad ./configure"
373 435
374 # TODO Move this before autoreconf !!! 436 # TODO: Move this before autoreconf !!!
375 find . -type f -name Makefile -print0 \ 437 find . -type f -name Makefile -print0 \
376 | xargs -0 -n100 sed -i \ 438 | xargs -0 -n100 sed -i \
377 -e 's|^pkglibdir *= *$(libdir)/mysql|pkglibdir = $(libdir)|;s|^pkgincludedir *= *$(includedir)/mysql|pkgincludedir = $(includedir)|' 439 -e 's|^pkglibdir *= *$(libdir)/mysql|pkglibdir = $(libdir)|;s|^pkgincludedir *= *$(includedir)/mysql|pkgincludedir = $(includedir)|'
378 440
379 emake || die "compile problem" 441 emake || die "compile problem"
380} 442}
381 443
382mysql_src_install() { 444mysql_src_install() {
383 445 # Make sure the vars are correctly initialized
384 mysql_init_vars 446 mysql_init_vars
447
385 make install DESTDIR="${D}" benchdir_root="${MY_SHAREDSTATEDIR}" || die 448 make install DESTDIR="${D}" benchdir_root="${MY_SHAREDSTATEDIR}" || die "make install error"
386 449
387 insinto "${MY_INCLUDEDIR}" 450 insinto "${MY_INCLUDEDIR}"
388 doins "${MY_INCLUDEDIR}"/my_{config,dir}.h 451 doins "${MY_INCLUDEDIR}"/my_{config,dir}.h
389 452
390 # convenience links 453 # Convenience links
391 dosym "/usr/bin/mysqlcheck${MY_SUFFIX}" "/usr/bin/mysqlanalyze${MY_SUFFIX}" 454 dosym "/usr/bin/mysqlcheck" "/usr/bin/mysqlanalyze"
392 dosym "/usr/bin/mysqlcheck${MY_SUFFIX}" "/usr/bin/mysqlrepair${MY_SUFFIX}" 455 dosym "/usr/bin/mysqlcheck" "/usr/bin/mysqlrepair"
393 dosym "/usr/bin/mysqlcheck${MY_SUFFIX}" "/usr/bin/mysqloptimize${MY_SUFFIX}" 456 dosym "/usr/bin/mysqlcheck" "/usr/bin/mysqloptimize"
394 457
395 # various junk (my-*.cnf moved elsewhere) 458 # Various junk (my-*.cnf moved elsewhere)
396 rm -rf "${D}/usr/share/info" 459 rm -Rf "${D}/usr/share/info"
397 for removeme in "mysql-log-rotate" mysql.server* \ 460 for removeme in "mysql-log-rotate" mysql.server* binary-configure* my-*.cnf mi_test_all* ; do
398 binary-configure* my-*.cnf mi_test_all*
399 do
400 rm -f ${D}/usr/share/mysql/${removeme} 461 rm -f "${D}"/usr/share/mysql/${removeme}
401 done 462 done
402 463
403 # TODO change at Makefile-am level
404 for moveme in "mysql_fix_privilege_tables.sql" \
405 "fill_help_tables.sql" "ndb-config-2-node.ini"
406 do
407 mv -f "${D}/usr/share/mysql/${moveme}" "${D}/usr/share/mysql${MY_SUFFIX}/" 2>/dev/null
408 done
409
410 if [[ -n "${MY_SUFFIX}" ]] ; then
411 local notcatched=$(ls "${D}/usr/share/mysql"/*)
412 if [[ -n "${notcatched}" ]] ; then
413 ewarn "QA notice"
414 ewarn "${notcatched} files in /usr/share/mysql"
415 ewarn "bug mysql-herd to manage them"
416 fi
417 rm -rf "${D}/usr/share/mysql"
418 fi
419
420 # clean up stuff for a minimal build 464 # Clean up stuff for a minimal build
421 # this is anything server-specific
422 if useq minimal; then 465 if useq "minimal" ; then
423 rm -rf ${D}${MY_SHAREDSTATEDIR}/{mysql-test,sql-bench} 466 rm -Rf "${D}${MY_SHAREDSTATEDIR}"/{mysql-test,sql-bench}
424 rm -f ${D}/usr/bin/{mysql{_install_db,manager*,_secure_installation,_fix_privilege_tables,hotcopy,_convert_table_format,d_multi,_fix_extensions,_zap,_explain_log,_tableinfo,d_safe,_install,_waitpid,binlog,test},myisam*,isam*,pack_isam} 467 rm -f "${D}"/usr/bin/{mysql{_install_db,manager*,_secure_installation,_fix_privilege_tables,hotcopy,_convert_table_format,d_multi,_fix_extensions,_zap,_explain_log,_tableinfo,d_safe,_install,_waitpid,binlog,test},myisam*,isam*,pack_isam}
425 rm -f "${D}/usr/sbin/mysqld${MY_SUFFIX}" 468 rm -f "${D}/usr/sbin/mysqld"
426 rm -f ${D}${MY_LIBDIR}/lib{heap,merge,nisam,my{sys,strings,sqld,isammrg,isam},vio,dbug}.a 469 rm -f "${D}${MY_LIBDIR}"/lib{heap,merge,nisam,my{sys,strings,sqld,isammrg,isam},vio,dbug}.a
427 fi 470 fi
428 471
429 # config stuff 472 # Configuration stuff
473 if mysql_version_is_at_least "4.01.00.00" ; then
474 mysql_mycnf_version="4.1"
475 else
476 mysql_mycnf_version="4.0"
477 fi
430 insinto "${MY_SYSCONFDIR}" 478 insinto "${MY_SYSCONFDIR}"
431 doins scripts/mysqlaccess.conf 479 doins "scripts/mysqlaccess.conf"
432 sed -e "s!@MY_SUFFIX@!${MY_SUFFIX}!g" \
433 -e "s!@DATADIR@!${DATADIR}!g" \ 480 sed -e "s!@DATADIR@!${DATADIR}!g" \
434 "${FILESDIR}/my.cnf-4.1-r1" \ 481 "${FILESDIR}/my.cnf-${mysql_mycnf_version}" \
435 > "${TMPDIR}/my.cnf.ok" 482 > "${TMPDIR}/my.cnf.ok"
483 if mysql_version_is_at_least "4.01.00.00" && useq "latin1" ; then
484 sed -e "s|utf8|latin1|g" -i "${TMPDIR}/my.cnf.ok"
485 fi
436 newins "${TMPDIR}/my.cnf.ok" my.cnf 486 newins "${TMPDIR}/my.cnf.ok" my.cnf
437 487
438 insinto "/etc/conf.d" 488 insinto "/etc/conf.d"
439 newins "${FILESDIR}/mysql-slot.conf.d-r1" "mysql" 489 newins "${FILESDIR}/mysql.conf.d" "mysql"
440 mysql_version_is_at_least "5.00.11.00" \ 490 mysql_version_is_at_least "5.00.11.00" \
441 && newins "${FILESDIR}/mysqlmanager-slot.conf.d" "mysqlmanager" 491 && newins "${FILESDIR}/mysqlmanager.conf.d" "mysqlmanager"
442 492
443 # minimal builds don't have the server 493 # Minimal builds don't have the MySQL server
444 if ! useq minimal; then 494 if ! useq "minimal" ; then
445 exeinto /etc/init.d 495 exeinto "/etc/init.d"
446 newexe "${FILESDIR}/mysql-slot.rc6-r3" "mysql" 496 newexe "${FILESDIR}/mysql.rc6" "mysql"
447
448 mysql_version_is_at_least "5.00.11.00" \ 497 mysql_version_is_at_least "5.00.11.00" \
449 && newexe "${FILESDIR}/mysqlmanager-slot.rc6" "mysqlmanager" 498 && newexe "${FILESDIR}/mysqlmanager.rc6" "mysqlmanager"
499
450 insinto /etc/logrotate.d 500 insinto "/etc/logrotate.d"
451 sed -e "s!___MY_SUFFIX___!${MY_SUFFIX}!g" \
452 "${FILESDIR}/logrotate-slot.mysql" \
453 > "${TMPDIR}/logrotate.mysql"
454 newins "${TMPDIR}/logrotate.mysql" "mysql${MY_SUFFIX}" 501 newins "${FILESDIR}/logrotate.mysql" "mysql"
455 502
456 #empty dirs... 503 # Empty directories ...
457 diropts "-m0750" 504 diropts "-m0750"
458 if [[ "${PREVIOUS_DATADIR}" != "yes" ]] ; then 505 if [[ "${PREVIOUS_DATADIR}" != "yes" ]] ; then
459 dodir "${DATADIR}" 506 dodir "${DATADIR}"
460 keepdir "${DATADIR}" 507 keepdir "${DATADIR}"
461 chown -R mysql:mysql "${D}/${DATADIR}" 508 chown -R mysql:mysql "${D}/${DATADIR}"
467 keepdir "${folder}" 514 keepdir "${folder}"
468 chown -R mysql:mysql "${D}/${folder}" 515 chown -R mysql:mysql "${D}/${folder}"
469 done 516 done
470 fi 517 fi
471 518
472 # docs 519 # Docs
473 dodoc README COPYING ChangeLog EXCEPTIONS-CLIENT INSTALL-SOURCE 520 dodoc README COPYING ChangeLog EXCEPTIONS-CLIENT INSTALL-SOURCE
521
474 # minimal builds don't have the server 522 # Minimal builds don't have the MySQL server
475 if ! useq minimal; then 523 if ! useq "minimal" ; then
476 docinto "support-files" 524 docinto "support-files"
477 for script in \ 525 for script in \
478 support-files/my-*.cnf \ 526 support-files/my-*.cnf \
479 support-files/magic \ 527 support-files/magic \
480 support-files/ndb-config-2-node.ini 528 support-files/ndb-config-2-node.ini
486 for script in scripts/mysql* ; do 534 for script in scripts/mysql* ; do
487 [[ "${script%.sh}" == "${script}" ]] && dodoc "${script}" 535 [[ "${script%.sh}" == "${script}" ]] && dodoc "${script}"
488 done 536 done
489 fi 537 fi
490 538
491 # oops, temporary fix 539 ROOT="${D}" mysql_lib_symlinks
492 mysql_check_version_range "5.00.16.00 to 5.00.18.99" \
493 && cp -f \
494 "${WORKDIR}/mysql-extras/fill_help_tables.sql-5.0" \
495 "${D}/usr/share/mysql${MY_SUFFIX}/fill_help_tables.sql"
496
497 if [[ ${SLOT} -gt 0 ]] ; then
498 # MOVED HERE DUE TO BUG #121445
499 # create a list of files, to be used
500 # by external utilities
501 mkdir -p "${D}/var/lib/eselect/mysql/"
502 local filelist="${D}/var/lib/eselect/mysql/mysql${MY_SUFFIX}.filelist"
503 pushd "${D}/" &>/dev/null
504 find usr/bin/ usr/sbin/ \
505 -type f -name "*${MY_SUFFIX}*" \
506 -and -not -name "mysql_config${MY_SUFFIX}" \
507 > "${filelist}"
508 find usr/share/man \
509 -type f -name "*${MY_SUFFIX}*" \
510 | sed -e 's/$/.gz/' \
511 >> "${filelist}"
512 echo "${MY_SYSCONFDIR#"/"}" >> "${filelist}"
513 echo "${MY_LIBDIR#"/"}" >> "${filelist}"
514 echo "${MY_SHAREDSTATEDIR#"/"}" >> "${filelist}"
515 popd &>/dev/null
516 fi
517} 540}
518 541
519mysql_pkg_preinst() { 542mysql_pkg_preinst() {
520
521 enewgroup mysql 60 || die "problem adding group mysql" 543 enewgroup mysql 60 || die "problem adding 'mysql' group"
522 enewuser mysql 60 -1 /dev/null mysql \ 544 enewuser mysql 60 -1 /dev/null mysql || die "problem adding 'mysql' user"
523 || die "problem adding user mysql"
524} 545}
525 546
526mysql_pkg_postinst() { 547mysql_pkg_postinst() {
527 548 # Make sure the vars are correctly initialized
528 mysql_init_vars 549 mysql_init_vars
529 mysql_lib_symlinks
530 550
531 # mind at FEATURES=collision-protect before to remove this 551 # Check FEATURES="collision-protect" before removing this
532 [ -d "${ROOT}/var/log/mysql" ] \
533 || install -d -m0750 -o mysql -g mysql "${ROOT}${MY_LOGDIR}" 552 [[ -d "${ROOT}/var/log/mysql" ]] || install -d -m0750 -o mysql -g mysql "${ROOT}${MY_LOGDIR}"
534 553
535 #secure the logfiles... does this bother anybody? 554 # Secure the logfiles
536 touch "${ROOT}${MY_LOGDIR}"/mysql.{log,err} 555 touch "${ROOT}${MY_LOGDIR}"/mysql.{log,err}
537 chown mysql:mysql "${ROOT}${MY_LOGDIR}"/mysql* 556 chown mysql:mysql "${ROOT}${MY_LOGDIR}"/mysql*
538 chmod 0660 "${ROOT}${MY_LOGDIR}"/mysql* 557 chmod 0660 "${ROOT}${MY_LOGDIR}"/mysql*
539 558
540 if ! useq minimal; then 559 if ! useq "minimal" ; then
541 if [[ ${SLOT} -gt 0 ]] ; then
542 einfo "you may want to read:"
543 einfo "http://www.gentoo.org/doc/en/mysql-upgrade-slotted.xml"
544 einfo "you may want to run \"eselect mysql list\" followed by a "
545 einfo "\"eselect mysql set 1\" to choose the default mysql server"
546 fi
547
548 # your friendly public service announcement... 560 # Your friendly public service announcement ...
549 einfo 561 einfo
550 einfo "You might want to run:" 562 einfo "You might want to run:"
551 einfo "\"emerge --config =${CATEGORY}/${PF}\"" 563 einfo "\"emerge --config =${CATEGORY}/${PF}\""
552 einfo "if this is a new install." 564 einfo "if this is a new install."
553 einfo 565 einfo
554 mysql_version_is_at_least "5.01.00.00" \ 566 mysql_version_is_at_least "5.01.00.00" \
555 || einfo "InnoDB is not optional as of MySQL-4.0.24, at the request of upstream." 567 || einfo "InnoDB is *not* optional as of MySQL-4.0.24, at the request of upstream."
556 fi 568 fi
557} 569}
558 570
559mysql_pkg_config() { 571mysql_pkg_config() {
572 # Make sure the vars are correctly initialized
560 mysql_init_vars 573 mysql_init_vars
574
561 [[ -z "${DATADIR}" ]] && die "sorry, unable to find DATADIR" 575 [[ -z "${DATADIR}" ]] && die "Sorry, unable to find DATADIR"
562 576
563 if built_with_use dev-db/mysql minimal; then 577 if built_with_use dev-db/mysql minimal ; then
564 die "Minimal builds do NOT include the MySQL server" 578 die "Minimal builds do NOT include the MySQL server"
565 fi 579 fi
566 580
567 local pwd1="a" 581 local pwd1="a"
568 local pwd2="b" 582 local pwd2="b"
574 ewarn "Please rename or delete it if you wish to replace it." 588 ewarn "Please rename or delete it if you wish to replace it."
575 die "MySQL database already exists!" 589 die "MySQL database already exists!"
576 fi 590 fi
577 591
578 einfo "Creating the mysql database and setting proper" 592 einfo "Creating the mysql database and setting proper"
579 einfo "permissions on it..." 593 einfo "permissions on it ..."
580 594
581 einfo "Insert a password for the mysql 'root' user" 595 einfo "Insert a password for the mysql 'root' user"
582 ewarn "Avoid [\"'\\_%] characters in the password" 596 ewarn "Avoid [\"'\\_%] characters in the password"
583
584 read -rsp " >" pwd1 ; echo 597 read -rsp " >" pwd1 ; echo
598
585 einfo "Check the password" 599 einfo "Retype the password"
586 read -rsp " >" pwd2 ; echo 600 read -rsp " >" pwd2 ; echo
587 601
588 if [[ "x$pwd1" != "x$pwd2" ]] ; then 602 if [[ "x$pwd1" != "x$pwd2" ]] ; then
589 die "Passwords are not the same" 603 die "Passwords are not the same"
590 fi 604 fi
591 605
592 local options="" 606 local options=""
593 local sqltmp="$(emktemp)" 607 local sqltmp="$(emktemp)"
594 608
595 local help_tables="${MY_SHAREDSTATEDIR}/fill_help_tables.sql" 609 local help_tables="${ROOT}${MY_SHAREDSTATEDIR}/fill_help_tables.sql"
596 [[ -r "${help_tables}" ]] \ 610 [[ -r "${help_tables}" ]] \
597 && cp "${help_tables}" "${TMPDIR}/fill_help_tables.sql" \ 611 && cp "${help_tables}" "${TMPDIR}/fill_help_tables.sql" \
598 || touch "${TMPDIR}/fill_help_tables.sql" 612 || touch "${TMPDIR}/fill_help_tables.sql"
599 help_tables="${TMPDIR}/fill_help_tables.sql" 613 help_tables="${TMPDIR}/fill_help_tables.sql"
600 614
601 pushd "${TMPDIR}" &>/dev/null 615 pushd "${TMPDIR}" &>/dev/null
602 ${ROOT}/usr/bin/mysql_install_db${MY_SUFFIX} | grep -B5 -A999 -i "ERROR" 616 "${ROOT}/usr/bin/mysql_install_db" | grep -B5 -A999 -i "ERROR"
603 popd &>/dev/null 617 popd &>/dev/null
604 [[ -f ${ROOT}/${DATADIR}/mysql/user.frm ]] || die "MySQL databases not installed" 618 [[ -f "${ROOT}/${DATADIR}/mysql/user.frm" ]] \
619 || die "MySQL databases not installed"
605 chown -R mysql:mysql ${ROOT}/${DATADIR} 2> /dev/null 620 chown -R mysql:mysql "${ROOT}/${DATADIR}" 2> /dev/null
606 chmod 0750 ${ROOT}/${DATADIR} 2> /dev/null 621 chmod 0750 "${ROOT}/${DATADIR}" 2> /dev/null
607 622
608 if mysql_version_is_at_least "4.01.03.00" ; then 623 if mysql_version_is_at_least "4.01.03.00" ; then
609 options="--skip-ndbcluster" 624 options="--skip-ndbcluster"
610 625
611 # Filling timezones, see 626 # Filling timezones, see
612 # http://dev.mysql.com/doc/mysql/en/time-zone-support.html 627 # http://dev.mysql.com/doc/mysql/en/time-zone-support.html
613 ${ROOT}/usr/bin/mysql_tzinfo_to_sql${MY_SUFFIX} ${ROOT}/usr/share/zoneinfo \ 628 "${ROOT}/usr/bin/mysql_tzinfo_to_sql" "${ROOT}/usr/share/zoneinfo" > "${sqltmp}" 2>/dev/null
614 > "${sqltmp}" 2>/dev/null
615 629
616 if [[ -r "${help_tables}" ]] ; then 630 if [[ -r "${help_tables}" ]] ; then
617 cat "${help_tables}" >> "${sqltmp}" 631 cat "${help_tables}" >> "${sqltmp}"
618 fi 632 fi
619 fi 633 fi
620 634
621 local socket=${ROOT}/var/run/mysqld/mysqld${RANDOM}.sock 635 local socket="${ROOT}/var/run/mysqld/mysqld${RANDOM}.sock"
622 local pidfile=${ROOT}/var/run/mysqld/mysqld${MY_SUFFIX}${RANDOM}.pid 636 local pidfile="${ROOT}/var/run/mysqld/mysqld${RANDOM}.pid"
623 local mysqld="${ROOT}/usr/sbin/mysqld${MY_SUFFIX} \ 637 local mysqld="${ROOT}/usr/sbin/mysqld \
624 ${options} \ 638 ${options} \
625 --user=mysql \ 639 --user=mysql \
626 --skip-grant-tables \ 640 --skip-grant-tables \
627 --basedir=${ROOT}/usr \ 641 --basedir=${ROOT}/usr \
628 --datadir=${ROOT}/${DATADIR} \ 642 --datadir=${ROOT}/${DATADIR} \
631 --skip-networking \ 645 --skip-networking \
632 --max_allowed_packet=8M \ 646 --max_allowed_packet=8M \
633 --net_buffer_length=16K \ 647 --net_buffer_length=16K \
634 --socket=${socket} \ 648 --socket=${socket} \
635 --pid-file=${pidfile}" 649 --pid-file=${pidfile}"
636 $mysqld & 650 ${mysqld} &
637 while ! [[ -S "${socket}" || "${maxtry}" -lt 1 ]] ; do 651 while ! [[ -S "${socket}" || "${maxtry}" -lt 1 ]] ; do
638 maxtry=$(($maxtry-1)) 652 maxtry=$((${maxtry}-1))
639 echo -n "." 653 echo -n "."
640 sleep 1 654 sleep 1
641 done 655 done
642 656
643 # do this from memory we don't want clear text password in temp files 657 # Do this from memory, as we don't want clear text passwords in temp files
644 local sql="UPDATE mysql.user SET Password = PASSWORD('${pwd1}') WHERE USER='root'" 658 local sql="UPDATE mysql.user SET Password = PASSWORD('${pwd1}') WHERE USER='root'"
645 ${ROOT}/usr/bin/mysql${MY_SUFFIX} \ 659 "${ROOT}/usr/bin/mysql" \
646 --socket=${socket} \ 660 --socket=${socket} \
647 -hlocalhost \ 661 -hlocalhost \
648 -e "${sql}" 662 -e "${sql}"
649 663
650 einfo "Loading \"zoneinfo\" this step may require few seconds" 664 einfo "Loading \"zoneinfo\", this step may require a few seconds ..."
651 665
652 ${ROOT}/usr/bin/mysql${MY_SUFFIX} \ 666 "${ROOT}/usr/bin/mysql" \
653 --socket=${socket} \ 667 --socket=${socket} \
654 -hlocalhost \ 668 -hlocalhost \
655 -uroot \ 669 -uroot \
656 -p"${pwd1}" \ 670 -p"${pwd1}" \
657 mysql < "${sqltmp}" 671 mysql < "${sqltmp}"
658 672
659 # server stop and cleanup 673 # Stop the server and cleanup
660 kill $(< "${pidfile}" ) 674 kill $(< "${pidfile}" )
661 rm "${sqltmp}" 675 rm -f "${sqltmp}"
662 einfo "stopping the server," 676 einfo "Stopping the server ..."
663 wait %1 677 wait %1
664 einfo "done" 678 einfo "Done"
665}
666
667mysql_pkg_prerm() {
668 if [[ ${SLOT} -gt 0 ]] ; then
669 # external program
670 eselect mysql slot_remove "${SLOT}"
671 fi
672} 679}
673 680
674mysql_pkg_postrm() { 681mysql_pkg_postrm() {
675 mysql_lib_symlinks 682 mysql_lib_symlinks
676 if [[ ${SLOT} -gt 0 ]] ; then
677 einfo "you may want to run \"eselect mysql list\" followed by a "
678 einfo "\"eselect mysql list\" to choose the default mysql server"
679 fi
680} 683}

Legend:
Removed from v.1.22  
changed lines
  Added in v.1.32

  ViewVC Help
Powered by ViewVC 1.1.20