Cannot access owncloud 10 web interface using domain name or even localhost from server


#1

OWncloud was working perfectly yesterday, nothing has been changed but today I cannot access the web interface either from any browser or by using localhost/owncloud from the server. All the files are still in /var/www/owncloud.
Sorry if this has already been asked but I could not find this problem discussed previously.

Steps to reproduce

  1. Unknown

Expected behaviour

Tell us what should happen
navigate to https://ninfield.eu/owncloud then log in

Actual behaviour

Tell us what happens instead
The requested URL /owncloud was not found on this server.
Apache/2.4.18 (Ubuntu) Server at ninfield.eu Port 443

Server configuration

Operating system:
Ubuntu server 16.04
Web server:
apache 2.4.18
Database:
MySQL
PHP version:
7.0.32
ownCloud version: (see ownCloud admin page)
10.0.10.4
Updated from an older ownCloud or fresh install:
yes
Where did you install ownCloud from:


Signing status (ownCloud 9.0 and above):
unknown

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.

not accessible

The content of config/config.php:

Log in to the web-UI with an administrator account and click on
'admin' -> 'Generate Config Report' -> 'Download ownCloud config report'
This report includes the config.php settings, the list of activated apps
and other details in a well sanitized form.

or 

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

*ATTENTION:* Do not post your config.php file in public as is. Please use one of the above
methods whenever possible. Both, the generated reports from the web-ui and from occ config:list
consistently remove sensitive data. You still may want to review the report before sending.
If done manually then it is critical for your own privacy to dilligently
remove *all* host names, passwords, usernames, salts and other credentials before posting.
You should assume that attackers find such information and will use them against your systems.

{
“system”: {
“updatechecker”: false,
“instanceid”: “ocl2zidip4zd”,
“passwordsalt”: “REMOVED SENSITIVE VALUE”,
“secret”: “REMOVED SENSITIVE VALUE”,
“trusted_domains”: [
“**"
],
“datadirectory”: “/media/data/data”,
“overwrite.cli.url”: "http://
/owncloud”,
“dbtype”: “mysql”,
“version”: “10.0.10.4”,
“dbname”: “owncloud”,
“dbhost”: “localhost”,
“dbtableprefix”: “oc_”,
“dbuser”: “REMOVED SENSITIVE VALUE”,
“dbpassword”: “REMOVED SENSITIVE VALUE”,
“logtimezone”: “UTC”,
“installed”: true,
“htaccess.RewriteBase”: “/owncloud”,
“memcache.local”: “\OC\Memcache\APCu”,
“memcache.locking”: “\OC\Memcache\Redis”,
“filelocking.enabled”: “true”,
“redis”: {
“host”: “localhost”,
“port”: 6379,
“timeout”: 0
},
“mail_from_address”: “REMOVED SENSITIVE VALUE”,
“mail_smtpmode”: “php”,
“mail_domain”: “REMOVED SENSITIVE VALUE”,
“theme”: “”,
“loglevel”: 1,
“maintenance”: false,
“updater.secret”: “REMOVED SENSITIVE VALUE
}
}
List of activated apps:

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.
  • activity: 2.4.1
  • announcementcenter: 1.2.1
  • audioplayer: 2.5.1
  • bookmarks: 0.10.5
  • calendar: 1.6.1
  • camerarawpreviews: 0.6.4
  • checksum: 0.3.5
  • comments: 0.3.0
  • configreport: 0.1.1
  • contacts: 1.5.5
  • customgroups: 0.4.0
  • dav: 0.4.0
  • federatedfilesharing: 0.3.1
  • federation: 0.1.0
  • files: 1.5.1
  • files_clipboard: 0.7.1
  • files_external: 0.7.1
  • files_pdfviewer: 0.10.0
  • files_sharing: 0.11.0
  • files_texteditor: 2.3.0
  • files_textviewer: 1.0
  • files_trashbin: 0.9.1
  • files_versions: 1.3.0
  • files_videoplayer: 0.9.8
  • firstrunwizard: 1.1
  • gallery: 16.1.1
  • impersonate: 0.4.0
  • market: 0.3.0
  • notes: 2.0.4
  • notifications: 0.3.5
  • onlyoffice: 2.1.3
  • passman: 2.1.4
  • phonetrack: 0.2.8
  • provisioning_api: 0.5.0
  • systemtags: 0.3.0
  • updatenotification: 0.2.1
    Disabled:
  • encryption
  • external
  • user_external
    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:**
chrome and firefox
**Operating system:**

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

Insert your webserver log here

[Thu Jan 31 07:35:10.614351 2019] [:notice] [pid 22635] FastCGI: process manager initialized (pid 22635)
PHP Warning:  Module 'apcu' already loaded in Unknown on line 0
[Thu Jan 31 07:35:10.714856 2019] [:error] [pid 10373] python_init: Python version mismatch, expected '2.7.6', found '2.7.12'.
[Thu Jan 31 07:35:10.714984 2019] [:error] [pid 10373] python_init: Python executable found '/usr/bin/python'.
[Thu Jan 31 07:35:10.714990 2019] [:error] [pid 10373] python_init: Python path being used '/usr/lib/python2.7/:/usr/lib/python2.7/plat-x86_64-linux-gnu:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload'.
[Thu Jan 31 07:35:10.715005 2019] [:notice] [pid 10373] mod_python: Creating 8 session mutexes based on 150 max processes and 0 max threads.
[Thu Jan 31 07:35:10.715022 2019] [:notice] [pid 10373] mod_python: using mutex_directory /tmp 
[Thu Jan 31 07:35:10.729477 2019] [ssl:warn] [pid 10373] AH01909: 127.0.1.1:443:0 server certificate does NOT include an ID which matches the server name
[Thu Jan 31 07:35:10.729864 2019] [ssl:warn] [pid 10373] AH01906: 127.0.1.1:8080:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Jan 31 07:35:10.729878 2019] [ssl:warn] [pid 10373] AH01909: 127.0.1.1:8080:0 server certificate does NOT include an ID which matches the server name
[Thu Jan 31 07:35:10.730011 2019] [ssl:error] [pid 10373] AH02217: ssl_stapling_init_cert: can't retrieve issuer certificate! [subject: CN=192.168.0.99:8080,O=Internet Widgits Pty Ltd,ST=Some-State,C=uk / issuer: CN=192.168.0.99:8080,O=Internet Widgits Pty Ltd,ST=Some-State,C=uk / serial: 9C695EEFA74AAB90 / notbefore: Aug 23 14:58:00 2017 GMT / notafter: Aug 21 14:58:00 2027 GMT]
[Thu Jan 31 07:35:10.730021 2019] [ssl:error] [pid 10373] AH02604: Unable to configure certificate 127.0.1.1:8080:0 for stapling
[Thu Jan 31 07:35:10.730632 2019] [mpm_prefork:notice] [pid 10373] AH00163: Apache/2.4.18 (Ubuntu) mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_fcgid/2.3.9 mod_python/3.3.1 Python/2.7.12 OpenSSL/1.0.2g configured -- resuming normal operations
[Thu Jan 31 07:35:10.730652 2019] [core:notice] [pid 10373] AH00094: Command line: '/usr/sbin/apache2'
[Thu Jan 31 07:35:10.730733 2019] [mpm_prefork:warn] [pid 10373] AH00167: long lost child came home! (pid 2986)
[Fri Feb 01 00:00:15.548343 2019] [mpm_prefork:notice] [pid 10373] AH00171: Graceful restart requested, doing restart
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
[Fri Feb 01 00:00:15.666672 2019] [:notice] [pid 22502] FastCGI: process manager initialized (pid 22502)
PHP Warning:  Module 'apcu' already loaded in Unknown on line 0
[Fri Feb 01 00:00:15.760198 2019] [:error] [pid 10373] python_init: Python version mismatch, expected '2.7.6', found '2.7.12'.
[Fri Feb 01 00:00:15.760344 2019] [:error] [pid 10373] python_init: Python executable found '/usr/bin/python'.
[Fri Feb 01 00:00:15.760351 2019] [:error] [pid 10373] python_init: Python path being used '/usr/lib/python2.7/:/usr/lib/python2.7/plat-x86_64-linux-gnu:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload'.
[Fri Feb 01 00:00:15.760367 2019] [:notice] [pid 10373] mod_python: Creating 8 session mutexes based on 150 max processes and 0 max threads.
[Fri Feb 01 00:00:15.760379 2019] [:notice] [pid 10373] mod_python: using mutex_directory /tmp 
[Fri Feb 01 00:00:15.774971 2019] [ssl:warn] [pid 10373] AH01909: 127.0.1.1:443:0 server certificate does NOT include an ID which matches the server name
[Fri Feb 01 00:00:15.775357 2019] [ssl:warn] [pid 10373] AH01906: 127.0.1.1:8080:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Fri Feb 01 00:00:15.775371 2019] [ssl:warn] [pid 10373] AH01909: 127.0.1.1:8080:0 server certificate does NOT include an ID which matches the server name
[Fri Feb 01 00:00:15.775500 2019] [ssl:error] [pid 10373] AH02217: ssl_stapling_init_cert: can't retrieve issuer certificate! [subject: CN=192.168.0.99:8080,O=Internet Widgits Pty Ltd,ST=Some-State,C=uk / issuer: CN=192.168.0.99:8080,O=Internet Widgits Pty Ltd,ST=Some-State,C=uk / serial: 9C695EEFA74AAB90 / notbefore: Aug 23 14:58:00 2017 GMT / notafter: Aug 21 14:58:00 2027 GMT]
[Fri Feb 01 00:00:15.775522 2019] [ssl:error] [pid 10373] AH02604: Unable to configure certificate 127.0.1.1:8080:0 for stapling
[Fri Feb 01 00:00:15.776117 2019] [mpm_prefork:notice] [pid 10373] AH00163: Apache/2.4.18 (Ubuntu) mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_fcgid/2.3.9 mod_python/3.3.1 Python/2.7.12 OpenSSL/1.0.2g configured -- resuming normal operations
[Fri Feb 01 00:00:15.776135 2019] [core:notice] [pid 10373] AH00094: Command line: '/usr/sbin/apache2'
[Fri Feb 01 00:00:15.776202 2019] [mpm_prefork:warn] [pid 10373] AH00167: long lost child came home! (pid 22633)
[Fri Feb 01 00:00:16.466459 2019] [mpm_prefork:notice] [pid 10373] AH00171: Graceful restart requested, doing restart
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
[Fri Feb 01 00:00:16.570032 2019] [:notice] [pid 23003] FastCGI: process manager initialized (pid 23003)
PHP Warning:  Module 'apcu' already loaded in Unknown on line 0
[Fri Feb 01 00:00:16.659152 2019] [:error] [pid 10373] python_init: Python version mismatch, expected '2.7.6', found '2.7.12'.
[Fri Feb 01 00:00:16.659279 2019] [:error] [pid 10373] python_init: Python executable found '/usr/bin/python'.
[Fri Feb 01 00:00:16.659285 2019] [:error] [pid 10373] python_init: Python path being used '/usr/lib/python2.7/:/usr/lib/python2.7/plat-x86_64-linux-gnu:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload'.
[Fri Feb 01 00:00:16.659300 2019] [:notice] [pid 10373] mod_python: Creating 8 session mutexes based on 150 max processes and 0 max threads.
[Fri Feb 01 00:00:16.659314 2019] [:notice] [pid 10373] mod_python: using mutex_directory /tmp 
[Fri Feb 01 00:00:16.673819 2019] [ssl:warn] [pid 10373] AH01909: 127.0.1.1:443:0 server certificate does NOT include an ID which matches the server name
[Fri Feb 01 00:00:16.674198 2019] [ssl:warn] [pid 10373] AH01906: 127.0.1.1:8080:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Fri Feb 01 00:00:16.674215 2019] [ssl:warn] [pid 10373] AH01909: 127.0.1.1:8080:0 server certificate does NOT include an ID which matches the server name
[Fri Feb 01 00:00:16.674348 2019] [ssl:error] [pid 10373] AH02217: ssl_stapling_init_cert: can't retrieve issuer certificate! [subject: CN=192.168.0.99:8080,O=Internet Widgits Pty Ltd,ST=Some-State,C=uk / issuer: CN=192.168.0.99:8080,O=Internet Widgits Pty Ltd,ST=Some-State,C=uk / serial: 9C695EEFA74AAB90 / notbefore: Aug 23 14:58:00 2017 GMT / notafter: Aug 21 14:58:00 2027 GMT]
[Fri Feb 01 00:00:16.674357 2019] [ssl:error] [pid 10373] AH02604: Unable to configure certificate 127.0.1.1:8080:0 for stapling
[Fri Feb 01 00:00:16.674971 2019] [mpm_prefork:notice] [pid 10373] AH00163: Apache/2.4.18 (Ubuntu) mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_fcgid/2.3.9 mod_python/3.3.1 Python/2.7.12 OpenSSL/1.0.2g configured -- resuming normal operations
[Fri Feb 01 00:00:16.675001 2019] [core:notice] [pid 10373] AH00094: Command line: '/usr/sbin/apache2'
[Fri Feb 01 00:00:16.675046 2019] [mpm_prefork:warn] [pid 10373] AH00167: long lost child came home! (pid 22498)
[Fri Feb 01 01:22:53.704698 2019] [:error] [pid 23067] [client 185.234.217.209:51355] script '/var/www/html/wp-login.php' not found or unable to stat, referer: http://ninfield.eu/wp-login.php
[Fri Feb 01 01:22:53.756341 2019] [:error] [pid 23067] [client 185.234.217.209:51355] script '/var/www/html/wp-login.php' not found or unable to stat, referer: http://ninfield.eu/wp-login.php
[Fri Feb 01 07:35:10.320169 2019] [mpm_prefork:notice] [pid 10373] AH00171: Graceful restart requested, doing restart
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message

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

Insert your ownCloud log here

€‹{"reqId":"qZB7y8Nu9bHx2DF4ruH\/","remoteAddr":"159.253.162.14","app":"mysql.setup","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'","level":3,"time":"2017-08-21T19:40:20+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
{"reqId":"qZB7y8Nu9bHx2DF4ruH\/","remoteAddr":"159.253.162.14","app":"mysql.setup","message":"Database creation failed: An exception occurred while executing 'GRANT ALL PRIVILEGES ON `owncloud` . * TO 'owncloud'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'owncloud'@'localhost' to database 'owncloud'","level":3,"time":"2017-08-21T19:40:20+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
{"reqId":"qZB7y8Nu9bHx2DF4ruH\/","remoteAddr":"159.253.162.14","app":"PHP","message":"file_put_contents(\/media\/data\/data\/.htaccess): failed to open stream: Permission denied at \/var\/www\/owncloud\/lib\/private\/Setup.php#500","level":3,"time":"2017-08-21T19:40:45+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
{"reqId":"vZ6Frri\/jq\/CjmhHXOwo","remoteAddr":"159.253.162.14","app":"mysql.setup","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'","level":3,"time":"2017-08-22T13:26:41+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
{"reqId":"vZ6Frri\/jq\/CjmhHXOwo","remoteAddr":"159.253.162.14","app":"mysql.setup","message":"Database creation failed: An exception occurred while executing 'GRANT ALL PRIVILEGES ON `owncloud` . * TO 'owncloud'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'owncloud'@'localhost' to database 'owncloud'","level":3,"time":"2017-08-22T13:26:41+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
{"reqId":"vZ6Frri\/jq\/CjmhHXOwo","remoteAddr":"159.253.162.14","app":"PHP","message":"file_put_contents(\/media\/data\/data\/.htaccess): failed to open stream: Permission denied at \/var\/www\/owncloud\/lib\/private\/Setup.php#500","level":3,"time":"2017-08-22T13:27:04+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}

#### Browser log

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

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


#2

I assume this is quite wrong.


#3

I thought that when I looked at this on the post but in the actual file it is correct “http://owncloud


#4

And this can be resolved by your local DNS?


#5

the actual complete line is
‘overwrite.cli.url’ => ‘http://mydomainname/owncloud’,
which cannot be resolved, also from the server 'http://localhost/owncloud cannot be resolved however mydomainname works fine. nothing has been changed on the server and no upgrades had been run.


#6

Hey,

could it be possible that your web server has lost the configuration for ownCloud?

https://doc.owncloud.org/server/administration_manual/installation/manual_installation.html#configure-apache-web-server


Please help - <url>/owncloud/ not found on server - all the sudden after many years