[mythtv] [mythtv-users] Android mythfrontend mysql driver problems

[David Hampton]

On Wed, 2022-09-28 at 17:34 -0400, Peter Bennett wrote:
> 
> On 9/28/22 17:15, David Engel wrote:
> > What problem?  I've rebuilt recently with no, new problems.  There
> > are some resume from sleep related problems but I've usually
> > attributed them to Nvidia Shield updates and not MythTV.
> 
> The problems are:
> 
> 1. The build required API level 29 but the fire stick only has 25.
> This would not affect the Shield. It was caused by the new QT which 
> disallowed specification of the minimum version in the manifest. I
> fixed this locally by going back to api version 21 as we had used
> before.
> 
> 2. Rebuilding the libs, I was unable to build the mariadb-connector 
> library due to an error in the cmake file ConnectorName.cmake . It
> has an END() command where it should have had ENDIF(). The build
> failed with error "CMake Error at cmake/ConnectorName.cmake:30
> (ENDMACRO):   Flow control statements are not properly nested.".
> Changing it to ENDIF let the build complete that but I don't know
> what is really going on with this, whether the downloaded source has
> an error or whether some patch was applied incorrectly or if I am
> just misunderstanding the whole problem.

The downloaded source has an error.

> 3. After fixing those, I built and installed mythfrontend (32bit 
> version) on a fire stick 4K. Starting it up fails with the message 
> "mythdbcon.cpp:84:MSqlDatabase  FATAL: Unable to load the QT QMYSQL 
> driver, is it installed?". All I see is the splash screen for a few 
> seconds then back to the android home page.
> 
> It is possible that my fix for the mariadb connector was all wrong
> and caused the DB problem. Or maybe we need a different mariadb
> connector version. It is using version 2.3.7.

After fixing ConnectorName.cmake I am able to build, install, and run
mythtv on my nvidia shield.  I did this with both 32bit and 64bit
builds.  I know this isn't a fire stick, but if the problem was related
to mariadb connector v2.3.7 it should affect all devices.  This is
using android ndk 21.0.6113669.

I know you've probably already looked at this, but when Qt is
configured does it say that its going to build the mysql connector?  If
you have a logfile of the library build, try this:

    grep -B0 -A10 'Qt Sql Drivers' <logfilename>

This is what I get on my build system:

  Qt Sql Drivers:
    DB2 (IBM) .............................. no
    InterBase .............................. no
    MySql .................................. yes
    OCI (Oracle) ........................... no
    ODBC ................................... no
    PostgreSQL ............................. no
    SQLite2 ................................ no
    SQLite ................................. yes
      Using system provided SQLite ......... no
    TDS (Sybase) ........................... no

David

P.S.  I just ordered a fire stick for testing purposes.