Oops, I forgot the most important config file, /etc/postgresql/8<version>/main/pg_hba.conf.
Mary ________________________________ From: Laser, Mary Sent: Thursday, November 19, 2009 11:52 AM To: 'Furosh One'; fossology@fossology.org Subject: RE: [FOSSology] Unable to Connect to database... Hello Furosh, You should also check the PostgreSQL log in the directory /var/log/postgresql/. My guess is it's a problem with connections and/or authentication specified in your postgresql.conf file (/etc/postgresql/<version>/main/postgresql.conf). Also, try accessing the fossology db from the command line: psql -d fossology -u fossy Mary ________________________________ From: fossology-boun...@fossology.org [mailto:fossology-boun...@fossology.org] On Behalf Of Furosh One Sent: Thursday, November 19, 2009 11:42 AM To: fossology@fossology.org Subject: [FOSSology] Unable to Connect to database... Can anyone point me to areas to check/troubleshoot for agents not being able to connect to the central DB server? My central DB server is host: clear5 All /etc/hosts file for all agents have an entry for clear1-6 and can ping all using things such as: ping clear1 ping clear5 ssh fo...@fossy Clear5 - Db.conf: -------------------------------------- dbname=fossology; host=localhost; user=fossy; password=fossy; -------------------------------------- Agent - Clear1 - Db.conf: -------------------------------------- dbname=fossology; host=clear5; user=fossy; password=fossy; -------------------------------------- Error Logs: ============================================== *** Checking database connectivity *** ERROR: Unable to connect to the database Connection string: 'dbname=fossology host=clear5 user=fossy password=fossy' Connection status: '1' ERROR: Failed to open database ERROR: unable to connect to database, please check /etc/fossology/Db.conf ============================================== What can I check to ensure connecting to remote DB server on clients or server? Ports? There in a lab environment with no firewall but its a new install of Ubuntu v9.10, maybe I have to open up a port or service? -Regards, FuRoSh...
_______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology