Still failing. Here's what I did:
1. Edited the pg_hba.conf file and added the line:
host all all
127.0.0.1 255.255.255.255 trust
fossy@fosstest:/etc/postgresql/8.1/main$ psql -d fossology -U fossy -h localhost
Welcome to psql 8.1.10, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
2. Restarted PostgreSQL...
3. Ran the dbcheck command and received the same error:
root@fosstest:/fossology/fossology-0.6.0# ./install/usr/local/fossology/test.d/dbcheck
ERROR: Unable to connect to the database
Connection string: 'dbname=fossology local=localhost user=fossy password=fossy'
Connection status: '1'
ERROR: Failed to open database
Arrgh.
On Feb 7, 2008 9:19 AM, Kurt Schroeder <
kschroe@gmail.com> wrote:
No, it didn't work! When I ran:
fossy@fosstest:/fossology/fossology-0.6.0$ psql -d fossology -U fossy -h localhost
I got the error:
psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "fossy", database "fossology", SSL off
I will work on resolving this. Thank you!!!
- Kurt On Feb 6, 2008 5:25 PM, Tom Lane <
tgl@sss.pgh.pa.us> wrote:
> Yes, I can:
> root@ubuntu:/home/sandy# psql -d fossology -U fossy
But does it work with -h localhost, which is also implied by your
connection parameters? I suspect you don't have the server configured
to listen for TCP connections, or else that there's a firewall problem.
regards, tom lane
--
Kurt Schroeder
kschroe@gmail.comhttp://kurtandsandy.blogspot.com
