Christian, Don't reinstall - not necessary, the problem is as you correctly identified is with the postgres pg_hba.conf I am not a postgres expert but had similar problems on an Ubuntu install ....
Try this for starters and try and isolate down to your IPv4, then maybe switch on and off sections to see where the problem occurs (Remembering to restart postgres between changes) I am assuming apache has been set up to just run localhost so that http://localhost/repo/ brings you to the fossology instance. ################################################## # "local" is for Unix domain socket connections only #local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: #host all all ::1/128 trust ################################################## The postgres site has some good documentation in order to configure this later on - but I assume you want to try and get this running. Hope this helps, as I said no expert but just from my installation experience. Sincerely, Shay Stowe Pramerica Systems Ireland Limited is a private company limited by shares incorporated and registered in the Republic of Ireland with registered number 319900 and registered office at 6th Floor, South Bank House, Barrow Street, Dublin 4, Ireland. christian.ster...@clearstream.com Sent by: fossology-boun...@fossology.org Wed 02/18/2009 10:24 AM To fossology@fossology.org cc pavel.kraynyuk...@clearstream.com Subject [FOSSology] Installation problem Hello, Here is a problem we encounter after the installation of fossology. (on a RHEL 5.2 x86_64) By start of scheduler: 2009-02-13 10:53:47 scheduler[11317] : *** Scheduler started 2009-02-13 10:53:47 scheduler[11317] : FATAL: Unable to connect to database Db.conf: ------------ dbname=fossology; host=localhost; user=fossy; password=fossy; ------------ DB instance is up and running: -------------------------- [fo...@reikland ~]$ psql -d fossology -h localhost -U fossy -W Password for user fossy: Welcome to psql 8.1.11, 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 fossology=> -------------------- Following a suggestion from Mary Laser, the following was done: I have changed all "trust" to "md5" in following part of pg_hba.conf and restarted postgresql. ################################################## # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust ################################################## Then i tryed to restart scheduler again. Those changes had no effect, the scheduler still fails. However the postgresql log file does not consists mentioning of "apachedb" anymore. Any further ideas ? should i drop the db and reinstall fossology again ? Would it help ? Thanks in advance, Christian Sterpin - ICSD System & Hardware Administration Ext: 32303 ---------------------------------------------------------------------------- Clearstream Services S.A. 42 Avenue JF Kennedy, L-1855 Luxembourg Société anonyme is organised with limited liability in the Grand Duchy of Luxembourg R.C.S. Luxembourg B 60911. Visit us at http://www.clearstream.com IMPORTANT MESSAGE Internet communications are not secure and therefore Clearstream International does not accept legal responsibility for the contents of this message. The information contained in this e-mail is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any views expressed in this e-mail are those of the individual sender, except where the sender specifically states them to be the views of Clearstream International or of any of its affiliates or subsidiaries. Legally required information for business correspondence/ Gesetzliche Pflichtangaben fuer Geschaeftskorrespondenz: http://deutsche-boerse.com/letterhead END OF DISCLAIMER _______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
_______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
