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
[EMAIL PROTECTED]:/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:
[EMAIL
PROTECTED]:/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 <[EMAIL PROTECTED]> wrote:
> No, it didn't work! When I ran:
>
> [EMAIL PROTECTED]:/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 <[EMAIL PROTECTED]> wrote:
>
> > "Kurt Schroeder" <[EMAIL PROTECTED]> writes:
> > > On Feb 6, 2008 2:18 PM, brian <[EMAIL PROTECTED]> wrote:
> > >> Can you connect to the database with psql?
> >
> > > Yes, I can:
> > > [EMAIL PROTECTED]:/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
> [EMAIL PROTECTED]
> http://kurtandsandy.blogspot.com
--
Kurt Schroeder
[EMAIL PROTECTED]
http://kurtandsandy.blogspot.com
