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

Diff of /eclass/mysql.eclass

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

Revision 1.136 Revision 1.142
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/mysql.eclass,v 1.136 2010/03/09 20:37:34 robbat2 Exp $ 3# $Header: /var/cvsroot/gentoo-x86/eclass/mysql.eclass,v 1.142 2010/03/24 20:37:54 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>
51 ;; 51 ;;
52 *) 52 *)
53 die "Unsupported EAPI: ${EAPI}" ;; 53 die "Unsupported EAPI: ${EAPI}" ;;
54esac 54esac
55 55
56
57# @ECLASS-VARIABLE: MYSQL_PV_MAJOR
58# @DESCRIPTION:
59# Upstream MySQL considers the first two parts of the version number to be the
60# major version. Upgrades that change major version should always run
61# mysql_upgrade.
62MYSQL_PV_MAJOR="$(get_version_component_range 1-2 ${PV})"
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]
60# This is an important part, because many of the choices the MySQL ebuild will do 68# This is an important part, because many of the choices the MySQL ebuild will do
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
112 >=sys-apps/sed-4 120 >=sys-apps/sed-4
113 >=sys-apps/texinfo-4.7-r1 121 >=sys-apps/texinfo-4.7-r1
114 >=sys-libs/readline-4.1 122 >=sys-libs/readline-4.1
115 >=sys-libs/zlib-1.2.3" 123 >=sys-libs/zlib-1.2.3"
116 124
125[[ "${PN}" == "mariadb" ]] \
126&& DEPEND="${DEPEND} libevent? ( >=dev-libs/libevent-1.4 )"
127
117# 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
118for i in "" "-community" ; do 129for i in "mysql" "mysql-community" "mariadb" ; do
119 [[ "${i}" == ${PN#mysql} ]] || 130 [[ "${i}" == ${PN} ]] ||
120 DEPEND="${DEPEND} !dev-db/mysql${i}" 131 DEPEND="${DEPEND} !dev-db/${i}"
121done 132done
122 133
123RDEPEND="${DEPEND} 134RDEPEND="${DEPEND}
124 !minimal? ( dev-db/mysql-init-scripts ) 135 !minimal? ( dev-db/mysql-init-scripts )
125 selinux? ( sec-policy/selinux-mysql )" 136 selinux? ( sec-policy/selinux-mysql )"
134 145
135# 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
136PDEPEND="perl? ( >=dev-perl/DBD-mysql-2.9004 )" 147PDEPEND="perl? ( >=dev-perl/DBD-mysql-2.9004 )"
137 148
138# For other stuff to bring us in 149# For other stuff to bring us in
139PDEPEND="${PDEPEND} =virtual/mysql-$(get_version_component_range 1-2 ${PV})" 150PDEPEND="${PDEPEND} =virtual/mysql-${MYSQL_PV_MAJOR}"
140 151
141# Work out the default SERVER_URI correctly 152# Work out the default SERVER_URI correctly
142if [ -z "${SERVER_URI}" ]; then 153if [ -z "${SERVER_URI}" ]; then
143 [ -z "${MY_PV}" ] && MY_PV="${PV//_/-}" 154 [ -z "${MY_PV}" ] && MY_PV="${PV//_/-}"
155 if [ "${PN}" == "mariadb" ]; then
156 MARIA_FULL_PV="$(replace_version_separator 3 '-' ${PV})"
157 SERVER_URI="http://launchpad.net/maria/${MYSQL_PV_MAJOR}/ongoing/+download/mariadb-${MARIA_FULL_PV}.tar.gz"
144 # The community build is on the mirrors 158 # The community build is on the mirrors
145 if [ "${MYSQL_COMMUNITY_FEATURES}" == "1" ]; then 159 elif [ "${MYSQL_COMMUNITY_FEATURES}" == "1" ]; then
146 SERVER_URI="mirror://mysql/Downloads/MySQL-${PV%.*}/mysql-${MY_PV}.tar.gz" 160 SERVER_URI="mirror://mysql/Downloads/MySQL-${PV%.*}/mysql-${MY_PV}.tar.gz"
147 # The (old) enterprise source is on the primary site only 161 # The (old) enterprise source is on the primary site only
148 elif [ "${PN}" == "mysql" ]; then 162 elif [ "${PN}" == "mysql" ]; then
149 SERVER_URI="ftp://ftp.mysql.com/pub/mysql/src/mysql-${MY_PV}.tar.gz" 163 SERVER_URI="ftp://ftp.mysql.com/pub/mysql/src/mysql-${MY_PV}.tar.gz"
150 fi 164 fi
160 http://g3nt8.org/patches/mysql-extras-${MY_EXTRAS_VER}.tar.bz2 174 http://g3nt8.org/patches/mysql-extras-${MY_EXTRAS_VER}.tar.bz2
161 http://dev.gentoo.org/~robbat2/distfiles/mysql-extras-${MY_EXTRAS_VER}.tar.bz2" 175 http://dev.gentoo.org/~robbat2/distfiles/mysql-extras-${MY_EXTRAS_VER}.tar.bz2"
162 176
163DESCRIPTION="A fast, multi-threaded, multi-user SQL database server." 177DESCRIPTION="A fast, multi-threaded, multi-user SQL database server."
164HOMEPAGE="http://www.mysql.com/" 178HOMEPAGE="http://www.mysql.com/"
179if [[ "${PN}" == "mariadb" ]]; then
180 HOMEPAGE="http://askmonty.org/"
181 DESCRIPTION="MariaDB is a MySQL fork with 3rd-party patches and additional storage engines merged."
182fi
183if [[ "${PN}" == "mysql-community" ]]; then
184 DESCRIPTION="${DESCRIPTION} (obsolete, move to dev-db/mysql)"
185fi
165LICENSE="GPL-2" 186LICENSE="GPL-2"
166SLOT="0" 187SLOT="0"
167IUSE="big-tables debug embedded minimal ${IUSE_DEFAULT_ON}perl selinux ssl static test" 188IUSE="big-tables debug embedded minimal ${IUSE_DEFAULT_ON}perl selinux ssl static test"
168 189
169mysql_version_is_at_least "4.1" \ 190mysql_version_is_at_least "4.1" \
182|| IUSE="${IUSE} berkdb" 203|| IUSE="${IUSE} berkdb"
183 204
184[ "${MYSQL_COMMUNITY_FEATURES}" == "1" ] \ 205[ "${MYSQL_COMMUNITY_FEATURES}" == "1" ] \
185&& IUSE="${IUSE} ${IUSE_DEFAULT_ON}community profiling" 206&& IUSE="${IUSE} ${IUSE_DEFAULT_ON}community profiling"
186 207
187# PBXT engine 208[[ "${PN}" == "mariadb" ]] \
209&& IUSE="${IUSE} libevent"
210
211# MariaDB has integrated PBXT
212# PBXT_VERSION means that we have a PBXT patch for this PV
213# PBXT was only introduced after 5.1.12
214pbxt_patch_available() {
215 [[ "${PN}" != "mariadb" ]] \
188mysql_version_is_at_least "5.1.12" \ 216 && mysql_version_is_at_least "5.1.12" \
189&& [[ -n "${PBXT_VERSION}" ]] \ 217 && [[ -n "${PBXT_VERSION}" ]]
218 return $?
219}
220
221pbxt_available() {
222 pbxt_patch_available || [[ "${PN}" == "mariadb" ]]
223 return $?
224}
225
226# Get the percona tarball if XTRADB_VER and PERCONA_VER are both set
227# MariaDB has integrated XtraDB
228# XTRADB_VERS means that we have a XTRADB patch for this PV
229# XTRADB was only introduced after 5.1.26
230xtradb_patch_available() {
231 [[ "${PN}" != "mariadb" ]] \
232 && mysql_version_is_at_least "5.1.26" \
233 && [[ -n "${XTRADB_VER}" && -n "${PERCONA_VER}" ]]
234 return $?
235}
236
237pbxt_patch_available \
190&& PBXT_P="pbxt-${PBXT_VERSION}" \ 238&& PBXT_P="pbxt-${PBXT_VERSION}" \
191&& PBXT_SRC_URI="http://www.primebase.org/download/${PBXT_P}.tar.gz mirror://sourceforge/pbxt/${PBXT_P}.tar.gz" \ 239&& PBXT_SRC_URI="http://www.primebase.org/download/${PBXT_P}.tar.gz mirror://sourceforge/pbxt/${PBXT_P}.tar.gz" \
192&& SRC_URI="${SRC_URI} pbxt? ( ${PBXT_SRC_URI} )" \ 240&& SRC_URI="${SRC_URI} pbxt? ( ${PBXT_SRC_URI} )" \
241
242pbxt_available \
193&& IUSE="${IUSE} pbxt" 243&& IUSE="${IUSE} pbxt"
194 244
195# Get the percona tarball if XTRADB_VER and PERCONA_VER are both set 245xtradb_patch_available \
196mysql_version_is_at_least "5.1.26" \
197&& [[ -n "${XTRADB_VER}" && -n "${PERCONA_VER}" ]] \
198&& XTRADB_P="percona-xtradb-${XTRADB_VER}" \ 246&& XTRADB_P="percona-xtradb-${XTRADB_VER}" \
199&& XTRADB_SRC_URI_COMMON="${PERCONA_VER}/source/${XTRADB_P}.tar.gz" \ 247&& XTRADB_SRC_URI_COMMON="${PERCONA_VER}/source/${XTRADB_P}.tar.gz" \
200&& XTRADB_SRC_URI1="http://www.percona.com/percona-builds/xtradb/${XTRADB_SRC_URI_COMMON}" \ 248&& XTRADB_SRC_URI1="http://www.percona.com/percona-builds/xtradb/${XTRADB_SRC_URI_COMMON}" \
201&& XTRADB_SRC_URI2="http://www.percona.com/${PN}/xtradb/${XTRADB_SRC_URI_COMMON}" \ 249&& XTRADB_SRC_URI2="http://www.percona.com/${PN}/xtradb/${XTRADB_SRC_URI_COMMON}" \
202&& SRC_URI="${SRC_URI} xtradb? ( ${XTRADB_SRC_URI1} ${XTRADB_SRC_URI2} )" \ 250&& SRC_URI="${SRC_URI} xtradb? ( ${XTRADB_SRC_URI1} ${XTRADB_SRC_URI2} )" \
488 fi 536 fi
489 fi 537 fi
490 538
491 # 5.1 introduces a new way to manage storage engines (plugins) 539 # 5.1 introduces a new way to manage storage engines (plugins)
492 # like configuration=none 540 # like configuration=none
541 # This base set are required, and will always be statically built.
493 local plugins="csv,myisam,myisammrg,heap" 542 local plugins="csv,myisam,myisammrg,heap"
494 if use extraengine ; then 543 if use extraengine ; then
495 # like configuration=max-no-ndb, archive and example removed in 5.1.11 544 # like configuration=max-no-ndb, archive and example removed in 5.1.11
496 # not added yet: ibmdb2i 545 # not added yet: ibmdb2i
497 # Not supporting as examples: example,daemon_example,ftexample 546 # Not supporting as examples: example,daemon_example,ftexample
498 plugins="${plugins},archive,blackhole,federated,partition" 547 plugins="${plugins},archive,blackhole,federated,partition"
499 548
549 if [[ "${PN}" != "mariadb" ]] ; then
500 elog "Before using the Federated storage engine, please be sure to read" 550 elog "Before using the Federated storage engine, please be sure to read"
501 elog "http://dev.mysql.com/doc/refman/5.1/en/federated-limitations.html" 551 elog "http://dev.mysql.com/doc/refman/5.1/en/federated-limitations.html"
552 else
553 elog "MariaDB includes the FederatedX engine. Be sure to read"
554 elog "http://askmonty.org/wiki/index.php/Manual:FederatedX_storage_engine"
555 fi
502 fi 556 fi
503 557
504 # Upstream specifically requests that InnoDB always be built: 558 # Upstream specifically requests that InnoDB always be built:
505 # - innobase, innodb_plugin 559 # - innobase, innodb_plugin
506 # Build falcon if available for 6.x series. 560 # Build falcon if available for 6.x series.
512 if use cluster ; then 566 if use cluster ; then
513 plugins="${plugins},ndbcluster" 567 plugins="${plugins},ndbcluster"
514 myconf="${myconf} --with-ndb-binlog" 568 myconf="${myconf} --with-ndb-binlog"
515 fi 569 fi
516 570
571 if [[ "${PN}" == "mariadb" ]] ; then
572 # In MariaDB, InnoDB is packaged in the xtradb directory, so it's not
573 # caught above.
574 plugins="${plugins},maria,innobase"
575 if use pbxt ; then
576 plugins="${plugins},pbxt"
577 else
578 myconf="${myconf} --without-plugin-pbxt"
579 fi
580 myconf="${myconf} $(use_with libevent)"
581 # This is not optional, without it several upstream testcases fail.
582 # Also strongly recommended by upstream.
583 myconf="${myconf} --with-maria-tmp-tables"
584 fi
585
517 myconf="${myconf} --with-plugins=${plugins}" 586 myconf="${myconf} --with-plugins=${plugins}"
518}
519
520xtradb_applicable() {
521 mysql_version_is_at_least "5.1.26" \
522 && [[ -n "${XTRADB_VER}" && -n "${PERCONA_VER}" ]] \
523 && use xtradb
524 return $?
525}
526
527pbxt_applicable() {
528 mysql_version_is_at_least "5.1.12" \
529 && [[ -n "${PBXT_VERSION}" ]] \
530 && use pbxt
531 return $?
532} 587}
533 588
534pbxt_src_configure() { 589pbxt_src_configure() {
535 mysql_init_vars 590 mysql_init_vars
536 591
538 593
539 einfo "Reconfiguring dir '${PWD}'" 594 einfo "Reconfiguring dir '${PWD}'"
540 AT_GNUCONF_UPDATE="yes" eautoreconf 595 AT_GNUCONF_UPDATE="yes" eautoreconf
541 596
542 local myconf="" 597 local myconf=""
543 myconf="${myconf} --with-mysql=${S} --libdir=${MY_LIBDIR}" 598 myconf="${myconf} --with-mysql=${S} --libdir=/usr/$(get_libdir)"
544 use debug && myconf="${myconf} --with-debug=full" 599 use debug && myconf="${myconf} --with-debug=full"
545 # TODO: is it safe/needed to use econf here ?
546 ./configure ${myconf} || die "Problem configuring PBXT storage engine" 600 econf ${myconf} || die "Problem configuring PBXT storage engine"
547} 601}
548 602
549pbxt_src_compile() { 603pbxt_src_compile() {
550 # Be backwards compatible for now 604 # Be backwards compatible for now
551 if [[ $EAPI != 2 ]]; then 605 if [[ $EAPI != 2 ]]; then
691 rm -f "scripts/mysqlbug" 745 rm -f "scripts/mysqlbug"
692 fi 746 fi
693 747
694 local rebuilddirlist d 748 local rebuilddirlist d
695 749
696 if xtradb_applicable ; then 750 if xtradb_patch_available && use xtradb ; then
697 einfo "Replacing InnoDB with Percona XtraDB" 751 einfo "Replacing InnoDB with Percona XtraDB"
698 pushd "${S}"/storage 752 pushd "${S}"/storage
699 i="innobase" 753 i="innobase"
700 o="${WORKDIR}/storage-${i}.mysql-upstream" 754 o="${WORKDIR}/storage-${i}.mysql-upstream"
701 # Have we been here already? 755 # Have we been here already?
806 find . -type f -name Makefile -print0 \ 860 find . -type f -name Makefile -print0 \
807 | xargs -0 -n100 sed -i \ 861 | xargs -0 -n100 sed -i \
808 -e 's|^pkglibdir *= *$(libdir)/mysql|pkglibdir = $(libdir)|;s|^pkgincludedir *= *$(includedir)/mysql|pkgincludedir = $(includedir)|' 862 -e 's|^pkglibdir *= *$(libdir)/mysql|pkglibdir = $(libdir)|;s|^pkgincludedir *= *$(includedir)/mysql|pkgincludedir = $(includedir)|'
809 863
810 if [[ $EAPI == 2 ]]; then 864 if [[ $EAPI == 2 ]]; then
811 pbxt_applicable && pbxt_src_configure 865 pbxt_patch_available && use pbxt && pbxt_src_configure
812 fi 866 fi
813} 867}
814 868
815# @FUNCTION: mysql_src_compile 869# @FUNCTION: mysql_src_compile
816# @DESCRIPTION: 870# @DESCRIPTION:
817# Compile the mysql code. 871# Compile the mysql code.
818mysql_src_compile() { 872mysql_src_compile() {
819 # Be backwards compatible for now 873 # Be backwards compatible for now
820 case ${EAPI:-0} in 874 case ${EAPI:-0} in
821 2) : ;; 875 2) : ;;
822 0 | 1) mysql_src_configure ;; 876 0 | 1) mysql_src_configure ;;
823 esac 877 esac
824 878
825 emake || die "emake failed" 879 emake || die "emake failed"
826 880
827 pbxt_applicable && pbxt_src_compile 881 pbxt_patch_available && use pbxt && pbxt_src_compile
828} 882}
829 883
830# @FUNCTION: mysql_src_install 884# @FUNCTION: mysql_src_install
831# @DESCRIPTION: 885# @DESCRIPTION:
832# Install mysql. 886# Install mysql.
838 DESTDIR="${D}" \ 892 DESTDIR="${D}" \
839 benchdir_root="${MY_SHAREDSTATEDIR}" \ 893 benchdir_root="${MY_SHAREDSTATEDIR}" \
840 testroot="${MY_SHAREDSTATEDIR}" \ 894 testroot="${MY_SHAREDSTATEDIR}" \
841 || die "emake install failed" 895 || die "emake install failed"
842 896
843 pbxt_applicable && pbxt_src_install 897 pbxt_patch_available && use pbxt && pbxt_src_install
844 898
845 # Convenience links 899 # Convenience links
846 einfo "Making Convenience links for mysqlcheck multi-call binary" 900 einfo "Making Convenience links for mysqlcheck multi-call binary"
847 dosym "/usr/bin/mysqlcheck" "/usr/bin/mysqlanalyze" 901 dosym "/usr/bin/mysqlcheck" "/usr/bin/mysqlanalyze"
848 dosym "/usr/bin/mysqlcheck" "/usr/bin/mysqlrepair" 902 dosym "/usr/bin/mysqlcheck" "/usr/bin/mysqlrepair"
872 if use !test ; then 926 if use !test ; then
873 rm -rf "${D}"/${MY_SHAREDSTATEDIR}/mysql-test 927 rm -rf "${D}"/${MY_SHAREDSTATEDIR}/mysql-test
874 fi 928 fi
875 929
876 # Configuration stuff 930 # Configuration stuff
931 if mysql_version_is_at_least "5.1" ; then
932 mysql_mycnf_version="5.1"
877 if mysql_version_is_at_least "4.1" ; then 933 elif mysql_version_is_at_least "4.1" ; then
878 mysql_mycnf_version="4.1" 934 mysql_mycnf_version="4.1"
879 else 935 else
880 mysql_mycnf_version="4.0" 936 mysql_mycnf_version="4.0"
881 fi 937 fi
882 einfo "Building default my.cnf" 938 einfo "Building default my.cnf"
884 doins scripts/mysqlaccess.conf 940 doins scripts/mysqlaccess.conf
885 sed -e "s!@DATADIR@!${MY_DATADIR}!g" \ 941 sed -e "s!@DATADIR@!${MY_DATADIR}!g" \
886 "${FILESDIR}/my.cnf-${mysql_mycnf_version}" \ 942 "${FILESDIR}/my.cnf-${mysql_mycnf_version}" \
887 > "${TMPDIR}/my.cnf.ok" 943 > "${TMPDIR}/my.cnf.ok"
888 if mysql_version_is_at_least "4.1" && use latin1 ; then 944 if mysql_version_is_at_least "4.1" && use latin1 ; then
889 sed -e "s|utf8|latin1|g" -i "${TMPDIR}/my.cnf.ok" 945 sed -i \
946 -e "/character-set/s|utf8|latin1|g" \
947 "${TMPDIR}/my.cnf.ok"
890 fi 948 fi
891 newins "${TMPDIR}/my.cnf.ok" my.cnf 949 newins "${TMPDIR}/my.cnf.ok" my.cnf
892 950
893 # Minimal builds don't have the MySQL server 951 # Minimal builds don't have the MySQL server
894 if ! use minimal ; then 952 if ! use minimal ; then
970 for script in \ 1028 for script in \
971 support-files/my-*.cnf \ 1029 support-files/my-*.cnf \
972 support-files/magic \ 1030 support-files/magic \
973 support-files/ndb-config-2-node.ini 1031 support-files/ndb-config-2-node.ini
974 do 1032 do
1033 [[ -f "${script}" ]] \
975 dodoc "${script}" 1034 && dodoc "${script}"
976 done 1035 done
977 1036
978 docinto "scripts" 1037 docinto "scripts"
979 for script in scripts/mysql* ; do 1038 for script in scripts/mysql* ; do
1039 [[ -f "${script}" ]] \
980 [[ "${script%.sh}" == "${script}" ]] && dodoc "${script}" 1040 && [[ "${script%.sh}" == "${script}" ]] \
1041 && dodoc "${script}"
981 done 1042 done
982 1043
983 einfo 1044 einfo
984 elog "You might want to run:" 1045 elog "You might want to run:"
985 elog "\"emerge --config =${CATEGORY}/${PF}\"" 1046 elog "\"emerge --config =${CATEGORY}/${PF}\""
986 elog "if this is a new install." 1047 elog "if this is a new install."
987 einfo 1048 einfo
988 fi 1049 fi
989 1050
990 if pbxt_applicable ; then 1051 if pbxt_available && use pbxt ; then
991 # TODO: explain it better 1052 # TODO: explain it better
992 elog " mysql> INSTALL PLUGIN pbxt SONAME 'libpbxt.so';" 1053 elog " mysql> INSTALL PLUGIN pbxt SONAME 'libpbxt.so';"
993 elog " mysql> CREATE TABLE t1 (c1 int, c2 text) ENGINE=pbxt;" 1054 elog " mysql> CREATE TABLE t1 (c1 int, c2 text) ENGINE=pbxt;"
994 elog "if, after that, you cannot start the MySQL server," 1055 elog "if, after that, you cannot start the MySQL server,"
995 elog "remove the ${MY_DATADIR}/mysql/plugin.* files, then" 1056 elog "remove the ${MY_DATADIR}/mysql/plugin.* files, then"
1046 fi 1107 fi
1047 fi 1108 fi
1048 1109
1049 local pwd1="a" 1110 local pwd1="a"
1050 local pwd2="b" 1111 local pwd2="b"
1112 local MYSQL_ROOT_PASSWORD=''
1051 local maxtry=5 1113 local maxtry=15
1114
1115 if [ -z "${MYSQL_ROOT_PASSWORD}" -a -f "${ROOT}/root/.my.cnf" ]; then
1116 MYSQL_ROOT_PASSWORD="$(sed -n -e '/^password=/s,^password=,,gp' "${ROOT}/root/.my.cnf")"
1117 fi
1052 1118
1053 if [[ -d "${ROOT}/${MY_DATADIR}/mysql" ]] ; then 1119 if [[ -d "${ROOT}/${MY_DATADIR}/mysql" ]] ; then
1054 ewarn "You have already a MySQL database in place." 1120 ewarn "You have already a MySQL database in place."
1055 ewarn "(${ROOT}/${MY_DATADIR}/*)" 1121 ewarn "(${ROOT}/${MY_DATADIR}/*)"
1056 ewarn "Please rename or delete it if you wish to replace it." 1122 ewarn "Please rename or delete it if you wish to replace it."
1059 1125
1060 # Bug #213475 - MySQL _will_ object strenously if your machine is named 1126 # Bug #213475 - MySQL _will_ object strenously if your machine is named
1061 # localhost. Also causes weird failures. 1127 # localhost. Also causes weird failures.
1062 [[ "${HOSTNAME}" == "localhost" ]] && die "Your machine must NOT be named localhost" 1128 [[ "${HOSTNAME}" == "localhost" ]] && die "Your machine must NOT be named localhost"
1063 1129
1064 einfo "Creating the mysql database and setting proper" 1130 if [ -z "${MYSQL_ROOT_PASSWORD}" ]; then
1065 einfo "permissions on it ..."
1066 1131
1067 einfo "Insert a password for the mysql 'root' user" 1132 einfo "Please provide a password for the mysql 'root' user now,"
1133 einfo "or in the MYSQL_ROOT_PASSWORD env var."
1068 ewarn "Avoid [\"'\\_%] characters in the password" 1134 ewarn "Avoid [\"'\\_%] characters in the password"
1069 read -rsp " >" pwd1 ; echo 1135 read -rsp " >" pwd1 ; echo
1070 1136
1071 einfo "Retype the password" 1137 einfo "Retype the password"
1072 read -rsp " >" pwd2 ; echo 1138 read -rsp " >" pwd2 ; echo
1073 1139
1074 if [[ "x$pwd1" != "x$pwd2" ]] ; then 1140 if [[ "x$pwd1" != "x$pwd2" ]] ; then
1075 die "Passwords are not the same" 1141 die "Passwords are not the same"
1142 fi
1143 MYSQL_ROOT_PASSWORD="${pwd1}"
1144 unset pwd1 pwd2
1076 fi 1145 fi
1077 1146
1078 local options="" 1147 local options=""
1079 local sqltmp="$(emktemp)" 1148 local sqltmp="$(emktemp)"
1080 1149
1094 [[ -f "${ROOT}/${MY_DATADIR}/mysql/user.frm" ]] \ 1163 [[ -f "${ROOT}/${MY_DATADIR}/mysql/user.frm" ]] \
1095 || die "MySQL databases not installed" 1164 || die "MySQL databases not installed"
1096 chown -R mysql:mysql "${ROOT}/${MY_DATADIR}" 2>/dev/null 1165 chown -R mysql:mysql "${ROOT}/${MY_DATADIR}" 2>/dev/null
1097 chmod 0750 "${ROOT}/${MY_DATADIR}" 2>/dev/null 1166 chmod 0750 "${ROOT}/${MY_DATADIR}" 2>/dev/null
1098 1167
1168 # Figure out which options we need to disable to do the setup
1169 helpfile="${TMPDIR}/mysqld-help"
1170 ${ROOT}/usr/sbin/mysqld --verbose --help >"${helpfile}" 2>/dev/null
1171 for opt in grant-tables host-cache name-resolve networking slave-start bdb \
1172 federated innodb ssl log-bin relay-log slow-query-log external-locking \
1173 ; do
1174 optexp="--(skip-)?${opt}" optfull="--skip-${opt}"
1175 egrep -sq -- "${optexp}" "${helpfile}" && options="${options} ${optfull}"
1176 done
1177 # But some options changed names
1178 egrep -sq external-locking "${helpfile}" && \
1179 options="${options/skip-locking/skip-external-locking}"
1180
1099 if mysql_version_is_at_least "4.1.3" ; then 1181 if mysql_version_is_at_least "4.1.3" ; then
1100 options="--skip-ndbcluster"
1101
1102 # Filling timezones, see 1182 # Filling timezones, see
1103 # http://dev.mysql.com/doc/mysql/en/time-zone-support.html 1183 # http://dev.mysql.com/doc/mysql/en/time-zone-support.html
1104 "${ROOT}/usr/bin/mysql_tzinfo_to_sql" "${ROOT}/usr/share/zoneinfo" > "${sqltmp}" 2>/dev/null 1184 "${ROOT}/usr/bin/mysql_tzinfo_to_sql" "${ROOT}/usr/share/zoneinfo" > "${sqltmp}" 2>/dev/null
1105 1185
1106 if [[ -r "${help_tables}" ]] ; then 1186 if [[ -r "${help_tables}" ]] ; then
1107 cat "${help_tables}" >> "${sqltmp}" 1187 cat "${help_tables}" >> "${sqltmp}"
1108 fi 1188 fi
1109 fi 1189 fi
1190
1191 einfo "Creating the mysql database and setting proper"
1192 einfo "permissions on it ..."
1110 1193
1111 local socket="${ROOT}/var/run/mysqld/mysqld${RANDOM}.sock" 1194 local socket="${ROOT}/var/run/mysqld/mysqld${RANDOM}.sock"
1112 local pidfile="${ROOT}/var/run/mysqld/mysqld${RANDOM}.pid" 1195 local pidfile="${ROOT}/var/run/mysqld/mysqld${RANDOM}.pid"
1113 local mysqld="${ROOT}/usr/sbin/mysqld \ 1196 local mysqld="${ROOT}/usr/sbin/mysqld \
1114 ${options} \ 1197 ${options} \
1115 --user=mysql \ 1198 --user=mysql \
1116 --skip-grant-tables \
1117 --basedir=${ROOT}/usr \ 1199 --basedir=${ROOT}/usr \
1118 --datadir=${ROOT}/${MY_DATADIR} \ 1200 --datadir=${ROOT}/${MY_DATADIR} \
1119 --skip-innodb \
1120 --skip-bdb \
1121 --skip-networking \
1122 --max_allowed_packet=8M \ 1201 --max_allowed_packet=8M \
1123 --net_buffer_length=16K \ 1202 --net_buffer_length=16K \
1124 --socket=${socket} \ 1203 --socket=${socket} \
1125 --pid-file=${pidfile}" 1204 --pid-file=${pidfile}"
1205 #einfo "About to start mysqld: ${mysqld}"
1206 ebegin "Starting mysqld"
1126 ${mysqld} & 1207 ${mysqld} &
1208 rc=$?
1127 while ! [[ -S "${socket}" || "${maxtry}" -lt 1 ]] ; do 1209 while ! [[ -S "${socket}" || "${maxtry}" -lt 1 ]] ; do
1128 maxtry=$((${maxtry}-1)) 1210 maxtry=$((${maxtry}-1))
1129 echo -n "." 1211 echo -n "."
1130 sleep 1 1212 sleep 1
1131 done 1213 done
1214 eend $rc
1132 1215
1216 if ! [[ -S "${socket}" ]]; then
1217 die "Completely failed to start up mysqld with: ${mysqld}"
1218 fi
1219
1220 ebegin "Setting root password"
1133 # Do this from memory, as we don't want clear text passwords in temp files 1221 # Do this from memory, as we don't want clear text passwords in temp files
1134 local sql="UPDATE mysql.user SET Password = PASSWORD('${pwd1}') WHERE USER='root'" 1222 local sql="UPDATE mysql.user SET Password = PASSWORD('${MYSQL_ROOT_PASSWORD}') WHERE USER='root'"
1135 "${ROOT}/usr/bin/mysql" \ 1223 "${ROOT}/usr/bin/mysql" \
1136 --socket=${socket} \ 1224 --socket=${socket} \
1137 -hlocalhost \ 1225 -hlocalhost \
1138 -e "${sql}" 1226 -e "${sql}"
1227 eend $?
1139 1228
1140 einfo "Loading \"zoneinfo\", this step may require a few seconds ..." 1229 ebegin "Loading \"zoneinfo\", this step may require a few seconds ..."
1141
1142 "${ROOT}/usr/bin/mysql" \ 1230 "${ROOT}/usr/bin/mysql" \
1143 --socket=${socket} \ 1231 --socket=${socket} \
1144 -hlocalhost \ 1232 -hlocalhost \
1145 -uroot \ 1233 -uroot \
1146 -p"${pwd1}" \ 1234 -p"${MYSQL_ROOT_PASSWORD}" \
1147 mysql < "${sqltmp}" 1235 mysql < "${sqltmp}"
1236 rc=$?
1237 eend $?
1238 [ $rc -ne 0 ] && ewarn "Failed to load zoneinfo!"
1148 1239
1149 # Stop the server and cleanup 1240 # Stop the server and cleanup
1241 einfo "Stopping the server ..."
1150 kill $(< "${pidfile}" ) 1242 kill $(< "${pidfile}" )
1151 rm -f "${sqltmp}" 1243 rm -f "${sqltmp}"
1152 einfo "Stopping the server ..."
1153 wait %1 1244 wait %1
1154 einfo "Done" 1245 einfo "Done"
1155} 1246}
1156 1247
1157# @FUNCTION: mysql_pkg_postrm 1248# @FUNCTION: mysql_pkg_postrm

Legend:
Removed from v.1.136  
changed lines
  Added in v.1.142

  ViewVC Help
Powered by ViewVC 1.1.20