Search found 55 matches

by Gribnif
Fri Oct 11, 2019 8:34 pm
Forum: General Discussion
Topic: Case sensitivity/insensitivity in MySQL queries?
Replies: 2
Views: 47
United States of America

Re: Case sensitivity/insensitivity in MySQL queries?

To expand on what bill6502 said, if you want a particular column to be searched in a case-insensitive way, change it to a case-insensitive collation. These end in "_ci", like "latin1_general_ci" and "utf8_general_ci".
by Gribnif
Tue Aug 13, 2019 4:13 pm
Forum: Hardware
Topic: Atom CPU Enough Power?
Replies: 8
Views: 463
United States of America

Re: Atom CPU Enough Power?

I ran my backend on an Atom-based motherboard for a while. It worked well for most things, however it was only SATA 2. Recording too many streams at once would cause timeouts. Even doing a "check" of my RAID array would be dramatically slow--not because of the CPU, but because of the relatively slow...
by Gribnif
Thu May 23, 2019 6:54 pm
Forum: Troubleshooting
Topic: Job queue is backed up
Replies: 8
Views: 282
United States of America

Re: Job queue is backed up

This happens to me every month or two, as well. Simply restarting the backend is enough to get it running again.
by Gribnif
Mon May 13, 2019 8:05 pm
Forum: General Discussion
Topic: Database Optimize/Backup Order
Replies: 3
Views: 191
United States of America

Re: Database Optimize/Backup Order

It's perfectly safe to do it in either order. About the only reason I can think of to optimize before backing up is to potentially make the backup a little smaller.
by Gribnif
Mon Apr 22, 2019 5:16 pm
Forum: Troubleshooting
Topic: HDHomeRun with mythtv .30
Replies: 11
Views: 466
United States of America

Re: HDHomeRun with mythtv .30

It's also worth noting that, if you compile your own copy of MythTV from source, you will need the "-devel" HDHomerun package, as well. Having just the library isn't enough for the configure script to enable this feature when compiling.
by Gribnif
Wed Feb 06, 2019 3:08 pm
Forum: General Discussion
Topic: SQL errors in Mythweb
Replies: 13
Views: 710
United States of America

Re: SQL errors in Mythweb

Hi Tony,

I don't normally use Ubuntu, but I looked in a list of files in the package you are likely using, and I think you'd want to add the line to:

Code: Select all

/etc/mysql/mysql.conf.d/mysqld.cnf
in the

Code: Select all

[mysqld]
section. Remove the edits you made previously.
by Gribnif
Mon Feb 04, 2019 3:59 pm
Forum: General Discussion
Topic: SQL errors in Mythweb
Replies: 13
Views: 710
United States of America

Re: SQL errors in Mythweb

Hello, This is due to a recent(ish) change in the MySQL defaults, which cause it to be more strict than it used to be. Short of fixing the SQL code in Mythweb, the easier thing to do is to add this line to /etc/my.cnf: sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_...
by Gribnif
Thu Jan 17, 2019 2:01 pm
Forum: Linux
Topic: 0.29 on Centos 6
Replies: 5
Views: 369
United States of America

Re: 0.29 on Centos 6

I have to ask: why not upgrade to CentOS 7? I use 7 on my backend and five of my frontends, and the upgrade from 6 wasn't too bad.
by Gribnif
Mon Nov 19, 2018 7:13 pm
Forum: Troubleshooting
Topic: Suggestion for a decent, currently-available remote/ir pair for Linux frontend
Replies: 7
Views: 456
United States of America

Re: Suggestion for a decent, currently-available remote/ir pair for Linux frontend

I have two Myth boxes which use this remote: https://www.mythtv.org/wiki/Air_mouse_rf_remote https://www.amazon.com/d/Remote-Controls/SODIAL-Portable-Wireless-Keyboard-Controller/B01A2SM1LK/ref=sr_1_13?ie=UTF8&qid=1542653658&sr=8-13&keywords=rf+remote+keyboard (This is just an example of one seller;...
by Gribnif
Thu Nov 01, 2018 3:09 pm
Forum: Troubleshooting
Topic: myhthfilldatabase stopped grabbing listings [solved]
Replies: 5
Views: 356
United States of America

Re: myhthfilldatabase stopped grabbing listings

I had a similar problem which seems to have been caused by an oddity in the way mfdb does DNS resolution. Does it work if you run mfdb, let it fail, and then immediately run it again? If so, you're hitting the same problem I had. I ended up substituting this wrapper script for a direct call to mfdb:...
by Gribnif
Thu Jul 05, 2018 2:17 pm
Forum: OSX
Topic: Builds
Replies: 22
Views: 2350
United States of America

Re: Builds

What is the current state of build scripts for version 29 on OS X? I found warpme's pre-compiled frontend, but I also need the backend. It doesn't look like macports includes 29 yet. I'm willing to compile it myself, but not to go through what I'm sure is dependency hell to get it to work. Has anybo...
by Gribnif
Fri May 18, 2018 6:04 pm
Forum: Troubleshooting
Topic: Watch TV not working
Replies: 22
Views: 1450
United States of America

Re: Watch TV not working

The best idea for diagnosing this sort of thing is the logs, primarily on the frontend, but potentially on the backend as well. The easiest way to start is to run the frontend from an xterm session with "-v playback" added to the commandline and see if anything useful appears there. If not, you may ...
by Gribnif
Thu Apr 26, 2018 1:19 pm
Forum: General Discussion
Topic: Last update solved a lot of issues
Replies: 1
Views: 313
United States of America

Re: Last update solved a lot of issues

Hard drives are definitely susceptible to data errors caused by vibration. So having your HTPC case right next to a speaker, especially a subwoofer, is probably not a good idea if you use spinning disks. Due to the heat and noise generated by their backend, many people put it in a closet or basement...
by Gribnif
Tue Jan 30, 2018 4:44 pm
Forum: Troubleshooting
Topic: Multiple IPTV Encoders
Replies: 4
Views: 781
United States of America

Re: Multiple IPTV Encoders

Hi Charles, I have been working on a modified version of mythfilerecorder that takes the output of an arbitrary shell command and pipes that back into the backend, rather than reading a static file. It also accepts a command to tune the required channel. It sounds like this might help for you, too. ...
by Gribnif
Mon Jan 22, 2018 2:44 pm
Forum: General Discussion
Topic: HD PVR 2 review / feedback
Replies: 7
Views: 1294
United States of America

Re: HD PVR 2 review / feedback

Hi Gribnif. I'm curious how you managed to get your device working. My code, such as it is, is pretty rough right now. I definitely intend to share what I've done with the world, but I'm still having a big problem that I haven't had time to figure out. I can record one program (or live TV channel) ...