Mary, Spent too much time trouble shooting it. Since it was a new machine I am setting up, I have un-installed and re-installed Ubuntu OS on my machine. At this point, there is no trace of Fossology. What is the best way to install Fossology without running into issues? Thanks for your support in advance.
Regards, Gurbax Deol 214-567-3311 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Laser, Mary Sent: Tuesday, August 17, 2010 2:19 PM To: McIntosh, Matt Cc: [email protected] Subject: Re: [FOSSology] Db tables Hi Matt, It looks like your database was created with the wrong encoding. By default, the postgres package is installed with UTF8 encoding. However, the fossology database cluster must be created with SQL_ASCII encoding. If you do not specify SQL_ASCII, the fossology db cluster will default to the postgres db encoding. This seems the most plausible explanation for your error below. You can check by invoking psql on the command line as user poastgres: postg...@mysys:~$ psql Welcome to psql 8.3.11, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit postgres=# \encoding SQL_ASCII postgres=# \c fossology You are now connected to database "fossology". fossology=# \encoding SQL_ASCII fossology=# If your installation does not match the example above, I suggest you drop the fossology database (drop database fossology) and recreate it by re-running fo-postinstall. Mary > -----Original Message----- > From: McIntosh, Matt [mailto:[email protected]] > Sent: Tuesday, August 17, 2010 11:31 AM > To: Laser, Mary > Subject: RE: Db tables > > Mary, > > This got me further. I'm now getting the below errors in the log. > Also, did you see my second email yesterday with the binary display on > the web pages? > > Thanks, > -Matt > > > 2010-08-17 10:14:43 scheduler[17680] : Child[7] 'agent=copyright > host=localhost ' state=SPAWNED(4) @ Tue Aug 17 10:14:43 2010 > 2010-08-17 10:14:44 scheduler[17680] : Child[7] 'agent=copyright > host=localhost ' state=READY(5) @ Tue Aug 17 10:14:44 2010 > 2010-08-17 10:14:44 scheduler[17680] : ERROR: In thread 7: DB Access > error, returned -1. > 2010-08-17 10:14:44 scheduler[17680] : DEBUG[7]: ERROR: DB Access > error, returned -1. > 2010-08-17 10:14:44 scheduler[17680] : ERROR: In thread 7: DB STATUS: > PGRES_FATAL_ERROR > 2010-08-17 10:14:44 scheduler[17680] : DEBUG[7]: ERROR: DB STATUS: > PGRES_FATAL_ERROR > 2010-08-17 10:14:44 scheduler[17680] : ERROR: In thread 7: DB ERRMSG: > invalid byte sequence for encoding "UTF8": 0x00 > 2010-08-17 10:14:44 scheduler[17680] : DEBUG[7]: ERROR: DB ERRMSG: > invalid byte sequence for encoding "UTF8": 0x00 > 2010-08-17 10:14:44 scheduler[17680] : DEBUG[7]: HINT: This error can > also happen if the byte sequence does not match the encoding expected > by the server, which is controlled by "client_encoding". > 2010-08-17 10:14:44 scheduler[17680] : ERROR: In thread 7: sql=INSERT > INTO copyright (agent_fk, pfile_fk, copy_startbyte, copy_endbyte, > content, hash, type) > 2010-08-17 10:14:44 scheduler[17680] : DEBUG[7]: ERROR: sql=INSERT > INTO copyright (agent_fk, pfile_fk, copy_startbyte, copy_endbyte, > content, hash, type) > 2010-08-17 10:14:44 scheduler[17680] : DEBUG[7]: > VALUES (24, 19421, 1235, 1276, > E'http\:\/\/www\.w3\.org\/TR\/html4\/loose\.dtd\"\>\^A\000\^N', > E'0x781313cb0a6a289b', 'url') > 2010-08-17 10:14:44 scheduler[17680] : ERROR: In thread 7: > filename=9133AD80C7B6AC5E2880BFD86002DA81006CDB77.3FF4F6DD09C98FC3EF27 > C > C > D4531EECCD.6412 > 2010-08-17 10:14:44 scheduler[17680] : DEBUG[7]: ERROR: > filename=9133AD80C7B6AC5E2880BFD86002DA81006CDB77.3FF4F6DD09C98FC3EF27 > C > C > D4531EECCD.6412 > 2010-08-17 10:14:44 scheduler[17680] : FATAL: In thread 7: An error > occurred in the main agent loop. Please consult the provided traceback. > 2010-08-17 10:14:44 scheduler[17680] : DEBUG[7]: FATAL: An error > occurred in the main agent loop. Please consult the provided traceback. > 2010-08-17 10:14:44 scheduler[17680] : DEBUG[7]: Traceback (most > recent call last): > 2010-08-17 10:14:44 scheduler[17680] : DEBUG[7]: File > "/usr/lib/fossology/agents/copyright/copyright.py", line 284, in agent > 2010-08-17 10:14:44 scheduler[17680] : DEBUG[7]: print >> > sys.stdout, 'ERROR: Could not process file.\n\tupload_pk = %s, > pfile_pk = %s, pfilename = %s' % (upload_pk, jobs[i]['pfile_pk'], > jobs[i]['pfilename']) > 2010-08-17 10:14:44 scheduler[17680] : DEBUG[7]: NameError: global > name 'jobs' is not defined > 2010-08-17 10:14:54 scheduler[17680] : ERROR: Child[7] died > prematurely (was state RUNNING, signal was 0) > 2010-08-17 10:14:54 scheduler[17680] : > Thread 7: > 2010-08-17 10:14:54 scheduler[17680] : PID: 17819 > 2010-08-17 10:14:54 scheduler[17680] : Pipes: in=7->8 / out=10->9 > 2010-08-17 10:14:54 scheduler[17680] : Attr: 'agent=copyright > host=localhost ' > 2010-08-17 10:14:54 scheduler[17680] : Command: > '/usr/lib/fossology/agents/copyright/run.py --model > /usr/share/fossology/model.dat --agent' > 2010-08-17 10:14:54 scheduler[17680] : Parm: '5 > ' > 2010-08-17 10:14:54 scheduler[17680] : Heartbeat: Tue Aug 17 > 10:14:44 > 2010 > 2010-08-17 10:14:54 scheduler[17680] : State: Tue Aug 17 > 10:14:44 > 2010 > 2010-08-17 10:14:54 scheduler[17680] : Status: 6 (RUNNING) > 2010-08-17 10:14:54 scheduler[17680] : Spawn: 1 at Tue Aug 17 > 10:14:43 2010 > 2010-08-17 10:14:54 scheduler[17680] : DB: > 2010-08-17 10:14:54 scheduler[17680] : IsDB: 1 > 2010-08-17 10:14:54 scheduler[17680] : DBJobKey: 51 > 2010-08-17 10:14:54 scheduler[17680] : DBMSQrow: 0 > 2010-08-17 10:14:54 scheduler[17680] : DBagent: 24 > 2010-08-17 10:14:54 scheduler[17680] : Child[7] 'agent=copyright > host=localhost ' state=FREEING(2) @ Tue Aug 17 10:14:54 2010 > 2010-08-17 10:14:54 scheduler[17680] : Child[7] 'agent=copyright > host=localhost ' state=FREE(1) @ Tue Aug 17 10:14:54 2010 > > -----Original Message----- > From: Laser, Mary [mailto:[email protected]] > Sent: Monday, August 16, 2010 14:36 > To: McIntosh, Matt > Subject: RE: Db tables > > Hi Matt, > 2 more things you should try: > 1) check to make sure there is an entry for the copyright agent in > the Scheduler.conf file (in /etc/fossology). > 2) please stop the scheduler, rerun fo-posinstall - check for > errors; restart the scheduler; check log file for errors. > > Email errors, if any. > Mary > > > -----Original Message----- > > From: McIntosh, Matt [mailto:[email protected]] > > Sent: Monday, August 16, 2010 1:48 PM > > To: Laser, Mary > > Subject: RE: Db tables > > > > Mary, > > > > I looked in the file and ran the sql to create the table, indexes, > etc. > > but now it looks like the job isn't getting run. If I look at the > job > > queue it's there but it isn't running and I look in the log and the > > copyright agent isn't showing as being run. I uploaded a new > > package and it ran all the way through the other agents, but stopped > > at the copyright. Any ideas? > > > > Thanks, > > -Matt > > > > -----Original Message----- > > From: Laser, Mary [mailto:[email protected]] > > Sent: Monday, August 16, 2010 11:10 > > To: McIntosh, Matt; [email protected] > > Subject: RE: Db tables > > > > Hi Matt, > > Matt Taggart discovered shortly after we released. We've checked in > a > > (1 line) fix: > > > http://fossology.svn.sourceforge.net/viewvc/fossology?view=revision&re > v > > i > > sion=3348 > > > > Sorry for the inconvenience. > > > > Mary > > > > _______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology _______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology
