"Abort" or "you don't have permission to upload or create files here" notifications

Pierre_Cathe · March 8, 2021, 3:30pm

Steps to reproduce

Connect to 192.168.server.ip/owncloud
Login as admin
Drag and drop a file from my pc to the root folder, or try to create a new folder

Expected behaviour

The file should be uploaded or the folder should be created

Actual behaviour

If the file is over around 8Mb, a notification saying “abort” pops up
If the file is under around 8Mb, a progress bar fills up and when complete, a notification saying “You don’t have permission to upload or create files here”
If you tried to create a new folder, a notification saying “Unable to create folder ‘asdf’”

Server configuration

Operating system: Linux raspberrypi 5.10.17

Web server: Apache 2.4.38 (Raspbian)

Database: MySQL

PHP version: 7.3

ownCloud version: 10.6.0.5

Updated from an older ownCloud or fresh install: Fresh install

Where did you install ownCloud from:
I used this link : wget htt ps://download.owncloud.org/community/owncloud-10.6.0.tar.bz2
from this tutorial : htt ps://doc.owncloud.com/server/10.6/admin_manual/installation/quick_guides/ubuntu_20_04.html

Signing status (ownCloud 9.0 and above): Not sure what this means

No errors have been found.

The content of config/config.php: see next
List of activated apps:
This is the generated config report :

gist.github.com

https://gist.github.com/Pierre-Cathe/558c58256506046781cc339dbf90eb44

report.txt

```{
    "basic": {
        "license key": "***REMOVED SENSITIVE VALUE***",
        "date": "Mon, 08 Mar 2021 14:53:03 +0000",
        "ownCloud version": "10.6.0.5",
        "ownCloud version string": "10.6.0",
        "ownCloud edition": "Community",
        "server OS": "Linux",
        "server OS version": "Linux raspberrypi 5.10.17-v7+ #1403 SMP Mon Feb 22 11:29:51 GMT 2021 armv7l",
        "server SAPI": "apache2handler",

This file has been truncated. show original

Are you using external storage, if yes which one: No, but I have moved the data storage directory to a USB hard drive plugged into the Pi. To do so I followed this tutorial :
htt ps://doc.owncloud.com/server/admin_manual/maintenance/manually-moving-data-folders.html

Are you using encryption: do not know

**Are you using an external user-backend, if yes which one:**No

Client configuration

Browser: Google Chrome Version 88.0.4324.190

Operating system: Windows 10

Logs

Web server error log

[Mon Mar 08 16:19:40.803740 2021] [mpm_prefork:notice] [pid 2215] AH00163: Apache/2.4.38 (Raspbian) OpenSSL/1.1.1d configured -- resuming normal operations
[Mon Mar 08 16:19:40.804062 2021] [core:notice] [pid 2215] AH00094: Command line: '/usr/sbin/apache2'

ownCloud log (data/owncloud.log)

gist.github.com

https://gist.github.com/Pierre-Cathe/95b4b0451eec5de0aca81a88805753cc

oc_log.txt

```
root@raspberrypi:/media/pi/external_drive/owncloud_data/data# cat owncloud.log
{"reqId":"JUY9w8u0WouoZS9H5bbD","level":3,"time":"2021-03-06T21:48:13+00:00","remoteAddr":"","user":"--","app":"mysql.setup","method":"--","url":"--","message":"Specific user creation failed: An exception occurred while executing 'SELECT user FROM mysql.user WHERE user=?' with params [\"oc_admin\"]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'owncloud'@'localhost' for table 'user'"}
{"reqId":"DrQOsj5ZErpvt8qlqVXg","level":2,"time":"2021-03-06T21:52:28+00:00","remoteAddr":"192.168.1.254","user":"--","app":"core","method":"GET","url":"\/owncloud\/","message":"Trusted domain error. \"192.168.1.254\" tried to access using \"87.88.253.144\" as host."}
{"reqId":"ohxSBuo2IcuSocGvGBj1","level":2,"time":"2021-03-06T21:52:29+00:00","remoteAddr":"192.168.1.254","user":"--","app":"core","method":"GET","url":"\/owncloud\/index.php\/core\/js\/oc.js?v=18779503ed56677e2fea400b1284d7f9","message":"Trusted domain error. \"192.168.1.254\" tried to access using \"87.88.253.144\" as host."}
{"reqId":"wasaUgILSpDS0BIZ7zMf","level":2,"time":"2021-03-06T22:00:26+00:00","remoteAddr":"192.168.1.254","user":"admin","app":"core","method":"GET","url":"\/owncloud\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"Login failed: 'admin' (Remote IP: '192.168.1.254')"}
{"reqId":"wasaUgILSpDS0BIZ7zMf","level":3,"time":"2021-03-06T22:00:26+00:00","remoteAddr":"192.168.1.254","user":"admin","app":"OC\\User\\Session::validateToken","method":"GET","url":"\/owncloud\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"invalid credentials in token 3f541e79077d0c514688fa3913f32d9aef66318d4554f26a5c30b811e7b8a0a9f08842b4db0fa4fe2611b57d941fd5c35aba32db2ccf8e4ff8f48c9bca238389 with token id 1"}
{"reqId":"lgc5itBwQaIOzYG4MOvI","level":2,"time":"2021-03-07T00:50:26+00:00","remoteAddr":"18.130.227.63","user":"--","app":"core","method":"GET","url":"\/login","message":"Trusted domain error. \"18.130.227.63\" tried to access using \"127.0.1.1\" as host."}
{"reqId":"0nwZqHq9g61OxX4H4qrF","level":2,"time":"2021-03-07T00:50:27+00:00","remoteAddr":"18.130.227.63","user":"--","app":"core","method":"GET","url":"\/jenkins\/login","message":"Trusted domain error. \"18.130.227.63\" tried to access using \"127.0.1.1\" as host."}
{"reqId":"sOg3gV9oCeshsXkUKP8x","level":2,"time":"2021-03-07T02:30:39+00:00","remoteAddr":"120.78.11.122","user":"--","app":"core","method":"GET","url":"\/login","message":"Trusted domain error. \"120.78.11.122\" tried to access using \"127.0.1.1\" as host."}

This file has been truncated. show original

Browser log

I don’t know how to get those things

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...

Thanks in advance !

tom42 · March 12, 2021, 7:44pm

Hey,

i have seen the following in your log file:

{"reqId":"P24kefQbfuOBs2SqhnuM","level":3,"time":"2021-03-08T15:18:44+00:00","remoteAddr":"192.168.1.254","user":"admin","app":"no app in context","method":"GET","url":"\/owncloud\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","message":"User backend OC\\User\\Database is returning home: \/media\/pi\/external_drive\/owncloud_data\/data\/admin for user: admin which differs from existing value: \/media\/www\/pi\/external_drive\/owncloud_data\/data\/my_user\/files"}

Could it be possible that you have moved the data directory of ownCloud after the installation without following the documentation provided by the ownCloud people here:

https://doc.owncloud.com/server/admin_manual/maintenance/manually-moving-data-folders.html

Pierre_Cathe · March 13, 2021, 9:16am

Hi tom42, thanks for your reply.
I have indeed followed the “manually moving data folders” documentation to do this, but I messed up the step " Update the oc_accounts Table"
I have edited the oc_accounts table to match what the backend is expecting (/media/pi/external_drive/owncloud_data/data/admin)
and it works perfectly now, thanks a lot for your help you legend !

tom42 · March 13, 2021, 9:28am

This is great, very happy that you were able to get this sorted out.

system · June 11, 2021, 9:28am

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.