[mythtv-users] Database access problems

[John Pilkington]

On 21/09/2019 12:34, Stephen Worthington wrote:
> On Thu, 19 Sep 2019 20:49:35 +0100, you wrote:
> 
>> I have spent the past few days away from home with internet access via a
>> wifi hotspot that comes and goes unpredictably.  The laptop has kubuntu
>> 16.04 and MythTV master from the ppa, updated in July and last weekend.
>> It has a crossover local-link ethernet cable to the tv, and DLNA
>> playback had been working fine.   That needs a non-127.0.0.1 backend
>> address; the tv shows a manually entered DNS address of 169.254.51 .44
>> and the laptop 'details' shows 169.254.51.44
> 
> I am hoping the above is just a typo - you really do not ever want two
> devices with the same IP address on a network.  That could easily
> cause database access problems if you are accessing the database on
> the duplicated IP address.  The TV needs to have a different IP
> address from the laptop.

Thank you, Stephen.  No, it wasn't a typo, but the failure was new and 
as far as I know the setting hadn't been changed.  I'm back home now and 
should be able to experiment with other systems.  I see the TV has Auto 
and Manual DNS settings, and I hadn't recognised the presence of that as 
a switch.  I may try a normal cable, although the TV manual (Panasonic 
but 2012 models) say use crossover for the direct connection.  The TV's 
Connection Test failed the final step: 'Check server connection for 
VIERA connect', which the more conventional setup here passes.

I get more comprehensive listings of mysql grants here, but maybe I just 
had a broken DNS.

John
> 
> Maybe you should be running a DHCP server on the laptop, as link local
> IP addresses like the 169.254.0.0/16 ones above are problematical -
> getting them assigned properly does not always work.  If you run a
> DHCP server from the laptop, you would normally want the laptop to
> have a static IP address, or have a manually allocated DHCP address so
> that it does not change.
> 
> There is normally no need for crossover Ethernet cables these days. If
> both devices have gigabit Ethernet, they will automatically negotiate
> the Tx and Rx pin use.  If the TV only has 100 Mbit Ethernet, that
> also should be capable of negotiation unless it is truly ancient.