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

CentOS 7 Packaged Install Not Working

Added by Reginald Greyling over 4 years ago

Hi OpenProject community,

I was extremely excited when I discovered OpenProject, mainly because we’re a small company in South Africa and this means that we end up paying an arm and a leg for SaaS applications thanks to basically all of them using USD or EUR for their subscriptions and South Africa’s ZAR being extremely weak due to its struggling economy.

Unfortunately, however, my excitement vanished quickly after running openproject configure on a fresh CentOS 7 1908 minimal install hosted on ESXi 6.5. As it turns out, the configuration wizard attempts to install PostgreSQL from a repository that doesn’t exist!

[postgres] ./bin/preinstall
INFO: autoinstall=install. A new PostgreSQL v10 server will be installed locally unless a conflicting installation is found.
INFO: Checking whether port 45432 is available... OK
INFO: Installing PostgreSQL v10...
Loaded plugins: fastestmirror
Cannot open: https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-redhat10-10-2.noarch.rpm. Skipping.
Error: Nothing to do

I checked, there is no RPM package named pgdg-redhat10-10-2.noarch.rpm located in the rhel-7-x86_64 directory above. So either it’s been removed or this is a mistake in the wizard script.

Nonetheless, I didn’t give up. I installed PostgreSQL manually and configured it where I could log in using the command psql -U openproject -h localhost openproject. Feeling positive, I ran openproject reconfigure and chose to use an existing PostgreSQL database. To my utter disappointment I had to abort the wizard due to it being unable to connect to the database. After an hour of Google searches trying to find a solution I eventually gave up and now I’m here.

I’m really hoping that someone in the community can help me get OpenProject up and running on a CentOS 7 server, as it’s our distro of choice for servers. Thank you in advance!


Replies (3)

RE: CentOS 7 Packaged Install Not Working - Added by Cyril Rohr over 4 years ago

Hello Reginald,

I'm sorry for the issues you encountered. Our goal is to make it as easy to setup OpenProject as possible, and clearly this wasn't a good experience for you.

I'll have a look at the missing repository issue you are describing. It may happen that postgres decided to yank that version from their repositories.

If you want to use a pre-existing database, you must ensure that you have created a proper user and password and that you can connect using psql -h 127.0.0.1 -U username. The wizard does not support the ident-based mechanism.

I'll get back to you once the first issue has been fixed.

Thanks for the report,

Cyril

RE: CentOS 7 Packaged Install Not Working - Added by Cyril Rohr over 4 years ago

Hello again,

A build with the updated wizard is in progress at https://packager.io/gh/opf/openproject/builds/2729. Once it's all green, can you retry setting it up on your CentOS7 server? Best way would be to start from scratch if you can, or then run reconfigure and choose the automated install for postgres.

Let me know how this goes,

Thanks,

Cyril

RE: CentOS 7 Packaged Install Not Working - Added by Reginald Greyling over 4 years ago

Hi Cyril,

My apologies for the late reply. Just been having so much fun with OpenProject!

If that wasn’t clear enough, the installation worked! Thank you very much for your prompt response and resolution of this issue.

Now that we can better manage our projects and make greater successes out of them, we’ll hopefully soon be able to opt for the premium features.

Take care and be safe until control over this pandemic has been regained.

Regards,

Reginald

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