[CORE-77] I2B2 installation Guide fixes Created: 26/Sep/13  Updated: 09/Jun/14  Resolved: 09/Jun/14

Status: Closed
Project: i2b2 Core Software
Component/s: Documentation, Install
Affects Version/s: 1.7.00-RC1
Fix Version/s: 1.7.01

Type: Documentation Priority: Major
Reporter: George Kowalski Assignee: Janice Donahoe
Resolution: Completed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment: VMware image of Centos 6.4

Participant/s:

 Description   
I noted the following issues while using the i2b2 Installation Guide version 1.7.0 with a Postgres database on Linux

- Ant is used as a dependency during the installation , but not listed as Prerequisite Software to obtain in section 1.1
- No instructions on how to run the pgsql command in section 2.4.1 , found that to run it "sudo -u postgres psql"
- In 2.5 and subsequent sections I needed to run the following commands BEFORE creating the tables and loading data otherwise the tables were created in teh public scheama :

 grant all on schema i2b2metadata to i2b2metadata;
 grant all on schema i2b2demodata to i2b2demodata;
etc ...

In section 2.5.2 I could not use the db.url that contained localhost but rather needed to specify the ip address on the machine I was loading on

db.url=jdbc:postgresql://###.###.###.###:5432/postgres?searchpath=i2b2pm

Also no instructions to set up Postgres for network access via the port ( which is disabled by default ) . I used http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html

In step 2.10 the instructions go on about setting up a schema with i2b2im and the same userid . The instructions omitted this schema and user id in step 2.2.2 and 2.2.3



 Comments   
Comment by George Kowalski [ 26/Sep/13 ]
Also in addition to editing the following files as root :

/var/lib/pgsql/9.1/data/postgresql.conf and pg_hba.conf

to enable port 5432 support

I needed to turn off the CentOS Firewall
Comment by George Kowalski [ 06/Jan/14 ]
Didn't make it into the final 1.7.0 documentation. The i2b2im userid is still not referenced before section 2.10 in the Data Installation Guide.
Comment by Janice Donahoe [ 09/Jun/14 ]
A new installation guide was written and made available to users on the community i2b2 wiki page (https://community.i2b2.org/wiki/display/getstarted/i2b2+Installation+Guide). The concerns addressed in this issue are addressed in the new guide.
Generated at Mon Apr 14 11:26:12 UTC 2025 using Jira 8.20.11#820011-sha1:0629dd8d260e3954ece49053e565d01dabe11609.