Details
-
Documentation
-
Status: Closed
-
Major
-
Resolution: Completed
-
1.7.00-RC1
-
None
-
VMware image of Centos 6.4
-
Rank:0|i000qf:
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
- 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