Menu
▾
▴
Re: [GUSDEV] GUS install problem with Postgres and Mac OSX
|
From: Mark H. <mh...@ug...> - 2012-03-22 14:24:11
|
I have confirmed that the ojdbc jar is required for the code to compile. -Mark On Mar 22, 2012, at 10:09 AM, John Iodice wrote: > Hi Nicolas, > > That dbVendor setting looks right; I think that your configuration is correct for a Postgres install (and that I was mistaken to think that the install is looking for oracle.jdbc.OracleDriver because it's configured to use Oracle). > > Looking in my own $GUS_HOME/lib/java/db_driver directory, I see that I have both Oracle and Postgres drivers, though I only use Oracle. Maybe both are required to compile the Java? These are the files I have there: > > $ ls $GUS_HOME/lib/java/db_driver/ > ojdbc5.jar postgresql-8.3-603.jdbc3.jar > > I see that ojdbc5.jar does contain oracle/jdbc/OracleDriver.class. I suggest you try downloading that jarfile. You can get it from here: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-111060-084321.html > > -- John > > On Thu, Mar 22, 2012 at 9:28 AM, Nicolas Joannin <nic...@gm...> wrote: > Hi Rodrigo, > > I will not be able to test before tomorrow morning (it's almost bedtime for me here in Japan), but I will try modifying these settings when I get to work in the morning. > The settings that I have tried are as follow: > > dbVendor=Postgres > dbiDsn=dbi:Pg:dbname=<my_db_name> > jdbcDsn=jdbc:postgresql:<my_db_name> > > databaseLogin=<my_db_user_name> > databasePassword=<my_db_password> > > I set the dbiDsn and jdbcDsn like that because, according to what Google told me, it seemed that those settings where acceptable when the database was on the local machine. > Obviously, I'm rather new to dealing with databases in general, so it is highly possible that I misread or misunderstood what I read... However, just out of curiosity, are these settings totally and systematically wrong and I should never have tried them in the first place or may these settings have possibly worked in a different context? > > In any case, I greatly appreciate your help, both John and Rodrigo! > Best regards, > > Nicolas > > > On Thu, Mar 22, 2012 at 22:09, Rodrigo Jardim <jar...@gm...> wrote: > Hi John, > > follow: > > dbVendor=Postgres > dbiDsn=dbi:Pg:dbname=<your_database_name>;host=<your_database_server_ip> > jdbcDsn=jdbc:postgresql://<your_database_server_ip>/<your_database_name> > > # Login and Password to the RDBMS > databaseLogin=<your_database_user_name> > databasePassword=<your_database_password> > > Regards, > > > > 2012/3/22 Nicolas Joannin <nic...@gm...> > Hi John, > > I don't have access to my work machine at the moment, but I can tell you for sure that the dbvendor is set to Postgres. > > I am rather new at working with databases, so my research into the problem may be misguided... However, could it be linked to the version of the jdbc driver? At this link, they seem to say that for JVM v1.6, one should use a jdbc4, whereas the GUS install uses a jdbc3. The current MacOSX 10.6 uses JVM v1.6. > > Also, I wasn't quite sure what to put for the "jdbcDsn", so I ended up using jdbcDsn=jdbc:postgresql:<database_name>. > (I chose that after reading this page and because the database is on the local machine.) > > Otherwise, please let me know if there is any other information that may be useful. > Best regards, > Nicolas > > On Thu, Mar 22, 2012 at 21:20, John Iodice <io...@gm...> wrote: > Hi Nicolas, > > It seems odd that the install is looking for an Oracle driver when you're using Postgres. What's the value of the "dbVendor" property in your GUS config file? Is it set to "Postgres"? > > -- John > > On Thu, Mar 22, 2012 at 12:42 AM, Nicolas Joannin <nic...@gm...> wrote: > Hello, > > I'm trying to install GUS, but have encountered a problem I cannot figure out. > I have looked at the mailing list archive, but haven't found anything that helps. > > In the output I get from the terminal (see below), there is a warning about 'includeantruntime' that comes back several times. Other then that, it stops with '/Users/Nicolas/GUS/project_home/GusSchema/build.xml:63: Unable to locate class'. > > I'm working with the following: > Mac OSX 10.6.8 fully updated > Perl v5.14.2 built for darwin-thread-multi-2level (with 1 registered patch) > Ant version 1.8.3 > PostgreSQL 9.1.1 > > Let me know if you need more information. > > Thank you in advance for any help you can give me! > Best regards, > Nicolas > > > > > Here is the terminal output I got: > > Nicolas-work-iMac:bin Nicolas$ ./build GUS install -append -installDBSchema > Buildfile: /Users/Nicolas/GUS/project_home/install/build.xml > > install: > [echo] proj=GUS > [echo] comp= > > defaultComponentInstall: > [echo] . > [echo] Installing CBIL/Bio > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > defaultComponentInstall: > [echo] . > [echo] Installing CBIL/CSP > > defaultJavaCompile: > [javac] /Users/Nicolas/GUS/project_home/install/build.xml:332: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > defaultComponentInstall: > [echo] . > [echo] Installing CBIL/Util > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > defaultComponentInstall: > [echo] . > [echo] Installing CBIL/Cider > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > defaultComponentInstall: > [echo] . > [echo] Installing CBIL/HQ > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > defaultComponentInstall: > [echo] . > [echo] Installing CBIL/TranscriptExpression > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > defaultComponentInstall: > [echo] . > [echo] Installing CBIL/ObjectMapper > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > defaultComponentInstall: > [echo] . > [echo] Installing GUS/Supported > > defaultJavaCompile: > [javac] /Users/Nicolas/GUS/project_home/install/build.xml:332: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > defaultComponentInstall: > [echo] . > [echo] Installing GUS/Community > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > defaultComponentInstall: > [echo] . > [echo] Installing GUS/DBAdmin > > defaultJavaCompile: > [javac] /Users/Nicolas/GUS/project_home/install/build.xml:332: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > defaultComponentInstall: > [echo] . > [echo] Installing GUS/GOPredict > > defaultJavaCompile: > [javac] /Users/Nicolas/GUS/project_home/install/build.xml:332: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > defaultComponentInstall: > [echo] . > [echo] Installing GusSchema/Definition > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > defaultComponentInstall: > [echo] . > [echo] Installing GUS/DBAdmin > > defaultJavaCompile: > [javac] /Users/Nicolas/GUS/project_home/install/build.xml:332: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds > > recordBuildState: > [propertyfile] Updating property file: /Users/Nicolas/GUS/gus_home/config/.build.info > > InstallSchema: > [InstallSchema] FATAL [main] (InstallSchemaTask.java:170) - Unable to locate class > [InstallSchema] java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver > [InstallSchema] at org.apache.tools.ant.AntClassLoader.findClassInComponents(AntClassLoader.java:1365) > [InstallSchema] at org.apache.tools.ant.AntClassLoader.findClass(AntClassLoader.java:1315) > [InstallSchema] at org.apache.tools.ant.AntClassLoader.loadClass(AntClassLoader.java:1068) > [InstallSchema] at java.lang.ClassLoader.loadClass(ClassLoader.java:247) > [InstallSchema] at java.lang.Class.forName0(Native Method) > [InstallSchema] at java.lang.Class.forName(Class.java:169) > [InstallSchema] at org.gusdb.dbadmin.util.InstallSchemaTask.initialize(InstallSchemaTask.java:167) > [InstallSchema] at org.gusdb.dbadmin.util.InstallSchemaTask.execute(InstallSchemaTask.java:62) > [InstallSchema] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) > [InstallSchema] at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) > [InstallSchema] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > [InstallSchema] at java.lang.reflect.Method.invoke(Method.java:597) > [InstallSchema] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) > [InstallSchema] at org.apache.tools.ant.Task.perform(Task.java:348) > [InstallSchema] at org.apache.tools.ant.Target.execute(Target.java:392) > [InstallSchema] at org.apache.tools.ant.Target.performTasks(Target.java:413) > [InstallSchema] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399) > [InstallSchema] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) > [InstallSchema] at org.apache.tools.ant.Project.executeTargets(Project.java:1251) > [InstallSchema] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442) > [InstallSchema] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) > [InstallSchema] at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) > [InstallSchema] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > [InstallSchema] at java.lang.reflect.Method.invoke(Method.java:597) > [InstallSchema] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) > [InstallSchema] at org.apache.tools.ant.Task.perform(Task.java:348) > [InstallSchema] at org.apache.tools.ant.Target.execute(Target.java:392) > [InstallSchema] at org.apache.tools.ant.Target.performTasks(Target.java:413) > [InstallSchema] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399) > [InstallSchema] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) > [InstallSchema] at org.apache.tools.ant.Project.executeTargets(Project.java:1251) > [InstallSchema] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442) > [InstallSchema] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) > [InstallSchema] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > [InstallSchema] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > [InstallSchema] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > [InstallSchema] at java.lang.reflect.Method.invoke(Method.java:597) > [InstallSchema] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) > [InstallSchema] at org.apache.tools.ant.Task.perform(Task.java:348) > [InstallSchema] at org.apache.tools.ant.Target.execute(Target.java:392) > [InstallSchema] at org.apache.tools.ant.Target.performTasks(Target.java:413) > [InstallSchema] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399) > [InstallSchema] at org.apache.tools.ant.Project.executeTarget(Project.java:1368) > [InstallSchema] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) > [InstallSchema] at org.apache.tools.ant.Project.executeTargets(Project.java:1251) > [InstallSchema] at org.apache.tools.ant.Main.runBuild(Main.java:811) > [InstallSchema] at org.apache.tools.ant.Main.startAnt(Main.java:217) > [InstallSchema] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280) > [InstallSchema] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109) > > BUILD FAILED > /Users/Nicolas/GUS/project_home/install/build.xml:38: The following error occurred while executing this line: > /Users/Nicolas/GUS/project_home/GUS/build.xml:16: The following error occurred while executing this line: > /Users/Nicolas/GUS/project_home/GusSchema/build.xml:63: Unable to locate class > > Total time: 18 seconds > > > > > ------------------------------------------------------------------------------ > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here > http://p.sf.net/sfu/sfd2d-msazure > _______________________________________________ > Gusdev-gusdev mailing list > Gusdev-gusdev@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > > > > > ------------------------------------------------------------------------------ > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here > http://p.sf.net/sfu/sfd2d-msazure > _______________________________________________ > Gusdev-gusdev mailing list > Gusdev-gusdev@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > > > > > -- > Atc, > Rodrigo Jardim > jar...@gm... > > > > > ------------------------------------------------------------------------------ > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here > http://p.sf.net/sfu/sfd2d-msazure_______________________________________________ > Gusdev-gusdev mailing list > Gus...@li... > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev |
