Putting aside the security aspects that I have taken on board, I still want to solve the technical problem of why I cannot connect to a our MySQL database from a standalone, but I can from the IDE.
To recap, I have the following lines to test basic connection to the net, that I call on openstack
Code: Select all
put url "http://www.google.com" into tURL
if tURL is empty then
answer "Could not update preferences. Using local prefs"
If this succeeds, then I try to connect to a MySQL database. In Standalone settings, when I set LiveCode to search automatically for inclusions, the standalone gets past the code given above, i.e. no error message, but it gives error on connecting to the database:
In contrast, when I select inclusions manually, adding these:
SSL & Encryption
then the URL test gives an error, i.e. it cannot connect to the web site.
Any hints to proceed would be appreciated. In particular:
- What am I failing to add in inclusions, that prevents the connection to www? I thought HTTPD would do it
- If, as SparkOut suggested, the database (under our control) stops direct access from the internet, how come it allows connection from the IDE?
Grateful for any thoughts.