Ecrypted paswords

Liquibase Development
1

Hello

Can we pass encrypted cipher sql server passwords to liquibase?

2

OR

can we just run updateSQL goal without giving it datbase properties? i just want to generate SQL files from changeset for PROD, of which i dont have access to connect to actually.

3

@aditi @MikeOlivas
can you pleas elook at this query asap

4

Hi @Pooja , you can run updateSQL to generate the SQL that Liquibase would run on a database.
To answer your earlier question, as long as it is on the jdbc url, you should for all intents and purposes be able to use encrypted passwords.

5

thanks a lot for fast reply, we have a prod build goign out with liquibase for first tiem today.
and i am not able to generate output SQL with update SQL for prod context.
can you help me with required properties?

url=jdbc:sqlserver://XXXXXXXXProd240:14330;databaseName=@@@@
above is my url.
what should i pass in username password?
@MikeOlivas

6

In your liquibase.properties file you can pass in the encrypted password using password=yourencryptedpw
Or you can pass on the command line via --password=yourencryptedpw

7

@MikeOlivas
i tried that in maven command:
mvn clean install -Psql240 -Denv=prod -Dgoal=updateSQL -Dusername=svcWeb -Dpassword=1b2bd7483b2dc308e31178be2e3c710c41b72fde99b7333fe9c493a15c794532329776ac2f67c88b528b7317f174##b9cf

but it says:
Error setting up or running Liquibase: liquibase.exception.DatabaseException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ‘svcWeb’.

what kind of encryption is it looking for? any specific key?

8

Hi @Pooja Now that we know this is from maven, you might try information in this tutorial.

If that does not help, then I would suggest signing up for a paid subscription to get support for your specific environment.

1 Like