Re: Fossology Install & Config Issues...

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(at)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(at)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(at)gmail(dot)com> wrote:

> No, it didn't work! When I ran:
>
> fossy(at)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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> > "Kurt Schroeder" <kschroe(at)gmail(dot)com> writes:
> > > On Feb 6, 2008 2:18 PM, brian <brian(at)zijn-digital(dot)com> wrote:
> > >> Can you connect to the database with psql?
> >
> > > Yes, I can:
> > > root(at)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(at)gmail(dot)com
> http://kurtandsandy.blogspot.com

--
Kurt Schroeder
kschroe(at)gmail(dot)com
http://kurtandsandy.blogspot.com