[horde] Unable to locate the tz database

[Per olof Ljungmark]

On 2014-09-25 15:41, Arjen de Korte wrote:
> Citeren Per olof Ljungmark <peo at bsdlabs.com>:
> 
>> Quoting Jan Schneider <jan at horde.org>:
>>
>>> Zitat von Per olof Ljungmark <peo at bsdlabs.com>:
>>>
>>>> On 2014-09-23 13:56, Jan Schneider wrote:
>>>>>
>>>>> Zitat von Per olof Ljungmark <peo at bsdlabs.com>:
>>>>>
>>>>>> Horde 5.2.1
>>>>>> Kronolith 4.2.2
>>>>>>
>>>>>> The following error is logged when syncing calendars via CalDAV:
>>>>>>
>>>>>> HORDE: [kronolith] Unable to locate the tz database. [pid 31107 on
>>>>>> line
>>>>>> 729 of "/usr/local/www/horde/kronolith/lib/Event.php"]
>>>>>>
>>>>>> with DEBUG:
>>>>>>
>>>>>>
>>>>>> Sep 21 12:40:39 <local3.debug> webmail HORDE: [kronolith]
>>>>>> Horde_HashTable_Memcache: Retrieved keys
>>>>>> (horde:history:kronolith:_Zm2C1DejoL0EWYsj5t1sg2:15D7E401-A7DD-4B47-8C6D-16C1D0CDE4A8)
>>>>>>
>>>>>>
>>>>>> [pid 67499 on line 233 of
>>>>>> "/usr/local/share/pear/Horde/HashTable/Base.php"]
>>>>>> Sep 21 12:40:39 <local3.debug> webmail HORDE: [kronolith]
>>>>>> Horde_HashTable_Memcache: Non-existent keys
>>>>>> (horde_timezone,horde_timezone_t) [pid 67499 on line 240 of
>>>>>> "/usr/local/share/pear/Horde/HashTable/Base.php"]
>>>>>> Sep 21 12:40:39 <local3.debug> webmail HORDE: SQL  (0,0002s)      
>>>>>> SELECT
>>>>>> id_interface FROM horde_dav_collections WHERE id_external =
>>>>>> 'calendar:8zg_EyXQcX0p71KDzfEPFA1' [pid 68119 on line 208 of
>>>>>> "/usr/local/share/pear/Horde/Db/Adapter/Pdo/Base.php"]
>>>>>> Sep 21 12:40:39 <local3.warn> webmail HORDE: [kronolith] Unable to
>>>>>> locate the tz database. [pid 67499 on line 729 of
>>>>>> "/usr/local/www/horde/kronolith/lib/Event.php"]
>>>>>> Sep 21 12:40:39 <local3.debug> webmail HORDE:
>>>>>> Horde_HashTable_Memcache:
>>>>>> Retrieved keys
>>>>>> (perm_sql_exists_2kronolith,perm_sql_exists_2kronolith_t)
>>>>>> [pid 68119 on line 233 of
>>>>>> "/usr/local/share/pear/Horde/HashTable/Base.php"]
>>>>>>
>>>>>>
>>>>>> horde_timezone,horde_timezone_t is not present in
>>>>>> Horde_HashTable_Memcache ? Should it be?
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> //per
>>>>>
>>>>> $conf['timezone']['location'] in horde/config/conf.php
>>>>>
>>>>
>>>> Is set to:
>>>> $conf['timezone']['location'] =
>>>> 'ftp://ftp.iana.org/tz/tzdata-latest.tar.gz';
>>>
>>> It may not be available from your location/server.
>>
>> It is.
>>
>>>> Data seems to be stored in (FreeBSD):
>>>> /usr/local/share/pear/tests/Horde_Timezone/Horde/Timezone/
>>>
>>> No.
>>
>> OK, but at least there is tz data there, for example in
>> /usr/local/share/pear/tests/Horde_Timezone/Horde/Timezone/fixtures/europe
>>
>> And where *should* it be then?
> 
> It is easier to debug to download the timezone from
> ftp://ftp.iana.org/tz/tzdata-latest.tar.gz to a locally accessible
> location and then point Horde to that local copy via
> 
> $conf['timezone']['location'] =
> 'file:///var/cache/horde/tzdata-latest.tar.gz';
> 
> By doing so you can make certain that the file is there. I actually use
> this in production too and use a cronjob to download it again once a
> month or so.

OK, it worked, thank you for the tip.

Then of course one could wonder how it is supposed to work...

//per