johnridley (![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
johnridley) wrote2008-07-07 07:09 pm
johnridley) wrote2008-07-07 07:09 pm
Entry tags:
MythTV fix
We had a power flicker this afternoon and the Myth box came up grumpy.
As a note to myself, this time the problem was that MySQL didn't want to come up. the solution was to make copies of the DB files over in /var/lib/mysql/mysql/*, run mysqld, note which files it was griping about being corrupt, deleting them, running /usr/bin/mysql_create_db, repeat until the DB comes up clean.
Then start mysqld as root and do "grant all on mythconverg.* to 'mythtv'@'localhost' identified by 'mythtv';
et voila.
Oh, this was just after the frog strangler of a rain that we had, in which another guy and I were getting completely soaked to the skin (well beyond that; jumping in a lake would have made no difference), putting tarps and plywood up to keep the rain out of the window wells at the church building (gutter still not installed). Too late, we had water on the floors. So after fixing Myth and getting a bite of dinner, I went back and ran the carpet cleaner to suck up water for an hour.
As a note to myself, this time the problem was that MySQL didn't want to come up. the solution was to make copies of the DB files over in /var/lib/mysql/mysql/*, run mysqld, note which files it was griping about being corrupt, deleting them, running /usr/bin/mysql_create_db, repeat until the DB comes up clean.
Then start mysqld as root and do "grant all on mythconverg.* to 'mythtv'@'localhost' identified by 'mythtv';
et voila.
Oh, this was just after the frog strangler of a rain that we had, in which another guy and I were getting completely soaked to the skin (well beyond that; jumping in a lake would have made no difference), putting tarps and plywood up to keep the rain out of the window wells at the church building (gutter still not installed). Too late, we had water on the floors. So after fixing Myth and getting a bite of dinner, I went back and ran the carpet cleaner to suck up water for an hour.
no subject
Problem is, I find UPSs to be real power hogs and the batteries do not last that long (as in calendar life).
How about one of these for Myth TV:
http://www.mini-itx.com/
In particular, the new Intel offering is cheap:
http://www.mini-itx.com/store/?c=47
Since the majority of mini-itx boxes just require a 12V external brick for power, you could then float a 12V SLA across the supply and say goodbye to power glitches.
I'm thinking of one of these for a 4 camera security/monitoring system.
no subject
RGB Dsub on my TV sucks rocks. Probably my TV's fault but there it is anyway.