Hi -
I had a happy persona/home Observium CE 19.x install on Debian (testing) running w/MySQL 5.5 and PHP 7.0 that I finally decided to upgrade to MariaDB 10.6 / PHP 8.1 and am running into some issues.
1) I did the PHP 8.1 upgrade first without touching anything else. I started getting the following:
% /opt/observium/discovery.php -u PHP Fatal error: Uncaught ValueError: mysqli_query(): Argument #2 ($query) cannot be empty in /opt/observium/includes/db/mysqli.inc.php:291 Stack trace: #0 /opt/observium/includes/db/mysqli.inc.php(291): mysqli_query() #1 /opt/observium/includes/db.inc.php(225): dbCallQuery() #2 /opt/observium/includes/sql-config.inc.php(97): dbQuery() #3 /opt/observium/discovery.php(19): include('...') #4 {main} thrown in /opt/observium/includes/db/mysqli.inc.php on line 291
I get something similar in the web interface:
[Sun Jun 05 14:59:53.435049 2022] [php:error] [pid 3255678] [client 2620:6:2003:105:2d8:61ff:fe0f:853:54778] PHP Fatal error: Uncaught ValueError: mysqli_query(): Argument #2 ($query) cannot be empty in /opt/observium/includes/db/mysqli.inc.php:291\nStack trace:\n#0 /opt/observium/includes/db/mysqli.inc.php(291): mysqli_query()\n#1 /opt/observium/includes/db.inc.php(225): dbCallQuery()\n#2 /opt/observium/includes/db/mysqli.inc.php(391): dbQuery()\n#3 /opt/observium/includes/common.inc.php(176): dbFetchRow()\n#4 /opt/observium/includes/common.inc.php(300): get_obs_attrib()\n#5 /opt/observium/includes/sql-config.inc.php(75): get_db_version()\n#6 /opt/observium/html/index.php(13): include('...')\n#7 {main}\n thrown in /opt/observium/includes/db/mysqli.inc.php on line 291
2) I decided to upgrade to Observium CE 22.5. No change. I even cleaned up my config.php and removed some obsolete items. 3) I upgraded MySQL 5.5 -> MariaDB 10.6. No change.
The CE 22.5 announcement indicated PHP8 should be supported now. However, I'm wondering if that doesn't include PHP 8.1.
Does anyone have CE 22.5 running successfully on Debian with PHP 8.1? If so, did you have to tweak anything to get it to work? If there's something obvious in the docs I've missed please just post a link and indicate RTFM ;)
Thanks in advance!
Some info:
(atlantis:14:56:EDT)% env php --version PHP Warning: PHP Startup: ^(text/|application/xhtml+xml) (offset=0): unrecognised compile-time option bit(s) in Unknown on line 0 PHP 8.1.5 (cli) (built: Apr 21 2022 09:51:30) (NTS) Copyright (c) The PHP Group Zend Engine v4.1.5, Copyright (c) Zend Technologies with Zend OPcache v8.1.5, Copyright (c), by Zend Technologies (atlantis:14:56:EDT)% dpkg -l | grep -i php8 ii libapache2-mod-php8.1 8.1.5-1 amd64 server-side, HTML-embedded scripting language (Apache 2 module) ii php8.1 8.1.5-1 all server-side, HTML-embedded scripting language (metapackage) ii php8.1-apcu 5.1.21+4.0.11-7 amd64 APC User Cache for PHP ii php8.1-bcmath 8.1.5-1 amd64 Bcmath module for PHP ii php8.1-cli 8.1.5-1 amd64 command-line interpreter for the PHP scripting language ii php8.1-common 8.1.5-1 amd64 documentation, examples and common module for PHP ii php8.1-curl 8.1.5-1 amd64 CURL module for PHP ii php8.1-gd 8.1.5-1 amd64 GD module for PHP ii php8.1-mbstring 8.1.5-1 amd64 MBSTRING module for PHP ii php8.1-mysql 8.1.5-1 amd64 MySQL module for PHP ii php8.1-opcache 8.1.5-1 amd64 Zend OpCache module for PHP ii php8.1-readline 8.1.5-1 amd64 readline module for PHP ii php8.1-xml 8.1.5-1 amd64 DOM, SimpleXML, XML, and XSL module for PHP (atlantis:14:56:EDT)% dpkg -l | grep -i mariadb ii libmariadb3:amd64 1:10.6.7-3 amd64 MariaDB database client library ii mariadb-client-10.6 1:10.6.7-3 amd64 MariaDB database client binaries ii mariadb-client-core-10.6 1:10.6.7-3 amd64 MariaDB database core client binaries ii mariadb-common 1:10.6.7-3 all MariaDB common configuration files ii mariadb-server 1:10.6.7-3 all MariaDB database server (metapackage depending on the latest version) ii mariadb-server-10.6 1:10.6.7-3 amd64 MariaDB database server binaries ii mariadb-server-core-10.6 1:10.6.7-3 amd64 MariaDB database core server files (atlantis:14:56:EDT)%
- Mark