[Akonadi] [Bug 408042] New: Calendar cannot be fetched from server because the login credentials string is too long

[Daniel]

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

            Bug ID: 408042
           Summary: Calendar cannot be fetched from server because the
                    login credentials string is too long
           Product: Akonadi
           Version: unspecified
          Platform: openSUSE RPMs
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: danielinberlin10 at gmail.com
  Target Milestone: ---

Created attachment 120361
  --> https://bugs.kde.org/attachment.cgi?id=120361&action=edit
Text file with error message

The calendar entries cannot be fetched from server because the login
credentials string is too long. I can see all calendars in KOrganizer, but the
calendar display filed remains empty.

Reason seems to be that the domain name of the server is very long.

It is a Horde server.
The client system running Akonadi is an OpenSUSE Leap 15.1.

All other calendars from this horde system can be displayed without problems
(domain name much shorter).

Reason seems to be a database table, column remoteId is to short, see the
following error message (for data protection reasons I have replaced some
letters by x letters, but I did not change the number of letters):


2019-05-25T23:59:16.891848+02:00 loa1 akonadiserver[3907]:
org.kde.pim.akonadiserver: Error while handling command FetchItems on
connection akonadi_davgroupware_resource_3 (0x55628b8621c0)
2019-05-25T23:59:16.895902+02:00 loa1 akonadiserver[3907]: message repeated 3
times: [ org.kde.pim.akonadiserver: Error while handling command FetchItems on
connection akonadi_davgroupware_resource_3 (0x55628b8621c0)]
2019-05-25T23:59:19.334931+02:00 loa1 akonadiserver[3907]:
org.kde.pim.akonadiserver: DATABASE ERROR:
2019-05-25T23:59:19.335251+02:00 loa1 akonadiserver[3907]:
org.kde.pim.akonadiserver:   Error code: "1406"
2019-05-25T23:59:19.335417+02:00 loa1 akonadiserver[3907]:
org.kde.pim.akonadiserver:   DB error:  "Data too long for column 'remoteId' at
row 1"
2019-05-25T23:59:19.335599+02:00 loa1 akonadiserver[3907]:
org.kde.pim.akonadiserver:   Error text: "Data too long for column 'remoteId'
at row 1 QMYSQL3: Der Befehl konnte nicht ausgeführt werden"
2019-05-25T23:59:19.335735+02:00 loa1 akonadiserver[3907]:
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(int, 0))(":1",
QVariant(QString,
"https://www.xxxxx.de/h/rpc.php/calendars/xxxxxx.xxxxxxxxxn@xxxxxxxxx-xxx-xxxxxxxxxxxxxxx.de/calendar~OV5Iqp6YmUNuhCyok2UpkJN/Ham4UixcxFU3Ft6PRqFr9X2.ics#040000008200E00074C5B7101A82E0080000000090B6EB6A4B4BD401000000000000000010000000544F59A1A0F4D341A8CF12EB09461AE62018-10-25T13:00:00+00:00"))(":2",
QVariant(QString, "\"065c4f8744e0ae5a4e2d3ea03efe3b88\""))(":3",
QVariant(QString, ""))(":4", QVariant(qlonglong, 85))(":5", QVariant(qlonglong,
3))(":6", QVariant(QDateTime, QDateTime(2019-05-25 21:59:19.334 UTC
Qt::TimeSpec(UTC))))(":7", QVariant(QDateTime, QDateTime(2019-05-25
21:59:19.334 UTC Qt::TimeSpec(UTC))))(":8", QVariant(bool, false))(":9",
QVariant(qlonglong, 0)))
2019-05-25T23:59:19.335874+02:00 loa1 akonadiserver[3907]:
org.kde.pim.akonadiserver:   Query: "INSERT INTO PimItemTable (rev, remoteId,
remoteRevision, gid, collectionId, mimeTypeId, datetime, atime, dirty, size)
VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9)"
2019-05-25T23:59:19.336000+02:00 loa1 akonadiserver[3907]:
org.kde.pim.akonadiserver: Error during insertion into table "PimItemTable"
"Data too long for column 'remoteId' at row 1 QMYSQL3: Der Befehl konnte nicht
ausgeführt werden"
2019-05-25T23:59:19.336129+02:00 loa1 akonadiserver[3907]:
org.kde.pim.akonadiserver: Error while handling command CreateItem on
connection akonadi_davgroupware_resource_3 (0x55628b8621c0)
2019-05-25T23:59:19.336255+02:00 loa1 akonadi_davgroupware_resource[6897]:
org.kde.pim.akonadicore: Creating/updating items from the akonadi database
failed: "Failed to append item"
2019-05-25T23:59:19.339166+02:00 loa1 akonadi_davgroupware_resource[6897]:
org.kde.pim.akonadicore: Error during ItemSync:  "Failed to append item"

I would be very thankfull if you could have a look at this.

Regards,
Daniel

-- 
You are receiving this mail because:
You are the assignee for the bug.