Bug 777527 (SOA-27) - 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: SOA-27
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: 2013-05-31 14:02 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
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
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-27 0 Minor Closed Error in MySQL GRANT command in server/default/deploy/jbossesb.sar/juddi-sql/mysql/create_database.sql 2013-05-31 15:53:19 UTC

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. 


Note You need to log in before you can comment on or make changes to this bug.