Re: [Gusdev-gusdev] Setting up your initial Users, etc

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Please disregard my previous message on the RADform submission. That has
only to do with our copy of GUS. Sorry.
In any case, the tables for project and group should be Core.ProjectInfo
and Core.GroupInfo.
Elisabetta

On Fri, 14 Mar 2003, Chetna Warade wrote:

> Hi guys,
>
> Yes I added a user in Core.UserInfo and Sres.Contact, but I still getting
> the same error for ga +meta --commit. Can anyone tell me what tables I
> need for projects and groups, Are they Core.GroupInfo and
> Core.ProjectInfo?. In the meantime I am adding rows in these two tables
> but please let me know if there are other table dependencies.
>
> Thanks to all for the help
> Chetna
>
>
> > yes, i agree.  chetna- you need to set up your Users and Projects, etc.
> >  Have you ever done this before?
> >
> > Jonathan Crabtree is away until Wed.  I don't know if he has set up
> > scripts to assist in this process.  but, we should provide something to
> > make this painless.
> >
> > I personally don't know the details of what is involved.
> >
> > Can anybody at PSU sketch what chetna should do?
> >
> > thanks
> > steve
> >
> > Dave Barkan wrote:
> >
> > >Hi Chetna and all,
> > >
> > >I had this problem too at one point.  Someone needs to insert Chetna into
> > >our UserInfo table as a user and give her the appropriate permissions.
> > >
> > >Dave
> > >
> > >On Fri, 14 Mar 2003, Chetna Warade wrote:
> > >
> > >
> > >
> > >>Hi Steve,
> > >>
> > >>I got the latest tars today morning, but I am getting:
> > >>
> > >>[chetna@mango install]$ ga +meta --commit
> > >>Reading properties from /home/gus_home/config/GUS-PluginMgr.prop
> > >>Reading properties from /home/chetna/.gus.properties
> > >>  <Core::Algorithm>
> > >>    <name>GA-Plugin</name>
> > >>    <description>GUS application framework for plugins</description>
> > >>    <Core::AlgorithmImplementation>
> > >>      <cvs_revision>1.36</cvs_revision>
> > >>      <cvs_tag> </cvs_tag>
> > >>      <executable>GUS::PluginMgr::GusApplication</executable>
> > >>      <executable_md5>5947e17c4e9fea1d750cb5d9aaeee1db</executable_md5>
> > >>      <description>update for GUS 3.0</description>
> > >>      <Core::AlgorithmInvocation>
> > >>        <start_time>sysdate</start_time>
> > >>        <end_time>sysdate</end_time>
> > >>        <machine_id>0</machine_id>
> > >>        <cpus_used>1</cpus_used>
> > >>        <result>meta</result>
> > >>      </Core::AlgorithmInvocation>
> > >>    </Core::AlgorithmImplementation>
> > >>  </Core::Algorithm>
> > >>DBD::Oracle::st execute failed: ORA-01400: cannot insert NULL into
> > >>("CORE"."ALGORITHM"."ROW_USER_ID") (DBD ERROR: OCIStmtExecute) at
> > >>/home/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 138.
> > >>
> > >> SQL ERROR!! involving
> > >>
> > >>    INSERT INTO Core.Algorithm (  description, other_read, user_write,
> > >>group_write, name, modification_date, user_read, algorithm_id,
> > >>row_alg_invocation_id, group_read, other_write )
> > >>    VALUES   (  ?, ?, ?, ?, ?, SYSDATE, ?, ?, ?, ?, ? )
> > >> Values: GUS application framework for plugins, 1, 1, 1, GA-Plugin, 1, 45,
> > >>1, 1, 0 at /home/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 178
> > >>
> > >>GUS::ObjRelP::DbiDbHandle::death('GUS::ObjRelP::DbiDbHandle=HASH(0x84ee5e8)',
> > >>'^J SQL ERROR!! involving^J ^J    INSERT INTO Core.Algorithm (  desc...')
> > >>called at /home/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 141
> > >>
> > >>GUS::ObjRelP::DbiDbHandle::sqlExec('GUS::ObjRelP::DbiDbHandle=HASH(0x84ee5e8)',
> > >>'GUS::ObjRelP::DbiDbHandle::st=HASH(0x86b7f10)', 'ARRAY(0x86b7f64)', '^J
> > >>INSERT INTO Core.Algorithm (  description, other_read, user...') called at
> > >>/home/gus_home/lib/perl/GUS/ObjRelP/DbiRow.pm line 694
> > >>
> > >>GUS::ObjRelP::DbiRow::quote_and_insert('GUS::Model::Core::Algorithm=HASH(0x84ee42c)',
> > >>'GUS::Model::Core::Algorithm', 'HASH(0x85f7aa0)') called at
> > >>/home/gus_home/lib/perl/GUS/ObjRelP/DbiRow.pm line 641
> > >>
> > >>GUS::ObjRelP::DbiRow::insert('GUS::Model::Core::Algorithm=HASH(0x84ee42c)')
> > >>called at /home/gus_home/lib/perl/GUS/Model/GusRow.pm line 1677
> > >>
> > >>GUS::Model::GusRow::submit('GUS::Model::Core::Algorithm=HASH(0x84ee42c)')
> > >>called at /home/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm line 339
> > >>
> > >>GUS::PluginMgr::GusApplication::doMajorMode_Meta('GUS::PluginMgr::GusApplication=HASH(0x80fbb0c)',
> > >>undef) called at /home/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm
> > >>line 283
> > >>
> > >>GUS::PluginMgr::GusApplication::doMajorMode('GUS::PluginMgr::GusApplication=HASH(0x80fbb0c)',
> > >>undef) called at /home/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm
> > >>line 192
> > >>
> > >>GUS::PluginMgr::GusApplication::parseAndRun('GUS::PluginMgr::GusApplication=HASH(0x80fbb0c)',
> > >>'ARRAY(0x8105130)') called at /home/gus_home/bin/ga line 11
> > >>[chetna@mango install]$
> > >>
> > >>Thanks,
> > >>Chetna
> > >>
> > >>
> > >>
> > >>>can you get the install.tar and the gus.tar files again from cvsweb at
> > >>>sanger.
> > >>>
> > >>>we have fixed an important problem that was introduced in the last few
> > >>>days, and i think that will fix your problem.
> > >>>
> > >>>i just tested ga +meta --commit here and it seemed fine.
> > >>>
> > >>>steve
> > >>>
> > >>>Chetna Warade wrote:
> > >>>
> > >>>
> > >>>
> > >>>>Hi Steve,
> > >>>>
> > >>>>Thanks for the mail.
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>>1) can you send me the lines that you commented, so i can fix the problem.
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>$GUS_HOME/lib/perl/GUS/ObjRelP/DbiDatabase.pm
> > >>>>line # 148
> > >>>>line # 469
> > >>>>line # 478
> > >>>>Basically wherever string BIG (Actually BIGRBS1 in gus 3.0) appears.
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>>2) the problem is that the tarball is excluding empty directories.  for
> > >>>>>now, create the following directories:
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>Thanks build is working correct now. But here's what I get:
> > >>>>
> > >>>>[chetna@mango chetna]$ ga +meta --commit
> > >>>>Reading properties from /home/gus_home/config/GUS-PluginMgr.prop
> > >>>>Reading properties from /home/chetna/.gus.properties
> > >>>> <Core::Algorithm>
> > >>>>   <name>GA-Plugin</name>
> > >>>>   <description>GUS application framework for plugins</description>
> > >>>>   <Core::AlgorithmImplementation>
> > >>>>     <cvs_revision>1.33</cvs_revision>
> > >>>>     <cvs_tag> </cvs_tag>
> > >>>>     <executable>GUS::PluginMgr::GusApplication</executable>
> > >>>>     <executable_md5>0f9925c1794c069d858378c052a9d747</executable_md5>
> > >>>>     <description>update for GUS 3.0</description>
> > >>>>     <Core::AlgorithmInvocation>
> > >>>>       <start_time>sysdate</start_time>
> > >>>>       <end_time>sysdate</end_time>
> > >>>>       <machine_id>0</machine_id>
> > >>>>       <cpus_used>1</cpus_used>
> > >>>>       <result>meta</result>
> > >>>>     </Core::AlgorithmInvocation>
> > >>>>   </Core::AlgorithmImplementation>
> > >>>> </Core::Algorithm>
> > >>>>DBD::Oracle::st execute failed: ORA-01400: cannot insert NULL into
> > >>>>("CORE"."ALGORITHM"."ROW_USER_ID") (DBD ERROR: OCIStmtExecute) at
> > >>>>/home/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 137.
> > >>>>
> > >>>>SQL ERROR!! involving
> > >>>>
> > >>>>   INSERT INTO Core.Algorithm (  description, other_read, user_write,
> > >>>>group_write, name, modification_date, user_read, algorithm_id,
> > >>>>row_alg_invocation_id, group_read, other_write )
> > >>>>   VALUES   (  ?, ?, ?, ?, ?, SYSDATE, ?, ?, ?, ?, ? )
> > >>>>Values: GUS application framework for plugins, 1, 1, 1, GA-Plugin, 1, 23,
> > >>>>1, 1, 0 at /home/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 177.
> > >>>>[chetna@mango chetna]$
> > >>>>
> > >>>>Hope to hear from you
> > >>>>Chetna
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>
> > >>>
> > >>
> > >>-------------------------------------------------------
> > >>This SF.net email is sponsored by:Crypto Challenge is now open!
> > >>Get cracking and register here for some mind boggling fun and
> > >>the chance of winning an Apple iPod:
> > >>http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> > >>_______________________________________________
> > >>Gusdev-gusdev mailing list
> > >>Gus...@li...
> > >>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
> > >>
> > >>
> > >>
> > >
> > >
> > >
> > >-------------------------------------------------------
> > >This SF.net email is sponsored by:Crypto Challenge is now open!
> > >Get cracking and register here for some mind boggling fun and
> > >the chance of winning an Apple iPod:
> > >http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> > >_______________________________________________
> > >Gusdev-gusdev mailing list
> > >Gus...@li...
> > >https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by:Crypto Challenge is now open!
> > Get cracking and register here for some mind boggling fun and
> > the chance of winning an Apple iPod:
> > http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> > _______________________________________________
> > Gusdev-gusdev mailing list
> > Gus...@li...
> > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
> >
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open!
> Get cracking and register here for some mind boggling fun and
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>

-- 
Elisabetta Manduchi

Computational Biology and Informatics Laboratory
Center for Bioinformatics
University of Pennsylvania
1428 Blockley Hall
423 Guardian Drive
Philadelphia, PA 19104-6021

phone: 215-573-4408
fax: 215 573-3111
email: man...@pc...
web: http://www.cbil.upenn.edu/~manduchi

---