I've got Virtualmin running successfully on Amazon EC2 (using a step-by-step tutorial). I use the server to run Sendy, a newsletter program. In order to integrate Sendy now with Facebook Ads (and other apps), I want to use Zapier. Zapier shows no error messages when I connect FB and Sendy and do a test run (or make the Zap active). It can connect to Sendy and sees the brands and lists there just fine. BUT no new subscribers get added. I did some research and talked with Sendy as well as Zapier support. It looks like Zapier needs explicit permission to access the server and database. More research followed. I found out the IP (220.127.116.11/32) that Zapier uses to connect to MySQL and added it to the security group I had created for the server instance on Amazon EC2. So far so good, but now I'm not 100% sure how to proceed: Do I have to whitelist Zapier's IP address in Virtualmin's firewall settings and if so, how do I do that? Or do I have to add database permissions or database user permissions for firstname.lastname@example.org/32 (and again how would I do that using Virtualmin's interface)? Or do I need to do both? Or is that wrong and there is something else to do?
Thanks for any clues you can give me. :)