Re: Fossology Install & Config Issues...
| От | Kurt Schroeder |
|---|---|
| Тема | Re: Fossology Install & Config Issues... |
| Дата | |
| Msg-id | 914b430c0802070901va1e9ff7jd9041fb7b841c985@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Fossology Install & Config Issues... ("Kurt Schroeder" <kschroe@gmail.com>) |
| Ответы |
Re: Fossology Install & Config Issues...
Re: Fossology Install & Config Issues... |
| Список | pgsql-general |
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.
--
Kurt Schroeder
kschroe@gmail.com
http://kurtandsandy.blogspot.com
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-- http://kurtandsandy.blogspot.comOn Feb 6, 2008 5:25 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:"Kurt Schroeder" <kschroe@gmail.com> writes:
> On Feb 6, 2008 2:18 PM, brian <brian@zijn-digital.com> wrote:
>> Can you connect to the database with psql?> Yes, I can:But does it work with -h localhost, which is also implied by your
> root@ubuntu:/home/sandy# psql -d fossology -U fossy
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.com
http://kurtandsandy.blogspot.com
В списке pgsql-general по дате отправления: