On Saturday 08 April 2017 18:10:35 Joe Conway wrote: > On 04/08/2017 01:23 PM, John Iliffe wrote: > > On Saturday 08 April 2017 09:38:07 Adrian Klaver wrote: > >> So what if you change the connection to use -h localhost? > > > > Can you please expand on that request? I'm not sure where you want me > > to put that directive. I'm using the mod_php module in Apache. > > See the second example here: > > http://php.net/manual/en/function.pg-connect.php > > 8<------------- > $dbconn2 = pg_connect("host=localhost port=5432 dbname=mary"); > // connect to a database named "mary" on "localhost" at port "5432" > 8<------------- > > That will try to use a tcp connection on localhost instead of a unix > socket. > Thanks Joe. I Changed the pg_connect line in the script to: -------------------------- $db_handle = pg_connect('dbname=yrarc host=192.168.1.6 port=5432 user=xxxx password=xxxxxx'); --------------------------- Even though "localhost" is in the /etc/hosts file the lookup failed to resolve so I provided the full IP address. The error from Apache is: ------------------------------------------ [Sun Apr 09 14:08:16.178126 2017] [php7:warn] [pid 24917:tid 139671464015616] [client 192.168.1.10:59260] PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused\n\tIs the server running on host "192.168.1.6" and accepting\n\tTCP/IP connections on port 5432? in /httpd/iliffe/testfcgi.php on line 132 ------------------------------------------- PHP does not show anything in its log. > Another question I don't believe has been asked is, what does your > pg_hba.conf look like? Note here that I have deleted a number of production users and the associated databases from the file shown below for security reasons. The user marked "XXXXXXX" has a real name but isn't the one we are using to connect to the database, so the active line should be the "local all all password" line. The UID being used to connect IS in the password list and PSQL can still connect OK. The yrarc database does exist and contains several tables. -------------------------------------- # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only #local all all md5 local yrarc XXXXXXX trust local all all password #local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust --------------------------------------------- > > Joe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
