wkw replied
“Heroku rotates credentials periodically and updates applications where this database is attached.”
> how to ensure a remote connection can be made to my MySQL. I set it to allow from ec-2-xxxxxxxxxxx.computer-1.amazonaws.com. That worked and I was able to try out Nocodb, connecting directly to the MySQL WP DB.
yesterday u set the host in Siteground. so this s the old value.
if u go to heroku and select your project, click Resources > Heroku Postgres under Add-ons > Settings > View Credentials. then u ll see the current host
> can u help verify that?
Yes… I just whitelisted today’s amazonaws host on Siteground and Nocodb successfully connects and shows the WP DB contents.
Thanks. I’ve just gone in to this (although I didn’t see the Add-ons link)… under for postgresql-xxxx-xxxxx, it says 2 of 20 connections…
In Settings, Database Credentials… the ec2-xx-xx-xx-xx.computer-1.amazonaws.com is different from either of the two I have now whitelisted on Siteground. So, this is a third.
if u r using postgresql, then the credentials would be rotated by Heroku from time to time, which means you have to reset NC_DB once it got rotated.
heroku one-click is designed more for people to experience NocoDB. if you wanna use NocoDB in a long term, i’d suggest to have your own DB as a meta DB.