Archive for the ‘Uncategorized’ Category

Howto to allow remote mythtv frontends connect to backend?

June 10, 2010

This is asked about gazillion times in the web… But very infrequent good answers/resolutions.. So here we go…

On the machine you’re running mysql (typically the same machine as your MythTV master backend server), you need to allow mysql connections from other hosts on your network.

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

Bug Shooting: Best screen capture utility for Windows

January 16, 2009

I think this is it. Best screen capture utility for Windows. I have tried many. ZScreen was my choice before until I discovered Bug Shooting.

Bug Shooting really stands out from the rest of the crowd.

How to fix a corrupted mythtv channel lineup

December 30, 2008

For some reason mythtv (mythweb) channel line up gets corrupted: same programs appear on multiple channels and channel ids are not correct.
Fix is pretty simple. As root run:

mythfilldatabase --do-channel-updates

See also mythfilldatabase in mythtv wiki.

Mythtv 0.20 to 0.21 upgrade problem solution

November 14, 2008

Mythtv 0.20 to 0.21 solution

While ago I was bit struggling with myth 0.20 on FC6 to 0.21 on Ubuntu 8.04 upgrade.

I posted this on mythtv users list

I finally figured this out.

This mythtv user post gave me a hint:

So…

mythv@hippo:~/mytti$ sudo apt-get remove --purge mythtv-database mysql-server-5.0
[sudo] password for mythtv:
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
libmpich1.0gf mytharchive-data libxml-perl python-mysqldb libgfortran2 fftw2
libcarp-clan-perl libxml-xql-perl libparse-yapp-perl libxml-dom-perl
libid3-3.8.3-dev python-xml libswscale1d ffmpeg zlib1g-dev libcdaudio1
libxml-simple-perl libimage-size-perl libxml-regexp-perl atomicparsley
libmyth-python perlmagick libid3-3.8.3c2a
Use 'apt-get autoremove' to remove them.
The following packages will be REMOVED:
mysql-server-5.0* mythtv-database*
0 upgraded, 0 newly installed, 2 to remove and 0 not upgraded.
After this operation, 86.4MB disk space will be freed.
Do you want to continue [Y/n]?
(Reading database ... 168473 files and directories currently installed.)
Removing mysql-server-5.0 ...
* Stopping MySQL database server mysqld [ OK ]
Purging configuration files for mysql-server-5.0 ...
Removing mythtv-database ...
Purging configuration files for mythtv-database ...
mythtv@hippo:~/mytti$ sudo apt-get install mysql-server-5.0 mythtv-database mythtv-common mythtv-backend
Reading package lists... Done
Building dependency tree
Reading state information... Done
mythtv-common is already the newest version.
mythtv-common set to manually installed.
mythtv-backend is already the newest version.
The following packages were automatically installed and are no longer required:
libmpich1.0gf mytharchive-data libxml-perl python-mysqldb libgfortran2 fftw2
libcarp-clan-perl libxml-xql-perl libparse-yapp-perl libxml-dom-perl
libid3-3.8.3-dev python-xml libswscale1d ffmpeg zlib1g-dev libcdaudio1
libxml-simple-perl libimage-size-perl libxml-regexp-perl atomicparsley
libmyth-python perlmagick libid3-3.8.3c2a
Use 'apt-get autoremove' to remove them.
Suggested packages:
mysql-doc-5.0 tinyca
Recommended packages:
libhtml-template-perl mailx
The following NEW packages will be installed:
mysql-server-5.0 mythtv-database
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B/27.5MB of archives.
After this operation, 86.4MB of additional disk space will be used.
Preconfiguring packages ...
Selecting previously deselected package mysql-server-5.0.
(Reading database ... 166523 files and directories currently installed.)
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-3ubuntu5.1_i386.deb) ...
Selecting previously deselected package mythtv-database.
Unpacking mythtv-database (from .../mythtv-database_0.21.0+fixes16838-0ubuntu3.1_all.deb) ...
Setting up mysql-server-5.0 (5.0.51a-3ubuntu5.1) ...
* Stopping MySQL database server mysqld [ OK ]
Reloading AppArmor profiles : done.
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.

Setting up mythtv-database (0.21.0+fixes16838-0ubuntu3.1) ...
* Starting MySQL database server mysqld [ OK ]
Failed to connect to database: Access denied for user 'root'@'localhost' (using password: NO) at -e line 5, line 1.
Failed to create database (incorrect admin username/password?)
It's also possible that mysql-server wasn't running. After install
is completed, you will need to make sure mysql-server is running
and that you supplied correct information. Try:
sudo dpkg-reconfigure mythtv-database

mythtv@hippo:~/mytti$ sudo dpkg-reconfigure mythtv-common

mythtv@hippo:~/mytti$ sudo apt-get install mysql-server-5.0 mythtv-database mythtv-common mythtv-backend

mythtv@hippo:~/mytti$ sudo dpkg-reconfigure mythtv-database
* Starting MySQL database server mysqld [ OK ]

mythtv@hippo:~/mytti$ mysql -u mythtv -pmythtv mythconverg < restore.sql

mythtv@hippo:~/mytti$

mythtv@hippo:~/mytti$ ls -ls restore.sql mythtv_backup.sql
132896 -rw-r--r-- 1 mythtv mythtv 135943023 2008-10-12 13:04 mythtv_backup.sql
107752 -rw-r--r-- 1 mythtv mythtv 110220860 2008-10-12 15:43 restore.sql

MB to MiB and GB to GiB conversions

November 7, 2008

MiB and MB

1024 x 1024 = 1,048,576 bytes

1000 x 1000 = 1,000,000 bytes

To convert from MiB to MB, multiply by 1,048,576 / 1,000,000 = 1.048576

To convert from MB to MiB, divide by 1.048576.

Example:

500MB = 476.6 MiB

GiB and GB

1024 x 1024 x 1024 = 1,073,741,824 bytes

1000 x 1000 x 1000 = 1,000,000,000 bytes

To convert from GiB to GB, multiply by 1,073,741,824 / 1,000,000,000 = 1.073741824

To convert from GB to GiB, divide by 1.073741824.

Examples:

500 GB = 465.66 GiB

750 GB = 698.5 GiB

Simple conversion calculator:
http://www.cactus2000.de/uk/unit/massbyt.shtml