Bug 777528 - Error in MySQL GRANT command in server/default/deploy/jbossesb.sar/juddi-sql/mysql/create_database.sql
Summary: Error in MySQL GRANT command in server/default/deploy/jbossesb.sar/juddi-sql/...
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: JBossESB
Version: unspecified
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
: ---
Assignee: Kurt Stam
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA-27
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2007-09-28 15:09 UTC by Len DiMaggio
Modified: 2012-07-13 04:08 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of: SOA-27
Environment:
soa-standalone.zip (sept 25 2007) RHEL5 java version "1.5.0_12" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04) Java HotSpot(TM) Server VM (build 1.5.0_12-b04, mixed mode)
Last Closed: 2007-11-02 13:40:51 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-27 0 None None None Never

Description Len DiMaggio 2007-09-28 15:09:33 UTC 
++ This bug is a clone of bug 777527 ++

Date of First Response: 2007-10-04 23:16:12
project_key: SOA

There's a small error in: server/default/deploy/jbossesb.sar/juddi-sql/mysql/create_database.sql

Replace:
	GRANT ALL PRIVILEGES ON juddi.* TO 'juddi@%' IDENTIFIED BY 'juddi'; 
With:
	GRANT ALL PRIVILEGES ON juddi.* TO juddi@'%' IDENTIFIED BY 'juddi';

To grant access to juddi user on all hosts.


Ref: http://dev.mysql.com/doc/refman/5.0/en/grant.html
Comment 1 Len DiMaggio 2007-10-05 01:09:52 UTC 
Link: Added: This issue depends JBESB-1136
Comment 2 Kurt Stam 2007-10-05 03:16:12 UTC 
Setting up the user has been removed from the scripts all together. We are now using the scripts as they come with jUDDI.
Note You need to log in before you can comment on or make changes to this bug.