How to connect to MariaDB over SSL in TIBCO ActiveMatrix BusinessWorks™
Article ID: KB0076872
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | 5.14 |
Description
TIBCO ActiveMatrix BusinessWorks™ (BW) 5.14 supports MariaDB 10.1.x and 10.2.x. This article lists the steps for configuring BW to connect to MariaDB over SSL
Issue/Introduction
Steps for configuring TIBCO ActiveMatrix BusinessWorks™ to connect to MariaDB over SSL
Environment
TIBCO ActiveMatrix BusinessWorks™ 5.14
MariaDB 10.1.x, 10.2.x
Resolution
Pre-requisites
Configuration
1. Add the driver to classpath
Add the location of driver JAR file to the classpath
OR
Add the driver JAR file to one of the locations in the classpath
2. Configure 'JDBC Connection' shared resource as follows:
a. Do not select any driver from the dropdown
b. Set 'JDBC Driver' to org.mariadb.jdbc.Driver
c. Set 'Database URL' to jdbc:mariadb://host:port/database?useSSL=true&trustStore=truststore_location&trustStorePassword=truststore_password&keyStore=keystore_location&keyStorePassword=keystore_password
d. Set 'User Name' and 'Password' to appropriate values
Information on additional URL parameters, including SSL-related parameters, can be found at https://mariadb.com/kb/en/library/about-mariadb-connector-j/
- A suitable JDBC driver must be available on the machine where Designer or BW application is running. The driver, MariaDB Connector/J, can be downloaded from https://mariadb.com/kb/en/library/about-mariadb-connector-j/.
- The certificates needed for server authentication must be available on the machine where Designer or BW application is running.
- If mutual authentication is enabled, client's (driver) private key and certificate must be available on the machine where Designer or BW application is running. This is required for client authentication.
Configuration
1. Add the driver to classpath
Add the location of driver JAR file to the classpath
OR
Add the driver JAR file to one of the locations in the classpath
2. Configure 'JDBC Connection' shared resource as follows:
a. Do not select any driver from the dropdown
b. Set 'JDBC Driver' to org.mariadb.jdbc.Driver
c. Set 'Database URL' to jdbc:mariadb://host:port/database?useSSL=true&trustStore=truststore_location&trustStorePassword=truststore_password&keyStore=keystore_location&keyStorePassword=keystore_password
host - DB server host
port - DB server port
database - Database name
truststore_location - location of Java keystore file containing certificates needed for server authentication
truststore_password - password for truststore
keystore_location - location of Java keystore file containing client's private key and certificate
keystore_password - password for keystore
database - Database name
truststore_location - location of Java keystore file containing certificates needed for server authentication
truststore_password - password for truststore
keystore_location - location of Java keystore file containing client's private key and certificate
keystore_password - password for keystore
For example,
jdbc:mariadb://localhost:3306/bwdb?useSSL=true&trustStore=d:/wa/PKI/MariaDB/server.jks&trustStorePassword=password&keystore=d:/wa/PKI/MariaDB/client.jks&keyStorePassword=password
jdbc:mariadb://localhost:3306/bwdb?useSSL=true&trustStore=d:/wa/PKI/MariaDB/server.jks&trustStorePassword=password&keystore=d:/wa/PKI/MariaDB/client.jks&keyStorePassword=password
d. Set 'User Name' and 'Password' to appropriate values
Information on additional URL parameters, including SSL-related parameters, can be found at https://mariadb.com/kb/en/library/about-mariadb-connector-j/
Additional Information
https://mariadb.com/kb/en/library/about-mariadb-connector-j/
https://mariadb.com/kb/en/library/using-tls-ssl-with-mariadb-java-connector/
https://mariadb.com/kb/en/library/using-tls-ssl-with-mariadb-java-connector/
Feedback
Yes
No
Powered by
