[mythtv-users] Android Mythrontend on Firestck 4K

[Peter Bennett]

Try This:

SELECT user,plugin,host FROM mysql.user;

Sample result from my system:
'mythtv', 'mysql_native_password', '192.168.0.%'
'debian-sys-maint', 'caching_sha2_password', 'localhost'
'mysql.infoschema', 'caching_sha2_password', 'localhost'
'mysql.session', 'caching_sha2_password', 'localhost'
'mysql.sys', 'caching_sha2_password', 'localhost'

Your mythtv user id must have mysql_native_password.

Use this in /etc/mysql/mysql.conf.d/mysqld.cnf before you create your 
user id:
default_authentication_plugin=mysql_native_password

You may be able to fix it this way if it has the wrong plugin:
ALTER USER 'mythtv'@'192.168.0.%' IDENTIFIED WITH mysql_native_password 
by 'mythtv';

Alternatively create the user id this way:
create user 'mythtv'@'192.168.0.%' identified with mysql_native_password 
by 'mythtv';

Peter

On 9/27/23 11:43, Ken Mandelberg wrote:
> Hi Peter
>
> Waiting to hear from you.
>
> Is
>
> Plugin caching_sha2_password could not be loaded: dlopen failed: 
> library 
> "/home/peter/proj/github.com/MythTV/packaging-master/android/libsinstall/lib/mariadb/plugin/caching_sha2_password.so" 
> not found
>
> what I think it is, a dlopen that would only work in your build 
> environment?
>
> Is there anything I can do on my side, or would you have to rebuild 
> the apk differently?
>
>
> Ken
>
>> Peter
>>
>> Your suggestion
>> >adb logcat mfe:D *:S |& tee /tmp/android.log
>>
>> was a good idea! It yields:
>>
>>
>> 09-25 17:07:41.285 18181 18242 E mfe     : QMYSQL: Unable to connect
>> 09-25 17:07:41.285 18181 18242 E mfe     : Database error was:
>> 09-25 17:07:41.285 18181 18242 E mfe     : Plugin 
>> caching_sha2_password could not be loaded: dlopen failed: library 
>> "/home/peter/proj/github.com/MythTV/packaging-master/android/libsinstall/lib/mariadb/plugin/caching_sha2_password.so" 
>> not found
>> 09-25 17:07:46.291 18181 18242 I mfe     : 
>> mythcontext.cpp:1021:TestDBconnection  Start up failure. host 
>> 192.168.10.10, status dbStartedFail
>>
>> Incidentally my wiresharks had the mysql server asking for 
>> caching_sha2_password, and then the android response on the wire that 
>> it was "missing".
>>
>> So I guess it all makes sense now, a packaging error that wouldn't 
>> show on your device.
>>
>> Ken
>>
>>
>>
>>
>