You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@causeway.apache.org by "Daniel Keir Haywood (Jira)" <ji...@apache.org> on 2024/07/05 13:44:00 UTC
[jira] [Updated] (CAUSEWAY-3118) [SecMan] With Postgres, Schema is not Created Automatically
[ https://issues.apache.org/jira/browse/CAUSEWAY-3118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel Keir Haywood updated CAUSEWAY-3118:
------------------------------------------
Fix Version/s: (was: 2.2.0)
> [SecMan] With Postgres, Schema is not Created Automatically
> -----------------------------------------------------------
>
> Key: CAUSEWAY-3118
> URL: https://issues.apache.org/jira/browse/CAUSEWAY-3118
> Project: Causeway
> Issue Type: Bug
> Components: Ext Sec Secman
> Affects Versions: 2.0.0-M7
> Reporter: Jörg Rade
> Priority: Minor
>
> Workaround: create Schema manually
> {code}CREATE SCHEMA isisextsecman;{code}
> Console Log:
> {code}
> 2022-08-10 18:13:51.500 INFO 27068 --- [ main] o.a.i.e.s.a.s.SeedSecurityModuleService : SEED security fixtures (Users and Roles)
> [EL Warning]: 2022-08-10 18:13:51.552--UnitOfWork(2129226780)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.10.v20211216-fe64cd39c3): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "isisextsecman.applicationtenancy" does not exist
> Position: 45
> Error Code: 0
> Call: SELECT PATH, NAME, VERSION, parentPath FROM isisExtSecman.ApplicationTenancy WHERE (PATH = ?)
> bind => [1 parameter bound]
> Query: ReadObjectQuery(name="isis.ext.secman.ApplicationTenancy.findByPath" referenceClass=ApplicationTenancy sql="SELECT PATH, NAME, VERSION, parentPath FROM isisExtSecman.ApplicationTenancy WHERE (PATH = ?)")
> 2022-08-10 18:13:51.561 ERROR 27068 --- [ main] o.a.i.t.f.a.f.FixtureScript : seed-users-and-roles-fixture-script/global-tenancy: JPA operation: ERROR: relation "isisextsecman.applicationtenancy" does not exist
> Position: 45; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "isisextsecman.applicationtenancy" does not exist
> Position: 45
> 2022-08-10 18:13:51.561 ERROR 27068 --- [ main] o.a.i.t.f.a.f.FixtureScript : seed-users-and-roles-fixture-script
> org.springframework.jdbc.BadSqlGrammarException: JPA operation: ERROR: relation "isisextsecman.applicationtenancy" does not exist
> Position: 45; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "isisextsecman.applicationtenancy" does not exist
> ...
> {code}
> c.f. https://the-asf.slack.com/archives/CFC42LWBV/p1660148483783429
--
This message was sent by Atlassian Jira
(v8.20.10#820010)