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 <adama@memetic.org>
To:        Observium Network Observation System <observium@observium.org>
Date:        06/26/2015 04:41 PM
Subject:        Re: [Observium] mysqli db extension
Sent by:        "observium" <observium-bounces@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 <VAniello@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


_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium