Difference between revisions of "User:AndrewAllison"
From MythTV Official Wiki
| Line 445: | Line 445: | ||
Crontab | Crontab | ||
| − | + | ||
| − | + | ||
| − | + | MAILTO="andrew.allison@gmail.com" | |
| − | + | #min hour day month Sun=0 Sat=6 | |
| − | + | 1 3 * * * /home/mythtv/backup-mysql.sh | |
| + | 1 4 1 * * /home/mythtv/optimize-myth-db.sh | ||
| + | 1 1 16 * * /storage2/mirror-canvec.sh | ||
| + | |||
/etc/rc.local | /etc/rc.local | ||
Revision as of 15:37, 5 November 2013
Hardware
Asus M4A77TD motherboard AMD Phenom II X4 965 Processor nVidia Corporation NV44 [GeForce 6200 TurboCache Hauppaupe HVR-950 Hauppauge 150 Hauppauge 500 Pinnacle Systems, Inc. Remote Kit Infrared Transceiver
Standard Files
Because these files are spread out everywhere, I usually get a mismatched set :-(
/etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 key_buffer = 16M table_cache = 128 sort_buffer_size = 2M myisam_sort_buffer_size = 8M query_cache_size = 16M [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
/etc/lirc/lircd.conf # # # contributed by Andrew Allison # # brand: PCTV (Hauppauge) USB MCE Remote # model no. of remote control: RRS9002-8601FC # devices being controlled by this remote: Pinnacle IR Receiver / Blaster #
begin remote
name pctv.usb.remote
bits 13
flags RC6|CONST_LENGTH
eps 30
aeps 100
header 2694 840
one 471 413
zero 471 413
pre_data_bits 24
pre_data 0x1BFF83
gap 105342
min_repeat 2
# suppress_repeat 2
# uncomment to suppress unwanted repeats
toggle_bit_mask 0x8000
rc6_mask 0x100000000
begin codes
KEY_POWER 0x13
KEY_PAUSE 0x037FF07BE7
KEY_RECORD 0x037FF07BE8
KEY_STOP 0x037FF07BE6
KEY_REWIND 0x037FF07BEA
KEY_PLAY 0x037FF07BE9
KEY_FORWARD 0x037FF07BEB
KEY_FRAMEBACK 0x037FF07BE4
KEY_FRAMEFORWARD 0x037FF07BE5
KEY_BACK 0x1BDC
KEY_INFO 0x1BF0
KEY_LEFT 0x1BDF
KEY_RIGHT 0x1BDE
KEY_OK 0x037FF07BDD
KEY_UP 0x1BE1
KEY_DOWN 0x1BE0
KEY_VOLUMEUP 0x037FF07BEF
KEY_VOLUMEDOWN 0x037FF07BEE
KEY_RESSTART 0x1BF2
KEY_CHANNELDOWN 0x037FF07BEC
KEY_CHANNELUP 0x037FF07BED
KEY_MUTE 0x1BF1
KEY_SWITCHVIDEOMODE 0x1BB7
KEY_EPG 0x1BD9
KEY_TV 0x1BDA
KEY_VIDEO 0x1BDB
KEY_1 0x1BFE
KEY_2 0x1BFD
KEY_3 0x1BFC
KEY_4 0x1BFB
KEY_5 0x1BFA
KEY_6 0x1BF9
KEY_7 0x1BF8
KEY_8 0x1BF7
KEY_9 0x1BF6
KEY_0 0x1BFF
KEY_CLEAR 0x037FF07BF5
KEY_ENTER 0x037FF07BF4
KEY_RED 0x037FF07BA4
KEY_GREEN 0x037FF07BA3
KEY_YELLOW 0x037FF07BA2
KEY_BLUE 0x037FF07BA1
KEY_NUMERIC_STAR 0x037FF07BE2
KEY_NUMERIC_POUND 0x037FF07BE3
KEY_SUBTITLE 0x037FF07BA5
end codes
end remote
/home/mythtv/.lircrc
# lircrc config file for the Microsoft Media Center Edition Remote, model 1039 # # @url $URL$ # @date $Date: 2008-03-08 23:30:22 -0500 (Sat, 08 Mar 2008) $ # @version $Revision: 16474 $ # @author $Author: kormoc $ # # This file is intended to complement the lircd.conf.mceusb file included with # lirc 0.8 and above. # # Save this file in ~/.mythtv/lircrc # # You will also need to make a few changes to the MythTV key bindings and jump # points as follows. # # Jump Points: # # TV Recording Playback: Alt+R # Program Guide: Alt+G # Live TV: Alt+P # MythVideo -> The MythVideo default view: Alt+V # Main Menu: Alt+Home # # Key Bindings: # # TV Playback -> CHANNELDOWN: Down,PgDown # TV Playback -> CHANNELUP: Up,PgUp # TV Playback -> JUMPRWND: Shift+PgUp # TV Playback -> JUMPFFWD: Shift+PgDown #
#
# Program Navigation
#
#
begin
prog = mythtv
button = Home
config = Alt+Home
repeat = 2
end
begin
prog = mythtv
button = RecTV
config = Alt+R
repeat = 2
end
begin
prog = mythtv
button = KEY_EPG
config = Alt+G
repeat = 2
end
begin
prog = mythtv
button = KEY_TV
config = Alt+P
repeat = 2
end
begin
prog = mythtv
button = KEY_VIDEO
config = Alt+V
repeat = 2
end
#
# Menu Navigation
#
begin
prog = mythtv
button = KEY_BACK
config = Esc
repeat = 2
end
begin
prog = mythtv
button = KEY_OK
config = Space
repeat = 2
end
begin
prog = mythtv
button = More
config = I
repeat = 2
end
begin
prog = mythtv
button = KEY_LEFT
config = Left
repeat = 2
end
begin
prog = mythtv
button = KEY_RIGHT
config = Right
repeat = 2
end
begin
prog = mythtv
button = KEY_UP
config = Up
repeat = 2
end
begin
prog = mythtv
button = KEY_DOWN
config = Down
repeat = 2
end
# TV Control
#
begin
prog = mythtv
button = KEY_VOLUMEDOWN
config = F10
repeat = 2
end
begin
prog = mythtv
button = KEY_VOLUMEUP
config = F11
repeat = 2
end
begin
prog = mythtv
button = KEY_MUTE
config = F9
repeat = 2
end
begin
prog = mythtv
button = KEY_CHANNELDOWN
config = PgDown
repeat = 2
end
begin
prog = mythtv
button = KEY_CHANNELUP
config = PgUp
repeat = 2
end
#
# Video Navigation
#
begin
prog = mythtv
button = KEY_PLAY
config = P
repeat = 2
end
begin
prog = mythtv
button = KEY_PAUSE
config = P
repeat = 2
end
begin
prog = mythtv
button = KEY_STOP
config = Esc
repeat = 2
end
begin
prog = mythtv
button = KEY_FORWARD
config = >
repeat = 2
end
begin
prog = mythtv
button = KEY_REWIND
config = <
repeat = 2
end
begin
prog = mythtv
button = KEY_FRAMEBACK
config = Q
repeat = 2
end
begin
prog = mythtv
button = KEY_FRAMEFORWARD
config = Z
repeat = 2
end
begin
prog = mythtv
button = KEY_RECORD
config = R
repeat = 2
end
#
#
# Miscellaneous
#
#
# M for Menu
begin
prog = mythtv
button = KEY_INFO
config = M
repeat = 2
end
begin
prog = mythtv
button = Hash
config = M
repeat = 2
end
begin
prog = mythtv
button = KEY_CLEAR
config = Esc
repeat = 2
end
#begin
# prog = mythtv
# button = Enter
# config = Space
#end
#
# Numbers
#
begin
prog = mythtv
button = KEY_0
config = 0
repeat = 2
end
begin
prog = mythtv
button = KEY_1
config = 1
repeat = 2
end
begin
prog = mythtv
button = KEY_2
config = 2
repeat = 2
end
begin
prog = mythtv
button = KEY_3
config = 3
repeat = 2
end
begin
prog = mythtv
button = KEY_4
config = 4
repeat = 2
end
begin
prog = mythtv
button = KEY_5
config = 5
repeat = 2
end
begin
prog = mythtv
button = KEY_6
config = 6
repeat = 2
end
begin
prog = mythtv
button = KEY_7
config = 7
repeat = 2
end
begin
prog = mythtv
button = KEY_8
config = 8
repeat = 2
end
begin
prog = mythtv
button = KEY_9
config = 9
repeat = 2
end
begin
remote = pctv.usb.remote
prog = irexec
button = KEY_BLUE
config = /home/mythtv/start_myth.sh &
repeat = 0
delay = 0
end
My Backup script
date= date -I nice -n 19 mysqldump -u --password= --extended-insert --no-create-db --add-drop-table --database mythconverg > `date -I`_myth_backup_data.sql nice -n 19 mysqldump -u --password= --extended-insert --database mythconverg > `date -I`_myth_complete_backup_data.sql nice -n 19 gzip `date -I`_myth_backup_data.sql nice -n 19 gzip `date -I`_myth_complete_backup_data.sql chmod 777 `date -I`_myth_backup_data.sql.gz chmod 777 `date -I`_myth_complete_backup_data.sql.gz mv `date -I`_myth_backup_data.sql.gz /storage1/Database/ mv `date -I`_myth_complete_backup_data.sql.gz /storage1/Database/
My Restore
mysql -u root -p < myth_complete_backup_data.sql
Setting Atrpms.repo
[atrpms] name=Fedora Core $releasever - $basearch - ATrpms baseurl=http://dl.atrpms.net/f$releasever-$basearch/atrpms/stable gpgkey=http://ATrpms.net/RPM-GPG-KEY.atrpms enabled=1 gpgcheck=1
Setting up Autologin
/etc/gdm/custom # GDM configuration storage [daemon] TimedLoginEnable=true TimedLogin=mythtv TimedLoginDelay=5 [security] [xdmcp] [greeter] [chooser] [debug]
Crontab
MAILTO="andrew.allison@gmail.com" #min hour day month Sun=0 Sat=6 1 3 * * * /home/mythtv/backup-mysql.sh 1 4 1 * * /home/mythtv/optimize-myth-db.sh 1 1 16 * * /storage2/mirror-canvec.sh
/etc/rc.local
#!/bin/sh mount /dev/sdc1 /storage1 mount /dev/sdd1 /storage2 mount /dev/sdb1 /storage3 modprobe -r ir_rc6_decoder modprobe -r rc_rc6_mce modprobe -r ir_rc5_decoder echo lirc > /sys/class/rc/rc0/protocols #command v4l2-ctl -d /dev/video3 --list-ctrl v4l2-ctl -d /dev/video3 --set-ctrl volume=24 /bin/mythbackend --daemon --loglevel info /bin/mythjobqueue --daemon --loglevel info
Mythtv->Setup-General
LIRC daemon socket /var/run/lirc/lircd
Notes on Fedora 15 Install
Using the default nouveau video driver GeForce 6200 SVideo
Add boot option to grub.conf nouveau.tv_norm=NTSC-M
kernel /vmlinuz-2.6.40.6-0.fc15.x86_64 ro root=UUID=4b78f456-a78b-4f2b-b4b6-392bd5a2b215 rd_NO_LUKS rd_NO_LVM rd_NO_MD rd_NO_DM LANG=en_US.UTF-8 SYSFONT=latarcyrheb-sun16 KEYTABLE=us nouveau.tv_norm=NTSC-M quiet initrd /initramfs-2.6.40.6-0.fc15.x86_64.img
Installing MS Core Fonts
yum install rpm-build cabextract ttmkfdir wget wget http://corefonts.sourceforge.net/msttcorefonts-2.0-1.spec rpmbuild -ba msttcorefonts-2.0-1.spec yum install --nogpgcheck /root/rpmbuild/RPMS/noarch/msttcorefonts-2.0-1.noarch.rpm
Useful Links
http://blog.grantgoodyear.org/2010_05_01_archive.html
Notes
Crash in MythNews 2012-01-01 10:26:35.859302 I MythUIWebBrowser: Loading css from - file:///usr/local/share/mythtv/themes/default/htmls/mythbrowser.css 2012-01-01 10:26:35.866052 I MythUIWebBrowser: enabling plugins ** (process:7422): DEBUG: NP_Initialize ** (process:7422): DEBUG: NP_Initialize succeeded ** (process:7422): DEBUG: NP_Initialize ** (process:7422): DEBUG: NP_Initialize succeeded /builddir/build/BUILD/icedtea-web-1.0.6/plugin/icedteanp/IcedTeaNPPlugin.cc:2016: thread 0x2793a60: Error: Invalid plugin function table. ** (<unknown>:7422): DEBUG: NP_Initialize ** (<unknown>:7422): DEBUG: NP_Initialize succeeded ** (<unknown>:7422): DEBUG: NP_Initialize ** (<unknown>:7422): DEBUG: NP_Initialize succeeded
Solution Remove all files in .mythtv/MythNews
SQL Profiling script
Please remember to put the password for your admin user at the point marked XXX.
The script waits for the SQL load to get over 75% then starts to dump
a file called sqlload'timestamp' to your Desktop, it stops when the
load falls back below 75%.
If a few users could run it for testing it would be useful, it ONLY
starts to dump when load is > 75%
#!/bin/sh
FILENOW=`date +%a"."%b%d"."%H":"%M":"%S`
COUNT="0"
cd ~/Desktop
LOADOUTPUT="sqlload@""$FILENOW"
touch "$LOADOUTPUT"
SQLLOAD="0"
while [ "$SQLLOAD" -le 75 ] ; do
SQLLOAD=`top -b -n 1 | grep mysqld | awk -F " " '{ print $9 }'`
done;
while [ "$SQLLOAD" -ge 75 ]; do
mysql -uroot -pXXXADDYOURPASSWORDHEREXXX -e"SHOW full processlist;" >>
"$LOADOUTPUT"
NEWNOW=`date +%a"."%b%d"."%H":"%M":"%S`
echo -e "**************\n\n\n$NEWNOW\n\n\n Next Pass" >> "$LOADOUTPUT"
COUNT=`echo "$COUNT + 1" | bc`
echo "Count $COUNT sqlload $SQLLOAD"
sleep 1
SQLLOAD=`top -b -n 1 | grep mysqld | awk -F " " '{ print $9 }'`
done
echo "Glitch finished at $NEWNOW, end of Run" >> "$LOADOUTPUT"
_______________________________________________
UDEV
KERNEL=="video[0-9]", DRIVERS=="ivtv", ATTRS{subsystem_device}=="0x8801", SYMLINK+="PVR150-0"
KERNEL=="video[0-9]", DRIVERS=="ivtv", ATTRS{subsystem_device}=="0xe807", SYMLINK+="PVR150-1"
KERNEL=="video[0-9]", DRIVERS=="ivtv", ATTRS{subsystem_device}=="0xe817", SYMLINK+="PVR150-2"
DRIVERS=="em28xx", SYMLINK+="HVR950-0"
#KERNEL=="dvb0.frontend0", DRIVERS=="em28xx", SYMLINK+="HVR950-0"
#KERNEL=="video[0-9]", DRIVERS=="cx18", SYMLINK+="HVR1600-1"
#KERNEL=="video[0-9]*", DRIVERS=="cx18", ATTRS{subsystem_device}=="0x8389", SYMLINK+="HVR1600-1"
Fedora 16 Service Configuration
chkconfig --list
systemctl enable mysqld.service systemctl enable mythbackend.service systemctl enable mythjobqueue.service
ssmtp
Fedora 19 requires the TLS_CA_File option
root=email address MailHub=smtp.gmail.com:587 AuthUser=email address AuthPass=password UseSTARTTLS=YES UseTLS=YES FromLineOverride=YES TLS_CA_File=/etc/pki/tls/certs/ca-bundle.crt
