Dear all
Scenario: I am on an apache2 server, and I would like to connect to a
remote DB on target.host.name; I plan to migrate from the apache 2
server to the remote server.? On both, I run Debian linux with
postgresql 9.6
Problem: On the apache2 server, I shut down postgresql (after I imported
the cluster on the remote server).
While I can connect via
??? psql -d davical -U davical_app -w -h target.host.name -p 5432
davical when run from Apache2 cannot with the following setting in the
respectice /etc/davical/<config-file>
??? $c->pg_connect[] = "dbname=davical user=davical_app port=5432
host=target.host.name";
??? the following error is reported in the apache log
[Sun Nov 29 22:00:58.426582 2020] [:error] [pid 60889] [client
ip.add.re.ss:48560] Unable to connect to database: SQLSTATE[08006] [7]
could not connect to server: No such file or directory\n\tIs the server
running locally and accepting\n\tconnections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?
Unclear to me: if I start the postgresql server 9.6 on the apache2
server, davical is able to retrieve the data -- ignoring the
configuration settings
Questions:
1. Is my local configuration ignored in /etc/davical/<config-file> on
apache2 server?
1. How can I test, if the configuration is ignored?
2. Does davical mandatorily require a local Unix domain socket -- and
does not work with a remote db server?
3. Anything which I could take care of?
Thank you.
wbr
Lukas
Scenario: I am on an apache2 server, and I would like to connect to a
remote DB on target.host.name; I plan to migrate from the apache 2
server to the remote server.? On both, I run Debian linux with
postgresql 9.6
Problem: On the apache2 server, I shut down postgresql (after I imported
the cluster on the remote server).
While I can connect via
??? psql -d davical -U davical_app -w -h target.host.name -p 5432
davical when run from Apache2 cannot with the following setting in the
respectice /etc/davical/<config-file>
??? $c->pg_connect[] = "dbname=davical user=davical_app port=5432
host=target.host.name";
??? the following error is reported in the apache log
[Sun Nov 29 22:00:58.426582 2020] [:error] [pid 60889] [client
ip.add.re.ss:48560] Unable to connect to database: SQLSTATE[08006] [7]
could not connect to server: No such file or directory\n\tIs the server
running locally and accepting\n\tconnections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?
Unclear to me: if I start the postgresql server 9.6 on the apache2
server, davical is able to retrieve the data -- ignoring the
configuration settings
Questions:
1. Is my local configuration ignored in /etc/davical/<config-file> on
apache2 server?
1. How can I test, if the configuration is ignored?
2. Does davical mandatorily require a local Unix domain socket -- and
does not work with a remote db server?
3. Anything which I could take care of?
Thank you.
wbr
Lukas