Menu
▾
▴
Re: [GUSDEV] GUS install problem with Postgres and Mac OSX
|
From: Nicolas J. <nic...@gm...> - 2012-03-22 13:28:52
|
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 >>>> _______________________________________________ >>>> Gusdev-gusdev mailing list >>>> Gus...@li... >>>> 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 >> Gus...@li... >> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev >> >> > > > -- > Atc, > Rodrigo Jardim > jar...@gm... > > > |
