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