Bug 777558 (SOA-62)

Summary:	Need to define, document, (ideally) automate in installer - steps for customer to convert or install SOA-P with DB other than HSQL
Product:	[JBoss] JBoss Enterprise SOA Platform 4	Reporter:	Len DiMaggio <ldimaggi>
Component:	Documentation	Assignee:	Mike Brock <cbrock>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	4.2 IR2	CC:	rruss
Target Milestone:	---
Target Release:	4.2 CR3
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-62
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2008-02-26 13:37:10 UTC	Type:	Task
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Bug Depends On:	777899
Bug Blocks:

Description Len DiMaggio 2007-10-23 14:17:24 UTC

Date of First Response: 2007-10-24 02:42:46
project_key: SOA

We need to support customers who do not want to run HSQL. Right now, the ESB/SOA-P install (ant dist for ESB) creates the DBs automatically, but only for HSQL.

The DBs are:
   - jBPM
   - Message store
   - DB used by ESB console
   - DB used by transformations console
   - DB used by management/admin console
   - jUDDI

Right now, some of the DBs have scripts to create their DBs, but probably not all of them.

We need to create these scripts, define/document/verify/test the steps needed to convert an installation from HSQL to MySQL and PostgreSQL (tier 1 DBs for SOA-P).

Ideally - we will automate the install process in the installer.

Comment 2 Len DiMaggio 2007-10-23 14:27:45 UTC

Link: Added: This issue is related to SOA-63

Comment 3 Len DiMaggio 2007-10-23 14:40:35 UTC

Link: Added: This issue related JBESB-832

Comment 4 Len DiMaggio 2007-10-23 14:40:54 UTC

Link: Added: This issue related JBESB-871

Comment 5 Jiri Pechanec 2007-10-24 06:42:46 UTC

Check https://svn.corp.jboss.com/repos/soa/trunk/qa/dbinstall

It contains QA ant script that allows to configure ESB for selected database

Comment 7 Joshua Wulf 2007-12-19 15:10:25 UTC

Will a script be included to do this, or will this be a sequence of steps that users need to follow manually, and which we will need to provide in the installation guide?

Comment 8 Jiri Pechanec 2008-02-05 14:15:52 UTC

Also look to
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4122856#4122856

Comment 9 Mike Brock 2008-02-07 04:33:19 UTC

fixed in CR3.

Interactive script is located in: /tools/schema

Simply run: "ant" then follow screen prompts for information.

Comment 10 Len DiMaggio 2008-02-26 13:37:10 UTC

The new tool is in: /tools/schema in the GA CR3 and GA builds.

Comment 11 Aleksandar Kostadinov 2008-02-26 14:59:54 UTC

SOA-427 is about the tool being broken

Comment 12 Aleksandar Kostadinov 2008-02-26 14:59:54 UTC

Link: Added: This issue depends SOA-427