Enable Google Drive plugin for ownCloud

[chris]

Configure the ​external storage application on ​https://cloud.crin.org/ on the existing GreenCloud server for mounting Google Drive.

[chris]

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.

[chris]

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"?

[chris]

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]

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..

[chris]

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?

[chris]

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.

[chris]

CCs changed.