Re: Fossology Install & Config Issues...

["Kurt Schroeder" <kschroe@xxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxxxxxx> wrote:

"Kurt Schroeder" <kschroe@xxxxxxxxx> writes:
> On Feb 6, 2008 2:18 PM, brian <brian@xxxxxxxxxxxxxxxx> wrote:
>> Can you connect to the database with psql?

> 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@xxxxxxxxx

http://kurtandsandy.blogspot.com

-- 
Kurt Schroeder
kschroe@xxxxxxxxx
http://kurtandsandy.blogspot.com