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

[Claudio Prono]

Il 03/05/2011 11.35, "T. Bühlmann" ha scritto:
>
> 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
>

It works, thank you very much! :)

Claudio.


-- 
--------------------------------------------------------------------------------
Claudio Prono                         OPST
System Developer               
                                      Gsm: +39-349-54.33.258
@PSS Srl                              Tel: +39-011-32.72.100
Via San Bernardino, 17                Fax: +39-011-32.46.497
10141 Torino - ITALY                  http://atpss.net/disclaimer
--------------------------------------------------------------------------------
PGP Key - http://keys.atpss.net/c_prono.asc