View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 6 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sun Oct 09, 2005 8:32 pm 
Offline
Joined: Sun Oct 09, 2005 8:13 pm
Posts: 24
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


Top
 Profile  
 
 Post subject:
PostPosted: Sun Oct 09, 2005 9:10 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
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'


Top
 Profile  
 
 Post subject:
PostPosted: Sun Oct 09, 2005 9:53 pm 
Offline
Joined: Sun Oct 09, 2005 8:13 pm
Posts: 24
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.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Oct 10, 2005 9:08 am 
Offline
Joined: Sun Oct 09, 2005 8:13 pm
Posts: 24
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.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Oct 10, 2005 6:06 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
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.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Oct 11, 2005 7:39 am 
Offline
Joined: Sun Oct 09, 2005 8:13 pm
Posts: 24
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


Top
 Profile  
 

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


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 4 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