[horde] ActiveSync failing on fresh install with Horde 5.0.3

[Jan Schneider]

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

> Quoting Jan Schneider <jan at horde.org>:
>> 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/
>>
>> -- 
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
> Hi Jan,
>
> Thanks for your help, during the installation all of the databases  
> were listed as DB schema is out of date.  After clicking the button  
> Update all DB schemas  all databases including Horde_Activesync  
> report as "DB schema is ready" and the three applications I  
> currently have installed as listed as "Application is ready".  There  
> are no errors displayed in horde, apache error log or mysqld log to  
> indicate that tables could not be created.
>
> From the original message I am mostly concerned about the syncing  
> attempt from the device occurring every 2 to 3 seconds and never  
> actually completing.  My main issue, which I am not 100% sure is  
> related is the error message "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" would this actually  
> cause the sync to fail?

So you are still getting this error message even though all migration  
ran without an error, and all schemas are marked up to date?

> If this is the cause of the failure is there anyway to force the  
> creation or can someone provide a MySQL formatted version of these  
> tables so I can manually add them?
>
> In an attempt to get the table to be created I have delete all  
> horde_activesync_* tables from the database, refreshed the web  
> interface and clicked the Update all DB schemas button.  The  
> following tables are created by updating the DB schemas using the  
> web interface.
>
> mysql> show tables like '%activesync%';
> +-------------------------------+
> | Tables_in_webmail6 (%ctive%)  |
> +-------------------------------+
> | horde_activesync_device       |
> | horde_activesync_device_users |
> | horde_activesync_map          |
> | horde_activesync_schema_info  |
> | horde_activesync_state        |
> +-------------------------------+

This doesn't make sense, because you indeed have the cache table  
missing. What version number do you have in the  
horde_activesync_schema_info table, what's your Horde_ActiveSync  
version, and which is the highest number in your ActiveSync migration  
scripts?

> From looking through the files in  
> pear/data/Horde_ActiveSync/migration/ I am concerned that there  
> might be more than just the horde_activesync_cache table missing.   
> However not being familiar enough with Horde 5 yet I am not 100% sure.
>
> Is there an alternative way to actually trigger the creation of the  
> missing tables considering the Configuration screen shows the DB  
> Schema to be ready?
>
> Also I have tried to fix the database using the horde-db-migrate  
> script from the pear directory however the script errors when I run  
> it, I am guessing here but I think it is throwing errors because I  
> have installed pear in a new location rather than updating the  
> system version of it.
>
> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>
>>
>> If you don't want your install to provide email, you can disable it  
>> in the administrative interface. This "mocks" the email support, so  
>> the device thinks it is working.
>> -- 
>> mike
>>
>> The Horde Project (www.horde.org)
>> mrubinsk at horde.org
>
> Hi Mike,
>
> Thanks for the assistance, I don't have a need for ActiveSync to  
> provide email as I already have K9-Mail setup to access my mailbox  
> via IMAP.  I left it enabled initially as was recommended by  
> http://wiki.horde.org/ActiveSync#toc11 - The entry for Samsung  
> Galaxy Nexus 4.1.2 (Jelly Bean) to ensure the initial folder sync  
> occurred.  As I can't seem to even get the initial folder sync to  
> happen email syncing at the moment is the last of my worries.
>
> Quoting Luis Felipe Marzagao <lfbm.andamentos at gmail.com>:
>>
>> That´s what I did here and sync is working just fine in two Galaxy  
>> Note 2 devices, with multiple horde accounts. But I always leave  
>> email sync on in the device. If I turn it off, calendar won´t work.
>>
>> -- 
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
> Thanks for the input Luis, I'm glad to know that I should be able to  
> get it work, as mentioned above to Jan it may be related to the  
> issue with the table creation :(
>
> I really appreciate the tip that I will have to leave email syncing  
> enabled otherwise the calendar may stop syncing!
>
> Thanks for any further assistance anyone can provide.
>
> Brett


-- 
Jan Schneider
The Horde Project
http://www.horde.org/