Menu
▾
▴
Re: [Gusdev-gusdev] Setting up your initial Users, etc
|
From: steve f. <sfi...@pc...> - 2003-03-24 19:37:44
|
chetna-
can you send your .gus.properties file?
thanks,
steve
Chetna Warade wrote:
>Hi Steve,
>
>Thanks for the mail. As you said I changed userLogin == login of
>core.userinfo so the error msg "ORA-01400: cannot insert NULL into
>("CORE"."ALGORITHM"."ROW_USER_ID")" is gone. But now
>
>DBD::Oracle::st execute failed: ORA-01400: cannot insert NULL into
>("CORE"."ALGORITHM"."ROW_GROUP_ID") (DBD ERROR: OCIStmtExecute) at
>/home/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 138.
>
>is coming. I verified that core.groupinfo has "ctegd" as name and "2" as
>its group_id but I am wondering why's the ga getting null value
>
>Hope to hear from you
>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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>
>>
>
>
>
>
|
