[horde] ActiveSync failing on fresh install with Horde 5.0.3

[Jan Schneider]

Zitat von Brett Lumsden <horde at controlunlimited.net>:

> Hello
>
> I'm hoping someone may be able to point me in the direction with the  
> issue I am experiencing with Horde & ActiveSync, the initial setup  
> works fine, I am not using auto discovery so I simply enter all the  
> required details.  As I am using Android I left email on to sync,  
> however I dont actually want this but was recommended by the Wiki  
> page http://wiki.horde.org/ActiveSync#toc11 in relation to 4.1.2,  
> even though I am running 4.1.1 (Galaxy Note 2).
>
> In the process of trying to debug the issue I am experiencing I  
> enabled the Custom logging and received the following output in the  
> log, this occurs every 2 - 3 seconds and the device constantly  
> attempts to sync.
>
> 2013-01-23T04:01:17+00:00 DEBUG: [4220] FOLDERSYNC request received  
> for user wizrd
> 2013-01-23T04:01:17+00:00 DEBUG: [SEC1FABA1B0D2F5E] loadDeviceInfo: wizrd
> 2013-01-23T04:01:17+00:00 INFO: Request being handled for device:  
> SEC1FABA1B0D2F5E Supporting protocol version: 12.1
> 2013-01-23T04:01:17+00:00 INFO: [4220] Handling FOLDERSYNC command.
> 2013-01-23T04:01:17+00:00 DEBUG: [SEC1FABA1B0D2F5E] Checking  
> policykey for device: 0 user: wizrd
> 2013-01-23T04:01:17+00:00 DEBUG: Policykey: 0 verified.
> 2013-01-23T04:01:17+00:00 DEBUG: [4220] I <FolderHierarchy:FolderSync>
> 2013-01-23T04:01:17+00:00 DEBUG: [4220] I  <FolderHierarchy:SyncKey>
> 2013-01-23T04:01:17+00:00 DEBUG: [4220] I    0
> 2013-01-23T04:01:17+00:00 DEBUG: [4220] I   </FolderHierarchy:SyncKey>
> 2013-01-23T04:01:17+00:00 DEBUG:  
> [Horde_ActiveSync::handleFolderSync] syncKey: 0
> 2013-01-23T04:01:17+00:00 DEBUG: [4220] Resetting device state for  
> device: SEC1FABA1B0D2F5E, user: wizrd, and collection: foldersync.
> 2013-01-23T04:01:17+00:00 ERR: SQLSTATE[42S02]: Base table or view  
> not found: 1146 Table 'webmail6.horde_activesync_cache' doesn't exist
> 2013-01-23T04:01:17+00:00 DEBUG: [4220] O  <FolderHierarchy:FolderSync>
> 2013-01-23T04:01:17+00:00 DEBUG: [4220] O   <FolderHierarchy:Status>
> 2013-01-23T04:01:17+00:00 DEBUG: [4220] O     9
> 2013-01-23T04:01:17+00:00 DEBUG: [4220] O   <FolderHierarchy:Status/>
> 2013-01-23T04:01:17+00:00 DEBUG: [4220] O  <FolderHierarchy:FolderSync/>
> 2013-01-23T04:01:17+00:00 INFO: [4220] User wizrd logged off
>
> I believe I am reading the error message correctly that the Table  
> webmail6.horde_activesync_cache doesn't exist and this is the cause  
> of the sync failing, however I'm not 100% sure this is the cause of  
> the sync failing and am looking for a little guidance.

It is.

> In an attempt to resolve the issue I did delete both the horde and  
> pear directories, I installed pear in a separate location as the  
> system instance of pear is being used by an old installation of  
> Horde and this is my test bed until I can get it up and running and  
> finish the migration from a horde 4 alpha that seems to break in  
> really horrible ways everytime I have tried in place upgrades.
>
> After reinstalling both (Pear and Horde) following the instructions  
> at http://www.horde.org/apps/horde/docs/INSTALL and still I am  
> having no luck getting the sync to work.
>
> In a last ditch effort I have updated MySQL & PHP in case this was  
> the cause of my issues.  It is important for me to point out that  
> Horde, IMP & Kronolith all appear to work alright, Kronolith has a  
> few hiccups but in Basic mode works fine (Dynamic is a little broken).
>
> I believe because I have installed pear in a separate directory I  
> haven't been able to run pear/horde-db-migrate which errors with  
> errors pointing straight to the original installation of Horde (The  
> still current one).
>
> Does anyone have any other suggestions as to what I could try?
>
> Thanks,
>
> Brett

Why don't you run the database migration scripts from the  
adminstration interface instead (configuration section)?
-- 
Jan Schneider
The Horde Project
http://www.horde.org/