Using the vault with redgate Flyway tool -- path to secret error

Hi, i just started using the vault and testing it to use in redgate Flyway tool to get the database authentication. I am using DEV server for this locally. I can access the vault in browser using the local address and can see the secrets that i created. When i try to access the secrets from Flyway, i am getting below error. I think i am giving wrong path. How to know the actual path to the secret?

ERROR: Unable to read configuration from Vault: Vault secret location ‘http://localhost:8200/Flyway_KV/data/pgpwd’ could not be found. Ensure the path to your secret is correct.

Thank You for the help.
Kiran

How did you enable the secret engine? Can you provide some more former steps?

Hi, Please ignore the above URL. As my machine was restarted, i had to repeat the process. Below are the steps i followed to create the secret.

Started DEV server – vault server -dev

– In new command window, det environment Variables – VAULT_ADDR & VAULT_TOKEN

vault status

Key Value


Seal Type shamir
Initialized true
Sealed false
Total Shares 1
Threshold 1
Version 1.6.3
Storage Type inmem
Cluster Name vault-cluster-02c565df
Cluster ID c4d1f8df-16e3-6f7b-c806-124929a09932
HA Enabled false

vault kv put secret/pgpwd flyway.password=secret1234

Key Value


created_time 2021-03-08T15:06:03.8433211Z
deletion_time n/a
destroyed false
version 1

vault kv get secret/pgpwd

====== Metadata ======
Key Value


created_time 2021-03-08T15:06:03.8433211Z
deletion_time n/a
destroyed false
version 1

========= Data =========
Key Value


flyway.password secret1234

– Flyway config file settings for vault

flyway.vault.url=http://127.0.0.1:8200/
flyway.vault.token=************
flyway.vault.secrets=secret/pgpwd

flyway -teams -configFiles=C:\Redgate\flyway-7.5.4\conf\DBADEV.conf info

ERROR: Unable to read configuration from Vault: Vault secret location ‘http://127.0.0.1:8200/v2/secret’ could not be found. Ensure the path to your secret is correct.

Thanks for the help.

I created a new v1 secret engine and tried it with as well as flyway docs are saying that it supports v1. Config file updated with below values.

flyway.vault.url=http://127.0.0.1:8200/v1/
flyway.vault.token=***************
flyway.vault.secrets=flyway/pgpwd1

flyway -teams -configFiles=C:\Redgate\flyway-7.5.4\conf\DBADEV.conf info
ERROR: Unable to read configuration from Vault: Vault secret location ‘http://127.0.0.1:8200/v1/flyway’ could not be found. Ensure the path to your secret is correct.

Not sure if the path is wrong or authentication is failing. I can see those secrets in browser.
image
image
image