[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