Reply to topic

Google Drive access not working

Tony_B
Registered Member
Posts
11
Karma
0

Re: Google Drive access not working

Sun Mar 01, 2020 8:05 pm
Same issue here.

Kubuntu 18.04 (Ubuntu Studio Version)
KDE Plasma 5.12.9
KDE Frameworks 5.44.0
tonysnc
Registered Member
Posts
1
Karma
0

Re: Google Drive access not working

Thu Mar 05, 2020 1:36 am
I was able to fix this manually on my system. I experience some of the same issues most people here referenced: setup the account with 2FA, it showed up just as "(Google)" in the Online Accounts page, and kio-gdrive (via Dolphin) wouldn't go anywhere with it. So following the instructions here https://bugs.kde.org/show_bug.cgi?id=414219 plus a few extra steps, I made it work. Basically you may need to do these steps:
Code: Select all
sqlite3 ~/.config/libaccounts-glib/accounts.db
.dump Accounts

Get the account id for your Google account (the first column). If this is your only account it is probably 1, but verify.
Code: Select all
update Accounts set name = '[email protected]' where id = 1;
update Settings set value = '[email protected]' where account = 1 and key = 'name';
update Settings set value = '[email protected]' where account = 1 key = 'username';

Certainly change the email address to yours and the ID number and account number in those SQL commands to the ID identified first.

After that I was able to refresh Online Accounts and see my account listed properly, then go visit Google Drive in Dolphin and see my files!

I hope that helps someone.
Al Muckart
Registered Member
Posts
1
Karma
0

Re: Google Drive access not working

Sat Mar 07, 2020 1:49 am
Thanks tonysnc for those steps. They helped once I'd persuaded kaccounts to actually create the Google account.

I have no idea why it worked, but creating an account in the sqlite db with:
Code: Select all
INSERT INTO Accounts VALUES(1,'[email protected]','google',1);

but not creating anything in the settings etc. meant that when I next tried to create the account it worked and inserted the information into the database.

At that point I could use your commands, substituting 2 for 1 in the ID, to rename the account and set the username properly.

After restarting Dolphin it worked.
stoolpigeon
Registered Member
Posts
3
Karma
0
OS

Re: Google Drive access not working

Mon Mar 30, 2020 9:36 am
This was so helpful. Thank you for posting the sql lite fix it really saved my day.
bfeltman
Registered Member
Posts
1
Karma
0
OS

Re: Google Drive access not working

Thu Apr 09, 2020 1:06 pm
For me above solution doesnt fully work.
After @Al Muckart step and then @tonysnc I was able to see my gmail account in Dolphin > network > Google Drive > my email account but then there is "unknown error".

Code: Select all
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE Accounts (id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT,provider TEXT,enabled INTEGER);
INSERT INTO Accounts VALUES(1,'[email protected]','google',1);
CREATE TRIGGER tg_delete_account BEFORE DELETE ON Accounts FOR EACH ROW BEGIN DELETE FROM Settings WHERE account = OLD.id; END;
COMMIT;
sqlite>
mtk0
Registered Member
Posts
2
Karma
0

Re: Google Drive access not working

Mon May 18, 2020 8:06 pm
i just want to confirm that as of 05/18/2020, this problem *still* exists (on a fresh fedora 32 KDE install). and the work-around of inserting a dummy entry into Accounts, followed by attempting to create an entry from System Settings/Online Accounts, followed by patching the newly created entry in the Accounts & Settings tables still *works*! thanks!
User avatar robertotamburrino
Registered Member
Posts
30
Karma
0
OS

Re: Google Drive access not working

Tue May 19, 2020 8:02 pm
I can't open google drive in dolphin on kde neon user, it asks me for email and password, but after date it gives me error: "Functionality Sign in with Google temporarily disabled for this app
This app has not yet been verified by Google and therefore cannot use the Sign in with Google feature. "
How do I go about starting gdrive in dolphin? :( since I'm not a programmer, can you tell me the steps to do from the terminal?
zigwen
Registered Member
Posts
1
Karma
0

Re: Google Drive access not working

Thu Jun 18, 2020 10:15 pm
Hello,

same unfortunate conclusion on my side using Kubuntu 18.04 : I have successfully inserted values into Accounts and Settings but got the "unknown error" message in dolphin ...
Any suggestion would be welcomed :)
Thanks.
shihabshahriar
Registered Member
Posts
1
Karma
0

Re: Google Drive access not working

Tue Jul 07, 2020 11:49 pm
Same problem, nothing happens once I provide email & password- just an empty window (Kubuntu 20.04)
User avatar Mamarok
Manager
Posts
4849
Karma
12
OS

Re: Google Drive access not working

Wed Jul 08, 2020 10:47 am
The bug gives some hints how to solve the problem, please everybody read that bug report, get a newer Dolphin (the partial fix is in 19.12.3) and correct the access manually.


Currently running Kubuntu 20.04, Plasma 5.18.5, Frameworks 5.68.0, Qt 5.12.8, kernel 5.4.0-42
FWIW: it is always useful to state the exact Plasma version and distribution when asking questions in this forum, makes it easier for us to help ...

 
Reply to topic

Bookmarks



Who is online

Registered users: aleksander, Alexa [Bot], Baidu [Spider], Bing [Bot], Google [Bot], grahm, nicoleagnew, sandro4912, Sogou [Bot], Yahoo [Bot], zeroarmor