onedev/server

#1448 Able to use specified postgresql schema

Released

Daniel Eagle opened 10 months 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 10 months ago

It always uses public schema. I am converting this to an improvement request.

Robin Shen changed fields 10 months ago

Name	Previous Value	Current Value
Type	Discussion	Improvement

Robin Shen changed title 10 months ago

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

jbauer commented 10 months 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' 10 months ago

Previous Value	Current Value
Open	Closed

OneDev commented 10 months ago

State changed as code fixing the issue is committed (2c347f28)

OneDev changed state to 'Released' 10 months ago

Previous Value	Current Value
Closed	Released

OneDev commented 10 months ago

State changed as build #3909 is successful

Robin Shen commented 10 months ago

Just modify postgresql jdbc connection url to add currentSchema param

Type	Improvement
Priority	Normal
Assignee	Robin Shen

Issue Votes (0)

Watchers (5)

Reference

onedev/server#1448