"General input/output error" when attempting to save a document to google drive

[Olivier Tilloy]

(bug initially reported upstream, but apparently only affects ubuntu: https://bugs.documentfoundation.org/show_bug.cgi?id=97898)

Steps to reproduce:

 - start a document in libreoffice writer
 - menu File > Save Remote…
 - use the "Add Service" button to configure an existing google account (not one using 2FA, that's not implemented yet)

Expected result: the document is saved on your google drive

Current result: an error dialog box that reads: "Error saving the document Untitled 1: General input/output error."

ProblemType: Bug
DistroRelease: Ubuntu 18.04
Package: libreoffice 1:6.0.2-0ubuntu1
ProcVersionSignature: Ubuntu 4.15.0-10.11-generic 4.15.3
Uname: Linux 4.15.0-10-generic x86_64
ApportVersion: 2.20.8-0ubuntu10
Architecture: amd64
CurrentDesktop: ubuntu:GNOME
Date: Thu Mar 8 17:22:50 2018
InstallationDate: Installed on 2018-02-08 (27 days ago)
InstallationMedia: Ubuntu 18.04 LTS "Bionic Beaver" - Alpha amd64 (20180208)
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

[Olivier Tilloy (osomon)]

Just tested the 6.0.2 snap (from the candidate channel), and I'm seeing a different behaviour: no error, but I get prompted a 6-digit PIN code, as if 2FA was enabled for my test google account (which it isn't).

[Olivier Tilloy (osomon)]

gdrive-client-id and gdrive-client-secret differ between the deb packages and the snap. I wonder if the tokens were updated/renewed, but we forgot to update the deb packages.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Olivier Tilloy (osomon)]

Just tested again with libreoffice 6.0.3 in bionic, after we explicitly enabled the google drive API for the project that holds the API key used in libreoffice (it was not enabled previously).

I am now seeing the same thing as with the snap: I am being prompted for a 6 digit PIN code, and I don't know where I'm supposed to get that one.

[Olivier Tilloy (osomon)]

After allowing less secure apps in my google account security settings (https://myaccount.google.com/security#connectedapps), I was able to save a writer document on my google drive by only providing e-mail address and password.

However I tested with another account with 2FA enabled, and I'm still getting the prompt to enter a 6-digit PIN code, but I'm not receiving any code via SMS on my phone as I would expect.

[Olivier Tilloy (osomon)]

(maybe) relevant bug: https://bugs.documentfoundation.org/show_bug.cgi?id=101630