Remote connection string doesn't seem to work - am I missing something?

[conraddecker]

I'm attempting to connect to Redshift using the following connection string (some specific details omitted):

redshift://segment@redshift-endpoint:5439/segment

Every time I attempt to do that I receive the following error

Error: getaddrinfo ENOTFOUND segment segment:5432

I am able to connect to that remote instance using psql on my local computer. I am also able to connect to a local database no problem but that remote connection does not seem to want to work.

Other testing of remote connection strings seem to fail as well. The following

postgres://user:pass@host:5432/database

prompts me for a password even though one is provided. When I provide it again, I'm given the following error

error: no pg_hba.conf entry for host "ip address", user "user", database "database", SSL off

but I'm able to connect via psql from my computer.

Am I missing something obvious or is the connection string not being parsed correctly?

[sasha-alias]

Hi, thanks for reporting the issue. I guess that you really revealed a bug in connection string parsing.. Does your password contain some special character like slash, colon and similar?

[conraddecker]

Okay great, thanks for the quick response! I'm glad it doesn't look like I'm missing something obvious.

The only special character that the password has is a pound sign, everything else is a combination of letters and numbers. If it helps, I'm happy to send along the full connection string and can change it after the fact. Additionally, I'll change the password right now to something simple - with no special characters - and see if that changes anything.

[conraddecker]

Changing the password to something without the pound sign seems to have fixed the issue. Once I changed it, sqltabs connected straight away. Let me know if there's any additional information I can provide to help troubleshoot but feel free to close this issue if you'd like.

[sasha-alias]

@conraddecker btw, did you have password written straight in the connection string or you entered it in the password dialog on connection?

[conraddecker]

@sasha-alias I put it directly in the connection string