[mythtv] Issue with android frontend

[Peter Bennett]

On 11/15/21 6:50 PM, glen wrote:
> On Mon, 2021-11-15 at 17:38 -0600, Dennis wrote:
>>
>>
>> On 11/15/21 5:27 PM, glen wrote:
>>
>>> On Mon, 2021-11-15 at 17:25 -0600, Dennis wrote:
>>>
>>>> I have downloaded the prebuilt apk located at 
>>>> https://dl.orangedox.com/pCBmBm and it cannot connect to the backend.
>>>>
>>>> 11-15 16:51:46.760  3114  3178 E mfe     : Plugin 
>>>> caching_sha2_password could not be loaded: dlopen failed: library 
>>>> "/home/peter/proj/github.com/MythTV/packaging-master/android/libsinstall/lib/plugin/caching_sha2_password.so" 
>>>> not found
>>>>
>>>> I have tried both with the same result.
>>>>
>>>> mythfrontend-20210819-arm-v31.0-163-g5da2523154-dirty.apk
>>>> mythfrontend-20211003-arm-v32-Pre-2895-gdd172c0a0c.apk
>>>>
>>>> Is this a known issue?  I searched the web and have not found 
>>>> anything,  but I have tried on several android devices and get the 
>>>> same error.  My goal is to run directly on a sony android TV and 
>>>> retire my pc/frontend.
>>>>
>>>> Thanks,
>>>>
>>>> Dennis
>>>>
>>>> ______________________________________________
>>>>
>>>> mythtv-dev mailing list
>>>> mythtv-dev at mythtv.org <mailto:mythtv-dev at mythtv.org>
>>>> http://lists.mythtv.org/mailman/listinfo/mythtv-dev 
>>>> <http://email.mg.glenb.net/c/eJxFjc0KwyAQhJ8m3ipx178cPPTS9zCuJoLakkigb9-0FAJzmW9mGHIheVKSZYezJaPABwNKIGkUggxYCjoiRC-TsQIAJx58jWWQ41Jim3mLna0uSRFs1DD5pAGSlZJUNIRqMsKMAVlxa--vAe8DPE6VvPed13df-8Gf23Ki6nOpvv3D3NLzC3-NG8WDbe4y5_u1_QBJgD3n>
>>>> http://wiki.mythtv.org/Mailing_List_etiquette 
>>>> <http://email.mg.glenb.net/c/eJxFjcsOgjAQRb8GdpI-KG0XXbhxpd9ASmcGGgsqjhj_XhIXJnd1ck4uhEQRTFvnoAcH1qiYrDJSQ6elBKscpA61wtiSdVIp7ZsUZyxVK8aCy9AsyPUUOm-BlADRueS9EYhEZMAQikSJ2rqEifle6WOlTvve-Zqb-cMTb81tHXdyibnkZezP-ck9cn68kBnrNfysA-C2f_6TL2QuO-8>
>>>> MythTV Forums: https://forum.mythtv.org 
>>>> <http://email.mg.glenb.net/c/eJxFjMsKwjAQRb-m2RmSmby6yMKN_5HMTFqhrVJjwb-34EK4HDgcuJypFfZO3TPWxNFDoQjeIge0liMkpiAIUlyLyQLgqKmssgzOTItsVW_S1ZxtbVBDPdkkBhuTBzJUqeCYXDNGLXnu_fka8DrA7Vx77O9Vr58-90M_9knt-ScXluM8_5cvU_IyxA>
>>> something on backend of myth server. have you checked your mysql 
>>> settings for bind address etc ?
>>>
>>>
>>> _______________________________________________
>>> mythtv-dev mailing list
>>> mythtv-dev at mythtv.org
>>> http://lists.mythtv.org/mailman/listinfo/mythtv-dev
>>> http://wiki.mythtv.org/Mailing_List_etiquette
>>> MythTV Forums:https://forum.mythtv.org
>>
>> Is something different needed for an android frontend?
>>
>> *I have several frontends and all can connect without issue.*
>>
>> searching "bind-address" in /etc/mysql of the backend results in the 
>> following:
>>
>> ============= ./mysql.conf.d/mysqld.cnf =================
>> bind-address        = 0.0.0.0
>> mysqlx-bind-address    = 0.0.0.0
>>
>> ============= ./conf.d/mythtv.cnf =================
>> #bind-address=::
>>
>>
>>
>> _______________________________________________
>> mythtv-dev mailing list
>> mythtv-dev at mythtv.org <mailto:mythtv-dev at mythtv.org>
>> http://lists.mythtv.org/mailman/listinfo/mythtv-dev 
>> <http://email.mg.glenb.net/c/eJxFTUsKwyAUPE3cVUye34WLbnqP5y8R1JZEAr19bSkEhoH5McH6hEFwki1HDhgUwOy40C4piRCZ9HoWKUpjuDeS4ZKoxxrLxNlaYnO0xU42m4wBpwwkxrQEwyJyEUEPXrxQ2pFit95fE9yn5TFQ8tEPWt996yd97uuwKuZSsf3D3NLza_4atxBPsttLjPdr-wFwWz4i>
>> http://wiki.mythtv.org/Mailing_List_etiquette 
>> <http://email.mg.glenb.net/c/eJxFjUEOgjAQRU9DdzaFtgMsunDjSs9Ahs4UGgEVR4y3l8SFyV-9vJdPISYk71QODp1Fqq0te-ebPtWAlg3EpvSJoW1dbMFglXTEmafCmWHipdcLixpD9K0zqQJAB5YIuI5cIViIhMlQraYwitwLeyyq0753vmY9f2SUTd_WYScXzFNehu6cn9Kx5MeLRVit4WcdiLf98598AXYIO-M>
>> MythTV Forums: https://forum.mythtv.or 
>> <http://email.mg.glenb.net/c/eJxFjEEKwyAQRU8TdxXNqHEWLrrpPUYdk0JMSmIDvX2FLgpv83mfl0MqlK0Rz2DIAOUJQEdjfSyTI2Dlkte2sEM0CZ2ischEldfBqHnlLcqNm1hC9F4pZ32PQUbuN5_R0jglRM3AYg1La69zgPswPjplP95V1k9b2iX3YxZH-I1b5qvH_-YLeOIzGg>
>
> looks ok, all my androids connect. and all prior versions androids 
> have also. i'm arch linux and mariadb. check with peter bennett. on 
> android i am using shield, but have also used mibox.
>

It looks like you have a problem with the mysql authentication method.

Before creating your mythtv users set this is mysql.cnf:

default_authentication_plugin=mysql_native_password

Alternatively if you have already created your user run this:

select * from mysql.user;

Find the host id and user name of your mythtv user

If it shows plugin as caching_sha2_password, run the below under root. 
That should change the plugin to mysql_native_password.

ALTER USER 'mythtv'@'192.168.0.%' IDENTIFIED WITH mysql_native_password 
by 'password';

Substitute your user name for mythtv, the correct host id, and your 
password.

Peter

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-dev/attachments/20211115/8ed24996/attachment.htm>