Menu
▾
▴
Re: [Gusdev-gusdev] Setting up your initial Users, etc
|
From: Chetna W. <ch...@ar...> - 2003-03-24 16:50:30
|
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
> >>
> >>
> >>
> >
> >
> >
> >
>
>
|
