Search found 1724 matches

by bill6502
Fri Aug 28, 2020 8:27 pm
Forum: Troubleshooting
Topic: [Solved] mythtv-database (v.31) apt upgrade error
Replies: 12
Views: 231
United States of America

Re: mythtv-database (v.31) apt upgrade error

On my 20.04 host running MySQL v8, Trigger_priv: Y, Create_tablespace_priv: Y.

And on my 20.04 host running MariaDB 10.3, debian-sys-maint doesn't exist in
the user's table. Someone (that would be me) changed the defaults file user to
root.
by bill6502
Fri Aug 28, 2020 6:22 pm
Forum: Troubleshooting
Topic: [Solved] mythtv-database (v.31) apt upgrade error
Replies: 12
Views: 231
United States of America

Re: mythtv-database (v.31) apt upgrade error

SELECT * FROM user WHERE User IN ('root', 'debian-sys-maint')\G
by bill6502
Fri Aug 28, 2020 5:42 pm
Forum: Troubleshooting
Topic: [Solved] mythtv-database (v.31) apt upgrade error
Replies: 12
Views: 231
United States of America

Re: mythtv-database (v.31) apt upgrade error

I did leave the --host=localhost line out of the test above. If that fails, need to look at /etc/hosts (perhaps). If not, I'd change this line in the file above, just adding the $: fail_database "mysql 'hidden SECURITY_INFO' --execute=$QUERY $database" to fail_database "mysql 'hidden $SECURITY_INFO'...
by bill6502
Fri Aug 28, 2020 5:24 pm
Forum: Troubleshooting
Topic: [Solved] mythtv-database (v.31) apt upgrade error
Replies: 12
Views: 231
United States of America

Re: mythtv-database (v.31) apt upgrade error

When running: sudo dpkg-reconfigure, are you prompted for anything?
by bill6502
Fri Aug 28, 2020 5:10 pm
Forum: Troubleshooting
Topic: [Solved] mythtv-database (v.31) apt upgrade error
Replies: 12
Views: 231
United States of America

Re: mythtv-database (v.31) apt upgrade error

Hi, The file in play here is: mythtv-database.postinst The SECURITY_INFO, hidden for obvious reasons, is either from the defaults file /etc/mysql/debian.cnf or entered manually via prompts. It's the SQL root user which is automatically generated and stored in the file in /etcmysql or (if that doesn'...
by bill6502
Thu Aug 27, 2020 7:55 pm
Forum: Troubleshooting
Topic: "Change Group Filter" suddenly unsorted?
Replies: 5
Views: 209
United States of America

Re: "Change Group Filter" suddenly unsorted?

What little I know: Mine Groups sort OK, but I only have 1 "CUSTOM" group. It's ------- Groups ------- (seven, not three dashes, at least in master). The query involved seems to be: SELECT recgroup,COUNT(title) FROM recorded WHERE deletepending = 0 AND watched <= 0x800 GROUP BY recgroup; (I could be...
by bill6502
Wed Aug 26, 2020 3:59 pm
Forum: Troubleshooting
Topic: [Solved] Can't access recordings on migrated new machine
Replies: 6
Views: 158
United States of America

Re: Can't access recordings on migrated new machine

I would start the backend with --loglevel debug and watch for messages at the beginning of the log (related to Storage Groups). Also, from your favorite browser: <yourBackend>:6544/Myth/GetStorageGroupDirs?GroupName=Default if Default is the Storage Group of interest. Expect contents similar to thes...
by bill6502
Mon Aug 24, 2020 5:33 pm
Forum: Troubleshooting
Topic: XMLTV grabber for Schedules Direct JSON
Replies: 39
Views: 2399
United States of America

Re: XMLTV grabber for Schedules Direct JSON

"settings" is an actual table name in the mythconverg DB. I'm not sure if that's what you're referring to above. When the package is removed, the DB isn't, so everything, not just the settings table remains. My experience has been that removing/reinstalling doesn't always solve issues. While it can ...
by bill6502
Sat Aug 22, 2020 3:09 am
Forum: Troubleshooting
Topic: XMLTV grabber for Schedules Direct JSON
Replies: 39
Views: 2399
United States of America

Re: XMLTV grabber for Schedules Direct JSON

You can, but, honestly I don't see why it isn't happening automatically Here's the packaging script that I would expect to add the user (if it doesn't exist.) https://github.com/MythTV/packaging/blob/master/deb/debian/mythtv-common.postinst#L8 I think I'm seriously missing something. But won't have ...
by bill6502
Thu Aug 20, 2020 6:14 pm
Forum: Troubleshooting
Topic: XMLTV grabber for Schedules Direct JSON
Replies: 39
Views: 2399
United States of America

Re: XMLTV grabber for Schedules Direct JSON

In addition to the above location of ScheulesDirect.DB, you have the
<source name>.xmltv file(s) under ~mythtv/.mythtv too right?

Need to look at the mythfilldatabase.log. Should be in /var/log/mythtv.

If it doesn't offer any clues, pastebin it or attach it here.
by bill6502
Thu Aug 20, 2020 5:51 pm
Forum: Troubleshooting
Topic: XMLTV grabber for Schedules Direct JSON
Replies: 39
Views: 2399
United States of America

Re: XMLTV grabber for Schedules Direct JSON

The login user's .mythtv directory wasn't supposed to be empty, the
<source>.xmltv isn't supposed to be there. The "normal" things, like
config.xml and all other directories would still be there. My example
above is misleading and I fixed it.
by bill6502
Thu Aug 20, 2020 5:17 am
Forum: Troubleshooting
Topic: Problem recording most channels in program guide
Replies: 5
Views: 179
United States of America

Re: Problem recording most channels in program guide

Did the recordings actually fail, or were the ones selected already being broadcast
with a complete episode available in the future?

Or, was it only the 'Record One Showing (this episode)' that didn't appear to work
while other choices were OK?
by bill6502
Wed Aug 19, 2020 3:42 pm
Forum: Troubleshooting
Topic: XMLTV grabber for Schedules Direct JSON
Replies: 39
Views: 2399
United States of America

Re: XMLTV grabber for Schedules Direct JSON

When there is a SchedulesDirect.DB file in home/jim/.xmltv, it means the setup was run as that user, not as the the user that runs the backend which is typically user mythtv. That means the command line runs will work, but the backend runs will fail. Suggest the directories/files should look like th...
by bill6502
Sun Aug 16, 2020 11:40 pm
Forum: Troubleshooting
Topic: XMLTV grabber for Schedules Direct JSON
Replies: 39
Views: 2399
United States of America

Re: XMLTV grabber for Schedules Direct JSON

To answer the above, you really need to know which grabber you've selected. You can use mythtv-setup or from a browser, go to <yourBackendHostNameOrIP>:6544/Channel/GetVideoSourceList If tv_grab_zz_sdjson_sqlite was selected, then after running the four configuration commands in the Wiki, and assumi...
by bill6502
Sun Aug 16, 2020 4:29 pm
Forum: General Discussion
Topic: How to change time into recording that preview is taken from?
Replies: 4
Views: 748
United States of America

Re: How to change time into recording that preview is taken from?

I don't see a way to change it, but you can generate a new preview like this: mythpreviewgen --seconds 1 --chanid=1111 --starttime=20200621190000 Note, that if the preview has already been created (what you're trying to avoid) the cache on all frontends needs to be deleted too. For the example above...