Menu
▾
▴
Re: [Gusdev-gusdev] Setting up your initial Users, etc
|
From: Chetna W. <ch...@ar...> - 2003-03-24 19:48:50
|
Hi Steve,
Thanks for the mail.
I am done with the ga +meta --commit. I am attaching the document that I
prepared for solving this problem.
Thanks
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
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >
> >
> >
> >
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>
|
