The mythfrontend wiki page tells me I need to make sure the MySQL server will accept connections from the remote frontend machine.
orange@frontend:~$ mysql -u mythtv -h tempbackend.domain ERROR 1130 (HY000): Host 'x.x.x.x' is not allowed to connect to this MySQL server $ ls /usr/local/share/mysql/*.cnf /usr/local/share/mysql/my-huge.cnf /usr/local/share/mysql/my-medium.cnf /usr/local/share/mysql/my-innodb-heavy-4G.cnf /usr/local/share/mysql/my-small.cnf /usr/local/share/mysql/my-large.cnf $ sudo cp /usr/local/share/mysql/my-large.cnf /usr/local/etc/my.cnf $ sudo vim /usr/local/etc/my.cnf
In my.cnf, I set bind-address to the tempbackend’s IP, to enable networking. I also need to allow access to the database. I could use ‘%’ for a wildcard instead of frontend’s IP but that seems a little heavy handed.
$ mysql -u mythtv -p mysql> grant all on mythconverg.* to 'mythtv'@'x.x.x.x' identified by 'mythtv'; mysql> flush privileges;
Running mythfrontend on the frontend machine (which automatically starts upon Xorg login due to ~/.config/autostart/mythtv.desktop) gave an error that it couldn’t work with the backend. It then indicated that it had found two backends running different versions of MythTV (0.25 and 0.27). I assumed that they referred respectively to master and tempbackend, so selected the 0.27 version. It worked, and I could play the single recording I had copied across to tempbackend.
Two issues to sort out before actual migration:
- Mythfrontend on frontend prompts to upgrade the schema of the Music database. Hopefully this won’t be a problem for upgrading the master, since it’s Mythbuntu and tempbackend is FreeBSD – slight package version differences?
- There is no functioning audio on the frontend.
I checked that audio worked at all with aplay:
$ aplay /usr/share/sounds/alsa/Front_Center.wav
This having worked, I delved into mythfrontend’s Setup -> Audio menu, and found a number of options for the Audio output device. I have successfully used three:
- ALSA:hw:CARD=PCH,DEV=0 is the 3.5mm headphone jack on the front of the NUC, and has further identification of “HDA Intel PCH, ALC283 Analog”
- ALSA:plughw:CARD=HDMI,DEV=3 and ALSA:hw:CARD=HDMI,DEV=3
The HDMI options also have text at the bottom of the setup window, which will lead me to more reading later:
HDA Intel HDMI, HDMI 0
Hardware device with all software conversions (SHARP HDMI connected to HDMI)
Device supports up to 2.0 (LPCM)