Repository navigation
connection string not being recognized #26
Description
I have a secret in the following format as per all of the documentation
psql "host='mypostgresservername1.postgres.database.azure.com' port=5432 dbname='postgres' user='myuser@mypostgresservername1' password='&&&&&&&&&' sslmode=require"
My password contains and starts with special (non alpha-numeric) characters and might also end the same way.
I have verified through connecting via the command line and DBeaver that all values are correct.
I get the following ambiguous and frustrating error:
Error: Error occurred while running action:
Error: Please provide a valid connection string. A valid connection string is a series of keyword/value pairs separated by space. Spaces around the equal sign are optional. To write an empty value, or a value containing spaces, surround it with single quotes, e.g., keyword = 'a value'. Single quotes and backslashes within the value must be escaped with a backslash
No whitespace in any of my values, nor backslashes.
Please help. This is terrible.
Activity
pk-ot commentedon Jan 27, 2024
For me it started working once I used
user='myuser'(without the server name).yuseow commentedon Feb 14, 2024
the way the documentation listed to store the whole connection string like so:
connection-string: ${{ secrets.AZURE_POSTGRESQL_CONNECTION_STRING }}DOES NOT WORK AT ALL. this is how you need to put your connection string in the yaml file for it to work :/ separate the components and string it together like this:
connection-string: "psql host=${{secrets.AZURE_POSTGRES_SERVER_NAME}} port=5342 dbname=${{secrets.AZURE_POSTGRES_DB_NAME}} user=${{secrets.AZURE_POSTGRES_USERNAME}} password=${{secrets.AZURE_POSTGRES_PASSWORD}} sslmode=require"