I can no longer download any google sheets documents from google drive. Everything worked properly until 2 days ago when suddenly I started getting errors with any sheets file. All other files copy fine, and these same files copied fine 3 days ago. Permissions have not changed for these files, however the content has.
Any help would be greatly appreciated! Thanks!
What is your rclone version (output from rclone version)
rclone v1.36 (Latest according to Ubuntu?)
Which OS you are using and how many bits (eg Windows 7, 64 bit)
Ubuntu 18.04.5 LTS (64 bit)
Which cloud storage system are you using? (eg Google Drive)
Google Drive
The command you were trying to run (eg rclone copy /tmp remote:tmp)
2021/07/09 10:37:32 DEBUG : rclone: Version "v1.36" starting with parameters ["rclone" "-vv" "copy" "gdrive:/Financials" "."]
2021/07/09 10:37:33 INFO : Local file system at /home/green1/.config/rclone: Modify window is 1ms
2021/07/09 10:37:33 ERROR : Financials: Failed to copy: failed to open source object: forbidden to download - check sharing permission
2021/07/09 10:37:33 INFO : Local file system at /home/green1/.config/rclone: Waiting for checks to finish
2021/07/09 10:37:33 INFO : Local file system at /home/green1/.config/rclone: Waiting for transfers to finish
2021/07/09 10:37:33 ERROR : Attempt 1/3 failed with 1 errors and: failed to open source object: forbidden to download - check sharing permission
2021/07/09 10:37:33 ERROR : Financials: Failed to copy: failed to open source object: forbidden to download - check sharing permission
2021/07/09 10:37:33 INFO : Local file system at /home/green1/.config/rclone: Waiting for checks to finish
2021/07/09 10:37:33 INFO : Local file system at /home/green1/.config/rclone: Waiting for transfers to finish
2021/07/09 10:37:33 ERROR : Attempt 2/3 failed with 1 errors and: failed to open source object: forbidden to download - check sharing permission
2021/07/09 10:37:34 ERROR : Financials: Failed to copy: failed to open source object: forbidden to download - check sharing permission
2021/07/09 10:37:34 INFO : Local file system at /home/green1/.config/rclone: Waiting for checks to finish
2021/07/09 10:37:34 INFO : Local file system at /home/green1/.config/rclone: Waiting for transfers to finish
2021/07/09 10:37:34 ERROR : Attempt 3/3 failed with 1 errors and: failed to open source object: forbidden to download - check sharing permission
2021/07/09 10:37:34 Failed to copy: failed to open source object: forbidden to download - check sharing permission
Ubuntu should update that, as apt-get update states it is up to date, and the recommendation "don't use a package manager" would make maintaining any computer system a complete nightmare. How would you stay on top of security updates for the hundreds upon hundreds of packages on a modern computer?
That said, I just updated to version 1.55.1 and now I get:
2021/07/09 11:10:58 DEBUG : Using config file from "/home/green1/.config/rclone/rclone.conf"
2021/07/09 11:10:58 DEBUG : rclone: Version "v1.55.1" starting with parameters ["rclone" "-vv" "copy" "gdrive:/Financials.xlsx" "."]
2021/07/09 11:10:58 DEBUG : Creating backend with remote "gdrive:/Financials.xlsx"
2021/07/09 11:10:59 DEBUG : Google drive root 'Financials.xlsx': root_folder_id = "0AMbYvqxas-iQUk9PVA" - save this in the config to speed up startup
2021/07/09 11:10:59 DEBUG : fs cache: adding new entry for parent of "gdrive:/Financials.xlsx", "gdrive:"
2021/07/09 11:10:59 DEBUG : Creating backend with remote "."
2021/07/09 11:10:59 DEBUG : fs cache: renaming cache item "." to be canonical "/home/green1"
2021/07/09 11:11:00 DEBUG : Financials: Need to transfer - File not found at Destination
2021/07/09 11:11:02 ERROR : Financials: Failed to copy: failed to open source object: open file failed: googleapi: Error 403: Only files with binary content can be downloaded. Use Export with Docs Editors files., fileNotDownloadable
2021/07/09 11:11:02 ERROR : Attempt 1/3 failed with 1 errors and: failed to open source object: open file failed: googleapi: Error 403: Only files with binary content can be downloaded. Use Export with Docs Editors files., fileNotDownloadable
2021/07/09 11:11:02 DEBUG : Financials: Need to transfer - File not found at Destination
2021/07/09 11:11:05 ERROR : Financials: Failed to copy: failed to open source object: open file failed: googleapi: Error 403: Only files with binary content can be downloaded. Use Export with Docs Editors files., fileNotDownloadable
2021/07/09 11:11:05 ERROR : Attempt 2/3 failed with 1 errors and: failed to open source object: open file failed: googleapi: Error 403: Only files with binary content can be downloaded. Use Export with Docs Editors files., fileNotDownloadable
2021/07/09 11:11:05 DEBUG : Financials: Need to transfer - File not found at Destination
2021/07/09 11:11:07 ERROR : Financials: Failed to copy: failed to open source object: open file failed: googleapi: Error 403: Only files with binary content can be downloaded. Use Export with Docs Editors files., fileNotDownloadable
2021/07/09 11:11:07 ERROR : Attempt 3/3 failed with 1 errors and: failed to open source object: open file failed: googleapi: Error 403: Only files with binary content can be downloaded. Use Export with Docs Editors files., fileNotDownloadable
2021/07/09 11:11:07 INFO :
Transferred: 0 / 0 Bytes, -, 0 Bytes/s, ETA -
Errors: 1 (retrying may help)
Elapsed time: 9.0s
2021/07/09 11:11:07 DEBUG : 4 go routines active
2021/07/09 11:11:07 Failed to copy: failed to open source object: open file failed: googleapi: Error 403: Only files with binary content can be downloaded. Use Export with Docs Editors files., fileNotDownloadable
Package managers are great for certain things but not so great for others. It's not great for rclone as it's a single binary and no one maintains it as you noticed it. We don't here. If you want to maintain the package for Ubuntu and keep it up to date, that's the beauty of freeware as you can.
Not everything on Ubuntu is via the package manager as many 3rd part applications require updates outside of the package management system. How you want to maintain your system based on the software installed is really up to you. I think you are merging operating system patches and such with 3rd party applications. Again, if you want to maintain the package on Ubuntu, feel free
Is that a file you created via Google Docs? How did you make that one file that's failing?
I did a quick test making an Excel sheet via Google Docs:
felix@gemini:~$ rclone copy GD:test.xlsx . -vv
2021/07/09 13:24:46 DEBUG : Using config file from "/opt/rclone/rclone.conf"
2021/07/09 13:24:46 DEBUG : rclone: Version "v1.55.1" starting with parameters ["rclone" "copy" "GD:test.xlsx" "." "-vv"]
2021/07/09 13:24:46 DEBUG : Creating backend with remote "GD:test.xlsx"
2021/07/09 13:24:46 DEBUG : GD: detected overridden config - adding "{TKSWb}" suffix to name
2021/07/09 13:24:47 DEBUG : fs cache: adding new entry for parent of "GD:test.xlsx", "GD{TKSWb}:"
2021/07/09 13:24:47 DEBUG : Creating backend with remote "."
2021/07/09 13:24:47 DEBUG : fs cache: renaming cache item "." to be canonical "/home/felix"
2021/07/09 13:24:47 DEBUG : test.xlsx: Need to transfer - File not found at Destination
2021/07/09 13:24:48 DEBUG : Local file system at /home/felix: File to upload is small (4678 bytes), uploading instead of streaming
2021/07/09 13:24:48 DEBUG : test.xlsx: MD5 = 82544972f35be865e1a8ad1fb81fe93c OK
2021/07/09 13:24:48 INFO : test.xlsx: Copied (new)
2021/07/09 13:24:48 DEBUG : test.xlsx: Updating size of doc after download to 4678
2021/07/09 13:24:48 INFO : test.xlsx: Copied (Rcat, new)
2021/07/09 13:24:48 INFO :
Transferred: 9.137k / 9.137 kBytes, 100%, 19.438 kBytes/s, ETA 0s
Transferred: 3 / 3, 100%
Elapsed time: 1.1s
2021/07/09 13:24:48 DEBUG : 8 go routines active
and no issues, but someone also reported something similar:
That issue you linked looks like the same issue I'm having, and the same timeframe. I'm guessing google changed something on their end?
Now that I updated to the latest version of rclone, it appears that some of my other google sheets are downloadable, but this one is giving me that 403 error.
Let's use the issue to follow up with as it does look like something changed perhaps on the Google side. I only use encrypted remotes so I would never have the issue myself.
2021/07/13 11:39:07 ERROR :Failed to copy: failed to open source object: open file failed: googleapi: Error 403: Only files with binary content can be downloaded. Use Export with Docs Editors files., fileNotDownloadable
if you have started a new topic, there would be a template of questions to answer, so that we can help you without having to pull all the answers from you one by one....