Re: [FOSSology] 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
Re: [FOSSology] Database connection error
Mark, I double checked and the postgresql.conf file has the changes listed in the INSTALL doc. I've also made the other listed config changes. I had tried to do a deb install first, but couldn't get it to work. I have Ubuntu 11.04 and it looks like the deb packages don't support that version of the OS. So I cleaned everything off and build it from source. The fo-installdeps did not work and gave an error message that said Unsupported version of Ubuntu. So I manually installed the dependencies with Synaptic package manager. The pg_hba.conf is identical to the one I have on an older version of Ubuntu where I have fossology 1.3.0 installed and running fine. So I'm not sure where the problem is at this point. Thanks, Dave Message: 3 Date: Thu, 07 Jul 2011 15:08:58 -0700 From: Mark Donohoe mark.dono...@hp.com Subject: Re: [FOSSology] Database connection error To: fossology@fossology.org Message-ID: 4e162e7a.7060...@hp.com Content-Type: text/plain; charset=iso-8859-1; Format=flowed Dave, When doing a package install, the system prep is not much different that with a source install. That is fossology doesn't want to just go change your php.ini files, or postgres files as part of the install. So either before installing the packages or right after (stop the scheduler if you have installed packages). 1. Configure kernal shmmax 2. configure php ini files in cli and apache areas of php 3. configure postgres 4. configure apache 5. restart both apache and postgres This is explained in the INSTALL document in the sources. Hope that helps. Until all of the above steps have been done, you may continue to have problems. Hope that helps. On 07/07/2011 02:59 PM, Laser, Mary wrote: ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
Re: [FOSSology] Database connection error
I had tried to do a deb install first, but couldn't get it to work. I have Ubuntu 11.04 and it looks like the deb packages don't support that version of the OS. So I cleaned everything off and build it from source. The fo-installdeps did not work and gave an error message that said Unsupported version of Ubuntu. So I manually installed the dependencies with Synaptic package manager. Patches accepted :) -- Matt Taggart tagg...@fossology.org ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
Re: [FOSSology] Database connection error
On 07/08/2011 10:43 AM, Matt Taggart wrote: I had tried to do a deb install first, but couldn't get it to work. I have Ubuntu 11.04 and it looks like the deb packages don't support that version of the OS. So I cleaned everything off and build it from source. The fo-installdeps did not work and gave an error message that said Unsupported version of Ubuntu. So I manually installed the dependencies with Synaptic package manager. Patches accepted :) We didn't build packages for 11.04. So that was the issue.. I wondered how he got it to work on 11.04. Ya, source is the only way. Hmm not sure what the problem is then I hate when customers get into this situation. -- --- Mark Donohoe OSPO, HP FOSSology.org ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
Re: [FOSSology] Database connection error
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
Re: [FOSSology] 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