Debug output is attached. The issue seems to be here:
ERROR[^[[0;31mError in query: (Column 'wlan_ssid' cannot be null)
1048^[[0m]^[[0m
--Vincent
From: Adam Armstrong <***@memetic.org>
To: Observium Network Observation System <***@observium.org>
Date: 06/26/2015 04:41 PM
Subject: Re: [Observium] mysqli db extension
Sent by: "observium" <observium-***@observium.org>
Running that module with -d should give more information.
./discovery.php -h <host> -m wifi -d
Adam.
Sent with AquaMail for Android
http://www.aqua-mail.com
On 26 June 2015 20:33:46 Vincent Aniello <***@portware.com> wrote:
I am trying to use the mysqli db extension with my Observium installation
and when I add $config['db_extension'] = "mysqli"; to my config.php and
run a discovery on a device I receive the following database errors:
Module [ ucd-diskio ] time: 0.0758s
Wifi: RUCKUS-RADIO-MIB UU RUCKUS-WLAN-MIB Failed INSERT into DB, rollback
transaction.
+UUUUUUUUUUUUUUUUUFailed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+UUUUUUUUFailed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+Failed INSERT into DB, rollback transaction.
+
Module [ wifi ] time: 0.3944s
When I remove the mysqli db extension from my config.php and run the same
discovery it runs without issue:
Module [ ucd-diskio ] time: 0.0753s
Wifi: RUCKUS-RADIO-MIB UU RUCKUS-WLAN-MIB
+UUUUUUUUUUUUUUUUU+++++++++++UUUUUUUU+++++
The version information from my Observium installation is:
Observium 0.15.6.6458
OS Linux 2.6.32-358.el6.x86_64 [amd64] (CentOS 6.4)
Apache 2.2.15 (CentOS)
PHP 5.3.3
Python Python 2.6.6
MySQL 5.1.66 (extension: mysqli 5.1.66)
SNMP NET-SNMP 5.5
RRDtool 1.3.8
I also added the following line to my php.ini:
extension=/usr/lib64/php/modules/mysqli.so
This points to the file:
-rwxr-xr-x 1 root root 136032 Feb 21 2013
/usr/lib64/php/modules/mysqli.so
Is there anything else that needs to be configured in order to start using
the mysqli db extension with Observium?
Thank you.
--Vincent