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