Hi
I’m having an issue with 0.15.4.6392.
When polling devices I get
./discovery.php -d -h hostname.domain.com http://hostname.domain.com/
…..
SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('143','143','device',NOW(),'6','Inventory: 3 added.')] RUNTIME[0.00013995s] ERROR[Error in query: (1364) Field 'reference' doesn't have a default value]
and also:
SQL[INSERT INTO `entPhysical` (`entPhysicalIndex`,`entPhysicalDescr`,`entPhysicalClass`,`entPhysicalName`,`entPhysicalHardwareRev`,`entPhysicalFirmwareRev`,`entPhysicalSoftwareRev`,`entPhysicalAlias`,`entPhysicalAssetID`,`entPhysicalIsFRU`,`entPhysicalModelName`,`entPhysicalVendorType`,`entPhysicalSerialNum`,`entPhysicalContainedIn`,`entPhysicalParentRelPos`,`entPhysicalMfgName`,`ifIndex`,`device_id`) VALUES ('1','MikroTik RouterBoard','chassis','','','','','','','false','','','57820471C18C','0','0','MikroTik','','143')] RUNTIME[0.00013900s] ERROR[Error in query: (1366) Incorrect integer value: '' for column 'ifIndex' at row 1]
192.sql has:
ALTER TABLE `ports` ADD `port_label_short` VARCHAR( 16 ) NOT NULL AFTER `port_label` ;
Changing this to “DEFAULT NULL” seems to fix the problem and ports are discovered and graphed…
(I’ve run ./discovery.php -u Observium 0.15.4.6392 Discovery )
Can anyone assist?
Regards,
Shaun