Contents

Setting up

  1. Open the profile for off-line editing through the Profile Manager as explained in section 4.8.1 How to Enable Pinging.
  2. Modify Principal Manager as explained in section Modifying ACL and Principal Manager Implementation and Modifying ACLManager Implementation section in the Working with ACL based Security section to RDBMS.
  3. Configure these components as per the database used. A sample configuration for some common databases is provided in later sections.
  4. Right-click on the FioranoMQ node and select the Save option from the pop-up menu.

Additional Configuration

The database driver needs to be added to the Container classpath. To force the FioranoMQ server to create default Destinations and Users in the recently configured RDBMS server, the existing database is to be cleared (run folder of profile) prior to restarting the server.

Sample Configurations

The list below provides sample configurations for various databases. These parameters can be specified for the ACLManager as well as for the PrincipalManager.

Oracle

  • URL: jdbc:oracle:thin:@164.164.128.113:1521:orcl
  • Database Driver: oracle.jdbc.driver.OracleDriver
  • Username: scott
  • Password: tiger

MySQL

  • URL: jdbc:mysql://localhost/mysql
  • DatabaseDriver: com.mysql.jdbc.Driver
  • Username: <user name>
  • Password: <password>

HSQL

  • URL: jdbc:hsqldb:d:\FMQDB
  • DatabaseDriver: org.hsqldb.jdbcDriver
  • Username: sa
  • Password: <password>

MSSQL

  • URL: jdbc:microsoft:sqlserver://qalab01:1433
  • DatabaseDriver: com.microsoft.jdbc.sqlserver.SQLServerDriver
  • Username: sa
  • Password: <password>
Icon

The MS-SQL driver has to be added to the Container classpath(msutil.jar,mssqlserver.jar,msbase.jar)

DB2

  • URL: jdbc:db2://localhost:7777/sample
  • DatabaseDriver: COM.ibm.db7.jdbc.net.DB2Driver
  • Username: user
  • Password: passwd

The parameter named Properties File should point to principalsqlstatements properties when configuring PrincipalManager, and to aclsqlstatements properties when configuring ACLManager. These files can be found in the conf folder of the profile being used.

Verifying

Use a Query tool provided by the database vendor (SQLWorksheet for Oracle) and verify the creation of the following tables with their default values:

Principal Manager

  • TableName - users (stores all Users related information)
  • TableName - groupmembers (stores all Group related information)

ACL Manager

TableName - aclentries (stores ACL Entries for all users)

The following is a sample SQL query executed in a SQLWorksheet:

Adaptavist ThemeBuilder EngineAtlassian Confluence