I realize this is closed, but for anyone that comes looking I wanted to document the issue I had and what needed to be done.
I updated to 23.6.12860 and lost graph generation. Checking the logs resulted in no errors. After much troubleshooting I realized the issue was with the poller-wrapper.php script.
After updating observium, while running the ./discovery.php -u script I received the following:
PHP Parse error: syntax error, unexpected '=' in /opt/observium/includes/observium.inc.php on line 427
Digging into that error led me to OBS-4531. Which led me to this mailing list announcement: https://lists.observium.org/hyperkitty/list/observium@lists.observium.org/thread/G2JDYY5TZLSQRCERTKYXORK64XBYMGTC/
From there I set forth on updating our PHP 7.1 --> 8.1. That went pretty smoothly; however, after running ./discovery.php -u again I saw another notice about my MariaDB instance. I have v5.5 and Observium was recommending >= 10.3. Since I was already performing maintenance on this server, I went ahead with getting the recommended MariaDB.
This is where this issue comes into play. After updating MariaDB I noticed that I was not getting any graphs. I checked all my logs, and saw no errors. After much troubleshooting, I manually ran ./poller-wrapper.php 8 to be greeted with the following:
ERROR: missing python module: MySQLdb
|
On Ubuntu: apt-get install python-mysqldb
|
On RHEL/CentOS: yum install MySQL-python
|
On FreeBSD: cd /usr/ports/*/py-MySQLdb && make install clean
|
I installed MySQL-python and observium was happily generating graphs again.
Now that I had a fix, I wanted to know why this happened...
As it turns out, when updating MariaDB from 5.5 --> >= 10.3 I uninstalled the existing MariaDB instance:
yum remove mariadb mariadb-libs
Mariadb and mariadb-libs do not have MySQL-python marked as a dependency. But, MySQL-python has mariadb-libs marked as a dependency. By removing the previous installation of mariadb-libs, MySQL-python was also removed.
I am certain that while removing mariadb and mariadb-libs that I was informed about the removal of MySQL-python. This was entirely an oversight on my part.
The frustrating part though, for me, was that the ./poller.php script ran without issue. It took a long time before I got back around to the ./poller-wrapper.php
script for troubleshooting.
TLDR:
If you are using CentOS, and along with updating Observium you also updated MariaDB. AND as part of the MariaDB update you uninstalled the previous version. Verify that you have MySQL-python installed as it is required by the ./poller-wrapper.php script.
I realize this is closed, but for anyone that comes looking I wanted to document the issue I had and what needed to be done.
I updated to 23.6.12860 and lost graph generation. Checking the logs resulted in no errors. After much troubleshooting I realized the issue was with the poller-wrapper.php script.
After updating observium, while running the ./discovery.php -u script I received the following:
PHP Parse error: syntax error, unexpected '=' in /opt/observium/includes/observium.inc.php on line 427
Digging into that error led me to
OBS-4531. Which led me to this mailing list announcement: https://lists.observium.org/hyperkitty/list/observium@lists.observium.org/thread/G2JDYY5TZLSQRCERTKYXORK64XBYMGTC/From there I set forth on updating our PHP 7.1 --> 8.1. That went pretty smoothly; however, after running ./discovery.php -u again I saw another notice about my MariaDB instance. I have v5.5 and Observium was recommending >= 10.3. Since I was already performing maintenance on this server, I went ahead with getting the recommended MariaDB.
This is where this issue comes into play. After updating MariaDB I noticed that I was not getting any graphs. I checked all my logs, and saw no errors. After much troubleshooting, I manually ran ./poller-wrapper.php 8 to be greeted with the following:
ERROR: missing python module: MySQLdb
On Ubuntu: apt-get install python-mysqldb
On RHEL/CentOS: yum install MySQL-python
On FreeBSD: cd /usr/ports/*/py-MySQLdb && make install clean
I installed MySQL-python and observium was happily generating graphs again.
Now that I had a fix, I wanted to know why this happened...
As it turns out, when updating MariaDB from 5.5 --> >= 10.3 I uninstalled the existing MariaDB instance:
yum remove mariadb mariadb-libs
Mariadb and mariadb-libs do not have MySQL-python marked as a dependency. But, MySQL-python has mariadb-libs marked as a dependency. By removing the previous installation of mariadb-libs, MySQL-python was also removed.
I am certain that while removing mariadb and mariadb-libs that I was informed about the removal of MySQL-python. This was entirely an oversight on my part.
The frustrating part though, for me, was that the ./poller.php script ran without issue. It took a long time before I got back around to the ./poller-wrapper.php
script for troubleshooting.
TLDR:
If you are using CentOS, and along with updating Observium you also updated MariaDB. AND as part of the MariaDB update you uninstalled the previous version. Verify that you have MySQL-python installed as it is required by the ./poller-wrapper.php script.