1 Topic by communque

  • communque
  • Member
  • Offline
  • Registered: 2024-04-01
  • Posts: 65

Topic: How to connect the iRedMail-installed PG server using pgAdmin 4?

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version:  iRedMail-1.7.0
- Deployed with downloadable installer
- Linux/BSD distribution name and version: Ubuntu 24.04 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
====

Looking to connect to the iRedMail-installed PG server using pgAdmin 4
Right now just testing over a LAN (later over WAN)
Not immediately having success.

What would be the login creds / pg_hba.conf settings?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by communque

  • communque
  • Member
  • Offline
  • Registered: 2024-04-01
  • Posts: 65

Re: How to connect the iRedMail-installed PG server using pgAdmin 4?

NOTE: I am able to log in using psql on the machine

but not with pgAdmin via LAN

Currently key entries I've got are...

in pg_hba.conf

host  all     all     0.0.0.0/0        md5

in postgresql.conf:

listen_addresses = '*'

And with pgAdmin, the attempt to log via LAN is

Host name/address: 192.168.1.xxx
Port: 5432
Maintenance database: postgres
Username: postgres
Password: •••••

Error: connection timeout expired

3 Reply by Cthulhu

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 907

Re: How to connect the iRedMail-installed PG server using pgAdmin 4?

firewall, you need to open the port

4 Reply by communque

  • communque
  • Member
  • Offline
  • Registered: 2024-04-01
  • Posts: 65

Re: How to connect the iRedMail-installed PG server using pgAdmin 4?

Cthulhu wrote:

firewall, you need to open the port

Yep, that did it.  Note: Using iftables instead of ufw.

Thanks Cthulhu