[horde] ActiveSync failing on fresh install with Horde 5.0.3

Thu Jan 24 10:34:22 UTC 2013

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

> Quoting Jan Schneider <jan at horde.org>:
>
>> 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?
>>
>
> Yes that is correct, all schemas are marked as 'DB Schema is ready'.
>
>>> 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?
>>
>
> mysql> select * from horde_activesync_schema_info;
> +---------+
> | version |
> +---------+
> |       3 |
> +---------+

Not good. Especially since:

> The only file that makes any sense that contains the word 'version'  
> in pear/data/Horde_ActiveSync/ is the file  
> migration/7_horde_activesync_clearstate.php but this is a comment  
> and references clearing the collection state when moving between  
> version 1 and 2.
>
> If there is a different file that I should be looking at.  All my  
> references are from the directory that contains two directories  
> which are horde/ and pear/.

The version is leading number of the migration script. Which means  
that you *at least* have migration up to version 7 (version 9 is what  
adds the cache table). Yet your schema has only been updated to  
version 3.

This could only happen if:
- There was an error during the migration
AND
- The schema is still listed as outdated
OR
- Horde cannot determine the highest schema version for some reason,  
e.g. because it cannot read the migration/ directory.

>>> 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/
>>
>> -- 
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
> Thanks,
>
> Brett

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