datarevenue-berlin / OpenMLOps

MIT License
703 stars 101 forks source link

Mlflow cant login to postgres DB #119

Open PhilippSKAI opened 1 year ago

PhilippSKAI commented 1 year ago

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".