Sequelize CLI Fails to Authenticate with Postgres DB Containing a ':' in Password

[hrabizadeh-sa]

When attempting to use Sequelize CLI to connect to a PostgreSQL database, an issue arises if the database password contains a colon (':') symbol. The CLI does not handle this special character correctly, causing authentication failures.

I'm using the Sequelize db:migration with and without --url and in both scenarios, Sequelize could authenticate to the database with the same password but sequelize-cli can not connect to run migrations and seeds.

In the file config-helper.js at line 174, we've identified that the
const urlParts = url.parse(urlString);
statement is responsible for decoding encoded URL symbols, including the colon (':').
Due to the following code at line 186, which is
password: urlParts.auth.split(':')[1],
characters in the password field after the colon (':') will be ignored.

[WikiRik]

This was fixed before (see #334) but for some reason reverted. I copied the code from the core repo, can you check if that works? We have minimal test coverage and with the upcoming rewrite I'm not sure if I want to invest the time into it now. Only main thing we changed is that I'm not using _.assign anymore

[hrabizadeh-sa]

Hi,
I've just reviewed the code and even tested it on the Node console and it seems it is working properly.

Thanks,

[github-actions]

🎉 This issue has been resolved in version 6.6.2 🎉

The release is available on:

• npm package (@latest dist-tag)
• GitHub release

Your semantic-release bot 📦🚀

[tejasautkar]

I am still facing the same issue. my password has |{:]r*+) these special characters.