Zoho MySQL/MariaDB connections not working
Hi people,
Has anyone ever got any of the MariaDB or MySQL connections added as a connection to a cloud service (not a on-prem agent)?
I have tested now with 2 different providers, GoDaddy & AWS both currently testing with MariaDB and Zoho Flow will not let me create any connection for them, no matter what I get the error "Cannot create PoolableConnectionFactory".
And I can't see anywhere else I can get error logs for failed setup of connections to give me a better idea of what's failing.
On both cloud services that I am testing with we have temporarily allowed any connections to port 3306 to rule out firewall problems with requiring setting the allowed IPs and I can successfully connect to both in MySQL Workbench without issues with the open firewall rules.
Unless i'm crazy there is pretty much only 2 options on this setup, 'On-Prem Agent' which i am not using as they are all cloud hosts. And SSL, which I have tested on and off. The rest are just the connection fields that are just same as im entering to MySQL Workbench (apart from adding the database name)