[CAUSEWAY-3029] Schema "isisextensionssecman" does not exists

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Abandoned
• Affects Version/s: 2.0.0-M7
• Fix Version/s: 2.0.0-RC2
• Component/s: Ext Sec Secman
• Labels: TestCaseRequired
• Assignee: Unassigned
• Reporter: Han Hui Wen
• Created: 27/Apr/22 06:17
• Updated: 06/May/23 06:33
• Resolved: 06/May/23 06:33

Description

I use Postgresql .when I try ISIS secman extension ,find following issue :

 

Call: CREATE TABLE isisExtensionsSecman.ApplicationUserRoles (roleId BIGINT NOT NULL, userId BIGINT NOT NULL, PRIMARY KEY (roleId, userId))
Query: DataModifyQuery(sql="CREATE TABLE isisExtensionsSecman.ApplicationUserRoles (roleId BIGINT NOT NULL, userId BIGINT NOT NULL, PRIMARY KEY (roleId, userId))")
[EL Warning]: 2022-04-27 14:08:56.375-ServerSession(1942100755)-Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.10.v20211216-fe64cd39c3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: Error schema"isisextensionssecman"  does not exits .

 

Anctullay I have  created isisextensionssecman in Postgresql Database . Seems it's cause by Postgres  names case sensitive issue .

 

when I change the configuration as following according to the document :

https://isis.apache.org/security/2.0.0-M7/secman/setting-up.html#examples

 

isis:

    persistence:

        schema:

              auto-create-schemas: abdb

It's still has  the issue , seems isisextensionssecman is hard coding in program .