Well Postgresql is very particular. I found out what the issue was. For some reason I couldn't use 'psql -d fossology -U fossy' because it needed '-h localhost' as an included option. Once I entered that I could connect on the local box.
Then I had to change the list address in the /etc/postgresql/8.3/main/postgresql.conf file: #------------------------------------------------------------------------------ # CONNECTIONS AND AUTHENTICATION #------------------------------------------------------------------------------ # - Connection Settings - #listen_addresses = 'localhost' # what IP address(es) to listen on; listen_addresses = '*' # what IP address(es) to listen on; So I tested from the agent the remote connection with: 'psql -h clear5 -d fossology -U fossy' and it worked!!! Thanks so much for your push!!! -FuRoSh... On Thu, Nov 19, 2009 at 4:23 PM, Laser, Mary <mary.la...@hp.com> wrote: > Hi Furosh, > When invoking psql with "-U", it should automatically prompt you for a > password (see psql --help). Since it's not doing it, you can force the > prompt with -W. > > psql -d fossology -U fossy -W > > try that. > Mary > > > ------------------------------ > *From:* Furosh One [mailto:fur...@gmail.com] > *Sent:* Thursday, November 19, 2009 5:20 PM > *To:* Gobeille, Robert > *Cc:* Laser, Mary; fossology@fossology.org > *Subject:* Re: [FOSSology] Unable to Connect to database... > > Okay I read up on the configuring the pg_hba.conf file for remote access. > I added the following to the file: > # Enable access for Fossology agents to connect to fossology DB: > host all all 10.3.3.0/24 trust > > This should allow all my 5 agents to access it now. > > However, I tested the login to fossology db on the server and login > authentication fails: > ============================ > gmarq...@san-clear5:~$ psql -d fossology -U fossy > psql: FATAL: Ident authentication failed for user "fossy" > ============================ > > I can probably remove a package and then reinstall fossology to correct > this, but is there another way to correct the login here? I would obviously > need to correct this on the server before the agents can connect. > > -FuRoSh... > >
_______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
