PLEASE NOTE: these instructions are for the install of tranSMART beta release 19.0. They may not fully apply to earlier versions.

Overview

These notes describe the command line tools and features that are required for tranSMART version 19.0. The suggestions given are based on Ubuntu 18.04 but in most cases for other systems simple analogs are available. There is a set of scripts, on GitHub

, written for bash on Ubuntu 18.04, that verify these requirements; in particular, see the README.md and CheckAll.sh.

Background needs

Are the these available: the Prerequisites, Rserve, SOLR, and the configuration files?

Once you have have installed the Prerequisites and set up Rserve, SOLR, and configuration files then the following instructions produce an output indicating the existence of the base required applications; unless otherwise noted, the specific version is not important, just the fact that the command is there and responds to the 'version' option:

git --version
make --version
java -version (version JDK 8)
ant -version
mvn --version
tar --version
rsync --version
php --version (7.2 or higher)
g++ --version
gfortran --version
R --version (3.6.1)
psql --version (9.6 or higher)
groovy --version (2.4.16 or higher)

The following files, directories, links should be present:

~/transmart/transmart-data/vars
~/transmart/transmart-data/env/data-integration
~/transmart/transmart-data/env/transmart-etl or ~/transmart/transmart-etl
~/transmart/transmart-data/R/root/bin

Furthermore, Rserve should be evident in the following commands (the second and third issued after R starts, indicated by that change in prompt character from $ to >)

R CMD Rserve --version

And SOLR should be evident. Start it with:
sudo systemctl start solr

Then browse to the web location:
http://localhost:8983/solr/#/

You should see a clearly labeled SOLR web site; the "Core Selector" pull-down should contain: "browse", "rwg" and "sample".

Finally, the configuration files should show up as:

/var/lib/tomcat8/.grails/transmartConfig/
Config.groovy
DataSource.groovy

PostgreSQL

Can the database be accessed by the "default" tranSMART account? Is the login data present?

You should be able to start the postgres database using the postgres account and login by the following

cd ~/transmart/transmart-data
. ./vars
$PGSQL_BIN/psql postgres
(use \q to quit)

Also you should be able to verify that the transmart web application can access the data base by checking the following SQL commands (alternate prompts indicate commands in PostgreSQL). The select of username should return one row without error. If searchapp is not found then you have not loaded the database correctly. It the command to run psql (e.g. $PGSQL_BIN/psql ) fails with ".../psql command not found" or "database 'transmart' does not exist' then, see further checks below.

cd ~/transmart/transmart-data
. ./vars
$PGSQL_BIN/psql transmart
>select username from searchapp.search_auth_user where username='guest';
(use \q to quit)

If there was some problem with the psql command or the select, check the following

cd ~/transmart/transmart-data
. ./vars
echo $PGSQL_BIN

Should return /usr/bin .

which psql

Should return /usr/bin/psql

cd ~/transmart/transmart-data
. ./vars
$PGSQL_BIN/psql postgres
>\l transmart
(use \q to quit)

The \l command should return an entry for the transmart database (owned by postgres).  

Tomcat

Tomcat will need to be running (tomcat8 is used here). The default installation on Ubuntu 18.04 will present a service that supports the following commands:

  • sudo systemctl status tomcat8
  • sudo systemctl start tomcat8
  • sudo systemctl stop tomcat8
  • sudo systemctl restart tomcat8

The status command returns text (to standard out) indicating if tomcat is running not. The start, stop, and restart commands do as they say. The restart command will stop and start tomcat; it can be used if tomcat is already stopped, in which case it will not attempt to stop tomcat but will simply restart it.

War Files

Have transmart.war and gwava.war been install? Did they expand correctly? Was transmart.log generated? And does catalina.out show that transmart was started. 

The following files, and dirs should exist:

cd /var/lib/tomcat8/webapps/
ls transmart.war transmart gwava.war gwava
cd /var/lib/tomcat8/logs
ls -al catalina.out transmart.log

Grep transmart.log for the phrase 'initialization coompleted' and check the date/time match the latest system or server (re)start.

Web Site

Is the tranSMART web application running? Can you log in? Is the example data available?

Use a browser to check that the following URLs return a page. For the transmart login pages the initial administrative login is, username=admin, password=admin.

http://localhost:8080/

 http://localhost:8080/transmart/login/forceAuth

(after log in is successful)

http://localhost:8080/transmart/datasetExplorer/index

On the datasetExplorer page you should see a "tree" display on the left with a top level entry "Public Studies". Expanding this entry (click on the '+') should reveal a study 'GSE8581' .


  • No labels

1 Comment

  1. Please expand manual on how to get following folders:

    ~/transmart/transmart-data/env/data-integration
    ~/transmart/transmart-data/env/tranSMART-ETL

    To get above prerequisites transmart-data could be used:

    make -C env/ update_etl 
    make -C env/ data-integration