The AGG_SERVICE_ACCOUNT user defaults to a well known password and can be used to login to the webclient. After changing the password in the admin client, queries will throw errors with the following:
10:16:37,317 ERROR [edu.harvard.i2b2.pm.delegate.ServicesHandler] (Thread-114) Username or password does not exist
10:16:37,318 ERROR [stderr] (Thread-114) java.lang.Exception: Username or password does not exist
10:16:37,319 ERROR [stderr] (Thread-114) at edu.harvard.i2b2.pm.delegate.ServicesHandler.execute(Unknown Source)
10:16:37,319 ERROR [stderr] (Thread-114) at edu.harvard.i2b2.pm.ws.ExecutorRunnable.run(Unknown Source)
10:16:37,319 ERROR [stderr] (Thread-114) at java.lang.Thread.run(Thread.java:744)
10:16:37,321 ERROR [edu.harvard.i2b2.pm.ws.PMResponseMessage] (http--0.0.0.0-9090-4) Error reported by Ont web Service Username or password does not exist
Queries no longer function as well. How do we change the password to be more secure?
As a note and may address this issue, if you change the AGG_SERVICE_ACCOUNT password via the admin interface, you must also update the password that is hard-coded into the config files and redeploy Jboss:
Robert Bradford
added a comment - As a note and may address this issue, if you change the AGG_SERVICE_ACCOUNT password via the admin interface, you must also update the password that is hard-coded into the config files and redeploy Jboss:
edu.harvard.i2b2.ontology\etc\spring\ontology.properties
edu.harvard.i2b2.crc\etc\spring\crc.properties
Updated issue type to documentation. The install documentation will be updated on the process of changing the AGG_SERVICE_ACCOUNT password.
Janice Donahoe
added a comment - Updated issue type to documentation. The install documentation will be updated on the process of changing the AGG_SERVICE_ACCOUNT password.
People
Janice Donahoe
Johann Hoehn
Votes:
0Vote for this issue
Watchers:
2Start watching this issue
Dates
Created:
Updated:
{"report":{"fcp":1092.7000000476837,"ttfb":421.7999999523163,"pageVisibility":"visible","entityId":10467,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"3e59aeb3-6a72-40ff-a41b-1a80fa89d07d","navigationType":0,"readyForUser":1127.9000000953674,"redirectCount":0,"resourceLoadedEnd":893.4000000953674,"resourceLoadedStart":426.60000014305115,"resourceTiming":[{"duration":8.599999904632568,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":426.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":426.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":435.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":9.200000047683716,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/898b8076c5e82f53cd816ca393e45a56-CDN/4x9nqn/820011/16zrvj4/41b71ca9fb0eed92dc73e9510f2744ee/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?jira.create.linked.issue=true&richediton=true&whisper-enabled=true","startTime":426.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":426.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":436.10000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":391.59999990463257,"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":427.10000014305115,"connectEnd":734.9000000953674,"connectStart":709,"domainLookupEnd":709,"domainLookupStart":709,"fetchStart":427.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":735,"responseEnd":818.7000000476837,"responseStart":753.5,"secureConnectionStart":721.7999999523163},{"duration":425.10000014305115,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/694e598c1ae48b0f96655173631cd247-CDN/4x9nqn/820011/16zrvj4/41b71ca9fb0eed92dc73e9510f2744ee/_/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&whisper-enabled=true","startTime":427.2999999523163,"connectEnd":752.6000001430511,"connectStart":726.7000000476837,"domainLookupEnd":726.7000000476837,"domainLookupStart":726.7000000476837,"fetchStart":427.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":752.7000000476837,"responseEnd":852.4000000953674,"responseStart":773.6000001430511,"secureConnectionStart":739.5},{"duration":342.2000000476837,"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":427.5,"connectEnd":755.9000000953674,"connectStart":732.5,"domainLookupEnd":732.5,"domainLookupStart":732.4000000953674,"fetchStart":427.5,"redirectEnd":0,"redirectStart":0,"requestStart":756,"responseEnd":769.7000000476837,"responseStart":768.9000000953674,"secureConnectionStart":744.2000000476837},{"duration":344.59999990463257,"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":427.7000000476837,"connectEnd":757.2999999523163,"connectStart":731.6000001430511,"domainLookupEnd":731.6000001430511,"domainLookupStart":731.6000001430511,"fetchStart":427.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":757.2999999523163,"responseEnd":772.2999999523163,"responseStart":771.5,"secureConnectionStart":744.5},{"duration":354.2000000476837,"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":427.90000009536743,"connectEnd":768.4000000953674,"connectStart":745.4000000953674,"domainLookupEnd":745.4000000953674,"domainLookupStart":745.4000000953674,"fetchStart":427.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":768.5,"responseEnd":782.1000001430511,"responseStart":781.4000000953674,"secureConnectionStart":756.7999999523163},{"duration":12.799999952316284,"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":428.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":428.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":440.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":356.2000000476837,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":428.2999999523163,"connectEnd":768.7000000476837,"connectStart":742.2999999523163,"domainLookupEnd":742.2999999523163,"domainLookupStart":742.2999999523163,"fetchStart":428.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":768.7000000476837,"responseEnd":784.5,"responseStart":782.9000000953674,"secureConnectionStart":754.7000000476837},{"duration":2.9000000953674316,"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":492.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":492.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":495.10000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":319.2000000476837,"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":492.2999999523163,"connectEnd":795.7999999523163,"connectStart":772.2000000476837,"domainLookupEnd":772.2000000476837,"domainLookupStart":772.2000000476837,"fetchStart":492.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":796,"responseEnd":811.5,"responseStart":809.7999999523163,"secureConnectionStart":784},{"duration":389.60000014305115,"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":503.7999999523163,"connectEnd":878.1000001430511,"connectStart":852.2999999523163,"domainLookupEnd":852.2999999523163,"domainLookupStart":852.2999999523163,"fetchStart":503.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":878.2999999523163,"responseEnd":893.4000000953674,"responseStart":892.6000001430511,"secureConnectionStart":864.9000000953674},{"duration":378.39999985694885,"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":513.9000000953674,"connectEnd":878.7000000476837,"connectStart":855.2999999523163,"domainLookupEnd":855.2999999523163,"domainLookupStart":855.2999999523163,"fetchStart":513.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":878.7000000476837,"responseEnd":892.2999999523163,"responseStart":891.2000000476837,"secureConnectionStart":866.7999999523163},{"duration":170.79999995231628,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":999.5,"connectEnd":1151.7000000476837,"connectStart":1128.2999999523163,"domainLookupEnd":1128.2999999523163,"domainLookupStart":1128.2999999523163,"fetchStart":999.5,"redirectEnd":0,"redirectStart":0,"requestStart":1151.7999999523163,"responseEnd":1170.2999999523163,"responseStart":1169.6000001430511,"secureConnectionStart":1139.4000000953674}],"fetchStart":131,"domainLookupStart":133,"domainLookupEnd":181,"connectStart":182,"connectEnd":220,"secureConnectionStart":193,"requestStart":220,"responseStart":422,"responseEnd":514,"domLoading":426,"domInteractive":1179,"domContentLoadedEventStart":1179,"domContentLoadedEventEnd":1215,"domComplete":1361,"loadEventStart":1361,"loadEventEnd":1362,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1156.4000000953674},{"name":"bigPipe.sidebar-id.end","time":1157.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1157.6000001430511},{"name":"bigPipe.activity-panel-pipe-id.end","time":1158.6000001430511},{"name":"activityTabFullyLoaded","time":1244.7999999523163}],"measures":[],"correlationId":"366d33e382e514","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":280,"dbReadsTimeInMs":43,"dbConnsTimeInMs":57,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Task
Minor
edu.harvard.i2b2.ontology\etc\spring\ontology.properties
edu.harvard.i2b2.crc\etc\spring\crc.properties