Hello,
I have a OML version 1.10.4 running with the POSTGRESQL DB Server in a separate machine.
When I try to run the upgrade, the process failed with the following error:
++++++++++++++++++++++++++++++++++++++++++++++++++++++
TASK [omniapp_second : Add queuelog trigger to database] ***************************************************************************************************************
fatal: [cc2.telenews.com.ec]: FAILED! => {
"changed": true,
"cmd": "psql -c '\i /opt/omnileads/ominicontacto/reportes_app/sql/plperl/replace_insert_queue_log_ominicontacto_queue_log.sql'",
"delta": "0:00:00.011749",
"end": "2021-02-24 15:35:37.613396",
"rc": 2,
"start": "2021-02-24 15:35:37.601647"
}
STDERR:
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
MSG:
non-zero return code
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
My inventory file includes the following config lines related to PostGres:
postgres_database=omnileadscc
postgres_user=omnileadscc
postgres_password=Master2020
postgres_host=db.server.com.ec
postgres_port=5432
default_postgres_database=omnileadscc
default_postgres_user=postgres
default_postgres_password=Master2020
Obviously the local server has an entry in its /etc/hosts resolving db.server.com.ec to the POSTGRES DB Server IP address, and it is runing.
This server has previously upgraded from 1.8 to 1.10.4 without issue.
Any advice or direction to solve the issue?
Alfredo
