Back to bug 1175386

Who When What Removed Added
Van Halbert 2014-12-22 13:59:37 UTC CC vhalbert
Van Halbert 2014-12-22 14:01:41 UTC CC jstastny
Flags needinfo?(jstastny)
Jan Stastny 2015-01-05 07:23:29 UTC Flags needinfo?(jstastny)
Van Halbert 2015-01-06 18:29:31 UTC Flags needinfo?(jstastny)
Van Halbert 2015-01-06 18:34:33 UTC Link ID JBoss Issue Tracker TEIIDDSHB-11
Jan Stastny 2015-01-07 06:40:58 UTC Flags needinfo?(jstastny)
Van Halbert 2015-01-07 17:02:21 UTC Keywords Documentation
Status NEW ASSIGNED
Assignee vhalbert dlesage
Doc Text Cause: When using either a PostgreSQL or MySQL database for command logging, the DV dashboard will fail due to its inability to find the AuditLog or CommandLog tables. This is due to these database use case sensitive names and the table names exist in all lower case.

Consequence: The DV dashboard will fail with an exception indicating it can not find the table.

Workaround (if any):
Update the DV Dashboard
a. Log into the DV Dashboard with the dashboardAdmin user
b. Select the SecurityLogging workspace to edit
c. Select "Add Source Query" to show data providers
d. Edit both, the AuditLoggingTable and Command Logging providers to change the table names to "ALL" lowercase.
- AuditLog => auditlog
- CommandLog => commandlog
e. save changes

Result: The DV Dashboard should be able to present data from these tables.
Doc Type Bug Fix Known Issue
Van Halbert 2015-01-07 17:02:41 UTC Target Release --- 6.1.0
Van Halbert 2015-01-07 22:14:01 UTC Flags needinfo?(jstastny)
Van Halbert 2015-01-19 14:30:44 UTC Keywords Documentation
Assignee dlesage vhalbert
Target Milestone --- CR2
Doc Type Known Issue Bug Fix
Flags needinfo?(jstastny)
Red Hat Bugzilla 2015-01-19 14:30:44 UTC Doc Type Bug Fix Known Issue
Van Halbert 2015-01-19 14:31:09 UTC Doc Text Cause: When using either a PostgreSQL or MySQL database for command logging, the DV dashboard will fail due to its inability to find the AuditLog or CommandLog tables. This is due to these database use case sensitive names and the table names exist in all lower case.

Consequence: The DV dashboard will fail with an exception indicating it can not find the table.

Workaround (if any):
Update the DV Dashboard
a. Log into the DV Dashboard with the dashboardAdmin user
b. Select the SecurityLogging workspace to edit
c. Select "Add Source Query" to show data providers
d. Edit both, the AuditLoggingTable and Command Logging providers to change the table names to "ALL" lowercase.
- AuditLog => auditlog
- CommandLog => commandlog
e. save changes

Result: The DV Dashboard should be able to present data from these tables.
Doc Type Known Issue Bug Fix
Van Halbert 2015-01-19 16:02:22 UTC Status ASSIGNED MODIFIED
Van Halbert 2015-02-04 16:01:46 UTC CC nshendye
Doc Text When using either a PostgreSQL or MySQL database for command logging
Doc Text , the JBoss Data Virtualization dashboard fails due to its inability to find the AuditLog or CommandLog tables. This is due to the case sensitive names that these database use and the table names exist in lower case. The dashboard fails with an exception
Doc Text indicating it cannot find the table. The workaround is to edit the data source query in the dashboard. The JBoss Data Virtualization Dashboard should be able to present data from these tables.
Target Milestone CR2 ---
Van Halbert 2015-03-13 20:41:45 UTC Keywords Documentation
Assignee vhalbert dlesage
Van Halbert 2015-03-13 20:42:23 UTC Doc Type Bug Fix Release Note
Red Hat Bugzilla 2015-03-13 20:42:23 UTC Doc Type Release Note Bug Fix
Van Halbert 2015-03-13 20:42:40 UTC Doc Type Bug Fix Known Issue
Red Hat Bugzilla 2015-03-13 20:42:40 UTC Doc Type Known Issue Bug Fix
Anne-Louise Tangring 2015-03-13 20:52:01 UTC CC atangrin
David Le Sage 2015-03-22 23:29:33 UTC Status MODIFIED CLOSED
Resolution --- ERRATA
Last Closed 2015-03-22 19:29:33 UTC

Back to bug 1175386