You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@isis.apache.org by "Daniel Keir Haywood (Jira)" <ji...@apache.org> on 2022/08/02 12:29:00 UTC

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

     [ https://issues.apache.org/jira/browse/ISIS-3029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel Keir Haywood updated ISIS-3029:
--------------------------------------
    Fix Version/s: 2.0.0-RC1
                       (was: 2.0.0-M8)

> 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 
>            Assignee: Daniel Keir Haywood
>            Priority: Major
>             Fix For: 2.0.0-RC1
>
>
> 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.10#820010)