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

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

chetna-

userName from gus.properties corresponds to the login attribute of 
core.userinfo.

i know this is confusing (we have known about this but didn't get to 
fixing it)

i think that we should consider renaming the property in .gus.property to:
  userLogin=sfischer

the databaseLogin is something like this:
  databaseLogin=GUSrw

meanwhile, i plan on improving the error message ga puts out in this 
case so that it won't be hard to figure out what is going on.

steve

Chetna Warade wrote:

>Hi Dave,
>
>Yes I knew from gus 2.0 that the user in gus properties correspond to the
>oracle user login. Is this true in gus 3.0 too - meaning databaseLogin in 
>.gus.properties correspond to user_id in the core.userinfo. And is
>userName any important (I did make the FIRST_NAME in Core.userinfo equal
>to the $USER of .gus.properties).
>
>Thanks
>Chetna
>
>  
>
>>Forgot to mention this the first time; is the user you added in
>>Core.UserInfo the same as the one in your .gus.properties file?
>>
>>If it is, then sorry, that's probably the extent of my usefulness in
>>solving this problem!
>>
>>dave
>>
>>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
>>>
>>>      
>>>
>>
>>-------------------------------------------------------
>>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
>>
>>    
>>
>
>
>  
>