Re: Direct access to MySQL on mobile Part 2

2025-07-08 Thread Klaus major-k via use-livecode
Hi all, > Am 08.07.2025 um 15:49 schrieb Klaus major-k : > Before I forget, this is an Android app/cellphone we ware testing. >> Am 08.07.2025 um 15:46 schrieb Klaus major-k via use-livecode >> : >> Hi all, >> we finally resolved the problem of "Database not found" by supplying >> the actual IP a

Re: Direct access to MySQL on mobile Part 2

2025-07-08 Thread panagiotis merakos via use-livecode
Hello Klaus, Just a shot in the dark, in the Android settings, have you checked the "Internet" and the "Allow http connections" permissions? Cheers, Panos On Tue, 8 Jul 2025 at 16:51, Klaus major-k via use-livecode < use-livecode@lists.runrev.com> wrote: > Before I forget, this is an Android a

Re: Direct access to MySQL on mobile Part 2

2025-07-08 Thread Klaus major-k via use-livecode
Before I forget, this is an Android app/cellphone we ware testing. > Am 08.07.2025 um 15:46 schrieb Klaus major-k via use-livecode > : > > Hi all, > > we finally resolved the problem of "Database not found" by supplying > the actual IP address. > > Recommended or not, we currently want to use

Re: Direct access to MySQL on mobile Part 2

2025-07-08 Thread Klaus major-k via use-livecode
Hi all, we finally resolved the problem of "Database not found" by supplying the actual IP address. Recommended or not, we currently want to use direct access from the cellphone to an online MySQL database. We may change that later. LC 10.0.2 macOS 15.5 Now we get: Can't create TCP/IP socket

Re: Direct access to MySQL on mobile

2025-07-02 Thread Bob Sneidar via use-livecode
I store the credentials in an encrypted format, and the encryption library that contains the key is a different file and is itself password protected. Only I know the. keys and passwords. That probably isn’t even enough for a lot of people who would still not recommend this, but frankly I do not

Re: Direct access to MySQL on mobile

2025-07-02 Thread Klaus major-k via use-livecode
Hi Matthias, > Am 02.07.2025 um 19:46 schrieb Matthias Rebbe via use-livecode > : > > I would say that first depends on if the app is for ones own use or available > to the public. > And 2nd for inhouse solutions direct access should not be a problem. > But if the mySQL server is hosted on the

Re: Direct access to MySQL on mobile

2025-07-02 Thread Matthias Rebbe via use-livecode
I would say that first depends on if the app is for ones own use or available to the public. And 2nd for inhouse solutions direct access should not be a problem. But if the mySQL server is hosted on the internet even if the app is for ones own use, direct remote access wouldn‘t be a good idea. T

Re: Direct access to MySQL on mobile

2025-07-02 Thread panagiotis merakos via use-livecode
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 ap

Re: Direct access to MySQL on mobile

2025-07-02 Thread Klaus major-k via use-livecode
Hi Bob, > Am 02.07.2025 um 17:13 schrieb Bob Sneidar via use-livecode > : > 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 >> wrote: >> >> Hi

Re: Direct access to MySQL on mobile

2025-07-02 Thread Bob Sneidar via use-livecode
Yes, but the wifi could be routed, in which case there can still be a firewall issue. Bob S > On Jul 2, 2025, at 8:10 AM, Klaus major-k via use-livecode > wrote: > > Hi Bob, > >> Am 02.07.2025 um 17:04 schrieb Bob Sneidar via use-livecode >> : >> >> I doubt that the issue is encryption.

Re: Direct access to MySQL on mobile

2025-07-02 Thread Klaus major-k via use-livecode
Hi Bob, > Am 02.07.2025 um 17:04 schrieb Bob Sneidar via use-livecode > : > > 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 h

Re: Direct access to MySQL on mobile

2025-07-02 Thread Klaus major-k via use-livecode
Hi Matthias, > Am 02.07.2025 um 16:59 schrieb Matthias Rebbe via use-livecode > : > > Klaus, > using shell on Mac or Windows you could do a ping HOSTNAME which then would > return the ip adress. > Or you do use the LC function hostNameToAdress. ;) ah, yes! :-) Thank you, will try that. > Reg

Re: Direct access to MySQL on mobile

2025-07-02 Thread Bob Sneidar via use-livecode
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. Also try and ping the hostname from somewhere outside the hosts local network, it doesn’t matter

Re: Direct access to MySQL on mobile

2025-07-02 Thread Matthias Rebbe via use-livecode
Klaus, using shell on Mac or Windows you could do a ping HOSTNAME which then would return the ip adress. Or you do use the LC function hostNameToAdress. ;) Regards, Matthias Von meinem iPad gesendet > Am 02.07.2025 um 16:30 schrieb Klaus major-k via use-livecode > : > > Hi Matthias, > >> A

Re: Direct access to MySQL on mobile

2025-07-02 Thread Klaus major-k via use-livecode
Hi Matthias, > Am 02.07.2025 um 16:20 schrieb Matthias Rebbe via use-livecode > : > > It looks like that the android phone cannot get the correct IP address for > the domain name. > Did you already try to use the IP address of my server, instead of the domain > name? will have to check if mys

Re: Direct access to MySQL on mobile

2025-07-02 Thread Matthias Rebbe via use-livecode
It looks like that the android phone cannot get the correct IP address for the domain name. Did you already try to use the IP address of my server, instead of the domain name? Von meinem iPhone gesendet > Am 02.07.2025 um 15:41 schrieb Klaus major-k via use-livecode > : > > Hi friends, > > w

Direct access to MySQL on mobile

2025-07-02 Thread Klaus major-k via use-livecode
Hi friends, we have a stack that accesses an online MySQL database directly. This works in the IDE on Mac and Windows, the address is like this: .xxxmedia.ch:3306 DB Username and PWD are correct. However when we create an Android app and try it on a tablet we get: