Digital Ocean Postgres DB, Can't Connect

Get Help
1

I am trying to connect to a Postgres DB running on Digital Ocean, as a data source, but I am unable to get the connection to work.

It’s the same DB I am using as the system store for Metabase, and for that to work I need to add the following to the end of the URL.

ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory&sslmode=require

But if I add that to the Additional JDBC connection string options, I get the following error:

metabase.util.i18n.UserLocalizedString cannot be cast to java.lang.String

Anyone got any ideas?

Thanks

Gareth

2

Hi @gazzer82
Which version of Metabase?
Are you using the same credentials for both connections?
So if you do not add the string options, then it connects correctly?
Do you see more details in the Metabase log?
It looks similar to this issue, but that is caused by bad credentials:
https://github.com/metabase/metabase/issues/10347

3

Hi @flamber I'm currently using 0.33 Preview 2

Yes, same credentials for both.

If I don't add the string then the connection fails as their is no SSL being used, so I get the following.

No pg_hba.conf entry for host "3.8.109.126", user "doadmin", database "stitch", ssl off.

Which is what I would expect.

Metabase logs show this with the string in place.

{:valid false, :dbname "metabase.util.i18n.UserLocalizedString cannot be cast to java.lang.String", :message "metabase.util.i18n.UserLocalizedString cannot be cast to java.lang.String"}

That issue seems like the same issue, and look like it's fixed in RC1, unfortunately I'm stuck on Preview 2 at the moment as RC1 is breaking my Oracle connection.

Will try again once I've managed to update and report back if it's not fixed.