New installation on a web hosting - new folders not created

10
hosting

#1

Hi,

I’m trying to get the latest version 10.0.10.4 working on a web hosting. This is a SentOS with itk, PHP 7.2 and mySQL 5.7.22-22. I don’t have root access and can’t do chown, but I can ask the provider to do something for me. The manual installation went smooth, I’m able to login and see the default folders and files. I can upload a file or delete files and folders. But there’s just one problem:

Steps to reproduce

  1. Login into ownCloud instance
  2. Click ‘+’, select ‘Folder’
  3. Enter a new folder name.

Expected behaviour

The new folder is created

Actual behaviour

The ‘+’ dialog is closed, the folder is not created.

Server configuration

Operating system:
CentOS Linux 7

Web server:
Apache/2.4.6

Database:
mySQL 5.7.22-22

PHP version:
7.2

ownCloud version: (see ownCloud admin page)
10.0.10.4

Updated from an older ownCloud or fresh install:
fresh install

Where did you install ownCloud from:
owncloud-10.0.10.tar.bz2 from owncloud.org

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

No errors have been found.

The content of config/config.php:


**List of activated apps:**
none

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.


**Are you using external storage, if yes which one:** local/smb/sftp/...
no

**Are you using encryption:** yes/no
no

**Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/...
no


### Client configuration
**Browser:**
Google Chrome 70.0.3538.110

**Operating system:**
Windows 10 1809

### Logs
#### Web server error log

Insert your webserver log here


#### ownCloud log (data/owncloud.log)

Insert your ownCloud log here
{“reqId”:“DlZZrgMhKpNfKPyr40Qh”,“level”:3,“time”:“2018-12-08T15:01:26+00:00”,“remoteAddr”:“213.21.16.149”,“user”:"–",“app”:“mysql.setup”,“method”:“POST”,“url”:"/index.php",“message”:“Specific user creation failed: An exception occurred while executing ‘SELECT user FROM mysql.user WHERE user=?’ with params [“oc_vzinovyev”]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user ‘f0005468_f0005468_vz’@‘localhost’ for table ‘user’”}
{“reqId”:“DlZZrgMhKpNfKPyr40Qh”,“level”:3,“time”:“2018-12-08T15:01:28+00:00”,“remoteAddr”:“213.21.16.149”,“user”:"–",“app”:“no app in context”,“method”:“POST”,“url”:"/index.php",“message”:“User backend OC\User\Database is returning home: /home/f0005468/domains/runblogger.ru/public_html/oc/data//vzinovyev for user: vzinovyev which differs from existing value: “}
{“reqId”:“ZHow51XaKiGTu0Jx4mes”,“level”:3,“time”:“2018-12-08T15:46:25+00:00”,“remoteAddr”:“213.21.16.149”,“user”:“vzinovyev”,“app”:“no app in context”,“method”:“POST”,“url”:”/index.php/settings/users/users”,“message”:“User backend OC\User\Database is returning home: /home/f0005468/domains/runblogger.ru/public_html/oc/data//vika for user: vika which differs from existing value: “}
{“reqId”:“a0PZLAAkKF8xdeOWcll4”,“level”:0,“time”:“2018-12-08T16:04:34+00:00”,“remoteAddr”:“213.21.16.149”,“user”:“vzinovyev”,“app”:“OC\User\Session::validateToken”,“method”:“GET”,“url”:”/ocs/v2.php/apps/notifications/api/v1/notifications?format=json”,“message”:“token 273416790df6451db44696248f43f92b29c2cfb20eec3fdf8a78c8a4a5627cb617432d33595ed86735ca529c2f67cfe31f476f7fbca533148682979861aa941c with token id 3 found, validating”}
{“reqId”:“a0PZLAAkKF8xdeOWcll4”,“level”:0,“time”:“2018-12-08T16:04:34+00:00”,“remoteAddr”:“213.21.16.149”,“user”:“vzinovyev”,“app”:“OC\User\Session::validateToken”,“method”:“GET”,“url”:"/ocs/v2.php/apps/notifications/api/v1/notifications?format=json",“message”:“token 273416790df6451db44696248f43f92b29c2cfb20eec3fdf8a78c8a4a5627cb617432d33595ed86735ca529c2f67cfe31f476f7fbca533148682979861aa941c with token id 3 found, validating”}
{“reqId”:“Zs7I8DsfiCNlb1kKqtSY”,“level”:0,“time”:“2018-12-08T16:04:36+00:00”,“remoteAddr”:“213.21.16.149”,“user”:“vzinovyev”,“app”:“OC\User\Session::validateToken”,“method”:“GET”,“url”:"/index.php/apps/files/",“message”:“token 273416790df6451db44696248f43f92b29c2cfb20eec3fdf8a78c8a4a5627cb617432d33595ed86735ca529c2f67cfe31f476f7fbca533148682979861aa941c with token id 3 found, validating”}
{“reqId”:“Zs7I8DsfiCNlb1kKqtSY”,“level”:0,“time”:“2018-12-08T16:04:36+00:00”,“remoteAddr”:“213.21.16.149”,“user”:“vzinovyev”,“app”:“OC\User\Session::validateToken”,“method”:“GET”,“url”:"/index.php/apps/files/",“message”:“token 273416790df6451db44696248f43f92b29c2cfb20eec3fdf8a78c8a4a5627cb617432d33595ed86735ca529c2f67cfe31f476f7fbca533148682979861aa941c with token id 3 found, validating”}
{“reqId”:“Zs7I8DsfiCNlb1kKqtSY”,“level”:0,“time”:“2018-12-08T16:04:36+00:00”,“remoteAddr”:“213.21.16.149”,“user”:“vzinovyev”,“app”:“OC\User\Session::validateToken”,“method”:“GET”,“url”:"/index.php/apps/files/",“message”:“token 273416790df6451db44696248f43f92b29c2cfb20eec3fdf8a78c8a4a5627cb617432d33595ed86735ca529c2f67cfe31f476f7fbca533148682979861aa941c with token id 3 found, validating”}
{“reqId”:“0OS8c0cpQrgmHA3Uy4jL”,“level”:0,“time”:“2018-12-08T16:04:36+00:00”,“remoteAddr”:“213.21.16.149”,“user”:“vzinovyev”,“app”:“OC\User\Session::validateToken”,“method”:“GET”,“url”:"/index.php/core/js/oc.js?v=9f1e52b9f5b86563d7cf0c3db888cecd",“message”:“token 273416790df6451db44696248f43f92b29c2cfb20eec3fdf8a78c8a4a5627cb617432d33595ed86735ca529c2f67cfe31f476f7fbca533148682979861aa941c with token id 3 found, validating”}
{“reqId”:“0OS8c0cpQrgmHA3Uy4jL”,“level”:0,“time”:“2018-12-08T16:04:36+00:00”,“remoteAddr”:“213.21.16.149”,“user”:“vzinovyev”,“app”:“OC\User\Session::validateToken”,“method”:“GET”,“url”:"/index.php/core/js/oc.js?v=9f1e52b9f5b86563d7cf0c3db888cecd",“message”:“token 273416790df6451db44696248f43f92b29c2cfb20eec3fdf8a78c8a4a5627cb617432d33595ed86735ca529c2f67cfe31f476f7fbca533148682979861aa941c with token id 3 found, validating”}

Browser log

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

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

#2

How did you create the database? Obviously there went something wrong.


#3

Yes, I noticed that. The database was created with the provider’s console. I guess that the owncloud installation was not able to create a new user as it normally does with the oc_ prefix (oc_vzinovyev). I’m seeing the same user ID and password that I set when created the database. But the database was successfully intialized and the config.php contains ‘installed’ => true. I checked permissions in the database, and they seem to be OK. As I mentioned, I can upload files without problems. So, the database works. What’s strange is that when I’m trying to create a folder, I don’t get any errors, it’s just not created.


#4

The next thing I cannot understand:

Can you tell something about this?


#5

Not sure, The location /home/f0005468/domains/runblogger.ru/public_html/oc/data//vzinovyev is obviosly the data folder for myself. I can see default folders and files in it both in the file system and through the ownCloud web UI. I don’t know what is the empty existing value. I might guess that it was an initial check during ownCloud setup when it was setting up the database.


#6

But what is the content in the users panel?


#7

Do you mean what I’m seeing when logged in?


#8

No. Go to Users-Menu. There you have to click on the gear wheel down left, select “Show storage location”.


#9

It shows correct location: /home/f0005468/domains/runblogger.ru/public_html/oc/data//vzinovyev


#10

Is the double slash a problem?


#11

Yes, I noticed too. Not sure. I have another server where everything works, and there’s no double slash… How would I fix that… I added another user yesterday and it also shows the double slash.


#12

I guess it’s in my config.php, the data location ends with a slash. I’ll try to remove


#13

Ah, I see. You have a trailing slash there.


#14

The fix in config.php did not remove the double shash in user’s menu. I thing it’s in the database as well. I’ll search how to change the data store location properly.


#15

Table ‘oc_accounts’, column ‘home’.


#16

Thanks. I found an article. There’re multiple places


#17

Unfortunately, fix to the path did not help, still not creating a folder…


#18

Perhaps something was corrupted because of the wrong path. I’ll try to re-install the ownCloud later today and see if that helps.


#19

BTW, some time ago, I also tried an installation with a data directory under public_html, but couldn’t bring it to a good state. After switching to a dedicated directory all the trouble went away. Just wanted to mention this.


#20

Thanks. I started with a dedicated directory and when discovered that it’s not working, I moved to the owncloud one :slight_smile: My another instance is running with a dedicated directory, but I have full access there and configured by the instructions. Here I’m not sure if the default ownership settings with itk are sufficient for the owncloud. I’ll file a support ticket to my provider and see if they can figure that out.