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

Diff of /eclass/mysql.eclass

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

Revision 1.123 Revision 1.145
1# Copyright 1999-2009 Gentoo Foundation 1# Copyright 1999-2009 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/Attic/mysql.eclass,v 1.123 2009/12/10 01:27:59 robbat2 Exp $ 3# $Header: /var/cvsroot/gentoo-x86/eclass/Attic/mysql.eclass,v 1.145 2010/04/27 05:45:55 robbat2 Exp $
4 4
5# @ECLASS: mysql.eclass 5# @ECLASS: mysql.eclass
6# @MAINTAINER: 6# @MAINTAINER:
7# Author: Francesco Riosa (Retired) <vivo@gentoo.org> 7# Author: Francesco Riosa (Retired) <vivo@gentoo.org>
8# Maintainers: MySQL Team <mysql-bugs@gentoo.org> 8# Maintainers: MySQL Team <mysql-bugs@gentoo.org>
16# phase hooks. 16# phase hooks.
17 17
18WANT_AUTOCONF="latest" 18WANT_AUTOCONF="latest"
19WANT_AUTOMAKE="latest" 19WANT_AUTOMAKE="latest"
20 20
21inherit eutils flag-o-matic gnuconfig autotools mysql_fx versionator 21inherit eutils flag-o-matic gnuconfig autotools mysql_fx versionator toolchain-funcs
22
23# Shorten the path because the socket path length must be shorter than 107 chars
24# and we will run a mysql server during test phase
25S="${WORKDIR}/mysql"
26
27[[ "${MY_EXTRAS_VER}" == "latest" ]] && MY_EXTRAS_VER="20090228-0714Z"
28if [[ "${MY_EXTRAS_VER}" == "live" ]]; then
29 EGIT_PROJECT=mysql-extras
30 EGIT_REPO_URI="git://git.overlays.gentoo.org/proj/mysql-extras.git"
31 inherit git
32fi
22 33
23case "${EAPI:-0}" in 34case "${EAPI:-0}" in
24 2) 35 2)
25 EXPORT_FUNCTIONS pkg_setup \ 36 EXPORT_FUNCTIONS pkg_setup \
26 src_unpack src_prepare \ 37 src_unpack src_prepare \
40 ;; 51 ;;
41 *) 52 *)
42 die "Unsupported EAPI: ${EAPI}" ;; 53 die "Unsupported EAPI: ${EAPI}" ;;
43esac 54esac
44 55
45# Shorten the path because the socket path length must be shorter than 107 chars
46# and we will run a mysql server during test phase
47S="${WORKDIR}/mysql"
48 56
49[[ "${MY_EXTRAS_VER}" == "latest" ]] && MY_EXTRAS_VER="20090228-0714Z" 57# @ECLASS-VARIABLE: MYSQL_PV_MAJOR
50if [[ "${MY_EXTRAS_VER}" == "live" ]]; then 58# @DESCRIPTION:
51 EGIT_PROJECT=mysql-extras 59# Upstream MySQL considers the first two parts of the version number to be the
52 EGIT_REPO_URI="git://git.overlays.gentoo.org/proj/mysql-extras.git" 60# major version. Upgrades that change major version should always run
53 inherit git 61# mysql_upgrade.
54fi 62MYSQL_PV_MAJOR="$(get_version_component_range 1-2 ${PV})"
55 63
56# @ECLASS-VARIABLE: MYSQL_VERSION_ID 64# @ECLASS-VARIABLE: MYSQL_VERSION_ID
57# @DESCRIPTION: 65# @DESCRIPTION:
58# MYSQL_VERSION_ID will be: 66# MYSQL_VERSION_ID will be:
59# major * 10e6 + minor * 10e4 + micro * 10e2 + gentoo revision number, all [0..99] 67# major * 10e6 + minor * 10e4 + micro * 10e2 + gentoo revision number, all [0..99]
77# @DESCRIPTION: 85# @DESCRIPTION:
78# Specifiy if community features are available. Possible values are 1 (yes) 86# Specifiy if community features are available. Possible values are 1 (yes)
79# and 0 (no). 87# and 0 (no).
80# Community features are available in mysql-community 88# Community features are available in mysql-community
81# AND in the re-merged mysql-5.0.82 and newer 89# AND in the re-merged mysql-5.0.82 and newer
82if [ "${PN}" == "mysql-community" ]; then 90if [ "${PN}" == "mysql-community" -o "${PN}" == "mariadb" ]; then
83 MYSQL_COMMUNITY_FEATURES=1 91 MYSQL_COMMUNITY_FEATURES=1
84elif [ "${PV#5.0}" != "${PV}" ] && mysql_version_is_at_least "5.0.82"; then 92elif [ "${PV#5.0}" != "${PV}" ] && mysql_version_is_at_least "5.0.82"; then
85 MYSQL_COMMUNITY_FEATURES=1 93 MYSQL_COMMUNITY_FEATURES=1
86elif [ "${PV#5.1}" != "${PV}" ] && mysql_version_is_at_least "5.1.28"; then 94elif [ "${PV#5.1}" != "${PV}" ] && mysql_version_is_at_least "5.1.28"; then
87 MYSQL_COMMUNITY_FEATURES=1 95 MYSQL_COMMUNITY_FEATURES=1
88elif [ "${PV#5.4}" != "${PV}" ]; then 96elif [ "${PV#5.4}" != "${PV}" ] ; then
97 MYSQL_COMMUNITY_FEATURES=1
98elif [ "${PV#5.5}" != "${PV}" ] ; then
99 MYSQL_COMMUNITY_FEATURES=1
100elif [ "${PV#6.0}" != "${PV}" ] ; then
89 MYSQL_COMMUNITY_FEATURES=1 101 MYSQL_COMMUNITY_FEATURES=1
90else 102else
91 MYSQL_COMMUNITY_FEATURES=0 103 MYSQL_COMMUNITY_FEATURES=0
92fi 104fi
93 105
108 >=sys-apps/sed-4 120 >=sys-apps/sed-4
109 >=sys-apps/texinfo-4.7-r1 121 >=sys-apps/texinfo-4.7-r1
110 >=sys-libs/readline-4.1 122 >=sys-libs/readline-4.1
111 >=sys-libs/zlib-1.2.3" 123 >=sys-libs/zlib-1.2.3"
112 124
125[[ "${PN}" == "mariadb" ]] \
126&& DEPEND="${DEPEND} libevent? ( >=dev-libs/libevent-1.4 )"
127
113# Having different flavours at the same time is not a good idea 128# Having different flavours at the same time is not a good idea
114for i in "" "-community" ; do 129for i in "mysql" "mysql-community" "mariadb" ; do
115 [[ "${i}" == ${PN#mysql} ]] || 130 [[ "${i}" == ${PN} ]] ||
116 DEPEND="${DEPEND} !dev-db/mysql${i}" 131 DEPEND="${DEPEND} !dev-db/${i}"
117done 132done
118 133
119RDEPEND="${DEPEND} 134RDEPEND="${DEPEND}
120 !minimal? ( dev-db/mysql-init-scripts ) 135 !minimal? ( dev-db/mysql-init-scripts )
121 selinux? ( sec-policy/selinux-mysql )" 136 selinux? ( sec-policy/selinux-mysql )"
130 145
131# dev-perl/DBD-mysql is needed by some scripts installed by MySQL 146# dev-perl/DBD-mysql is needed by some scripts installed by MySQL
132PDEPEND="perl? ( >=dev-perl/DBD-mysql-2.9004 )" 147PDEPEND="perl? ( >=dev-perl/DBD-mysql-2.9004 )"
133 148
134# For other stuff to bring us in 149# For other stuff to bring us in
135PDEPEND="${PDEPEND} =virtual/mysql-$(get_version_component_range 1-2 ${PV})" 150PDEPEND="${PDEPEND} =virtual/mysql-${MYSQL_PV_MAJOR}"
136 151
137# Work out the default SERVER_URI correctly 152# Work out the default SERVER_URI correctly
138if [ -z "${SERVER_URI}" ]; then 153if [ -z "${SERVER_URI}" ]; then
154 [ -z "${MY_PV}" ] && MY_PV="${PV//_/-}"
155 if [ "${PN}" == "mariadb" ]; then
156 MARIA_FULL_PV="$(replace_version_separator 3 '-' ${PV})"
157 MARIA_FULL_P="${PN}-${MARIA_FULL_PV}"
158 SERVER_URI="
159 http://ftp.rediris.es/mirror/MariaDB/${MARIA_FULL_P}/kvm-tarbake-jaunty-x86/${MARIA_FULL_P}.tar.gz
160 http://maria.llarian.net/download/${MARIA_FULL_P}/kvm-tarbake-jaunty-x86/${MARIA_FULL_P}.tar.gz
161 http://launchpad.net/maria/${MYSQL_PV_MAJOR}/ongoing/+download/${MARIA_FULL_P}.tar.gz
162 "
139 # The community build is on the mirrors 163 # The community build is on the mirrors
140 if [ "${MYSQL_COMMUNITY_FEATURES}" == "1" ]; then 164 elif [ "${MYSQL_COMMUNITY_FEATURES}" == "1" ]; then
141 SERVER_URI="mirror://mysql/Downloads/MySQL-${PV%.*}/mysql-${PV//_/-}.tar.gz" 165 SERVER_URI="mirror://mysql/Downloads/MySQL-${PV%.*}/mysql-${MY_PV}.tar.gz"
142 # The (old) enterprise source is on the primary site only 166 # The (old) enterprise source is on the primary site only
143 elif [ "${PN}" == "mysql" ]; then 167 elif [ "${PN}" == "mysql" ]; then
144 SERVER_URI="ftp://ftp.mysql.com/pub/mysql/src/mysql-${PV//_/-}.tar.gz" 168 SERVER_URI="ftp://ftp.mysql.com/pub/mysql/src/mysql-${MY_PV}.tar.gz"
145 fi 169 fi
146fi 170fi
147 171
148# Define correct SRC_URIs 172# Define correct SRC_URIs
149SRC_URI="${SERVER_URI}" 173SRC_URI="${SERVER_URI}"
150 174
151# Gentoo patches to MySQL 175# Gentoo patches to MySQL
152[[ ${MY_EXTRAS_VER} != live ]] \ 176[[ ${MY_EXTRAS_VER} != live ]] \
153&& SRC_URI="${SRC_URI} 177&& SRC_URI="${SRC_URI}
154 mirror://gentoo/mysql-extras-${MY_EXTRAS_VER}.tar.bz2 178 mirror://gentoo/mysql-extras-${MY_EXTRAS_VER}.tar.bz2
155 http://g3nt8.org/patches/mysql-extras-${MY_EXTRAS_VER}.tar.bz2" 179 http://g3nt8.org/patches/mysql-extras-${MY_EXTRAS_VER}.tar.bz2
156 180 http://dev.gentoo.org/~robbat2/distfiles/mysql-extras-${MY_EXTRAS_VER}.tar.bz2"
157# PBXT engine
158mysql_version_is_at_least "5.1.12" \
159&& [[ -n "${PBXT_VERSION}" ]] \
160&& PBXT_P="pbxt-${PBXT_VERSION}" \
161&& PBXT_SRC_URI="mirror://sourceforge/pbxt/${PBXT_P}.tar.gz" \
162&& SRC_URI="${SRC_URI} pbxt? ( ${PBXT_SRC_URI} )"
163
164# Get the percona tarball if XTRADB_VER and PERCONA_VER are both set
165mysql_version_is_at_least "5.1.26" \
166&& [[ -n "${XTRADB_VER}" && -n "${PERCONA_VER}" ]] \
167&& XTRADB_P="percona-xtradb-${XTRADB_VER}" \
168&& XTRADB_SRC_URI="http://www.percona.com/${PN}/xtradb/${PERCONA_VER}/source/${XTRADB_P}.tar.gz" \
169&& SRC_URI="${SRC_URI} xtradb? ( ${XTRADB_SRC_URI} )"
170 181
171DESCRIPTION="A fast, multi-threaded, multi-user SQL database server." 182DESCRIPTION="A fast, multi-threaded, multi-user SQL database server."
172HOMEPAGE="http://www.mysql.com/" 183HOMEPAGE="http://www.mysql.com/"
184if [[ "${PN}" == "mariadb" ]]; then
185 HOMEPAGE="http://askmonty.org/"
186 DESCRIPTION="MariaDB is a MySQL fork with 3rd-party patches and additional storage engines merged."
187fi
188if [[ "${PN}" == "mysql-community" ]]; then
189 DESCRIPTION="${DESCRIPTION} (obsolete, move to dev-db/mysql)"
190fi
173LICENSE="GPL-2" 191LICENSE="GPL-2"
174SLOT="0" 192SLOT="0"
175IUSE="big-tables debug embedded minimal ${IUSE_DEFAULT_ON}perl selinux ssl static" 193IUSE="big-tables debug embedded minimal ${IUSE_DEFAULT_ON}perl selinux ssl static test"
176 194
177mysql_version_is_at_least "4.1" \ 195mysql_version_is_at_least "4.1" \
178&& IUSE="${IUSE} latin1" 196&& IUSE="${IUSE} latin1"
179 197
180mysql_version_is_at_least "4.1.3" \ 198mysql_version_is_at_least "4.1.3" \
187&& IUSE="${IUSE} max-idx-128" 205&& IUSE="${IUSE} max-idx-128"
188 206
189mysql_version_is_at_least "5.1" \ 207mysql_version_is_at_least "5.1" \
190|| IUSE="${IUSE} berkdb" 208|| IUSE="${IUSE} berkdb"
191 209
192mysql_version_is_at_least "5.1.12" \
193&& [[ -n "${PBXT_VERSION}" ]] \
194&& IUSE="${IUSE} pbxt"
195
196mysql_version_is_at_least "5.1.26" \
197&& [[ -n "${XTRADB_VER}" && -n "${PERCONA_VER}" ]] \
198&& IUSE="${IUSE} xtradb"
199
200[ "${MYSQL_COMMUNITY_FEATURES}" == "1" ] \ 210[ "${MYSQL_COMMUNITY_FEATURES}" == "1" ] \
201&& IUSE="${IUSE} ${IUSE_DEFAULT_ON}community profiling" 211&& IUSE="${IUSE} ${IUSE_DEFAULT_ON}community profiling"
212
213[[ "${PN}" == "mariadb" ]] \
214&& IUSE="${IUSE} libevent"
215
216# MariaDB has integrated PBXT
217# PBXT_VERSION means that we have a PBXT patch for this PV
218# PBXT was only introduced after 5.1.12
219pbxt_patch_available() {
220 [[ "${PN}" != "mariadb" ]] \
221 && mysql_version_is_at_least "5.1.12" \
222 && [[ -n "${PBXT_VERSION}" ]]
223 return $?
224}
225
226pbxt_available() {
227 pbxt_patch_available || [[ "${PN}" == "mariadb" ]]
228 return $?
229}
230
231# Get the percona tarball if XTRADB_VER and PERCONA_VER are both set
232# MariaDB has integrated XtraDB
233# XTRADB_VERS means that we have a XTRADB patch for this PV
234# XTRADB was only introduced after 5.1.26
235xtradb_patch_available() {
236 [[ "${PN}" != "mariadb" ]] \
237 && mysql_version_is_at_least "5.1.26" \
238 && [[ -n "${XTRADB_VER}" && -n "${PERCONA_VER}" ]]
239 return $?
240}
241
242
243pbxt_patch_available \
244&& PBXT_P="pbxt-${PBXT_VERSION}" \
245&& PBXT_SRC_URI="http://www.primebase.org/download/${PBXT_P}.tar.gz mirror://sourceforge/pbxt/${PBXT_P}.tar.gz" \
246&& SRC_URI="${SRC_URI} pbxt? ( ${PBXT_SRC_URI} )" \
247
248# PBXT_NEWSTYLE means pbxt is in storage/ and gets enabled as other plugins
249# vs. built outside the dir
250pbxt_available \
251&& IUSE="${IUSE} pbxt" \
252&& mysql_version_is_at_least "5.1.40" \
253&& PBXT_NEWSTYLE=1
254
255xtradb_patch_available \
256&& XTRADB_P="percona-xtradb-${XTRADB_VER}" \
257&& XTRADB_SRC_URI_COMMON="${PERCONA_VER}/source/${XTRADB_P}.tar.gz" \
258&& XTRADB_SRC_B1="http://www.percona.com/" \
259&& XTRADB_SRC_B2="${XTRADB_SRC_B1}/percona-builds/" \
260&& XTRADB_SRC_URI1="${XTRADB_SRC_B2}/Percona-Server/Percona-Server-${XTRADB_SRC_URI_COMMON}" \
261&& XTRADB_SRC_URI2="${XTRADB_SRC_B2}/xtradb/${XTRADB_SRC_URI_COMMON}" \
262&& XTRADB_SRC_URI3="${XTRADB_SRC_B1}/${PN}/xtradb/${XTRADB_SRC_URI_COMMON}" \
263&& SRC_URI="${SRC_URI} xtradb? ( ${XTRADB_SRC_URI1} ${XTRADB_SRC_URI2} ${XTRADB_SRC_URI3} )" \
264&& IUSE="${IUSE} xtradb"
202 265
203# 266#
204# HELPER FUNCTIONS: 267# HELPER FUNCTIONS:
205# 268#
206 269
207# @FUNCTION: mysql_disable_test 270# @FUNCTION: mysql_disable_test
208# @DESCRIPTION: 271# @DESCRIPTION:
209# Helper function to disable specific tests. 272# Helper function to disable specific tests.
210mysql_disable_test() { 273mysql_disable_test() {
274 local rawtestname testname testsuite reason mysql_disable_file
211 local testname="${1}" ; shift 275 rawtestname="${1}" ; shift
212 local reason="${@}" 276 reason="${@}"
277 ewarn "test '${rawtestname}' disabled: '${reason}'"
278
279 testsuite="${rawtestname/.*}"
280 testname="${rawtestname/*.}"
213 local mysql_disable_file="${S}/mysql-test/t/disabled.def" 281 mysql_disable_file="${S}/mysql-test/t/disabled.def"
282 #einfo "rawtestname=${rawtestname} testname=${testname} testsuite=${testsuite}"
214 echo ${testname} : ${reason} >> "${mysql_disable_file}" 283 echo ${testname} : ${reason} >> "${mysql_disable_file}"
215 ewarn "test '${testname}' disabled: '${reason}'" 284
285 # ${S}/mysql-tests/t/disabled.def
286 #
287 # ${S}/mysql-tests/suite/federated/disabled.def
288 #
289 # ${S}/mysql-tests/suite/jp/t/disabled.def
290 # ${S}/mysql-tests/suite/ndb/t/disabled.def
291 # ${S}/mysql-tests/suite/rpl/t/disabled.def
292 # ${S}/mysql-tests/suite/parts/t/disabled.def
293 # ${S}/mysql-tests/suite/rpl_ndb/t/disabled.def
294 # ${S}/mysql-tests/suite/ndb_team/t/disabled.def
295 # ${S}/mysql-tests/suite/binlog/t/disabled.def
296 # ${S}/mysql-tests/suite/innodb/t/disabled.def
297 if [ -n "${testsuite}" ]; then
298 for mysql_disable_file in \
299 ${S}/mysql-test/suite/${testsuite}/disabled.def \
300 ${S}/mysql-test/suite/${testsuite}/t/disabled.def \
301 FAILED ; do
302 [ -f "${mysql_disable_file}" ] && break
303 done
304 if [ "${mysql_disabled_file}" != "FAILED" ]; then
305 echo "${testname} : ${reason}" >> "${mysql_disable_file}"
306 else
307 ewarn "Could not find testsuite disabled.def location for ${rawtestname}"
308 fi
309 fi
216} 310}
217 311
218# @FUNCTION: mysql_init_vars 312# @FUNCTION: mysql_init_vars
219# @DESCRIPTION: 313# @DESCRIPTION:
220# void mysql_init_vars() 314# void mysql_init_vars()
363 myconf="${myconf} $(use_with perl bench)" 457 myconf="${myconf} $(use_with perl bench)"
364 myconf="${myconf} --enable-assembler" 458 myconf="${myconf} --enable-assembler"
365 myconf="${myconf} --with-extra-tools" 459 myconf="${myconf} --with-extra-tools"
366 myconf="${myconf} --with-innodb" 460 myconf="${myconf} --with-innodb"
367 myconf="${myconf} --without-readline" 461 myconf="${myconf} --without-readline"
462 myconf="${myconf} $(use_with ssl openssl)"
368 mysql_version_is_at_least "5.0" || myconf="${myconf} $(use_with raid)" 463 mysql_version_is_at_least "5.0" || myconf="${myconf} $(use_with raid)"
369 464
370 # --with-vio is not needed anymore, it's on by default and 465 # --with-vio is not needed anymore, it's on by default and
371 # has been removed from configure 466 # has been removed from configure
467 # Apply to 4.x and 5.0.[0-3]
372 if use ssl ; then 468 if use ssl ; then
373 mysql_version_is_at_least "5.0.4" || myconf="${myconf} --with-vio" 469 mysql_version_is_at_least "5.0.4" || myconf="${myconf} --with-vio"
374 fi
375
376 if mysql_version_is_at_least "5.1.11" ; then
377 myconf="${myconf} $(use_with ssl)"
378 else
379 myconf="${myconf} $(use_with ssl openssl)"
380 fi 470 fi
381 471
382 if mysql_version_is_at_least "5.0.60" ; then 472 if mysql_version_is_at_least "5.0.60" ; then
383 if use berkdb ; then 473 if use berkdb ; then
384 elog "Berkeley DB support was disabled due to build failures" 474 elog "Berkeley DB support was disabled due to build failures"
441 531
442configure_51() { 532configure_51() {
443 # TODO: !!!! readd --without-readline 533 # TODO: !!!! readd --without-readline
444 # the failure depend upon config/ac-macros/readline.m4 checking into 534 # the failure depend upon config/ac-macros/readline.m4 checking into
445 # readline.h instead of history.h 535 # readline.h instead of history.h
446 myconf="${myconf} $(use_with ssl)" 536 myconf="${myconf} $(use_with ssl ssl /usr)"
447 myconf="${myconf} --enable-assembler" 537 myconf="${myconf} --enable-assembler"
448 myconf="${myconf} --with-geometry" 538 myconf="${myconf} --with-geometry"
449 myconf="${myconf} --with-readline" 539 myconf="${myconf} --with-readline"
450 myconf="${myconf} --with-row-based-replication"
451 myconf="${myconf} --with-zlib=/usr/$(get_libdir)" 540 myconf="${myconf} --with-zlib-dir=/usr/"
452 myconf="${myconf} --without-pstack" 541 myconf="${myconf} --without-pstack"
542 myconf="${myconf} --with-plugindir=/usr/$(get_libdir)/mysql/plugin"
543
453 use max-idx-128 && myconf="${myconf} --with-max-indexes=128" 544 use max-idx-128 && myconf="${myconf} --with-max-indexes=128"
545 if [ "${MYSQL_COMMUNITY_FEATURES}" == "1" ]; then
546 myconf="${myconf} $(use_enable community community-features)"
547 if use community; then
548 myconf="${myconf} $(use_enable profiling)"
549 else
550 myconf="${myconf} --disable-profiling"
551 fi
552 fi
553
554 # Scan for all available plugins
555 local plugins_avail="$(
556 LANG=C \
557 find "${S}" \
558 \( \
559 -name 'plug.in' \
560 -o -iname 'configure.in' \
561 -o -iname 'configure.ac' \
562 \) \
563 -print0 \
564 | xargs -0 sed -r -n \
565 -e '/^MYSQL_STORAGE_ENGINE/{
566 s~MYSQL_STORAGE_ENGINE\([[:space:]]*\[?([-_a-z0-9]+)\]?.*,~\1 ~g ;
567 s~^([^ ]+).*~\1~gp;
568 }' \
569 | tr -s '\n' ' '
570 )"
454 571
455 # 5.1 introduces a new way to manage storage engines (plugins) 572 # 5.1 introduces a new way to manage storage engines (plugins)
456 # like configuration=none 573 # like configuration=none
574 # This base set are required, and will always be statically built.
457 local plugins="csv,myisam,myisammrg,heap" 575 local plugins_sta="csv myisam myisammrg heap"
576 local plugins_dyn=""
577 local plugins_dis="example ibmdb2i"
578
579 # These aren't actually required by the base set, but are really useful:
580 plugins_sta="${plugins_sta} archive blackhole"
581
582 # default in 5.5.4
583 if mysql_version_is_at_least "5.5.4" ; then
584 plugins_sta="${plugins_sta} partition"
585 fi
586 # Now the extras
458 if use extraengine ; then 587 if use extraengine ; then
459 # like configuration=max-no-ndb, archive and example removed in 5.1.11 588 # like configuration=max-no-ndb, archive and example removed in 5.1.11
460 plugins="${plugins},archive,blackhole,example,federated,partition" 589 # not added yet: ibmdb2i
590 # Not supporting as examples: example,daemon_example,ftexample
591 plugins_sta="${plugins_sta} partition"
592 plugins_dyn="${plugins_sta} federated"
461 593
594 if [[ "${PN}" != "mariadb" ]] ; then
462 elog "Before using the Federated storage engine, please be sure to read" 595 elog "Before using the Federated storage engine, please be sure to read"
463 elog "http://dev.mysql.com/doc/refman/5.1/en/federated-limitations.html" 596 elog "http://dev.mysql.com/doc/refman/5.1/en/federated-limitations.html"
597 else
598 elog "MariaDB includes the FederatedX engine. Be sure to read"
599 elog "http://askmonty.org/wiki/index.php/Manual:FederatedX_storage_engine"
464 fi 600 fi
601 else
602 plugins_dis="${plugins_dis} partition federated"
603 fi
465 604
466 # Upstream specifically requests that InnoDB always be built. 605 # Upstream specifically requests that InnoDB always be built:
467 plugins="${plugins},innobase" 606 # - innobase, innodb_plugin
607 # Build falcon if available for 6.x series.
608 for i in innobase falcon ; do
609 [ -e "${S}"/storage/${i} ] && plugins_sta="${plugins_sta} ${i}"
610 done
611 for i in innodb_plugin ; do
612 [ -e "${S}"/storage/${i} ] && plugins_dyn="${plugins_dyn} ${i}"
613 done
468 614
469 # like configuration=max-no-ndb 615 # like configuration=max-no-ndb
470 if use cluster ; then 616 if use cluster ; then
471 plugins="${plugins},ndbcluster" 617 plugins_sta="${plugins_sta} ndbcluster"
472 myconf="${myconf} --with-ndb-binlog" 618 myconf="${myconf} --with-ndb-binlog"
619 else
620 plugins_dis="${plugins_dis} ndbcluster"
473 fi 621 fi
474 622
475 if mysql_version_is_at_least "5.2" ; then 623 if [[ "${PN}" == "mariadb" ]] ; then
476 plugins="${plugins},falcon" 624 # In MariaDB, InnoDB is packaged in the xtradb directory, so it's not
625 # caught above.
626 plugins_sta="${plugins_sta},maria,innobase"
627 myconf="${myconf} $(use_with libevent)"
628 # This is not optional, without it several upstream testcases fail.
629 # Also strongly recommended by upstream.
630 myconf="${myconf} --with-maria-tmp-tables"
477 fi 631 fi
632
633 if pbxt_available && [[ "${PBXT_NEWSTYLE}" == "1" ]]; then
634 use pbxt \
635 && plugins_dyn="${plugins_dyn} pbxt" \
636 || plugins_dis="${plugins_dis} pbxt"
637 fi
478 638
639 use static && \
640 plugins_sta="${plugins_sta} ${plugins_dyn}" && \
641 plugins_dyn=""
642
643 einfo "Available plugins: ${plugins_avail}"
644 einfo "Dynamic plugins: ${plugins_dyn}"
645 einfo "Static plugins: ${plugins_sta}"
646 einfo "Disabled plugins: ${plugins_dis}"
647
648 # These are the static plugins
479 myconf="${myconf} --with-plugins=${plugins}" 649 myconf="${myconf} --with-plugins=${plugins_sta// /,}"
650 # And the disabled ones
651 for i in ${plugins_dis} ; do
652 myconf="${myconf} --without-plugin-${i}"
653 done
480} 654}
481 655
482pbxt_src_configure() { 656pbxt_src_configure() {
483 mysql_init_vars 657 mysql_init_vars
484 658
486 660
487 einfo "Reconfiguring dir '${PWD}'" 661 einfo "Reconfiguring dir '${PWD}'"
488 AT_GNUCONF_UPDATE="yes" eautoreconf 662 AT_GNUCONF_UPDATE="yes" eautoreconf
489 663
490 local myconf="" 664 local myconf=""
491 myconf="${myconf} --with-mysql=${S} --libdir=${D}/${MY_LIBDIR}" 665 myconf="${myconf} --with-mysql=${S} --libdir=/usr/$(get_libdir)"
492 use debug && myconf="${myconf} --with-debug=full" 666 use debug && myconf="${myconf} --with-debug=full"
493 # TODO: is it safe/needed to use econf here ?
494 ./configure ${myconf} || die "Problem configuring PBXT storage engine" 667 econf ${myconf} || die "Problem configuring PBXT storage engine"
495} 668}
496 669
497pbxt_src_compile() { 670pbxt_src_compile() {
671
498 # Be backwards compatible for now 672 # Be backwards compatible for now
499 if [[ $EAPI != 2 ]]; then 673 if [[ $EAPI != 2 ]]; then
500 pbxt_src_configure 674 pbxt_src_configure
501 fi 675 fi
502 # TODO: is it safe/needed to use emake here ? 676 # TODO: is it safe/needed to use emake here ?
506 # TODO: modify test suite for PBXT 680 # TODO: modify test suite for PBXT
507} 681}
508 682
509pbxt_src_install() { 683pbxt_src_install() {
510 pushd "${WORKDIR}/pbxt-${PBXT_VERSION}" &>/dev/null 684 pushd "${WORKDIR}/pbxt-${PBXT_VERSION}" &>/dev/null
511 make install || die "Failed to install PBXT" 685 emake install DESTDIR="${D}" || die "Failed to install PBXT"
512 popd 686 popd
513} 687}
514 688
515# 689#
516# EBUILD FUNCTIONS 690# EBUILD FUNCTIONS
531 fi 705 fi
532 fi 706 fi
533 707
534 # Check for USE flag problems in pkg_setup 708 # Check for USE flag problems in pkg_setup
535 if use static && use ssl ; then 709 if use static && use ssl ; then
536 eerror "MySQL does not support being built statically with SSL support enabled!"
537 die "MySQL does not support being built statically with SSL support enabled!" 710 M="MySQL does not support being built statically with SSL support enabled!"
711 eerror "${M}"
712 die "${M}"
538 fi 713 fi
539 714
540 if ! mysql_version_is_at_least "5.0" \ 715 if ! mysql_version_is_at_least "5.0" \
541 && use raid \ 716 && use raid \
542 && use static ; then 717 && use static ; then
544 eerror "with RAID support enabled." 719 eerror "with RAID support enabled."
545 die "USE flags 'raid' and 'static' conflict!" 720 die "USE flags 'raid' and 'static' conflict!"
546 fi 721 fi
547 722
548 if mysql_version_is_at_least "4.1.3" \ 723 if mysql_version_is_at_least "4.1.3" \
549 && ( use cluster || use extraengine ) \ 724 && ( use cluster || use extraengine || use embedded ) \
550 && use minimal ; then 725 && use minimal ; then
551 eerror "USE flags 'cluster' and 'extraengine' conflict with 'minimal' USE flag!"
552 die "USE flags 'cluster' and 'extraengine' conflict with 'minimal' USE flag!" 726 M="USE flags 'cluster', 'extraengine', 'embedded' conflict with 'minimal' USE flag!"
727 eerror "${M}"
728 die "${M}"
729 fi
730
731 if mysql_version_is_at_least "5.1" \
732 && xtradb_patch_available \
733 && use xtradb \
734 && use embedded ; then
735 M="USE flags 'xtradb' and 'embedded' conflict and cause build failures"
736 eerror "${M}"
737 die "${M}"
738 fi
739
740 # Bug #290570, 284946, 307251
741 # Upstream changes made us need a fairly new GCC4.
742 # But only for 5.0.8[3-6]!
743 if mysql_version_is_at_least "5.0.83" && ! mysql_version_is_at_least 5.0.87 ; then
744 GCC_VER=$(gcc-version)
745 case ${GCC_VER} in
746 2*|3*|4.0|4.1|4.2)
747 eerror "Some releases of MySQL required a very new GCC, and then"
748 eerror "later release relaxed that requirement again. Either pick a"
749 eerror "MySQL >=5.0.87, or use a newer GCC."
750 die "Active GCC too old!" ;;
751 esac
553 fi 752 fi
554 753
555 # This should come after all of the die statements 754 # This should come after all of the die statements
556 enewgroup mysql 60 || die "problem adding 'mysql' group" 755 enewgroup mysql 60 || die "problem adding 'mysql' group"
557 enewuser mysql 60 -1 /dev/null mysql || die "problem adding 'mysql' user" 756 enewuser mysql 60 -1 /dev/null mysql || die "problem adding 'mysql' user"
558 757
559 mysql_check_version_range "4.0 to 5.0.99.99" \ 758 mysql_check_version_range "4.0 to 5.0.99.99" \
560 && use berkdb \ 759 && use berkdb \
561 && elog "Berkeley DB support is deprecated and will be removed in future versions!" 760 && elog "Berkeley DB support is deprecated and will be removed in future versions!"
761
762 if [ "${PN}" != "mysql-cluster" ] && use cluster; then
763 ewarn "Upstream has noted that the NDB cluster support in the 5.0 and"
764 ewarn "5.1 series should NOT be put into production. In the near"
765 ewarn "future, it will be disabled from building."
766 ewarn ""
767 ewarn "If you need NDB support, you should instead move to the new"
768 ewarn "mysql-cluster package that represents that upstream NDB"
769 ewarn "development."
770 fi
562} 771}
563 772
564# @FUNCTION: mysql_src_unpack 773# @FUNCTION: mysql_src_unpack
565# @DESCRIPTION: 774# @DESCRIPTION:
566# Unpack the source code and call mysql_src_prepare for EAPI < 2. 775# Unpack the source code and call mysql_src_prepare for EAPI < 2.
595 # Now link in right patches 804 # Now link in right patches
596 mysql_mv_patches 805 mysql_mv_patches
597 # And apply 806 # And apply
598 epatch 807 epatch
599 808
809 # last -fPIC fixup, per bug #305873
810 i="${S}"/storage/innodb_plugin/plug.in
811 [ -f "${i}" ] && sed -i -e '/CFLAGS/s,-prefer-non-pic,,g' "${i}"
812
600 # Additional checks, remove bundled zlib 813 # Additional checks, remove bundled zlib
601 rm -f "${S}/zlib/"*.[ch] 814 rm -f "${S}/zlib/"*.[ch]
602 sed -i -e "s/zlib\/Makefile dnl/dnl zlib\/Makefile/" "${S}/configure.in" 815 sed -i -e "s/zlib\/Makefile dnl/dnl zlib\/Makefile/" "${S}/configure.in"
603 rm -f "scripts/mysqlbug" 816 rm -f "scripts/mysqlbug"
604 817
617 rm -f "scripts/mysqlbug" 830 rm -f "scripts/mysqlbug"
618 fi 831 fi
619 832
620 local rebuilddirlist d 833 local rebuilddirlist d
621 834
622 if mysql_version_is_at_least "5.1.26" && use xtradb ; then 835 if xtradb_patch_available && use xtradb ; then
623 einfo "Replacing InnoDB with Percona XtraDB" 836 einfo "Adding storage engine: Percona XtraDB (replacing InnoDB)"
624 pushd "${S}"/storage 837 pushd "${S}"/storage >/dev/null
625 i="innobase" 838 i="innobase"
626 o="${WORKDIR}/storage-${i}.mysql-upstream" 839 o="${WORKDIR}/storage-${i}.mysql-upstream"
627 # Have we been here already? 840 # Have we been here already?
628 [ -h "${i}" ] && rm -f "${i}" 841 [ -d "${o}" ] && rm -f "${i}"
629 # Or maybe we haven't 842 # Or maybe we haven't
630 [ -d "${i}" -a ! -d "${o}" ] && mv "${i}" "${o}" 843 [ -d "${i}" -a ! -d "${o}" ] && mv "${i}" "${o}"
631 ln -s "${WORKDIR}/${XTRADB_P}" "${i}" 844 cp -ral "${WORKDIR}/${XTRADB_P}" "${i}"
632 popd 845 popd >/dev/null
846 fi
847
848 if pbxt_available && [[ "${PBXT_NEWSTYLE}" == "1" ]] && use pbxt ; then
849 einfo "Adding storage engine: PBXT"
850 pushd "${S}"/storage >/dev/null
851 i='pbxt'
852 [ -d "${i}" ] && rm -rf "${i}"
853 cp -ral "${WORKDIR}/${PBXT_P}" "${i}"
854 popd >/dev/null
633 fi 855 fi
634 856
635 if mysql_version_is_at_least "5.1.12" ; then 857 if mysql_version_is_at_least "5.1.12" ; then
636 einfo "Updating innobase cmake"
637 rebuilddirlist="." 858 rebuilddirlist="."
859 # This does not seem to be needed presently. robbat2 2010/02/23
860 #einfo "Updating innobase cmake"
638 # TODO: check this with a cmake expert 861 ## TODO: check this with a cmake expert
639 cmake \ 862 #cmake \
640 -DCMAKE_C_COMPILER=$(type -P $(tc-getCC)) \ 863 # -DCMAKE_C_COMPILER=$(type -P $(tc-getCC)) \
641 -DCMAKE_CXX_COMPILER=$(type -P $(tc-getCXX)) \ 864 # -DCMAKE_CXX_COMPILER=$(type -P $(tc-getCXX)) \
642 "storage/innobase" 865 # "storage/innobase"
643 else 866 else
644 rebuilddirlist=". innobase" 867 rebuilddirlist=". innobase"
645 fi 868 fi
646 869
647 for d in ${rebuilddirlist} ; do 870 for d in ${rebuilddirlist} ; do
730 # TODO: Move this before autoreconf !!! 953 # TODO: Move this before autoreconf !!!
731 find . -type f -name Makefile -print0 \ 954 find . -type f -name Makefile -print0 \
732 | xargs -0 -n100 sed -i \ 955 | xargs -0 -n100 sed -i \
733 -e 's|^pkglibdir *= *$(libdir)/mysql|pkglibdir = $(libdir)|;s|^pkgincludedir *= *$(includedir)/mysql|pkgincludedir = $(includedir)|' 956 -e 's|^pkglibdir *= *$(libdir)/mysql|pkglibdir = $(libdir)|;s|^pkgincludedir *= *$(includedir)/mysql|pkgincludedir = $(includedir)|'
734 957
735 if [[ $EAPI == 2 ]]; then 958 if [[ $EAPI == 2 ]] && [[ "${PBXT_NEWSTYLE}" != "1" ]]; then
736 mysql_version_is_at_least "5.1.12" && use pbxt && pbxt_src_configure 959 pbxt_patch_available && use pbxt && pbxt_src_configure
737 fi 960 fi
738} 961}
739 962
740# @FUNCTION: mysql_src_compile 963# @FUNCTION: mysql_src_compile
741# @DESCRIPTION: 964# @DESCRIPTION:
742# Compile the mysql code. 965# Compile the mysql code.
743mysql_src_compile() { 966mysql_src_compile() {
744 # Be backwards compatible for now 967 # Be backwards compatible for now
745 case ${EAPI:-0} in 968 case ${EAPI:-0} in
746 2) : ;; 969 2) : ;;
747 0 | 1) mysql_src_configure ;; 970 0 | 1) mysql_src_configure ;;
748 esac 971 esac
749 972
750 emake || die "emake failed" 973 emake || die "emake failed"
751 974
752 mysql_version_is_at_least "5.1.12" && use pbxt && pbxt_src_compile 975 if [[ "${PBXT_NEWSTYLE}" != "1" ]]; then
976 pbxt_patch_available && use pbxt && pbxt_src_compile
977 fi
753} 978}
754 979
755# @FUNCTION: mysql_src_install 980# @FUNCTION: mysql_src_install
756# @DESCRIPTION: 981# @DESCRIPTION:
757# Install mysql. 982# Install mysql.
758mysql_src_install() { 983mysql_src_install() {
759 # Make sure the vars are correctly initialized 984 # Make sure the vars are correctly initialized
760 mysql_init_vars 985 mysql_init_vars
761 986
762 emake install DESTDIR="${D}" benchdir_root="${MY_SHAREDSTATEDIR}" || die "emake install failed" 987 emake install \
988 DESTDIR="${D}" \
989 benchdir_root="${MY_SHAREDSTATEDIR}" \
990 testroot="${MY_SHAREDSTATEDIR}" \
991 || die "emake install failed"
763 992
764 mysql_version_is_at_least "5.1.12" && use pbxt && pbxt_src_install 993 if [[ "${PBXT_NEWSTYLE}" != "1" ]]; then
994 pbxt_patch_available && use pbxt && pbxt_src_install
995 fi
765 996
766 # Convenience links 997 # Convenience links
767 einfo "Making Convenience links for mysqlcheck multi-call binary" 998 einfo "Making Convenience links for mysqlcheck multi-call binary"
768 dosym "/usr/bin/mysqlcheck" "/usr/bin/mysqlanalyze" 999 dosym "/usr/bin/mysqlcheck" "/usr/bin/mysqlanalyze"
769 dosym "/usr/bin/mysqlcheck" "/usr/bin/mysqlrepair" 1000 dosym "/usr/bin/mysqlcheck" "/usr/bin/mysqlrepair"
773 einfo "Removing duplicate /usr/share/mysql files" 1004 einfo "Removing duplicate /usr/share/mysql files"
774 rm -Rf "${D}/usr/share/info" 1005 rm -Rf "${D}/usr/share/info"
775 for removeme in "mysql-log-rotate" mysql.server* \ 1006 for removeme in "mysql-log-rotate" mysql.server* \
776 binary-configure* my-*.cnf mi_test_all* 1007 binary-configure* my-*.cnf mi_test_all*
777 do 1008 do
778 rm -f "${D}"/usr/share/mysql/${removeme} 1009 rm -f "${D}"/${MY_SHAREDSTATEDIR}/${removeme}
779 done 1010 done
780 1011
781 # Clean up stuff for a minimal build 1012 # Clean up stuff for a minimal build
782 if use minimal ; then 1013 if use minimal ; then
783 einfo "Remove all extra content for minimal build" 1014 einfo "Remove all extra content for minimal build"
785 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} 1016 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}
786 rm -f "${D}/usr/sbin/mysqld" 1017 rm -f "${D}/usr/sbin/mysqld"
787 rm -f "${D}${MY_LIBDIR}"/lib{heap,merge,nisam,my{sys,strings,sqld,isammrg,isam},vio,dbug}.a 1018 rm -f "${D}${MY_LIBDIR}"/lib{heap,merge,nisam,my{sys,strings,sqld,isammrg,isam},vio,dbug}.a
788 fi 1019 fi
789 1020
1021 # Unless they explicitly specific USE=test, then do not install the
1022 # testsuite. It DOES have a use to be installed, esp. when you want to do a
1023 # validation of your database configuration after tuning it.
1024 if use !test ; then
1025 rm -rf "${D}"/${MY_SHAREDSTATEDIR}/mysql-test
1026 fi
1027
790 # Configuration stuff 1028 # Configuration stuff
1029 if mysql_version_is_at_least "5.1" ; then
1030 mysql_mycnf_version="5.1"
791 if mysql_version_is_at_least "4.1" ; then 1031 elif mysql_version_is_at_least "4.1" ; then
792 mysql_mycnf_version="4.1" 1032 mysql_mycnf_version="4.1"
793 else 1033 else
794 mysql_mycnf_version="4.0" 1034 mysql_mycnf_version="4.0"
795 fi 1035 fi
796 einfo "Building default my.cnf" 1036 einfo "Building default my.cnf"
798 doins scripts/mysqlaccess.conf 1038 doins scripts/mysqlaccess.conf
799 sed -e "s!@DATADIR@!${MY_DATADIR}!g" \ 1039 sed -e "s!@DATADIR@!${MY_DATADIR}!g" \
800 "${FILESDIR}/my.cnf-${mysql_mycnf_version}" \ 1040 "${FILESDIR}/my.cnf-${mysql_mycnf_version}" \
801 > "${TMPDIR}/my.cnf.ok" 1041 > "${TMPDIR}/my.cnf.ok"
802 if mysql_version_is_at_least "4.1" && use latin1 ; then 1042 if mysql_version_is_at_least "4.1" && use latin1 ; then
803 sed -e "s|utf8|latin1|g" -i "${TMPDIR}/my.cnf.ok" 1043 sed -i \
1044 -e "/character-set/s|utf8|latin1|g" \
1045 "${TMPDIR}/my.cnf.ok"
804 fi 1046 fi
805 newins "${TMPDIR}/my.cnf.ok" my.cnf 1047 newins "${TMPDIR}/my.cnf.ok" my.cnf
806 1048
807 # Minimal builds don't have the MySQL server 1049 # Minimal builds don't have the MySQL server
808 if ! use minimal ; then 1050 if ! use minimal ; then
823 done 1065 done
824 fi 1066 fi
825 1067
826 # Docs 1068 # Docs
827 einfo "Installing docs" 1069 einfo "Installing docs"
828 dodoc README COPYING ChangeLog EXCEPTIONS-CLIENT INSTALL-SOURCE 1070 dodoc README ChangeLog EXCEPTIONS-CLIENT INSTALL-SOURCE
829 doinfo "${S}"/Docs/mysql.info 1071 doinfo "${S}"/Docs/mysql.info
830 1072
831 # Minimal builds don't have the MySQL server 1073 # Minimal builds don't have the MySQL server
832 if ! use minimal ; then 1074 if ! use minimal ; then
833 einfo "Including support files and sample configurations" 1075 einfo "Including support files and sample configurations"
835 for script in \ 1077 for script in \
836 "${S}"/support-files/my-*.cnf \ 1078 "${S}"/support-files/my-*.cnf \
837 "${S}"/support-files/magic \ 1079 "${S}"/support-files/magic \
838 "${S}"/support-files/ndb-config-2-node.ini 1080 "${S}"/support-files/ndb-config-2-node.ini
839 do 1081 do
840 dodoc "${script}" 1082 [[ -f "$script" ]] && dodoc "${script}"
841 done 1083 done
842 1084
843 docinto "scripts" 1085 docinto "scripts"
844 for script in "${S}"/scripts/mysql* ; do 1086 for script in "${S}"/scripts/mysql* ; do
845 [[ "${script%.sh}" == "${script}" ]] && dodoc "${script}" 1087 [[ -f "$script" ]] && [[ "${script%.sh}" == "${script}" ]] && dodoc "${script}"
846 done 1088 done
847 1089
848 fi 1090 fi
849 1091
850 mysql_lib_symlinks "${D}" 1092 mysql_lib_symlinks "${D}"
884 for script in \ 1126 for script in \
885 support-files/my-*.cnf \ 1127 support-files/my-*.cnf \
886 support-files/magic \ 1128 support-files/magic \
887 support-files/ndb-config-2-node.ini 1129 support-files/ndb-config-2-node.ini
888 do 1130 do
1131 [[ -f "${script}" ]] \
889 dodoc "${script}" 1132 && dodoc "${script}"
890 done 1133 done
891 1134
892 docinto "scripts" 1135 docinto "scripts"
893 for script in scripts/mysql* ; do 1136 for script in scripts/mysql* ; do
1137 [[ -f "${script}" ]] \
894 [[ "${script%.sh}" == "${script}" ]] && dodoc "${script}" 1138 && [[ "${script%.sh}" == "${script}" ]] \
1139 && dodoc "${script}"
895 done 1140 done
896 1141
897 einfo 1142 einfo
898 elog "You might want to run:" 1143 elog "You might want to run:"
899 elog "\"emerge --config =${CATEGORY}/${PF}\"" 1144 elog "\"emerge --config =${CATEGORY}/${PF}\""
900 elog "if this is a new install." 1145 elog "if this is a new install."
901 einfo 1146 einfo
902 fi 1147 fi
903 1148
904 if mysql_version_is_at_least "5.1.12" && use pbxt ; then 1149 if pbxt_available && use pbxt ; then
905 # TODO: explain it better 1150 # TODO: explain it better
906 elog " mysql> INSTALL PLUGIN pbxt SONAME 'libpbxt.so';" 1151 elog " mysql> INSTALL PLUGIN pbxt SONAME 'libpbxt.so';"
907 elog " mysql> CREATE TABLE t1 (c1 int, c2 text) ENGINE=pbxt;" 1152 elog " mysql> CREATE TABLE t1 (c1 int, c2 text) ENGINE=pbxt;"
908 elog "if, after that, you cannot start the MySQL server," 1153 elog "if, after that, you cannot start the MySQL server,"
909 elog "remove the ${MY_DATADIR}/mysql/plugin.* files, then" 1154 elog "remove the ${MY_DATADIR}/mysql/plugin.* files, then"
960 fi 1205 fi
961 fi 1206 fi
962 1207
963 local pwd1="a" 1208 local pwd1="a"
964 local pwd2="b" 1209 local pwd2="b"
1210 local MYSQL_ROOT_PASSWORD=''
965 local maxtry=5 1211 local maxtry=15
1212
1213 if [ -z "${MYSQL_ROOT_PASSWORD}" -a -f "${ROOT}/root/.my.cnf" ]; then
1214 MYSQL_ROOT_PASSWORD="$(sed -n -e '/^password=/s,^password=,,gp' "${ROOT}/root/.my.cnf")"
1215 fi
966 1216
967 if [[ -d "${ROOT}/${MY_DATADIR}/mysql" ]] ; then 1217 if [[ -d "${ROOT}/${MY_DATADIR}/mysql" ]] ; then
968 ewarn "You have already a MySQL database in place." 1218 ewarn "You have already a MySQL database in place."
969 ewarn "(${ROOT}/${MY_DATADIR}/*)" 1219 ewarn "(${ROOT}/${MY_DATADIR}/*)"
970 ewarn "Please rename or delete it if you wish to replace it." 1220 ewarn "Please rename or delete it if you wish to replace it."
973 1223
974 # Bug #213475 - MySQL _will_ object strenously if your machine is named 1224 # Bug #213475 - MySQL _will_ object strenously if your machine is named
975 # localhost. Also causes weird failures. 1225 # localhost. Also causes weird failures.
976 [[ "${HOSTNAME}" == "localhost" ]] && die "Your machine must NOT be named localhost" 1226 [[ "${HOSTNAME}" == "localhost" ]] && die "Your machine must NOT be named localhost"
977 1227
978 einfo "Creating the mysql database and setting proper" 1228 if [ -z "${MYSQL_ROOT_PASSWORD}" ]; then
979 einfo "permissions on it ..."
980 1229
981 einfo "Insert a password for the mysql 'root' user" 1230 einfo "Please provide a password for the mysql 'root' user now,"
1231 einfo "or in the MYSQL_ROOT_PASSWORD env var."
982 ewarn "Avoid [\"'\\_%] characters in the password" 1232 ewarn "Avoid [\"'\\_%] characters in the password"
983 read -rsp " >" pwd1 ; echo 1233 read -rsp " >" pwd1 ; echo
984 1234
985 einfo "Retype the password" 1235 einfo "Retype the password"
986 read -rsp " >" pwd2 ; echo 1236 read -rsp " >" pwd2 ; echo
987 1237
988 if [[ "x$pwd1" != "x$pwd2" ]] ; then 1238 if [[ "x$pwd1" != "x$pwd2" ]] ; then
989 die "Passwords are not the same" 1239 die "Passwords are not the same"
1240 fi
1241 MYSQL_ROOT_PASSWORD="${pwd1}"
1242 unset pwd1 pwd2
990 fi 1243 fi
991 1244
992 local options="" 1245 local options=""
993 local sqltmp="$(emktemp)" 1246 local sqltmp="$(emktemp)"
994 1247
1008 [[ -f "${ROOT}/${MY_DATADIR}/mysql/user.frm" ]] \ 1261 [[ -f "${ROOT}/${MY_DATADIR}/mysql/user.frm" ]] \
1009 || die "MySQL databases not installed" 1262 || die "MySQL databases not installed"
1010 chown -R mysql:mysql "${ROOT}/${MY_DATADIR}" 2>/dev/null 1263 chown -R mysql:mysql "${ROOT}/${MY_DATADIR}" 2>/dev/null
1011 chmod 0750 "${ROOT}/${MY_DATADIR}" 2>/dev/null 1264 chmod 0750 "${ROOT}/${MY_DATADIR}" 2>/dev/null
1012 1265
1266 # Figure out which options we need to disable to do the setup
1267 helpfile="${TMPDIR}/mysqld-help"
1268 ${ROOT}/usr/sbin/mysqld --verbose --help >"${helpfile}" 2>/dev/null
1269 for opt in grant-tables host-cache name-resolve networking slave-start bdb \
1270 federated innodb ssl log-bin relay-log slow-query-log external-locking \
1271 ; do
1272 optexp="--(skip-)?${opt}" optfull="--skip-${opt}"
1273 egrep -sq -- "${optexp}" "${helpfile}" && options="${options} ${optfull}"
1274 done
1275 # But some options changed names
1276 egrep -sq external-locking "${helpfile}" && \
1277 options="${options/skip-locking/skip-external-locking}"
1278
1013 if mysql_version_is_at_least "4.1.3" ; then 1279 if mysql_version_is_at_least "4.1.3" ; then
1014 options="--skip-ndbcluster"
1015
1016 # Filling timezones, see 1280 # Filling timezones, see
1017 # http://dev.mysql.com/doc/mysql/en/time-zone-support.html 1281 # http://dev.mysql.com/doc/mysql/en/time-zone-support.html
1018 "${ROOT}/usr/bin/mysql_tzinfo_to_sql" "${ROOT}/usr/share/zoneinfo" > "${sqltmp}" 2>/dev/null 1282 "${ROOT}/usr/bin/mysql_tzinfo_to_sql" "${ROOT}/usr/share/zoneinfo" > "${sqltmp}" 2>/dev/null
1019 1283
1020 if [[ -r "${help_tables}" ]] ; then 1284 if [[ -r "${help_tables}" ]] ; then
1021 cat "${help_tables}" >> "${sqltmp}" 1285 cat "${help_tables}" >> "${sqltmp}"
1022 fi 1286 fi
1023 fi 1287 fi
1288
1289 einfo "Creating the mysql database and setting proper"
1290 einfo "permissions on it ..."
1024 1291
1025 local socket="${ROOT}/var/run/mysqld/mysqld${RANDOM}.sock" 1292 local socket="${ROOT}/var/run/mysqld/mysqld${RANDOM}.sock"
1026 local pidfile="${ROOT}/var/run/mysqld/mysqld${RANDOM}.pid" 1293 local pidfile="${ROOT}/var/run/mysqld/mysqld${RANDOM}.pid"
1027 local mysqld="${ROOT}/usr/sbin/mysqld \ 1294 local mysqld="${ROOT}/usr/sbin/mysqld \
1028 ${options} \ 1295 ${options} \
1029 --user=mysql \ 1296 --user=mysql \
1030 --skip-grant-tables \
1031 --basedir=${ROOT}/usr \ 1297 --basedir=${ROOT}/usr \
1032 --datadir=${ROOT}/${MY_DATADIR} \ 1298 --datadir=${ROOT}/${MY_DATADIR} \
1033 --skip-innodb \
1034 --skip-bdb \
1035 --skip-networking \
1036 --max_allowed_packet=8M \ 1299 --max_allowed_packet=8M \
1037 --net_buffer_length=16K \ 1300 --net_buffer_length=16K \
1301 --default-storage-engine=MyISAM \
1038 --socket=${socket} \ 1302 --socket=${socket} \
1039 --pid-file=${pidfile}" 1303 --pid-file=${pidfile}"
1304 #einfo "About to start mysqld: ${mysqld}"
1305 ebegin "Starting mysqld"
1040 ${mysqld} & 1306 ${mysqld} &
1307 rc=$?
1041 while ! [[ -S "${socket}" || "${maxtry}" -lt 1 ]] ; do 1308 while ! [[ -S "${socket}" || "${maxtry}" -lt 1 ]] ; do
1042 maxtry=$((${maxtry}-1)) 1309 maxtry=$((${maxtry}-1))
1043 echo -n "." 1310 echo -n "."
1044 sleep 1 1311 sleep 1
1045 done 1312 done
1313 eend $rc
1046 1314
1315 if ! [[ -S "${socket}" ]]; then
1316 die "Completely failed to start up mysqld with: ${mysqld}"
1317 fi
1318
1319 ebegin "Setting root password"
1047 # Do this from memory, as we don't want clear text passwords in temp files 1320 # Do this from memory, as we don't want clear text passwords in temp files
1048 local sql="UPDATE mysql.user SET Password = PASSWORD('${pwd1}') WHERE USER='root'" 1321 local sql="UPDATE mysql.user SET Password = PASSWORD('${MYSQL_ROOT_PASSWORD}') WHERE USER='root'"
1049 "${ROOT}/usr/bin/mysql" \ 1322 "${ROOT}/usr/bin/mysql" \
1050 --socket=${socket} \ 1323 --socket=${socket} \
1051 -hlocalhost \ 1324 -hlocalhost \
1052 -e "${sql}" 1325 -e "${sql}"
1326 eend $?
1053 1327
1054 einfo "Loading \"zoneinfo\", this step may require a few seconds ..." 1328 ebegin "Loading \"zoneinfo\", this step may require a few seconds ..."
1055
1056 "${ROOT}/usr/bin/mysql" \ 1329 "${ROOT}/usr/bin/mysql" \
1057 --socket=${socket} \ 1330 --socket=${socket} \
1058 -hlocalhost \ 1331 -hlocalhost \
1059 -uroot \ 1332 -uroot \
1060 -p"${pwd1}" \ 1333 -p"${MYSQL_ROOT_PASSWORD}" \
1061 mysql < "${sqltmp}" 1334 mysql < "${sqltmp}"
1335 rc=$?
1336 eend $?
1337 [ $rc -ne 0 ] && ewarn "Failed to load zoneinfo!"
1062 1338
1063 # Stop the server and cleanup 1339 # Stop the server and cleanup
1340 einfo "Stopping the server ..."
1064 kill $(< "${pidfile}" ) 1341 kill $(< "${pidfile}" )
1065 rm -f "${sqltmp}" 1342 rm -f "${sqltmp}"
1066 einfo "Stopping the server ..."
1067 wait %1 1343 wait %1
1068 einfo "Done" 1344 einfo "Done"
1069} 1345}
1070 1346
1071# @FUNCTION: mysql_pkg_postrm 1347# @FUNCTION: mysql_pkg_postrm

Legend:
Removed from v.1.123  
changed lines
  Added in v.1.145

  ViewVC Help
Powered by ViewVC 1.1.20