(In reply to Colin from comment #70) > This from Google drive support in response to me asking them how to gain > access; > > When you contact Libre Office Support, please let them know that you need > help with the 6 digit PIN so that it will allow remote access from your > Libre Office account. > > Where does the 6 digit pin originate?
That pin was part of the now no longer supported login mechanism into your gdrive account, it wasn't used by LibreOffice as a pin or password to protect the documents, but rather just how the login worked.. > I imagine even if LO fixes the issue then "newer" LO users who haven't > previously availed themselves of the service simply won't have a 6 Digit PIN. And they won't need that pin. > That's certainly my situation. I'm not trying to access existing files, just > trying to implement the cloud storage for some CALCs by File> Open Remote> > Add Service (from the dropdown menu defaulting to Manage services. Both cases will be solved when the login/token generation is changed as described in comment#67, similar as it has been done for onedrive for 7.1.0 (fixing gdrive login is on the todo, but just didn't make it into 7.1.0). So then the user-experience would be (for the time being): * User chossed to open/save to remote service * LO asks to copy the login URL to browser * User logs in to the service using their browser, granting LibreOffice the access privileges if not already done so in the past * browser will return a code that has to be pasted back into the LibreOffice window → for the duration of the LO session, LO can then create access tokens and won't have to ask the user again. To be fully clear: I know that this is not a great user-experience, so the copy-the-code-back to the LibreOffice window can be solved by having LibreOffice listen on a localhost address and setting the redirect URL to that localhost address, so that would eliminate the need for manually copy'n'paste. But the bigger drawback is that currently LibreOffice doesn't store the refresh_token, so it will have to ask every time LO is started and the files are accessed. (typically they are valid for multiple weeks/months) They should be securely stored locally, so the most natural way would be to use LibreOffice's password-store for that, so the user only would have to unlock it using the master password and not do the login-dance. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1844453 Title: [upstream] Access to the Google remote account does not work Status in LibreOffice: Confirmed Status in libreoffice package in Ubuntu: Confirmed Bug description: I have a Google account with 2FA login, from LibreOffice I try to add the remote account, but it doesn't work, it asks me for a 6-digit PIN. Investigating to see if it was just my problem, I discovered that this is a long-standing LibreOffice bug (1) and seems unresolved. The last report confirms this: "2019-07-04 04:44:41 UTC This feature doesn't work with my Google account _w/o_ 2FA. Bug hasn't be resolved for about 3 years and "very soon" we may celebrate 5 years anniversary. %-(" 1) https://bugs.documentfoundation.org/show_bug.cgi?id=101630 ProblemType: Bug DistroRelease: Ubuntu 19.10 Package: libreoffice (not installed) ProcVersionSignature: Ubuntu 5.3.0-10.11-generic 5.3.0-rc8 Uname: Linux 5.3.0-10-generic x86_64 NonfreeKernelModules: nvidia_modeset nvidia ApportVersion: 2.20.11-0ubuntu7 Architecture: amd64 CurrentDesktop: ubuntu:GNOME Date: Tue Sep 17 23:00:10 2019 InstallationDate: Installed on 2019-02-18 (210 days ago) InstallationMedia: Kubuntu 19.04 "Disco Dingo" - Alpha amd64 (20190130) ProcEnviron: TERM=screen-256color PATH=(custom, no user) XDG_RUNTIME_DIR=<set> LANG=it_IT.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: No upgrade log present (probably fresh install) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1844453/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
