Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

2.0.1 database username is hardcoded #78

Open
matthewsaum opened this issue May 21, 2024 · 2 comments
Open

2.0.1 database username is hardcoded #78

matthewsaum opened this issue May 21, 2024 · 2 comments

Comments

@matthewsaum
Copy link

matthewsaum commented May 21, 2024

Completely rewriting this with better formatting and info. It wasn't the database name, it was the user. FlyWay errors out when I try to use a user which isn't postgres to access things.

* What went wrong:
Execution failed for task ':api-svc:db:flywayMigrate'.
> Error occurred while executing flywayMigrate
  Migration B25__baseline.sql failed
  ----------------------------------
  SQL State  : 42501
  Error Code : 0
  Message    : ERROR: must be member of role "postgres"
  Location   : db/migration/B25__baseline.sql (/opt/raid/api-svc/db/build/resources/main/db/migration/B25__baseline.sql)
  Line       : 19
  Statement  : ALTER SCHEMA api_svc OWNER TO postgres
  
  Migration B25__baseline.sql failed
  ----------------------------------
  SQL State  : 42501
  Error Code : 0
  Message    : ERROR: must be member of role "postgres"
  Location   : db/migration/B25__baseline.sql (/opt/raid/api-svc/db/build/resources/main/db/migration/B25__baseline.sql)
  Line       : 19
  Statement  : ALTER SCHEMA api_svc OWNER TO postgres
  
  ERROR: must be member of role "postgres"
@robleney-ardc
Copy link
Contributor

Hey @matthewsaum can you provide some links to where you found the hardcoded database name please?

@matthewsaum matthewsaum changed the title 2.0.1 database name is hardcoded 2.0.1 database username is hardcoded Nov 14, 2024
@matthewsaum
Copy link
Author

I apologize on letting this fall to the wayside so long, I provided much better source info in the top ticket entry.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants