Bug 92647

Summary:	wrong mysql grants for www-apps/bugzilla-2.18.1
Product:	Gentoo Linux	Reporter:	Daniel Mettler <mettlerd>
Component:	[OLD] Server	Assignee:	Gentoo Web Application Packages Maintainers <web-apps>
Status:	RESOLVED DUPLICATE
Severity:	blocker
Priority:	High
Version:	unspecified
Hardware:	All
OS:	All
URL:	http://www.bugzilla.org/docs/2.18/html/configuration.html
Whiteboard:
Package list:		Runtime testing required:	---

Description Daniel Mettler 2005-05-14 16:22:11 UTC

the mysql grants in files/2.18.0_rc4/reconfig are correct for mysql 3, but wrong for mysql 4. mysql 4 requires the following additional permissions:

LOCK TABLES, CREATE TEMPORARY TABLES

according to http://www.bugzilla.org/docs/2.18/html/configuration.html, section 2.2.2.4

if these permissions are lacking, ./checksetup.pl fails for systems using mysql 4, resulting in a not working bugzilla installation:

DBD::mysql::db do failed: Access denied for user: 'bugs@localhost' to database 'bugs' at Bugzilla/Series.pm line 173
        Bugzilla::Series::writeToDatabase('Bugzilla::Series=HASH(myhash)') called at ./checksetup.pl line 3976

(thx to wicked from #mozwebtools for the hint)

Comment 1 Elfyn McBratney (beu) (RETIRED) gentoo-dev

2005-05-14 16:25:34 UTC

The following webapp-config 'reconfig' scripts need updating to reflect this:
files/2.18.0_rc1/reconfig
files/2.18.0_rc2/reconfig
files/2.18.0_rc3/reconfig
files/2.18.0_rc4/reconfig

Dunno what's best - work with both 3.x and 4.x (by checking the installed version of mysql in the scripts, or just depend on >=mysql-4 (as kloeri noted on irc, it has been stable for 6 months).  Thoughts ?

Comment 2 Daniel Mettler 2005-05-14 16:40:04 UTC

fyi: i just verified that with these fixes, bugzilla installs nicely :)
(on my mysql 4 box)

Comment 3 Jakub Moc (RETIRED) gentoo-dev

2005-05-14 16:47:55 UTC

I don

Comment 4 Jakub Moc (RETIRED) gentoo-dev

2005-05-14 16:47:55 UTC

I don´t actually care if this depends on 4.x only but the bug has been there for almost two years, so it´s about time to fix this one... 

http://bugs.gentoo.org/show_bug.cgi?id=15031#c22
http://bugs.gentoo.org/show_bug.cgi?id=80996

I´d just like to note that I never had a problem with missing CREATE TEMPORARY TABLES though, but maybe that´s just b/c I don´t use the features that require this.

Comment 5 Elfyn McBratney (beu) (RETIRED) gentoo-dev

2005-05-14 17:35:59 UTC


*** This bug has been marked as a duplicate of 80996 ***