Date: Tue, 31 Aug 2004 02:28:32 +0700 (NOVST) From: Dmitry A Grigorovich <odip@bionet.nsc.ru> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/71161: [PATCH] Incorrect rights for setup devel/bugzilla Message-ID: <20040830192832.AA891154D9@cosmos.softberry.ru> Resent-Message-ID: <200408301930.i7UJUPVc001707@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 71161
>Category: ports
>Synopsis: [PATCH] Incorrect rights for setup devel/bugzilla
>Confidential: no
>Severity: critical
>Priority: medium
>Responsible: freebsd-ports-bugs
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: change-request
>Submitter-Id: current-users
>Arrival-Date: Mon Aug 30 19:30:25 GMT 2004
>Closed-Date:
>Last-Modified:
>Originator: Dmitry A Grigorovich
>Release: FreeBSD 4.9-RELEASE-p4 i386
>Organization:
ICiG SB RAS
>Environment:
System: FreeBSD 4.9-RELEASE-p4
>Description:
File /usr/ports/devel/bugzilla/pkg-message have incorrect right
for setup bugzilla:
1. Create database user who has rights on bugs database manipulation
by following mysql commands:
GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES \
ON <database>.* TO <dbuser>@<host> IDENTIFIED BY '<password>';
====
On first login in bugzilla I found,
that also needed LOCK TABLES for this list or rights
>How-To-Repeat:
Install mysql40
Install devel/bugzilla
Configure bugzilla via ./checksetup.pl
After complete you will be have administrator with password
Login as administrator in bugzilla
You are get error about LOCK TABLES in global.pl
>Fix:
Apply patch
--- diff begins here ---
--- pkg-message Fri Jul 23 13:41:02 2004
+++ pkg-message.new Tue Aug 31 02:15:51 2004
@@ -4,8 +4,9 @@
1. Create database user who has rights on bugs database manipulation
by following mysql commands:
- GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES \
- ON <database>.* TO <dbuser>@<host> IDENTIFIED BY '<password>';
+ GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,DROP,REFERENCES,\
+ LOCK TABLES ON <database>.* TO <dbuser>@<host> \
+ IDENTIFIED BY '<password>';
FLUSH PRIVILEGES;
where <database> is a bugs database name; <dbuser> is a bugs database
--- diff ends here ---
Now you are known what rights needed :)
Change rights and bugzilla worked
>Release-Note:
>Audit-Trail:
>Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040830192832.AA891154D9>