[mythtv-users] Trying Nvshield android package, unsuccessfully. Pointers needed.
John Pilkington
johnpilk222 at gmail.com
Fri Jan 11 11:45:06 UTC 2019
On 11/01/2019 03:20, Kris J wrote:
>
>
> On Thu, Jan 10, 2019 at 9:24 PM Kris J <kris.jensen.knj at gmail.com
> <mailto:kris.jensen.knj at gmail.com>> wrote:
>
>
>
> On Thu, Jan 10, 2019 at 7:02 PM Peter Bennett <pb.mythtv at gmail.com
> <mailto:pb.mythtv at gmail.com>> wrote:
>
>
>
> On 1/10/19 6:37 PM, Kris J wrote:
> >
> >
> > On Thu, Jan 10, 2019 at 5:18 PM Peter Bennett
> <pb.mythtv at gmail.com <mailto:pb.mythtv at gmail.com>
> > <mailto:pb.mythtv at gmail.com <mailto: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
> <mailto:kris.jensen.knj at gmail.com>
> <mailto:kris.jensen.knj at gmail.com
> <mailto:kris.jensen.knj at gmail.com>>> wrote:
> >>
> >>
> >>
> >> On Thu, Jan 10, 2019 at 10:52 AM Kris J
> >> <kris.jensen.knj at gmail.com
> <mailto:kris.jensen.knj at gmail.com>
> >> <mailto:kris.jensen.knj at gmail.com
> <mailto:kris.jensen.knj at gmail.com>>> wrote:
> >>
> >>
> >>
> >> On Thu, Jan 10, 2019 at 10:48 AM Peter Bennett
> >> <pb.mythtv at gmail.com
> <mailto:pb.mythtv at gmail.com> <mailto:pb.mythtv at gmail.com
> <mailto: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
> <mailto:pb.mythtv at gmail.com> <mailto:pb.mythtv at gmail.com
> <mailto: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
> <mailto:pb.mythtv at gmail.com>
> >>>> <mailto:pb.mythtv at gmail.com
> <mailto: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
> <http://www.mythtv.org> <http://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
> >
> >
> >
> >
> >
> I don't think that will make a difference, 5.7 is the version
> shipping
> with ubuntu now. The only one important is mysql-server and you
> have 5.7
> so that should be OK. The latest mysql is version 8. I am using
> mariadb
> which is at version 10. It seems ubuntu ships newer versions of
> mariadb
> than of mysql.
>
> Perhaps you have some network problem. Using ethernet try
> plugging it
> differently, into a different router if possible. Also try
> different cables.
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org <mailto:mythtv-users at mythtv.org>
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
>
> I think you are correct about network issues. Looking though the
> mysql log's and they are filled with errors like such:
>
> 2019-01-08T18:12:32.196916Z 8808 [Note] Aborted connection 8808 to
> db: 'mythconverg' user: 'mythtv' host: 'localhost' (Unknown error)
> 2019-01-08T18:12:32.626207Z 8855 [Note] Aborted connection 8855 to
> db: 'mythconverg' user: 'mythtv' host: '192.168.0.15' (Got an error
> reading communication packets)
> 2019-01-08T18:12:33.792349Z 8858 [Note] Aborted connection 8858 to
> db: 'mythconverg' user: 'mythtv' host: '192.168.0.15' (Got an error
> reading communication packets)
> 2019-01-08T18:13:19.080825Z 8857 [Note] Aborted connection 8857 to
> db: 'mythconverg' user: 'mythtv' host: 'localhost' (Unknown error)
> 2019-01-08T18:15:59.133402Z 8910 [Note] Got an error reading
> communication packets
>
> hmmm....I'll have to test things on the network. Or maybe remake the
> server, in preparation of 0.30 release. With mariadb.
>
>
> Many thanks Peter
>
>
> I think I track it down to DB corruption.
> Running ( mysql -umythtv -p mythconverg -e 'status;' ) on my server shows:
> --------------
> mysql Ver 14.14 Distrib 5.7.24, for Linux (x86_64) using EditLine wrapper
>
> Connection id: 11854
> Current database: mythconverg
> Current user: mythtv at localhost
> SSL: Not in use
> Current pager: stdout
> Using outfile: ''
> Using delimiter: ;
> Server version: 5.7.24-0ubuntu0.16.04.1 (Ubuntu)
> Protocol version: 10
> Connection: Localhost via UNIX socket
> Server characterset: latin1
> Db characterset: utf8
> Client characterset: utf8
> Conn. characterset: utf8
> UNIX socket: /var/run/mysqld/mysqld.sock
> Uptime: 4 hours 2 min 39 sec
>
> Threads: 46 Questions: 2801872 Slow queries: 0 Opens: 4221 Flush
> tables: 1 Open tables: 128 Queries per second avg: 192.449
> --------------
>
> Searching for answers lead me to a old outdated wiki page that explains
> the problem and how to fix the DB.
> (https://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding)
>
> However I'm leery to apply the suggested fix as the page has been
> labeled outdated.
>
> Is the "Fixing the database corruption" entry still a viable fix for
> Mythtv .29.1?
I ran the same mysql status query on my Fedora 28 box running master,
which connects and runs well with a firestick 4K and Peter's 32-bit
20181124 build. The characterset results are identical. I have a
'Server: MariaDB' line, and the Server Version is 10.2.19-MariaDB
MariaDB Server. Using outfile: has two ticks, not the double-tick as
shown in your post, and my UNIX socket is /var/lib/mysql/mysql.sock,
where the differences might be Fedora/Ubuntu or just a quirk of my setup.
I don't claim to understand mysql, but I'm not certain that your mysql
config is bad.
John P
More information about the mythtv-users
mailing list