Thread: Jolla and Google Calendar not working correctly
View Single Post
juz is offline juz
2015-08-06 , 09:25
Posts: 53 | Thanked: 146 times | Joined on Apr 2012 @ Australia
#1
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
 

The Following 2 Users Say Thank You to juz For This Useful Post: