This is what I’ve been able to determine thus far. Here are my relevant syslogs and error logs:
SYSLOG
Nov 2 07:35:03 openemrhost systemd[1]: Reloading LSB: Apache2 web server.
Nov 2 07:35:03 openemrhost apache2[13444]: * Reloading Apache httpd web server apache2
Nov 2 07:35:04 openemrhost apache2[13444]: *
Nov 2 07:35:04 openemrhost systemd[1]: Reloaded LSB: Apache2 web server.
Nov 2 07:35:04 openemrhost systemd[1]: Stopping Make remote CUPS printers available locally…
ERROR LOG
[Fri Nov 02 07:35:04.225505 2018] [mpm_prefork:notice] [pid 1388] 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 Nov 02 07:35:04.363718 2018] [ssl:warn] [pid 1388] AH01906: 127.0.1.1:5380:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Fri Nov 02 07:35:04.363835 2018] [ssl:warn] [pid 1388] AH01909: 127.0.1.1:5380:0 server certificate does NOT include an ID which matches the server name
[Fri Nov 02 07:35:04.364176 2018] [mpm_prefork:notice] [pid 1388] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured – resuming normal operations
[Fri Nov 02 07:35:04.364194 2018] [core:notice] [pid 1388] AH00094: Command line: ‘/usr/sbin/apache2’
(Able to log on to OpenEMR)
SYSLOG
Nov 3 07:35:03 openemrhost systemd[1]: Reloading LSB: Apache2 web server.
Nov 3 07:35:03 openemrhost apache2[18561]: * Reloading Apache httpd web server apache2
Nov 3 07:35:03 openemrhost apache2[18561]: *
Nov 3 07:35:03 openemrhost systemd[1]: Reloaded LSB: Apache2 web server.
ERROR LOG
[Sat Nov 03 07:35:03.793924 2018] [mpm_prefork:notice] [pid 1388] 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
[Sat Nov 03 07:35:03.927658 2018] [ssl:warn] [pid 1388] AH01906: 127.0.1.1:5380:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Sat Nov 03 07:35:03.927766 2018] [ssl:warn] [pid 1388] AH01909: 127.0.1.1:5380:0 server certificate does NOT include an ID which matches the server name
[Sat Nov 03 07:35:03.928087 2018] [mpm_prefork:notice] [pid 1388] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured – resuming normal operations
[Sat Nov 03 07:35:03.928104 2018] [core:notice] [pid 1388] AH00094: Command line: ‘/usr/sbin/apache2’
(Upgraded to Ubuntu 18.04 later that morning, still able to log on to OpenEMR after upgrade)
SYSLOG
Nov 4 00:08:26 openemrhost systemd[1]: Reloading The Apache HTTP Server.
Nov 4 00:08:26 openemrhost apachectl[5145]: 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
Nov 4 00:08:26 openemrhost systemd[1]: Reloaded The Apache HTTP Server.
ERROR LOG
[Sun Nov 04 00:08:26.535717 2018] [mpm_prefork:notice] [pid 1302] 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
[Sun Nov 04 00:08:26.656981 2018] [ssl:warn] [pid 1302] AH01906: 127.0.1.1:5380:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Sun Nov 04 00:08:26.657028 2018] [ssl:warn] [pid 1302] AH01909: 127.0.1.1:5380:0 server certificate does NOT include an ID which matches the server name
[Sun Nov 04 00:08:26.658190 2018] [mpm_prefork:notice] [pid 1302] AH00163: Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g configured – resuming normal operations
[Sun Nov 04 00:08:26.658220 2018] [core:notice] [pid 1302] AH00094: Command line: ‘/usr/sbin/apache2’
[Sun Nov 04 00:08:26.672174 2018] [:error] [pid 5152] avahi_entry_group_add_service_strlst(“openemrhost”) failed: Local name collision
(Still able to log on to OpenEMR)
SYSLOG
Nov 5 00:05:25 openemrhost systemd[1]: Reloading The Apache HTTP Server.
Nov 5 00:05:25 openemrhost apachectl[21545]: 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
Nov 5 00:05:25 openemrhost systemd[1]: Reloaded The Apache HTTP Server.
ERROR LOG
[Mon Nov 05 00:05:25.427266 2018] [mpm_prefork:notice] [pid 1302] 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
[Mon Nov 05 00:05:25.636151 2018] [ssl:warn] [pid 1302] AH01906: 127.0.1.1:5380:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Nov 05 00:05:25.636193 2018] [ssl:warn] [pid 1302] AH01909: 127.0.1.1:5380:0 server certificate does NOT include an ID which matches the server name
[Mon Nov 05 00:05:25.637409 2018] [mpm_prefork:notice] [pid 1302] AH00163: Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g configured – resuming normal operations
[Mon Nov 05 00:05:25.637439 2018] [core:notice] [pid 1302] AH00094: Command line: ‘/usr/sbin/apache2’
[Mon Nov 05 00:05:25.648978 2018] [:error] [pid 21555] avahi_entry_group_add_service_strlst(“openemrhost”) failed: Local name collision
(Still able to log on to OpenEMR)
SYSLOG
Nov 6 00:06:08 openemrhost systemd[1]: Reloading The Apache HTTP Server.
Nov 6 00:06:08 openemrhost apachectl[29273]: 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
Nov 6 00:06:08 openemrhost systemd[1]: Reloaded The Apache HTTP Server.
ERROR LOG
[Tue Nov 06 00:06:08.555518 2018] [mpm_prefork:notice] [pid 1302] 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
[Tue Nov 06 00:06:08.675572 2018] [ssl:warn] [pid 1302] AH01906: 127.0.1.1:5380:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Tue Nov 06 00:06:08.675610 2018] [ssl:warn] [pid 1302] AH01909: 127.0.1.1:5380:0 server certificate does NOT include an ID which matches the server name
[Tue Nov 06 00:06:08.676661 2018] [mpm_prefork:notice] [pid 1302] AH00163: Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g configured – resuming normal operations
[Tue Nov 06 00:06:08.676690 2018] [core:notice] [pid 1302] AH00094: Command line: ‘/usr/sbin/apache2’
[Tue Nov 06 00:06:08.688361 2018] [:error] [pid 29286] avahi_entry_group_add_service_strlst(“openemrhost”) failed: Local name collision
[Tue Nov 06 16:40:59.462890 2018] [:error] [pid 26679] [client 192.168.11.27:58032] PHP Deprecated: You are retrieving the service locator from within the class Installer\Controller\InstallerController. Please be aware that ServiceLocatorAwareInterface is deprecated and will be removed in version 3.0, along with the ServiceLocatorAwareInitializer. You will need to update your class to accept all dependencies at creation, either via constructor arguments or setters, and use a factory to perform the injections. in /var/www/openemr/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php on line 258, referer: https://192.168.11.28:5380/openemr/interface/main/tabs/main.php
(Still able to log on to OpenEMR that morning)
SYSLOG
Nov 7 00:10:08 openemrhost systemd[1]: Reloading The Apache HTTP Server.
Nov 7 00:10:08 openemrhost apachectl[29551]: 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
Nov 7 00:10:08 openemrhost systemd[1]: Reloaded The Apache HTTP Server.
ERROR LOG
[Wed Nov 07 00:10:08.627546 2018] [mpm_prefork:notice] [pid 1302] 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
[Wed Nov 07 00:10:08.765036 2018] [ssl:warn] [pid 1302] AH01906: 127.0.1.1:5380:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Wed Nov 07 00:10:08.765085 2018] [ssl:warn] [pid 1302] AH01909: 127.0.1.1:5380:0 server certificate does NOT include an ID which matches the server name
[Wed Nov 07 00:10:08.766346 2018] [mpm_prefork:notice] [pid 1302] AH00163: Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g configured – resuming normal operations
[Wed Nov 07 00:10:08.766378 2018] [core:notice] [pid 1302] AH00094: Command line: ‘/usr/sbin/apache2’
[Wed Nov 07 00:10:08.778917 2018] [:error] [pid 29564] avahi_entry_group_add_service_strlst(“openemrhost”) failed: Local name collision
[Wed Nov 07 07:54:11.108058 2018] [:error] [pid 29569] [client 192.168.11.27:58396] PHP Fatal error: Uncaught Error: Call to undefined function mysqli_query() in /var/www/openemr/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php:786\nStack trace:\n#0 /var/www/openemr/vendor/adodb/adodb-php/adodb.inc.php(1251): ADODB_mysqli->_query(‘SET NAMES ‘utf8…’, false)\n#1 /var/www/openemr/vendor/adodb/adodb-php/adodb.inc.php(1229): ADOConnection->_Execute(‘SET NAMES ‘utf8…’, false)\n#2 /var/www/openemr/library/ADODB_mysqli_log.php(24): ADOConnection->Execute(‘SET NAMES ‘utf8…’, false)\n#3 /var/www/openemr/library/sql.inc(53): ADODB_mysqli_log->Execute(‘SET NAMES ‘utf8…’)\n#4 /var/www/openemr/interface/globals.php(268): require_once(’/var/www/openem…’)\n#5 /var/www/openemr/interface/login/login.php(33): require_once(’/var/www/openem…’)\n#6 {main}\n thrown in /var/www/openemr/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php on line 786
(Not able log on to OpenEMR as of that morning)
From what I can see, things are more or less the same with some minor differences in format after the upgrade; the highlighted error seems to be the key difference that matches up with when we could no longer log on.
Does this reveal the problem?
-Venu