Skip to content

Latest commit

 

History

History
114 lines (82 loc) · 3.4 KB

README.md

File metadata and controls

114 lines (82 loc) · 3.4 KB

Creating webMethods database on MySQL server

STATUS: INCUBATING

With this template you can create user, database, and webMethods database schemas on a MySQL Server.

Requirements

Supported Software AG releases

  • Command Central 10.3 or higher
  • Database Component Configurator 10.3
  • webMethods database schemas for products version 10.3
  • MySQL JDBC Driver

Supported platforms

  • All supported Windows and UNIX platforms
  • All supported versions of MySQL Server database
  • Docker Engine 17.09 or higher

Running as a standalone Composite Template

To install Database Component Configurator 10.3 on the Command Central node with alias local, create a database named webm and a database user named webm with password webm, and create IS database product schemas with user root with password root:

sagcc exec templates composite apply sag-db-mysql \
  db.version=latest repo.product=products-10.3 repo.fix=fixes-10.3 nodes=local \
  db.host=mysql db.admin.username=root db.admin.password=root \
  db.name=webm db.username=webm db.password=webm \
  db.components=[STR] \
  db.products=[IS]
  --sync-job --wait 360

Using for local development and testing on Docker platforms

Launch the Command Central container from the root folder of this project:

docker-compose up -d cc

Launch the MySQL container:

docker-compose -f templates/sag-db-mysql/docker-compose.yml up -d mysql

Provision sag-db-mysql template and run tests:

CC_ENV=mysql ./provisionw sag-db-mysql

Successful test output looks like this:

...
**********************************
* Executing action
*   Action            : catalog
*   Database          : SQL Server
*   URL               : jdbc:mysql://mysql:3306/webm
*   User              : webm
**********************************

**********************************
*      Installed Components      *
**********************************
*   XRF 11 CrossReference
*   ISC 60 ISCoreAudit
*   ISI 75 ISInternal
**********************************

The expected values were successfully retrieved after 1 call within 4 seconds.
TEST SUCCESSFUL

You can now use this database for creating instances of webMethods products (Integration Server, My webMethods Server) with the following database connection properties:

db.url=jdbc:mysql://mysql:3306/webm
db.username=webm
db.password=webm
db.type=mysql

The properties are preset in environments/mysql/env.properties file and you can use them by poiting to the environment name. For example:

CC_ENV=mysql ./provisionw sag-is-cluster