[SOLVED] Error: delivery temporarily suspended

Y

Younex

Well-Known Member
Jan 30, 2018
93
22
48
45
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: 18
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`
 
Stoiko Ivanov said:
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`
Click to expand...
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.
 
Younex said:
For any reason postgresql config files and directories not getting installed even if i deinstall it before.
Click to expand...
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.
 
You must log in or register to reply here.
Top Bottom