Hi Dave, Sorry your having such a difficult time :-(
This is definitely a Postgres problem. Try these steps: 1. Carefully check the configuration of pg_hba.conf. Don't assume that what worked with your older Ubuntu version will work with Ubuntu 11.04. You may have to refer to the online PG docs. (they are an excellent resource) 2. Make sure user fossy owns the fossology db. You must become the postgres user and then invoke psql to examine the fossology db. 3. Once you can successfully access the db via "psql -d fossology -U fossy", try starting the scheduler. 4. Please send us your solution for our troubleshooting page (http://fossology.org/troubleshooting). Mary From: Dave McLoughlin [mailto:dave.mclough...@openlogic.com] Sent: Friday, July 08, 2011 10:40 AM To: Laser, Mary; fossology@fossology.org Subject: RE: Database connection error Mary, I should have included the postgresql logs yesterday. Does this help pinpoint the issue? This is the last couple entries from the postgresql log: 2011-07-07 15:39:15 MDT [local] 4e162783.ccbLOG: provided username (fossy) and authenticated username (user) don't match 2011-07-07 15:39:15 MDT [local] 4e162783.ccbFATAL: Ident authentication failed for user "fossy" thanks, Dave -----Original Message----- From: Laser, Mary [mailto:mary.la...@hp.com] Sent: Thu 7/7/2011 3:59 PM To: Dave McLoughlin; fossology@fossology.org Subject: RE: Database connection error This usually is a symptom of a mis-configured postgres file; typically /etc/postgresql/8.3/main/pg_hba.conf Look in the postgres log file (/var/log/postgresql/postgresql-8.3-main.log) for additional clues to your error. Mary From: fossology-boun...@fossology.org [mailto:fossology-boun...@fossology.org] On Behalf Of Dave McLoughlin Sent: Thursday, July 07, 2011 3:46 PM To: fossology@fossology.org Subject: [FOSSology] Database connection error I'm running into a problem with a database connection error after install of 1.4.1 on Ubuntu 1.4.1. When I re-ran fo-postinstall to make sure everything was okay I got: *** Running postinstall for everything *** *** Setting up the FOSSology database *** NOTE: fossology database already exists, not creating *** Checking for plpgsql support *** NOTE: plpgsql already exists in fossology database, good *** Creating user and group *** NOTE: group 'fossy' already exists, good. NOTE: user 'fossy' already exists, good. *** Making sure needed dirs exist with right ownership/permissions *** NOTE: Repository already exists at /srv/fossology/repository NOTE: /srv/fossology/repository/localhost directory already exists *** Checking database connectivity *** NOTE: Connect succeeded, database is working. But my fossology.log shows 2011-07-07 13:30:49 scheduler[1030] : FATAL: fo_watchdog unable to connect to database. Terminating. 2011-07-07 13:34:30 scheduler[2408] : Log opened 2011-07-07 13:34:30 scheduler[2408] : Scheduler kill requested. Killing scheduler. Also trying psql I get: $ psql -d fossology -U fossy psql: FATAL: Ident authentication failed for user "fossy" Any ideas? Dave Any ideas?
_______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
