Hi Simon, Thanks for sending the postgresql log file and for correcting the pathnames. (I incorrectly assumed you were on a debian-based distro and referred you to the wrong locations - sorry.) What distro are you using?
Based on my initial examination of your log file, all the jobs ran successfully and the data from the analysis was saved in the database. (See the attached file for the relevant postgresql statements.) I'm looking for other clues in the postgresql log file and I'll respond with more as soon as I find something. Mary > -----Original Message----- > From: 西门烧雪 Simon [mailto:[email protected]] > Sent: Thursday, August 06, 2009 10:25 AM > To: Laser, Mary > Subject: Re: [FOSSology] Again: File contents are not > available in the repository > > My postgres conf is located under > /var/lib/pgsql/data > > I have modified, so that > log_statement = all # none, mod, ddl, all > > /etc/init.d/postgresql restart > > Uploaded the zip file again, the problem persists. > > The postgres log file, > /var/lib/pgsql/data/pg_log/postgresql-Thu.log, is attached. > I didn't find anything more obvious than the followings, > which I think is obnoxious. > > ERROR: prepared statement > "FolderGetFromUpload_1_exported" already exists > ERROR: prepared statement "DirGetNonArtifact_exported" > already exists > ERROR: prepared statement "DirGetNonArtifact_exported" > already exists > ERROR: prepared statement "DirGetNonArtifact_exported" > already exists > > > > 2009/8/6 Laser, Mary <[email protected]>: > > The default location for the postgresql log file is > /var/log/postgresql/postgresql-<version>-main.log. You > should also check your postgresql configuration file > (/etc/postgresql/8.3/main/postgresql.conf) to see if you have > logging enabled and to verify the log file location. Please > set "log_statement = all" so we can see if the upload data is > being inserted into the database successfully. > > > > Thanks, > > Mary > > > > > >> -----Original Message----- > >> From: 西门烧雪 Simon [mailto:[email protected]] > >> Sent: Thursday, August 06, 2009 6:36 AM > >> To: Laser, Mary > >> Subject: Re: [FOSSology] Again: File contents are not available in > >> the repository > >> > >> Mary, > >> > >> I used the Upload -> From File, like you did. > >> > >> Where is the postgresql log files? I checked /var/log, > but not found. > >> > >> I can provide all the information you need to analyze this issue. > >> Could you give me a list (and locations please since I am > deficient > >> in advanced Unix) of locations to look for? > >> > >> Thanks, > >> > >> > Hi Simon, > >> > I saved your zip file to my desktop, uploaded it (from the > >> UI using "Upload -> From File") and analyzed it with my > fossology 1.1 > >> instance. I had no issues. > >> > > >> > Are you uploading it the same way? (from the UI using > >> "Upload -> From File") If not, what method are you using? > >> > > >> > Please look at the postgresql log file for errors that > >> might have occurred when inserting the data for your upload. > >> > > >> > Mary > >> > > >> > > -----Original Message----- > >> >> From: [email protected] > >> >> [mailto:[email protected]] On Behalf Of ???? Simon > >> >> Sent: Wednesday, August 05, 2009 1:38 PM > >> >> To: [email protected] > >> >> Subject: [FOSSology] Again: File contents are not > available in the > >> >> repository > >> >> > >> >> Mary, > >> >> > >> >> Last time, I didn't follow through on this matter because > >> I suspected > >> >> that my installing process was defective. > >> >> > >> >> This time, using Fossology 1.1.0 GA, I successfully > installed by > >> >> using the official rpm. So I want to tackle this issue again. > >> >> > >> >> I am not able to view ANY of my uploads. (See attached > >> for the zip > >> >> file used for this analysis) Unpack seems successful, > >> judged by that > >> >> the tasks were all finished successfully. I don't know > >> how to verify > >> >> that the content is on my file system. > >> >> The /var/log/fossology/fossology.log shows that everything was > >> >> successful. (initially shown error, but was caused by postgres > >> >> didn't start in time) > >> >> > >> >> Please advise. Thank you. > >> >> > >> >> -- > >> >> Simon > >> >> 西门烧雪 > > > > -- > Simon > 西门烧雪 >
simons_pglog.odt
Description: simons_pglog.odt
_______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology
