View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 7 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Wed Dec 28, 2005 4:05 am 
Offline
Joined: Sun Oct 09, 2005 6:31 pm
Posts: 52
My setup is in my sig below.
Running Knoppmyth R5A16

I noticed that I can't seem to be able to disable commercial skipping. I have it configured to skip by default in mythfrontend setup (screens of my config here:
http://www.ph.utexas.edu/~daneel/wierdness.html
)

However, I then start watching a recording, then goto the OSD menu to set the commercial skip to OFF (to counter a false positive made by mythcommflag) but mythtv skips the commercial anyways (even after restarting the backend and the mysql server). I disabled the commercial skipping altigether in mythfrontend setup but the commercials skip anyways.

I saw nothing that could be related to this problem in mythbackend logs ( The latest unrotated log is posted at:
http://www.ph.utexas.edu/~daneel/mythbackend.log
)

Wondering if this could be a problem with the database or something. This problem occurs both in the local frontend from the tv and remotely from another compu in the lan

I'd be real grateful for some guidance on how to analyse this problem (I dunno any sql, but I can connect to the database via gui or shell and follow instructions and stuff)

I did mess with mysql a bit before this started to happen:

I got rid of some unsecure system users named "Debian-system" or something in mysql using mysql-administrator GUI

I also had to change the user in /etc/mysql/debian.cnf from that "Debian-system" to "mythtv" with the password for mythtv

I had to grant SHUTDOWN privilege to user mythtv (followed a howto in mysql's website for that) bcause the system user (presumably) was shutting down mysql and had that privilege and now mythtv user needs the same privilege else it shuts down mysql by killing te pid and I've read that that can damage mysql tables or something so...)


could any of the above have caused this problem with commercials? I can't see how they could be related. I checked the database tables for corruptions but didn't get any.

I'd appreciate some help.

Thanks,
AR

_________________
My knoppmyth system:
P-III 850 MHz
256 Mb RAM
Hauppauge PVR-350 connected to tv via tv-out
Hauppauge PVR-150 in another PCI slot
using ivtv version 0.8.2 in Knoppmyth R5E50
PVR is both frontend and backend


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 28, 2005 7:10 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
What does this show?
Code:
mysql -u root mythconverg -e "select * from settings where value='AutoCommercialSkip'"

Oh, and did you convert the commercial markup to a real cutlist (which is always honored)?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 28, 2005 8:41 pm 
Offline
Joined: Sun Oct 09, 2005 6:31 pm
Posts: 52
tjc wrote:
What does this show?
Code:
mysql -u root mythconverg -e "select * from settings where value='AutoCommercialSkip'"


Thanks for your reply. I changed the root login to the non-default "mysqlroot" and have set a password, so I had to enter (click on pastebin):

http://pastebin.ca/35118


Quote:
Oh, and did you convert the commercial markup to a real cutlist (which is always honored)?


I think I may have. That could be it. I'll check with a new recording.

_________________
My knoppmyth system:
P-III 850 MHz
256 Mb RAM
Hauppauge PVR-350 connected to tv via tv-out
Hauppauge PVR-150 in another PCI slot
using ivtv version 0.8.2 in Knoppmyth R5E50
PVR is both frontend and backend


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 28, 2005 8:47 pm 
Offline
Joined: Sun Oct 09, 2005 6:31 pm
Posts: 52
erm, That was it. My cutlist was still loaded in the recording as you pointed out. I tried to disable commskip on a fresh recording and it worked fine, heh! :oops:


I'll look at the mythtv docs to find out if there is a key to unload a cutlist and bind it to a button in my remote. Shuld work.

_________________
My knoppmyth system:
P-III 850 MHz
256 Mb RAM
Hauppauge PVR-350 connected to tv via tv-out
Hauppauge PVR-150 in another PCI slot
using ivtv version 0.8.2 in Knoppmyth R5E50
PVR is both frontend and backend


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 28, 2005 8:52 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
hari_seldon99 wrote:
http://pastebin.ca/35118

Well, that pretty much explains it. Those values should be 0 if it's disabled. Running this bit of SQL should fix that:
Code:
update settings set data = '0' where value = 'AutoCommercialSkip';


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 28, 2005 8:55 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
hari_seldon99 wrote:
I'll look at the mythtv docs to find out if there is a key to unload a cutlist and bind it to a button in my remote. Shuld work.

The key is "c" for clear I think... See this page: http://www.knoppmythwiki.org/index.php?page=HowToUseMyth


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 28, 2005 11:58 pm 
Offline
Joined: Sun Oct 09, 2005 6:31 pm
Posts: 52
tjc wrote:
hari_seldon99 wrote:
I'll look at the mythtv docs to find out if there is a key to unload a cutlist and bind it to a button in my remote. Shuld work.

The key is "c" for clear I think... See this page: http://www.knoppmythwiki.org/index.php?page=HowToUseMyth


Both c & q work. Thanks for clearing this up. I lookedin the "mythtv-keys" page on my mythweb setup

AR

_________________
My knoppmyth system:
P-III 850 MHz
256 Mb RAM
Hauppauge PVR-350 connected to tv via tv-out
Hauppauge PVR-150 in another PCI slot
using ivtv version 0.8.2 in Knoppmyth R5E50
PVR is both frontend and backend


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: Bing [Bot] and 25 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu