LinHES Forums
http://forums.linhes.org/

Zap2it...just can't get times right
http://forums.linhes.org/viewtopic.php?f=17&t=6361
Page 1 of 1

Author:  b.askew [ Sun Oct 09, 2005 8:32 pm ]
Post subject:  Zap2it...just can't get times right

After installation everything is working so well, overall I am very satisfied with the ease of installation and that my hardware worked so perfectly after installation. Now, to my problem.
Zap2it is 5 hours off...I have seen so many others who have had this same issue and have been advised by others to fix the time zone and date on their machine. Try tzconfig, and then clear your channel settings and re-run mythfilldatabase in order to populate the EPG for Myth.
No matter what I seem to do there is this gap where my computer says its 2pm for example the EPG reads like what is on at 2pm is what was on 5 hours earlier, and what is really playing live is on the EPG at 7pm. So any recoreded shows show the wrong description and title, of course. The only way I can compensate is to change my local time zone to match the difference EPG, which is set my local to 5 hours ahead of the actual time. I have tried many settings with tzconfig, and then clear my channel settings by running mythtv-setup, then mythfilldatabase.
I also have tried changing the settings inside of MythTV called the offset, but it does nothing.
I know this has been coverd by I cannot seem to clear this up
Regards

Author:  tjc [ Sun Oct 09, 2005 9:10 pm ]
Post subject: 

Did you reboot the machine after you made the timezone change? Or at the very least restart the mythbackend and mysql servers?

What do the following commands show?
Code:
date
tail -500 /var/log/mysql/mysql.log | grep '^05'

Author:  b.askew [ Sun Oct 09, 2005 9:53 pm ]
Post subject: 

tjc wrote:
Did you reboot the machine after you made the timezone change? Or at the very least restart the mythbackend and mysql servers?

That's hard to answer, I'm sure I did but maybe not after each time I changed my time zone settings.

tjc wrote:
What do the following commands show?
Code:
date
tail -500 /var/log/mysql/mysql.log | grep '^05'

Code:
root@mythtv:~# date
Mon Oct 10 03:53:31 GMT-5 2005
root@mythtv:~# tail -500 /var/log/mysql/mysql.log |grep '^05'
051009 22:53:08      87 Query       SELECT NULL
051009 22:53:09      87 Query       SELECT NULL
051009 22:53:36      14 Query       SELECT NULL


From what I understand, Zap2it uses UTC for their program data. So I don't know how to make up for the difference in Myth. If I set my local time correct, then the EPG is off. What the problem appears to be is that linux shows UTC to be what my time actually is, when UTC should be off by 5 hours according to where I am. So...when I set my local time it changes to be -5 hours from UTC which is wrong in the 1st place, so I guess if there is a way to change this, that should fix it.
Another idea (I will try this when I get home) is to change the hardware clock to set to local time, and not UTC...just a thought.

Author:  b.askew [ Mon Oct 10, 2005 9:08 am ]
Post subject: 

Sorry for replying to my own post, but I think this is crazy so...

I've noticed that my UTC after setting tzconfig to my time zone is actually setting UTC to my local time, it shouldn't be doing this. On my other linux box, I run tzconfig, set to Central time.
Code:
Local time is now:      Mon Oct 10 10:07:02 CDT 2005.
Universal Time is now:  Mon Oct 10 15:07:02 UTC 2005.

so this is what it should say. Now, on the mythtv box i set tzconfig to the exact same and it says UTC is the same as the actual local time (10:07:02), then Local time is -5 hours from that time?!?!? I don't know why linux is confused about this. I'm sure this is my problem, fixing it is another issue that may not belong in this forum.

Author:  tjc [ Mon Oct 10, 2005 6:06 pm ]
Post subject: 

Your problem should be obvious from the command output. Here's what my (working) system shows:
Code:
root@black2:/etc# date ; tail -50 /var/log/mysql/mysql.log | grep '^05'
Mon Oct 10 09:35:45 EDT 2005
051010  9:32:21    1384 Query       SELECT NULL
051010  9:33:21    1384 Query       SELECT NULL
051010  9:34:21    1384 Query       SELECT NULL
051010  9:35:21    1384 Query       SELECT NULL

Note that the times are the same.

To fix your problem, as root run the tzsetup command and set your local timezone and then your local time, then either reboot (less ways to screw up) or restart the backend and mysql. After that, rerun mythtv-setup and drop all your guide info, finally run su mythtv -c "mythfilldatabase" to refill your guide.

Author:  b.askew [ Tue Oct 11, 2005 7:39 am ]
Post subject: 

First of all, let me say I didn't even notice that so thanks for pointing that out. But what I did was once I figured out my system time was wrong I used ntpdate by pointing it to a server and it corrected my UTC time, and then used tzconfig and set my local time right, rebooted, then did the mythtv-setup and mythfilldatabase as you suggested, that did it!
Thanks again

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/