Menu
▾
▴
gusdev-gusdev — Topics concerning GUS development
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(11) |
Jul
(34) |
Aug
(14) |
Sep
(10) |
Oct
(10) |
Nov
(11) |
Dec
(6) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(56) |
Feb
(76) |
Mar
(68) |
Apr
(11) |
May
(97) |
Jun
(16) |
Jul
(29) |
Aug
(35) |
Sep
(18) |
Oct
(32) |
Nov
(23) |
Dec
(77) |
| 2004 |
Jan
(52) |
Feb
(44) |
Mar
(55) |
Apr
(38) |
May
(106) |
Jun
(82) |
Jul
(76) |
Aug
(47) |
Sep
(36) |
Oct
(56) |
Nov
(46) |
Dec
(61) |
| 2005 |
Jan
(52) |
Feb
(118) |
Mar
(41) |
Apr
(40) |
May
(35) |
Jun
(99) |
Jul
(84) |
Aug
(104) |
Sep
(53) |
Oct
(107) |
Nov
(68) |
Dec
(30) |
| 2006 |
Jan
(19) |
Feb
(27) |
Mar
(24) |
Apr
(9) |
May
(22) |
Jun
(11) |
Jul
(34) |
Aug
(8) |
Sep
(15) |
Oct
(55) |
Nov
(16) |
Dec
(2) |
| 2007 |
Jan
(12) |
Feb
(4) |
Mar
(8) |
Apr
|
May
(19) |
Jun
(3) |
Jul
(1) |
Aug
(6) |
Sep
(12) |
Oct
(3) |
Nov
|
Dec
|
| 2008 |
Jan
(4) |
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
(21) |
| 2009 |
Jan
|
Feb
(2) |
Mar
(1) |
Apr
|
May
(1) |
Jun
(8) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2010 |
Jan
|
Feb
(1) |
Mar
(4) |
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
|
Mar
|
Apr
(4) |
May
(19) |
Jun
(14) |
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2012 |
Jan
|
Feb
|
Mar
(22) |
Apr
(12) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2013 |
Jan
(2) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(3) |
Jun
|
Jul
|
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(1) |
Feb
(1) |
Mar
|
Apr
(1) |
May
|
Jun
(2) |
Jul
(1) |
Aug
|
Sep
|
Oct
(1) |
Nov
(1) |
Dec
|
| 2017 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Thomas O. <th...@gm...> - 2004-01-15 16:21:32
|
Hello, just finished with the installation of the Oracle and GUS... Because it was a kind of fight for me, just want to post my errors and problems I had, to show the difficulties for new people. First you have to download a lot of packages... the idea: with the cvs you will download the gus shemas. The ant builds the oracle schemas and will install all modules, mainly perl modules. Do following order: I. http://www.gusdb.org/documentation/install-setup.html to point 7. download of GUS in the $PROJECT_HOME directory: cvs -d :pserver:cv...@cv...:/cvsroot/GUS login login is CVSUSER and then cvs -z 3 -d :pserver:cv...@cv...:/cvsroot/GUS co install GUS II.then follow http://www.gusdb.org/documentation/installguide_UGA.html until INITIAL DATA SETUP FOR GUS 3.0 note: (a) for installing the Oracle on your system, see the OTN page of Oracle for help! (...down theses days) or google around (b) Call your DB GUS-instance gus, it will make it more easy... set the $ORACLE_SID=gus + export it!!! (c) play with netca until i.e sqlplus system/password@gus works III. next help is: http://www.gusdb.org/documentation/installguide.html take care during the initiation of the tablespace! It must have the same name than later in the file $GUS_HOME/config/schema.prop!!! There are also missing 2 for the app appVer user. In this file there is also a bug: replaced these lines: oracle_rad3=RAD3 oracle_rad3Password=password5 oracle_rad3ver=RAD3Ver oracle_rad3verPassword=password5 with these: oracle_rad=RAD oracle_radPassword=password5 oracle_radver=RADVer oracle_radverPassword=password5 and (think to initiate the tabel space for these too) oracle_app=app oracle_appPassword=password6 oracle_appTablespace=tablespace6 oracle_appIndexTablespace=tablespace6 oracle_appver=appVer oracle_appverPassword=password6 oracle_appverTablespace=tablespace6 in rad3-views.sql changed these lines: Later in rad3-views.sql changed these lines: (after the second build!) from RAD3.ANALYSISRESULTIMP FROM RAD3.CompositeElementResultImp to: from RAD.ANALYSISRESULTIMP FROM RAD.CompositeElementResultImp and in rad3ver-views.sql changed these lines: FROM RAD3ver.ANALYSISRESULTIMPver FROM rad3ver.AnalysisResultImpver; FROM RAD3Ver.CompositeElementResultImpVer; to: FROM RADver.ANALYSISRESULTIMPver FROM radver.AnalysisResultImpver; FROM RADVer.CompositeElementResultImpVer; Compare for theses changes the mail from Matthew Hobbs, the 7.01.03! Look in the log files, if everything is build correctly! I had some problems with the tablespace, something new for mysql users! IV. Do the rest of http://www.gusdb.org/documentation/installguide_UGA.html Hope this is not too redundad and might help someone! Cheers, Thomas |
|
From: Steve F. <sfi...@pc...> - 2004-01-14 16:22:07
|
sounds like you are moving along. no problem.... keep the questions coming. steve Thomas Otto wrote: >Dear Steve, > >I just reinstalled everything with another user... now the files were >installed. Guess my problem was, because of the multiple partly installa= tion of the >create-sh.sql script, that not very table was installed. Now the files a= re >there...=20 >Still couldn't register ga - I have a "ORA-12154: TNS:could not resolve >service name" problem to solve with my DB, but that's another story ;-) > >So sorry to bother you - thanks for helping, >abra=E7o, > >Thomas > > =20 > >>thomas- >> >>at this point, it would probably help if we had a phone call. can we=20 >>try to set up a time to do so? >> >>i am usually in my office from 10:00 to 6:00 Eastern time, USA. >> >>steve >> >>Thomas Otto wrote: >> >> =20 >> >>>Steve-=20 >>>Michael - >>> >>>I did the build, also the @INC has the path included. Indeed, I think = the >>>problem is the ant building, during the build I got this 2 warnings: >>>... >>> [echo] Installing CBIL/Util >>> [concat] Warning: Could not find any of the files specified in conca= t >>>task. >>>... >>> [echo] Installing GUS/RAD >>> [concat] Warning: Could not find any of the files specified in conca= t >>>task. >>> >>>I also did several times the build, with the changes in the build.xml. >>>Maybe the problem is more during the download with cvs (what I also tr= ied >>>several times)... I did: >>>cvs -d :pserver:cv...@cv...:/cvsroot/GUS login and then >>>cvs -z 3 -d :pserver:cv...@cv...:/cvsroot/GUS co instal= l >>> =20 >>> >>GUS >> =20 >> >>>where I got following msg: >>>? GUS/TMP.XmL >>>? GUS/buildorg.xml >>>? GUS/Model/lib/perl/App >>>... >>> >>>=20 >>> >>> =20 >>> >>>>Do you have a checkouts directory AND a gus_home directory? >>>> =20 >>>> >>>> =20 >>>> >>>What is the checkouts directory? I follow the diverses installations >>>scripts... >>>=20 >>> >>> =20 >>> >>>>What does your gus properties file look like? >>>> =20 >>>> >>>> =20 >>>> >>>databaseLogin=3DGUSrw # are created >>>databasePassword=3D<passwd> >>>readOnlyDatabaseLogin=3DGUSdevReadOnly =20 >>>readOnlyDatabasePassword=3D<passwd> # are created >>>coreSchemaName=3DCore >>>userName=3Dotto #here not sure, but i tried different >>>group=3Dusers >>>project=3Dgus >>>dbiDsn=3Ddbi:Oracle:host=3Dlocalhost;sid=3Dgus >>> >>>Actually I tried different stuff for the userName. Also dba/sysdba, >>> =20 >>> >>oracle >> =20 >> >>>(Oracle user), but it would be good, because this is just a test >>> =20 >>> >>installation, >> =20 >> >>>and later we will use a 'real' oracleDB, where the admin has the right= s >>> =20 >>> >>of >> =20 >> >>>sysdba, not us. >>> >>>Cheers, >>> >>>Thomas >>> >>>=20 >>> >>> =20 >>> >>>>Thomas- >>>> >>>>The directory GUS/Model/Core should contain .pm files that represent = GUS >>>> =20 >>>> >>>>tables. GUS has an '"object layer" in perl. Each table is=20 >>>>represented by a perl .pm file. The files are *code generated* by th= e=20 >>>>build command. =20 >>>> >>>>have you run the build command? >>>> >>>>steve >>>> >>>>Thomas Otto wrote: >>>> >>>> =20 >>>> >>>> =20 >>>> >>>>>Hey, >>>>> >>>>>finally installed the schemas in the oracle, at least it looks like >>>>> =20 >>>>> >>(had >> =20 >> >>>>>some problems like Mathews). >>>>> >>>>>But now I am stucked, trying to register the ga: ga +meta --commit >>>>>Can't locate GUS/Model/Core/AlgorithmImplementation.pm in @INC (@INC >>>>>contains: /home/otto/gus_home ... >>>>> >>>>>Actually the GUS/Model/Core directory is empty... >>>>> >>>>>Did I do an error before, can't find this perl class somewhere. >>>>> >>>>>Hope for help, thanks, >>>>>Thomas >>>>> >>>>> >>>>> >>>>>------------------------------------------------------- >>>>>This SF.net email is sponsored by: Perforce Software. >>>>>Perforce is the Fast Software Configuration Management System offeri= ng >>>>>advanced branching capabilities and atomic changes on 50+ platforms. >>>>>Free Eval! http://www.perforce.com/perforce/loadprog.html >>>>>_______________________________________________ >>>>>Gusdev-gusdev mailing list >>>>>Gus...@li... >>>>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev >>>>> >>>>> >>>>> =20 >>>>> >>>>> =20 >>>>> >>>>------------------------------------------------------- >>>>This SF.net email is sponsored by: Perforce Software. >>>>Perforce is the Fast Software Configuration Management System offerin= g >>>>advanced branching capabilities and atomic changes on 50+ platforms. >>>>Free Eval! http://www.perforce.com/perforce/loadprog.html >>>>_______________________________________________ >>>>Gusdev-gusdev mailing list >>>>Gus...@li... >>>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev >>>> >>>> =20 >>>> >>>> =20 >>>> >> >>------------------------------------------------------- >>This SF.net email is sponsored by: Perforce Software. >>Perforce is the Fast Software Configuration Management System offering >>advanced branching capabilities and atomic changes on 50+ platforms. >>Free Eval! http://www.perforce.com/perforce/loadprog.html >>_______________________________________________ >>Gusdev-gusdev mailing list >>Gus...@li... >>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev >> >> =20 >> |
|
From: Thomas O. <th...@gm...> - 2004-01-14 16:15:12
|
Dear Steve, I just reinstalled everything with another user... now the files were installed. Guess my problem was, because of the multiple partly installation of the create-sh.sql script, that not very table was installed. Now the files are there... Still couldn't register ga - I have a "ORA-12154: TNS:could not resolve service name" problem to solve with my DB, but that's another story ;-) So sorry to bother you - thanks for helping, abraço, Thomas > thomas- > > at this point, it would probably help if we had a phone call. can we > try to set up a time to do so? > > i am usually in my office from 10:00 to 6:00 Eastern time, USA. > > steve > > Thomas Otto wrote: > > >Steve- > >Michael - > > > >I did the build, also the @INC has the path included. Indeed, I think the > >problem is the ant building, during the build I got this 2 warnings: > >... > > [echo] Installing CBIL/Util > > [concat] Warning: Could not find any of the files specified in concat > >task. > > ... > > [echo] Installing GUS/RAD > > [concat] Warning: Could not find any of the files specified in concat > >task. > > > >I also did several times the build, with the changes in the build.xml. > >Maybe the problem is more during the download with cvs (what I also tried > >several times)... I did: > >cvs -d :pserver:cv...@cv...:/cvsroot/GUS login and then > >cvs -z 3 -d :pserver:cv...@cv...:/cvsroot/GUS co install > GUS > >where I got following msg: > >? GUS/TMP.XmL > >? GUS/buildorg.xml > >? GUS/Model/lib/perl/App > >... > > > > > > > >>Do you have a checkouts directory AND a gus_home directory? > >> > >> > >What is the checkouts directory? I follow the diverses installations > >scripts... > > > > > >>What does your gus properties file look like? > >> > >> > >databaseLogin=GUSrw # are created > >databasePassword=<passwd> > >readOnlyDatabaseLogin=GUSdevReadOnly > >readOnlyDatabasePassword=<passwd> # are created > >coreSchemaName=Core > >userName=otto #here not sure, but i tried different > >group=users > >project=gus > >dbiDsn=dbi:Oracle:host=localhost;sid=gus > > > >Actually I tried different stuff for the userName. Also dba/sysdba, > oracle > >(Oracle user), but it would be good, because this is just a test > installation, > >and later we will use a 'real' oracleDB, where the admin has the rights > of > >sysdba, not us. > > > >Cheers, > > > >Thomas > > > > > > > >>Thomas- > >> > >>The directory GUS/Model/Core should contain .pm files that represent GUS > > >>tables. GUS has an '"object layer" in perl. Each table is > >>represented by a perl .pm file. The files are *code generated* by the > >>build command. > >> > >>have you run the build command? > >> > >>steve > >> > >>Thomas Otto wrote: > >> > >> > >> > >>>Hey, > >>> > >>>finally installed the schemas in the oracle, at least it looks like > (had > >>>some problems like Mathews). > >>> > >>>But now I am stucked, trying to register the ga: ga +meta --commit > >>>Can't locate GUS/Model/Core/AlgorithmImplementation.pm in @INC (@INC > >>>contains: /home/otto/gus_home ... > >>> > >>>Actually the GUS/Model/Core directory is empty... > >>> > >>>Did I do an error before, can't find this perl class somewhere. > >>> > >>>Hope for help, thanks, > >>>Thomas > >>> > >>> > >>> > >>>------------------------------------------------------- > >>>This SF.net email is sponsored by: Perforce Software. > >>>Perforce is the Fast Software Configuration Management System offering > >>>advanced branching capabilities and atomic changes on 50+ platforms. > >>>Free Eval! http://www.perforce.com/perforce/loadprog.html > >>>_______________________________________________ > >>>Gusdev-gusdev mailing list > >>>Gus...@li... > >>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > >>> > >>> > >>> > >>> > >> > >>------------------------------------------------------- > >>This SF.net email is sponsored by: Perforce Software. > >>Perforce is the Fast Software Configuration Management System offering > >>advanced branching capabilities and atomic changes on 50+ platforms. > >>Free Eval! http://www.perforce.com/perforce/loadprog.html > >>_______________________________________________ > >>Gusdev-gusdev mailing list > >>Gus...@li... > >>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > >> > >> > >> > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Perforce Software. > Perforce is the Fast Software Configuration Management System offering > advanced branching capabilities and atomic changes on 50+ platforms. > Free Eval! http://www.perforce.com/perforce/loadprog.html > _______________________________________________ > Gusdev-gusdev mailing list > Gus...@li... > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > |
|
From: Steve F. <sfi...@pc...> - 2004-01-14 15:08:18
|
thomas- at this point, it would probably help if we had a phone call. can we try to set up a time to do so? i am usually in my office from 10:00 to 6:00 Eastern time, USA. steve Thomas Otto wrote: >Steve- >Michael - > >I did the build, also the @INC has the path included. Indeed, I think the >problem is the ant building, during the build I got this 2 warnings: >... > [echo] Installing CBIL/Util > [concat] Warning: Could not find any of the files specified in concat >task. > ... > [echo] Installing GUS/RAD > [concat] Warning: Could not find any of the files specified in concat >task. > >I also did several times the build, with the changes in the build.xml. >Maybe the problem is more during the download with cvs (what I also tried >several times)... I did: >cvs -d :pserver:cv...@cv...:/cvsroot/GUS login and then >cvs -z 3 -d :pserver:cv...@cv...:/cvsroot/GUS co install GUS >where I got following msg: >? GUS/TMP.XmL >? GUS/buildorg.xml >? GUS/Model/lib/perl/App >... > > > >>Do you have a checkouts directory AND a gus_home directory? >> >> >What is the checkouts directory? I follow the diverses installations >scripts... > > >>What does your gus properties file look like? >> >> >databaseLogin=GUSrw # are created >databasePassword=<passwd> >readOnlyDatabaseLogin=GUSdevReadOnly >readOnlyDatabasePassword=<passwd> # are created >coreSchemaName=Core >userName=otto #here not sure, but i tried different >group=users >project=gus >dbiDsn=dbi:Oracle:host=localhost;sid=gus > >Actually I tried different stuff for the userName. Also dba/sysdba, oracle >(Oracle user), but it would be good, because this is just a test installation, >and later we will use a 'real' oracleDB, where the admin has the rights of >sysdba, not us. > >Cheers, > >Thomas > > > >>Thomas- >> >>The directory GUS/Model/Core should contain .pm files that represent GUS >>tables. GUS has an '"object layer" in perl. Each table is >>represented by a perl .pm file. The files are *code generated* by the >>build command. >> >>have you run the build command? >> >>steve >> >>Thomas Otto wrote: >> >> >> >>>Hey, >>> >>>finally installed the schemas in the oracle, at least it looks like (had >>>some problems like Mathews). >>> >>>But now I am stucked, trying to register the ga: ga +meta --commit >>>Can't locate GUS/Model/Core/AlgorithmImplementation.pm in @INC (@INC >>>contains: /home/otto/gus_home ... >>> >>>Actually the GUS/Model/Core directory is empty... >>> >>>Did I do an error before, can't find this perl class somewhere. >>> >>>Hope for help, thanks, >>>Thomas >>> >>> >>> >>>------------------------------------------------------- >>>This SF.net email is sponsored by: Perforce Software. >>>Perforce is the Fast Software Configuration Management System offering >>>advanced branching capabilities and atomic changes on 50+ platforms. >>>Free Eval! http://www.perforce.com/perforce/loadprog.html >>>_______________________________________________ >>>Gusdev-gusdev mailing list >>>Gus...@li... >>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev >>> >>> >>> >>> >> >>------------------------------------------------------- >>This SF.net email is sponsored by: Perforce Software. >>Perforce is the Fast Software Configuration Management System offering >>advanced branching capabilities and atomic changes on 50+ platforms. >>Free Eval! http://www.perforce.com/perforce/loadprog.html >>_______________________________________________ >>Gusdev-gusdev mailing list >>Gus...@li... >>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev >> >> >> |
|
From: Steve F. <sfi...@pc...> - 2004-01-14 15:07:27
|
thomas- as a start, do this, and send me the results: cd $PROJECT_HOME ls * steve Thomas Otto wrote: >Steve- >Michael - > >I did the build, also the @INC has the path included. Indeed, I think the >problem is the ant building, during the build I got this 2 warnings: >... > [echo] Installing CBIL/Util > [concat] Warning: Could not find any of the files specified in concat >task. > ... > [echo] Installing GUS/RAD > [concat] Warning: Could not find any of the files specified in concat >task. > >I also did several times the build, with the changes in the build.xml. >Maybe the problem is more during the download with cvs (what I also tried >several times)... I did: >cvs -d :pserver:cv...@cv...:/cvsroot/GUS login and then >cvs -z 3 -d :pserver:cv...@cv...:/cvsroot/GUS co install GUS >where I got following msg: >? GUS/TMP.XmL >? GUS/buildorg.xml >? GUS/Model/lib/perl/App >... > > > >>Do you have a checkouts directory AND a gus_home directory? >> >> >What is the checkouts directory? I follow the diverses installations >scripts... > > >>What does your gus properties file look like? >> >> >databaseLogin=GUSrw # are created >databasePassword=<passwd> >readOnlyDatabaseLogin=GUSdevReadOnly >readOnlyDatabasePassword=<passwd> # are created >coreSchemaName=Core >userName=otto #here not sure, but i tried different >group=users >project=gus >dbiDsn=dbi:Oracle:host=localhost;sid=gus > >Actually I tried different stuff for the userName. Also dba/sysdba, oracle >(Oracle user), but it would be good, because this is just a test installation, >and later we will use a 'real' oracleDB, where the admin has the rights of >sysdba, not us. > >Cheers, > >Thomas > > > >>Thomas- >> >>The directory GUS/Model/Core should contain .pm files that represent GUS >>tables. GUS has an '"object layer" in perl. Each table is >>represented by a perl .pm file. The files are *code generated* by the >>build command. >> >>have you run the build command? >> >>steve >> >>Thomas Otto wrote: >> >> >> >>>Hey, >>> >>>finally installed the schemas in the oracle, at least it looks like (had >>>some problems like Mathews). >>> >>>But now I am stucked, trying to register the ga: ga +meta --commit >>>Can't locate GUS/Model/Core/AlgorithmImplementation.pm in @INC (@INC >>>contains: /home/otto/gus_home ... >>> >>>Actually the GUS/Model/Core directory is empty... >>> >>>Did I do an error before, can't find this perl class somewhere. >>> >>>Hope for help, thanks, >>>Thomas >>> >>> >>> >>>------------------------------------------------------- >>>This SF.net email is sponsored by: Perforce Software. >>>Perforce is the Fast Software Configuration Management System offering >>>advanced branching capabilities and atomic changes on 50+ platforms. >>>Free Eval! http://www.perforce.com/perforce/loadprog.html >>>_______________________________________________ >>>Gusdev-gusdev mailing list >>>Gus...@li... >>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev >>> >>> >>> >>> >> >>------------------------------------------------------- >>This SF.net email is sponsored by: Perforce Software. >>Perforce is the Fast Software Configuration Management System offering >>advanced branching capabilities and atomic changes on 50+ platforms. >>Free Eval! http://www.perforce.com/perforce/loadprog.html >>_______________________________________________ >>Gusdev-gusdev mailing list >>Gus...@li... >>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev >> >> >> |
|
From: Thomas O. <th...@gm...> - 2004-01-14 12:12:47
|
Steve-
Michael -
I did the build, also the @INC has the path included. Indeed, I think the
problem is the ant building, during the build I got this 2 warnings:
...
[echo] Installing CBIL/Util
[concat] Warning: Could not find any of the files specified in concat
task.
...
[echo] Installing GUS/RAD
[concat] Warning: Could not find any of the files specified in concat
task.
I also did several times the build, with the changes in the build.xml.
Maybe the problem is more during the download with cvs (what I also tried
several times)... I did:
cvs -d :pserver:cv...@cv...:/cvsroot/GUS login and then
cvs -z 3 -d :pserver:cv...@cv...:/cvsroot/GUS co install GUS
where I got following msg:
? GUS/TMP.XmL
? GUS/buildorg.xml
? GUS/Model/lib/perl/App
...
>Do you have a checkouts directory AND a gus_home directory?
What is the checkouts directory? I follow the diverses installations
scripts...
>What does your gus properties file look like?
databaseLogin=GUSrw # are created
databasePassword=<passwd>
readOnlyDatabaseLogin=GUSdevReadOnly
readOnlyDatabasePassword=<passwd> # are created
coreSchemaName=Core
userName=otto #here not sure, but i tried different
group=users
project=gus
dbiDsn=dbi:Oracle:host=localhost;sid=gus
Actually I tried different stuff for the userName. Also dba/sysdba, oracle
(Oracle user), but it would be good, because this is just a test installation,
and later we will use a 'real' oracleDB, where the admin has the rights of
sysdba, not us.
Cheers,
Thomas
> Thomas-
>
> The directory GUS/Model/Core should contain .pm files that represent GUS
> tables. GUS has an '"object layer" in perl. Each table is
> represented by a perl .pm file. The files are *code generated* by the
> build command.
>
> have you run the build command?
>
> steve
>
> Thomas Otto wrote:
>
> >Hey,
> >
> >finally installed the schemas in the oracle, at least it looks like (had
> >some problems like Mathews).
> >
> >But now I am stucked, trying to register the ga: ga +meta --commit
> >Can't locate GUS/Model/Core/AlgorithmImplementation.pm in @INC (@INC
> >contains: /home/otto/gus_home ...
> >
> >Actually the GUS/Model/Core directory is empty...
> >
> >Did I do an error before, can't find this perl class somewhere.
> >
> >Hope for help, thanks,
> >Thomas
> >
> >
> >
> >-------------------------------------------------------
> >This SF.net email is sponsored by: Perforce Software.
> >Perforce is the Fast Software Configuration Management System offering
> >advanced branching capabilities and atomic changes on 50+ platforms.
> >Free Eval! http://www.perforce.com/perforce/loadprog.html
> >_______________________________________________
> >Gusdev-gusdev mailing list
> >Gus...@li...
> >https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
> >
> >
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>
|
|
From: Steve F. <sfi...@pc...> - 2004-01-13 20:59:48
|
Thomas- The directory GUS/Model/Core should contain .pm files that represent GUS tables. GUS has an '"object layer" in perl. Each table is represented by a perl .pm file. The files are *code generated* by the build command. have you run the build command? steve Thomas Otto wrote: >Hey, > >finally installed the schemas in the oracle, at least it looks like (had >some problems like Mathews). > >But now I am stucked, trying to register the ga: ga +meta --commit >Can't locate GUS/Model/Core/AlgorithmImplementation.pm in @INC (@INC >contains: /home/otto/gus_home ... > >Actually the GUS/Model/Core directory is empty... > >Did I do an error before, can't find this perl class somewhere. > >Hope for help, thanks, >Thomas > > > >------------------------------------------------------- >This SF.net email is sponsored by: Perforce Software. >Perforce is the Fast Software Configuration Management System offering >advanced branching capabilities and atomic changes on 50+ platforms. >Free Eval! http://www.perforce.com/perforce/loadprog.html >_______________________________________________ >Gusdev-gusdev mailing list >Gus...@li... >https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > > |
|
From: MICHAEL L. <lu...@cs...> - 2004-01-13 19:51:45
|
Thomas- If $GUS_HOME=/home/otto/gus_home, then you need to have $GUS_HOME/lib/perl in @INC If $GUS_HOME/lib/perl/GUS/Model/Core is empty, then you might not have built Gus correctly (using ant). Do you have a checkouts directory AND a gus_home directory? What does your gus properties file look like? Michael Luchtan http://www.cs.uga.edu/~luchtan On Tue, 13 Jan 2004, Thomas Otto wrote: > Hey, > > finally installed the schemas in the oracle, at least it looks like (had > some problems like Mathews). > > But now I am stucked, trying to register the ga: ga +meta --commit > Can't locate GUS/Model/Core/AlgorithmImplementation.pm in @INC (@INC > contains: /home/otto/gus_home ... > > Actually the GUS/Model/Core directory is empty... > > Did I do an error before, can't find this perl class somewhere. > > Hope for help, thanks, > Thomas > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Perforce Software. > Perforce is the Fast Software Configuration Management System offering > advanced branching capabilities and atomic changes on 50+ platforms. > Free Eval! http://www.perforce.com/perforce/loadprog.html > _______________________________________________ > Gusdev-gusdev mailing list > Gus...@li... > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > |
|
From: Thomas O. <th...@gm...> - 2004-01-13 01:14:25
|
Hey, finally installed the schemas in the oracle, at least it looks like (had some problems like Mathews). But now I am stucked, trying to register the ga: ga +meta --commit Can't locate GUS/Model/Core/AlgorithmImplementation.pm in @INC (@INC contains: /home/otto/gus_home ... Actually the GUS/Model/Core directory is empty... Did I do an error before, can't find this perl class somewhere. Hope for help, thanks, Thomas |
|
From: Steve F. <sfi...@pc...> - 2004-01-09 17:01:39
|
awesome. just mail it to me. steve Sucheta Tripathy wrote: >Hi All, > >We at VBI have been working on the GUS schema implementation. We(mostly >Fidel Salas) have documented the steps and processes in great detail and >we would like to release the first version of our documentation. > >I am sure this will help others trying out things as we did. > >I was wondering if this can be integrated to the gusdb site. > >Sucheta > > > |
|
From: Sucheta T. <su...@vb...> - 2004-01-09 16:47:20
|
Hi All, We at VBI have been working on the GUS schema implementation. We(mostly Fidel Salas) have documented the steps and processes in great detail and we would like to release the first version of our documentation. I am sure this will help others trying out things as we did. I was wondering if this can be integrated to the gusdb site. Sucheta -- Sucheta Tripathy Virginia Bioinformatics Institute 1880 Pratt Drive,Bldg XV Virginia Tech. Blacksburg Virginia VA 24061 phone-(540)231-8138 |
|
From: Angel P. <an...@pc...> - 2004-01-08 19:55:28
|
Hey Matthew, Thanks for finding all of the bugs in the schema code for me. I will update them and commit to CVS. Angel Matthew Hobbs wrote: >Thanks Angel - this made things much clearer to me. > > >On Wed, 7 Jan 2004 02:17 am, you wrote: > > >>schmea.prop does indeed get read by the build process, and not by >>create-db.sh >>The build process should read schema.prop and do macro replacements on >>all of the SQL files that create a GUS instance. >> >>For example, the "@oracle_rad@" macro should have been replaced by the >>value in schema.prop for oracle_rad, but I just checked and there is not >>one there. There is a "oracle_rad3=RAD3", so this is my mistake as a >>result of dumping GUS 3.1 and trying to get rid of a historic version >>number from the RAD schema's name. So when you are runnning the $GUSHOME >>SQL files, that particular macro was (erroneously) not replaced. Sorry >>about that. The simple thing to do is to replace "rad3" with "rad" in >>the schema.prop file wherever you find it. Including the uppercase. (I >>just did so in my local copy and will commit it to CVS shortly) >> >> > > >I ended up making these changes to schema.prop: > >i) replaced these lines: > >oracle_rad3=RAD3 >oracle_rad3Password=password5 >oracle_rad3ver=RAD3Ver >oracle_rad3verPassword=password5 > >with these: > >oracle_rad=RAD >oracle_radPassword=password5 >oracle_radver=RADVer >oracle_radverPassword=password5 > >ii) added lines something like this (but with nice passwords): > >oracle_app=app >oracle_appPassword=password6 >oracle_appTablespace=tablespace6 >oracle_appIndexTablespace=tablespace6 > >oracle_appver=appVer >oracle_appverPassword=password6 >oracle_appverTablespace=tablespace6 > > >Does this look sensible? > > >Also I note that these lines don't seem to be necessary as the variables are >not used in any SQL statements: > >oracle_coreverIndexTablespace=indextablespace1 >oracle_sresverIndexTablespace=indextablespace2 >oracle_tessverIndexTablespace=tablespace4 >oracle_rad3verIndexTablespace=tablespace5 > >because dotsver is the only 'ver' database (whatever that is ) to be indexed. >Does that sound correct? > > >I also made some changes to view-creating SQL files where 'RAD3' was >inappropriately used instead of 'RAD'. > >in rad3-views.sql changed these lines: > >from RAD3.ANALYSISRESULTIMP >FROM RAD3.CompositeElementResultImp > >to: > >from RAD.ANALYSISRESULTIMP >FROM RAD.CompositeElementResultImp > > >and in rad3ver-views.sql changed these lines: > >FROM RAD3ver.ANALYSISRESULTIMPver >FROM rad3ver.AnalysisResultImpver; >FROM RAD3Ver.CompositeElementResultImpVer; > >to: > >FROM RADver.ANALYSISRESULTIMPver >FROM radver.AnalysisResultImpver; >FROM RADVer.CompositeElementResultImpVer; > > >After these edits I was able to run create-db.sh without any errors! > >Now on with the installation.... > > >Matthew > > > |
|
From: Elisabetta M. <man...@pc...> - 2004-01-07 12:36:57
|
Hi Matthew, at least as far as the RAD Study-Annotator is concerned, instructions as to what entries need to be present and some dumps from our instance of RAD can be found in the README file of the Study Annotator Tarball. The most recent release of the latter is v. 1.1.0 (released this week) and is available at http://www.cbil.upenn.edu/downloads/RAD/. Elisabetta On Wed, 7 Jan 2004, Matthew Hobbs wrote: > Hi, > > I am keen to try to set up a local version of RAD. Having passed through the > ordeal of Oracle installation, and more recently having managed to build GUS, > I would now like to populate some of the GUS tables and do whatever else is > necessary to start using the system. Sadly the installguide.html document > seems to be unfinished (I am very interested to know what section 2.10 might > have said!) Can anyone give me some advice about how to proceed - should I > now be installing the RAD Study-Annotator or is there more GUS-specific stuff > to do first? > > Thanks again, > > > Matthew |
|
From: MICHAEL L. <lu...@cs...> - 2004-01-07 04:08:57
|
Off the top of my head, here are some tables that you need to hand enter--- I'm not sure which are pertinent to RAD: SequenceType Project external database external database release Algorithm--I think Taxonomy . . . Can any recent installations remember which tables you had to hand enter to get started? Michael Luchtan http://www.cs.uga.edu/~luchtan On Wed, 7 Jan 2004, Matthew Hobbs wrote: > Hi, > > I am keen to try to set up a local version of RAD. Having passed through the > ordeal of Oracle installation, and more recently having managed to build GUS, > I would now like to populate some of the GUS tables and do whatever else is > necessary to start using the system. Sadly the installguide.html document > seems to be unfinished (I am very interested to know what section 2.10 might > have said!) Can anyone give me some advice about how to proceed - should I > now be installing the RAD Study-Annotator or is there more GUS-specific stuff > to do first? > > Thanks again, > > > Matthew > > -- > Matthew Hobbs Research Fellow in Bioinformatics > Faculty of Veterinary Science > Building B19, University of Sydney, NSW 2006, Australia > Phone: +61 2 9351 3154 Fax: +61 2 93513957 > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IBM Linux Tutorials. > Become an expert in LINUX or just sharpen your skills. Sign up for IBM's > Free Linux Tutorials. Learn everything from the bash shell to sys admin. > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click > _______________________________________________ > Gusdev-gusdev mailing list > Gus...@li... > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > |
|
From: Matthew H. <mat...@ve...> - 2004-01-07 03:06:27
|
Hi, I am keen to try to set up a local version of RAD. Having passed through the ordeal of Oracle installation, and more recently having managed to build GUS, I would now like to populate some of the GUS tables and do whatever else is necessary to start using the system. Sadly the installguide.html document seems to be unfinished (I am very interested to know what section 2.10 might have said!) Can anyone give me some advice about how to proceed - should I now be installing the RAD Study-Annotator or is there more GUS-specific stuff to do first? Thanks again, Matthew -- Matthew Hobbs Research Fellow in Bioinformatics Faculty of Veterinary Science Building B19, University of Sydney, NSW 2006, Australia Phone: +61 2 9351 3154 Fax: +61 2 93513957 |
|
From: Matthew H. <mat...@ve...> - 2004-01-07 02:17:43
|
After fixing create-db.sh problems I was able to successfully run the third 'build' which I guess means I have successfully built GUS. I am very grateful for the help I was given. Matthew -- Matthew Hobbs Research Fellow in Bioinformatics Faculty of Veterinary Science Building B19, University of Sydney, NSW 2006, Australia Phone: +61 2 9351 3154 Fax: +61 2 93513957 |
|
From: Matthew H. <mat...@ve...> - 2004-01-07 02:08:11
|
Thanks Angel - this made things much clearer to me. On Wed, 7 Jan 2004 02:17 am, you wrote: > schmea.prop does indeed get read by the build process, and not by > create-db.sh > The build process should read schema.prop and do macro replacements on > all of the SQL files that create a GUS instance. > > For example, the "@oracle_rad@" macro should have been replaced by the > value in schema.prop for oracle_rad, but I just checked and there is not > one there. There is a "oracle_rad3=RAD3", so this is my mistake as a > result of dumping GUS 3.1 and trying to get rid of a historic version > number from the RAD schema's name. So when you are runnning the $GUSHOME > SQL files, that particular macro was (erroneously) not replaced. Sorry > about that. The simple thing to do is to replace "rad3" with "rad" in > the schema.prop file wherever you find it. Including the uppercase. (I > just did so in my local copy and will commit it to CVS shortly) I ended up making these changes to schema.prop: i) replaced these lines: oracle_rad3=RAD3 oracle_rad3Password=password5 oracle_rad3ver=RAD3Ver oracle_rad3verPassword=password5 with these: oracle_rad=RAD oracle_radPassword=password5 oracle_radver=RADVer oracle_radverPassword=password5 ii) added lines something like this (but with nice passwords): oracle_app=app oracle_appPassword=password6 oracle_appTablespace=tablespace6 oracle_appIndexTablespace=tablespace6 oracle_appver=appVer oracle_appverPassword=password6 oracle_appverTablespace=tablespace6 Does this look sensible? Also I note that these lines don't seem to be necessary as the variables are not used in any SQL statements: oracle_coreverIndexTablespace=indextablespace1 oracle_sresverIndexTablespace=indextablespace2 oracle_tessverIndexTablespace=tablespace4 oracle_rad3verIndexTablespace=tablespace5 because dotsver is the only 'ver' database (whatever that is ) to be indexed. Does that sound correct? I also made some changes to view-creating SQL files where 'RAD3' was inappropriately used instead of 'RAD'. in rad3-views.sql changed these lines: from RAD3.ANALYSISRESULTIMP FROM RAD3.CompositeElementResultImp to: from RAD.ANALYSISRESULTIMP FROM RAD.CompositeElementResultImp and in rad3ver-views.sql changed these lines: FROM RAD3ver.ANALYSISRESULTIMPver FROM rad3ver.AnalysisResultImpver; FROM RAD3Ver.CompositeElementResultImpVer; to: FROM RADver.ANALYSISRESULTIMPver FROM radver.AnalysisResultImpver; FROM RADVer.CompositeElementResultImpVer; After these edits I was able to run create-db.sh without any errors! Now on with the installation.... Matthew -- Matthew Hobbs Research Fellow in Bioinformatics Faculty of Veterinary Science Building B19, University of Sydney, NSW 2006, Australia Phone: +61 2 9351 3154 Fax: +61 2 93513957 |
|
From: Steve F. <sfi...@pc...> - 2004-01-06 17:47:35
|
Yes, there is a bug. It is in the schema.prop file. Angel's previous
mail tells how to fix it, which, in sum, is change the line:
oracle_rad3=RAD3
to:
oracle_rad=RAD3
Steve
Fidel Salas wrote:
>Matthew,
>
>I think the gus distribution you have is buggy. This is assuming you
>downloaded your distribution recently. I also noticed the same
>behavior when trying to install recently. Since I had an older
>distribution that did not give similar errors to the ones you reported
>below when running create-db.sh, I used that instead.
>
>If you have not solved the problems you are having, you can get the
>tar file that works for me until the bugs in the current distribution
>are fixed.
>
>You will then have to update some files with more current versions.
>
>Fidel
>
>
> > From: Matthew Hobbs <mat...@ve...>
> > Organization: Innovative Dairy Products CRC
> > To: gus...@li...
> > Subject: Re: [Gusdev-gusdev] more help with installation please
> > Date: Tue, 6 Jan 2004 13:13:48 +1100
> >
> > Thanks Angel and Steve for your replies to my previous message.
> >
> > I am however still struggling with this installation! I am still getting
> > errors when running create-db.sh. Angel advises me to 'use the schema.prop
> > file for setting appropriate logins and tablespace usage' but I don't
> > understand how schema.prop and create-db.sh could interact. schema.prop is
> > referrred to in GUS/build.xml and is used by ant in the build - but this is
> > not where I am having my problem. As explained in installguide.html the
> > build must be run three times. Between build 2 and build 3 the createdb.sh
> > script is run. How is create-db.sh supposed to read any of the information
> > in schema.prop?
> >
> > Having created some more tablespaces (answering my own previous question) the
> > first error reported by create-db.sh is now:
> >
> >
> > SQL> DROP USER @oracle_rad@ CASCADE;
> > DROP USER @oracle_rad@ CASCADE
> > *
> > ERROR at line 1:
> > ORA-01935: missing user or role name
> >
> >
> > This is the first place in the input sql file that '@' notation is
> > encountered. I guess @oracle_rad@ is a variable but SQL*Plus doesn't know
> > its value. Is the value is supposed to be read from schema.prop (a wild
> > guess but schema.prop does seem to have assignemnts of values to similar
> > names like 'oracle_rad3')???
> >
> >
> > Again I would be grateful for help.
> >
> >
> > Thanks,
> >
> >
> > Matthew
> >
> >
> >
> >
> > --
> > Matthew Hobbs Research Fellow in Bioinformatics
> > Faculty of Veterinary Science
> > Building B19, University of Sydney, NSW 2006, Australia
> > Phone: +61 2 9351 3154 Fax: +61 2 93513957
> >
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: IBM Linux Tutorials.
>Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
>Free Linux Tutorials. Learn everything from the bash shell to sys admin.
>Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
>_______________________________________________
>Gusdev-gusdev mailing list
>Gus...@li...
>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>
>
|
|
From: Fidel S. <fi...@vb...> - 2004-01-06 17:12:34
|
Matthew, I think the gus distribution you have is buggy. This is assuming you downloaded your distribution recently. I also noticed the same behavior when trying to install recently. Since I had an older distribution that did not give similar errors to the ones you reported below when running create-db.sh, I used that instead. If you have not solved the problems you are having, you can get the tar file that works for me until the bugs in the current distribution are fixed. You will then have to update some files with more current versions. Fidel > From: Matthew Hobbs <mat...@ve...> > Organization: Innovative Dairy Products CRC > To: gus...@li... > Subject: Re: [Gusdev-gusdev] more help with installation please > Date: Tue, 6 Jan 2004 13:13:48 +1100 > > Thanks Angel and Steve for your replies to my previous message. > > I am however still struggling with this installation! I am still getting > errors when running create-db.sh. Angel advises me to 'use the schema.prop > file for setting appropriate logins and tablespace usage' but I don't > understand how schema.prop and create-db.sh could interact. schema.prop is > referrred to in GUS/build.xml and is used by ant in the build - but this is > not where I am having my problem. As explained in installguide.html the > build must be run three times. Between build 2 and build 3 the createdb.sh > script is run. How is create-db.sh supposed to read any of the information > in schema.prop? > > Having created some more tablespaces (answering my own previous question) the > first error reported by create-db.sh is now: > > > SQL> DROP USER @oracle_rad@ CASCADE; > DROP USER @oracle_rad@ CASCADE > * > ERROR at line 1: > ORA-01935: missing user or role name > > > This is the first place in the input sql file that '@' notation is > encountered. I guess @oracle_rad@ is a variable but SQL*Plus doesn't know > its value. Is the value is supposed to be read from schema.prop (a wild > guess but schema.prop does seem to have assignemnts of values to similar > names like 'oracle_rad3')??? > > > Again I would be grateful for help. > > > Thanks, > > > Matthew > > > > > -- > Matthew Hobbs Research Fellow in Bioinformatics > Faculty of Veterinary Science > Building B19, University of Sydney, NSW 2006, Australia > Phone: +61 2 9351 3154 Fax: +61 2 93513957 > |
|
From: Fidel S. <fi...@vb...> - 2004-01-06 16:36:42
|
I need help in finding a quick solution to the following requirement. I need topology information for any given GenBank DNA sequence or entry. This information is found in the LOCUS line of a GenBank entry. For reasons unclear to me, the GBParser plugin parses this and then silently drops it. Since I am about to create a new GUS database, I would like to add a column to DoTS:NAEntry that will hold the topology information. The main question is: will I break anything if I add this column to the tables sql script? Also, what is the reason this information is dropped? I am assuming getting GBParser to populate this new column would involve just getting the objrelp generator to add set and get methods. Is this all that would need to be done? Thanks Fidel |
|
From: Angel P. <an...@pc...> - 2004-01-06 15:58:11
|
forgot to forward my reply to the list angel -------- Original Message -------- Subject: Re: [Gusdev-gusdev] more help with installation please Date: Tue, 06 Jan 2004 10:17:40 -0500 From: Angel Pizarro <an...@pc...> To: Matthew Hobbs <mat...@ve...> References: <200...@ve...> <3FF...@pc...> <200...@ve...> Matthew Hobbs wrote: >Thanks Angel and Steve for your replies to my previous message. > >I am however still struggling with this installation! I am still getting >errors when running create-db.sh. Angel advises me to 'use the schema.prop >file for setting appropriate logins and tablespace usage' but I don't >understand how schema.prop and create-db.sh could interact. schema.prop is >referrred to in GUS/build.xml and is used by ant in the build - but this is >not where I am having my problem. As explained in installguide.html the >build must be run three times. Between build 2 and build 3 the createdb.sh >script is run. How is create-db.sh supposed to read any of the information >in schema.prop? > > schmea.prop does indeed get read by the build process, and not by create-db.sh The build process should read schema.prop and do macro replacements on all of the SQL files that create a GUS instance. For example, the "@oracle_rad@" macro should have been replaced by the value in schema.prop for oracle_rad, but I just checked and there is not one there. There is a "oracle_rad3=RAD3", so this is my mistake as a result of dumping GUS 3.1 and trying to get rid of a historic version number from the RAD schema's name. So when you are runnning the $GUSHOME SQL files, that particular macro was (erroneously) not replaced. Sorry about that. The simple thing to do is to replace "rad3" with "rad" in the schema.prop file wherever you find it. Including the uppercase. (I just did so in my local copy and will commit it to CVS shortly) >Having created some more tablespaces (answering my own previous question) the >first error reported by create-db.sh is now: > > >SQL> DROP USER @oracle_rad@ CASCADE; >DROP USER @oracle_rad@ CASCADE > * >ERROR at line 1: >ORA-01935: missing user or role name > > >This is the first place in the input sql file that '@' notation is >encountered. I guess @oracle_rad@ is a variable but SQL*Plus doesn't know >its value. Is the value is supposed to be read from schema.prop (a wild >guess but schema.prop does seem to have assignemnts of values to similar >names like 'oracle_rad3')??? > Again yes, the the @some_variable@ macros are substituted in the build/install process with values from the schema.prop. So at least now you know where "tablespace1" came from ;) AND you should replace such minor strings "password*" for the login to something a bit more secure. You can now also customize the oracle tablespaces as you like for your particular installation. If this is just a test, I would use two tablespaces, one for indexes and the other for data. If not a test and you are limited in space, then I would separate the tablespaces as follows [DoTS], [RAD], [TESS,SRes,Core,App], [Indexes_DoTS], [Indexes_rest]. Otherwise, separate tablespaces for schema space and index space is best, but better names are recommended for easier admin (rad_data_tablespace, rad_index_tablspace, etc. ) Angel >Again I would be grateful for help. > > >Thanks, > > >Matthew > > > > > > |
|
From: Matthew H. <mat...@ve...> - 2004-01-06 02:13:58
|
Thanks Angel and Steve for your replies to my previous message.
I am however still struggling with this installation! I am still getting
errors when running create-db.sh. Angel advises me to 'use the schema.prop
file for setting appropriate logins and tablespace usage' but I don't
understand how schema.prop and create-db.sh could interact. schema.prop is
referrred to in GUS/build.xml and is used by ant in the build - but this is
not where I am having my problem. As explained in installguide.html the
build must be run three times. Between build 2 and build 3 the createdb.sh
script is run. How is create-db.sh supposed to read any of the information
in schema.prop?
Having created some more tablespaces (answering my own previous question) the
first error reported by create-db.sh is now:
SQL> DROP USER @oracle_rad@ CASCADE;
DROP USER @oracle_rad@ CASCADE
*
ERROR at line 1:
ORA-01935: missing user or role name
This is the first place in the input sql file that '@' notation is
encountered. I guess @oracle_rad@ is a variable but SQL*Plus doesn't know
its value. Is the value is supposed to be read from schema.prop (a wild
guess but schema.prop does seem to have assignemnts of values to similar
names like 'oracle_rad3')???
Again I would be grateful for help.
Thanks,
Matthew
--
Matthew Hobbs Research Fellow in Bioinformatics
Faculty of Veterinary Science
Building B19, University of Sydney, NSW 2006, Australia
Phone: +61 2 9351 3154 Fax: +61 2 93513957
|
|
From: Angel P. <an...@pc...> - 2004-01-05 15:40:34
|
I answer the second question. Matthew Hobbs wrote: >ii) More importantly I can't get create-db.sh to create the CORE user: > > >SQL> >SQL> CREATE USER Core IDENTIFIED BY password1 > 2 TEMPORARY TABLESPACE TEMP > 3 DEFAULT TABLESPACE tablespace1 > 4 QUOTA UNLIMITED ON TEMP > 5 QUOTA UNLIMITED ON tablespace1; >CREATE USER Core IDENTIFIED BY password1 >* >ERROR at line 1: >ORA-00959: tablespace 'TABLESPACE1' does not exist > > > "password1" and "tablespace1" should be replaces with appropriate values from your particular instance. These values are configurable from the GUS/Model/config/schema.prop prior to building GUS/Model/schema From that file: # The names, passwords, and tablespaces for the new users. # It is recommended that you do NOT change the default usernames # as this feature has not been fully tested (the username is the # first parameter in each group of four.) # oracle_core=Core oracle_corePassword=password1 oracle_coreTablespace=tablespace1 oracle_coreIndexTablespace=indextablespace1 > >Although I had created some tablespaces (gus_core, etc) using the table >initialization script 'installguide02.sql' these did not include TABLESPACE1 >et al. Should I do something like: > > Yeah, I don't know much about that script, but db administration particulars are a little outside the scope of a GUS install. Please use the schema.prop file for setting appropriate logins and tablespace usage. Angel > >create tablespace TABLESPACE1 >datafile '/usr/local/Oracle/oradata/gus/TABLESPACE1' size 200M >default storage (initial 4M next 1M pctincrease 0); > > > |
|
From: Steve F. <sfi...@pc...> - 2004-01-05 14:47:34
|
i can answer the first and third question. i'll forward this to our db folks here to entice them to answer the second question. - ignore the warning. - kind of a bummer that sourceforge doesn't offer archive search. we'll have to consider looking for an alternative host eventually. steve Matthew Hobbs wrote: >Thanks to everyone who replied to my previous request for help. (Seems I >should have read BOTH installation guides thoroughly - sorry!) > >I have progressed a bit further but still haven't completed the installation >so would appreciate more help with these problems please: > >i) This may be trivial but during the build I get this warning: > >[echo] Installing CBIL/Util >[concat] Warning: Could not find any of the files specified in concat task. > >Does this warning matter? > > > > >ii) More importantly I can't get create-db.sh to create the CORE user: > > >SQL> >SQL> CREATE USER Core IDENTIFIED BY password1 > 2 TEMPORARY TABLESPACE TEMP > 3 DEFAULT TABLESPACE tablespace1 > 4 QUOTA UNLIMITED ON TEMP > 5 QUOTA UNLIMITED ON tablespace1; >CREATE USER Core IDENTIFIED BY password1 >* >ERROR at line 1: >ORA-00959: tablespace 'TABLESPACE1' does not exist > > > >Although I had created some tablespaces (gus_core, etc) using the table >initialization script 'installguide02.sql' these did not include TABLESPACE1 >et al. Should I do something like: > > >create tablespace TABLESPACE1 >datafile '/usr/local/Oracle/oradata/gus/TABLESPACE1' size 200M >default storage (initial 4M next 1M pctincrease 0); > > > > > >iii) another trivial problem - I don't seem to be able to search the gusdev >mail list archives. Is the sourceforge mailarchive search facility working >for other people? > > >Thanks, > > >Matthew > > > > |
|
From: Matthew H. <mat...@ve...> - 2004-01-05 03:45:07
|
Thanks to everyone who replied to my previous request for help. (Seems I should have read BOTH installation guides thoroughly - sorry!) I have progressed a bit further but still haven't completed the installation so would appreciate more help with these problems please: i) This may be trivial but during the build I get this warning: [echo] Installing CBIL/Util [concat] Warning: Could not find any of the files specified in concat task. Does this warning matter? ii) More importantly I can't get create-db.sh to create the CORE user: SQL> SQL> CREATE USER Core IDENTIFIED BY password1 2 TEMPORARY TABLESPACE TEMP 3 DEFAULT TABLESPACE tablespace1 4 QUOTA UNLIMITED ON TEMP 5 QUOTA UNLIMITED ON tablespace1; CREATE USER Core IDENTIFIED BY password1 * ERROR at line 1: ORA-00959: tablespace 'TABLESPACE1' does not exist Although I had created some tablespaces (gus_core, etc) using the table initialization script 'installguide02.sql' these did not include TABLESPACE1 et al. Should I do something like: create tablespace TABLESPACE1 datafile '/usr/local/Oracle/oradata/gus/TABLESPACE1' size 200M default storage (initial 4M next 1M pctincrease 0); iii) another trivial problem - I don't seem to be able to search the gusdev mail list archives. Is the sourceforge mailarchive search facility working for other people? Thanks, Matthew -- Matthew Hobbs Research Fellow in Bioinformatics Faculty of Veterinary Science Building B19, University of Sydney, NSW 2006, Australia Phone: +61 2 9351 3154 Fax: +61 2 93513957 |
30 messages has been excluded from this view by a project administrator.
