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]> > 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]] On Behalf Of Jonathan Parès > > Sent: Tuesday, August 04, 2009 5:26 AM > > To: [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
