Cannot access my owncloud server

Please help us by providing the following info. Before posting please also check the pinned "Known issues" threads and make sure that you're running the latest available version for your oC release: https://owncloud.org/changelog/

Steps to reproduce
1. try to access https://covici.com/owncloud
2.
3.

Expected behaviour
Tell us what should happen
I should see the log in page
Actual behaviour
Tell us what happens instead
I get 500 internal server error after about 30 seconds of waiting
Server configuration
Operating system: Linux kernel 4.4.54
Web server:apache 2.4
Database:postgresql 9.6
PHP version:5.6
ownCloud version (see ownCloud admin page): 9.1.0
Updated from an older ownCloud or fresh install: updated
Special configuration (external storage, external authentication, reverse proxy, server-side-encryption):

ownCloud configuration

Go to the admin page, click on 'admin' -> 'Generate Config Report' -> 'Download ownCloud config report' or use the command line `sudo -u www-data php occ config:list system` (please sanitize sensitive data):

{
"system": {
"instanceid": "occc0c1ec9dc",
"passwordsalt": "REMOVED SENSITIVE VALUE",
"datadirectory": "\/var\/www\/covici.com\/htdocs-secure\/owncloud\/data",
"dbtype": "pgsql",
"version": "9.1.0.15",
"dbname": "owncloud",
"dbhost": "127.0.0.1",
"dbtableprefix": "oc_",
"dbuser": "REMOVED SENSITIVE VALUE",
"dbpassword": "REMOVED SENSITIVE VALUE",
"installed": true,
"forcessl": true,
"loglevel": "1",
"theme": "",
"maintenance": false,
"overwrite.cli.url": "\/owncloud",
"trusted_domains": [
"covici.com"
],
"secret": "REMOVED SENSITIVE VALUE",
"trashbin_retention_obligation": "auto",
"debug": false,
"mail_smtpmode": "smtp",
"mail_from_address": "owncloud",
"mail_domain": "covici.com",
"mail_smtpauthtype": "LOGIN",
"mail_smtphost": "localhost",
"mail_smtpport": "25"
}
}

ownCloud log (data/owncloud.log)

Please paste possible errors in the following code block, see https://central.owncloud.org/t/how-to-find-webserver-or-oc-logfile-enable-php-logfile/808 for more info

I see nothing in the owncloud.log when I dtry to access the server

Integrity status for oC9+

Login as admin user into your ownCloud and access
http://example.com/index.php/settings/integrity/failed
paste the results here. The only thing that fails is the .htaccess. I got this by doing ./occ integrity check-core

I should also add that it was all working till Sunday morning. I restored the database to a time before the fault, but no joy. Also, there is nothing in the server log or owncloud.log. I checked this by looking at the log before and after the attempt, but no change.

In your case we need the webserver error logfile. Once you got your version running, you should update to a current version: https://owncloud.org/changelog/#latest9.1 (Please don't upgrade to ownCloud 10 yet, wait for at least one release update in about one month).

Well, there seems to be nothing, I will paste what is there, but its mostly about other apps not related to owncloud.

Here is all I could find -- the first line is from error_log and the next are from ssl_request.log

[Mon May 01 05:46:35.754227 2017] [ssl:info] [pid 19747] [client 192.168.0.2:57442] AH01964: Connection to child 1 established (server ccs.covici.com:443)
[01/May/2017:05:46:35 -0400] 192.168.0.2 TLSv1.2 ECDHE-RSA-AES256-GCM-SHA384 "GET /owncloud HTTP/1.1" 297
[01/May/2017:05:46:35 -0400] 192.168.0.2 TLSv1.2 ECDHE-RSA-AES256-GCM-SHA384 "GET /owncloud/ HTTP/1.1" -

There are no other lines with that ip address.

Please try harder to find any errors in your logfiles matching the internal server error (Such internal server errors are definitely logged somewhere). Without these its impossible to help here.

Possible logfiles are your webservers error log, the one of PHP and the data/owncloud.log

I never had a log file for php, where might that be, usually they come in the logs for apache. Is there any way to increase the log level for apache, I just don't see anything at all.

There is a FAQ about an internal server error available here:

which guides you to some resources about possible logfiles here:

So, I set the server log to debug, but I get nothing, but here is what it did give me. I am not getting anything when I set debug => true in my owncloud config file.

[Mon May 01 09:52:31.246121 2017] [ssl:info] [pid 17851] [client 192.168.0.2:59590] AH01964: Connection to child 0 established (server ccs.covici.com:443)
[Mon May 01 09:52:31.246323 2017] [ssl:debug] [pid 17851] ssl_engine_kernel.c(2115): [client 192.168.0.2:59590] AH02043: SSL virtual host for servername covici.com found
[Mon May 01 09:52:31.246372 2017] [ssl:debug] [pid 17851] ssl_engine_kernel.c(2115): [client 192.168.0.2:59590] AH02043: SSL virtual host for servername covici.com found
[Mon May 01 09:52:31.246387 2017] [core:debug] [pid 17851] protocol.c(2163): [client 192.168.0.2:59590] AH03155: select protocol from , choices=h2,http/1.1 for server ccs.covici.com
[Mon May 01 09:52:31.302727 2017] [ssl:debug] [pid 17851] ssl_engine_kernel.c(2042): [client 192.168.0.2:59590] AH02041: Protocol: TLSv1.2, Cipher: ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)
[Mon May 01 09:52:31.302803 2017] [ssl:debug] [pid 17851] ssl_engine_kernel.c(366): [client 192.168.0.2:59590] AH02034: Initial (No.1) HTTPS request received for child 0 (server ccs.covici.com:443)
[Mon May 01 09:52:31.303248 2017] [authz_core:debug] [pid 17851] mod_authz_core.c(809): [client 192.168.0.2:59590] AH01626: authorization result of Require all granted: granted
[Mon May 01 09:52:31.303264 2017] [authz_core:debug] [pid 17851] mod_authz_core.c(809): [client 192.168.0.2:59590] AH01626: authorization result of : granted
[Mon May 01 09:52:31.337101 2017] [ssl:debug] [pid 17851] ssl_engine_kernel.c(366): [client 192.168.0.2:59590] AH02034: Subsequent (No.2) HTTPS request received for child 0 (server ccs.covici.com:443)
[Mon May 01 09:52:31.337314 2017] [authz_core:debug] [pid 17851] mod_authz_core.c(809): [client 192.168.0.2:59590] AH01626: authorization result of Require all granted: granted
[Mon May 01 09:52:31.337330 2017] [authz_core:debug] [pid 17851] mod_authz_core.c(809): [client 192.168.0.2:59590] AH01626: authorization result of : granted
[Mon May 01 09:52:31.337392 2017] [authz_core:debug] [pid 17851] mod_authz_core.c(809): [client 192.168.0.2:59590] AH01626: authorization result of Require all granted: granted
[Mon May 01 09:52:31.337405 2017] [authz_core:debug] [pid 17851] mod_authz_core.c(809): [client 192.168.0.2:59590] AH01626: authorization result of : granted
[Mon May 01 09:52:31.676679 2017] [ssl:debug] [pid 17851] ssl_engine_kernel.c(366): [client 192.168.0.2:59590] AH02034: Subsequent (No.3) HTTPS request received for child 0 (server ccs.covici.com:443)
[Mon May 01 09:52:31.676978 2017] [authz_core:debug] [pid 17851] mod_authz_core.c(809): [client 192.168.0.2:59590] AH01626: authorization result of Require all granted: granted
[Mon May 01 09:52:31.676993 2017] [authz_core:debug] [pid 17851] mod_authz_core.c(809): [client 192.168.0.2:59590] AH01626: authorization result of : granted
[Mon May 01 09:52:31.677178 2017] [authz_core:debug] [pid 17851] mod_authz_core.c(809): [client 192.168.0.2:59590] AH01626: authorization result of Require all granted: granted
[Mon May 01 09:52:31.677192 2017] [authz_core:debug] [pid 17851] mod_authz_core.c(809): [client 192.168.0.2:59590] AH01626: authorization result of : granted
[Mon May 01 09:53:01.678548 2017] [ssl:debug] [pid 17851] ssl_engine_io.c(1043): [client 192.168.0.2:59590] AH02001: Connection closed to child 0 with standard shutdown (server ccs.covici.com:443)

I guess you should get some support for this on a apache forums / community like:

https://httpd.apache.org/support.html
http://www.apachelounge.com/

Especially as you're using some sort of proxy or something redirecting the external requests to another server.

I am not using any proxy at all. But I do know that it reaches index.php by putting an echo statement in there, so it looks like it dies in OC::handleRequest but I am at a loss to know where that is.

Most likely as everyone else in here. As written, without any matching error to the internal server error its impossible to help here. You could also ask for some help in the resources linked above how to gather them in your environment.

But someone should be able to tell me where the handleRequest function is, so I can see where things wind up and maybe debug the thing. I don't know why the debug => true in my config.php is not doing anything.

OK, so I have found that we never return from $SystemConfig = \OC::$server->getSystemConfig();
Somewhere in there, it times out. I am not skilled enough to trace this down any further, so I will need some assistance.

Thanks in advance for any suggestions.

Well, I find that one of my traces ends after setting execution and input timeouts. What seems to be happening is that something times out and apache eventually gives up and produces an error. I do not know the internals of this program enough to get any further, but now my server is dead and all the hundreds of links I have shared are no good, so I need some help to get this going.

Now I also know that the only database querries during this session are the following
LOG: statement: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED
LOG: execute : SELECT * FROM "oc_appconfig"
LOG: execute : SHOW SERVER_VERSION
LOG: execute : SELECT "id", "uid", "login_name", "password", "name", "type", "token", "last_activity", "last_check" FROM "oc_authtoken" WHERE "token" = $1
DETAIL: parameters: $1 = '5b75d669e22d65ea65eec760d745f4f4157d60b6acb7235c66fe1ba36153e5da6d0dd6266411ae8154b3ec1a73a9fd6147ffe931a0436fabcde7e2d0e4abcf70'

Thanks in advance for any suggestions.