MySQL Root-Passwort setzen

# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

Datenbankzugriff für Remote Frontends erlauben

$ mysql -u root -p mythconverg
mysql> grant all on mythconverg.* to mythtv@"192.168.0.%" identified by "mythtv";
mysql> flush privileges;
mysql> quit

Backup der Datenbank

$ mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql

Restore der Datenbank

$ mysql -u root -p
mysql>create database mythconverg;
mysql>exit
$ mysql -u mythtv -pmythtv mythconverg < mythtv_backup.sql

Hostname in der DB ändern

$ mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql
$ cat mythtv_backup.sql | sed s/\'frontend1\'/\'kidsroom\'/g >> mythtv_restore.sql
$ mysql -u root -p
mysql>drop database mythconverg;
mysql>create database mythconverg;
mysql>exit
$ mysql -u mythtv -pmythtv mythconverg < mythtv_restore.sql

Crystalfontz LC-Display 632 seriell

Testen

Testprogramm runterladen.

cd 632_634_linux
make
./test632_634 /dev/ttyS0 19200

LCDproc

LCDproc runterladen und compilieren/installieren:

cd lcdproc-0.52
./configure --enable-drivers=all
make
cd server
su
make install
cd /home/mythtv 
mkdir lcd
cp lcdproc-0.52/server/drivers/CFontz.so lcd/
cp lcdproc-0.52/LCDd.conf lcd/

LCDd.conf:

[server]
Driver=CFontz
DriverPath=/home/mythtv/lcd/

[CFontz]
Device=/dev/ttyS0
Size=16x2
Contrast=560
Brightness=500
OffBrightness=0
Speed=19200
NewFirmware=yes
Reboot=no

Starten des Demons (z.B. in /etc/rc.local):

/usr/local/sbin/LCDd -c /home/mythtv/lcd/LCDd.conf

Danach kann man in MythFrontend bei Konfiguration/Erscheinungsbild die LCD-Ansteuerung aktivieren.

Links