Dear Mary, I have decided to install CentOS-5.3 as virtual machine on my PC. Fossology is working like a charm now. I would like helping you to fix this problem on Ubuntu 8.04, but I have done a backup on my virtual machine and now I don't have fossology installed on it anymore. But it seems that the 8.3 release of Postgresql doesn't like the database creation with an encoding different from UTF-8, and the fossology database uses the SQL-ASCII encoding ... This information must be confirmed, may be the problem comes from this.
Best regards, Jonathan 2009/8/6 Laser, Mary <[email protected]> > 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:* [email protected] > *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:[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]> > >> 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. > > -- ---------------------------------------------------- Jonathan Parès, Software engineer, Qualipso project, O-Engine/GMRC, Open Source Competence Center (China), Guangzhou China.
_______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology
