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

Mlflow cant login to postgres DB #16

Open
PhilippSKAI opened this issue Jan 13, 2023 · 0 comments
Open

Mlflow cant login to postgres DB #16

PhilippSKAI opened this issue Jan 13, 2023 · 0 comments

Comments

@PhilippSKAI
Copy link

PhilippSKAI commented Jan 13, 2023

When trying to set up a minikube cluster with mlflow, mlflow is not able to connect to its dedicated psql db.
I specified the username and password in the variables, however it seems to ignore them. I cant use any other user besides the default "postgres" otherwise it says the role doesnt exist.

Edit: Also the default password "postgres" sadly doesnt work

Here are the logs of the postgres pod:

postgresql 10:01:18.61 
postgresql 10:01:18.62 Welcome to the Bitnami postgresql container
postgresql 10:01:18.62 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-postgresql
postgresql 10:01:18.62 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-postgresql/issues
postgresql 10:01:18.63 
postgresql 10:01:18.83 INFO  ==> ** Starting PostgreSQL setup **
postgresql 10:01:18.85 INFO  ==> Validating settings in POSTGRESQL_* env vars..
postgresql 10:01:18.86 INFO  ==> Loading custom pre-init scripts...
postgresql 10:01:18.92 INFO  ==> Initializing PostgreSQL database...
postgresql 10:01:18.97 INFO  ==> pg_hba.conf file not detected. Generating it...
postgresql 10:01:18.97 INFO  ==> Generating local authentication configuration
postgresql 10:01:23.24 INFO  ==> Starting PostgreSQL in background...
postgresql 10:01:23.39 INFO  ==> Changing password of postgres
postgresql 10:01:23.56 INFO  ==> Configuring replication parameters
postgresql 10:01:23.67 INFO  ==> Configuring fsync
postgresql 10:01:23.85 INFO  ==> Loading custom scripts...
postgresql 10:01:23.87 INFO  ==> Enabling remote connections
postgresql 10:01:23.92 INFO  ==> Stopping PostgreSQL...
waiting for server to shut down.... done
server stopped
postgresql 10:01:24.16 INFO  ==> ** PostgreSQL setup finished! **

postgresql 10:01:24.18 INFO  ==> ** Starting PostgreSQL **
2023-01-13 10:01:24.236 GMT [1] LOG:  pgaudit extension initialized
2023-01-13 10:01:24.237 GMT [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2023-01-13 10:01:24.237 GMT [1] LOG:  listening on IPv6 address "::", port 5432
2023-01-13 10:01:24.258 GMT [1] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2023-01-13 10:01:24.337 GMT [130] LOG:  database system was shut down at 2023-01-13 10:01:24 GMT
2023-01-13 10:01:24.344 GMT [1] LOG:  database system is ready to accept connections
2023-01-13 10:01:53.073 GMT [159] FATAL:  password authentication failed for user "postgres"
2023-01-13 10:01:53.073 GMT [159] DETAIL:  Password does not match for user "postgres".
	Connection matched pg_hba.conf line 1: "host     all             all             0.0.0.0/0               md5"
2023-01-13 10:01:53.254 GMT [160] FATAL:  password authentication failed for user "postgres"
2023-01-13 10:01:53.254 GMT [160] DETAIL:  Password does not match for user "postgres".
	Connection matched pg_hba.conf line 1: "host     all             all             0.0.0.0/0               md5"
2023-01-13 10:01:53.574 GMT [161] FATAL:  password authentication failed for user "postgres"
2023-01-13 10:01:53.574 GMT [161] DETAIL:  Password does not match for user "postgres".
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

1 participant