I am using Zato 3 stable version. I am facing issues with configuring an outgoing SQL(Postgres) connection.
SQL connection is not being established even if I give the correct username and password. When I verified the PostgreSQL logs it is showing as authentication failed.
Upon further analysing this issue I see that the password is being encrypted and getting stored in the database. I suspect that the password is not being decrypted while establishing the SQL connection. This is because if I manually update the database entry to the plain text format then I was able to establish the SQL connection successfully.