maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   SailfishOS (https://talk.maemo.org/forumdisplay.php?f=52)
-   -   Jolla and Google Calendar not working correctly (https://talk.maemo.org/showthread.php?t=95821)

juz 2015-08-06 09:25

Jolla and Google Calendar not working correctly
 
I am having problems with the syncing of my google calendar and the Jolla calendar app. The problem is that some events are missing. This is a problem, as I use the calendar, and rely on it being accurate. Having looked around on together.jolla.com, it looks like it may be a case of notebook uid being empty. Note that all events are displayed correctly, in there correct calendar in the google web interface.

I was suffering from this problem prior to updating to 1.1.7.x, and the fix mentioned here (TJC fix) had worked for me. Every now and then I would have to reapply this fix, but the events would always reappear.

However, after updating to 1.1.7.25 the calendar is loosing many events and the above no longer works. I have tried removing my google account, deleting all database files, and starting again. Upon re adding the google account, all events are shown, until I start adding new ones, then they get added to the google web calendar, but may or may not be shown on the jolla calendar.

A manual sync does not improve the scenario. I am now missing a Calendars directory at "/home/nemo/.local/share/system/privileged/". There is only a Calendar directory. Thus the above fix no longer works as there is no google.db in the directory to work with. A brief look with "sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "SELECT * FROM Components WHERE Notebook = '';" " shows a handful of entries. Also starting the calendar app whilst running "journalctl --all --follow --no-pager" shows amongst other things, reports of a notebook uid being empty. See the below for results of these commands.

Can someone help me get my calendars back on track.
Please let me know if the below does not contain enough information and you want me to check other things. Or if I have left in sensitive information that shouldn't be present. Thanks.

Thanks in advance, Justin.

RESULTS:
~ Test (1) - Directory Contents


Code:

ls -all /home/nemo/.local/share/system/privileged/
total 0
d---rwx--- 1 privileged privileged 120 Jul 16 15:40 .
drwxr-xr-x 1 nemo      nemo        36 Jul 10  2014 ..
drwxr-xr-x 1 nemo      privileged 112 Jul 10  2014 Ambienced
drwxr-xr-x 1 nemo      privileged  10 Jul 24 17:47 Calendar
drwxr-xr-x 1 nemo      privileged 718 Aug  4 21:31 Contacts
drwxr-xr-x 1 nemo      privileged  22 Aug  5 17:00 Images
drwxr-x--- 1 nemo      privileged  28 Mar  2 16:09 Keys
drwxr-xr-x 1 nemo      privileged  40 Jul 28 06:20 Location
drwxr-xr-x 1 nemo      privileged 112 Aug  5 19:50 Notifications
drwxr-xr-x 1 nemo      privileged 148 Jul 24 17:44 Sync

Note that I used to have a Calendars folder containing google.db.

Code:

ls -all /home/nemo/.local/share/system/privileged/Calendar/
total 456
drwxr-xr-x 1 nemo privileged    24 Aug  6 17:13 .
drwxr-xr-x 1 nemo privileged    10 Jul 24 17:47 ..
-rw-r--r-- 1 nemo privileged 465920 Aug  6 17:13 db
-rw-r--r-- 1 nemo privileged      0 Aug  6 17:13 db.changed

Should db.changed have a size?

~ Test (2) - Notebook ID
Note that a row of **** 's is some plain text that I have redacted.
Also, In order to fit it all in one post I have shortened the following. Hope nothing crucial is missing.

Code:

[root@Jolla nemo]# sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "SELECT * FROM Components WHERE Notebook = '';"
512||Event|Prep & Practice||1439501400|1439537400|Australia/Melbourne|0|1439528400|1439564400|Australia/Melbourne|0|0|Skills Centre||0|255.0|255.0|0||1438458681|1438482804|1438482804|0|jolla-sociald:gcal-id:***********|||0|0|0|||urn:x-ical:a18933ed-7d81-474b-a358-ad5f1cb8d894|a18933ed-7d81-474b-a358-ad5f1cb8d894|0|0||0|0|0|0|||0
713||Event|Opening Party||1439539200|1439575200|Australia/Melbourne|0|1439553600|1439589600|Australia/Melbourne|0|0|Victoria St, Brunswick||0|255.0|255.0|0||1438458681|1438482804|1438482804|1|jolla-sociald:gcal-id::***********|||0|0|0|||urn:x-ical:9dadacfe-f4c7-46d4-80b9-1d36b81304b4|9dadacfe-f4c7-46d4-80b9-1d36b81304b4|0|0||0|0|0|0|||0
814||Event| Factory||1438390800|1438426800|Australia/Melbourne|0|1438398000|1438434000|Australia/Melbourne|0|0|||0|255.0|255.0|0||1438482786|1438482899|1438482899|1|jolla-sociald:gcal-id::***********|||0|0|0|||urn:x-ical:5dfe3a9c-25d6-4747-9a85-8aea515d5dad|5dfe3a9c-25d6-4747-9a85-8aea515d5dad|0|0||0|0|0|0|||0
816||Event|Prep & Practice||1439501400|1439537400|Australia/Melbourne|0|1439528400|1439564400|Australia/Melbourne|0|0|Skills Centre||0|255.0|255.0|0||1438482899|1438482899|1438482899|0|jolla-sociald:gcal-id::***********|||0|0|0|||urn:x-ical:3fdc2b13-ce59-4517-bbf7-e6bc66edc889|3fdc2b13-ce59-4517-bbf7-e6bc66edc889|0|0|0|0|0||0|||0
818||Event|Prep & Practice||1439501400|1439537400|Australia/Melbourne|0|1439528400|1439564400|Australia/Melbourne|0|0|Skills Centre||0|255.0|255.0|0||1438546786|1438670686|1438670686|0|jolla-sociald:gcal-id::***********|||0|0|0|||urn:x-ical:5de501df-f6c1-4604-8af6-f35047343b18|5de501df-f6c1-4604-8af6-f35047343b18|0|0||0|0|0|0|||0
819||Event|Present Shopping||1438491600|1438527600|Australia/Melbourne|0|1438495200|1438531200|Australia/Melbourne|0|0||
birthday|0|255.0|255.0|0||1438670666|1438670724|1438670724|1|jolla-sociald:gcal-id::***********|||0|0|0|||urn:x-ical:fdecf097-7f65-45d9-841b-6cab8fdcdb7c|fdecf097-7f65-45d9-841b-6cab8fdcdb7c|0|0||0|0|0|0|||0
820||Event|Return Glasses||1438498800|1438534800|Australia/Melbourne|0|1438506000|1438542000|Australia/Melbourne|0|0||Return borrowed glasses post party|0|255.0|255.0|0||1438670704|1438685227|1438685227|1|jolla-sociald:gcal-id::***********|||0|0|0|||urn:x-ical:3c9abf87-1a40-47a0-90a4-22b4f8db2528|3c9abf87-1a40-47a0-90a4-22b4f8db2528|0|0||0|0|0|0|||0

~ Test (3) - Journal on Calendar start

Code:

[root@Jolla nemo]# journalctl --all --follow --no-pager
-- Logs begin at Thu 2015-08-06 17:12:59 AEST. --
Aug 06 18:44:54 Jolla dbus-daemon[932]: Activating service name='com.jolla.calendar.ui'
Aug 06 18:44:54 Jolla dbus-daemon[932]: Successfully activated service 'com.jolla.calendar.ui'
Aug 06 18:44:54 Jolla kernel: dbus-daemon(932) send signal 9 to dbus-daemon(15609)
Aug 06 18:44:54 Jolla estart[15235]: [W] mKCal::SqliteStorage::open:179 - sqlitestorage.cpp: 179 - database "/home/nemo/.local/share/system/privileged/Calendar/mkcal/db" opened
Aug 06 18:44:54 Jolla google-calendars-client[15615]: [W] Buteo::TransportTracker::btConnectivityStatus:202 - This device does not have a BT adapter
Aug 06 18:44:54 Jolla lipstick[1035]: [W] DeclarativeWindow::_setAllowedOrientations:241 - Invalid allowedOrientations value: 0
Aug 06 18:44:55 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:55 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:55 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:55 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:55 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:55 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:55 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:55 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:55 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:55 Jolla google-calendars-client[15615]: [W] mKCal::SqliteStorage::open:179 - sqlitestorage.cpp: 179 - database "/home/nemo/.local/share/system/privileged/Calendar/mkcal/db" opened
Aug 06 18:44:55 Jolla invoker[1018]: SailfishKeyProvider_ini_read: reached end of file
Aug 06 18:44:55 Jolla invoker[1018]: SailfishKeyProvider_ini_read: reached end of file
Aug 06 18:44:55 Jolla google-calendars-client[15615]: [D] SignOn::ConnectionManager::setupSocketConnection:106 - connection-manager.cpp 106 setupSocketConnection p2p error: QDBusError("org.freedesktop.DBus.Error.FileNotFound", "Failed to connect to socket /run/user/100000/signond/socket: No such file or directory") 1
Aug 06 18:44:55 Jolla google-calendars-client[15615]: [D] SignOn::ConnectionManager::init:132 - connection-manager.cpp 132 init Peer connection unavailable, activating service
Aug 06 18:44:55 Jolla dbus-daemon[932]: Activating service name='com.google.code.AccountsSSO.SingleSignOn'
Aug 06 18:44:55 Jolla google-calendars-client[15615]: [D] SignOn::IdentityImpl::updateState:96 - identityimpl.cpp 96 updateState Updating state:  "PendingRegistration" SignOn::IdentityImpl(0xcffbe8)
Aug 06 18:44:55 Jolla google-calendars-client[15615]: [D] SignOn::AuthSessionImpl::initInterface:94 - authsessionimpl.cpp 94 initInterface
Aug 06 18:44:55 Jolla google-calendars-client[15615]: [D] SignOn::AuthSessionImpl::initInterface:94 - authsessionimpl.cpp 94 initInterface
Aug 06 18:44:55 Jolla [15395]: signondaemon.cpp 388 init Failed to SUID root. Secure storage will not be available.
Aug 06 18:44:55 Jolla dbus-daemon[932]: Successfully activated service 'com.google.code.AccountsSSO.SingleSignOn'
Aug 06 18:44:55 Jolla kernel: dbus-daemon(932) send signal 9 to dbus-daemon(15626)
Aug 06 18:44:55 Jolla google-calendars-client[15615]: [D] SignOn::ConnectionManager::init:150 - connection-manager.cpp 150 init Connected to "libsignon-qt1"
Aug 06 18:44:55 Jolla google-calendars-client[15615]: [D] SignOn::IdentityImpl::updateState:96 - identityimpl.cpp 96 updateState Updating state:  "Ready" SignOn::IdentityImpl(0xcffbe8)
Aug 06 18:44:55 Jolla google-calendars-client[15615]: [D] SignOn::IdentityImpl::updateState:96 - identityimpl.cpp 96 updateState Updating state:  "NeedsUpdate" SignOn::IdentityImpl(0xcffbe8)
Aug 06 18:44:55 Jolla google-calendars-client[15615]: [D] SignOn::IdentityImpl::updateState:96 - identityimpl.cpp 96 updateState Updating state:  "PendingUpdate" SignOn::IdentityImpl(0xcffbe8)
Aug 06 18:44:55 Jolla google-calendars-client[15615]: [D] SignOn::IdentityImpl::infoUpdated:442 - identityimpl.cpp 442 infoUpdated SERVER INFO UPDATED. NeedsUpdate " 10 "
Aug 06 18:44:57 Jolla booster-silica-qt5[15613]: [D] QWaylandEglClientBufferIntegration::QWaylandEglClientBufferIntegration:62 - Using Wayland-EGL
Aug 06 18:44:57 Jolla ard[1761]: [D] onTriggered:47 - Checking network connectivity ...
Aug 06 18:44:57 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:58 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:59 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty
Aug 06 18:44:59 Jolla estart[15235]: [W] mKCal::ExtendedCalendar::addEvent:339 - extendedcalendar.cpp: 339 - ExtendedCalendar::addEvent(): NotebookUid empty


aegis 2015-08-06 12:07

Re: Jolla and Google Calendar not working correctly
 
Calendars just seem to be a big bag of hurt on the Jolla.

Today I've been trialling the integrated calendar and contacts that's now in cPanel 11.50. It's based on SabreDAV. It's utterly flawless so far syncing between my Mac and our servers (I run a web hosting company so we're rolling this out to our customers).

Apple's Calendar, Contacts and Reminders apps work flawlessly.
BusyCal, BusyContacts and Fantastical work flawlessly.
My Android phone using Marten Gajda's SmoothSync apps work flawlessly.
An iPad worked flawlessly.

On the Jolla (running 1.1.6.27 - the current 'safe' release), on first sync of a brand new calendar the single event I've put in there is 1 hour out - it's getting confused by DST seemingly so an event set for 3pm ends up as 4pm.

If I edit the event on the Jolla and manually sync, it disappears from the Jolla though thankfully not from the server. The edit never reaches the server.

This is similar to what I've had on ownCloud and Apple's iCloud so it's not SabreDAV's fault. It's been like this for as long as they said they'd "implemented" CalDAV support though initially you couldn't even get the list of calendars from iCloud.

...and my Jolla goes back in the drawer because of this.

Can someone at Jolla buy Chris Adams a Mac so he can test CalDAV/CardDAV properly and if they want to test it against a cPanel server I'll happily provide one for them for free.

romu 2015-08-06 12:43

Re: Jolla and Google Calendar not working correctly
 
search my bug report on TJC, title contains something like "events come and go", Chris has posted some information about this bug.

rob_kouw 2015-08-07 08:32

Re: Jolla and Google Calendar not working correctly
 
Same kind of problems with fruux. Thunderbird/Lightning on Windows works fine with fruux, Jolla makes a mess of it. Some events show the same time, others will be one hour off.

Test: create and event "Test 12:00" at 12:00 on Jolla. After sync, the event shows on Jolla, fruux and Lightning at 12:00. Hurray! But wait, a few hours later the event will show at 13:00 on Jolla!? There is something very wrong here.

P.S. fruux has an option to send me a daily mail with scheduled events. I just turned it on, so I can check the right time on my Jolla trough the mail. :rolleyes:

juz 2015-08-07 11:30

Re: Jolla and Google Calendar not working correctly
 
Thanks all for the reports.

@romu, I had seen your report on TJC, and my issue was different. My events either stay or go. Once gone, they are not coming back. Hopefully the changes Chris Adams refers to fixes all this up.

@rob_kouw, thanks for the update on fruux. I was looking at that last night wondering if I should migrate my calendars over, thinking that since it said it supported Sailfish OS it must be working. How naive of me.

I have reported this case to Jolla care and they have escalated it to there R&D, so will report back if I get any feedback from that avenue.

How I wish it would work. Happy for a hacky fix. Just want a calendar that displays events reliably.


All times are GMT. The time now is 20:56.

vBulletin® Version 3.8.8