Can't connect to DB after updating Heidi

mitya33's profile image mitya33 posted 11 months ago in General Permalink

Hi all, first-time poster.

Yesterday I updated Heidi, and now I can't connect to my various Postgres DBs. These DBs are hosted on Azure and are available over public IP, with 0.0.0.0 - 255.255.255.255 whitelisted. As I say, I could connect yesterday and for years before that. Here's what I'm seeing:

image.png

I've tried changing the library option but it's the same each time. I'm not using SSL (at least, the checkbox isn't checked.)

Anyone know what might be up here? Many thanks in advance.

mitya33's profile image mitya33 posted 11 months ago Permalink

Downgrading to 12.6 fixes the issue, but curious to know what's up.

ansgar's profile image ansgar posted 11 months ago Permalink

This is a known issue and is caused by the more strict SSL mode in newer HeidiSQL versions. You should try (with the current HeidiSQL version), to check "Use SSL" and then for "Certificate verfication" select "No verification".

43878-1-HeidiSQL_solution_redacted.png

That issue was also reported with some solutions in issue #2067

mitya33's profile image mitya33 posted 11 months ago Permalink

Ah great, thank you. I'll give that a go. Appreciate the help!

Please login to leave a reply, or register at first.