Bug 777527 (SOA-27)

Summary: Error in MySQL GRANT command in server/default/deploy/jbossesb.sar/juddi-sql/mysql/create_database.sql
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Len DiMaggio <ldimaggi>
Component: JBossESBAssignee: Kurt Stam <kurt.stam>
Status: CLOSED WONTFIX QA Contact:
Severity: medium Docs Contact:
Priority: medium    
Version: unspecifiedCC: atangrin, ldimaggi, soa-p-jira
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-27
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 777528 777529 (view as bug list) 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
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Len DiMaggio 2007-09-28 15:09:33 UTC 
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.