Hi folks
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
on get_remote_prefs
put url "http://www.google.com" into tURL
if tURL is empty then
answer "Could not update preferences. Using local prefs"
exit get_remote_prefs
end if
end get_remote_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:
HTTPD Library
MySQL
Database
SSL & Encryption
Answer Dialog
Ask Dialog
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.
Kaveh