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

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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
> 