| Sunday, August 30th, 2020, 01:37 UTC | ||
| [01:37:33] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Quit: Konversation terminated!) | |
| [03:34:38] | Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7d83:6501:6032:9caa:16d4:6ffa) has joined #mythtv-users | |
| [03:34:38] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v Steve-Goodey | |
| [03:45:53] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv-users | |
| [04:39:30] | Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7d83:6501:6032:9caa:16d4:6ffa) has quit (Quit: Konversation terminated!) | |
| [05:30:00] | peterbennett (peterbennett!~pi@mythtv/developer/peterbennett) has quit (Quit: WeeChat 2.3) | |
| [05:31:50] | peterbennett (peterbennett!~pi@2601:183:100:6a:f1e0:d1e4:326b:fdd5) has joined #mythtv-users | |
| [05:31:50] | peterbennett (peterbennett!~pi@mythtv/developer/peterbennett) has joined #mythtv-users | |
| [05:31:50] | peterbennett (peterbennett!~pi@2601:183:100:6a:f1e0:d1e4:326b:fdd5) has quit (Changing host) | |
| [05:31:51] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v peterbennett | |
| [07:59:28] | Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7d83:6501:6032:9caa:16d4:6ffa) has joined #mythtv-users | |
| [07:59:28] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v Steve-Goodey | |
| [08:16:17] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Read error: Connection reset by peer) | |
| [08:16:45] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv-users | |
| [09:19:52] | clueminati (clueminati!~clueminat@gateway/tor-sasl/clueminati) has quit (Remote host closed the connection) | |
| [09:20:22] | clueminati (clueminati!~clueminat@gateway/tor-sasl/clueminati) has joined #mythtv-users | |
| [09:43:56] | pppingme (pppingme!~pppingme@unaffiliated/pppingme) has quit (Ping timeout: 240 seconds) | |
| [09:49:59] | pppingme (pppingme!~pppingme@unaffiliated/pppingme) has joined #mythtv-users | |
| [09:59:52] | Toast (Toast!~quassel@w-37.cust-u6165.ip.static.uno.uk.net) has joined #mythtv-users | |
| [10:06:56] | jpabq (jpabq!~quassel@mythtv/developer/jpabq) has quit (Ping timeout: 246 seconds) | |
| [10:07:53] | sutula (sutula!~sutula@184.97.13.190) has quit (Ping timeout: 265 seconds) | |
| [10:09:11] | mkbloke (mkbloke!~mkbloke@vps.cammo.me.uk) has quit (Remote host closed the connection) | |
| [10:11:27] | mkbloke (mkbloke!~mkbloke@vps.cammo.me.uk) has joined #mythtv-users | |
| [10:11:27] | gigem (gigem!~david@47.183.238.94) has joined #mythtv-users | |
| [10:11:27] | gigem (gigem!~david@mythtv/developer/gigem) has joined #mythtv-users | |
| [10:11:27] | gigem (gigem!~david@47.183.238.94) has quit (Changing host) | |
| [10:11:27] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v gigem | |
| [10:12:00] | afisher (afisher!sid188203@gateway/web/irccloud.com/x-zsjrhvzmlettvegn) has quit (Ping timeout: 244 seconds) | |
| [10:12:18] | pppingme (pppingme!~pppingme@unaffiliated/pppingme) has quit (Ping timeout: 256 seconds) | |
| [10:16:04] | markk__ (markk__!~mark@host86-161-98-168.range86-161.btcentralplus.com) has joined #mythtv-users | |
| [10:16:04] | pppingme (pppingme!~pppingme@unaffiliated/pppingme) has joined #mythtv-users | |
| [10:16:04] | MythLogBot (MythLogBot!~bot@mythtv/bot/MythLogBot) has quit (Ping timeout: 258 seconds) | |
| [10:16:21] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v MythLogBot | |
| [10:45:44] | afisher (afisher!sid188203@gateway/web/irccloud.com/x-rdpyspezuvjgmfts) has joined #mythtv-users | |
| [10:47:16] | sutula (sutula!~sutula@184.97.13.190) has joined #mythtv-users | |
| [10:51:43] | sutula (sutula!~sutula@184.97.13.190) has quit (Ping timeout: 258 seconds) | |
| [10:56:34] | sutula (sutula!~sutula@184.97.13.190) has joined #mythtv-users | |
| [10:58:17] | clueminati (clueminati!~clueminat@gateway/tor-sasl/clueminati) has quit (Quit: clueminati) | |
| [11:08:54] | clever_ (clever_!~clever@nwcsnbsc03w-47-54-162-0.dhcp-dynamic.fibreop.nb.bellaliant.net) has joined #mythtv-users | |
| [11:12:26] | clever (clever!~clever@NixOS/user/clever) has quit (Ping timeout: 256 seconds) | |
| [11:13:11] | clever_ (clever_!~clever@nwcsnbsc03w-47-54-162-0.dhcp-dynamic.fibreop.nb.bellaliant.net) has quit (Changing host) | |
| [11:13:12] | clever_ (clever_!~clever@NixOS/user/clever) has joined #mythtv-users | |
| [11:13:52] | clever_ is now known as clever | |
| [11:40:52] | afisher (afisher!sid188203@gateway/web/irccloud.com/x-rdpyspezuvjgmfts) has quit (Ping timeout: 244 seconds) | |
| [11:41:25] | p71 (p71!~chatzilla@097-083-185-160.res.spectrum.com) has quit (Ping timeout: 240 seconds) | |
| [11:41:45] | gigem (gigem!~david@mythtv/developer/gigem) has quit (Ping timeout: 240 seconds) | |
| [11:42:05] | sutula (sutula!~sutula@184.97.13.190) has quit (Ping timeout: 240 seconds) | |
| [11:44:25] | LedHed (LedHed!~ledhed@047-027-199-113.res.spectrum.com) has quit (Ping timeout: 240 seconds) | |
| [11:45:18] | SteveGoodey (SteveGoodey!~steve@host86-149-198-216.range86-149.btcentralplus.com) has joined #mythtv-users | |
| [11:45:18] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v SteveGoodey | |
| [11:45:32] | afisher (afisher!sid188203@gateway/web/irccloud.com/x-pgaggphpeuzztdly) has joined #mythtv-users | |
| [11:46:46] | LedHed (LedHed!~ledhed@047-027-199-113.res.spectrum.com) has joined #mythtv-users | |
| [11:54:18] | MythLogBot (MythLogBot!~bot@mythtv/bot/MythLogBot) has quit (Ping timeout: 256 seconds) | |
| [12:00:13] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v MythLogBot | |
| [12:00:27] | p71 (p71!~chatzilla@097-083-185-160.res.spectrum.com) has joined #mythtv-users | |
| [12:01:01] | clueminati (clueminati!~clueminat@gateway/tor-sasl/clueminati) has joined #mythtv-users | |
| [12:04:24] | clueminati (clueminati!~clueminat@gateway/tor-sasl/clueminati) has joined #mythtv-users | |
| [12:04:24] | clueminati (clueminati!~clueminat@gateway/tor-sasl/clueminati) has quit (Client Quit) | |
| [12:04:25] | MythLogBot (MythLogBot!~bot@mythtv/bot/MythLogBot) has quit (Ping timeout: 240 seconds) | |
| [12:14:53] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v MythLogBot | |
| [12:38:18] | afisher (afisher!sid188203@gateway/web/irccloud.com/x-pgaggphpeuzztdly) has quit (Read error: Connection reset by peer) | |
| [12:39:41] | sutula (sutula!~sutula@184.97.13.190) has joined #mythtv-users | |
| [12:39:52] | markk__ (markk__!~mark@host86-161-98-168.range86-161.btcentralplus.com) has quit (Ping timeout: 256 seconds) | |
| [12:40:48] | gigem (gigem!~david@mythtv/developer/gigem) has quit (Ping timeout: 244 seconds) | |
| [12:40:57] | afisher (afisher!sid188203@gateway/web/irccloud.com/x-ufacgdqqewznadrj) has joined #mythtv-users | |
| [12:56:40] | sutula (sutula!~sutula@184.97.13.190) has quit (Ping timeout: 246 seconds) | |
| [13:03:31] | sutula (sutula!~sutula@184.97.13.190) has joined #mythtv-users | |
| [13:14:55] | mkbloke (mkbloke!~mkbloke@vps.cammo.me.uk) has quit (Ping timeout: 240 seconds) | |
| [13:15:09] | mkbloke (mkbloke!~mkbloke@vps.cammo.me.uk) has joined #mythtv-users | |
| [13:16:52] | gigem (gigem!~david@mythtv/developer/gigem) has joined #mythtv-users | |
| [13:16:52] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v gigem | |
| [14:08:26] | afisher (afisher!sid188203@gateway/web/irccloud.com/x-ufacgdqqewznadrj) has quit (Ping timeout: 240 seconds) | |
| [14:10:23] | afisher (afisher!sid188203@gateway/web/irccloud.com/x-fwthcuzomyhegxff) has joined #mythtv-users | |
| [14:13:28] | xris (xris!~xris@mythtv/developer/xris) has quit (Remote host closed the connection) | |
| [14:17:47] | xris (xris!~xris@97.113.223.5) has joined #mythtv-users | |
| [14:17:47] | xris (xris!~xris@97.113.223.5) has quit (Changing host) | |
| [14:17:47] | xris (xris!~xris@mythtv/developer/xris) has joined #mythtv-users | |
| [14:17:47] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v xris | |
| [14:39:50] | clueminati (clueminati!~clueminat@gateway/tor-sasl/clueminati) has quit (Remote host closed the connection) | |
| [14:40:05] | sutula (sutula!~sutula@184.97.13.190) has quit (Ping timeout: 240 seconds) | |
| [14:40:59] | clueminati (clueminati!~clueminat@gateway/tor-sasl/clueminati) has joined #mythtv-users | |
| [14:41:23] | sutula (sutula!~sutula@184.97.13.190) has joined #mythtv-users | |
| [16:11:18] | cybrNaut: | this sucks https://www.mythtv.org/wiki?title=ROKU_HD_Fro . . . ;oldid=53408 |
| [17:24:52] | mack_ (mack_!~mack-@cpe-70-119-42-141.tx.res.rr.com) has joined #mythtv-users | |
| [17:25:16] | mack_ is now known as Guest25625 | |
| [17:28:25] | mack- (mack-!~mack-@cpe-70-119-42-141.tx.res.rr.com) has quit (Ping timeout: 264 seconds) | |
| [17:52:45] | Guest25625 (Guest25625!~mack-@cpe-70-119-42-141.tx.res.rr.com) has quit (Quit: Leaving) | |
| [17:53:15] | mack- (mack-!~mack-@cpe-70-119-42-141.tx.res.rr.com) has joined #mythtv-users | |
| [19:03:21] | markk__ (markk__!~mark@host86-161-98-168.range86-161.btcentralplus.com) has joined #mythtv-users | |
| [19:06:58] | gregl (gregl!~greg@cpe-24-194-253-7.nycap.res.rr.com) has quit (Quit: Leaving) | |
| [19:24:01] | gregl (gregl!~greg@cpe-24-194-253-7.nycap.res.rr.com) has joined #mythtv-users | |
| [20:22:45] | markk__ (markk__!~mark@host86-161-98-168.range86-161.btcentralplus.com) has quit (Ping timeout: 240 seconds) | |
| [20:45:53] | cybrNaut: | there is a recorded.basename and also a recordedfile.basename |
| [20:46:15] | cybrNaut: | there is a recorded.filesize and also a recordedfile.filesize |
| [20:46:19] | cybrNaut: | seems like a bad idea |
| [20:47:51] | cybrNaut: | so after transcoding, should i update all 4 of those attributes? |
| [20:48:21] | cybrNaut: | I see that recordedfile.basename "references" recorded.basename. Does that mean if I update recorded.basename the recordedfile.basename will automatically update? |
| [21:02:32] | markk__ (markk__!~mark@host86-161-98-168.range86-161.btcentralplus.com) has joined #mythtv-users | |
| [21:04:13] | cybrNaut: | shit, looks like updating recorded.basename does *not* automatically update recordedfile.basename. |
| [21:06:13] | cybrNaut: | so should I push the same update to the recordedfile table as I do to the recorded table? Any reason for the tables to differ? |
| [21:13:49] | Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7d83:6501:6032:9caa:16d4:6ffa) has quit (Quit: Konversation terminated!) | |
| [21:32:06] | Toast (Toast!~quassel@w-37.cust-u6165.ip.static.uno.uk.net) has quit (Quit: No Ping reply in 180 seconds.) | |
| [21:34:29] | Toast (Toast!~quassel@w-37.cust-u6165.ip.static.uno.uk.net) has joined #mythtv-users | |
| [21:38:40] | psymin (psymin!~psymin@fsf/member/psymin) has quit (Quit: Leaving) | |
| [21:42:22] | clueminati (clueminati!~clueminat@gateway/tor-sasl/clueminati) has quit (Remote host closed the connection) | |
| [21:42:31] | mack-: | cybrNaut: You should not really be messing directly with the database for almost all uses. |
| [21:43:30] | clueminati (clueminati!~clueminat@gateway/tor-sasl/clueminati) has joined #mythtv-users | |
| [21:44:14] | cybrNaut: | mack-: i would love to know the non-db way to make my manual transcodings known to the db |
| [21:45:16] | cybrNaut: | I looked at the rokuencode script in this project: mysql --user=mythtv --password=0CXAFPKe --host=10.15.65.170 --table mythconverg <<< 'select recordedfile.basename,cast(recorded.title as char(30)) as title,convert_tz(recorded.starttime,"GMT","system") as "lcl time",recorded.filesize,unix_timestamp(recorded.endtime)-unix_timestamp(rec orded.starttime) as |
| [21:45:21] | cybrNaut: | seconds,TIMEDIFF(recorded.endtime,recorded.starttime) as duration,recorded.filesize/1000/(unix_timestamp(recorded.endtime)-unix_timestamp (recorded.starttime)) as kbps from recordedfile join recorded on recorded.recordedid = recordedfile.recordedid order by kbps;' |
| [21:45:26] | cybrNaut: | shit, bad past |
| [21:45:30] | cybrNaut: | *paste |
| [21:46:07] | cybrNaut: | I looked at the rokuencode script in this project: https://github.com/ear9mrn/MythRokuPlayer |
| [21:47:02] | cybrNaut: | that script file is updating the db directly after transcoding. |
| [21:47:08] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Quit: Konversation terminated!) | |
| [21:48:46] | cybrNaut: | https://github.com/ear9mrn/MythRokuPlayer/blo . . . okuencode.sh |
| [21:54:51] | mack-: | are you just wanting your old recording to be flagged as transcoded? Calling mythtranscode (lossless, honorcutlist) in your user job script should do that.Are you trying to transcode in place and leave the output in the Recordings directory or something? Not sorting through roku stuff, sorry =) |
| [21:56:41] | cybrNaut: | the Roku is limited to mp4 files, and all the source files are .ts files. /mythtranscode/ is not capable of transcoding from TS to MP4. |
| [21:57:46] | mack-: | yeah, use mythtranscode to cut commercials losslessly, then transcode to whatever you like using whatever tools you like |
| [21:59:55] | mack-: | several examples are in the wiki, and even more around the web, using different scripting languages and different tools. I personally have my user jobs call handbrakeCLI |
| [22:00:21] | cybrNaut: | well my script is already refined to honoring the cutlist, so mythtranscode is redundant. I would be nice if I could tell mythtranscode old & new filenames so it would skip the transcoding and just do everything else |
| [22:00:58] | cybrNaut: | in fact the rokuencode.sh uses handbrakeCLI |
| [22:01:46] | cybrNaut: | i see there is a "mythutils --copyfile" command. the wiki doesn't really say what it does. Not sure if that would serve me here to get the DB updated |
| [22:03:48] | mack-: | Most people doing external transcodes usually dump the output into Videos or other places if they don't use mythfrontend and then delete the recording, I think. That's what I do, at least, and what other examples I remember seeing back in the day when I was setting mine up. |
| [22:05:01] | clueminati (clueminati!~clueminat@gateway/tor-sasl/clueminati) has quit (Remote host closed the connection) | |
| [22:05:04] | jm|laptop: | they've been saying "Recordings might no longer look for shit in Videos" for a loooong time though. |
| [22:05:23] | clueminati (clueminati!~clueminat@gateway/tor-sasl/clueminati) has joined #mythtv-users | |
| [22:06:20] | mack-: | I wasn't aware Recordings looks for stuff in Videos lol. If it was recorded from TV, it's in recordings. If it's been transcoded, it's not. <- that's how I view it. |
| [22:07:17] | mack-: | I have never used the Videos section of the frontend, btw. I tried it out the first day I installed Myth, threw up a little, and never gave it another chance =) |
| [22:07:18] | jm|laptop: | mack-: iimu that if e.g. chanid_starttime.ts files are not found in the define Recordings directories, it might sneakily look into the defined Videos directories for good measure |
| [22:07:52] | jm|laptop: | (at least up to .30 IMOE) |
| [22:09:24] | cybrNaut: | the Myth FE for Roku is basically a client for the mythweb API. Mythweb does not appear to access "videos" |
| [22:10:03] | cybrNaut: | i suppose this is why the rokuencode.sh script hacks the db. |
| [22:12:04] | cybrNaut: | jm|laptop: you seem to be suggesting I could drop the new transcodings in /var/lib/mythtv/videos/ and delete the source TS file. But would the backend be smart enough to discover the new filename if it has a different extension? |
| [22:12:56] | cybrNaut: | mack-: do you lose the metadata when you put your transcoded versions in /var/lib/mythtv/videos/? |
| [22:13:49] | jm|laptop: | cybrNaut: sorry. I had not read up and talking very generically about MythTV's own frontend. AIUI, the recorded table stores the filename (basename) of the recording and then defined Storage directories are traversed. |
| [22:14:00] | mack-: | cybrNaut: I don't use mythfrontend for Videos after transcoding. |
| [22:15:35] | jm|laptop: | if you were to rename the 'basename' I doubt it would look for variants with a different suffix, and I know even less about the various APIs. It's arguable that the decoder/player (myth's own or whatever has been specified for playback) cares little for the file extension anyway and very likely queries the bitstream itself to identify container and formats |
| [22:17:12] | jm|laptop: | this might allow what might be seen as abuse or a Bad Thing by renaming say an .mkv to a .ts as stored in the recorded table so that it will 'find' it and then the decoder will query the bitstream and be all like "these aren't my glasses!" but still be able to decode it based on container headers or file magic or whatevs |
| [22:21:31] | user798645 (user798645!~User@user-10mt7in.cable.mindspring.com) has joined #mythtv-users | |
| [22:24:01] | markk__ (markk__!~mark@host86-161-98-168.range86-161.btcentralplus.com) has quit (Ping timeout: 258 seconds) | |
| [22:38:42] | GWG (GWG!~GWG@pool-72-69-18-11.nycmny.fios.verizon.net) has quit (Quit: ZNC 1.7.5+deb4 - https://znc.in) | |
| [22:46:32] | GWG (GWG!~GWG@pool-72-69-18-11.nycmny.fios.verizon.net) has joined #mythtv-users | |
| [22:48:56] | user798645 (user798645!~User@user-10mt7in.cable.mindspring.com) has quit (Ping timeout: 258 seconds) | |
| [23:26:19] | RokLobsta (RokLobsta!~Dirkka@121-200-12-5.79c80c.mel.nbn.aussiebb.net) has quit (Quit: Leaving) | |
| [23:40:05] | Toast (Toast!~quassel@w-37.cust-u6165.ip.static.uno.uk.net) has quit (Ping timeout: 240 seconds) | |
| [23:50:16] | cybrNaut: | looks like some ppl are writing transcode scripts in Python and using API calls to MythTV and using the job queue. That's probably the most proper but not everyone knows python. So it looks like bash scripts are limited to hacking the DB. |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.