[mythtv-users] mythbackend not responding on port 6543
Karl Newman
newmank1 at asme.org
Thu Nov 17 04:55:35 UTC 2016
On Wed, Nov 16, 2016 at 6:59 PM, Stephen Worthington <
stephen_agent at jsw.gen.nz> wrote:
> On Tue, 15 Nov 2016 07:04:34 -0800, you wrote:
>
> >On Tue, Nov 15, 2016 at 5:41 AM, Stephen Worthington <
> >stephen_agent at jsw.gen.nz> wrote:
> >
> >> On Tue, 15 Nov 2016 01:33:53 +1300, you wrote:
> >>
> >> The conclusion I reached from this is that the problem is related to
> >> my database somehow, rather than the versions of any software I am
> >> running. Something about my current database triggers the problem.
> >>
> >>
> >It might be enlightening to do a dump and diff of the settings table from
> >your working vs. non-working backups.
> >
> >Karl
>
> Thanks for the idea. Doing it with database tables is a just a *bit*
> more difficult than using the diff command, but I worked it out. So
> can anyone see any problems in the diff? I can not.
>
> If you can not read it properly in your email program, I have also put
> it in a file on my web server:
>
> http://www.jsw.gen.nz/mythtv/6543/settings_diff.txt
>
> MariaDB [mythconverg]> select hostname,value,data from (select
> s.hostname,s.value,s.data from settings s union all select
> o.hostname,o.value,o.data from settings_old o) t where hostname is
> null or hostname='mypvr' group by hostname,value having count(*)=1
> order by hostname,value;
> +----------+----------------------------+-------------------
> ------------------------------------------------------------
> ------------------------------------------------------------
> ---------------------+
> | hostname | value | data
>
> |
> +----------+----------------------------+-------------------
> ------------------------------------------------------------
> ------------------------------------------------------------
> ---------------------+
> | NULL | BrowserDBSchemaVer | 1002
>
> |
> | NULL | Country | NZ
>
> |
> | NULL | Language | en_GB
>
> |
> | NULL | MovieGrabber | metadata/Movie/tmdb3.py
>
> |
> | NULL | MusicStreamListModified | 2016-02-10T13:20:13Z
>
> |
> | NULL | recommend_enabled |
>
> |
> | NULL | recommend_key | REQUIRED
>
> |
> | NULL | recommend_server | http://myth-recommendations.
> aws.af.cm/
> |
> | NULL | TelevisionGrabber | metadata/Television/ttvdb.py
>
> |
> | mypvr | AllowLinkLocal | 1
>
> |
> | mypvr | AllowTagWriting | 1
>
> |
> | mypvr | DailyArtworkUpdates | 0
>
> |
> | mypvr | EventCmdLivetvStarted | /usr/local/bin/mythsgu event
> LivetvStarted
> |
> | mypvr | EventCmdMasterShutdown | /usr/local/bin/mythsgu event
> MasterShutdown
> |
> | mypvr | EventCmdMasterStarted | /usr/local/bin/mythsgu event
> MasterStarted
> |
> | mypvr | EventCmdPlayPaused | /usr/local/bin/mythsgu event
> PlayPaused
> |
> | mypvr | EventCmdPlayStarted | /usr/local/bin/mythsgu event
> PlayStarted
> |
> | mypvr | EventCmdPlayStopped | /usr/local/bin/mythsgu event
> PlayStopped
> |
> | mypvr | EventCmdPlayUnpaused | /usr/local/bin/mythsgu event
> PlayUnpaused
> |
> | mypvr | EventCmdRecDeleted | /usr/local/bin/event_test.sh
> %HOSTNAME% %CHANID% %DIR% %FILE% %PROGSTARTISOUTC% %PROGENDISOUTC%
> %STARTTIMEISOUTC% %ENDTIMEISOUTC% %RECGROUP% %TITLE% |
> | mypvr | EventCmdRecExpired | /usr/local/bin/mythsgu event
> RecExpired %FILE%
> |
> | mypvr | EventCmdRecFinished | /usr/local/bin/mythsgu event
> RecFinished
> |
> | mypvr | EventCmdRecPending | /usr/local/bin/mythsgu event
> RecPending
> |
> | mypvr | EventCmdRecStarted | /usr/local/bin/mythsgu event
> RecStarted
> |
> | mypvr | EventCmdSchedulerRan | /usr/local/bin/mythsgu event
> SchedulerRan
> |
> | mypvr | GalleryDirCaption | 1
>
> |
> | mypvr | GalleryImageCaption | 1
>
> |
> | mypvr | JobAllowMetadata | 1
>
> |
> | mypvr | MusicJumpPointAction | stop
>
> |
> | mypvr | MusicScannerLastRunEnd | 2016-07-24T14:24:01Z
>
> |
> | mypvr | MusicScannerLastRunStart | 2016-07-24T14:24:01Z
>
> |
> | mypvr | MusicScannerLastRunStatus | success - total tracks found:
> 118 (unchanged: 108, added: 10, removed: 0, updated 0) - total coverart
> found: 9 (unchanged: 1, added: 8, removed: 0, updated 0) |
> | mypvr | mythgame.MetadataGrabber |
>
> |
> | mypvr | mythvideo.folder_view_1 | 0
>
> |
> | mypvr | mythvideoDefaultBrowse | -1
>
> |
> | mypvr | mythvideoDefaultCast | -1
>
> |
> | mypvr | mythvideoDefaultCategory | -1
>
> |
> | mypvr | mythvideoDefaultCountry | -1
>
> |
> | mypvr | mythvideoDefaultCoverFile | -1
>
> |
> | mypvr | mythvideoDefaultFilter | ty9 -
>
> |
> | mypvr | mythvideoDefaultGenre | -1
>
> |
> | mypvr | mythvideoDefaultInetRef | -1
>
> |
> | mypvr | mythvideoDefaultOrderby | 0
>
> |
> | mypvr | mythvideoDefaultRuntime | -2
>
> |
> | mypvr | mythvideoDefaultUserrating | -1
>
> |
> | mypvr | mythvideoDefaultWatched | -1
>
> |
> | mypvr | mythvideoDefaultYear | -1
>
> |
> | mypvr | ResumeModeEditor | 0
>
> |
> | mypvr | ResumeModePlayback | 3
>
> |
> | mypvr | ResumeModeRadio | 2
>
> |
> +----------+----------------------------+-------------------
> ------------------------------------------------------------
> ------------------------------------------------------------
> ---------------------+
> 50 rows in set (0.04 sec)
>
I was thinking of something conceptually simpler, like doing a select on
each settings table, dumping the results to a text file and then diff'ing
the two files (an ORDER BY clause could help there). Since your statement
is doing a union, it doesn't show the differences (if any).
Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20161116/1633331a/attachment.html>
More information about the mythtv-users
mailing list