[mythtv-users] Trying Nvshield android package, unsuccessfully. Pointers needed.

[Kris J]

On Thu, Jan 10, 2019 at 5:18 PM Peter Bennett <pb.mythtv at gmail.com> wrote:

>
>
> On 1/10/19 4:49 PM, Kris J wrote:
>
>
>
> On Thu, Jan 10, 2019 at 12:51 PM Kris J <kris.jensen.knj at gmail.com> wrote:
>
>>
>>
>> On Thu, Jan 10, 2019 at 10:52 AM Kris J <kris.jensen.knj at gmail.com>
>> wrote:
>>
>>>
>>>
>>> On Thu, Jan 10, 2019 at 10:48 AM Peter Bennett <pb.mythtv at gmail.com>
>>> wrote:
>>>
>>>>
>>>>
>>>> On 1/10/19 10:41 AM, Kris J wrote:
>>>>
>>>>
>>>>
>>>> On Thu, Jan 10, 2019 at 10:32 AM Peter Bennett <pb.mythtv at gmail.com>
>>>> wrote:
>>>>
>>>>>
>>>>>
>>>>> On 1/10/19 10:21 AM, Kris J wrote:
>>>>>
>>>>>
>>>>>
>>>>> On Wed, Jan 9, 2019 at 6:43 PM Peter Bennett <pb.mythtv at gmail.com>
>>>>> wrote:
>>>>>
>>>>>>
>>>>>>
>>>>>> On 1/9/19 1:47 PM, Kris J wrote:
>>>>>>
>>>>>> I can install either available 64bit packages from
>>>>>> https://dl.bintray.com/bennettpeter/generic/. The android fronted
>>>>>> starts up with trying to connect to backend, it seems slow to find the
>>>>>> backend (29.1+fixes) and sometimes fails. However after several try's it
>>>>>> eventually connects. (using ETH)
>>>>>>
>>>>>>
>>>>>> I can move about the frontend. However most end points in the menu
>>>>>> lead to a loading screen that seems to hang the Nvshield, and requires a
>>>>>> hard power off.
>>>>>>
>>>>>>
>>>>>> I've been reading the user list and wiki for pointer. However it
>>>>>> seems I'm the only one with this type of trouble. I see no other reports of
>>>>>> this type so I must have missed something somewhere.
>>>>>>
>>>>>>
>>>>>> Any pointers appreciated.
>>>>>>
>>>>>> Many thanks.
>>>>>>
>>>>>>
>>>>>>
>>>>>> I have not seen or heard of this behavior. I assume you got as far as
>>>>>> the main menu so it must be successfully connecting to the database and the
>>>>>> backend.
>>>>>>
>>>>>> Have you gone into setup and set the audio and video profile (or
>>>>>> maybe it hangs even before you can get there). If you have not set these up
>>>>>> and you are attempting playback it will not work well.
>>>>>>
>>>>>> If you still have a problem you can get a log.
>>>>>>
>>>>>> If you have adb installed and debug mode activated, you can do this
>>>>>> to get a log:
>>>>>>
>>>>>> On your linux machine, with the ip address of the shield:
>>>>>> adb connect [ip address]
>>>>>> adb logcat mfe:D *:S |& tee android.log
>>>>>>
>>>>>> Then try starting mythfrontend and navigating. If it is having errors
>>>>>> you will see them on the screen and in the android.log file. This may give
>>>>>> you an idea of what is wrong.
>>>>>>
>>>>>> Peter
>>>>>>
>>>>>>
>>>>>
>>>>> Hi, Peter
>>>>>
>>>>> I don't see anything in the log (https://pastebin.com/AuTgdVXk)
>>>>> that's a obvious, other then minor font errors.
>>>>>
>>>>> The log stops when I navigate to "setup/general" Then the load screen
>>>>> pops up and the shield needed are power off.
>>>>>
>>>>> Many Thank for your time.
>>>>>
>>>>>
>>>>> The log looks normal. Which backend version are you using? Perhaps
>>>>> there is a problem with that. The android frontend will work with backend
>>>>> version 29 or later. Older versions will likely cause problems.
>>>>>
>>>>> _______________________________________________
>>>>>
>>>>> Backend package = mythtv-backend-master
>>>> 29.1+fixes.20181228.af5d819~ubuntu16.04.1
>>>>
>>>> And
>>>>
>>>> "m-user at MythServer:~/build$ mythbackend -v
>>>> 2019-01-10 10:35:20.003539 C  mythbackend version:  [v29.1]
>>>> www.mythtv.org
>>>> 2019-01-10 10:35:20.003567 C  Qt version: compile: 5.5.1, runtime:
>>>> 5.5.1"
>>>>
>>>>
>>>>
>>>>
>>>> I have no idea what the problem is. You could try uninstalling and
>>>> reinstalling, also try looking at a full log. That gives messages from all
>>>> applications and android itself, there you can see things like missing
>>>> libraries:
>>>>
>>>> adb logcat |& tee tmp/android.log
>>>>
>>>> Peter
>>>> _______________________________________________
>>>>
>>>>
>>>
>>> Ok thank for the logging tips.
>>>
>>> I'll see if I can find anything meaningful to work off of.
>>>
>>> Many Thanks again.
>>>
>>>
>>
>>
>>
>> So I noticed the backend log has some errors when the android frontend
> has the loading screen. :
>
> Jan 10 16:10:07 MythServer mythbackend: mythbackend[1690]: I
> MythSocketThread(84) mainserver.cpp:7674 (connectionClosed) Playback
> sock(1b0a970) 'android-3a0785970c9ae7ba' disconnected
> Jan 10 16:10:07 MythServer mythbackend: mythbackend[1690]: I
> MythSocketThread(86) mainserver.cpp:7674 (connectionClosed) Monitor
> sock(1a69530) 'android-3a0785970c9ae7ba' disconnected
> Jan 10 16:10:07 MythServer mythbackend: mythbackend[1690]: E CoreContext
> mythdbcon.cpp:873 (prepare) Error preparing query: SELECT data FROM
> settings WHERE value = :KEY AND hostname = :HOSTNAME
> Jan 10 16:10:07 MythServer mythbackend: mythbackend[1690]: E CoreContext
> mythdbcon.cpp:875 (prepare) Driver error was [2/2013]:#012QMYSQL3: Unable
> to prepare statement#012Database error was:#012Lost connection to MySQL
> server during query
> Jan 10 16:10:07 MythServer mythbackend: mythbackend[1690]: I CoreContext
> mythdbcon.cpp:263 (Reconnect) MySQL reconnected successfully
>
> I don't have problems connecting with my other frontends and kodi's
> frontend connect fine on the same shield.
>
> Still trying however.
>
>
>
>
>
> That looks like the root cause of the problem. I seem to remember
> something like this being the result of having conflicting versions of
> database software on client and server. Do you have very old mysql server
> software?
>
>
>
>
Hmm.. I seem to have old and new mysql packages installed on my myth
server. I did a package search for "mysql" and found:

libdbd-mysql-perl 4.033-1ubuntu0.1
  libmysqlclient18 5.5.62-0ubuntu0.14.04.1
  libmysqlclient20 5.7.24-0ubuntu0.16.04.1
  libqt4-sql-mysql 4.8.7+dfsg-5ubuntu2
  libqt5sql5-mysql 5.5.1+dfsg-16ubuntu7.5
  mysql-client 5.7.24-0ubuntu0.16.04.1 K-O
  mysql-client-5.7 5.7.24-0ubuntu0.16.04.1 K-O
  mysql-client-core-5.7 5.7.24-0ubuntu0.16.04.1
  mysql-common 5.7.24-0ubuntu0.16.04.1
  mysql-server 5.7.24-0ubuntu0.16.04.1
  mysql-server-5.7 5.7.24-0ubuntu0.16.04.1
  mysql-server-core-5.7 5.7.24-0ubuntu0.16.04.1
  php5-mysql 5.5.9+dfsg-1ubuntu4.26
  php7.0-mysql 7.0.32-0ubuntu0.16.04.1
  python-mysqldb 1.3.7-1build2

So it's the lingering 5.5 mysql packages the cause?

I'm sketchy when it comes to DB stuff. But I would think removing the older
packages listed below would be ok. Yes?
libmysqlclient18 5.5.62-0ubuntu0.14.04.1,
 libqt4-sql-mysql 4.8.7+dfsg-5ubuntu2,
 libqt5sql5-mysql 5.5.1+dfsg-16ubuntu7.5
 php5-mysql 5.5.9+dfsg-1ubuntu4.26
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190110/3f9a81ca/attachment-0001.html>