Top Menu

Jump to content
Home
    • Projects
    • Work packages
    • News
    • Getting started
    • Introduction video

      Welcome to OpenProject Community

      Get an overview

      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
    • Professional 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?
      Create a new account

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
  • Roadmap
  • Work packages
  • Calendars
  • Team planners
  • Boards
  • Forums
  • Wiki
    • Table of contents
      • Expanded. Click to collapseCollapsed. Click to showDeveloper
        • Hierarchy leafAccessibility Checklist
        • Hierarchy leafCode Review Guidelines
        • Expanded. Click to collapseCollapsed. Click to showContribution
          • Hierarchy leafGit Workflow
          • Hierarchy leafTranslations
        • Expanded. Click to collapseCollapsed. Click to showDeveloping Plugins
          • Hierarchy leafDeveloping an OmniAuth Authentication Plugin
        • Hierarchy leafRelease Process
        • Hierarchy leafReport a bug
        • Hierarchy leafSecurity
        • Hierarchy leafSetting up an OpenLDAP server for testing
        • Hierarchy leafTheme Features
      • Hierarchy leafDownload
      • Expanded. Click to collapseCollapsed. Click to showFeature tour
        • Hierarchy leafRelease Notes OpenProject 30
        • Expanded. Click to collapseCollapsed. Click to showRelease Notes OpenProject 30 - Overview
          • Hierarchy leafGlossary
          • Hierarchy leafRelease Notes - Accessibility
          • Hierarchy leafRelease Notes - Accessibility changes
          • Hierarchy leafRelease Notes - Add work package queries as menu items to sidebar
          • Hierarchy leafRelease Notes - Copy projects based on Templates
          • Hierarchy leafRelease Notes - Design changes
          • Hierarchy leafRelease Notes - Fixed Bugs
          • Hierarchy leafRelease Notes - Keyboard Shortcuts
          • Hierarchy leafRelease Notes - Project settings
          • Hierarchy leafRelease Notes - Ruby&Rails Update
          • Hierarchy leafRelease Notes - Security
          • Hierarchy leafRelease Notes - Timelines
          • Hierarchy leafRelease Notes - Work packages
      • Hierarchy leafHowto create animated gifs
      • Hierarchy leafMigration Squashing
      • Hierarchy leafMod security
      • Hierarchy leafNew work package page
      • Hierarchy leafOP3 to OP4 Debian upgrade
      • Hierarchy leafOP4 Ubuntu1404 Stable with MySQL in production
      • Hierarchy leafOpenProject 40 Development Setup
      • Expanded. Click to collapseCollapsed. Click to showOpenProject Foundation
        • Hierarchy leafBoards
        • Hierarchy leafMembers
        • Hierarchy leafOPF-Meetings
        • Hierarchy leafStatutes
      • Expanded. Click to collapseCollapsed. Click to showRelease Notes
        • Hierarchy leafOpenProject released on Bitnami
      • Expanded. Click to collapseCollapsed. Click to showRelease Notes OpenProject 40 - Overview
        • Hierarchy leafRelease Notes OpenProject 40 - Accessibility improvements
        • Hierarchy leafRelease Notes OpenProject 40 - Column header functions in work package table
        • Hierarchy leafRelease Notes OpenProject 40 - Improved Design
        • Hierarchy leafRelease Notes OpenProject 40 - Integrated query title on work package page
        • Hierarchy leafRelease Notes OpenProject 40 - Integrated toolbar on work package page
        • Hierarchy leafRelease Notes OpenProject 40 - OmniAuth integration for OpenProject
        • Hierarchy leafRelease Notes OpenProject 40 - Work package details pane
      • Expanded. Click to collapseCollapsed. Click to showSecurity and privacy
        • Hierarchy leafFAQ
      • Expanded. Click to collapseCollapsed. Click to showSupport
        • Expanded. Click to collapseCollapsed. Click to showDownload and Installation
          • Hierarchy leafInstallation MacOS
          • Expanded. Click to collapseCollapsed. Click to showInstallation OpenProject 3 0
            • Hierarchy leafDebian Stable with MySQL in production
            • Hierarchy leafInstallation Ubuntu
            • Hierarchy leafInstallation Windows
            • Hierarchy leafInstallation on Centos 65 x64 with Apache and PostgreSQL 93
          • Expanded. Click to collapseCollapsed. Click to showInstallation OpenProject 40
            • Hierarchy leafOP4 Debian Stable with MySQL in production
          • Expanded. Click to collapseCollapsed. Click to showMigration paths
            • Hierarchy leafFrom Chilliproject to OpenProject
            • Hierarchy leafMigration 15 to 30
            • Hierarchy leafMigration 24 to 30
            • Hierarchy leafMigration Redmine 2x › OpenProject 30
            • Hierarchy leafOpenProject 3 Migration
          • Hierarchy leafOpenProject 40
        • Expanded. Click to collapseCollapsed. Click to showNews
          • Hierarchy leafNew OpenProject Translations Plugin
          • Hierarchy leafNew Plugin on OpenProjectorg Local Avatars
          • Hierarchy leafNew design for OpenProject
          • Hierarchy leafNews Accessibility workshop for OpenProject
          • Hierarchy leafNews Glossary for OpenProject
          • Hierarchy leafNews Heartbleed fixed
          • Hierarchy leafNews Icon Fonts
          • Hierarchy leafNews OpenProject 30 Release
          • Hierarchy leafNews Release GitHub Integration Plugin
          • Hierarchy leafNews Success Story Deutsche Telekom
          • Hierarchy leafNews Timelines
          • Hierarchy leafOpenProject 3013 released
          • Hierarchy leafOpenProject 3017 released
          • Hierarchy leafOpenProject 40 released
          • Hierarchy leafOpenProject 40 will be coming soon
          • Hierarchy leafOpenProject 405 released
          • Hierarchy leafOpenProject and pkgrio
          • Hierarchy leafOpenProject news moved to a new blog
          • Hierarchy leafOpenProjectBitnami
          • Hierarchy leafPackager version with plugins released ("Community edition")
          • Hierarchy leafRegistration OpenProject-Foundation
          • Hierarchy leafRelease OpenProject AuthPlugins
          • Hierarchy leafUpdates on OpenProject
          • Hierarchy leafWe need your feedback for the the new fullscreen view for work packages
        • Hierarchy leafOpenProject Plug-Ins
      • Hierarchy leafWiki
You are here:
  • Forums
  • General discussion

Content

Centos 7 - New install failed no connection

Added by Marc Walter about 3 years ago

Hi dev's and folks,

I want to install for internal private usage a openproject installation. I have Centos 7 installed and I deactivated the firewall and SElinux. I created a new user with sudo privileges but I can't install OpenProject because of this error. The errors means I can't connect to the server because of a missing file or path. Maybe the server is not running or not acception local connections?

Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-10.service to /usr/lib/systemd/system/postgresql-10.service.
psql: konnte nicht mit dem Server verbinden: Datei oder Verzeichnis nicht gefunden
        Läuft der Server lokal und akzeptiert er Verbindungen
        auf dem Unix-Domain-Socket »/var/run/postgresql/.s.PGSQL.45432«?

I really don't know what to do I have tried to install it with root but I get the same error. I have restored my vm several times before I wrote here but at the moment I don't have any ideas. 

Can someone help? 

Thanks


Replies (14)

RE: Centos 7 - New install failed no connection - Added by Alessandro Boschian Pest about 3 years ago

Hi,
I used the configure script and got the same error and i just figured out a solution.
The steps i followed to make it work:

  1. fully cleaned the database "rm -rf /var/lib/pgsql/10/data/"
  2. re-init the database (follow the official manual installation on the postgresql part....)
  3. edit the: /var/lib/pgsql/10/data/pg_hba.conf changing the method to TRUST where is IDENT
  4. openproject reconfigure

Ale

RE: Centos 7 - New install failed no connection - Added by Marc Walter about 3 years ago

Hi Ale,

Thank you so, I'm not the only one ;=) but i'm always the first one. It doesn't matter which linux software I want to install i always get in trouble.

  1. re-init the database (follow the official manual installation on the postgresql part....) <- Can you point me the link?

Can someone from the dev's have a look at this. Because it looks like a packaging issue on centos 7. I try it now again and set my VM back ;).... I will give you an update soon.....

UPDATE:

The problem is still the same on a fresh centos 7 installation. So you won't be able to install it with the normal installer.

I will try the steps from Ale if I get some more info... first attempt I wasn't able to fix it.

Total download size: 13 M
Installed size: 52 M
Downloading packages:
(1/4): libicu-50.1.2-17.el7.x86_64.rpm                                                                                                    | 6.9 MB  00:00:00     
warning: /var/cache/yum/x86_64/7/pgdg10/packages/postgresql10-10.8-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY MB  --:--:-- ETA 
Public key for postgresql10-10.8-1PGDG.rhel7.x86_64.rpm is not installed
(2/4): postgresql10-10.8-1PGDG.rhel7.x86_64.rpm                                                                                           | 1.6 MB  00:00:00     
(3/4): postgresql10-libs-10.8-1PGDG.rhel7.x86_64.rpm                                                                                      | 355 kB  00:00:00     
(4/4): postgresql10-server-10.8-1PGDG.rhel7.x86_64.rpm                                                                                    | 4.5 MB  00:00:00     
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                             12 MB/s |  13 MB  00:00:01     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Importing GPG key 0x442DF0F8:
 Userid     : "PostgreSQL RPM Building Project <pgsqlrpms-hackers@pgfoundry.org>"
 Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
 Package    : pgdg-redhat-repo-42.0-4.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : postgresql10-libs-10.8-1PGDG.rhel7.x86_64                                                                                                     1/4 
  Installing : libicu-50.1.2-17.el7.x86_64                                                                                                                   2/4 
  Installing : postgresql10-10.8-1PGDG.rhel7.x86_64                                                                                                          3/4 
  Installing : postgresql10-server-10.8-1PGDG.rhel7.x86_64                                                                                                   4/4 
  Verifying  : libicu-50.1.2-17.el7.x86_64                                                                                                                   1/4 
  Verifying  : postgresql10-server-10.8-1PGDG.rhel7.x86_64                                                                                                   2/4 
  Verifying  : postgresql10-10.8-1PGDG.rhel7.x86_64                                                                                                          3/4 
  Verifying  : postgresql10-libs-10.8-1PGDG.rhel7.x86_64                                                                                                     4/4 

Installed:
  postgresql10.x86_64 0:10.8-1PGDG.rhel7                                      postgresql10-server.x86_64 0:10.8-1PGDG.rhel7                                     

Dependency Installed:
  libicu.x86_64 0:50.1.2-17.el7                                            postgresql10-libs.x86_64 0:10.8-1PGDG.rhel7                                           

Complete!
Initializing database ... OK

Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-10.service to /usr/lib/systemd/system/postgresql-10.service.
psql: konnte nicht mit dem Server verbinden: Datei oder Verzeichnis nicht gefunden
        Läuft der Server lokal und akzeptiert er Verbindungen
        auf dem Unix-Domain-Socket »/var/run/postgresql/.s.PGSQL.45432«?

RE: Centos 7 - New install failed no connection - Added by Alessandro Boschian Pest about 3 years ago

Yes exactly the same issue it's definitely an issue with postgres. 
Yesteday i spent most of my day trying to solve this thing. I managed to make it work but the way i solved it it's pretty unsafe. Setting trust to postgresql means everyone who has access to the machine is able to access the database as well. I ended up using a Debian Server (the setup just works) but i would be way happier to use a CentOS install since my network is all based on that distro.

Here's the link to the manual setup: https://github.com/opf/openproject/blob/stable/8/docs/installation/manual/README.md

Ale

RE: Centos 7 - New install failed no connection - Added by Alessandro Boschian Pest about 3 years ago

As a side note on the debian install the pg_hba.conf looks like this:

# Database administrative login by Unix domain socket
local   all             postgres                                peer
# TYPE  DATABASE        USER            ADDRESS                 METHOD
# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            md5
host    replication     all             ::1/128                 md5

But when i try to set it the same way on centos it fails...
Ale

RE: Centos 7 - New install failed no connection - Added by Cyril Rohr about 3 years ago

Hello, sorry for the inconvenience. I am looking into this issue. I'll update this ticket when it's fixed.

RE: Centos 7 - New install failed no connection - Added by Marc Walter about 3 years ago

Thank you Ale,

Yes this is not a solution "TRUST". Hmm yes ok, Ubuntu is ok but as you: I prefer CentOS.

Hi Cyril
Let me know when it's fixed. I can test it very fast since my snapshot is still available ;).

Thanks,

RE: Centos 7 - New install failed no connection - Added by Cyril Rohr about 3 years ago

A newer package has been released that fixes this issue. If you can, I would recommend reinstalling from scratch.

If not possible, you will need to purge the postgresql-server package, and remove /usr/lib/systemd/system/postgresql.service and /var/lib/pgsql for the installer to attempt to reinstall postgres10 automatically. Only do this after checking that you don't have anything valuable in that postgres instance (it was installed by OpenProject so there should only be the openproject database in there).

RE: Centos 7 - New install failed no connection - Added by Alessandro Boschian Pest about 3 years ago

Thanks, i'm gonna try right now! I'll let you know asap.
Ale

RE: Centos 7 - New install failed no connection - Added by Marc Walter about 3 years ago

Restored virtual machine - nothing was installed before that it's a blank system.

Then i did the following: 

sudo wget -O /etc/yum.repos.d/openproject-ce.repo \
 https://dl.packager.io/srv/opf/openproject-ce/stable/8/installer/el/7.repo


sudo yum install openproject

sudo openproject configure

But same error:

Installed:
  postgresql10.x86_64 0:10.8-1PGDG.rhel7                                      postgresql10-server.x86_64 0:10.8-1PGDG.rhel7                                     

Dependency Installed:
  libicu.x86_64 0:50.1.2-17.el7                                            postgresql10-libs.x86_64 0:10.8-1PGDG.rhel7                                           

Complete!
Initializing database ... OK

Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-10.service to /usr/lib/systemd/system/postgresql-10.service.
psql: konnte nicht mit dem Server verbinden: Datei oder Verzeichnis nicht gefunden
        Läuft der Server lokal und akzeptiert er Verbindungen
        auf dem Unix-Domain-Socket »/var/run/postgresql/.s.PGSQL.45432«?

RE: Centos 7 - New install failed no connection - Added by Alessandro Boschian Pest about 3 years ago

Shouldn't it be version 9?
sudo wget -O /etc/yum.repos.d/openproject-ce.repo \
https://dl.packager.io/srv/opf/openproject-ce/stable/9/installer/el/7.repo

RE: Centos 7 - New install failed no connection - Added by Alessandro Boschian Pest about 3 years ago

I can confirm it works! Thanks a lot!
Ale

RE: Centos 7 - New install failed no connection - Added by Marc Walter about 3 years ago

Same here... I can confirm in V.9.01 it's working fine the installation on CentOS 7. 

Thank you for fixing that.

RE: Centos 7 - New install failed no connection - Added by Patric Distel over 2 years ago

Hi all together

I've exactly the same problem, but with the V10.2. I've created also a new clean vm and installed with the instruction. But now there's exatly the same issue, after the configuration:

Installiert:
  postgresql10.x86_64 0:10.11-1PGDG.rhel7
  postgresql10-server.x86_64 0:10.11-1PGDG.rhel7

Abhängigkeit installiert:
  postgresql10-libs.x86_64 0:10.11-1PGDG.rhel7

Komplett!
Initializing database ... OK

Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-10.service to /usr/lib/systemd/system/postgresql-10.service.
psql: konnte nicht mit dem Server verbinden: Datei oder Verzeichnis nicht gefunden
        Läuft der Server lokal und akzeptiert er Verbindungen
        auf dem Unix-Domain-Socket »/var/run/postgresql/.s.PGSQL.45432«?

Could it be, there is a new bug? What can I test?

Thanks for reply

padi

RE: Centos 7 - New install failed no connection - Added by Patric Distel over 2 years ago

Patric Distel wrote:

Hi all together

I've exactly the same problem, but with the V10.2. I've created also a new clean vm and installed with the instruction. But now there's exatly the same issue, after the configuration:

I tested now with an other centos 7 vm (not our template) to be sure there is nothing on it and I have stil the exact the same error.

Anyone an idea?

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