Hello,What do you think about the error that I showed you? My installation is stoping. I can't deply the web application. I think it doesn't recognise the direction of my database because when PostgreSQL is started it isn´t found and it is replaced for h2 database (h2 isn´t my database).I hope you can help me.Thanks you.Regards,Celia
From: celiaalva...@hotmail.com
To: keith....@transmartfoundation.org
Subject: RE: Errors in the tranSMART installation
Date: Tue, 10 Nov 2015 14:55:23 +0100
Hello,I have intended to install both .war files but I obtain the same errors. When PostgreSQL is started it isn´t found and it is replaced for h2 database (h2 isn´t my database). When PostgreSQL is stopped I obtain the previous messages.catalina.outorg.apache.catalina.core.StandardContext startInternalGRAVE: One or more listeners failed to start. Full details will be found in the appropriate container log fileorg.apache.catalina.util.SessionIdGeneratorBase createSecureRandomINFORMACIÓN: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [19.883] milliseconds.org.apache.catalina.core.StandardContext startInternalGRAVE: Falló en arranque del Contexto [/transmart] debido a errores previosorg.apache.catalina.loader.WebappClassLoader clearReferencesJdbcGRAVE: La aplicación web [/transmart] registró el conductor JDBC [org.postgresql.Driver] pero falló al anular el registro mientras la aplicación web estaba parada. Para prevenir un fallo de memoria, se ha anulado el registro del conductor JDBC por la fuerza.org.apache.catalina.loader.WebappClassLoader clearReferencesJdbcGRAVE: La aplicación web [/transmart] registró el conductor JDBC [org.h2.Driver] pero falló al anular el registro mientras la aplicación web estaba parada. Para prevenir un fallo de memoria, se ha anulado el registro del conductor JDBC por la fuerza.Thanks you,Celia
From: celiaalva...@hotmail.com
To: keith....@transmartfoundation.org
Subject: RE: Errors in the tranSMART installation
Date: Mon, 9 Nov 2015 11:37:21 +0100
Hello,That error is solutioned, I have copied the configuration files in the directory /root/.grails/transmartConfig/But now I'm obtaining others errors: my database is PosgreSQL, when it is started it isn´t found and it is replaced for h2 database (h2 isn´t my database). When PostgreSQL is stopped I obtain the following messages:org.postgresql.util.PSQLException: Conexión rechazada. Verifique que el nombre del Host y el puerto sean correctos y que postmaster este aceptando conexiones TCP/IPcatalina.outorg.apache.catalina.core.StandardContext startInternalGRAVE: One or more listeners failed to start. Full details will be found in the appropriate container log fileorg.apache.catalina.util.SessionIdGeneratorBase createSecureRandomINFORMACIÓN: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [19.883] milliseconds.org.apache.catalina.core.StandardContext startInternalGRAVE: Falló en arranque del Contexto [/transmart] debido a errores previosorg.apache.catalina.loader.WebappClassLoader clearReferencesJdbcGRAVE: La aplicación web [/transmart] registró el conductor JDBC [org.postgresql.Driver] pero falló al anular el registro mientras la aplicación web estaba parada. Para prevenir un fallo de memoria, se ha anulado el registro del conductor JDBC por la fuerza.org.apache.catalina.loader.WebappClassLoader clearReferencesJdbcGRAVE: La aplicación web [/transmart] registró el conductor JDBC [org.h2.Driver] pero falló al anular el registro mientras la aplicación web estaba parada. Para prevenir un fallo de memoria, se ha anulado el registro del conductor JDBC por la fuerza.
What could I do?Thanks you.Best regards,Celia
Date: Fri, 6 Nov 2015 22:30:59 +0100
Subject: Re: Errors in the tranSMART installation
From: keith....@transmartfoundation.org
To: celiaalva...@hotmail.com
Dear Celia,It appears that there is a problem with the Postgres database. If you're not familiar with Postgres I can send you a command to theft whether it's running.Also could you describe your environment- version of UNIX etc., and the commands you used to pull the code (or just let me know if they were exactly as written on the wiki page).Best regards,
On Friday, November 6, 2015, Celia Alvarez Romero <celiaalva...@hotmail.com> wrote:Hello,I'm Celia Alvarez and I'm installing transmart in my server.I'm following the installation guide https://wiki.transmartfoundation.org/pages/viewpage.action?pageId=6619205 and I'm in the step 9. I'm deploying tranSMART web application but it doesn't operate.How could I use the server mode? How could I close all other connections?I hope you will help me, I want to finish the installation as soon as possible.Thanks you.The error is the following:Catalina.outfeb 11, 2012 3:27:56 PM org.apache.catalina.core.StandardServer awaitINFORMACIÓN: Se ha recibido un comando de apagado a través del puerto de apagado. Parando la instancia del Servidor.feb 11, 2012 3:27:56 PM org.apache.coyote.AbstractProtocol pauseINFORMACIÓN: Pausing ProtocolHandler ["http-apr-8080"]feb 11, 2012 3:27:56 PM org.apache.coyote.AbstractProtocol pauseINFORMACIÓN: Pausing ProtocolHandler ["http-apr-8081"]feb 11, 2012 3:27:56 PM org.apache.coyote.AbstractProtocol pauseINFORMACIÓN: Pausing ProtocolHandler ["ajp-apr-8009"]feb 11, 2012 3:27:56 PM org.apache.catalina.core.StandardService stopInternalINFORMACIÓN: Parando servicio Catalinafeb 11, 2012 3:27:56 PM org.apache.coyote.AbstractProtocol stopINFORMACIÓN: Stopping ProtocolHandler ["http-apr-8080"]feb 11, 2012 3:27:56 PM org.apache.coyote.AbstractProtocol stopINFORMACIÓN: Stopping ProtocolHandler ["http-apr-8081"]feb 11, 2012 3:27:57 PM org.apache.coyote.AbstractProtocol stopINFORMACIÓN: Stopping ProtocolHandler ["ajp-apr-8009"]feb 11, 2012 3:27:57 PM org.apache.coyote.AbstractProtocol destroyINFORMACIÓN: Destroying ProtocolHandler ["http-apr-8080"]feb 11, 2012 3:27:57 PM org.apache.coyote.AbstractProtocol destroyINFORMACIÓN: Destroying ProtocolHandler ["http-apr-8081"]feb 11, 2012 3:27:57 PM org.apache.coyote.AbstractProtocol destroyINFORMACIÓN: Destroying ProtocolHandler ["ajp-apr-8009"]feb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: Server version: Apache Tomcat/7.0.64feb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: Server built: Aug 19 2015 17:18:06 UTCfeb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: Server number: 7.0.64.0feb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: OS Name: Linuxfeb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: OS Version: 2.6.32-573.7.1.el6.x86_64feb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: Architecture: amd64feb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: Java Home: /usr/lib/jvm/java-1.7.0-openjdk-1.7.0.91.x86_64/jrefeb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: JVM Version: 1.7.0_91-mockbuild_2015_10_21_19_56-b00feb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: JVM Vendor: Oracle Corporationfeb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: CATALINA_BASE: /opt/tomcat7/apache-tomcat-7.0.64feb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: CATALINA_HOME: /opt/tomcat7/apache-tomcat-7.0.64feb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: Command line argument: -Djava.util.logging.config.file=/opt/tomcat7/apache-tomcat-7.0.64/conf/logging.propertiesfeb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManagerfeb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: Command line argument: -Xmx4096Mfeb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: Command line argument: -XX:MaxPermSize=1024Mfeb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: Command line argument: -Djava.endorsed.dirs=/opt/tomcat7/apache-tomcat-7.0.64/endorsedfeb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: Command line argument: -Dcatalina.base=/opt/tomcat7/apache-tomcat-7.0.64feb 11, 2012 3:28:02 PM org.apache.catalina.startup.VersionLoggerListener logINFORMACIÓN: Command line argument: -Dcatalina.home=/opt/tomcat7/apache-tomcat-7.0.64feb 11, 2012 3:28:02 PM org.apache.catalina.core.AprLifecycleListener lifecycleEventINFORMACIÓN: Cargada la biblioteca nativa APR de Apache Tomcat 1.1.33 con la versión APR 1.3.9.feb 11, 2012 3:28:02 PM org.apache.catalina.core.AprLifecycleListener lifecycleEventINFORMACIÓN: Capacidades APR: IPv6 [true], enviar fichero [true], aceptar filtros [false], aleatorio [true].feb 11, 2012 3:28:02 PM org.apache.catalina.core.AprLifecycleListener initializeSSLINFORMACIÓN: OpenSSL inicializado correctamente (OpenSSL 1.0.1e 11 Feb 2013)feb 11, 2012 3:28:02 PM org.apache.coyote.AbstractProtocol initINFORMACIÓN: Initializing ProtocolHandler ["http-apr-8080"]feb 11, 2012 3:28:02 PM org.apache.coyote.AbstractProtocol initINFORMACIÓN: Initializing ProtocolHandler ["http-apr-8081"]feb 11, 2012 3:28:02 PM org.apache.coyote.AbstractProtocol initINFORMACIÓN: Initializing ProtocolHandler ["ajp-apr-8009"]feb 11, 2012 3:28:02 PM org.apache.catalina.startup.Catalina loadINFORMACIÓN: Initialization processed in 618 msfeb 11, 2012 3:28:02 PM org.apache.catalina.core.StandardService startInternalINFORMACIÓN: Arrancando servicio Catalinafeb 11, 2012 3:28:02 PM org.apache.catalina.core.StandardEngine startInternalINFORMACIÓN: Starting Servlet Engine: Apache Tomcat/7.0.64feb 11, 2012 3:28:02 PM org.apache.catalina.startup.HostConfig deployWARINFORMACIÓN: Despliegue del archivo /opt/tomcat7/apache-tomcat-7.0.64/webapps/transmart.war de la aplicación webfeb 11, 2012 3:28:10 PM org.apache.catalina.startup.TaglibUriRule bodyINFORMACIÓN: TLD skipped. URI: http://java.sun.com/jsp/jstl/core is already definedfeb 11, 2012 3:28:10 PM org.apache.catalina.startup.TaglibUriRule bodyINFORMACIÓN: TLD skipped. URI: http://java.sun.com/jsp/jstl/fmt is already definedfeb 11, 2012 3:28:10 PM org.apache.catalina.startup.TaglibUriRule bodyINFORMACIÓN: TLD skipped. URI: http://www.springframework.org/tags is already definedfeb 11, 2012 3:28:10 PM org.apache.catalina.startup.TldConfig executeINFORMACIÓN: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.[INFO] Configuration file /root/.grails/transmartConfig/Config.groovy does not exist.[INFO] Configuration file /root/.grails/transmartConfig/DataSource.groovy does not exist.[INFO] Configuration file /root/.grails/transmartConfig/Config.groovy does not exist.[INFO] Configuration file /root/.grails/transmartConfig/DataSource.groovy does not exist.Configuring Spring Security Core ...... finished configuring Spring Security Core2012-02-11 15:28:34,617 [localhost-startStop-1] ERROR pool.ConnectionPool - Unable to create initial connections of pool.org.h2.jdbc.JdbcSQLException: La base de datos puede que ya esté siendo utilizada: "Locked by another process". Soluciones Posibles: cierre todas las otras conexiones; use el modo serverDatabase may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-176]at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)at org.h2.message.DbException.get(DbException.java:178)at org.h2.message.DbException.get(DbException.java:154)at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:462)at org.h2.store.FileLock.lockFile(FileLock.java:356)......at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1095)at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1930)at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)at java.util.concurrent.FutureTask.run(FutureTask.java:262)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)at java.lang.Thread.run(Thread.java:745)2012-02-11 15:28:37,027 [localhost-startStop-1] ERROR pool.ConnectionPool - Unable to create initial connections of pool.org.h2.jdbc.JdbcSQLException: La base de datos puede que ya esté siendo utilizada: "Locked by another process". Soluciones Posibles: cierre todas las otras conexiones; use el modo serverDatabase may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-176]at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)at org.h2.message.DbException.get(DbException.java:178)at org.h2.message.DbException.get(DbException.java:154)at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:462)at org.h2.store.FileLock.lockFile(FileLock.java:356)at org.h2.store.FileLock.lock(FileLock.java:136)at org.h2.engine.Database.open(Database.java:622)at org.h2.engine.Database.openDatabase(Database.java:260)at org.h2.engine.Database.<init>(Database.java:254)at org.h2.engine.Engine.openSession(Engine.java:57).......at java.util.concurrent.FutureTask.run(FutureTask.java:262)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)at java.lang.Thread.run(Thread.java:745)2012-02-11 15:28:39,134 [localhost-startStop-1] ERROR context.GrailsContextLoader - Error initializing the application: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'transactionManager_oauth2' while setting constructor argument with key [1]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager_oauth2': Cannot resolve reference to bean 'sessionFactory_oauth2' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory_oauth2': Cannot resolve reference to bean 'hibernateProperties_oauth2' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties_oauth2': Cannot resolve reference to bean 'dialectDetector_oauth2' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector_oauth2': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.h2.jdbc.JdbcSQLException: La base de datos puede que ya esté siendo utilizada: "Locked by another process". Soluciones Posibles: cierre todas las otras conexiones; use el modo serverDatabase may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-176]org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'transactionManager_oauth2' while setting constructor argument with key [1]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager_oauth2': Cannot resolve reference to bean 'sessionFactory_oauth2' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory_oauth2': Cannot resolve reference to bean 'hibernateProperties_oauth2' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties_oauth2': Cannot resolve reference to bean 'dialectDetector_oauth2' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector_oauth2': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.h2.jdbc.JdbcSQLException: La base de datos puede que ya esté siendo utilizada: "Locked by another process". Soluciones Posibles: cierre todas las otras conexiones; use el modo serverDatabase may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-176]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)at java.util.concurrent.FutureTask.run(FutureTask.java:262)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)at java.lang.Thread.run(Thread.java:745)Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'transactionManager_oauth2' while setting constructor argument with key [1]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager_oauth2': Cannot resolve reference to bean 'sessionFactory_oauth2' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory_oauth2': Cannot resolve reference to bean 'hibernateProperties_oauth2' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties_oauth2': Cannot resolve reference to bean 'dialectDetector_oauth2' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector_oauth2': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.h2.jdbc.JdbcSQLException: La base de datos puede que ya esté siendo utilizada: "Locked by another process". Soluciones Posibles: cierre todas las otras conexiones; use el modo serverDatabase may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-176]... 5 moreCaused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager_oauth2': Cannot resolve reference to bean 'sessionFactory_oauth2' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory_oauth2': Cannot resolve reference to bean 'hibernateProperties_oauth2' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties_oauth2': Cannot resolve reference to bean 'dialectDetector_oauth2' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector_oauth2': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.h2.jdbc.JdbcSQLException: La base de datos puede que ya esté siendo utilizada: "Locked by another process". Soluciones Posibles: cierre todas las otras conexiones; use el modo serverDatabase may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-176]... 5 moreCaused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory_oauth2': Cannot resolve reference to bean 'hibernateProperties_oauth2' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties_oauth2': Cannot resolve reference to bean 'dialectDetector_oauth2' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector_oauth2': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.h2.jdbc.JdbcSQLException: La base de datos puede que ya esté siendo utilizada: "Locked by another process". Soluciones Posibles: cierre todas las otras conexiones; use el modo server.....feb 11, 2012 3:28:39 PM org.apache.catalina.core.StandardContext startInternalGRAVE: One or more listeners failed to start. Full details will be found in the appropriate container log file....feb 11, 2012 3:29:22 PM org.apache.catalina.core.StandardContext startInternalGRAVE: Falló en arranque del Contexto [/transmart] debido a errores previosfeb 11, 2012 3:29:22 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbcGRAVE: La aplicación web [/transmart] registró el conductor JDBC [org.h2.Driver] pero falló al anular el registro mientras la aplicación web estaba parada. Para prevenir un fallo de memoria, se ha anulado el registro del conductor JDBC por la fuerza.......I show you the following files:TRANSMART CONFIG:BuildConfig.groovy/* Clone the pluginsʼ corresponding repository alongside transmartApp and* uncomment the settings below in order to use those plugins inline. See* under the heading ‘Specifying Plugin Locations’ for more information. *///grails.plugin.location.'rdc-rmodules' = '../Rmodules'//grails.plugin.location.'transmart-core' = '../core-db'//grails.plugin.location.'dalliance-plugin' = '../dalliance-plugin'//grails.plugin.location.'transmart-mydas' = '../transmart-mydas'grails.project.dependency.resolution = {repositories {mavenRepo([name: 'repo.thehyve.nl-public',])/* If you set the grails.project.dependency.resolution config property,* then the tranSMART Foundation repository will not be used (see the* in-tree BuildConfig.groovy). You can re-add it by uncommenting the* block below. It will have lower priority than the repositories listed* in BuildConfig.groovy (which have the highest priority) and the* repositories that are listed above it in this closure. */// mavenRepo([// name: 'repo.transmartfoundation.org-public',// ])}}// vim: filetype=groovy et ts=4 sts=4 sw=4 tw=80:Config.groovy/** NOTE* ----* This configuration assumes that the development environment will be used with* run-app and the production environment will be used with the application* packaged as a WAR and deployed to tomcat. Running grails run-war or otherwise* running a WAR with the development profile set up or activating the* production environment when running grails run-app are scenarios that have* NOT been tested.*/// if running as a WAR, we need thesedef catalinaBase = System.getProperty('catalina.base') ?: '.'def explodedWarDir = catalinaBase + '/webapps/transmart'def solrPort = 8983 //port of appserver where solr runs (under ctx path /solr)def searchIndex = catalinaBase + '/searchIndex' //create this directory// for running transmart as WAR, create this directory and then create an aliasdef jobsDirectory = "/var/tmp/jobs/"def oauthEnabled = truedef samlEnabled = falsedef gwavaEnabled = falsedef transmartURL = "http://10.232.0.114:${System.getProperty('server.port', '8080')}/transmart/"//Disabling/Enabling UI tabsui {tabs {//Search was not part of 1.2. It's not working properly. You need to set `show` to `true` to see it on UIsearch.show = falsebrowse.hide = false//Note: analyze tab is always shownsampleExplorer.hide = falsegeneSignature.hide = falsegwas.hide = falseuploadData.hide = false}}// I001 – Insertion point 'post-WAR-variables'//transmartURL = 'http://example.com/transmart/'//oauthEnabled = true//samlEnabled = false//gwavaEnabled = false/* Other things you may want to change:* – Log4j configuration* – 'Personalization & login' section* – Location of Solr instance in 'Faceted Search Configuration'* – For enabling SAML, editing the corresponding section is mandatory*//* If you want to be able to regenerate this file easily, instead of editing* the generated file directly, create a Config-extra.groovy file in the root of* the transmart-data checkout. That file will be appended to this one whenever* the Config.groovy target is run */environments { production {if (transmartURL.startsWith('http://localhost:')) {println "[WARN] transmartURL not overridden. Some settings (e.g. help page) may be wrong"}} }/* {{{ Log4J Configuration */log4j = {environments {development {root {info 'stdout'}// for a less verbose startup & shutdownwarn 'org.codehaus.groovy.grails.commons.spring'warn 'org.codehaus.groovy.grails.orm.hibernate.cfg'warn 'org.codehaus.groovy.grails.domain.GrailsDomainClassCleaner'debug 'org.transmartproject'debug 'com.recomdata'debug 'grails.app.services.com.recomdata'debug 'grails.app.services.org.transmartproject'debug 'grails.app.controllers.com.recomdata'debug 'grails.app.controllers.org.transmartproject'debug 'grails.app.domain.com.recomdata'debug 'grails.app.domain.org.transmartproject'// debug 'org.springframework.security'// (very verbose) debug 'org.grails.plugin.resource'}production {def logDirectory = "${catalinaBase}/logs".toString()appenders {rollingFile(name: 'transmart',file: "${logDirectory}/transmart.log",layout: pattern(conversionPattern: '%d{dd-MM-yyyy HH:mm:ss,SSS} %5p %c{1} - %m%n'),maxFileSize: '100MB')}root {warn 'transmart'}}}}/* }}} *//* {{{ Faceted Search Configuration */environments {development {com.rwg.solr.scheme = 'http'com.rwg.solr.host = '127.0.0.1:8983'com.rwg.solr.path = '/solr/rwg/select/'}production {com.rwg.solr.scheme = 'http'com.rwg.solr.host = '127.0.0.1:' + solrPortcom.rwg.solr.path = '/solr/rwg/select/'}}/* }}} *//* {{{ Personalization */// application logo to be used in the login pagecom.recomdata.largeLogo = "transmartlogo.jpg"// application logo to be used in the search pagecom.recomdata.smallLogo="transmartlogosmall.jpg"// contact email addresscom.recomdata.contactUs = "transmar...@googlegroups.com"// site administrator contact email addresscom.recomdata.adminEmail = "transmar...@googlegroups.com"// application titlecom.recomdata.appTitle = "tranSMART v" + org.transmart.originalConfigBinding.appVersion// Location of the help pages. Should be an absolute URL.// Currently, these are distribution with transmart,// so it can also point to that location copy.com.recomdata.adminHelpURL = "$transmartURL/help/adminHelp/default.htm"environments { development {com.recomdata.bugreportURL = 'https://jira.transmartfoundation.org'} }// Keys without defaults (see Config-extra.php.sample):// com.recomdata.projectName// com.recomdata.providerName// com.recomdata.providerURL/* }}} *//* {{{ Login */// Session timeout and heartbeat frequency (ping interval)com.recomdata.sessionTimeout = 300com.recomdata.heartbeatLaps = 30environments { development {com.recomdata.sessionTimeout = Integer.MAX_VALUE / 1000 as int /* ~24 days */com.recomdata.heartbeatLaps = 900} }// Not enabled by default (see Config-extra.php.sample)//com.recomdata.passwordstrength.pattern//com.recomdata.passwordstrength.description// Whether to enable guest auto login.// If it's enabled no login is required to access tranSMART.com.recomdata.guestAutoLogin = falseenvironments { development { com.recomdata.guestAutoLogin = true } }// Guest account user name - if guestAutoLogin is true, this is the username of// the account that tranSMART will automatically authenticate users as. This will// control the level of access anonymous users will have (the access will match// that of the account specified here).com.recomdata.guestUserName = 'guest'/* }}} *//* {{{ Search tool configuration */// Lucene index location for documentation searchcom.recomdata.searchengine.index = searchIndex/* }}} *//* {{{ Sample Explorer configuration */// This is an object to dictate the names and 'pretty names' of the SOLR fields.// Optionally you can set the width of each of the columns when rendered.sampleExplorer {fieldMapping = [columns:[[header:'Sample ID',dataIndex:'id', mainTerm: false, showInGrid: false],[header:'BioBank', dataIndex:'BioBank', mainTerm: true, showInGrid: true, width:10],[header:'Source Organism', dataIndex:'Source_Organism', mainTerm: true, showInGrid: true, width:10]// Continue as you have fields]]resultsGridHeight = 100resultsGridWidth = 100idfield = 'id'}edu.harvard.transmart.sampleBreakdownMap = ["id":"Aliquots in Cohort"]// Solr configuration for the Sample Explorercom { recomdata { solr {maxNewsStories = 10maxRows = 10000}}}/* }}} *//* {{{ Dataset Explorer configuration */com { recomdata { datasetExplorer {// set to 'true' (quotes included) to enable gene pattern integrationgenePatternEnabled = 'false'// The tomcat URL that gene pattern is deployed within -usually it's proxyed through apachegenePatternURL = 'http://23.23.185.167'// Gene Pattern real URL with port numbergenePatternRealURLBehindProxy = 'http://23.23.185.167:8080'// default Gene pattern user to start up - each tranSMART user will need a separate user account to be created in Gene PatterngenePatternUser = 'biomart'// Absolute path to PLINK executablesplinkExcutable = '/usr/local/bin/plink'} } }// Metadata viewcom.recomdata.view.studyview = 'studydetail'com.recomdata.plugins.resultSize = 5000/* }}} *//* {{{ RModules & Data Export Configuration */environments {// This is to target a remove Rserv. Bear in mind the need for shared network storageRModules.host = "127.0.0.1"RModules.port = 6311// This is not used in recent versions; the URL is always /analysisFiles/RModules.imageURL = "/tempImages/" //must end and start with /production {// The working directory for R scripts, where the jobs get created and// output files get generatedRModules.tempFolderDirectory = jobsDirectory}development {RModules.tempFolderDirectory = "/tmp"/* we don't need to specify temporaryImageDirectory, because we're not copying */}// Used to access R jobs parent directory outside RModules (e.g. data export)com.recomdata.plugins.tempFolderDirectory = RModules.tempFolderDirectory}/* }}} *//* {{{ GWAS Configuration */com.recomdata.dataUpload.appTitle="Upload data to tranSMART"com.recomdata.dataUpload.stageScript="run_analysis_stage"// Directory path of com.recomdata.dataUpload.stageScriptdef gwasEtlDirectory = new File(System.getenv('HOME'), '.grails/transmart-gwasetl')// Directory to hold GWAS file uploadsdef gwasUploadsDirectory = new File(System.getenv('HOME'), '.grails/transmart-datauploads')// Directory to preload with template files with names <type>-template.txtdef gwasTemplatesDirectory = new File(System.getenv('HOME'), '.grails/transmart-templates')com.recomdata.dataUpload.templates.dir = gwasTemplatesDirectory.absolutePathcom.recomdata.dataUpload.uploads.dir = gwasUploadsDirectory.absolutePathcom.recomdata.dataUpload.etl.dir = gwasEtlDirectory.absolutePath[gwasTemplatesDirectory, gwasUploadsDirectory, gwasEtlDirectory].each {if (!it.exists()) {it.mkdir()}}/* }}} *//* {{{ Misc Configuration */// This can be used to debug JavaScript callbacks in the dataset explorer in// Chrome. Unfortunately, it also sometimes causes chrome to segfaultcom.recomdata.debug.jsCallbacks = 'false'environments {production {com.recomdata.debug.jsCallbacks = 'false'}}grails.resources.adhoc.excludes = [ '/images' + RModules.imageURL + '**' ]// Adding properties to the Build information panelbuildInfo { properties {include = [ 'app.grails.version', 'build.groovy' ]exclude = [ 'env.proc.cores' ]} }/* }}} *//* {{{ Spring Security configuration */grails { plugin { springsecurity {// You probably won't want to change these// customized user GORM classuserLookup.userDomainClassName = 'org.transmart.searchapp.AuthUser'// customized password fielduserLookup.passwordPropertyName = 'passwd'// customized user /role join GORM classuserLookup.authorityJoinClassName = 'org.transmart.searchapp.AuthUser'// customized role GORM classauthority.className = 'org.transmart.searchapp.Role'// request map GORM class name - request map is stored in the dbrequestMap.className = 'org.transmart.searchapp.Requestmap'// requestmap in dbsecurityConfigType = grails.plugin.springsecurity.SecurityConfigType.Requestmap// url to redirect after login in// just_rest branch provides alternative default via org.transmart.defaultLoginRedirectsuccessHandler.defaultTargetUrl = org.transmart.defaultLoginRedirect ?: '/userLanding'// logout urllogout.afterLogoutUrl = '/login/forceAuth'// configurable requestmap functionality in transmart is deprecateddef useRequestMap = falseif (useRequestMap) {// requestmap in dbsecurityConfigType = 'Requestmap'// request map GORM class name - request map is stored in the dbrequestMap.className = 'org.transmart.searchapp.Requestmap'} else {securityConfigType = 'InterceptUrlMap'def oauthEndpoints = ['/oauth/authorize.dispatch': ["isFullyAuthenticated() and (request.getMethod().equals('GET') or request.getMethod().equals('POST'))"],'/oauth/token.dispatch': ["isFullyAuthenticated() and request.getMethod().equals('POST')"],]// This looks dangerous and it possibly is (would need to check), but// reflects the instructions I got from the developer.def gwavaMappings = ['/gwasWeb/**' : ['IS_AUTHENTICATED_ANONYMOUSLY'],]interceptUrlMap = ['/login/**' : ['IS_AUTHENTICATED_ANONYMOUSLY'],'/css/**' : ['IS_AUTHENTICATED_ANONYMOUSLY'],'/js/**' : ['IS_AUTHENTICATED_ANONYMOUSLY'],'/grails-errorhandler' : ['IS_AUTHENTICATED_ANONYMOUSLY'],'/images/analysisFiles/**' : ['IS_AUTHENTICATED_REMEMBERED'],'/images/**' : ['IS_AUTHENTICATED_ANONYMOUSLY'],'/static/**' : ['IS_AUTHENTICATED_ANONYMOUSLY'],'/search/loadAJAX**' : ['IS_AUTHENTICATED_ANONYMOUSLY'],'/analysis/getGenePatternFile': ['IS_AUTHENTICATED_ANONYMOUSLY'],'/analysis/getTestFile' : ['IS_AUTHENTICATED_ANONYMOUSLY'],'/requestmap/**' : ['ROLE_ADMIN'],'/role/**' : ['ROLE_ADMIN'],'/authUser/**' : ['ROLE_ADMIN'],'/secureObject/**' : ['ROLE_ADMIN'],'/accessLog/**' : ['ROLE_ADMIN'],'/authUserSecureAccess/**' : ['ROLE_ADMIN'],'/secureObjectPath/**' : ['ROLE_ADMIN'],'/userGroup/**' : ['ROLE_ADMIN'],'/secureObjectAccess/**' : ['ROLE_ADMIN'],* : (oauthEnabled ? oauthEndpoints : [:]),* : (gwavaEnabled ? gwavaMappings : [:]),'/**' : ['IS_AUTHENTICATED_REMEMBERED'], // must be last]rejectIfNoRule = true}// Hash algorithmpassword.algorithm = 'bcrypt'// Number of bcrypt roundspassword.bcrypt.logrounds = 14providerNames = ['daoAuthenticationProvider','anonymousAuthenticationProvider','rememberMeAuthenticationProvider',]if (oauthEnabled) {providerNames << 'clientCredentialsAuthenticationProvider'def securedResourcesFilters = ['JOINED_FILTERS','-securityContextPersistenceFilter','-logoutFilter','-rememberMeAuthenticationFilter','-basicAuthenticationFilter','-exceptionTranslationFilter',].join(',')filterChain.chainMap = ['/oauth/token': ['JOINED_FILTERS','-oauth2ProviderFilter','-securityContextPersistenceFilter','-logoutFilter','-rememberMeAuthenticationFilter','-exceptionTranslationFilter',].join(','),'/studies/**': securedResourcesFilters,'/observations/**': securedResourcesFilters,'/patient_sets/**': securedResourcesFilters,'/oauth/inspectToken': securedResourcesFilters,'/**': ['JOINED_FILTERS','-statelessSecurityContextPersistenceFilter','-oauth2ProviderFilter','-clientCredentialsTokenEndpointFilter','-basicAuthenticationFilter','-oauth2ExceptionTranslationFilter'].join(','),]grails.exceptionresolver.params.exclude = ['password', 'client_secret']def glowingBearRedirectUris = [transmartURL - ~/transmart\/$/ + '#/login',]if (transmartURL.startsWith('http://localhost:')) {// for dev, node reverse proxy runs on 8001glowingBearRedirectUris << 'http://localhost:8001/#/login'}oauthProvider {authorization.requireRegisteredRedirectUri = trueauthorization.requireScope = falseclients = [[clientId: 'api-client',clientSecret: 'api-client',authorities: ['ROLE_CLIENT'],scopes: ['read', 'write'],authorizedGrantTypes: ['authorization_code', 'refresh_token'],redirectUris: [transmartURL + 'oauth/verify']],
--Keith NangleEuropean Community FellowtranSMART FoundationCell: +49 151 1563 8609Skype US: +1 919.647.4741Skype: klnangle...................................................Confidentiality Note: This message is intended only for the use of the named recipient(s) and may contain confidential and/or privileged information. If you are not the intended recipient, please contact the sender and delete this message. Any unauthorized use of the information contained in this message is prohibited.
$ make -C samples/postgres load_
clinical_GSE8581make -C samples/postgres load_
clinical_GSE8581, I obtain the following:...
...
Regards,
Celia.