[mythtv-users] Mythfilldatabase uses wrong time information

[Ramon Hofer]

Hi all

My TV program listings in MythTV is one hour late. E.g. a showing that 
starts at 2 pm is listed in Mythweb and the frontend guide to start at 3 pm.
I live in Switzerland and but use the en_US.UTF-8 UTF-8 setting in my 
/etc/locale.gen because I want my system to speak English and there is 
no such setting for Switzerland.


The timezone setting on the machine seems correct (Zurich is in 
Switzerland):

$ diff -s /etc/localtime /usr/share/zoneinfo/`cat /etc/timezone`
Files /etc/localtime and /usr/share/zoneinfo/Europe/Zurich are identical



When I enter:
$ date
I get the correct time.



I changed the country in my /usr/share/mythtv//locales/en_us.xml to CH 
(Switzerland):

<?xml version="1.0" encoding="UTF-8" ?>
<mythlocale>
<!-- Global Settings -->
<!-- EIT, Subtitle, Audio Stream Language Preferences -->
<setting name="ISO639Language0" global="true">eng</setting>
<setting name="ISO639Language1" global="true">eng</setting>

<!-- Recording -->
<setting name="TVFormat" global="true">NTSC</setting>
<setting name="VbiFormat" global="true">NTSC Closed Caption</setting>
<setting name="FreqTable" global="true">us-bcast</setting>

<!-- Scheduling -->

<!-- Advert Detection -->


<!-- Per-host Settings -->
<!-- Languages - Self Explanatory -->
<setting name="Language">en_US</setting>

<!-- Country -->
<setting name="Country">CH</setting>

<!-- Date/Time format -->
<setting name="DateFormat">ddd MMM d yyyy</setting>
<setting name="TimeFormat">h:mm AP</setting>
<setting name="ShortDateFormat">M/d</setting>

<!-- Playback -->

<!-- Plugins -->
<!-- MythArchive -->
<setting name="MythArchiveVideoFormat">NTSC</setting>

<!-- Date/Time format -->
<setting name="MythArchiveDateFormat">%a %b %d %Y</setting>
<setting name="MythArchiveTimeFormat">%I:%M %p</setting>
</mythlocale>


Here's the ouptut of mythfilldatabase:

$ sudo -u mythtv mythfilldatabase --refresh-today

2011-05-14 14:18:14.669 Using runtime prefix = /usr
2011-05-14 14:18:14.669 Using configuration directory = 
/var/lib/mythtv/.mythtv
2011-05-14 14:18:14.669 Empty LocalHostName.
2011-05-14 14:18:14.669 Using localhost value of media-server
2011-05-14 14:18:14.675 New DB connection, total: 1
2011-05-14 14:18:14.676 Connected to database 'mythconverg' at host: 
localhost
2011-05-14 14:18:14.679 Closing DB connection named 'DBManager0'
2011-05-14 14:18:14.679 Connected to database 'mythconverg' at host: 
localhost
2011-05-14 14:18:14.680 Current locale EN_US
2011-05-14 14:18:14.680 Reading locale defaults from 
/usr/share/mythtv//locales/en_us.xml
2011-05-14 14:18:14.684 Loading en_gb translation for module mythfrontend
2011-05-14 14:18:14.685 Current MythTV Schema Version (DBSchemaVer): 1264
2011-05-14 14:18:14.686 New DB connection, total: 2
2011-05-14 14:18:14.687 Connected to database 'mythconverg' at host: 
localhost
2011-05-14 14:18:14.708 Updating source #1 (Analog Kabel Cablecom) with 
grabber tv_grab_ch_search
2011-05-14 14:18:14.709 Found 30 channels for source 1 which use grabber
2011-05-14 14:18:14.804 Grabber has capabilities: baseline manualconfig 
cache
2011-05-14 14:18:14.804
2011-05-14 14:18:14.804 Checking day @ offset 0, date: Sat May 14 2011
2011-05-14 14:18:14.804 Data Refresh needed because of user request
2011-05-14 14:18:14.804 Refreshing data for Sat May 14 2011
2011-05-14 14:18:14.804 New DB connection, total: 3
2011-05-14 14:18:14.805 Connected to database 'mythconverg' at host: 
localhost
2011-05-14 14:18:14.805 XMLTV config file is: 
/var/lib/mythtv/.mythtv/Analog Kabel Cablecom.xmltv
2011-05-14 14:18:14.805 New DB connection, total: 4
2011-05-14 14:18:14.805 Connected to database 'mythconverg' at host: 
localhost
2011-05-14 14:18:31.497 New DB connection, total: 5
2011-05-14 14:18:31.497 Connected to database 'mythconverg' at host: 
localhost
2011-05-14 14:18:31.540 IconData: Updating icons for sourceid: 1
2011-05-14 14:18:31.591 New DB connection, total: 6
2011-05-14 14:18:31.591 Connected to database 'mythconverg' at host: 
localhost
2011-05-14 14:18:32.138 Updated programs: 17 Unchanged programs: 1014
...



I have absolutely no clue what to do to get the correct times.


Cheers
Ramon