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
{"report":{"fcp":436.60000002384186,"ttfb":49.10000002384186,"pageVisibility":"visible","entityId":10215,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":1,"journeyId":"19bbf5c4-796a-440f-8478-43199287c677","navigationType":0,"readyForUser":488.10000002384186,"redirectCount":0,"resourceLoadedEnd":488.7000000178814,"resourceLoadedStart":54.10000002384186,"resourceTiming":[{"duration":6.199999988079071,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":54.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":54.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":60.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":6.300000011920929,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/898b8076c5e82f53cd816ca393e45a56-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?jira.create.linked.issue=true&richediton=true","startTime":54.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":54.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":60.60000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":136.30000001192093,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/694e598c1ae48b0f96655173631cd247-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":54.5,"connectEnd":86.90000000596046,"connectStart":63.20000001788139,"domainLookupEnd":54.5,"domainLookupStart":54.5,"fetchStart":54.5,"redirectEnd":0,"redirectStart":0,"requestStart":87,"responseEnd":190.80000001192093,"responseStart":114.2000000178814,"secureConnectionStart":75},{"duration":137.40000000596046,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/4c9c503fe98f210445831b0d7b0cdc33-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":54.5,"connectEnd":86.30000001192093,"connectStart":62.20000001788139,"domainLookupEnd":54.5,"domainLookupStart":54.5,"fetchStart":54.5,"redirectEnd":0,"redirectStart":0,"requestStart":86.40000000596046,"responseEnd":191.90000000596046,"responseStart":116.10000002384186,"secureConnectionStart":74.2000000178814},{"duration":53,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/53f54e0ac3f00bb56b136b4d2fff2853-CDN/4x9nqn/820011/16zrvj4/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":54.70000001788139,"connectEnd":89,"connectStart":64.40000000596046,"domainLookupEnd":54.70000001788139,"domainLookupStart":54.70000001788139,"fetchStart":54.70000001788139,"redirectEnd":0,"redirectStart":0,"requestStart":89.10000002384186,"responseEnd":107.7000000178814,"responseStart":107,"secureConnectionStart":77.10000002384186},{"duration":93.30000001192093,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":54.80000001192093,"connectEnd":132.7000000178814,"connectStart":107.60000002384186,"domainLookupEnd":54.80000001192093,"domainLookupStart":54.80000001192093,"fetchStart":54.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":133.10000002384186,"responseEnd":148.10000002384186,"responseStart":147.40000000596046,"secureConnectionStart":119.7000000178814},{"duration":117.7000000178814,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":54.900000005960464,"connectEnd":157.5,"connectStart":133.30000001192093,"domainLookupEnd":54.900000005960464,"domainLookupStart":54.900000005960464,"fetchStart":54.900000005960464,"redirectEnd":0,"redirectStart":0,"requestStart":157.60000002384186,"responseEnd":172.60000002384186,"responseStart":171.30000001192093,"secureConnectionStart":145.40000000596046},{"duration":10.200000017881393,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/30748292e4ca68be6947d7969829384b-CDN/4x9nqn/820011/16zrvj4/4f66da484ef7d95a2a604d3ab014374c/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":55,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":55,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":65.2000000178814,"responseStart":0,"secureConnectionStart":0},{"duration":128.89999997615814,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/5c69e534a30b62def7b98bda0f001346/shortcuts.js?context=issuenavigation&context=issueaction","startTime":55.10000002384186,"connectEnd":169.80000001192093,"connectStart":146,"domainLookupEnd":55.10000002384186,"domainLookupStart":55.10000002384186,"fetchStart":55.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":169.90000000596046,"responseEnd":184,"responseStart":183.2000000178814,"secureConnectionStart":157.90000000596046},{"duration":73,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":83.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":83.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":156.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":114.2000000178814,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/8087506fefd02b4096991c90836b49f6-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":83.5,"connectEnd":181.2000000178814,"connectStart":156.60000002384186,"domainLookupEnd":83.5,"domainLookupStart":83.5,"fetchStart":83.5,"redirectEnd":0,"redirectStart":0,"requestStart":181.2000000178814,"responseEnd":197.7000000178814,"responseStart":196.90000000596046,"secureConnectionStart":169.10000002384186},{"duration":296.39999997615814,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":91.60000002384186,"connectEnd":373.40000000596046,"connectStart":348.7000000178814,"domainLookupEnd":91.60000002384186,"domainLookupStart":91.60000002384186,"fetchStart":91.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":373.60000002384186,"responseEnd":388,"responseStart":386.90000000596046,"secureConnectionStart":361.2000000178814},{"duration":333.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":155.2000000178814,"connectEnd":474.5,"connectStart":450.5,"domainLookupEnd":155.2000000178814,"domainLookupStart":155.2000000178814,"fetchStart":155.2000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":474.60000002384186,"responseEnd":488.7000000178814,"responseStart":487.90000000596046,"secureConnectionStart":462.5},{"duration":113,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":361.10000002384186,"connectEnd":457.10000002384186,"connectStart":432.60000002384186,"domainLookupEnd":361.10000002384186,"domainLookupStart":361.10000002384186,"fetchStart":361.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":457.2000000178814,"responseEnd":474.10000002384186,"responseStart":473.60000002384186,"secureConnectionStart":445.10000002384186}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":23,"responseStart":49,"responseEnd":155,"domLoading":53,"domInteractive":568,"domContentLoadedEventStart":568,"domContentLoadedEventEnd":609,"domComplete":1003,"loadEventStart":1003,"loadEventEnd":1004,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":545.8000000119209},{"name":"bigPipe.sidebar-id.end","time":546.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":548.3000000119209},{"name":"bigPipe.activity-panel-pipe-id.end","time":551},{"name":"activityTabFullyLoaded","time":620.9000000059605}],"measures":[],"correlationId":"c08672845d8cc3","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":120,"dbReadsTimeInMs":7,"dbConnsTimeInMs":11,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}