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

[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.


-- 
--------------------------------------------------------------------------------
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