[FOSSology] Db tables
What file does the database table creation? After getting everything installed and uploading a couple of packages I found that the copyright job isn't running. In looking at the log I see that it tries to do a select from the copyright table. I don't have this table in the db. FYI: I did the install from the RHEL5 rpm. Log snippet is posted below. Thanks, -Matt 2010-08-13 14:04:32 scheduler[8247] : Child[7] 'agent=copyright host=localhost ' state=SPAWNED(4) @ Fri Aug 13 14:04:32 2010 2010-08-13 14:04:32 scheduler[8247] : ERROR: In thread 7: Could not select table copyright. Database said: "relation "copyright" does not exist at character 19" 2010-08-13 14:04:32 scheduler[8247] : DEBUG[7]: ERROR: Could not select table copyright. Database said: "relation "copyright" does not exist at character 19" 2010-08-13 14:04:32 scheduler[8247] : ERROR: In thread 7: sql=SELECT ct_pk FROM copyright LIMIT 1 2010-08-13 14:04:32 scheduler[8247] : DEBUG[7]: ERROR: sql=SELECT ct_pk FROM copyright LIMIT 1 2010-08-13 14:05:42 scheduler[8247] : ERROR: Child[7] failed to spawn after 70 seconds 2010-08-13 14:05:42 scheduler[8247] : ERROR: Child[7] failed command was: '/usr/lib/fossology/agents/copyright/run.py --model /usr/share/fossology/model.dat --agent' 2010-08-13 14:05:42 scheduler[8247] : Child[7] 'agent=copyright host=localhost ' state=SPAWNED(4) @ Fri Aug 13 14:05:42 2010 2010-08-13 14:05:42 scheduler[8247] : Child[7] 'agent=copyright host=localhost ' state=FREEING(2) @ Fri Aug 13 14:05:42 2010 2010-08-13 14:05:42 scheduler[8247] : Child[7] 'agent=copyright host=localhost ' state=FREE(1) @ Fri Aug 13 14:05:42 2010 2010-08-13 14:05:42 scheduler[8247] : Child[13] 'agent=sqlagent host=localhost ' state=FREE(1) @ Fri Aug 13 14:05:42 2010 2010-08-13 14:05:42 scheduler[8247] : ERROR: Child[7] died prematurely (was state FREE, signal was 0) 2010-08-13 14:05:42 scheduler[8247] : Thread 7: 2010-08-13 14:05:42 scheduler[8247] : PID: 12691 2010-08-13 14:05:42 scheduler[8247] : Pipes: in=0->0 / out=0->0 2010-08-13 14:05:42 scheduler[8247] : Attr: 'agent=copyright host=localhost ' 2010-08-13 14:05:42 scheduler[8247] : Command: '/usr/lib/fossology/agents/copyright/run.py --model /usr/share/fossology/model.dat --agent' 2010-08-13 14:05:42 scheduler[8247] : Parm: '' 2010-08-13 14:05:42 scheduler[8247] : Heartbeat: Fri Aug 13 14:05:42 2010 2010-08-13 14:05:42 scheduler[8247] : State: Fri Aug 13 14:05:42 2010 2010-08-13 14:05:42 scheduler[8247] : Status: 1 (FREE) 2010-08-13 14:05:42 scheduler[8247] : Spawn: 3 at Fri Aug 13 14:00:50 2010 2010-08-13 14:05:42 scheduler[8247] : DB: 2010-08-13 14:05:42 scheduler[8247] : IsDB: 0 2010-08-13 14:05:42 scheduler[8247] : DBJobKey: 0 2010-08-13 14:05:42 scheduler[8247] : DBMSQrow: 0 2010-08-13 14:05:42 scheduler[8247] : DBagent: 24 ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
Re: [FOSSology] 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&revision=3348 Sorry for the inconvenience. Mary > -Original Message- > From: fossology-boun...@fossology.org [mailto:fossology- > boun...@fossology.org] On Behalf Of McIntosh, Matt > Sent: Monday, August 16, 2010 10:49 AM > To: fossology@fossology.org > Subject: [FOSSology] Db tables > > What file does the database table creation? After getting everything > installed and uploading a couple of packages I found that the copyright > job isn't running. In looking at the log I see that it tries to do a > select from the copyright table. I don't have this table in the db. > FYI: I did the install from the RHEL5 rpm. Log snippet is posted > below. > > Thanks, > -Matt > > > 2010-08-13 14:04:32 scheduler[8247] : Child[7] 'agent=copyright > host=localhost ' state=SPAWNED(4) @ Fri Aug 13 14:04:32 2010 > 2010-08-13 14:04:32 scheduler[8247] : ERROR: In thread 7: Could not > select table copyright. Database said: "relation "copyright" does not > exist at character 19" > 2010-08-13 14:04:32 scheduler[8247] : DEBUG[7]: ERROR: Could not select > table copyright. Database said: "relation "copyright" does not exist at > character 19" > 2010-08-13 14:04:32 scheduler[8247] : ERROR: In thread 7: sql=SELECT > ct_pk FROM copyright LIMIT 1 > 2010-08-13 14:04:32 scheduler[8247] : DEBUG[7]: ERROR: sql=SELECT ct_pk > FROM copyright LIMIT 1 > 2010-08-13 14:05:42 scheduler[8247] : ERROR: Child[7] failed to spawn > after 70 seconds > 2010-08-13 14:05:42 scheduler[8247] : ERROR: Child[7] failed command > was: '/usr/lib/fossology/agents/copyright/run.py --model > /usr/share/fossology/model.dat --agent' > 2010-08-13 14:05:42 scheduler[8247] : Child[7] 'agent=copyright > host=localhost ' state=SPAWNED(4) @ Fri Aug 13 14:05:42 2010 > 2010-08-13 14:05:42 scheduler[8247] : Child[7] 'agent=copyright > host=localhost ' state=FREEING(2) @ Fri Aug 13 14:05:42 2010 > 2010-08-13 14:05:42 scheduler[8247] : Child[7] 'agent=copyright > host=localhost ' state=FREE(1) @ Fri Aug 13 14:05:42 2010 > 2010-08-13 14:05:42 scheduler[8247] : Child[13] 'agent=sqlagent > host=localhost ' state=FREE(1) @ Fri Aug 13 14:05:42 2010 > 2010-08-13 14:05:42 scheduler[8247] : ERROR: Child[7] died prematurely > (was state FREE, signal was 0) > 2010-08-13 14:05:42 scheduler[8247] : > Thread 7: > 2010-08-13 14:05:42 scheduler[8247] : PID: 12691 > 2010-08-13 14:05:42 scheduler[8247] : Pipes: in=0->0 / out=0->0 > 2010-08-13 14:05:42 scheduler[8247] : Attr: 'agent=copyright > host=localhost ' > 2010-08-13 14:05:42 scheduler[8247] : Command: > '/usr/lib/fossology/agents/copyright/run.py --model > /usr/share/fossology/model.dat --agent' > 2010-08-13 14:05:42 scheduler[8247] : Parm: '' > 2010-08-13 14:05:42 scheduler[8247] : Heartbeat: Fri Aug 13 14:05:42 > 2010 > 2010-08-13 14:05:42 scheduler[8247] : State: Fri Aug 13 14:05:42 > 2010 > 2010-08-13 14:05:42 scheduler[8247] : Status: 1 (FREE) > 2010-08-13 14:05:42 scheduler[8247] : Spawn: 3 at Fri Aug 13 > 14:00:50 2010 > 2010-08-13 14:05:42 scheduler[8247] : DB: > 2010-08-13 14:05:42 scheduler[8247] : IsDB: 0 > 2010-08-13 14:05:42 scheduler[8247] : DBJobKey: 0 > 2010-08-13 14:05:42 scheduler[8247] : DBMSQrow: 0 > 2010-08-13 14:05:42 scheduler[8247] : DBagent: 24 > ___ > fossology mailing list > fossology@fossology.org > http://fossology.org/mailman/listinfo/fossology ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
[FOSSology] FW: Db tables
Forgot to reply all... -Original Message- From: Laser, Mary Sent: Monday, August 16, 2010 3:36 PM 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:matt_mcint...@mentor.com] > 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:mary.la...@hp.com] > Sent: Monday, August 16, 2010 11:10 > To: McIntosh, Matt; fossology@fossology.org > 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&rev > i > sion=3348 > > Sorry for the inconvenience. > > Mary > > ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
[FOSSology] Fwd: list of nomos licenses
Thanks Raino. I hope you don't mind me forwarding this to the public mailing list. I've added a nomos link in the developer docs (http://fossology.org/developer_documentation). On the nomos page I put a link to your license list: http://fossology.org/nomos_liclist Thanks so much! Bob Gobeille Begin forwarded message: > From: Raino Lintulampi > Date: August 16, 2010 3:07:14 PM MDT > To: "b...@fossology.org" > Subject: list of nomos licenses > > Hi Bob, > one problem which I faced when creating buckets was that I couldn't figure > out > what where the license names nomos was using. And furthermore what > are the licenses which nomos identifies. Nomos is very good checker but > the information about the known licenses is implicit. So your reply on how to > add a new nomos license gave me a hint where the real information could be > foudn and so I grep the following information from the parse.c file, see > attachment. > If the information is accurate enough and you think it could be useful, be > free > to use it in fossology documentation. > > br Raino > ___ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
