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

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) …

I assume this is quite wrong.

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

And this can be resolved by your local DNS?

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.

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