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

Diff of /eclass/mysql.eclass

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

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

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

  ViewVC Help
Powered by ViewVC 1.1.20