# Bug OP-11177 - Backup failed: pg_dump: password authentication failed for user "openproject"

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-11177

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module |  |
| Target versions | 12.3.0 |
| Observed in versions | 12.2.0 |
| Sprint | 12.3.0 |
| Backlog bucket |  |
| Bug found in version (deprecated) | 12.2.x |
| Found in mobile app version |  |
| Follow-up feedback e-mail |  |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

### Steps to reproduce

1.  Login as admin to OpenProject
2.  Go to Administration > Backup
3.  Enter token and Request backup

###   

### What is the buggy behavior?

A popup appears and no backup is created:

> Backup failed: pg\_dump: error: connection to server on socket "/run/postgresql//.s.PGSQL.5432" failed: FATAL: password authentication failed for user "**openproject**"

OpenProject works fine and has no authentication issues, so obviously the DB settings in the conf file are correct. My DB name and username are not "openproject" but a custom one that I entered during the OpenProject install wizard. Therefore, I suspect the Backup module has DB username "openproject" hardcoded somewhere or it ignores the DB settings from the conf file.

  

### What is the expected behavior?

Create a backup without throwing DB authentication error.

###   

### Screenshots and other files

Popup after clicking Request backup within OpenProject:

<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/38763/content">

Content of `/etc/openproject/conf.d/00_addon_postgres`

<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/38764/content">

###   

### Environment information

During installation I used my existing PostgreSQL instance (runs on localhost and /run/postgresql). I called my OpenProject DB &quot;projects&quot; the owner of the DB is user &quot;projects&quot; and it has strong password. OpenProject installed without errors, all tables were created and I am able to use OpenProject normally, except for the Backup.

  
**OpenProject installation type**

*   [ ] Hosted cloud edition
*   [x] Packaged installation
    *   Ubuntu 22.04.01 LTS (x86\_64) with PostgreSQL 14.5
*   [ ] Docker All-in-one container
*   [ ] Docker-compose installation
*   [ ] Other (please specify)

**OpenProject version**

v12.2.4

**Language**

en