Menu
▾
▴
Re: [GUSDEV] GUS install problem with Postgres and Mac OSX
|
From: John I. <io...@gm...> - 2012-03-22 14:15:24
|
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 <http://jdbc.postgresql.org/download.html>, >>> 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<http://jdbc.postgresql.org/documentation/83/connect.html>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 <http://p.sf.net/sfu/sfd2d-msazure> >>>>> _______________________________________________ >>>>> Gusdev-gusdev mailing list >>>>> Gusdev-gusdev@lists.sourceforge.net<Gus...@li...> >>>>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev<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 <http://p.sf.net/sfu/sfd2d-msazure> >>> _______________________________________________ >>> Gusdev-gusdev mailing list >>> Gusdev-gusdev@lists.sourceforge.net<Gus...@li...> >>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev<https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev> >>> >>> >> >> >> -- >> Atc, >> Rodrigo Jardim >> jar...@gm... >> >> >> > |
