Title: Cannot install tests when using default user names as provided in template.env.sh · Issue #1200 · utPLSQL/utPLSQL · GitHub
Open Graph Title: Cannot install tests when using default user names as provided in template.env.sh · Issue #1200 · utPLSQL/utPLSQL
X Title: Cannot install tests when using default user names as provided in template.env.sh · Issue #1200 · utPLSQL/utPLSQL
Description: Describe the bug In template.env.sh the user name UT3$USER# is configured for ${UT3_USER}. In install_ut3_tester_helper.sql the user is hard coded. ut3_user is used. When I use an env.sh based on template.env.sh and do not change the def...
Open Graph Description: Describe the bug In template.env.sh the user name UT3$USER# is configured for ${UT3_USER}. In install_ut3_tester_helper.sql the user is hard coded. ut3_user is used. When I use an env.sh based on t...
X Description: Describe the bug In template.env.sh the user name UT3$USER# is configured for ${UT3_USER}. In install_ut3_tester_helper.sql the user is hard coded. ut3_user is used. When I use an env.sh based on t...
Opengraph URL: https://github.com/utPLSQL/utPLSQL/issues/1200
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Cannot install tests when using default user names as provided in template.env.sh","articleBody":"## Describe the bug\r\n\r\nIn [template.env.sh](https://github.com/utPLSQL/utPLSQL/blob/85fd36d222680ebe1420d0fe40ed34520595a0b2/development/template.env.sh#L20) the user name `UT3$USER#` is configured for `${UT3_USER}`. In [install_ut3_tester_helper.sql](https://github.com/utPLSQL/utPLSQL/blob/85fd36d222680ebe1420d0fe40ed34520595a0b2/test/install_ut3_tester_helper.sql#L38) the user is hard coded. `ut3_user` is used.\r\n\r\nWhen I use an `env.sh` based on `template.env.sh` and do not change the default users then running `test/install_and_run_tests.sh` produces an error while running this statement `create or replace synonym ut3_user.coverage_helper for ut3_tester_helper.coverage_helper;` because the user `ut3_user` does not exist.\r\n\r\n## Expected behavior\r\n\r\nInstallation of tests work when using the default usernames in `template.env.sh`. \r\n\r\n## Workaround\r\n\r\nConfigure `export UT3_USER=UT3_USER` in `env.sh`.\r\n\r\n## Off topic remark\r\n\r\nI do not see a value in making the test users configurable. Quite the contrary. It makes the the test setup more complicated and also more fragile. Making the utPLSQL schema owner for production use configurable makes sense. But the testing users? - I don't think so.","author":{"url":"https://github.com/PhilippSalvisberg","@type":"Person","name":"PhilippSalvisberg"},"datePublished":"2022-03-13T15:21:03.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/1200/utPLSQL/issues/1200"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:c75acd2f-5f5d-f17d-2f94-7d5a70c424c9 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | DD2A:3A1274:D91CC:124E30:6A63C586 |
| html-safe-nonce | 460c631c461a2bf8a0bb869498fce6c3625d0d86cf00448144b7ebb7da568453 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJERDJBOjNBMTI3NDpEOTFDQzoxMjRFMzA6NkE2M0M1ODYiLCJ2aXNpdG9yX2lkIjoiMTgxNTcyNTk0OTA0NjczNjI2MiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 0d72e26155025007d9ed4b2d5d99fd5af19710c84f51ec9cb4f309ae0e099b8f |
| hovercard-subject-tag | issue:1167610482 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/utPLSQL/utPLSQL/1200/issue_layout |
| twitter:image | https://opengraph.githubassets.com/236e78c060beab9721eb6f0189b2e1406923b2d65227247ffa1ac38d8893309f/utPLSQL/utPLSQL/issues/1200 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/236e78c060beab9721eb6f0189b2e1406923b2d65227247ffa1ac38d8893309f/utPLSQL/utPLSQL/issues/1200 |
| og:image:alt | Describe the bug In template.env.sh the user name UT3$USER# is configured for ${UT3_USER}. In install_ut3_tester_helper.sql the user is hard coded. ut3_user is used. When I use an env.sh based on t... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | PhilippSalvisberg |
| hostname | github.com |
| expected-hostname | github.com |
| None | 4c1c4f1792dfc705b5a5073fed6c61988f59766cec1277f24f55d4b876f9881c |
| turbo-cache-control | no-preview |
| go-import | github.com/utPLSQL/utPLSQL git https://github.com/utPLSQL/utPLSQL.git |
| octolytics-dimension-user_id | 15661281 |
| octolytics-dimension-user_login | utPLSQL |
| octolytics-dimension-repository_id | 50728220 |
| octolytics-dimension-repository_nwo | utPLSQL/utPLSQL |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 50728220 |
| octolytics-dimension-repository_network_root_nwo | utPLSQL/utPLSQL |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | fefaad6f0be5c33f57f42bb65ed668f74c872364 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width