When installing dev-db/mysql, the ebuild (through the mysql.eclass) suggests to use an environment variable called MYSQL_ROOT_PASSWORD if the user does not want to provide the MySQL root password interactively. However, this fails. Most likely, this is due to the fact that right before the check (in mysql.eclass) it defines MYSQL_ROOT_PASSWORD as a local variable, thus ignoring whatever environment variable that has been set. Instead, a valid way to do so would be to create /root/.my.cnf with "password=abc123" in it as the eclass parses this file if it exists. Reproducible: Always Steps to Reproduce: 1. emerge dev-db/mysql 2. export MYSQL_ROOT_PASSWORD="ofcourse" 3. emerge --config dev-db/mysql Actual Results: You will notice that it ignores the fact that MYSQL_ROOT_PASSWORD is set and asks for the root password. Expected Results: It should either accept that MYSQL_ROOT_PASSWORD was set, or not tell the user that this is a possibility (perhaps rather inform the user about the /root/.my.sql file?) ~# emerge --info Portage 2.1.9.25 (selinux/v2refpolicy/amd64/hardened, gcc-4.4.4, glibc-2.11.2-r3, 2.6.36-hardened-r9 x86_64) ================================================================= System uname: Linux-2.6.36-hardened-r9-x86_64-Intel-R-_Core-TM-_i5_CPU_M_430_@_2.27GHz-with-gentoo-1.12.14 Timestamp of tree: Thu, 24 Feb 2011 16:00:01 +0000 app-shells/bash: 4.1_p9 dev-java/java-config: 2.1.11-r3 dev-lang/python: 2.6.6-r1, 3.1.2-r4 dev-util/cmake: 2.8.1-r2 sys-apps/baselayout: 1.12.14-r1 sys-apps/sandbox: 2.4 sys-devel/autoconf: 2.65-r1 sys-devel/automake: 1.10.3, 1.11.1 sys-devel/binutils: 2.20.1-r1 sys-devel/gcc: 4.4.4-r2 sys-devel/gcc-config: 1.4.1 sys-devel/libtool: 2.2.10 sys-devel/make: 3.81-r2 virtual/os-headers: 2.6.36.1 (sys-kernel/linux-headers) ACCEPT_KEYWORDS="amd64" ACCEPT_LICENSE="* -@EULA Broadcom skype-eula AdobeFlash-10.1" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-march=core2 -O2 -pipe" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/config /usr/share/gnupg/qualified.txt /var/lib/hsqldb" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c" CXXFLAGS="-march=core2 -O2 -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="assume-digests binpkg-logs distlocks fixlafiles fixpackages news parallel-fetch protect-owned sandbox selinux sesandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch" GENTOO_MIRRORS="http://distfiles.gentoo.org" LDFLAGS="-Wl,-O1 -Wl,--as-needed" LINGUAS="en nl fr" MAKEOPTS="-j4" PKGDIR="/usr/portage/packages" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/home/swift/Development/Centralized/gentoo.overlay /home/swift/Development/Centralized/hardened-dev" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="X amd64 berkdb cairo cli cracklib crypt cxx dbus dri dvd dynamic fortran gnutls gpg graphviz gtk hardened iconv imap jpeg modules mp3 mudflap ncurses nls openmp pam pcre perl pic png policykit pppd python qemu qt3support readline sasl selinux session smime smtp ssl tcpd udev unicode v4l2 vde xorg xv zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache cgi cgid dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" CAMERAS="ptp2" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="evdev keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en nl fr" PHP_TARGETS="php5-3" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="nv nouveau" XFCE_PLUGINS="menu" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_ALL, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
I've added a patch to the eclass in the mysql overlay[1] to address this issue. Please test the mysql ebuilds in the overlay. [1] - http://git.overlays.gentoo.org/gitweb/?p=proj/mysql.git
Thanks. Both existing MySQL ebuilds in the main portage tree (fex. 5.1.50-r1) as well as those ebuilds in the MySQL overlay (fex. 5.1.53-r1) work with the new mysql.eclass. I did notice though that the mysql-v2.eclass didn't contain your fix.
(In reply to comment #2) > Thanks. > > Both existing MySQL ebuilds in the main portage tree (fex. 5.1.50-r1) as well > as those ebuilds in the MySQL overlay (fex. 5.1.53-r1) work with the new > mysql.eclass. > > I did notice though that the mysql-v2.eclass didn't contain your fix. Sven, thanks for testing this. I mixed some work before and after creating a local branch for testing mysql-5.5 and lost track of fixes. I'm going to update mysql-v2 asap to include this fix.
Fixed on mysql-v2 now.
Applied in the tree eclass.
