Direct access to MySQL on mobile

[Klaus major-k]

Hi Bob,

> Am 02.07.2025 um 17:04 schrieb Bob Sneidar via use-livecode <use-livecode at 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
> 
> 
>> On Jul 2, 2025, at 7:29 AM, Klaus major-k via use-livecode <use-livecode at lists.runrev.com> wrote:
>> 
>> Hi Matthias,
>> 
>>> Am 02.07.2025 um 16:20 schrieb Matthias Rebbe via use-livecode <use-livecode at lists.runrev.com>:
>>> 
>>> 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 mystudent knows the IP address.
>> 
>> In the meantime I found that we did not check "SSL & Encryption" in the "Inclusions" in the STAB.
>> Maybe that will already help.
>> 
>> We are communicating via MS Temans and Monsieur is VERY BUSY (Rentner/Retired :-D) so I need 
>> to wait for any progress he makes. :-)
>> 
>> Thank you!
>> 
>>> Von meinem iPhone gesendet
>>> 
>>>> Am 02.07.2025 um 15:41 schrieb Klaus major-k via use-livecode <use-livecode at lists.runrev.com>:
>>>> 
>>>> 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:
>>>> xxxx.xxxmedia.ch:3306
>>>> DB Username and PWD are correct.
>>>> 
>>>> However when we create an Android app and try it on a tablet we get:
>>>> -----------------------------------------------------------
>>>> Unable to connect to the database:
>>>> Unknown MySQL server host 'kallisto.kreativmedia.ch' (13)
>>>> -----------------------------------------------------------
>>>> 
>>>> What is the problem?  Do we need to add something to the address like
>>>> https or something?
>>>> 
>>>> Any hints VERY welcome!

Best

Klaus

--
Klaus Major
https://www.major-k.de
https://www.major-k.de/bass
klaus at major-k.de