Administrator Server Database Details
You can choose to use the Administrator server with a default in-process database during development. In production systems, use an external database instead. This screen allows you to configure database details.
Field | Description |
---|---|
Use Default In-Process Database | Select to use the embedded in-memory database, or clear to use an external database. If cleared, the database configuration fields are displayed.
Default: Selected. |
If you decide to use a non-default database, the wizard prompts you for database details.
If you are using an external database, see Database Requirements. To enable SSL communications, see Secure Communication Channels and SSL Requirements.
Field | Description |
---|---|
Database Driver | Driver for the external database:
Default: JDBC driver provided for HSQL 1.8.400. |
Database URL |
URL of the external database. Default: jdbc:hsqldb:hsql://localhost:1234/amx.
Note: For PostgreSQL database, you must add client machine IP address entry in the
pg_hba.conf file. If the TIBCO ActiveMatrix Administrator is replicated, you must also add IP address of the machine on which ActiveMatrix Administrator is replicated in the
pg_hba.conf file. For more information, see PostgreSQL documentation.
|
Username | External database username.
Default: sa. |
Password | External database password.
Default: None. |
Max Connections | Maximum number of database connections to allocate.
Default: 10. |
Database Server is SSL Enabled | Check to enable the database server for SSL. When checked, the SSL Keystore Configuration fields are enabled.
Default: Cleared. Note: PostgreSQL database with SSL enabled is not supported in TIBCO ActiveMatrix Service Grid 3.4.2.
|
Test Connection | Click Test Connection to ensure that you can connect to the database. |
Field | Description |
---|---|
Create a Trust Store... | Invokes a wizard to import certificates from a server and create the trust store.
|
Browse | Invokes a dialog to navigate to a keystore file. |
Keystore Location | Location of the keystore. |
Keystore Type | Type of the keystore: JKS or JCEKS.
Default: JKS. |
Keystore Password | Password that protects the keystore. |
Starting with TIBCO ActiveMatrix 3.4.0 Hotfix 002, PostgreSQL database versions 11.5 and 10.7 are supported. In PostgreSQL, the client authentication is controlled by apg_hba.conf file in the database cluster's /data directory.
By default, a PostgreSQL database listens to TCP/IP connections only on the local loopback address
localhost
.
Therefore, before configuring a PostgreSQL database by using TIBCO Configuration Tool (TCT), you must add a client machine IP address entry in the pg_hba.conf file.
If the TIBCO ActiveMatrix Administrator is replicated, you must also add the IP address of the machine on which the ActiveMatrix Administrator is replicated in the pg_hba.conf file.
For example, if the client machine IP address is
172.20.143.0
, then you must add an entry in the
pg_hba.conf file as:
# TYPE DATABASE USER ADDRESS METHOD host all all 172.20.143.0/24 trustFor more information about the pg_hba.conf file, see PostgreSQL documentation.