visulate/visulate-ora2pg

Postgres password validation fails

Closed this issue · 0 comments

UI Auth dialog fails connection to database. Password authentication is failing when valid credentials are passed with a message

FATAL: password authentication failed for user "postgres" FATAL: password authentication failed for user "postgres"

Issue appears to be in the validation module called by the UI, was able to work around the issue by turning off password validation for the IP address where ora2pg is running on server and then restarting postgres

vi /etc/postgresql/13/main/pg_hba.conf
host all all 192.168.1.27/32 trust

With password validation turned off I was able to save credentials to session storage. Once the credentials were saved I returned to the server and turned password validation back on and was able to run in COPY mode