You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@isis.apache.org by "Han Hui Wen (Jira)" <ji...@apache.org> on 2022/04/27 06:18:00 UTC

[jira] [Created] (ISIS-3029) Schema "isisextensionssecman" does not exists

Han Hui Wen  created ISIS-3029:
----------------------------------

             Summary: Schema "isisextensionssecman" does not exists
                 Key: ISIS-3029
                 URL: https://issues.apache.org/jira/browse/ISIS-3029
             Project: Isis
          Issue Type: Bug
          Components: Isis Extensions SecMan
    Affects Versions: 2.0.0-M7
            Reporter: Han Hui Wen 


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 .

 

 



--
This message was sent by Atlassian Jira
(v8.20.7#820007)