Skip to content

Latest commit

 

History

History

sag-db-mysql-103

README.md

Creating webMethods database on MySQL server

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

Requirements

None.

Supported Software AG releases

  • Command Central 10.3
  • 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

When importing the composite template to Command Central, you have to attach the 'mysql-connector-java-5.1.47.jar' file. Add the template.yaml and mysql-connector-java-5.1.47.jar files into a single template.zip file and import that file using the following command in the Command Central CLI:

sagcc exec templates composite import -i template.zip

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 and password root:

sagcc exec templates composite apply sag-db-mysql-10.3 \
  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

  1. Launch the Command Central container from the root folder of the following project:
docker-compose up -d cc
  1. Launch the MySQL container:
docker-compose -f templates/sag-db-mysql-10.3/docker-compose.yml up -d mysql
  1. Provision sag-db-mysql-10.3 and run tests:
CC_ENV=mysql ./provisionw sag-db-mysql-10.3

If the test is successful, the test ouptut contains TEST SUCCESSFUL.

You can now use this database for creating instances of webMethods products (for example, Integration Server and 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 pre-set in the environments/mysql/env.properties file and you can use them by pointing to the environment name, for example:

CC_ENV=mysql ./provisionw sag-is-cluster