Bug 71161 - [PATCH] Incorrect rights for setup devel/bugzilla
Summary: [PATCH] Incorrect rights for setup devel/bugzilla
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: Normal Affects Only Me
Assignee: freebsd-ports-bugs (Nobody)
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-08-30 20:30 UTC by Dmitry A Grigorovich
Modified: 2004-10-27 20:24 UTC (History)
0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Dmitry A Grigorovich 2004-08-30 20:30:25 UTC 
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

Fix: Apply patch



Now you are known what rights needed :)
Change rights and bugzilla worked--zBNhBXEhbo1dWMXtWTjRn5kh262NWXFJQhcRZfqYUFnbDGHw
Content-Type: text/plain; name="diff"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment; filename="diff"

--- 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
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
Comment 1 Dmitry A Grigorovich 2004-08-30 21:42:11 UTC 
More correctly:

If you are using MySQL 4.0 or newer, enter: 

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,LOCK
TABLES,CREATE TEMPORARY TABLES,REFERENCES ON bugs.* TO bugs@localhost
IDENTIFIED BY '<bugs_password>';  
mysql> FLUSH PRIVILEGES;  

If you are using an older version of MySQL, the LOCK TABLES and CREATE
TEMPORARY TABLES permissions need to be removed from the list: 

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES
ON bugs.* TO bugs@localhost IDENTIFIED BY '<bugs_password>';  
mysql> FLUSH PRIVILEGES;  

[ODiP] == Dmitry Grigorovich
Comment 2 Pav Lucistnik freebsd_committer freebsd_triage 2004-10-27 20:24:13 UTC 
State Changed
From-To: open->closed

Committed, thanks!