You must stop the router before you install this Kernel Swiftlet. Then copy the content of the "deploy" subdirectory of this Kernel Swiftlet distribution into the directory "kernel/sys$authentication".
Copy the JDBC driver jar files into "kernel/sys$authentication". Note that you cannot use zip files. If your JDBC driver is provided as a zip file, then you have to convert it to a jar file.
The configuration of the JDBC Authentication Swiftlet is defined within the element
<swiftlet name="sys$authentication" .../>
of the router's configuration file. One can use the SwiftMQ Exlorer or CLI for configuration as well. They both save into that file.
Attributes of Element "swiftlet"
Definition
| Attribute | Type | Mandatory | Description |
|---|---|---|---|
| authentication-enabled | java.lang.Boolean | No | Enabes/Disables Authentication |
Values
| Attribute | Values |
|---|---|
| authentication-enabled | Default: false |
Element "jdbc-connection", Parent Element: "swiftlet"
JDBC Connection.
Definition
| Attribute | Type | Mandatory | Description |
|---|---|---|---|
| driver-classname | java.lang.String | Yes | Name of the JDBC Driver Class |
| url | java.lang.String | Yes | JDBC URL |
| username | java.lang.String | No | JDBC Username |
| password | java.lang.String | No | JDBC Password |
Values
| Attribute | Values |
|---|---|
| driver-classname | |
| url | |
| username | |
| password |
Element "statements", Parent Element: "swiftlet"
SQL Statements.
Definition
| Attribute | Type | Mandatory | Description |
|---|---|---|---|
| schema-prefix | java.lang.String | No | Schema Prefix for Tables |
| user-select | java.lang.String | No | Select a single User |
| hostaccesslist-select | java.lang.String | No | Select Host Access List of a User |
| queuegrants-select | java.lang.String | No | Select Queue Grants of a Group |
| topicgrants-select | java.lang.String | No | Select Topic Grants of a Group |
| resourcelimitgroups-select | java.lang.String | No | Select a Resource Limit Group |
Values
| Attribute | Values |
|---|---|
| schema-prefix | |
| user-select | Default: select password,authgroupname,rlgroupname from ${schema-prefix}users where username = ? |
| hostaccesslist-select | Default: select hostnamepredicate from ${schema-prefix}hostaccesslists where username = ? |
| queuegrants-select | Default: select queuename,browsegrant,sendgrant,receivegrant from ${schema-prefix}queuegrants where authgroupname = ? |
| topicgrants-select | Default: select topicname,subscribegrant,publishgrant,durablegrant from ${schema-prefix}topicgrants where authgroupname = ? |
| resourcelimitgroups-select | Default: select maxconnections,maxsessions,maxtempqueues,maxproducers,maxconsumers from ${schema-prefix}resourcelimitgroups where rlgroupname = ? |
Element "cache", Parent Element: "swiftlet"
Cache.
Definition
| Attribute | Type | Mandatory | Description |
|---|---|---|---|
| enabled | java.lang.Boolean | No | Enabes/Disables Caching |
| expiration | java.lang.Long | No | A cached Entity expires after this time (ms) |
Values
| Attribute | Values |
|---|---|
| enabled | Default: true |
| expiration | Min: 1000 Default: 300000 |