Able to use specified postgresql schema (OD-1448)

Daniel Eagle opened 3 years ago

Hello. Do you happen to know which schema OneDev expects to be present for Postgres? Without an explicit schema, OneDev tries to do operations on the public schema and I get the following error:

WrapperManager: Initializing...
12:18:37 INFO  i.onedev.commons.bootstrap.Bootstrap - Launching application from '/opt/onedev'...
12:18:39 INFO  io.onedev.commons.loader.AppLoader - Starting application...
12:18:42 ERROR i.onedev.commons.bootstrap.Bootstrap - Error booting application
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: permission denied for schema public
  Position: 14

I appreciate the help. Thanks.

Robin Shen commented 3 years ago

It always uses public schema. I am converting this to an improvement request.
Robin Shen changed fields 3 years ago
Name Previous Value Current Value
Type

Discussion

Improvement

Name	Previous Value	Current Value
Type	Discussion	Improvement

Robin Shen changed title 3 years ago

Previous Value	Current Value
Which Schema for Postgres to Use with OneDev	Able to use specified postgresql schema

jbauer commented 3 years ago

Postgres 15+ disallows using the public schema by default and encourages users to create a named schema. Alternatively you have to grant the OneDev user permission to the public schema.
OneDev changed state to 'Closed' 3 years ago
Previous Value Current Value
Open

Closed
OneDev commented 3 years ago

State changed as code fixing the issue is committed (2c347f28)
OneDev changed state to 'Released' 3 years ago
Previous Value Current Value
Closed

Released
OneDev commented 3 years ago

State changed as build #3909 is successful
Robin Shen commented 3 years ago

Just modify postgresql jdbc connection url to add currentSchema param
Login to comment

Previous Value	Current Value
Open	Closed

Previous Value	Current Value
Closed	Released

Type	Improvement
Priority	Normal
Assignee	Robin Shen

Issue Votes (0)

Watchers (5)

Reference

OD-1448