[mythtv-users] mythbackend not responding on port 6543
Hika van den Hoven
hikavdh at gmail.com
Thu Nov 17 16:47:36 UTC 2016
Hoi Stephen,
Thursday, November 17, 2016, 4:39:43 PM, you wrote:
> On Thu, 17 Nov 2016 06:24:11 -0800, you wrote:
>>On Wed, Nov 16, 2016 at 10:11 PM, Stephen Worthington <
>>stephen_agent at jsw.gen.nz> wrote:
>>
>>> On Wed, 16 Nov 2016 20:55:35 -0800, you wrote:
>>>
>>> >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;
>>> [snip]
>>> >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
>>>
>>> Yes, it does show the differences. It is using a sneaky sql trick
>>> from this page:
>>>
>>>
>>> http://www.mysqltutorial.org/compare-two-tables-to-find-
>>> unmatched-records-mysql.aspx
>>>
>>> Trying to do a text diff of tables is quite difficult, due to the
>>> variable length of fields and the way the output table is formatted to
>>> accommodate only the longest actual length of a field. You have to do
>>> fixed length formatting on all fields to have a chance for a text diff
>>> to work.
>>>
>>
>>Ah, I forgot about variable column widths. The "union all" confused me. Is
>>there any way to identify which row goes with which table? I wonder if you
>>could add a constant to the select string such as:
>>select hostname,value,data from (select "s1",s.hostname,s.value,s.data from
>>settings s union all select "s2, 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;
>>
>>Karl
> You read my mind - I was just trying exactly that when your email
> arrived. Unfortunately, it does not work:
> MariaDB [mythconverg]> select hostname,value,data from (select
> 'settings',s.hostname,s.value,s.data from settings s union all select
> 'settings_old',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 need to read up on how unions work and see if there a way to make it
> work.
> _______________________________________________
Maybe you could put a listener on the network. The CIFS issue suggests
its network related?
Tot mails,
Hika mailto:hikavdh at gmail.com
"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"
De lerende Mens
More information about the mythtv-users
mailing list