Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums
  • Feature tour
    Feature tour

Content

You are here:
  1. Forums
  2. Support Installation & Updates

Error during installation process

Added by Rob Guinness over 6 years ago

Hi,

I’m installing OpenProject locally for the first time. I ran into the following error when running ./bin/rake db:migrate db:seed db:test:prepare:

psql:/home/rob/OpenReadingList/db/structure.sql:21: ERROR:  must be owner of extension plpgsql
rake aborted!
failed to execute:
psql -v ON_ERROR_STOP=1 -q -f /home/rob/OpenReadingList/db/structure.sql openreadinglist_test

Please check the output above for any errors and make sure that `psql` is installed in your PATH and has proper permissions.


Tasks: TOP => db:test:load_structure
(See full trace by running task with --trace)

After digging around a big, I managed to avert the error by granting more permissions to the openproject user via psql:

alter role openproject with superuser;

But I suspect this is not a good solution. Any ideas why I am getting this error in the first place?


Replies (2)

RE: Error during installation process - Added by Marce ML over 3 years ago

It seems that this issue is still open.

The  plpgsql extension is installed but it seems rake needs superuser rights for unclear reasons.

I cannot even run the suggested ALTER ROLE command, because I'm using a managed PgSQL cloud instance.

Can you suggest please a workaround for this?

Thanks in advance.

RE: Error during installation process - Added by Oliver Günther over 3 years ago

Hi Marce,

OpenProject depends on the plpgsql being active. It is thus added in the schema sql to trigger an error when it is not present and not allowed to do so.

In your case, please ensure the extension is enabled through your administration interface or other means of enabling it. In that case, OpenProject would not try to enable it itself.

Best

Oliver

  • (1 - 2/2)
Loading...