Dear Mary, I have read this in the Postegresql wiki page of the French Ubuntu community about the release 8.3 :
"Il est important de remarquer que lors de l'installation, les bases de données sont créées en unicode et qu'à cause de cela, il ne sera pas possible de créer une base de données dans un autre encodage." that means in English : "It's important to notice that during the installation, the database schemes are created with the unicode encoding and due to this, it will not possible to create an other scheme with an other encoding." Best regards, Jonathan 2009/8/10 Laser, Mary <mary.la...@hp.com> > Hi Jonathan, > Thanks for the update. I spent several hours Friday examining the > PostgreSQL log file you sent me and could not find the source of your > problem. I don't think it's due to encoding but, I'll look specifically for > that issue. > > I will also try to recreate the problem you describe below "Postgresql > doesn't like the database creation with an encoding different from UTF-8, > and the fossology database uses the SQL-ASCII encoding". > > Thanks again, > Mary > > ------------------------------ > *From:* Jonathan Parès [mailto:jonathan.pa...@gmail.com] > *Sent:* Sunday, August 09, 2009 9:10 PM > > *To:* Laser, Mary > *Cc:* fossology@fossology.org > *Subject:* Re: [FOSSology] Fossology installation troubles : ERROR: Unable > to initialize. > > 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 <mary.la...@hp.com> > >> 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> >> >>> 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] On Behalf Of Jonathan Parès >>> > Sent: Tuesday, August 04, 2009 5:26 AM >>> > To: 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. >> >> > > > -- > ---------------------------------------------------- > Jonathan Parès, > Software engineer, > Qualipso project, > O-Engine/GMRC, > Open Source Competence Center (China), > Guangzhou China. > > -- ---------------------------------------------------- Jonathan Parès, Software engineer, Qualipso project, O-Engine/GMRC, Open Source Competence Center (China), Guangzhou China.
_______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
