Akonadi Database Error With Exchange Calendar

[Garry Williams]

On Mon, Jan 29, 2018 at 11:54 AM, I wrote:
> I have been using davmail[*], a java proxy server for Exchange.  It
> seems to be very robust, but also very slow.  But it is reliable for
> the Exchange server I need for work.  The davmail server uses the OWA
> interface to Exchange and proxies IMAP mail and all the calendar
> functions and LDAP contact lists.

Well the Exchnage calendar quit working sometime ago.  I finally
decided to figure out the problem.  It turns out that the OWA item
URLs are very long now.  And the database definition for the column to
store that URL is VARCHAR(255).

To get the calendar to work again I had to alter the database table
pimitemtable:

    alter table pimitemtable modify column remoteId varchar(1024);

Akonadi has to be shut down to alter the table since it apparently
holds locks otherwise.  You can do that with

    akonadictl stop

And then start mysql using the same command line that akonadi uses
which you copied from a ps -ef display.

Anyway, if you were using davmail and calendar stopped working this is
probably the fix for you.

See https://bugs.kde.org/show_bug.cgi?id=394839

_____________
[*] http://davmail.sourceforge.net/

-- 
Garry Williams