Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 80996 - www-apps/bugzilla-2.18.0_rc4 bugs user needs LOCK TABLES privilege to its database
Summary: www-apps/bugzilla-2.18.0_rc4 bugs user needs LOCK TABLES privilege to its dat...
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: High major (vote)
Assignee: Gentoo Web Application Packages Maintainers
URL: http://bugs.gentoo.org/show_bug.cgi?i...
Whiteboard:
Keywords:
: 92647 (view as bug list)
Depends on:
Blocks:
 
Reported: 2005-02-06 08:58 UTC by Jakub Moc (RETIRED)
Modified: 2005-06-26 14:25 UTC (History)
2 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
patch for /files/2.18.0_rc4/reconfig (reconfig.patch,1.30 KB, patch)
2005-03-22 06:42 UTC, Jakub Moc (RETIRED)
Details | Diff
updated reconfig script to account for mysql-4*, and the extra privs required (reconfig,3.61 KB, text/plain)
2005-05-15 09:10 UTC, Elfyn McBratney (beu) (RETIRED)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jakub Moc (RETIRED) gentoo-dev 2005-02-06 08:58:58 UTC
Already mentioned here in Bug 15031 over one year ago, yet this is not fixed. When creating the bugzilla DB its user is NOT granted LOCK TABLES privilege and subsequent setup fails. After some googling I found the problem cause at http://www.matthewsmith.id.au/mediawiki/index.php/Gentoo and after granting LOCK TABLES everything is OK. 

Reproducible: Always
Steps to Reproduce:
1. emerge =www-apps/bugzilla-2.18.0_rc4
2. set localconfig
3. run ./checksetup.pl

Actual Results:  
Populating duplicates table...
Migrating old chart data into database ...
DBD::mysql::db do failed: Access denied for user: 'bugs@localhost' to database
'bugzilla' at Bugzilla/Series.pm line 173
        Bugzilla::Series::writeToDatabase('Bugzilla::Series=HASH(0x92860d0)')
called at ./checksetup.pl line 3876

Expected Results:  
Complete ./checksetup.pl successufully!

Portage 2.0.51-r15 (default-linux/x86/2004.3, gcc-3.3.5,
glibc-2.3.4.20040808-r1, 2.6.9-gentoo-r13 i686)
=================================================================
System uname: 2.6.9-gentoo-r13 i686 AMD Athlon(tm) XP 2200+
Gentoo Base System version 1.6.7
Python:              dev-lang/python-2.3.4 [2.3.4 (#1, Oct 17 2004, 02:15:56)]
dev-lang/python:     2.3.4
sys-devel/autoconf:  2.59-r6, 2.13
sys-devel/automake:  1.7.9-r1, 1.8.5-r3, 1.5, 1.4_p6, 1.6.3, 1.9.4
sys-devel/binutils:  2.15.92.0.2-r1
sys-devel/libtool:   1.5.10-r4
virtual/os-headers:  2.6.8.1-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CFLAGS="-O3 -march=athlon-xp -pipe -fomit-frame-pointer"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /opt/glftpd/etc /usr/kde/2/share/config
/usr/kde/3/share/config /usr/share/config /var/bind /var/qmail/control"
CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d"
CXXFLAGS="-O3 -march=athlon-xp -pipe -fomit-frame-pointer"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoaddcvs autoconfig ccache collision-protect distlocks makecheck
sandbox sfperms"
GENTOO_MIRRORS="http://distfiles.gentoo.org
http://distro.ibiblio.org/pub/Linux/distributions/gentoo"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="x86 3dnow acpi apache2 apm arts avi berkdb bitmap-fonts crypt encode f77
fbcon firebird font-server foomaticdb fortran gd gd-external gdbm gif gpm gtk2
imap imlib innodb java jpeg junit libg++ libwww mad maildir mikmod mmx motif
mpeg mysql ncurses nls nptl odbc oggvorbis opengl oss pam pdflib perl png pnp
postgres python quicktime readline sasl sdl slang snmp socks5 spell sqlite sse
ssl svga tcpd tiff truetype truetype-fonts type1-fonts unicode xml xml2 xmms xv
zlib"
Unset:  ASFLAGS, CBUILD, CTARGET, LANG, LC_ALL, LDFLAGS
Comment 1 Jakub Moc (RETIRED) gentoo-dev 2005-03-22 06:42:58 UTC
Created attachment 54152 [details, diff]
patch for /files/2.18.0_rc4/reconfig

Added patch to fix the bug
Comment 2 Maurice van der Pot (RETIRED) gentoo-dev 2005-04-15 14:14:42 UTC
Only for mysql 4 and it is not just LOCK TABLES:
http://www.bugzilla.org/docs/2.18/html/configuration.html#install-setupdatabase-adduser

Comment 3 Elfyn McBratney (beu) (RETIRED) gentoo-dev 2005-05-14 17:35:59 UTC
*** Bug 92647 has been marked as a duplicate of this bug. ***
Comment 4 Elfyn McBratney (beu) (RETIRED) gentoo-dev 2005-05-15 09:10:49 UTC
Created attachment 58957 [details]
updated reconfig script to account for mysql-4*, and the extra privs required
Comment 5 Renat Lumpau (RETIRED) gentoo-dev 2005-06-26 14:25:00 UTC
2.18.1-r1 in CVS, please test