baruwaproject / baruwa2

Baruwa 2.0
http://www.baruwa.org
GNU General Public License v3.0
21 stars 9 forks source link

Upgrade of database system fails (2.1.7-pre) #134

Closed rmoesbergen closed 6 years ago

rmoesbergen commented 6 years ago

While testing the upgrade of a backend system with role 'database', the following salt error occurs:

Jan 23 14:46:00 lnx2421vm baruwa-setup[10234]: Processing state pkg.installed[base-plugins] failed => One or more requisite failed: nrpe.nrpe-create-baruwa.cfg Jan 23 14:46:00 lnx2421vm baruwa-setup[10234]: Salt Engine reported error(s)#012Processing state postgres_user.present[postgresql-create-postgres-user] failed => Failed to create user postgresTraceback (most recent call last):#012 File "/usr/lib/python2.6/site-packages/baruwasetup/lib/application.py", line 825, in run#012 self.run_engine(2)#012 File "/usr/lib/python2.6/site-packages/baruwasetup/lib/application.py", line 758, in run_engine#012 self._run_salt_engine(pass_num)#012 File "/usr/lib/python2.6/site-packages/baruwasetup/lib/application.py", line 284, in _run_salt_engine#012 raise BSE("Salt Engine reported error(s)\n{0}".format(errors))#012BaruwaSetupException: Salt Engine reported error(s)#012Processing state postgres_user.present[postgresql-create-postgres-user] failed => Failed to create user postgres Jan 23 14:47:28 lnx2421vm baruwa-setup[11343]: Loading settings from DB Jan 23 14:47:59 lnx2421vm baruwa-setup[11343]: Checking the System Locale Jan 23 14:47:59 lnx2421vm baruwa-setup[11343]: System Locale already set to en_US.UTF-8 Jan 23 14:48:02 lnx2421vm baruwa-setup[11343]: Checking the System Hostname Jan 23 14:48:03 lnx2421vm baruwa-setup[11343]: System Hostname already set to: lnx2421vm.internal.asp4all.nl Jan 23 14:48:06 lnx2421vm baruwa-setup[11343]: Checking SELINUX configuration Jan 23 14:48:06 lnx2421vm baruwa-setup[11343]: SELINUX is already disabled Jan 23 14:48:06 lnx2421vm baruwa-setup[11343]: Checking Baruwa Network registration Jan 23 14:48:07 lnx2421vm baruwa-setup[11343]: System is active on the Baruwa Network Jan 23 14:48:10 lnx2421vm baruwa-setup[11343]: Running Yum update Jan 23 14:48:10 lnx2421vm baruwa-setup[11343]: No updates found Jan 23 14:48:10 lnx2421vm baruwa-setup[11343]: Generating Salt States Jan 23 14:48:10 lnx2421vm baruwa-setup[11343]: Creating Salt top state file Jan 23 14:48:10 lnx2421vm baruwa-setup[11343]: Salt top state file created Jan 23 14:48:10 lnx2421vm baruwa-setup[11343]: Running Salt Engine Pass: 1 Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.cmdmod Command '['/usr/bin/psql', '--no-align', '--no-readline', '--no-psqlrc', '--no-password', '--username', 'postgres', '--host', 'localhost4', '--port', '7432', '--dbname', 'postgres', '-c', "SELECT setting FROM pg_catalog.pg_settings WHERE name = 'server_version'", '-t']' failed with return code: 2 Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.cmdmod stderr: psql: server closed the connection unexpectedly#012#011This probably means the server terminated abnormally#012#011before or while processing the request. Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.cmdmod retcode: 2 Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.postgres Error connecting to Postgresql server Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.postgres Could not retrieve Postgres version. Is Postgresql server running? Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.postgres Could not retrieve Postgres role. Is Postgres running? Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.cmdmod Command '['/usr/bin/psql', '--no-align', '--no-readline', '--no-psqlrc', '--no-password', '--username', 'postgres', '--host', 'localhost4', '--port', '7432', '--dbname', 'postgres', '-c', "SELECT setting FROM pg_catalog.pg_settings WHERE name = 'server_version'", '-t']' failed with return code: 2 Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.cmdmod stderr: psql: server closed the connection unexpectedly#012#011This probably means the server terminated abnormally#012#011before or while processing the request. Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.cmdmod retcode: 2 Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.postgres Error connecting to Postgresql server Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.postgres Could not retrieve Postgres version. Is Postgresql server running? Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.postgres Could not retrieve Postgres role. Is Postgres running? Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.cmdmod Command '['/usr/bin/psql', '--no-align', '--no-readline', '--no-psqlrc', '--no-password', '--username', 'postgres', '--host', 'localhost4', '--port', '7432', '--dbname', 'postgres', '-c', 'CREATE ROLE "postgres" WITH INHERIT SUPERUSER LOGIN ENCRYPTED PASSWORD \'md5500a38196c7b5bddd9c3c96eba2bb4ad\'']' failed with return code: 2 Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.cmdmod stderr: psql: server closed the connection unexpectedly#012#011This probably means the server terminated abnormally#012#011before or while processing the request. Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.cmdmod retcode: 2 Jan 23 14:48:15 lnx2421vm salt.loaded.int.module.postgres Error connecting to Postgresql server Jan 23 14:48:15 lnx2421vm salt.state Failed to create user postgres Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.run[disable-selinux] successfully => unless execution succeeded Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[disable-selinux-conf] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[hostname-update-hosts] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[hostname-update-etc-sysconfig-network] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[set-timezone] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.wait[set-tzdata] successfully => Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.wait[reload-rsyslog] successfully => Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[misc-pkgs] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state sysctl.present[misc-create-oom-sysctl] successfully => Sysctl value vm.overcommit_memory = 0 is already set Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.absent[misc-create-baruwa-version] successfully => File /usr/local/bin/baruwa-version is not present Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[misc-fix-iptables-rules] successfully => unless execution succeeded Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.wait[misc-reload-iptables-service] successfully => Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[misc-config-baruwa-logs] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.absent[misc-create-baruwa-logs] successfully => File /usr/local/bin/baruwa-logs is not present Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[cronie] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state service.running[cronie] successfully => The service crond is already running Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.removed[ntp] successfully => All specified packages are already absent Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.removed[ntpdate] successfully => All specified packages are already absent Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.absent[ntpdate-cron] successfully => File /etc/cron.daily/ntp is not present Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[chrony] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state service.running[chrony] successfully => The service chronyd is already running Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[yum-cron] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[yum-update-config] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[yum-zap-centos] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state service.running[yum-cron] successfully => The service yum-cron is already running Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[git] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[etckeeper] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.run[etckeeper-init] successfully => /etc/.git exists Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state git.config_set[etckeeper-git-config-username] successfully => 'user.name' is already set to 'Etckeeper Backups' Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state git.config_set[etckeeper-git-config-email] successfully => 'user.email' is already set to 'root@lnx2421vm.internal.asp4all.nl' Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.run[etckeeper-git-initial-commit] successfully => unless execution succeeded Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[backupninja] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[backupninja-create-home] successfully => Directory /var/backups is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[backupninja-create-fs-conf] successfully => File /etc/backup.d/20-server-fs.rdiff exists with proper permissions. No changes made. Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[backupninja-add-baruwasetup-backup] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[backupninja-create-pgsql-conf] successfully => File /etc/backup.d/10-baruwa-database.pgsql exists with proper permissions. No changes made. Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[backupninja-uncomment-sysconfig-pghost] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[backupninja-config-sysconfig] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[backupninja-change-pgsql-location] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[haveged] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state service.running[haveged] successfully => The service haveged is already running Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-create-ca-dir] successfully => Directory /etc/pki/BaruwaCA is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-create-ca-key-dir] successfully => Directory /etc/pki/BaruwaCA/private is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-create-ca-certs-dir] successfully => Directory /etc/pki/BaruwaCA/certs is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-create-certs-home] successfully => Directory /etc/pki/baruwa is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-create-certs-cert-dir] successfully => Directory /etc/pki/baruwa/certs is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-create-certs-csr-dir] successfully => Directory /etc/pki/baruwa/csr is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-create-certs-dhparams-dir] successfully => Directory /etc/pki/baruwa/dhparams is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.rename[ssl-migrate-mail-dhparams] successfully => Source file "/etc/pki/dhparams-mail.pem" has already been moved out of place Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.run[ssl-make-mail-dhparams] successfully => /etc/pki/baruwa/dhparams/dhparams-mail.pem exists Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-create-certs-key-dir] successfully => Directory /etc/pki/baruwa/private is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.private_key_managed[ssl-create-host-key] successfully => File /etc/pki/baruwa/private/lnx2421vm.internal.asp4all.nl.key is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.private_key_managed[ssl-create-host-backup-key] successfully => File /etc/pki/baruwa/private/lnx2421vm.internal.asp4all.nl-bkup.key is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state group.present[ssl-ca-create-consul-group] successfully => Group consul is present and up to date Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state user.present[ssl-ca-create-consul-user] successfully => User consul is present and up to date Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.rename[ssl-ca-rename-key] successfully => Source file "/etc/pki/BaruwaCA/private/BaruwaCA_ca_cert.key" has already been moved out of place Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.private_key_managed[ssl-ca-create-key] successfully => File /etc/pki/BaruwaCA/private/BaruwaCA.key is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.rename[ssl-ca-rename-cert] successfully => Source file "/etc/pki/BaruwaCA/BaruwaCA_ca_cert.crt" has already been moved out of place Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.certificate_managed[ssl-ca-create-cert] successfully => File /etc/pki/BaruwaCA/certs/BaruwaCA.pem is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.run[ssl-ca-enable-update-ca-trust] successfully => unless execution succeeded Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.symlink[ssl-ca-link-cert-anchor] successfully => Symlink /etc/pki/ca-trust/source/anchors/BaruwaCA.pem is present and owned by root:root Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.run[ssl-ca-enable-trust] successfully => unless execution succeeded Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-database-create-base] successfully => Directory /etc/pki/database-ca is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-database-create-cert-dir] successfully => Directory /etc/pki/database-ca/certs is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-database-create-key-dir] successfully => Directory /etc/pki/database-ca/private is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-database-create-csr-dir] successfully => Directory /etc/pki/database-ca/csr is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-database-create-issued-dir] successfully => Directory /etc/pki/database-ca/issued is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.private_key_managed[ssl-ca-database-create-key] successfully => File /etc/pki/database-ca/private/database-ca.key is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state acl.present[ssl-ca-database-key-set-dir-acl] successfully => Permissions are in the desired state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state acl.present[ssl-ca-database-key-set-acl] successfully => Permissions are in the desired state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.csr_managed[ssl-ca-database-create-csr] successfully => File /etc/pki/database-ca/csr/database-ca.csr is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.certificate_managed[ssl-ca-database-create-cert] successfully => File /etc/pki/database-ca/certs/database-ca.pem is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-stunnel-create-base] successfully => Directory /etc/pki/stunnel-ca is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-stunnel-create-cert-dir] successfully => Directory /etc/pki/stunnel-ca/certs is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-stunnel-create-key-dir] successfully => Directory /etc/pki/stunnel-ca/private is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-stunnel-create-csr-dir] successfully => Directory /etc/pki/stunnel-ca/csr is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-stunnel-create-issued-dir] successfully => Directory /etc/pki/stunnel-ca/issued is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.private_key_managed[ssl-ca-stunnel-create-key] successfully => File /etc/pki/stunnel-ca/private/stunnel-ca.key is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state acl.present[ssl-ca-stunnel-key-set-dir-acl] successfully => Permissions are in the desired state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state acl.present[ssl-ca-stunnel-key-set-acl] successfully => Permissions are in the desired state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.csr_managed[ssl-ca-stunnel-create-csr] successfully => File /etc/pki/stunnel-ca/csr/stunnel-ca.csr is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.certificate_managed[ssl-ca-stunnel-create-cert] successfully => File /etc/pki/stunnel-ca/certs/stunnel-ca.pem is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-frontend-create-base] successfully => Directory /etc/pki/frontend-ca is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-frontend-create-cert-dir] successfully => Directory /etc/pki/frontend-ca/certs is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-frontend-create-key-dir] successfully => Directory /etc/pki/frontend-ca/private is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-frontend-create-csr-dir] successfully => Directory /etc/pki/frontend-ca/csr is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[ssl-ca-frontend-create-issued-dir] successfully => Directory /etc/pki/frontend-ca/issued is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.private_key_managed[ssl-ca-frontend-create-key] successfully => File /etc/pki/frontend-ca/private/frontend-ca.key is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state acl.present[ssl-ca-frontend-key-set-dir-acl] successfully => Permissions are in the desired state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state acl.present[ssl-ca-frontend-key-set-acl] successfully => Permissions are in the desired state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.csr_managed[ssl-ca-frontend-create-csr] successfully => File /etc/pki/frontend-ca/csr/frontend-ca.csr is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.certificate_managed[ssl-ca-frontend-create-cert] successfully => File /etc/pki/frontend-ca/certs/frontend-ca.pem is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[consul] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[consul-create-certs-home] successfully => Directory /etc/pki/consul is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[consul-create-certs-revoked-dir] successfully => Directory /etc/pki/consul/issued is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[consul-create-certs-cert-dir] successfully => Directory /etc/pki/consul/certs is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[consul-create-certs-csr-dir] successfully => Directory /etc/pki/consul/csr is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[consul-create-certs-key-dir] successfully => Directory /etc/pki/consul/private is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.private_key_managed[consul-create-host-key] successfully => File /etc/pki/consul/private/lnx2421vm.dc1.consul.key is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.csr_managed[consul-create-csr] successfully => File /etc/pki/consul/csr/lnx2421vm.dc1.consul.csr is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.certificate_managed[consul-create-cert] successfully => File /etc/pki/consul/certs/lnx2421vm.dc1.consul.pem is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[consul-create-config] successfully => File /etc/consul/00-base.json is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state service.running[consul] successfully => The service consul is already running Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state consul.kv_cert[consul-store-ca-cert-BaruwaCA] successfully => The file has already been stored Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state consul.kv_cert[consul-store-ca-cert-database-ca] successfully => The file has already been stored Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state consul.kv_cert[consul-store-ca-cert-frontend-ca] successfully => The file has already been stored Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state consul.kv_cert[consul-store-ca-cert-stunnel-ca] successfully => The file has already been stored Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state consul.acl_present[consul-create-anonymous-token] successfully => ACL Anonymous Token is already in correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state consul.acl_present[consul-create-agent-token] successfully => ACL agent-token-lnx2421vm.internal.asp4all.nl is already in correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.run[consul] successfully => State was not run because none of the onchanges reqs changed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state consul.acl_present[consul-create-patroni-token] successfully => ACL patroni-token-lnx2421vm.internal.asp4all.nl is already in correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state consul.acl_present[consul-create-fabio-token] successfully => ACL fabio-token-lnx2421vm.internal.asp4all.nl is already in correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[fabio] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[fabio-update-config] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state service.running[fabio] successfully => The service fabio is already running Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[exim] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[exim-service] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.removed[exim-other-mtas] successfully => All specified packages are already absent Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[exim-create-conf] successfully => File /etc/exim/exim.conf is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state service.running[exim-service] successfully => The service exim is already running Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state alias.present[exim-create-alias] successfully => Alias root already present Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[exim-create-ulimits] successfully => File /etc/security/limits.d/exim.conf is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[postgresql-server-pkgs] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state service.disabled[postgresql-server-pkgs] successfully => Service postgresql is already disabled, and is in the desired state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[postgresql-pg_repack-script] successfully => File /usr/sbin/repackdb.sh is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[postgresql-pg_repack-cron] successfully => File /etc/cron.d/pg_repack is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.rename[postgresql-rename-baruwa-conf] successfully => Source file "/etc/postgresql/10/99baruwa.conf" has already been moved out of place Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[postgresql-create-baruwa-conf] successfully => File /etc/postgresql/10/90baruwa.conf exists with proper permissions. No changes made. Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.script[postgresql-migrate-db] successfully => /var/lib/pgsql/analyze_new_cluster.sh exists Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state postgres_datadir.present[postgresql-initdb] successfully => unless execution succeeded Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[postgresql-create-profile] successfully => File /var/lib/pgsql/.pgsql_profile is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[postgresql-pg_hba.conf] successfully => File /var/lib/pgsql/10/data/pg_hba.conf is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[postgresql-sysconfig] successfully => File /etc/sysconfig/pgsql/postgresql is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[postgresql-tune] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[postgresql-pgpass] successfully => File /var/lib/pgsql/.pgpass is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[postgresql-create-certs-home] successfully => Directory /etc/pki/postgresql is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[postgresql-create-certs-revoked-dir] successfully => Directory /etc/pki/postgresql/issued is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[postgresql-create-certs-cert-dir] successfully => Directory /etc/pki/postgresql/certs is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[postgresql-create-certs-csr-dir] successfully => Directory /etc/pki/postgresql/csr is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[postgresql-create-certs-key-dir] successfully => Directory /etc/pki/postgresql/private is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.private_key_managed[postgresql-create-host-key] successfully => File /etc/pki/postgresql/private/lnx2421vm.internal.asp4all.nl.key is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.csr_managed[postgresql-create-csr] successfully => File /etc/pki/postgresql/csr/lnx2421vm.internal.asp4all.nl.csr is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.certificate_managed[postgresql-create-cert] successfully => File /etc/pki/postgresql/certs/lnx2421vm.internal.asp4all.nl.pem is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.private_key_managed[postgresql-client-create-key] successfully => File /etc/pki/postgresql/private/lnx2421vm.internal.asp4all.nl-client.key is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.symlink[postgresql-client-link-key] successfully => Symlink /etc/pki/postgresql/private/postgresql-client.key is present and owned by root:root Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.csr_managed[postgresql-client-create-csr] successfully => File /etc/pki/postgresql/csr/lnx2421vm.internal.asp4all.nl-client.csr is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state x509.certificate_managed[postgresql-client-create-cert] successfully => File /etc/pki/postgresql/certs/lnx2421vm.internal.asp4all.nl-client.pem is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.symlink[postgresql-client-link-cert] successfully => Symlink /etc/pki/postgresql/certs/postgresql-client.pem is present and owned by root:root Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[postgresql-set-ssl-options] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[patroni] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[patroni-create-bash-profile] successfully => File /etc/profile.d/postgresql.sh is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state environ.setenv[patroni-set-bash-env] successfully => Environ values were already set with the correct values Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[patroni-create-callback-config] successfully => File /etc/sysconfig/patroni-callbacks exists with proper permissions. No changes made. Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[patroni-configure-callback] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[patroni-create-callback.sh] successfully => File /usr/local/bin/patroni-callback.sh is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[patroni-create-softdog-config] successfully => File /etc/sysconfig/modules/softdog.modules is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[patroni-create-udev-config] successfully => File /etc/udev/rules.d/90-watchdog.rules is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.run[patroni-reload-udev] successfully => State was not run because none of the onchanges reqs changed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state kmod.present[patroni-load-softdog] successfully => Kernel module softdog is already present Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[patroni-create-archive-dir] successfully => Directory /var/lib/pgsql/10/wal_archive is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[patroni-create-config] successfully => File /etc/patroni/patroni.yml is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state service.running[patroni] successfully => The service patroni is already running Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.run[patroni-reload-cluster] successfully => State was not run because none of the onchanges reqs changed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state patroni.register_services[patroni-register-services] successfully => The patroni service(s) are already registered Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[patroni-set-callback-log-perms] successfully => File /var/log/patroni/callback.log exists with proper permissions. No changes made. Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[pgbouncer] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state cmd.run[pgbouncer-create-pg-auth-file] successfully => /var/lib/pgsql/10/data/global/pg_auth exists Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.directory[pgbouncer-log-dir] successfully => Directory /var/log/pgbouncer is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-unix-socket-dir] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-stats-users] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-server-check-query] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-server-check-delay] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-log-connections] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-log-disconnections] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-log-pooler-errors] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state augeas.change[pgbouncer.ini] successfully => No changes made Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state service.running[pgbouncer] successfully => The service pgbouncer is already running Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-client-tls-sslmode] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-client-tls-ca-file] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-client-tls-key-file] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-client-tls-cert-file] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-client-tls-ciphers] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.uncomment[pgbouncer-unc-client-tls-protocols] successfully => Pattern already uncommented Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.managed[postgresql-root-pgpass] successfully => File /root/.pgpass is in the correct state Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[postgresql] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.installed[postgresql-python-psycopg2] successfully => All specified packages are already installed Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_user.present[postgresql-create-postgres-user] failed => Failed to create user postgres Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_user.present[postgres-create-replication-user] failed => One or more requisite failed: postgresql.postgresql-create-postgres-user Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_user.present[postgresql-create-baruwa-user] failed => One or more requisite failed: postgresql.postgres-create-replication-user Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_user.present[postgresql-create-bayes-user] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-user Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_user.present[postgresql-create-sphinx-user] failed => One or more requisite failed: postgresql.postgresql-create-bayes-user Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_database.present[postgresql-create-baruwa-database] failed => One or more requisite failed: postgresql.postgresql-create-sphinx-user Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_language.present[postgresql-create-lang-plpgsql] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-database Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_language.present[postgresql-create-lang-plpythonu] failed => One or more requisite failed: postgresql.postgresql-create-lang-plpgsql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_extension.present[postgresql-create-extension-pg_repack] failed => One or more requisite failed: postgresql.postgresql-create-lang-plpythonu Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-execute-functions.sql] failed => One or more requisite failed: postgresql.postgresql-create-extension-pg_repack Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-execute-upgrade-functions.sql] failed => One or more requisite failed: postgresql.postgresql-execute-functions.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-txrep-table] failed => One or more requisite failed: postgresql.postgresql-execute-upgrade-functions.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-bayes-table] failed => One or more requisite failed: postgresql.postgresql-create-txrep-table Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-baruwa-tables] failed => One or more requisite failed: postgresql.postgresql-create-bayes-table Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-baruwa-functions] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-tables Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-baruwa-integration] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-functions Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-baruwa-policysettings-default-data] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-integration Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-baruwa-servers-default-data] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-policysettings-default-data Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-fix-baruwa-servers-default-data] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-servers-default-data Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-dmarc-tables] failed => One or more requisite failed: postgresql.postgresql-fix-baruwa-servers-default-data Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-baruwa-configurations-default-data] failed => One or more requisite failed: postgresql.postgresql-create-dmarc-tables Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.run[postgresql-update-pg-auth-file] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-user, postgresql.postgresql-create-postgres-user, postgresql.postgresql-create-sphinx-user, postgresql.postgresql-create-bayes-user Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-search_counters_id_seq] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-configurations-default-data Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-bayes_token] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-search_counters_id_seq Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-bayes_vars] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-bayes_token Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-txrep] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-bayes_vars Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_domains] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-txrep Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_ipaddr] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_domains Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_messages] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_ipaddr Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_reporters] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_messages Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_signatures] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_reporters Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_requests] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_signatures Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-bayes_seen] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_requests Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-bayes_expire] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-bayes_seen Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-bayes_global_vars] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-bayes_expire Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_domains_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-bayes_global_vars Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_ipaddr_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_domains_id_seq Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_messages_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_ipaddr_id_seq Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_reporters_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_messages_id_seq Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_signatures_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_reporters_id_seq Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_requests_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_signatures_id_seq Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-bayes_vars_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_requests_id_seq Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-search_counters] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-bayes_vars_id_seq Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-indexer_counters] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-search_counters Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-indexer_killlist] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-indexer_counters Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-lists] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-indexer_killlist Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-organizations] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-lists Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-organizations_admins] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-organizations Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-archive] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-organizations_admins Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-maildomains] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-archive Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-domain_owners] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-maildomains Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-domain_users] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-domain_owners Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-users] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-domain_users Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-auditlog] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-users Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-messages] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-auditlog Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-sarules] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-messages Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-remove-incorrect-config] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-sarules Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade202.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-remove-incorrect-config Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade205.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade202.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade206.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade205.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade207.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade206.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade207-2.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade207.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade211.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade207-2.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade213.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade211.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade214.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade213.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade215.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade214.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.run[postgresql-upgrade215-2.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade215.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade216.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade215-2.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade217.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade216.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state pkg.installed[nrpe] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade217.sql Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state file.comment[nrpe-comment-allowed-hosts] failed => One or more requisite failed: nrpe.nrpe Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state augeas.change[nrpe-update-conf] failed => One or more requisite failed: nrpe.nrpe-comment-allowed-hosts Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state file.managed[nrpe-create-baruwa.cfg] failed => One or more requisite failed: nrpe.nrpe-update-conf Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state service.running[nrpe] failed => One or more requisite failed: nrpe.nrpe, nrpe.nrpe-comment-allowed-hosts, nrpe.nrpe-create-baruwa.cfg Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processing state pkg.installed[base-plugins] failed => One or more requisite failed: nrpe.nrpe-create-baruwa.cfg Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state pkg.removed[net-snmp] successfully => All specified packages are already absent Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Processed state file.absent[net-snmp-rm-passwd] successfully => File /var/lib/net-snmp/passwd is not present Jan 23 14:48:16 lnx2421vm baruwa-setup[11343]: Running Salt Engine Pass: 2 Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.cmdmod Command '['/usr/bin/psql', '--no-align', '--no-readline', '--no-psqlrc', '--no-password', '--username', 'postgres', '--host', 'localhost4', '--port', '7432', '--dbname', 'postgres', '-c', "SELECT setting FROM pg_catalog.pg_settings WHERE name = 'server_version'", '-t']' failed with return code: 2 Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.cmdmod stderr: psql: server closed the connection unexpectedly#012#011This probably means the server terminated abnormally#012#011before or while processing the request. Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.cmdmod retcode: 2 Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.postgres Error connecting to Postgresql server Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.postgres Could not retrieve Postgres version. Is Postgresql server running? Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.postgres Could not retrieve Postgres role. Is Postgres running? Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.cmdmod Command '['/usr/bin/psql', '--no-align', '--no-readline', '--no-psqlrc', '--no-password', '--username', 'postgres', '--host', 'localhost4', '--port', '7432', '--dbname', 'postgres', '-c', "SELECT setting FROM pg_catalog.pg_settings WHERE name = 'server_version'", '-t']' failed with return code: 2 Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.cmdmod stderr: psql: server closed the connection unexpectedly#012#011This probably means the server terminated abnormally#012#011before or while processing the request. Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.cmdmod retcode: 2 Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.postgres Error connecting to Postgresql server Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.postgres Could not retrieve Postgres version. Is Postgresql server running? Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.postgres Could not retrieve Postgres role. Is Postgres running? Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.cmdmod Command '['/usr/bin/psql', '--no-align', '--no-readline', '--no-psqlrc', '--no-password', '--username', 'postgres', '--host', 'localhost4', '--port', '7432', '--dbname', 'postgres', '-c', 'CREATE ROLE "postgres" WITH INHERIT SUPERUSER LOGIN ENCRYPTED PASSWORD \'md5500a38196c7b5bddd9c3c96eba2bb4ad\'']' failed with return code: 2 Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.cmdmod stderr: psql: server closed the connection unexpectedly#012#011This probably means the server terminated abnormally#012#011before or while processing the request. Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.cmdmod retcode: 2 Jan 23 14:48:21 lnx2421vm salt.loaded.int.module.postgres Error connecting to Postgresql server Jan 23 14:48:21 lnx2421vm salt.state Failed to create user postgres Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_user.present[postgresql-create-postgres-user] failed => Failed to create user postgres Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_user.present[postgres-create-replication-user] failed => One or more requisite failed: postgresql.postgresql-create-postgres-user Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_user.present[postgresql-create-baruwa-user] failed => One or more requisite failed: postgresql.postgres-create-replication-user Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_user.present[postgresql-create-bayes-user] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-user Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_user.present[postgresql-create-sphinx-user] failed => One or more requisite failed: postgresql.postgresql-create-bayes-user Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_database.present[postgresql-create-baruwa-database] failed => One or more requisite failed: postgresql.postgresql-create-sphinx-user Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_language.present[postgresql-create-lang-plpgsql] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-database Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_language.present[postgresql-create-lang-plpythonu] failed => One or more requisite failed: postgresql.postgresql-create-lang-plpgsql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_extension.present[postgresql-create-extension-pg_repack] failed => One or more requisite failed: postgresql.postgresql-create-lang-plpythonu Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-execute-functions.sql] failed => One or more requisite failed: postgresql.postgresql-create-extension-pg_repack Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-execute-upgrade-functions.sql] failed => One or more requisite failed: postgresql.postgresql-execute-functions.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-txrep-table] failed => One or more requisite failed: postgresql.postgresql-execute-upgrade-functions.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-bayes-table] failed => One or more requisite failed: postgresql.postgresql-create-txrep-table Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-baruwa-tables] failed => One or more requisite failed: postgresql.postgresql-create-bayes-table Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-baruwa-functions] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-tables Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-baruwa-integration] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-functions Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-baruwa-policysettings-default-data] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-integration Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-baruwa-servers-default-data] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-policysettings-default-data Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-fix-baruwa-servers-default-data] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-servers-default-data Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-dmarc-tables] failed => One or more requisite failed: postgresql.postgresql-fix-baruwa-servers-default-data Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-create-baruwa-configurations-default-data] failed => One or more requisite failed: postgresql.postgresql-create-dmarc-tables Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.run[postgresql-update-pg-auth-file] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-user, postgresql.postgresql-create-postgres-user, postgresql.postgresql-create-sphinx-user, postgresql.postgresql-create-bayes-user Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-search_counters_id_seq] failed => One or more requisite failed: postgresql.postgresql-create-baruwa-configurations-default-data Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-bayes_token] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-search_counters_id_seq Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-bayes_vars] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-bayes_token Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-txrep] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-bayes_vars Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_domains] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-txrep Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_ipaddr] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_domains Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_messages] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_ipaddr Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_reporters] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_messages Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_signatures] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_reporters Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_requests] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_signatures Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-bayes_seen] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_requests Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-bayes_expire] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-bayes_seen Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-bayes_global_vars] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-bayes_expire Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_domains_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-bayes_global_vars Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_ipaddr_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_domains_id_seq Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_messages_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_ipaddr_id_seq Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_reporters_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_messages_id_seq Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_signatures_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_reporters_id_seq Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-dmarc_requests_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_signatures_id_seq Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-bayes-grants-on-bayes_vars_id_seq] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-dmarc_requests_id_seq Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-search_counters] failed => One or more requisite failed: postgresql.grants.postgresql-create-bayes-grants-on-bayes_vars_id_seq Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-indexer_counters] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-search_counters Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-indexer_killlist] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-indexer_counters Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-lists] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-indexer_killlist Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-organizations] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-lists Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-organizations_admins] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-organizations Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-archive] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-organizations_admins Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-maildomains] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-archive Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-domain_owners] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-maildomains Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-domain_users] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-domain_owners Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-users] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-domain_users Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-auditlog] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-users Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-messages] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-auditlog Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state postgres_privileges.present[postgresql-create-sphinx-grants-on-sarules] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-messages Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-remove-incorrect-config] failed => One or more requisite failed: postgresql.grants.postgresql-create-sphinx-grants-on-sarules Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade202.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-remove-incorrect-config Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade205.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade202.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade206.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade205.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade207.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade206.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade207-2.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade207.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade211.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade207-2.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade213.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade211.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade214.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade213.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade215.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade214.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.run[postgresql-upgrade215-2.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade215.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade216.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade215-2.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state cmd.script[postgresql-upgrade217.sql] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade216.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state pkg.installed[nrpe] failed => One or more requisite failed: postgresql.upgrades.postgresql-upgrade217.sql Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state file.comment[nrpe-comment-allowed-hosts] failed => One or more requisite failed: nrpe.nrpe Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state augeas.change[nrpe-update-conf] failed => One or more requisite failed: nrpe.nrpe-comment-allowed-hosts Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state file.managed[nrpe-create-baruwa.cfg] failed => One or more requisite failed: nrpe.nrpe-update-conf Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state service.running[nrpe] failed => One or more requisite failed: nrpe.nrpe, nrpe.nrpe-comment-allowed-hosts, nrpe.nrpe-create-baruwa.cfg Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Processing state pkg.installed[base-plugins] failed => One or more requisite failed: nrpe.nrpe-create-baruwa.cfg Jan 23 14:48:21 lnx2421vm baruwa-setup[11343]: Salt Engine reported error(s)#012Processing state postgres_user.present[postgresql-create-postgres-user] failed => Failed to create user postgresTraceback (most recent call last):#012 File "/usr/lib/python2.6/site-packages/baruwasetup/lib/application.py", line 825, in run#012 self.run_engine(2)#012 File "/usr/lib/python2.6/site-packages/baruwasetup/lib/application.py", line 758, in run_engine#012 self._run_salt_engine(pass_num)#012 File "/usr/lib/python2.6/site-packages/baruwasetup/lib/application.py", line 284, in _run_salt_engine#012 raise BSE("Salt Engine reported error(s)\n{0}".format(errors))#012BaruwaSetupException: Salt Engine reported error(s)#012Processing state postgres_user.present[postgresql-create-postgres-user] failed => Failed to create user postgres

Here's what I did:

  1. Cloned our existing (2.1.5) database server
  2. Ran baruwa-setup and filled-out some additional settings that are now required, like company name, admin site settings, etc. Note that I did not enable 'clustering'
  3. Database was converted from 8.4 to 10.x, which worked fine. Took about one hour for a 60GB database.
  4. Ran baruwa-setup again, because I want this server to be a bootstrap server, so I don't have to re-enter all the settings everywhere.
  5. Filled out even more additional settings (shared quarantine and various front-end settings).
  6. Salt ran, but produced the error above. Retried, but with the same result.

Also: the settings I entered were not saved, so to retry I had to re-enter them all again :(

Any idea what's going on? Should I even enable 'clustering' even if I want to have only one database server?

akissa commented 6 years ago

The credentials in baruwa-setup are incorrect ? baruwa-setup is not able to connect to the db using those credentials it seems.

tomtakan commented 6 years ago

On 23 Jan 2018, at 15:54, Ronald Moesbergen notifications@github.com wrote:

• Ran baruwa-setup again, because I want this server to be a bootstrap server, so I don't have to re-enter all the settings everywhere.

Was the system operational before you converted it to a bootstrap server ?

rmoesbergen commented 6 years ago

I just re-entered the credentials, same error. However, the system had previously completed a succesful baruwa-setup run with version 2.1.7, so I think the creds are correct.

The command it tries to execute is actually: /usr/bin/psql --no-align --no-readline --no-psqlrc --no-password --username postgres --host localhost4 --port 7432 --dbname postgres -c "SELECT setting FROM pg_catalog.pg_settings WHERE name = 'server_version'" -t

So it expects to connect on port 7432 with user postgres and no password. The error is:

psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

Maybe an SSL error prevents this connection? I don't see anything in the postgresql server logs though. But: If I change the port to '5432' it works just fine... (??)

rmoesbergen commented 6 years ago

On port 7432 something called 'fabio' is listening. The logs say:

2018/01/23 15:21:34 [WARN] No route for :7432 2018/01/23 15:22:54 [WARN] No route for :7432 2018/01/23 15:24:03 [WARN] No route for :7432 2018/01/23 15:24:18 [WARN] No route for :7432 2018/01/23 15:24:29 [WARN] No route for :7432 2018/01/23 15:24:59 [WARN] No route for :7432 2018/01/23 15:25:07 [WARN] No route for :7432 2018/01/23 15:25:15 [WARN] No route for :7432

So I guess that's why the connection is dropped. The question now is: why is there no route?

akissa commented 6 years ago

Okay i think, i could be related to wanting to run a bootstrap on a non clustered backend. We will try and replicate this.

akissa commented 6 years ago

Could you email us the full log (/var/log/messages) from the point you changed the activation key to the error.

akissa commented 6 years ago

Thanks for the logs and reporting this. I was able to replicate it. A fix has been committed and updated packages issued. Running baruwa-setup again should resolve the issue. Feel free to reopen this if you run into an issue

rmoesbergen commented 6 years ago

Yes, it works now, thanks!