Hello all, Off-topic (or maybe not) - it is not suggested to access the MySQL database directly from the client app, either it is a Desktop app or a mobile one. Accessing the DB directly means the credentials are stored in the app, so theoretically a malicious actor could extract those from the app.
The recommended approach is to have the client app talk with the DB via a LC Server .lc script, which will handle all the confidential info. So the credentials will never leave the server. The flow is the following: The client app talks to the server -> the server connects to the DB and does the SQL query -> the DB returns the result to the server -> the server returns the result back to the app. Hope this helps. Kind regards, Panos -- On Wed, 2 Jul 2025 at 18:19, Klaus major-k via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi Bob, > > > Am 02.07.2025 um 17:13 schrieb Bob Sneidar via use-livecode < > use-livecode@lists.runrev.com>: > > Yes, but the wifi could be routed, in which case there can still be a > firewall issue. > > I'll let him check this, thank you. > > > Bob S > > > >> On Jul 2, 2025, at 8:10 AM, Klaus major-k via use-livecode < > use-livecode@lists.runrev.com> wrote: > >> > >> Hi Bob, > >> > >>> Am 02.07.2025 um 17:04 schrieb Bob Sneidar via use-livecode < > use-livecode@lists.runrev.com>: > >>> I doubt that the issue is encryption. The error is that the host is > unknown. I would check to make sure your android has good router and dns > settings, and that port 3306 is not firewalled somewhere. > >> the tablet he tested on is in the same network (WiFi) as the Mac and PC > with LC where this works. > >>> Also try and ping the hostname from somewhere outside the hosts local > network, it doesn’t matter where. You should at least get DNS resolution. > If not, your public DNS records for the host are not good. > >>> > >>> Bob S > > Best > > Klaus > -- > Klaus Major > https://www.major-k.de > https://www.major-k.de/bass > kl...@major-k.de > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
