Plugins can't connect to databases on Oracle Cloud
My Oracle Cloud DB setup is chalked making it very hard to use it as a testing environment.
If I use 127.0.0.1 as the db host: allows me to create databases, plugins can't connect to themOn my other server I was able to use the FQDN and it worked just fine. Not sure what I'm doing wrong this time. Just to go down the list:
If I use 172.18.0.1 as the db host: same as above
If I use FQDN as the db host: There was an error while trying to connect to the host or while executing a query: "SQLSTATE[HY000] [2002] No route to host (Connection: dynamic, SQL: SELECT 1 FROM dual)"
- Yes I tried updating my panel and wings
- Yes I gave the user perms with grant option
- Yes I am configuring the correct database information in my plugin(s)
- Yes I opened port 3306
- Yes I configured the oracle cloud subnet to allow port 3306