Page 1 of 1

Apache server status: error 500

Posted: Wed 23. Oct 2019, 18:13
by mbear345
Hi, when I click on the menuitem 'Apache Server Status' in the System Status menu I got this error in browser:
This page isn’t working xxxx (my hostname) is currently unable to handle this request.
HTTP ERROR 500
The generated URL is:
https://xxxx/index.php?page=admin_apach ... vel2kqjk47

This function worked once after installation.

Can anyone knows how should I fix it?

Re: Apache server status: error 500

Posted: Thu 24. Oct 2019, 08:06
by Alexander
Hello!

Please have a look into the file:

Code: Select all

/var/log/keyhelp/php-error.log
There should be an error message listed, each time you call the admin server status page.

Furthermore, which operating system are you using?

Re: Apache server status: error 500

Posted: Thu 24. Oct 2019, 17:22
by mbear345
Hi,

Thank you, your suggestion have helped me a lot, there is a clear message about what happened:

Code: Select all

[23-Oct-2019 17:59:42 Europe/Berlin] PHP Fatal error:  Uncaught Exception: Curl: Unknown SSL protocol error in connection to localhost:443  in /home/keyhelp/www/keyhelp/core/Curl/Curl.php:238
Stack trace:
#0 /home/keyhelp/www/keyhelp/core/Curl/Curl.php(144): Curl->curl('GET', 'https://localho...')
#1 /home/keyhelp/www/keyhelp/functions/functions.main.php(2692): Curl->get('https://localho...')
#2 /home/keyhelp/www/keyhelp/pages/admin_apache_server_status.php(45): getApacheServerStatus(false, false)
#3 /home/keyhelp/www/keyhelp/index.php(407): unknown()
#4 {main}
  thrown in /home/keyhelp/www/keyhelp/core/Curl/Curl.php on line 238
I have changed my server SSL port number from 443 to 1443 with the SETTINGS menu Configuration / Web server function after the install. It was necessary, there is another service is planned to bind to port 443. There are some place(text files) I had to correct in after this setting because the GUI did not change the port everywhere.

I cannot see what happening is in the /home/keyhelp/www/keyhelp/core/Curl/Curl.php your source is not visible for me. Is it possible for you to modify it to ask http://localhost/server-status instead of https:// ?

The previous is working:

Code: Select all

# w3m -dump http://localhost/server-status 
Apache Server Status for ... (via ...)

Server Version: Apache/2.4.25 (Debian) mod_fcgid/2.3.9 OpenSSL/1.0.2t
Server MPM: worker
Server Built: 2019-10-13T15:43:54

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Current Time: Thursday, 24-Oct-2019 19:55:13 CEST
Restart Time: Thursday, 24-Oct-2019 18:19:20 CEST
Parent Server Config. Generation: 1
Parent Server MPM Generation: 0
Server uptime: 1 hour 35 minutes 52 seconds
Server load: 0.00 0.01 0.00
Total accesses: 33 - Total Traffic: 128 kB
CPU Usage: u.11 s0 cu0 cs0 - .00191% CPU load
.00574 requests/sec - 22 B/second - 3971 B/request
1 requests currently being processed, 49 idle workers

... continued ...
BTW I am using Debian9 on this server:

Code: Select all

# lsb_release  -a
No LSB modules are available.
Distributor ID:	Debian
Description:	Debian GNU/Linux 9.11 (stretch)
Release:	9.11
Codename:	stretch

Re: Apache server status: error 500

Posted: Fri 25. Oct 2019, 09:47
by Alexander
Thanks for reporting back.

I have now fixed the problem not using the correct HTTPS port. The fix is included in the next KeyHelp release, going live next week.
There are some place(text files) I had to correct in after this setting because the GUI did not change the port everywhere.
Can you tell me, which config files you had to update, so i can implement those changes in a later KeyHelp update.

Re: Apache server status: error 500

Posted: Fri 25. Oct 2019, 12:40
by mbear345
Hi, I will update definitely.

These 3 files are modified by me (xxxx is my server `hostname`):

Code: Select all

# grep -B1 -A1 -r '\:1443' /etc/apache2/* 
/etc/apache2/keyhelp/webmail.conf-    ServerAlias webmail.*
/etc/apache2/keyhelp/webmail.conf:    Redirect / https://xxxx:1443/webmail/
/etc/apache2/keyhelp/webmail.conf-</VirtualHost>
/etc/apache2/keyhelp/webmail.conf-
/etc/apache2/keyhelp/webmail.conf:<VirtualHost *:1443>
/etc/apache2/keyhelp/webmail.conf-    ServerName webmail
--
/etc/apache2/keyhelp/webmail.conf-
/etc/apache2/keyhelp/webmail.conf:    Redirect / https://xxxx:1443/webmail/
/etc/apache2/keyhelp/webmail.conf-</VirtualHost>
--
/etc/apache2/keyhelp/subdomain_catch_all.conf:<VirtualHost *:1443>
/etc/apache2/keyhelp/subdomain_catch_all.conf-  ServerName tisztaszappan.hu
--
/etc/apache2/keyhelp/subdomain_catch_all.conf-
/etc/apache2/keyhelp/subdomain_catch_all.conf:<VirtualHost *:1443>
/etc/apache2/keyhelp/subdomain_catch_all.conf-  ServerName vinilcenter.hu
--
/etc/apache2/keyhelp/subdomain_catch_all.conf-
/etc/apache2/keyhelp/subdomain_catch_all.conf:<VirtualHost *:1443>
/etc/apache2/keyhelp/subdomain_catch_all.conf-  ServerName xxxx
--
/etc/apache2/keyhelp/keyhelp.conf-# KeyHelp / Tools
/etc/apache2/keyhelp/keyhelp.conf:<VirtualHost *:1443>
/etc/apache2/keyhelp/keyhelp.conf-    ServerName xxxx
--
/etc/apache2/keyhelp/keyhelp.conf-        RewriteCond %{HTTP_HOST} ^(25[0-5]|2[0-4][0-9]|[0-1]?[0-9]?[0-9])\.(25[0-5]|2[0-4][0-9]|[0-1]?[0-9]?[0-9])\.(25[0-5]|2[0-4][0-9]|[0-1]?[0-9]?[0-9])\.(25[0-5]|2[0-4][0-9]|[0-1]?[0-9]?[0-9]).*$
/etc/apache2/keyhelp/keyhelp.conf:        RewriteRule ^(.*)$ https://%{HTTP_HOST}:1443/
/etc/apache2/keyhelp/keyhelp.conf-    </IfModule>
/etc/apache2/keyhelp/keyhelp.conf-
/etc/apache2/keyhelp/keyhelp.conf:    Redirect / https://xxxx:1443/
/etc/apache2/keyhelp/keyhelp.conf-</VirtualHost>
--
/etc/apache2/keyhelp/keyhelp.conf-# Default page, if domain not available.
/etc/apache2/keyhelp/keyhelp.conf:<VirtualHost *:1443>
/etc/apache2/keyhelp/keyhelp.conf-    ServerName xxxx
--
/etc/apache2/keyhelp/keyhelp.conf-    SSLCertificateChainFile /etc/ssl/keyhelp/keyhelp-ca.crt
/etc/apache2/keyhelp/keyhelp.conf:    Redirect / https://xxxx:1443/index.php?page=notavailable
/etc/apache2/keyhelp/keyhelp.conf-</VirtualHost>
--
/etc/apache2/keyhelp/keyhelp.conf-    ServerAlias *.xxxx
/etc/apache2/keyhelp/keyhelp.conf:    Redirect / https://xxxx:1443/index.php?page=notavailable
/etc/apache2/keyhelp/keyhelp.conf-</VirtualHost>
I had to check some URLs in the configuration database also. I can't remember what I actually had to modified. But the final vaules are here:

Code: Select all

MariaDB [keyhelp]> select * from settings where value like "%:1443%";
+----+-------------------+----------+------------------------------------------------+
| id | category          | name     | value                                          |
+----+-------------------+----------+------------------------------------------------+
|  7 | db_administration | nav_url  | https://xxxx:1443/db-administration/ |
| 54 | general           | panelurl | https://xxxx:1443                    |
| 90 | webmail           | nav_url  | https://xxxx:1443/webmail/           |
+----+-------------------+----------+------------------------------------------------+
3 rows in set (0.00 sec)

Re: Apache server status: error 500  [SOLVED]

Posted: Fri 25. Oct 2019, 13:56
by Alexander
Hello the file names you have posted gets updated by the KeyHelp update cron job run, after changing the appropriate configuration setting.

But you are right about the database stuff, they should receive an auto-updated too - I put it on my to-do list for the next update - Thanks.

---

Done with KeyHelp 22.0