CRIN Trac: Ticket #7: Enable Google Drive plugin for ownCloud

hours changed; totalhours set

chris — Wed, 29 Apr 2015 09:59:14 GMT

hours changed from 0 to 0.26
totalhours set to 0.26

The "External storage support" app was already enabled on this page:

https://cloud.crin.org/index.php/settings/apps

In the ownCloud admin interface "Google Drive" needed ticking on this page:

https://cloud.crin.org/index.php/settings/admin#goto-external-storage

And then "Client ID" and "Client Secret" are needed. I should be able to get these following the instructions here:

https://doc.owncloud.org/server/7.0/admin_manual/configuration/external_storage_configuration_gui.html#google-drive

Once access to the Google account has been sorted.

hours, totalhours changed

chris — Wed, 29 Apr 2015 11:15:38 GMT

hours changed from 0 to 0.25
totalhours changed from 0.26 to 0.51

Google access has been sorted out, on this page:

https://console.developers.google.com/project

An owncloud project has already been created, click it and go to APIs & Auth > Credentials then copy the "Client ID" and "Client Secret" into ownCloud and granty access it's ready to be tested!

Jonas can you look to see if it is all working and if it is close this ticket as "fixed"?

attachment set

chris — Wed, 29 Apr 2015 14:02:39 GMT

attachment set to ScreenShot2015-04-29at12.49.14.png

hours, totalhours changed

chris — Wed, 29 Apr 2015 14:48:35 GMT

hours changed from 0 to 0.75
totalhours changed from 0.51 to 1.26

Jonas has reported this error:

Looking in the Apache logs there are these issues:

mkstemp("/var/www/owncloud/.execoooh2tIcT") failed: Permission denied
[Wed Apr 29 11:14:55 2015] [error] [client X.X.X.X] client denied by server configuration: /var/www/owncloud/data/htaccesstest.txt

The only 500 errors seem to be on PROPFIND requests.

grep " 500 " cloud.ssl_access.log | grep -v PROPFIND

For example:

cloud.ssl_access.log:X.X.X.X - Jonas [29/Apr/2015:14:02:24 +0000] "PROPFIND /remote.php/webdav/GoogleDrive/XX HTTP/1.1" 500 2544 "-" "Mozilla/5.0 (Macintosh) mirall/1.8.0"

I found this:

Google Drive Large Files Fail with 500 Error

Google Drive tries to download the entire file into memory, then write it to a temp file, and then stream it to the client, so very large file downloads from Google Drive may fail with a 500 internal server error.

https://doc.owncloud.org/server/8.0/admin_manual/release_notes.html

Is this related?

The tmp directory is set in /etc/apache2/sites-available/cloud:

php_admin_value upload_tmp_dir /var/www/owncloud/tmp

But a php file with this in:

<?php echo sys_get_temp_dir(); ?>

Generates:

/tmp

Which is odd and adding this to the Apache config didn't change this:

SetEnv TMPDIR /var/www/owncloud/tmp

Some values in /etc/php5/apache2/php.ini have been increased to see if this helps:

#memory_limit = 256M
memory_limit = 512M
#max_execution_time = 30
max_execution_time = 60

I think I need to be able to reproduce this bug myself to proceed -- Jonas what application were you using and what action did you do to generate the error?

jonas — Wed, 29 Apr 2015 15:03:11 GMT

Maybe it is the problem of large files.. How big would be too large?

I am using the ownCloud desktop app and simply opened the settings. It is still synching all the files at the moment.

I am not sure this is helpful to solve the issue..

hours, totalhours changed

chris — Wed, 29 Apr 2015 15:16:23 GMT

hours changed from 0 to 0.15
totalhours changed from 1.26 to 1.41

Replying to jonas:

Maybe it is the problem of large files.. How big would be too large?

I'm not sure, the limits set by php are quite big:

post_max_size = 2G
upload_max_filesize = 2G
max_file_uploads = 200

So I doubt you are hitting these.

I am using the ownCloud desktop app and simply opened the settings. It is still synching all the files at the moment.

Ah, OK, let me know how that goes.

I am not sure this is helpful to solve the issue..

The file / directory generating the error has a "'" and a "&" is the file/directory name -- I wonder if this could be the cause of the problem, I'll email this to you, perhaps removing those chars might solve this?

hours, estimatedhours, status, totalhours changed; resolution set

chris — Thu, 07 May 2015 11:23:35 GMT

hours changed from 0 to 0.06
estimatedhours changed from 0 to 1.5
status changed from new to closed
resolution set to fixed
totalhours changed from 1.41 to 1.47

This ticket can be closed, for future reference having Google Drive directories with a single quote character in the directory name was the cause of the problem and it was resolved by renaming the folder.

milestone set

chris — Wed, 13 May 2015 11:27:55 GMT

milestone set to Maintenance

cc changed

chris — Thu, 18 Jun 2015 11:58:38 GMT

cc jenny gillian added; jonas removed

CCs changed.