[horde] Problems with Horde 4 and Active Sync.....

["T. Bühlmann"]

Am 03.05.2011 11:26, schrieb Claudio Prono:
>
> Il 02/05/2011 11.58, Claudio Prono ha scritto:
>> Hello all,
>>
>> I am testing Horde 4 with Active Sync, but i have a problem : the
>> database tables for the active sync was not created, so the application
>> when try to access to them, sends me an error like this:
>>
>>
>>       QUERY FAILED: Table 'horde4.horde_activesync_device' doesn't exist
>>       SELECT d.device_id device_id, device_type, device_agent,
>>       device_policykey, device_rwstatus, device_user FROM
>>       horde_activesync_device d INNER JOIN horde_activesync_device_users
>>       u ON d.device_id = u.device_id
>>
>> 1. Horde_ActiveSync_State_History->listDevices() /srv/www/horde.new/admin/activesync.php:53
>>
>>
>> How i can create te the appropriate tables? I have read this: http://wiki.horde.org/ActiveSync
>>
>> It says... "The SQL tables that horde uses are created as usual from the Horde configuration screen."....but where? I don't find any method to create the missing SQL tables...
>>
>> Any hint?
>>
>> Cordially,
>>
>> Claudio Prono.
>>
>>
> I repost the same question, i have done some more testing. I have clean
> installed a new Horde 4 (with empty database), and there is some problem
> with the database creation.
>
> After setting up the mysql database, some tables are not created, so the
> horde tells me:
>
> QUERY FAILED: Table 'horde4.horde_alarms' doesn't exist SELECT alarm_id,
> alarm_uid, alarm_start, alarm_end, alarm_methods, alarm_params,
> alarm_title, alarm_text, alarm_snooze, alarm_internal FROM horde_alarms
> WHERE alarm_dismissed = 0 AND ((alarm_snooze IS NULL AND alarm_start <=
> '2011-05-03T09:27:20') OR alarm_snooze <= '2011-05-03T09:27:20') AND
> (alarm_end IS NULL OR alarm_end >= '2011-05-03T09:27:20') AND (alarm_uid
> IS NULL OR alarm_uid = '' OR alarm_uid = 'Administrator') ORDER BY
> alarm_start, alarm_end
>
> In fact, the table horde_alarms into the database horde4 is not present.
>
> But the web interface tells me "database ready", and there is no way to
> do an update database.
>
> Any hint on this? Is a bug?
>
> Cordially,
>
> Claudio Prono.
>
>
Try to run the /usr/bin/horde-db-migrate

I had the same problem with database generation over the web-interface.
Running this prog fixed that for me.
Tom