I’d like to join in on this thread. I’m testing out Digital Ocean’s Managed database features. So I created a new project in Wappler: Docker with NodeJS, no db setup, yet.
- I add a db according to steps in tutorial by using connection string (tried both Public network and VPC Network.
- I also added my own ip to the trusted sources in DO (also did this for a droplet, that I want to use for this DB)
- Get error about self signed certificate.
- Try workaround by selecting Custom SSL profile and in my case point towards folder with .crt from DO download:
~/Wappler%20Projects/do_managed_test/app/ca-certificate.crt
- Get this error (ER_NOT_SUPPORTED_AUTH_MODE):
Any advice on how to properly connect to a DO managed DB?
PS: I just tried connecting to the managed db using DBeaver and it works perfectly with the same credentials and cert file. Great tool, btw!