Godaddy Mysql connection

[A_Computer_Solu]

Hi,
I am trying to connect to mysql database using appsheet. I am not getting any headway and asking for help. Anyone was able to connect? I get the following error message. I also added all the ipaddresses and firewall ip and still same error message. HELP please!

Error

Failed to establish connection. Details: One or more SQL errors has been encountered: AppSheet does not have permission to connect to the database. Please add AppSheet’s IP addresses from https://help.appsheet.com/performance-scale-reliability/managing-ip-addresses-and-firewall-informati... to the database firewall.

[A_Computer_Solu]

I messaged godaddy and they allowed it, they just put a % in the remote host. It is working now! Hooray!

[Steve]

A_Computer_Solutions:

they just put a % in the remote host

That strikes me as a very bad idea.

[MultiTech]

Steve:

A_Computer_Solutions:

they just put a % in the remote host

That strikes me as a very bad idea.

Indeed. The solution to your problem is right there in the error.

A_Computer_Solutions:

Please add AppSheet’s IP addresses from https://help.appsheet.com/performance-scale-reliability/managing-ip-addresses-and-firewall-informati... to the database firewall.

If you follow that link you’ll find a long list of IPs that AppSheet uses to connect to data sources; these need to be added to the white list for your SQL - all of them.

[A_Computer_Solu]

cab you be more specific, you mean this is a security risk?

[MultiTech]

Well I’m not sure exactly what this means:

A_Computer_Solutions:

they just put a % in the remote host

Did they put in SOME of the IPs, but not all?

• Then you’ll likely run into this problem again when an IP that’s not on the list is used.

[Steve]

A percent sign (%) is an SQL wildcard that matches anything, so “they” essentially allowed any remote host. Do you really want to accept any inbound connection from anywhere? The correct answer is no.

[A_Computer_Solu]

Absolutely not. Thanks for the information. Im a newby to this. Do you know how to add a shopping cart to the app? I have tables with information and prices and now just need to setup a checkout option. can you walk me through it if you know pls

[LeventK]

Are you intending to integrate an online payment with the checkout as well? If so, which online payment gateway are you gonna/intented to use?

[A_Computer_Solu]

I am new to this, but thinking of google pay or paypal or both.

[LeventK]

Then you will be clearly needing Google Apps Scripting support with webhook workflow as AppSheet does not support online payment gateway integration right at the moment.