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