Zammad DB Access by pgadmin

Technical assistance
1

Infos:

  • Used Zammad version: 5.1
  • Used Zammad installation type: Package
  • Operating system: Centos 7
  • Browser + version: Microsft Edge 101.0.1210.53

Expected behavior:

  • Connect to PostgreSQL DB by PDAdmin 4

Actual behavior:

  • Not connected to zammad DB with PGAdmin 4

Steps to reproduce the behavior:

  • Generate password with helper script /opt/zammad/contrib/zammad_db_user_helper.sh
    Change the password generated in PostgreSQL:
  • Access to local DB: -u postgres psql postgres
  • Change password: \password “Password generated”
  • Add line in pg_hba.conf: Host ALL ALL ALL md5
  • Connect with PGAdmin 4.
2

This is not a Zammad question but a Postgres question but did you edit postgresql.conf from #listen_addresses = 'localhost' to listen_addresses = '*'

3

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.