Bug 129558 – Error in SQL Privileges statement in the pkg_config section of joomla-1.0.8.ebuild.

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description Karl Dag Gursli 2006-04-10 22:23:50 UTC]

Portage 2.0.54 (default-linux/x86/2005.1, gcc-3.3.6, glibc-2.3.5-r2, 2.6.14-gentoo-r2-ementorlab i686)
=================================================================
System uname: 2.6.14-gentoo-r2-ementorlab i686 Pentium III (Coppermine)
Gentoo Base System version 1.6.13
dev-lang/python:     2.3.5, 2.4.2
sys-apps/sandbox:    1.2.12
sys-devel/autoconf:  2.13, 2.59-r6
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r1
sys-devel/binutils:  2.15.92.0.2-r10
sys-devel/libtool:   1.5.20
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=pentium3 -fomit-frame-pointer -pipe -ffast-math"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3.4/env /usr/kde/3.4/share/config /usr/kde/3.4/shutdown /usr/kde/3/share/config /usr/lib/X11/xkb /usr/lib/mozilla/defaults/pref /usr/share/config /var/qmail/control"
CONFIG_PROTECT_MASK="/etc/eselect/compiler /etc/gconf /etc/terminfo /etc/env.d"
CXXFLAGS="-O2 -march=pentium3 -fomit-frame-pointer -pipe -ffast-math"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks sandbox sfperms strict"
GENTOO_MIRRORS="http://ftp.belnet.be/mirror/rsync.gentoo.org/gentoo/ http://mirror.uni-c.dk/pub/gentoo/ http://trumpetti.atm.tut.fi/gentoo/ http://mirror.gentoo.no/"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://172.16.101.1/gentoo-portage"
USE="x86 X alsa apache apache2 apm arts audiofile automount avi berkdb bitmap-fonts bootsplash bzip2 cddb cgi cli commercial cpudetection crypt cups dbi dbus dga dio dri dv dvb eds emboss encode esd exif expat fam fat ffmpeg foomaticdb fortran fping freetds freetype gd gdbm gif glut gnome gpm gstreamer gtk gtk2 gtkhtml imap imlib ipcs ipv6 isdnlog jpeg kde lcms ldap libg++ libwww logrotate logwatch ltsp mad mdb mhash mikmod mng modperl motif mozilla mp3 mpeg mpeg2 mpeg4 mplayer mpm-worker msn mssql mysql mysqli mythtv nagios-dns nagios-game nagios-ntp nagios-ping nagios-ssh ncurses netboot network nfs nis nls ntlm odbc ogg oggvorbis opengl oss pam pcre pdflib perl php png postfix pppd pvm python qt quicktime radius rar rdesktop readline reiserfs rrdtool samba sasl sdl snmp spell ssl sysfs sysvipc tcltk tcpd threads tiff truetype truetype-fonts type1-fonts udev vhosts vnc vorbis winbind xfs xml xmldoclet xmlreader xmlrpc xmlwriter xmms xosd xscreensaver xsl xslt xtended xv zlib userland_GNU kernel_linux elibc_glibc"
Unset:  ASFLAGS, CTARGET, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTDIR_OVERLAY

[Comment 1 Karl Dag Gursli 2006-04-10 22:31:48 UTC]

I think it is in this section. Mainly the `${MY_DB}`.* frase.

mysql -u "${adminuser}" "${host:+-h ${host}}" -p \
        -e "GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,DROP,REFERENCES
        ON `${MY_DB}`.* TO '${MY_USER}'@'${clientaddr}' IDENTIFIED BY '${mypwd}'; FLUSH PRIVILEGES;"  || die "Error initializing database. Please grant permissions manually.

[Comment 2 Rick Harris 2006-04-20 00:28:21 UTC]

Created attachment 85001 [details]
Ebuild patch to fix `emerge --config =joomla-1.0.8`

[Comment 3 Renat Lumpau (RETIRED) 2006-04-24 08:24:07 UTC]

I was actually going to remove the SQL snippet altogether: imo, basic db management is a critical skill.

[Comment 4 Renat Lumpau (RETIRED) 2006-04-29 15:20:19 UTC]

Removed SQL snippets and pkg_config from mambo and joomla.