[SOLVED] Error: delivery temporarily suspended

Younex

Well-Known Member
Jan 30, 2018
93
22
48
44
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:

Code:
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:

Code:
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!
 

Attachments

  • 2021-10-11_12-25-22 (2).png
    2021-10-11_12-25-22 (2).png
    185.3 KB · Views: 13
Last edited:
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`
 
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.

Code:
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


Code:
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


Code:
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"
 
This message i get if i click ony an Mail-Filter related item in GUI:

Code:
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)
 
Seems no postgresql config files and data exist?

Code:
locate postgresql.conf
/usr/lib/tmpfiles.d/postgresql.conf
/usr/share/postgresql/13/postgresql.conf.sample
/var/lib/pmg/templates/postgresql.conf.in
 
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!
 
Anyhow it is not running and i don´t find any config files.

How can i reinstall including db from scratch please?
 
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.
 
For any reason postgresql config files and directories not getting installed even if i deinstall it before.
 
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
 
Thanks. I ended up installing it from scratch and moved queue to new server.
 

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!