Hi Jonathan, The message "Applying database schema" comes from the function ApplySchema in /usr/share/fossology/www/plugins/core-schema.php. Immediately after this is printed, we check for the existence of the core-schema.dat file (also in /usr/share/fossology/www/plugins/) followed by a validity check. If these 2 tests pass, the core-schema.dat file is read and applied to the database. Since we are not seeing any messages in the postgresql log file indicating the schema is being applied, I'd guess that one of the 2 previous tests failed. Please check to see that the core-schema.dat file is present, readable and valid. You can check it against this copy: http://fossology.svn.sourceforge.net/viewvc/fossology/trunk/fossology/ui/plugins/core-schema.dat?revision=2095&view=markup.
Mary ________________________________ From: Laser, Mary Sent: Wednesday, August 05, 2009 9:26 AM To: 'Jonathan Parès' Cc: fossology@fossology.org Subject: RE: [FOSSology] Fossology installation troubles : ERROR: Unable to initialize. 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:jonathan.pa...@gmail.com] Sent: Wednesday, August 05, 2009 1:27 AM To: Laser, Mary Cc: fossology@fossology.org 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 <mary.la...@hp.com<mailto:mary.la...@hp.com>> 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: fossology-boun...@fossology.org<mailto:fossology-boun...@fossology.org> > [mailto:fossology-boun...@fossology.org<mailto:fossology-boun...@fossology.org>] > On Behalf Of Jonathan Parès > Sent: Tuesday, August 04, 2009 5:26 AM > To: fossology@fossology.org<mailto:fossology@fossology.org> > 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 fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
