[SOLVED] Error: delivery temporarily suspended

[Younex]

Hi,

i just made an upgrade to two nodes of PMG from 6 to 7.
After following the upgrade manual and rebooting both servers i get this messages for all incoming mail which are not transported:

Error: delivery temporarily suspended: conversation with 127.0.0.1[127.0.0.1] timed out while receiving the initial server greeting)​

GUI is working and if i open "update" tab i popup frequently message "Proxy not allowed".
See screenshot.

Then, after a moment, i can´t login anymore (login popup appears suddenlty).
After a reboot login works again, but just for some minutes.

Hard disk space is available, services seems to run.
DNS issue on host file i don´t see.

Anyhow i have the impression postgresl is missing after upgrade.
I can´t find any postgresql binary.
To see status i executed this command:

root@mx1:/etc/pmg# service postgresql status
● postgresql.service - PostgreSQL RDBMS
     Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
     Active: active (exited) since Mon 2021-10-11 10:23:36 UTC; 23min ago
    Process: 600 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
   Main PID: 600 (code=exited, status=0/SUCCESS)
        CPU: 1ms

Oct 11 10:23:36 mx1 systemd[1]: Starting PostgreSQL RDBMS...
Oct 11 10:23:36 mx1 systemd[1]: Finished PostgreSQL RDBMS.

This is what i found further ins syslog:

DBI connect('dbname=Proxmox_ruledb;host=/var/run/postgresql;port=5432','root',...) failed: could not connect to server: No such file or directory#012#011Is the server running locally and accepting#012#011connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? at /usr/share/perl5/PMG/DBTools.pm line 79.

Any tips how to solves this would be very nice.

Thank you!

 

[Stoiko Ivanov]

could you please share:
* the output of `pmgversion -v`
* the output of `grep '' /etc/apt/sources.list /etc/apt/sources.list.d/*`
* the output of `dpkg -l |grep -i postgres`

Thanks!

else as a quick fix - if it's indeed postgresql missing - try installing it with `apt install postgresql-13`

 

[Younex]

could you please share:
* the output of `pmgversion -v`
* the output of `grep '' /etc/apt/sources.list /etc/apt/sources.list.d/*`
* the output of `dpkg -l |grep -i postgres`

Thanks!

else as a quick fix - if it's indeed postgresql missing - try installing it with `apt install postgresql-13`

Hi Stoiko.

Thank you.

pmgversion -v

proxmox-mailgateway: residual config (API: 7.0-8/36f2537c, running kernel: 5.10.0-9-amd64)
pmg-api: 7.0-8
pmg-gui: 3.0-5
pve-kernel-4.13.13-5-pve: 4.13.13-38
clamav-daemon: 0.103.3+dfsg-0+deb11u1
ifupdown: 0.8.36
libarchive-perl: 3.4.0-1
libjs-extjs: 7.0.0-1
libjs-framework7: 4.4.7-1
libproxmox-acme-perl: 1.3.0
libproxmox-acme-plugins: 1.3.0
libpve-apiclient-perl: 3.2-1
libpve-common-perl: 7.0-9
libpve-http-server-perl: 4.0-2
libxdgmime-perl: 1.0-1
lvm2: 2.03.11-2.1
pmg-docs: 7.0-2
pmg-i18n: 2.5-1
pmg-log-tracker: 2.2.0-1
postgresql-13: 13.4-0+deb11u1
proxmox-mini-journalreader: 1.2-1
proxmox-spamassassin: 3.4.6-3
proxmox-widget-toolkit: 3.3-6
pve-xtermjs: 4.12.0-1

grep '' /etc/apt/sources.list /etc/apt/sources.list.d/*

/etc/apt/sources.list:#
/etc/apt/sources.list:deb http://ftp.de.debian.org/debian/ bullseye main non-free contrib
/etc/apt/sources.list:deb http://security.debian.org/debian-security bullseye-security main contrib non-free
/etc/apt/sources.list:
/etc/apt/sources.list:# bullseye-updates, previously known as 'volatile'
/etc/apt/sources.list:deb http://ftp.de.debian.org/debian/ bullseye-updates main contrib non-free
/etc/apt/sources.list:
/etc/apt/sources.list:# PMG pmg-no-subscription repository provided by proxmox.com,
/etc/apt/sources.list:# NOT recommended for production use
/etc/apt/sources.list:#deb http://download.proxmox.com/debian/pmg bullseye pmg-no-subscription
/etc/apt/sources.list.d/pmg-enterprise.list:deb https://enterprise.proxmox.com/debian/pmg bullseye pmg-enterprise

dpkg -l |grep -i postgres

ii libdbd-pg-perl 3.14.2-1+b1 amd64 Perl DBI driver for the PostgreSQL database server
ii libpq5:amd64 13.4-0+deb11u1 amd64 PostgreSQL C client library
ii postgresql 13+225 all object-relational SQL database (supported version)
ii postgresql-13 13.4-0+deb11u1 amd64 The World's Most Advanced Open Source Relational Database
ii postgresql-client-13 13.4-0+deb11u1 amd64 front-end programs for PostgreSQL 13
ii postgresql-client-common 225 all manager for multiple PostgreSQL client versions
ii postgresql-common 225 all PostgreSQL database-cluster manager

I already executed "apt install postgresql-13"

 

[Younex]

This message i get if i click ony an Mail-Filter related item in GUI:

DBI connect('dbname=Proxmox_ruledb;host=/var/run/postgresql;port=5432','www-data',...) failed: could not connect to server: No such file or directory (500)

 

[Younex]

Seems no postgresql config files and data exist?

locate postgresql.conf

/usr/lib/tmpfiles.d/postgresql.conf
/usr/share/postgresql/13/postgresql.conf.sample
/var/lib/pmg/templates/postgresql.conf.in

 

[Stoiko Ivanov]

is postgres running? (`ps auxwf |grep -i postg`)
is it listening on port 5432 (`ss -tlnp`)

the config file should get rendered by the templateing system and is in /etc/postgresql/13/main/

also the logs should indicate any issues with postgresql (check the journal with `journalctl -b` and the postgresql logfiles in /var/log/postgresql

I hope this helps!

 

[Younex]

Anyhow it is not running and i don´t find any config files.

How can i reinstall including db from scratch please?

 

[Younex]

root@mx0 ~ # service postgresql status
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Mon 2021-10-11 14:47:52 CEST; 40min ago
Main PID: 586 (code=exited, status=0/SUCCESS)
Tasks: 0 (limit: 77051)
Memory: 0B
CPU: 0
CGroup: /system.slice/postgresql.service

Oct 11 14:47:52 mx0 systemd[1]: Starting PostgreSQL RDBMS...
Oct 11 14:47:52 mx0 systemd[1]: Finished PostgreSQL RDBMS.

 

[Younex]

For any reason postgresql config files and directories not getting installed even if i deinstall it before.

 

[Stoiko Ivanov]

For any reason postgresql config files and directories not getting installed even if i deinstall it before.

if there are no fitting config files in /etc/postgresql/13/main/ - run `pmgconfig sync` - that should create it...

else as said - please check the journal and postgresql logs

 

[Younex]

Thanks. I ended up installing it from scratch and moved queue to new server.