[mythtv-users] Frontend on firetvstick 4K - cannot connect to database

[John Pilkington]

On 26/11/18 16:30, Peter Bennett wrote:
> 
> 
> On 11/26/18 11:16 AM, John Pilkington wrote:
>> I don't seem to be getting anywhere with this.
>>
>> I have 2 FE/BE boxes running independently on the network, both with 
>> v30-Pre-afaf3cae3a2.  Both servers are detected by the stick in 
>> 'Search' mode, although then both display the same identifiers:
>>
>> MythTV AV Media Server 30.20181106-1
>> 91
>>
>> but scanning either says, eventually, Database failed to start
>>
>> Going to the Setup box on screen then shows one of the identifiers: 
>> I've tried hostnames and IP addresses, like 192:168:1:129, but none work.
>>
> You can only use ip addresses, the stick will not be able to find 
> servers by hostname.
>> I can access both DBs by 'mysql -umythtv -pmythtv - h localhost 
>> mythconverg', and the values shown by the stick agree.
>>
> 
> Did you remember to allow remote access to the database? for mysql 
> update mysqld.cnf and comment out bind-address = 127.0.0.1 and for 
> mariadb set bind-address = ::
> 
>> Media from both boxes can be played by uPnP.
>>
>> I'm not really clear about the difference between starting and 
>> accessing the DB.  Both have been running for most of the time. 
>> systemctl | grep maria shows mariadb.service loaded active running
>>
>> I've tried putting one of the MACs found by my router into the 'Write 
>> command or MAC' box, with no effect.  That MAC isn't the one quoted as 
>> an example(?), and the other suggested wakeup command invokes 
>> /etc/init.d/mysql, which I don't have.  systemctl start 
>> mariadb.service, perhaps?
>>
> That is only if you want to wake the database using wake on lan. Since 
> you have checked that your database is running that is not applicable.
>> The screen saver pictures are spectacular, though :-)


Peter:  Thank you. and sorry for asking a fairly FAQ. I guess the remote 
access setting will be the problem, but I need to consider its likely 
effects on my multiple systems.  I've probably been living dangerously.

>>
>> Cheers,
>>
>> John