| Sunday, January 13th, 2013, 00:04 UTC | ||
| [00:04:01] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [00:10:24] | zombor (zombor!~zombor__@kohana/developer/zombor) has quit (Remote host closed the connection) | |
| [00:18:09] | IReboot (IReboot!~doug@CPE10bf48e67915-CM00252eac6f40.cpe.net.cable.rogers.com) has quit (Read error: No route to host) | |
| [00:18:13] | FnC: | hmmm keep getting the deadlock detected when i try and transcode this file... even did the ffmpeg thing... anything else i could do |
| [00:18:13] | FnC: | ? |
| [00:23:55] | IReboot (IReboot!~doug@CPE10bf48e67915-CM00252eac6f40.cpe.net.cable.rogers.com) has joined #mythtv-users | |
| [00:41:42] | FnC: | anyone around that could help me try and get this transcoded? |
| [00:42:58] | Hoochster (Hoochster!~hooch@173.216.129.63) has quit (Ping timeout: 244 seconds) | |
| [00:44:47] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has quit (Quit: Konversation terminated!) | |
| [00:48:08] | Hoochster (Hoochster!~hooch@173.216.129.63) has joined #mythtv-users | |
| [00:52:41] | FnC: | here is the pastebin for the transcode debug http://pastebin.com/wXXZZq9v |
| [00:54:48] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has joined #mythtv-users | |
| [00:54:50] | Sharky112065 is now known as Sharky-AFK | |
| [00:58:41] | cocoa117 (cocoa117!~cocoa117@188-223-77-201.zone14.bethere.co.uk) has joined #mythtv-users | |
| [01:01:39] | joki (joki!~joki@p54861DCB.dip.t-dialin.net) has quit (Ping timeout: 240 seconds) | |
| [01:02:46] | joki (joki!~joki@p54862B69.dip.t-dialin.net) has joined #mythtv-users | |
| [01:05:28] | FnC: | is there a way to check if there is an updated version of just mythtranscode? |
| [01:06:48] | KaZeR (KaZeR!~kazer@114.170.67.86.rev.sfr.net) has quit (Ping timeout: 264 seconds) | |
| [01:08:48] | KaZeR (KaZeR!~kazer@89.170.67.86.rev.sfr.net) has joined #mythtv-users | |
| [01:19:20] | bentech (bentech!~bentech@host86-148-54-144.range86-148.btcentralplus.com) has quit (Quit: bentech) | |
| [01:33:53] | natanojl (natanojl!~jonatan@c83-252-237-63.bredband.comhem.se) has quit (Ping timeout: 248 seconds) | |
| [01:34:50] | cocoa117 (cocoa117!~cocoa117@188-223-77-201.zone14.bethere.co.uk) has quit (Ping timeout: 255 seconds) | |
| [01:34:59] | skd5aner: | jheizer: ping |
| [01:36:35] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has joined #mythtv-users | |
| [01:42:26] | croppa (croppa!~stuart@CPE-120-146-137-99.static.nsw.bigpond.net.au) has quit (Ping timeout: 252 seconds) | |
| [01:42:57] | croppa (croppa!~stuart@CPE-120-146-137-99.static.nsw.bigpond.net.au) has joined #mythtv-users | |
| [01:51:02] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has quit (Ping timeout: 276 seconds) | |
| [02:08:32] | lentferj (lentferj!~lentferj@p579B6AD3.dip.t-dialin.net) has quit (Ping timeout: 252 seconds) | |
| [02:09:40] | lentferj (lentferj!~lentferj@p57981F5A.dip.t-dialin.net) has joined #mythtv-users | |
| [02:10:05] | FnC: | looks like mythtanscode is broken in .26 |
| [02:10:46] | FnC: | http://code.mythtv.org/trac/ticket/11090 |
| [02:13:33] | RagingMind (RagingMind!~RagingMin@2001:470:1f11:fef:5604:a6ff:fe04:f8c5) has quit (Quit: ZNC - http://znc.in) | |
| [02:14:55] | RagingMind (RagingMind!~RagingMin@2001:470:1f11:fef:5604:a6ff:fe04:f8c5) has joined #mythtv-users | |
| [02:19:54] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has quit (Quit: Konversation terminated!) | |
| [02:26:19] | BLZbubba (BLZbubba!~mark@tpsit.com) has joined #mythtv-users | |
| [02:35:06] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [02:47:11] | Pluribus (Pluribus!~Pluribus@c-67-184-128-218.hsd1.il.comcast.net) has joined #mythtv-users | |
| [02:54:28] | [mrx] ([mrx]!~mrx]@2001:470:28:196:5054:ff:fe36:a3eb) has quit (Ping timeout: 260 seconds) | |
| [03:00:58] | FnC (FnC!~fnc@71-8-115-96.dhcp.ftwo.tx.charter.com) has left #mythtv-users () | |
| [03:04:58] | npm (npm!~npm@cpe-198-72-183-90.socal.res.rr.com) has quit (Remote host closed the connection) | |
| [03:05:45] | npm (npm!~npm@198.72.183.90) has joined #mythtv-users | |
| [03:20:59] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 260 seconds) | |
| [03:29:08] | cjo (cjo!~Chris@host109-154-190-19.range109-154.btcentralplus.com) has joined #mythtv-users | |
| [03:32:57] | Seeker` (Seeker`!~Chris@unaffiliated/seeker) has quit (Ping timeout: 276 seconds) | |
| [03:33:04] | andreaz (andreaz!~andre_000@p4FE64A84.dip.t-dialin.net) has quit (Quit: Leaving.) | |
| [03:35:00] | mzb is now known as mzb_ | |
| [03:37:52] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has joined #mythtv-users | |
| [04:02:17] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has quit (Remote host closed the connection) | |
| [04:05:32] | emmanuelux (emmanuelux!~emmanuelu@vau92-2-82-228-217-1.fbx.proxad.net) has quit (Read error: Connection reset by peer) | |
| [04:16:13] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has joined #mythtv-users | |
| [04:22:57] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [04:23:36] | Shadow__X (Shadow__X!~jose@unaffiliated/shadowx/x-411846) has quit (Read error: Connection reset by peer) | |
| [04:23:49] | Shadow__X (Shadow__X!~jose@c-68-32-235-149.hsd1.nj.comcast.net) has joined #mythtv-users | |
| [04:30:45] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 256 seconds) | |
| [04:35:13] | fetzerch (fetzerch!~quassel@unaffiliated/fetzerch) has quit (Ping timeout: 248 seconds) | |
| [04:36:35] | fetzerch (fetzerch!~quassel@unaffiliated/fetzerch) has joined #mythtv-users | |
| [04:41:43] | sraue (sraue!~stephan@xbmc/staff/sraue) has quit (Ping timeout: 260 seconds) | |
| [04:45:37] | [R] ([R]!~rbox@unaffiliated/rbox) has joined #mythtv-users | |
| [04:50:08] | Cubber: | I am using a hauppauge HVR-1600 in a gentoo Xen DomU running as a mythbackend server. The system is recording fine and I can playback recordings and watch live tv from another PC running a frontend. However when I go to change the channel the frontend will hang. |
| [04:51:01] | Cubber: | This did not happen on the hardware PC that I migrated the backend from to the VM. |
| [04:51:16] | [R]: | shocker... vms suck |
| [04:51:51] | wylie (wylie!~wylie@ip72-208-123-25.ph.ph.cox.net) has quit (Remote host closed the connection) | |
| [04:52:13] | wylie (wylie!~wylie@69.80.101.177) has joined #mythtv-users | |
| [04:52:52] | Cubber: | actually the performance is much better than the old athlonXP I was using before. The only issue is the channel changing. The system will change channels on its own if it needs to record a show on a different channel with no issues. Just when a frontend attempts the change. |
| [04:53:49] | wagnerrp: | talk to any of the kernel driver developers and they'll tell you if you have _any_ problems, stop using a VM |
| [04:54:03] | sraue (sraue!~stephan@xbmc/staff/sraue) has joined #mythtv-users | |
| [04:54:24] | wagnerrp: | use of a VM screws up latencies in communications |
| [04:54:45] | wagnerrp: | any any type of passthrough represents a huge headache in attempting to debug driver issues |
| [04:54:57] | Cubber: | wagnerrp understood |
| [04:55:00] | wagnerrp: | they basically just say no |
| [04:55:47] | wagnerrp: | still, i thought "DomU" meant the host OS, and any of the virtual machines run on the host were "Dom0/1/2/3/..." |
| [04:56:04] | Cubber: | no Dom0 is host, DomU is a guest |
| [04:56:11] | wagnerrp: | oh, had it backwards |
| [04:56:22] | Cubber: | the channel changing appears to work if I let it hang long enough. So it is just a serious latency |
| [04:56:40] | Cubber: | using pci-passthrough in xen to allow the guest to see the card |
| [04:56:54] | Cubber: | playback is flawless |
| [04:57:11] | wagnerrp: | there are some instabilities in mythtv itself, when attempting to change channels in live tv mode |
| [04:57:37] | wagnerrp: | but running your backend in a VM, especially when you have hardware you need to access, is just an unrecommended configuration |
| [04:57:49] | Cubber: | well seems the setup will work for recording, thats mainly what I need it for for now. I rarely use it to watch livetv anyway |
| [04:58:29] | wagnerrp: | why are you using a VM in the first place, if i may ask? |
| [04:59:01] | Cubber: | because I just built a dual core xeon server with 48 gigs of ram for virtualization |
| [04:59:27] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has quit (Ping timeout: 260 seconds) | |
| [04:59:27] | wagnerrp: | but why for virtualization? why not just run everything directly on the host os? (presuming everything your running runs on gentoo) |
| [04:59:35] | Cubber: | I wanted to replace all of my ancient machines that I was using for servers into one consolidated hardware |
| [04:59:58] | Cubber: | isolation of services, ability to create test machines etc.. |
| [05:00:32] | wagnerrp: | isolation of services for... security reasons? or just to prevent installs of different things from interfering with each other? |
| [05:00:48] | Cubber: | I could run mythtv on the dom0 directly giving it direct access to the video card without pci passthrough |
| [05:00:55] | Cubber: | both |
| [05:01:31] | MaverickTech (MaverickTech!~MaverickT@111.86.233.220.static.exetel.com.au) has quit (Ping timeout: 245 seconds) | |
| [05:01:32] | Cubber: | plus I am a PHD student so I need to be able to reconfigure machines and create them as needed on the fly for research purposes |
| [05:01:52] | Cubber: | rather than have a bunch of hardware kicking around sucking up electricity |
| [05:02:08] | wagnerrp: | if it's for security reasons, simply having mythtv running, and listening on the network for remote frontends, is a serious security risk |
| [05:02:20] | wagnerrp: | mythtv assumes your whole network is secure |
| [05:02:30] | wagnerrp: | and if your whole network is secure, there's no security need to run VMs |
| [05:02:51] | wagnerrp: | as for manageability, when you built your gentoo machine, did you do it by hand, or did you use one of the installers? |
| [05:02:52] | Cubber: | security not the main reason |
| [05:02:59] | Cubber: | all by hand |
| [05:03:12] | [R]: | wagnerrp: so my frontend has been real flaky a lot lately... turns out one of the ram sticks popped out |
| [05:03:22] | Cubber: | I had my old myth box running for years on gentoo and an amd athalon-XP 2600 CPU with 2g of ram |
| [05:03:30] | wagnerrp: | so you did the dev/proc/sys mounts, and chrooted into your build environment? |
| [05:03:56] | Cubber: | yes sir been using gentoo for about 8 years or so now |
| [05:04:24] | Cubber: | I have custom stage4s for each of my VMs to make creation a breeze |
| [05:04:26] | wagnerrp: | you can do the same thing to run multiple "system images" on one system, bypassing the need for a full virtual machine |
| [05:04:43] | Cubber: | even have a custom stage4 for this mythtv server so I can just create a new LVM partition and extract it then start it up |
| [05:04:54] | Cubber: | chroot jails |
| [05:05:03] | wagnerrp: | just set up a bunch of different environments for different applications, chroot into one of them, and run the application |
| [05:05:41] | Cubber: | I am just a fan of Xen since I did a lot with it during my master's thesis |
| [05:05:57] | wagnerrp: | i do that on my freebsd backend, but with a mechanism called "jails" |
| [05:06:06] | Cubber: | yah I am familiar with them |
| [05:06:14] | wagnerrp: | but jails offer a bit more memory and network isolation than a typical chroot |
| [05:06:22] | wagnerrp: | the linux analog is fairly new, LXC |
| [05:06:46] | Cubber: | xen is nice though |
| [05:07:15] | Cubber: | I teach at a university and use it for my network computer security students so they can have VMs to mess with |
| [05:07:21] | wagnerrp: | i don't deny that all those things come with a nice set of utilities around them to make them convenient to use |
| [05:07:28] | Cubber: | have had over 100 VM's running simutaniously on a single xen host |
| [05:08:15] | wagnerrp: | i'm just saying that for most home users where absolute isolation for security reasons is not necessary, lesser "paravirtualization" gives you the isolation for management they actually want, without any of the hassles that come from dealing with hardware access |
| [05:09:11] | Cubber: | I understand what your saying. |
| [05:09:29] | wagnerrp: | hardly a week goes by without someone on the mailing list repeating the same questions about trouble with hardware access in VMs |
| [05:09:50] | wagnerrp: | and honestly, i've just stopped responding to them, since when i try to explain this on the thread, people brand me a troll |
| [05:09:53] | Cubber: | I have read a few over the past few days |
| [05:10:50] | Cubber: | I am an experimenter and that is mainly why I setup this server and converted to VM. Its more of a can I do it and make it work kind of a thing. |
| [05:11:03] | wagnerrp: | fair enough |
| [05:11:55] | Cubber: | was just hoping maybe someone else has tried to cross this bridge and had some insight. Since I did see a few posts on the xen and mythtv mailing lists, but most went unanswered. |
| [05:13:38] | Cubber: | on a different not, something you can probably answer. If I migrate a backend and use the same tuner card in the new backend and the devices are setup in /dev the same way do I need to clear out my capture cards and reload them or is it fine to leave them as is? |
| [05:14:14] | Cubber: | they are working, but I was going to do that as a last resort to see if it helped the issue. But after our conversation I am feeling like it is not going to do a thing. |
| [05:16:06] | wagnerrp: | in mythtv, there are local and global settings |
| [05:16:17] | wagnerrp: | local settings key off the current profile name |
| [05:16:32] | wagnerrp: | and unless specified otherwise in the config.xml, the profile name defaults to the system hostname |
| [05:17:00] | wagnerrp: | if you change to a different machine, but keep the hostname, or otherwise force it with the config.xml, all the old settings will be loaded in place |
| [05:17:07] | Cubber: | I did the hostname change in the db, and changed the config.xml on all the clients to point to the new ip. That all works. |
| [05:17:13] | wagnerrp: | worst case, you have to define the cards again from scratch |
| [05:17:14] | Cubber: | I was just wondering about the actual tuner |
| [05:17:32] | Cubber: | but since it works I figured it does not need to be changed |
| [05:17:33] | wagnerrp: | but since the channels are stored against the source, and the source is one-to-many mapped to inputs on the tuners |
| [05:17:39] | disputin (disputin!~sean@67.232.160.146) has quit (Ping timeout: 260 seconds) | |
| [05:17:49] | wagnerrp: | reconfiguring your cards shouldn't take more than a few minutes |
| [05:18:28] | wagnerrp: | just add the cards, link the sources back to the inputs on those cards, and make sure your storage paths are valid and writable |
| [05:18:37] | wagnerrp: | mythtv-setup will warn you about that last one if they're not |
| [05:19:20] | Cubber: | something to mess with another night, need to turn in. Thanks for the insight! |
| [05:21:35] | disputin (disputin!~sean@67.232.160.146) has joined #mythtv-users | |
| [05:24:28] | OldEnK (OldEnK!~OldEnK@63-152-109-88.cdrr.qwest.net) has joined #mythtv-users | |
| [05:29:47] | MaverickTech (MaverickTech!~MaverickT@111.86.233.220.static.exetel.com.au) has joined #mythtv-users | |
| [05:47:53] | wylie_ (wylie_!~wylie@ip72-208-123-25.ph.ph.cox.net) has joined #mythtv-users | |
| [05:50:47] | wylie (wylie!~wylie@69.80.101.177) has quit (Ping timeout: 260 seconds) | |
| [05:50:47] | wylie_ is now known as wylie | |
| [05:51:24] | Shadow__X (Shadow__X!~jose@c-68-32-235-149.hsd1.nj.comcast.net) has quit (Changing host) | |
| [05:51:25] | Shadow__X (Shadow__X!~jose@unaffiliated/shadowx/x-411846) has joined #mythtv-users | |
| [06:05:07] | PatrickDickey (PatrickDickey!~quassel@2001:470:1f11:830:b940:c90f:614c:63f) has joined #mythtv-users | |
| [06:16:55] | Crshman (Crshman!~FreeNode@ns351414.ovh.net) has joined #mythtv-users | |
| [06:18:43] | PatrickDickey (PatrickDickey!~quassel@2001:470:1f11:830:b940:c90f:614c:63f) has quit (Quit: No Ping reply in 180 seconds.) | |
| [06:18:50] | PatrickDickey (PatrickDickey!~quassel@2001:470:1f11:830:d2c:82f2:b6e8:6444) has joined #mythtv-users | |
| [06:27:29] | Goga777 (Goga777!~Goga777@128-71-222-125.broadband.corbina.ru) has joined #mythtv-users | |
| [06:30:29] | Crshman: | hello, i'm in the process of getting my mythtv setup going and I See a lot of errors like this in the logs: Jan 12 22:25:42 fileserver mythbackend[9162]: E ProcessRequest mainserver.cpp:6068 (LocalFilePath) ERROR: LocalFilePath unable to find local path for 'none'. |
| [06:30:39] | Crshman: | is that something to be alarmed about? |
| [06:39:24] | rsiebert_ (rsiebert_!~quassel@g224248009.adsl.alicedsl.de) has joined #mythtv-users | |
| [06:42:42] | rsiebert (rsiebert!~quassel@g224251049.adsl.alicedsl.de) has quit (Ping timeout: 264 seconds) | |
| [06:54:25] | CiaranG (CiaranG!~CiaranG@fsf/member/CiaranG) has quit (Ping timeout: 248 seconds) | |
| [06:59:57] | CiaranG (CiaranG!~CiaranG@fsf/member/CiaranG) has joined #mythtv-users | |
| [07:26:03] | ubIx (ubIx!~ulf@p5DD18D61.dip0.t-ipconnect.de) has joined #mythtv-users | |
| [07:26:34] | ubIx_ (ubIx_!~ulf@p5DD18F46.dip0.t-ipconnect.de) has quit (Read error: Operation timed out) | |
| [07:50:41] | OldEnK (OldEnK!~OldEnK@63-152-109-88.cdrr.qwest.net) has quit (Quit: Leaving) | |
| [07:54:18] | pmhahn (pmhahn!~pmhahn@2001:4dd0:ff00:8d31:219:dbff:fef2:e135) has joined #mythtv-users | |
| [08:00:38] | [R] ([R]!~rbox@unaffiliated/rbox) has quit (Quit: Leaving) | |
| [08:04:52] | CiaranG (CiaranG!~CiaranG@fsf/member/CiaranG) has quit (Ping timeout: 272 seconds) | |
| [08:08:40] | CiaranG (CiaranG!~CiaranG@fsf/member/CiaranG) has joined #mythtv-users | |
| [08:10:55] | [mrx] ([mrx]!~mrx]@2001:470:28:196:5054:ff:fe36:a3eb) has joined #mythtv-users | |
| [08:19:53] | tasjohn (tasjohn!~chatzilla@ppp118-208-235-81.lns20.hba2.internode.on.net) has joined #mythtv-users | |
| [08:22:19] | tasjohn: | Hi everyone. I'm having issues with playback where I am getting flickering through the screen. I'm using an Asrock ION3D which has an NVIDIA GT218 and I've tried all the VDPAU profiles. I am assuming it is a deinterlacing issue. Any thoughts? |
| [08:28:50] | tmkt (tmkt!~david@206.223.170.189) has quit (Ping timeout: 255 seconds) | |
| [08:32:19] | stoffel (stoffel!~quassel@pD9E41A7F.dip.t-dialin.net) has joined #mythtv-users | |
| [08:32:19] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v stoffel | |
| [08:33:04] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has joined #mythtv-users | |
| [08:42:13] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has quit (Ping timeout: 245 seconds) | |
| [08:45:54] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has joined #mythtv-users | |
| [08:57:27] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has quit (Ping timeout: 260 seconds) | |
| [09:00:51] | aloril (aloril!~aloril@dsl-tkubrasgw3-54f97e-153.dhcp.inet.fi) has joined #mythtv-users | |
| [09:20:51] | jya (jya!~jyavenard@CPE-60-224-1-106.srql1.win.bigpond.net.au) has joined #mythtv-users | |
| [09:20:51] | jya (jya!~jyavenard@CPE-60-224-1-106.srql1.win.bigpond.net.au) has quit (Changing host) | |
| [09:20:51] | jya (jya!~jyavenard@mythtv/developer/jya) has joined #mythtv-users | |
| [09:30:08] | Goga777 (Goga777!~Goga777@128-71-222-125.broadband.corbina.ru) has quit (Quit: Leaving) | |
| [09:39:05] | dekarl1 (dekarl1!~dekarl@p4FE84D2B.dip.t-dialin.net) has joined #mythtv-users | |
| [09:39:06] | tasjohn (tasjohn!~chatzilla@ppp118-208-235-81.lns20.hba2.internode.on.net) has quit (Ping timeout: 264 seconds) | |
| [09:40:51] | dekarl (dekarl!~dekarl@p4FCEE71B.dip.t-dialin.net) has quit (Ping timeout: 276 seconds) | |
| [09:46:54] | monkeypet69 (monkeypet69!~quassel@c-24-6-135-62.hsd1.ca.comcast.net) has quit (Ping timeout: 260 seconds) | |
| [09:48:56] | monkeypet69 (monkeypet69!~quassel@c-24-6-135-62.hsd1.ca.comcast.net) has joined #mythtv-users | |
| [09:55:04] | CiaranG (CiaranG!~CiaranG@fsf/member/CiaranG) has quit (Ping timeout: 272 seconds) | |
| [09:56:29] | CiaranG (CiaranG!~CiaranG@fsf/member/CiaranG) has joined #mythtv-users | |
| [10:34:43] | FabriceMG (FabriceMG!~FabriceMG@APoitiers-155-1-143-45.w81-50.abo.wanadoo.fr) has joined #mythtv-users | |
| [10:37:50] | Xeneth (Xeneth!~Xeneth@74-128-193-250.dhcp.insightbb.com) has joined #mythtv-users | |
| [10:38:46] | Xeneth: | anyone awake who can help me with a Mythbox to backend issue? |
| [11:04:23] | purserj (purserj!~purserj@hosting.collaborynth.com.au) has quit (Remote host closed the connection) | |
| [11:10:50] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [11:11:03] | SteveGoodey (SteveGoodey!~steve@host86-149-167-13.range86-149.btcentralplus.com) has joined #mythtv-users | |
| [11:21:28] | mzb_ is now known as mzb | |
| [11:25:35] | natanojl (natanojl!~jonatan@c83-252-237-63.bredband.comhem.se) has joined #mythtv-users | |
| [11:26:41] | cougar_h (cougar_h!~cougar@2a03:5880:104:10:3871:b4b9:d89f:a36f) has joined #mythtv-users | |
| [11:26:41] | Cougar (Cougar!~cougar@2a03:5880:104:10:3871:b4b9:d89f:a36f) has joined #mythtv-users | |
| [11:26:42] | Cougar (Cougar!~cougar@2a03:5880:104:10:3871:b4b9:d89f:a36f) has quit (Read error: Connection reset by peer) | |
| [11:26:46] | cougar_h (cougar_h!~cougar@2a03:5880:104:10:3871:b4b9:d89f:a36f) has quit (Remote host closed the connection) | |
| [11:26:52] | Cougar (Cougar!~cougar@2a03:5880:104:10:3871:b4b9:d89f:a36f) has joined #mythtv-users | |
| [11:52:56] | cocoa117 (cocoa117!~cocoa117@188-223-77-201.zone14.bethere.co.uk) has joined #mythtv-users | |
| [11:59:43] | croppa (croppa!~stuart@CPE-120-146-137-99.static.nsw.bigpond.net.au) has quit () | |
| [12:11:50] | disputin (disputin!~sean@67.232.160.146) has quit (Quit: Leaving.) | |
| [12:22:18] | _abbenormal (_abbenormal!~abbenorma@d28-23-28-94.dim.wideopenwest.com) has quit (Read error: Operation timed out) | |
| [12:25:10] | Xeneth (Xeneth!~Xeneth@74-128-193-250.dhcp.insightbb.com) has quit (Quit: Leaving) | |
| [12:25:54] | IReboot (IReboot!~doug@CPE10bf48e67915-CM00252eac6f40.cpe.net.cable.rogers.com) has quit (Remote host closed the connection) | |
| [12:28:23] | IReboot (IReboot!~doug@CPE10bf48e67915-CM00252eac6f40.cpe.net.cable.rogers.com) has joined #mythtv-users | |
| [12:30:25] | bas-t (bas-t!~tycho@52484E89.cm-4-1b.dynamic.ziggo.nl) has joined #mythtv-users | |
| [12:32:42] | lyricnz (lyricnz!~simonrobe@ppp118-209-203-138.lns20.mel6.internode.on.net) has quit (Quit: lyricnz) | |
| [12:35:47] | cocoa117 (cocoa117!~cocoa117@188-223-77-201.zone14.bethere.co.uk) has quit (Quit: Leaving) | |
| [12:36:21] | purserj (purserj!~purserj@hosting.collaborynth.com.au) has joined #mythtv-users | |
| [12:41:41] | PatrickDickey (PatrickDickey!~quassel@2001:470:1f11:830:d2c:82f2:b6e8:6444) has quit (Ping timeout: 245 seconds) | |
| [12:50:32] | PatrickDickey (PatrickDickey!~quassel@2001:470:1f11:830:90df:2c44:9a1d:ea51) has joined #mythtv-users | |
| [12:54:02] | Igramul: | Is there a way to get the file size of recordings in Python? |
| [13:02:57] | Twiggy2cents (Twiggy2cents!~darren@173-25-90-98.client.mchsi.com) has quit (Ping timeout: 248 seconds) | |
| [13:12:19] | bas-t (bas-t!~tycho@52484E89.cm-4-1b.dynamic.ziggo.nl) has quit (Quit: Ex-Chat) | |
| [13:13:39] | andreaz (andreaz!~andre_000@p4FE64A84.dip.t-dialin.net) has joined #mythtv-users | |
| [13:14:08] | stoffel (stoffel!~quassel@pD9E41A7F.dip.t-dialin.net) has quit (Ping timeout: 240 seconds) | |
| [13:24:38] | natanojl: | Igramul: You can use the MythTV Python bindings and construct a Recorded object and then use the filesize attribute. mythvidexport.py uses it, https://github.com/wagnerrp/mythtv-scripts/bl . . . videxport.py |
| [13:25:18] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 264 seconds) | |
| [13:32:45] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [13:33:52] | _abbenormal (_abbenormal!~abbenorma@d28-23-28-94.dim.wideopenwest.com) has joined #mythtv-users | |
| [13:42:48] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 264 seconds) | |
| [13:49:14] | Vollstrecker_ (Vollstrecker_!~Vollstrec@p4FC79DCF.dip.t-dialin.net) has quit (Ping timeout: 255 seconds) | |
| [13:49:31] | Vollstrecker_ (Vollstrecker_!~Vollstrec@p4FC7A7C8.dip.t-dialin.net) has joined #mythtv-users | |
| [13:53:42] | dekarl1 (dekarl1!~dekarl@p4FE84D2B.dip.t-dialin.net) has quit (Ping timeout: 276 seconds) | |
| [13:55:28] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has joined #mythtv-users | |
| [13:56:12] | emmanuelux (emmanuelux!~emmanuelu@vau92-2-82-228-217-1.fbx.proxad.net) has joined #mythtv-users | |
| [14:31:10] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has quit (Remote host closed the connection) | |
| [14:31:32] | stoffel (stoffel!~quassel@pD9E41A7F.dip.t-dialin.net) has joined #mythtv-users | |
| [14:31:33] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v stoffel | |
| [14:33:46] | dekarl (dekarl!~dekarl@p4FE84A8B.dip.t-dialin.net) has joined #mythtv-users | |
| [14:41:28] | troyt (troyt!~troyt@2001:1938:240:3000::3) has quit (Ping timeout: 252 seconds) | |
| [14:44:27] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has joined #mythtv-users | |
| [14:45:33] | troyt (troyt!~troyt@2001:1938:240:3000::3) has joined #mythtv-users | |
| [14:51:03] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has quit (Quit: Konversation terminated!) | |
| [14:59:15] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has joined #mythtv-users | |
| [15:00:58] | CiaranG (CiaranG!~CiaranG@fsf/member/CiaranG) has quit (Ping timeout: 272 seconds) | |
| [15:04:14] | CiaranG (CiaranG!~CiaranG@fsf/member/CiaranG) has joined #mythtv-users | |
| [15:07:38] | stoffel (stoffel!~quassel@pD9E41A7F.dip.t-dialin.net) has quit (Ping timeout: 240 seconds) | |
| [15:35:30] | SteveGoodey (SteveGoodey!~steve@host86-149-167-13.range86-149.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
| [15:39:01] | SteveGoodey (SteveGoodey!~steve@host86-149-167-13.range86-149.btcentralplus.com) has joined #mythtv-users | |
| [16:06:04] | gregL (gregL!~greg@cpe-74-76-105-205.nycap.res.rr.com) has quit (Read error: Connection reset by peer) | |
| [16:12:24] | Cubber (Cubber!~ronny@cpe-74-71-250-35.twcny.res.rr.com) has quit (Quit: leaving) | |
| [16:14:26] | Cubber (Cubber!~ronny@cpe-74-71-250-35.twcny.res.rr.com) has joined #mythtv-users | |
| [16:18:50] | gregL (gregL!~greg@cpe-74-76-105-205.nycap.res.rr.com) has joined #mythtv-users | |
| [16:25:41] | stoffel (stoffel!~quassel@pD9E42566.dip.t-dialin.net) has joined #mythtv-users | |
| [16:25:41] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v stoffel | |
| [16:31:13] | bentech (bentech!~bentech@86.148.54.144) has joined #mythtv-users | |
| [16:42:31] | andreaz (andreaz!~andre_000@p4FE64A84.dip.t-dialin.net) has quit (Quit: Leaving.) | |
| [16:50:50] | bentech (bentech!~bentech@86.148.54.144) has quit (Quit: bentech) | |
| [16:59:06] | blassey (blassey!~blassey@c-71-232-20-86.hsd1.ma.comcast.net) has joined #mythtv-users | |
| [17:00:32] | Floppe (Floppe!~Floppe@2001:14b8:1d3::100) has quit (Ping timeout: 260 seconds) | |
| [17:03:49] | Floppe (Floppe!~Floppe@2001:14b8:1d3::100) has joined #mythtv-users | |
| [17:06:13] | andreaz (andreaz!~andre_000@p4FE64A84.dip.t-dialin.net) has joined #mythtv-users | |
| [17:08:02] | ElmerFudd (ElmerFudd!~le@0x5737a682.cpe.ge-0-1-0-1101.hsnqu1.customer.tele.dk) has left #mythtv-users ("Leaving") | |
| [17:12:17] | Cubber (Cubber!~ronny@cpe-74-71-250-35.twcny.res.rr.com) has quit (Quit: leaving) | |
| [17:13:55] | stoffel (stoffel!~quassel@pD9E42566.dip.t-dialin.net) has quit (Ping timeout: 265 seconds) | |
| [17:19:34] | andreaz (andreaz!~andre_000@p4FE64A84.dip.t-dialin.net) has quit (Read error: Connection reset by peer) | |
| [17:29:26] | faichele (faichele!~quassel@p4FCF2F94.dip.t-dialin.net) has joined #mythtv-users | |
| [17:35:02] | fleers (fleers!~fleers@cpe-76-93-149-124.san.res.rr.com) has quit (Ping timeout: 252 seconds) | |
| [17:47:43] | Igramul: | natanojl: ok, I'll try |
| [17:54:59] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has quit (Quit: Konversation terminated!) | |
| [17:55:59] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has joined #mythtv-users | |
| [18:06:17] | plotino (plotino!~miles@host21-187-dynamic.56-79-r.retail.telecomitalia.it) has joined #mythtv-users | |
| [18:22:24] | bentech (bentech!~bentech@host86-148-54-144.range86-148.btcentralplus.com) has joined #mythtv-users | |
| [18:30:05] | Igramul: | I guess, when I delete a recording, it will not be re-recorded, right? |
| [18:30:44] | Igramul: | "delete" means using Recorded's delete() method. |
| [18:31:35] | wagnerrp: | depends |
| [18:32:17] | thomasf (thomasf!~u200806@i59F6C2A6.versanet.de) has joined #mythtv-users | |
| [18:32:23] | wagnerrp: | if you notice, Recorded.delete() has an optional rerecord argument, that defaults to false |
| [18:33:36] | wagnerrp: | also note that unlike many of the other methods, delete does not actually delete the entry |
| [18:33:43] | wagnerrp: | it tells the backend to delete the recording |
| [18:34:10] | wagnerrp: | and the backend may take up to 15 minutes to do so, since deletions are performed by the auto-expirer |
| [18:35:34] | Igramul: | hmm... I guess I am looking at the wrong documentation page. http://www.mythtv.org/wiki/0.24_Python_bindin . . . ers#Recorded says nothing about the delete-method. |
| [18:36:09] | wagnerrp: | what version of mythtv are you using? |
| [18:36:18] | thomasf (thomasf!~u200806@i59F6C2A6.versanet.de) has left #mythtv-users () | |
| [18:36:45] | tlhiv_laptop (tlhiv_laptop!~foo@68.35.204.183) has joined #mythtv-users | |
| [18:36:47] | wagnerrp: | the Recorded.delete method has always had the backend perform the delete for it, rather than doing it directly |
| [18:37:12] | wagnerrp: | but the deletes being deferred for the autoexpirer was only optional until 0.26 (or maybe 0.25) |
| [18:37:42] | wagnerrp: | in any case, it's just a note to be aware of, in case you think you see strange behavior in that the database entry is still accessible after you "delete" it |
| [18:38:27] | Igramul: | Version: 2:0.25.0+fixes.20120410.1f5962a-0ubuntu1 |
| [18:39:26] | Igramul: | wagnerrp: What I am trying to do is detecting broken recordings (filesize < 10000) and scheduling those for re-recording. |
| [18:40:36] | wagnerrp: | i believe find_orphans.py scans for zero-byte recordings as one of its tests |
| [18:40:47] | wagnerrp: | although it doesn't currently do anything for impossibly small recordings |
| [18:41:17] | Igramul: | The code for finding those recordings is already working. |
| [18:41:46] | Igramul: | btw. thanks to the devs for python-bindings ;) |
| [18:46:03] | emmanuelux (emmanuelux!~emmanuelu@vau92-2-82-228-217-1.fbx.proxad.net) has quit (Quit: emmanuelux) | |
| [18:48:20] | tlhiv_laptop (tlhiv_laptop!~foo@68.35.204.183) has quit (Ping timeout: 272 seconds) | |
| [18:56:40] | Lomion0815 (Lomion0815!~androirc@178-191-182-244.adsl.highway.telekom.at) has joined #mythtv-users | |
| [19:00:17] | jheizer__ (jheizer__!~jheizer@c-98-226-220-178.hsd1.il.comcast.net) has joined #mythtv-users | |
| [19:00:24] | MavT (MavT!~MaverickT@111.86.233.220.static.exetel.com.au) has joined #mythtv-users | |
| [19:01:28] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [19:01:42] | wagnerrp: | igramul: i mean there's a whole utility set up for it already |
| [19:03:26] | Igramul: | wagnerrp: well, I'm still new to mythtv |
| [19:04:42] | Peitolm_ (Peitolm_!~moreyc@mandlebrot.random-chaos.org.uk) has joined #mythtv-users | |
| [19:04:49] | quicksil1er (quicksil1er!~jules@roobarb.crazydogs.org) has joined #mythtv-users | |
| [19:04:56] | sl1ce (sl1ce!~johnathan@pool-100-0-73-123.bstnma.fios.verizon.net) has quit (Quit: Konversation terminated!) | |
| [19:05:05] | petefunk_ (petefunk_!~pfunk@198.23.147.3) has joined #mythtv-users | |
| [19:05:10] | BLZbubba_ (BLZbubba_!~mark@tpsit.com) has joined #mythtv-users | |
| [19:07:03] | jbaxter (jbaxter!~jbaxter@jimbax.plus.com) has joined #mythtv-users | |
| [19:08:27] | tris- (tris-!tristan@camel.ethereal.net) has joined #mythtv-users | |
| [19:09:21] | jarryd_ (jarryd_!jarryd@im.jarryd.net) has joined #mythtv-users | |
| [19:09:27] | MaverickTech (MaverickTech!~MaverickT@111.86.233.220.static.exetel.com.au) has quit (*.net *.split) | |
| [19:09:27] | BLZbubba (BLZbubba!~mark@tpsit.com) has quit (*.net *.split) | |
| [19:09:27] | petefunk (petefunk!~pfunk@198.23.147.3) has quit (*.net *.split) | |
| [19:09:27] | jheizer (jheizer!~jheizer@c-98-226-220-178.hsd1.il.comcast.net) has quit (*.net *.split) | |
| [19:09:27] | tris (tris!tristan@camel.ethereal.net) has quit (*.net *.split) | |
| [19:09:27] | xris (xris!~xris@xris.forevermore.net) has quit (*.net *.split) | |
| [19:09:27] | quicksilver (quicksilver!~jules@46.235.224.144) has quit (*.net *.split) | |
| [19:09:28] | kc (kc!~Casper@unaffiliated/kc) has quit (*.net *.split) | |
| [19:09:28] | jarryd (jarryd!jarryd@im.jarryd.net) has quit (*.net *.split) | |
| [19:09:28] | jbrett (jbrett!brett@nat/hp/x-beusnkixyfgsjrpn) has quit (*.net *.split) | |
| [19:09:28] | Peitolm (Peitolm!~moreyc@unaffiliated/peitolm) has quit (*.net *.split) | |
| [19:09:45] | tris- is now known as tris | |
| [19:11:47] | fleers (fleers!~fleers@cpe-76-93-149-124.san.res.rr.com) has joined #mythtv-users | |
| [19:14:02] | jbaxter (jbaxter!~jbaxter@jimbax.plus.com) has quit (Ping timeout: 252 seconds) | |
| [19:21:12] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 264 seconds) | |
| [19:22:28] | jbaxter (jbaxter!~jbaxter@jimbax.plus.com) has joined #mythtv-users | |
| [19:22:43] | kc (kc!~Casper@unaffiliated/kc) has joined #mythtv-users | |
| [19:23:44] | jbaxter (jbaxter!~jbaxter@jimbax.plus.com) has quit (Remote host closed the connection) | |
| [19:25:51] | Igramul: | hmm... where can I find those scripts? |
| [19:27:46] | wagnerrp: | http://www.mythtv.org/wiki/Category:Scripts |
| [19:28:00] | Igramul: | They are not part of the distribution? |
| [19:28:08] | wagnerrp: | although the copies of mythvidexport and find_orphans on there are a bit old |
| [19:28:10] | Igramul: | i.e., the ubuntu packages |
| [19:28:16] | wagnerrp: | i need to clean them up and update them |
| [19:29:44] | jheizer__ is now known as jheizer | |
| [19:31:33] | Igramul: | by the way, what's the difference of defining one input source and linking all tuner cards to it vs. defining one input source per card? |
| [19:31:45] | Igramul: | What is the "myth"-way to do it? |
| [19:32:08] | wagnerrp: | inputs are something enumerated from your card |
| [19:32:12] | wagnerrp: | do you mean "video sources"? |
| [19:32:22] | Igramul: | exactly |
| [19:32:47] | wagnerrp: | a video source is basically a list of channels |
| [19:33:07] | plotino (plotino!~miles@host21-187-dynamic.56-79-r.retail.telecomitalia.it) has quit (Remote host closed the connection) | |
| [19:33:21] | wagnerrp: | you can map the video source to multiple inputs, but each input must be able to access every channel in that list, using the tuning information defined for that channel |
| [19:33:50] | wagnerrp: | in other words, if you've got multiple tuners hooked up to one antenna, they can (and should) share a video source |
| [19:34:09] | wagnerrp: | but say you've got one on antenna and one on cable, they should have different video sources |
| [19:34:15] | Igramul: | Now I understand some issues with my installation... |
| [19:35:01] | emmanuelux (emmanuelux!~emmanuelu@vau92-2-82-228-217-1.fbx.proxad.net) has joined #mythtv-users | |
| [19:35:16] | Igramul: | I have two tuners capable of SD (standard TV resolution) and two tuner cards capable of HD (high definition). |
| [19:35:34] | Igramul: | I should define two different video sources, right? |
| [19:35:47] | wagnerrp: | what tuners, specifically? |
| [19:36:13] | Igramul: | one DVB-S2 card (dual tuner) |
| [19:36:20] | Igramul: | two DVB-S cards |
| [19:37:02] | wagnerrp: | ok, so none of them are capable of SD or HD, since neither term applies to digital tuners |
| [19:37:21] | wagnerrp: | digital tuners just capture whatever data stream is being transmitted |
| [19:37:42] | wagnerrp: | it's left up to the video decoder whether it's actually capable of SD and HD |
| [19:38:13] | devinheitmueller: | wagnerrp: not quite correct. There are cases where either because of hardware limitations or driver bugs, that the net effect is you cannot support the bitrate associated with HD streams. |
| [19:38:14] | wagnerrp: | presumably the -S2 card is also capable of -S? |
| [19:38:36] | Igramul: | wagnerrp: right |
| [19:38:47] | wagnerrp: | devinheitmueller: well sure, and you've told me that before, but those are few and far between, and typically very old |
| [19:38:49] | Igramul: | wagnerrp: devinheitmueller is right |
| [19:39:01] | wagnerrp: | things that internally ran on USB1.1, and similar |
| [19:39:21] | devinheitmueller: | That said, you also cannot guarantee that a DVB-S2 tuner can do DVB-S. It *should* work, but again there are often driver bugs. |
| [19:39:31] | wagnerrp: | but still, it's a question of bitrate, not resolution |
| [19:39:38] | devinheitmueller: | wagnerrp: correct. |
| [19:39:53] | wagnerrp: | and you *could* record HD with those, so long as the channel stayed under the bitrate limit |
| [19:40:28] | Igramul: | devinheitmueller: I suffer from those driver bugs, I gonna replace my tuner hardware sooner or later. Missing records is a no-go (I'm married ;) |
| [19:40:29] | wagnerrp: | anyway... if you can and want to record S content with the S2 tuners, one video source will be a superset of the other |
| [19:40:49] | wagnerrp: | you'll need to scan just the S channels for one source, and then both the S and S2 channels for the other source |
| [19:41:10] | devinheitmueller: | Igramul: which board do you have? |
| [19:41:24] | wagnerrp: | you will end up with duplicate channels that way, but mythtv should automatically merge them for any user interaction |
| [19:41:25] | Igramul: | devinheitmueller: let me check the exact IDs.... |
| [19:42:56] | devinheitmueller: | At this point even just the manufacturer and model are probably good enough. |
| [19:43:08] | wagnerrp: | however you end up configuring it, just understand that you can only have one video source per tuner, and each tuner using that source must be able to tune everything in that source |
| [19:43:17] | wagnerrp: | and you should be fine |
| [19:45:38] | Igramul: | devinheitmueller: http://pastebin.com/y8bUuQM4 |
| [19:45:47] | Igramul: | lspci output |
| [19:46:32] | Igramul: | wagnerrp: currently, I have one video source per tuner |
| [19:46:46] | wagnerrp: | ok, you should be able to halve that |
| [19:47:02] | wagnerrp: | just discard two of the sources, and map those tuners to the remaining pair |
| [19:47:11] | devinheitmueller: | Ah, TBS6980, and a Technicsat. |
| [19:48:19] | Igramul: | right |
| [19:48:55] | Igramul: | sometimes, the TBS card fails to get a lock on most transports |
| [19:49:07] | Igramul: | really annoying |
| [19:49:18] | wagnerrp: | is CI only one tuner for one card? no multi-stream cards like cablecard? |
| [19:50:16] | Igramul: | CI? |
| [19:52:57] | wagnerrp: | common interface, for CAMs, encrypted channels |
| [19:54:32] | xris (xris!~xris@xris.forevermore.net) has joined #mythtv-users | |
| [19:54:32] | xris (xris!~xris@mythtv/developer/xris) has joined #mythtv-users | |
| [19:54:32] | xris (xris!~xris@xris.forevermore.net) has quit (Changing host) | |
| [19:54:33] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v xris | |
| [19:56:03] | Igramul: | I do not watch encrypted channels. |
| [19:56:16] | SteveGoodey (SteveGoodey!~steve@host86-149-167-13.range86-149.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
| [19:59:35] | wagnerrp: | of course not, not on that card with a CI slot |
| [19:59:43] | wagnerrp: | this was just a general question |
| [20:00:18] | wagnerrp: | the similar system over here for cable supports can decode up to six streams at once on a single card |
| [20:00:45] | wagnerrp: | i'm just curious if CI can do the same, or if the cards are only single-stream |
| [20:01:11] | Igramul: | sorry, I have no idea. |
| [20:02:59] | Igramul: | I will dive into that topic in some years when the fta channels will be switched off in central Europe. |
| [20:14:14] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [20:14:51] | blassey (blassey!~blassey@c-71-232-20-86.hsd1.ma.comcast.net) has quit (Remote host closed the connection) | |
| [20:17:24] | [R] ([R]!~rbox@unaffiliated/rbox) has joined #mythtv-users | |
| [20:19:04] | FabriceMG (FabriceMG!~FabriceMG@APoitiers-155-1-143-45.w81-50.abo.wanadoo.fr) has quit (Quit: Ex-Chat) | |
| [20:22:58] | Lomion0815 (Lomion0815!~androirc@178-191-182-244.adsl.highway.telekom.at) has quit (Quit: AndroIRC - Android IRC Client ( http://www.androirc.com )) | |
| [20:23:48] | jarle: | I'm guessing it is not "normal" to have several processes for mythlogserver running? I'm guessing I have to kill some runaway processes.... |
| [20:25:53] | Cubber (Cubber!~ronny@cpe-74-71-250-35.twcny.res.rr.com) has joined #mythtv-users | |
| [20:30:31] | sphery: | jarle: it's not desired--though with some setups, it may be normal :) |
| [20:31:01] | sphery: | there can be problems with it, depending on how/who is running the different apps |
| [20:31:32] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 255 seconds) | |
| [20:31:52] | jarle: | sphery: problem is I have two processes running at 80%+ CPU and one running "normal"... |
| [20:32:18] | sphery: | yeah, if you have multiple running, that's the typical end result |
| [20:32:32] | sphery: | so you'll need to kill some, but it's quite possible they'll come right back |
| [20:32:39] | sphery: | are all 3 being run by the same user? |
| [20:32:52] | jarle: | same user... |
| [20:32:58] | sphery: | non-root user? |
| [20:33:03] | jarle: | sphery: yes |
| [20:33:13] | sphery: | yeah, try just killing the oldest 2 |
| [20:33:29] | sphery: | or some random 2, I suppose |
| [20:35:18] | jarle: | killing the two oldest seem to have done the trick (and logging is still working) |
| [20:38:46] | jarle: | will restarting mysql during a recording, break the recoding? |
| [20:41:58] | Cubber (Cubber!~ronny@cpe-74-71-250-35.twcny.res.rr.com) has quit (Quit: leaving) | |
| [20:44:49] | faichele (faichele!~quassel@p4FCF2F94.dip.t-dialin.net) has quit (Remote host closed the connection) | |
| [20:46:02] | knightr (knightr!~knightr@69.165.170.178) has joined #mythtv-users | |
| [20:46:02] | knightr (knightr!~knightr@69.165.170.178) has quit (Changing host) | |
| [20:46:03] | knightr (knightr!~knightr@mythtv/developer/knightr) has joined #mythtv-users | |
| [20:47:13] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [20:49:37] | skd5aner: | jheizer: you around? |
| [20:51:03] | faichele (faichele!~quassel@p4FCF2F94.dip.t-dialin.net) has joined #mythtv-users | |
| [20:52:43] | andreaz (andreaz!~andre_000@p4FE64A84.dip.t-dialin.net) has joined #mythtv-users | |
| [20:53:22] | [R] ([R]!~rbox@unaffiliated/rbox) has quit (Quit: Leaving) | |
| [20:54:30] | faichele (faichele!~quassel@p4FCF2F94.dip.t-dialin.net) has quit (Remote host closed the connection) | |
| [21:10:41] | Sharky-AFK is now known as Sharky112065 | |
| [21:11:05] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 244 seconds) | |
| [21:20:22] | Sharky112065 is now known as Sharky-AFK | |
| [21:20:37] | stoffel (stoffel!~quassel@pD9E42566.dip.t-dialin.net) has joined #mythtv-users | |
| [21:20:37] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v stoffel | |
| [21:32:59] | andreaz (andreaz!~andre_000@p4FE64A84.dip.t-dialin.net) has quit (Read error: Connection reset by peer) | |
| [21:34:04] | stoffel (stoffel!~quassel@pD9E42566.dip.t-dialin.net) has quit (Remote host closed the connection) | |
| [21:37:46] | blassey (blassey!~blassey@c-71-232-20-86.hsd1.ma.comcast.net) has joined #mythtv-users | |
| [21:43:17] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has joined #mythtv-users | |
| [21:44:10] | dekarl: | I love documentation like "leave this option alone if you don't understand what it does" :) |
| [21:44:33] | [R] ([R]!~rbox@unaffiliated/rbox) has joined #mythtv-users | |
| [21:44:34] | dekarl: | ^- related to signaling of EIT presence |
| [21:51:48] | bobo (bobo!~bobo@ppp-88-217-64-103.dynamic.mnet-online.de) has joined #mythtv-users | |
| [21:52:02] | bobo: | good evening |
| [21:52:53] | bobo: | can anyone tell me if the "Country" value in the settings table in mythconverg affects the timezone of DVB-T transmitted EIT ? |
| [21:53:18] | bobo: | in mythtv-setup i set it to Germany, but in the DB it ends up in US |
| [21:53:36] | wagnerrp: | no, your system timezone affects the timezone of DVB-T transmitted EIT |
| [21:53:54] | wagnerrp: | your country is not, and cannot, be used to denote your timezone |
| [21:54:03] | wagnerrp: | as there are many countries that span multiple timezones |
| [21:54:19] | tlhiv_laptop (tlhiv_laptop!~foo@c-68-35-204-183.hsd1.al.comcast.net) has quit (Ping timeout: 246 seconds) | |
| [21:55:50] | wagnerrp: | country is used for language/locale preferences, and for filtering country-specific artwork and ratings |
| [22:01:46] | bobo: | wagnerrp: ok, thats what i guessed, US to germany would be a bigger difference than the problem i have |
| [22:02:13] | bobo: | my system is using the correct timezone (CET) and using ntp |
| [22:02:45] | jll_ (jll_!~jml974@191.112.233.220.static.exetel.com.au) has quit (Ping timeout: 244 seconds) | |
| [22:02:59] | bobo: | i have just dropped mythconverg entirely and ran mythtv-setup from scratch with "transmitted eit" only |
| [22:03:20] | jll (jll!~jml974@191.112.233.220.static.exetel.com.au) has joined #mythtv-users | |
| [22:03:33] | bobo: | but my EIT data is still one hour behind schedule |
| [22:04:32] | bobo: | there is no offset for transmitted data in the settings, only for xmltv, so i am running out of options |
| [22:04:57] | zombor (zombor!~zombor__@65.29.231.135) has joined #mythtv-users | |
| [22:04:57] | zombor (zombor!~zombor__@65.29.231.135) has quit (Changing host) | |
| [22:04:57] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [22:21:36] | dekarl: | bobo, where do you see the wrong timestamps? |
| [22:22:10] | bobo: | dekarl: in xbmc, but also in mythweb |
| [22:22:40] | dekarl: | can you verify that mythweb is updated to 0.26? There have been reports of accidently running mythweb 0.25 against mythtv 0.26 |
| [22:23:20] | bobo: | let me check, one sec |
| [22:23:41] | dekarl: | if "xbmc" is the new style pvr plugin, that should actually be applying proper conversion from UTC to whatever you have set on the XBMC side |
| [22:23:43] | bobo: | dekarl: yep, 0.26_pre20120430 on gentoo |
| [22:23:52] | pmhahn (pmhahn!~pmhahn@2001:4dd0:ff00:8d31:219:dbff:fef2:e135) has quit (Quit: Konversation terminated!) | |
| [22:24:24] | bobo: | i have tried all kinds of settings on xbmc, thats why i installed mythweb to doublecheck |
| [22:24:39] | dekarl: | you are looking at german dvb-t broadcast or is that austria? |
| [22:24:49] | bobo: | german |
| [22:24:56] | CiaranG (CiaranG!~CiaranG@fsf/member/CiaranG) has quit (Ping timeout: 272 seconds) | |
| [22:24:57] | dekarl: | just guessing as german dvb-t works over here |
| [22:25:52] | bobo: | i kinda habe the same setup on my laptop (newer mythtv version though) and it has been working there all the time |
| [22:26:12] | bobo: | now i moved mythtv to a new gentoo box and its messed up |
| [22:26:53] | stoffel (stoffel!~quassel@pD9E42566.dip.t-dialin.net) has joined #mythtv-users | |
| [22:26:53] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v stoffel | |
| [22:27:00] | zombor (zombor!~zombor__@kohana/developer/zombor) has quit (Read error: Connection reset by peer) | |
| [22:27:09] | CiaranG (CiaranG!~CiaranG@fsf/member/CiaranG) has joined #mythtv-users | |
| [22:27:31] | zombor (zombor!~zombor__@65.29.231.135) has joined #mythtv-users | |
| [22:27:31] | zombor (zombor!~zombor__@65.29.231.135) has quit (Changing host) | |
| [22:27:31] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [22:28:58] | bobo: | i think i'll update my new box to the same version as my laptop (both running gentoo) and see if that fixes the problem. otherwise i have no more ideas |
| [22:29:25] | dekarl: | my only idea would be that the time zone is set to late (after mythbackend starts) or something similiar |
| [22:29:58] | dekarl: | btw, you might want to update to a later version of fixes/0.26 your's is almost a year old |
| [22:30:52] | bobo: | the mythbackend is newer than mythweb, from july |
| [22:32:11] | dekarl: | you are missing critical bug fixes like unbreaking of "two recordings from the same transport starting at the same time" |
| [22:33:01] | Cubber (Cubber!~ronny@cpe-74-71-250-35.twcny.res.rr.com) has joined #mythtv-users | |
| [22:33:25] | bobo: | i just noticed that the hwclock of the new box was off, i just corrected that and rebooted, but after wiping the DB i made sure, that the system clock was synced |
| [22:36:02] | dekarl: | But I did not find timezone/guide related fixes on a quick glance at the changelog |
| [22:36:15] | dekarl: | http://code.mythtv.org/cgit/mythtv/log/?h=fixes/0.26 |
| [22:36:26] | bobo: | but is there a way to check the changes instantly other than wiping the program table in the DB ? |
| [22:36:42] | natanojl: | bobo: 0.26_pre20120430 doesn't sound like 0.26 considering it was released in October |
| [22:37:02] | dekarl: | aye, its master before it was released as 0.26 |
| [22:37:07] | natanojl: | like dekarl already had said :) |
| [22:38:59] | bobo: | that's gentoo ebuild versions |
| [22:39:30] | bobo: | but i'm updating to the latest, which works on my laptop media-tv/mythtv-0.26.0_p20121221 |
| [22:39:46] | bobo: | from last year, but close :) |
| [22:40:19] | bobo: | but do you know how to reset EIT data to test ? |
| [22:40:35] | bobo: | wipe the table? or do i have to run mythtv-setup ? |
| [22:41:05] | dekarl: | bobo, you have to truncate the eit_cache and the guide to get everything populated from scratch |
| [22:41:49] | dekarl: | but I'm not sure what that would do as EIT comes down in UTC and gets put in the database without change (at least thats what the code should do, I didn't verify it ;) |
| [22:42:34] | bobo: | dekarl: by "guide" you mean the "program" table? |
| [22:42:53] | dekarl: | aye, "program" and related tables (for genre, cast) |
| [22:45:19] | bobo: | dekarl: ok, i'll try that after the update is finished. if it doesn't work, ill drop the DB and start from scratch. that should be enough for today then. |
| [22:45:38] | bobo: | thanks guys, i'll be back tomorrow and report :) |
| [22:45:54] | dekarl: | good luck |
| [22:55:11] | sphery: | dekarl: thanks for picking up the audio-language thread for me--I knew you were far more qualified than I |
| [22:55:33] | sphery: | and, fwiw, I wouldn't mind adding in support for storing language information on programs if it's provided by EIT and/or XMLTV |
| [22:56:22] | rOOb (rOOb!~zero@unaffiliated/devicezer0) has joined #mythtv-users | |
| [22:56:43] | dekarl: | sphery: lets see if the data is there first :) |
| [22:56:47] | sphery: | hehe, yeah |
| [22:57:05] | sphery: | I didn't know if your message meant it's there for some people, at least |
| [22:58:56] | rOOb: | hello all. Doing a fresh install of 0.26 on freebsd and I'm in mythtv-setup(x11 forwarding over ssh) and I cannot add my SD video source. I select SD and enter my username and password(double checked i can login to site with same user/pass) and hit retrive lineups...it does its thing...but the data direct lineup selection shows nothing. |
| [22:58:57] | dekarl: | It can be signalled in the EIT, but as the secondary audio is as "original" or something else in the PMT I would not hold my breath |
| [22:59:05] | rOOb: | ive tried several times with no luck |
| [22:59:28] | dekarl: | ^- secondary audio is *signalled* as "original2... |
| [22:59:30] | rOOb: | I tried to continue on and finished mythtv-setup but when i run mythfilldatabase it doesnt grab anything |
| [22:59:43] | sphery: | ah, yeah, that wouldn't be too useful |
| [22:59:57] | rOOb: | reopening mythtv-setup and going to video sources still shows nothing under data direct lineup. |
| [23:00:17] | sphery: | rOOb: let me guess... you have a ton of channels in your lineup? |
| [23:00:29] | rOOb: | in the console i opened mythtv-setup from i see this line: |
| [23:00:31] | rOOb: | QString::arg: Argument missing: "SelectSetting::setValue(): invalid index: -1 size: " , 0 |
| [23:00:48] | sphery: | but the question is, do you see: 2013-01–13 16:03:05.141531 E DDLS: fillSelections did not successfully load selections |
| [23:00:50] | rOOb: | sphery umm..just a normal fios lineup...no more channels then normal? |
| [23:01:02] | sphery: | normal fios lineup = hundreds? |
| [23:01:11] | rOOb: | yea i think so |
| [23:01:21] | rOOb: | ...ive added my fios source before without this issue |
| [23:01:36] | rOOb: | http://pastebin.com/2p3uC0a1 |
| [23:01:40] | dekarl: | sphery: thanks for picking up Thor's question. I always wonder how to setup DVB sources with channel numbers and call signs. (Should simulcast Station and StationHD share a callsign? What about regional variants, etc pp) |
| [23:01:51] | sphery: | rOOb: http://www.gossamer-threads.com/lists/mythtv/users/530709#530709 |
| [23:02:21] | sphery: | dekarl: yeah, for callsign it's mostly up to the user--and really only matters if you actually use "this channel" rules |
| [23:03:31] | rOOb: | sphery ah. ok. that kinds stinks cuz ive already manually removed a bunch of channels from the fios lineup on SD(all the music+ channels i dont watch) |
| [23:03:49] | rOOb: | guess ill have to remove them all then readd them all..then remove the ones i dont want again |
| [23:03:54] | sphery: | I'd say most would prefer same callsign and same channel number (so it shows once in the guide), but then using "any channel" rules and proper schedule order so it chooses to use the best inputs first... but it's a lot of configurability to allow the odd user to say, "record this show on this source and this other show on this other source" |
| [23:04:08] | sphery: | rOOb: one second... |
| [23:04:24] | sphery: | I think there's a fix in, already--just have to make sure it's on -fixes, and then you can just update |
| [23:05:22] | rOOb: | sphery ah...well ive already gone ahead with this |
| [23:05:25] | rOOb: | but thanks :) |
| [23:05:25] | sphery: | rOOb: http://code.mythtv.org/trac/ticket/11287#comment:4 ... seems if you update to 0.26-fixes from after Jan 2, you will likely be OK |
| [23:05:45] | sphery: | might want to update, anyway, to pick up bug fixes |
| [23:05:52] | sphery: | I don't know how hard updating is on FBSD |
| [23:06:08] | dekarl: | I wonder why my EIT on IPTV patch breaks EIT :( But I have a test stream now for end-to-end tests :) http://picpaste.com/iptv-mit-eit-anixe.png |
| [23:06:20] | sphery: | regardless, this should get you past the current issue |
| [23:06:41] | rOOb: | sphery ah right now im using the mythtv from ports and dont wanna go mucking about with things and cause myself alot of issues. |
| [23:06:56] | rOOb: | also that trick worked. grabbed the lineup this time. thanks |
| [23:07:41] | sphery: | cool... sorry for the inconvenience |
| [23:11:18] | rOOb: | np |
| [23:11:48] | stoffel_ (stoffel_!~quassel@pD9E420A9.dip.t-dialin.net) has joined #mythtv-users | |
| [23:11:48] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v stoffel_ | |
| [23:12:04] | stoffel (stoffel!~quassel@pD9E42566.dip.t-dialin.net) has quit (Ping timeout: 252 seconds) | |
| [23:16:14] | stoffel_ (stoffel_!~quassel@pD9E420A9.dip.t-dialin.net) has quit (Remote host closed the connection) | |
| [23:16:59] | dekarl: | Bored and looking for a puzzle? If someone knows Mysql + QT better then me, why does this change break channel lookup? (only finds the first channel of a mux, but not the others) http://paste.ubuntu.com/1529416/ |
| [23:18:35] | rOOb: | is there a way to turn off commercial flagging globally? |
| [23:18:45] | rOOb: | IIRC this used to be a way to do this. |
| [23:19:17] | [R]: | you have to set which hosts it can run on |
| [23:19:19] | [R]: | just unchec kit |
| [23:19:50] | rOOb: | hmm ok |
| [23:24:08] | [mrx] ([mrx]!~mrx]@2001:470:28:196:5054:ff:fe36:a3eb) has quit (Ping timeout: 260 seconds) | |
| [23:27:02] | sphery: | rOOb: you'll also want to disable the commercial detection jobs themselves, otherwise, you'll choke your job queue with tons of jobs that no host is allowed to run |
| [23:27:53] | sphery: | rOOb: either a) set every single channel to be commercial free or b) disable the commercial detection job on every single recording rule |
| [23:28:23] | wagnerrp: | dekarl: because you're filtering for one specific chanid, of course you're only going to get one channel off a mux |
| [23:28:33] | wagnerrp: | unless i'm misunderstanding what you're trying to do |
| [23:28:37] | sphery: | rOOb: the easiest way to do b) is to disable commmercial detection in the Default Recording Rule template, so that when you create new recording rules, they start off with commercial detection disabled |
| [23:28:47] | G (G!njones@torea.jnet.net.nz) has quit (Quit: Reconnecting) | |
| [23:29:28] | wagnerrp: | oh, i'm reading this wrong |
| [23:29:32] | wagnerrp: | i see what you're trying to do |
| [23:31:22] | dekarl: | it wouldn't be a good puzzle if it was that easy ;) |
| [23:31:39] | sphery: | dekarl: doesn't that make 2 different queries in one QString? |
| [23:31:48] | wagnerrp: | sphery: yes |
| [23:31:52] | wagnerrp: | that's the purpose of UNION |
| [23:31:53] | sphery: | oh, wait, is union doing some kind of subquery thing? |
| [23:31:54] | dekarl: | they are combined with the UNION |
| [23:32:00] | wagnerrp: | not sub, merged |
| [23:32:09] | wagnerrp: | the results from both queries are returned in one response |
| [23:32:40] | dekarl: | mysql defaults to UNION DISTINCT, so its one result from the first and the same result from the second query => one result for the case where there is a multiplex |
| [23:32:52] | bas-t (bas-t!~tycho@52484E89.cm-4-1b.dynamic.ziggo.nl) has joined #mythtv-users | |
| [23:33:31] | sphery: | yeah, I don't know my sql well enough to help with that |
| [23:33:31] | wagnerrp: | well you are forcing c1.serviceid to your desired serviceid, so it will only return the one channel from the first query |
| [23:33:44] | dekarl: | But it appears to only return something when looking up the service_id that matches the chanid of the tuned channel |
| [23:33:54] | wagnerrp: | you're looking for all the channels that exist on that mux? |
| [23:34:26] | dekarl: | I'm tuning to chanid x and looking at each service_id that passes by in the EIT |
| [23:34:32] | sphery: | it looks like the where on teh first makes it so you really need 2 queries, so I see why you're going down that path |
| [23:34:49] | wagnerrp: | what data to you want to come out of this query? |
| [23:35:20] | sphery: | why is the first doing c2.chanid = :CHANID in the first place... |
| [23:35:24] | dekarl: | the output is the chanid and useonairguide flag of the channel that matches the service_id |
| [23:35:41] | dekarl: | sphery: service_id is not unique on big satelite lineups |
| [23:35:54] | [mrx] ([mrx]!~mrx]@2001:470:28:196:5054:ff:fe36:a3eb) has joined #mythtv-users | |
| [23:35:56] | wagnerrp: | oh? then how do you filter for a specific channel? |
| [23:36:05] | dekarl: | but it is guaranteed to be unique in one transport |
| [23:36:14] | natanojl: | dekarl: I think you can only use a placeholder once in the statement |
| [23:36:15] | wagnerrp: | but the transport is the multiplex |
| [23:36:31] | sphery: | by why c2 versus c1 |
| [23:36:39] | sphery: | why have channel c1 and channel c2 |
| [23:36:46] | wagnerrp: | so you're retrieving the one channel matching that serviceid off the multiplex |
| [23:36:49] | dekarl: | wagnerrp: exactly, c2 is the channel that got tuned to and c1 is the channel that we see guide data for |
| [23:36:53] | wagnerrp: | it sounds like it's doing what you're asking |
| [23:37:34] | dekarl: | natanojl: that's an idea to verify |
| [23:37:39] | wagnerrp: | no, c1 and c2 are tables, not entries in the table |
| [23:37:42] | sphery: | natanojl: I think it allows multiple usages |
| [23:38:16] | wagnerrp: | so you're currently tuned to one chanid, and you're getting EIT data from some other serviceid |
| [23:38:24] | wagnerrp: | you want the information for the channel of that OTHER serviceid |
| [23:38:25] | wagnerrp: | ? |
| [23:38:44] | dekarl: | wagnerrp: correct, I always get all EIT for the transport as its on the same PID |
| [23:39:07] | wagnerrp: | sounds like you need a subquery |
| [23:39:08] | natanojl: | dekarl, sphery, http://qt-project.org/doc/qt-4.8/qsqlquery.html#bindValue, I might be misreading though and I should really get some sleep |
| [23:39:59] | sphery: | ah, yeah, you're right |
| [23:40:02] | dekarl: | natanojl: meh "Binding to name will bind to the first :name, but not the second.", looks like you might be onto something |
| [23:40:08] | sphery: | was just checking and hadn't gotten there, yet |
| [23:41:11] | dekarl: | that would also explain why the query works in manual testing |
| [23:42:26] | sphery: | dekarl: you've got your EIT dump info, now |
| [23:43:02] | rOOb: | if i want to do a power search from mythweb for a show and record it at anytime on any channel EXCEPT for on saturdays...could i do something like: |
| [23:43:23] | rOOb: | program.title LIKE "BLAH" AND DAYNAME(program.starttime) != "Saturday" |
| [23:45:38] | G (G!njones@torea.jnet.net.nz) has joined #mythtv-users | |
| [23:45:45] | wagnerrp: | SELECT c.chanid,c.useonairguide,c.sourceid FROM (SELECT mplexid FROM channel WHERE chanid=4642) as sub JOIN channel c ON c.mplexid=sub.mplexid WHERE c.serviceid=1; |
| [23:46:03] | wagnerrp: | no reason to bother bringing dtv_multiplex into the query |
| [23:46:13] | ** natanojl hits the sack ** | |
| [23:46:14] | wagnerrp: | make a subquery to find the mplexid of the first |
| [23:46:31] | wagnerrp: | and then JOIN channel back in to the subquery matching that mplexid |
| [23:46:52] | wagnerrp: | dekarl: ^^^ |
| [23:47:02] | dekarl: | sphery: I'm missing the hex dump and what character it should be |
| [23:47:21] | wagnerrp: | only uses the binding points once too |
| [23:47:49] | bentech (bentech!~bentech@host86-148-54-144.range86-148.btcentralplus.com) has quit (Quit: bentech) | |
| [23:48:00] | wagnerrp: | ah, looking at the patch, it's the second query that uses the bindings a second time |
| [23:48:07] | wagnerrp: | well anyway... it's a cleaner query |
| [23:48:42] | dekarl: | the funny thing is that with the patch only the second binding works and the first binding doesn't... But at least the documentation is almost right ;) |
| [23:49:42] | toorima (toorima!~bq@ip70-181-180-210.sd.sd.cox.net) has quit (Remote host closed the connection) | |
| [23:50:00] | tonsofpcs (tonsofpcs!~tonsofpcs@cpe-72-230-192-8.stny.res.rr.com) has quit (Ping timeout: 264 seconds) | |
| [23:50:16] | dekarl: | wagnerrp: I have to lookup behaviour with mplexid==NULL before removing the dtv_multiplex table... There are some MySQLisms lurking in the dark |
| [23:51:03] | natanojl (natanojl!~jonatan@c83-252-237-63.bredband.comhem.se) has quit (Ping timeout: 276 seconds) | |
| [23:51:38] | wagnerrp: | actually, if there is no mplexid, it goes to 32767 rather than NULL |
| [23:53:07] | rOOb: | hmm. that doesnt seem to work :( |
| [23:55:50] | shubes (shubes!~shubes@tacs.shubes.net) has joined #mythtv-users | |
| [23:55:53] | shubes (shubes!~shubes@tacs.shubes.net) has left #mythtv-users () | |
| [23:58:04] | wagnerrp: | dekarl: what about this... |
| [23:58:11] | wagnerrp: | SELECT c.chanid,c.useonairguide,c.sourceid FROM (SELECT chanid,mplexid FROM channel WHERE chanid=4642) as sub JOIN channel c ON c.mplexid=sub.mplexid WHERE c.serviceid=1 AND (c.mplexid != 32727 OR (c.mplexid=32767 AND c.chanid=sub.chanid)); |
| [23:58:34] | wagnerrp: | serviceid is always matched |
| [23:59:07] | wagnerrp: | actually... SELECT c.chanid,c.useonairguide,c.sourceid FROM (SELECT chanid,mplexid FROM channel WHERE chanid=4642) as sub JOIN channel c ON c.mplexid=sub.mplexid WHERE c.serviceid=1 AND (c.mplexid != 32727 OR c.chanid=sub.chanid); |
| [23:59:29] | wagnerrp: | either the mplexid is valid (its on a digital transport), or the chanid matches |
| [23:59:45] | wagnerrp: | with the chanid carried through from the subquery to get rid of the second binding |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.
