Apache server status: error 500 [SOLVED]

[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?

[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?

[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

[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.

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

[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