ports/71161: [PATCH] Incorrect rights for setup devel/bugzilla
Dmitry A Grigorovich
odip at bionet.nsc.ru
Mon Aug 30 19:30:27 UTC 2004
>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:
More information about the freebsd-ports-bugs
mailing list