Hi Jonathan, Thank you for this additional information. I will take a look at fossinit to see why the error is occurring.
Mary ________________________________ From: Jonathan Parès [mailto:[email protected]] Sent: Wednesday, August 05, 2009 1:27 AM To: Laser, Mary Cc: [email protected] Subject: Re: [FOSSology] Fossology installation troubles : ERROR: Unable to initialize. Dear Mary, It seems it's a problem of script and not of my database. The postgresql log file is not updated/modified by the execution of the fo-postinstall script. Consequently I think it's a problem of script, inside the fo-postinstall script or the other ones called by the fo-postinstall. Following the result of the running with the -x parameter of the script : virtual...@ubuntu-8-04-vbx:~$ sudo bash -x /usr/local/lib/fossology/fo-postinstall ++ getopt -o adwseoh --long agent,database,web,web-only,scheduler,scheduler-only,everything,overwrite,help -n fo-postinstall -- + OPTS=' --' + '[' 0 '!=' 0 ']' + eval set -- ' --' ++ set -- -- + '[' ' --' = ' --' -o ' --' = ' -o --' ']' + EVERYTHING=1 + true + case "$1" in + shift + break + '[' ']' + '[' ']' + '[' 1 ']' + echo '*** Running postinstall for everything ***' *** Running postinstall for everything *** + AGENT=1 + DATABASE=1 + WEBONLY=1 + SCHEDULERONLY=1 ++ id -u + '[' 0 '!=' 0 ']' + '[' 1 ']' + /usr/local/lib/fossology/dbcreate *** Setting up the FOSSology database *** NOTE: fossology database already exists, not creating *** Checking for plpgsql support *** NOTE: plpgsql already exists in fossology database, good + '[' 1 ']' + '[' -e /usr/local/etc/fossology/RepPath.conf ']' ++ cat /usr/local/etc/fossology/RepPath.conf + REPO=/srv/fossology/repository + echo '*** Creating user and group ***' *** Creating user and group *** + grep -q '^fossy:' /etc/group + echo 'NOTE: group '\''fossy'\'' already exists, good.' NOTE: group 'fossy' already exists, good. + grep -q '^fossy:' /etc/passwd + echo 'NOTE: user '\''fossy'\'' already exists, good.' NOTE: user 'fossy' already exists, good. ++ grep '^fossy:' /etc/passwd ++ cut -d: -f 7 + USERSHELL=/bin/bash + '[' /bin/bash = /bin/false ']' + echo '*** Making sure needed dirs exist with right ownership/permissions ***' *** Making sure needed dirs exist with right ownership/permissions *** + '[' '!' -d /var/local/lib/fossology ']' + chown root:fossy /var/local/lib/fossology + chmod 2775 /var/local/lib/fossology + '[' '!' -d /var/local/lib/fossology/agents ']' + chown root:fossy /var/local/lib/fossology/agents + chmod 2775 /var/local/lib/fossology/agents + '[' '!' -d /srv/fossology/repository ']' + echo 'NOTE: Repository already exists at /srv/fossology/repository' NOTE: Repository already exists at /srv/fossology/repository + '[' -d /srv/fossology/repository/ununpack ']' + '[' -e /usr/local/etc/fossology/Hosts.conf ']' + grep -q '^localhost' /usr/local/etc/fossology/Hosts.conf + '[' 0 == 0 ']' + '[' '!' -d /srv/fossology/repository/localhost ']' + echo 'NOTE: /srv/fossology/repository/localhost directory already exists' NOTE: /srv/fossology/repository/localhost directory already exists + echo '*** Checking database connectivity ***' *** Checking database connectivity *** + DBCONF=/usr/local/etc/fossology/Db.conf + '[' '!' -f /usr/local/etc/fossology/Db.conf ']' + chgrp fossy /usr/local/etc/fossology/Db.conf + '[' -x /usr/local/lib/fossology/dbcheck ']' + /usr/local/lib/fossology/dbcheck + '[' 0 '!=' 0 ']' + echo 'NOTE: Connect succeeded, database is working.' NOTE: Connect succeeded, database is working. + echo '*** Initializing database tables ***' *** Initializing database tables *** + /usr/local/bin/fossinit Applying database schema + '[' 255 '!=' 0 ']' + echo 'ERROR: Unable to initialize.' ERROR: Unable to initialize. + exit 1 >From here seems to come from the problem : + '[' 255 '!=' 0 ']' Thanks for your help. Best regards, Jonathan 2009/8/4 Laser, Mary <[email protected]<mailto:[email protected]>> Hi Jonathan, Since the error is occurring during database creation, we need to examine the PostgreSQL log file for clues - /var/log/postgres<ver>/postgresql.log. If you don't see any useful information in there, please 1) edit your postgresql.conf file to enable more verbose logging (log_min_messages = info, client_min_messages = log, log_min_error_statement = info); 2) restart the PostgreSQL server; 3) rerun fo-postinstall to generate the error again 3) re-examine the PostgreSQL log file. Please send errors from the pg log file. Thanks, Mary > -----Original Message----- > From: [email protected]<mailto:[email protected]> > [mailto:[email protected]<mailto:[email protected]>] > On Behalf Of Jonathan Parès > Sent: Tuesday, August 04, 2009 5:26 AM > To: [email protected]<mailto:[email protected]> > Subject: [FOSSology] Fossology installation troubles : ERROR: > Unable to initialize. > > Dear all, > > I am trying to install fossology 1.1.0 from the source code > on my system (Ubuntu 8.04), and I have a problem with the > automatic configuration post-installation script. > > When I execute the fo-postinstall script I have this result : > > sudo /usr/local/lib/fossology/fo-postinstall > *** 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. > *** Initializing database tables *** > Applying database schema > ERROR: Unable to initialize. > > > As mentioned inside the INSTALL text file, I have modified > the Apache, PHP and Postgresql config files. > > For information you can find the different configuration > files of my system and for PHP and Postgresql. I mention too > that I can connect to the postgresql server successfully with > the postgres user. So I have no idea from where could come > from the problem. I have had a discussion on the Fossology > IRC channel with "vincent", and we didn't success to pass the > fo-postinstall step. > > Relying on your help, > > Best regards, > > Jonathan > > > -- ---------------------------------------------------- Jonathan Parès, Software engineer, Qualipso project, O-Engine/GMRC, Guangzhou China.
_______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology

