New hosts ports are not discovered?
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
This also happened to me. I think you must disable strict mode in MySQL.
Hope it helps.
Enviado con Aquamail para Android http://www.aqua-mail.com
El 21 de abril de 2015 20:20:24 Shaun Courtney shaun@cybersmart.co.za escribio:
Hi
I’m having an issue with 0.15.4.6392.
When polling devices I get
./discovery.php -d -h hostname.domain.comhttp://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
________________________________ Este correo electrónico y, en su caso, cualquier fichero anexo al mismo, contiene información de carácter confidencial exclusivamente dirigida a su destinatario o destinatarios. Si no es vd. el destinatario indicado, queda notificado que la lectura, utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. En el caso de haber recibido este correo electrónico por error, se ruega notificar inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente. Evite imprimir este mensaje si no es estrictamente necesario.
This email and any file attached to it (when applicable) contain(s) confidential information that is exclusively addressed to its recipient(s). If you are not the indicated recipient, you are informed that reading, using, disseminating and/or copying it without authorisation is forbidden in accordance with the legislation in effect. If you have received this email by mistake, please immediately notify the sender of the situation by resending it to their email address. Avoid printing this message if it is not absolutely necessary.
Yes, i had the same problem and disabling the strict setting solved my problem.
Op 21-apr.-2015 om 20:31 heeft Asensio Sánchez, Juan jasensios@indra.es het volgende geschreven:
This also happened to me. I think you must disable strict mode in MySQL.
Hope it helps.
Enviado con Aquamail para Android http://www.aqua-mail.com
El 21 de abril de 2015 20:20:24 Shaun Courtney shaun@cybersmart.co.za escribio:
Hi
I’m having an issue with 0.15.4.6392.
When polling devices I get
./discovery.php -d -h 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
Este correo electrónico y, en su caso, cualquier fichero anexo al mismo, contiene información de carácter confidencial exclusivamente dirigida a su destinatario o destinatarios. Si no es vd. el destinatario indicado, queda notificado que la lectura, utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. En el caso de haber recibido este correo electrónico por error, se ruega notificar inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente. Evite imprimir este mensaje si no es estrictamente necesario.
This email and any file attached to it (when applicable) contain(s) confidential information that is exclusively addressed to its recipient(s). If you are not the indicated recipient, you are informed that reading, using, disseminating and/or copying it without authorisation is forbidden in accordance with the legislation in effect. If you have received this email by mistake, please immediately notify the sender of the situation by resending it to their email address. Avoid printing this message if it is not absolutely necessary. _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
We probably need to add a note about this to the install guide. A small percentage of people seem to love using the mysql.com packages with strict mode enabled!
Adam.
Sent with AquaMail for Android http://www.aqua-mail.com
On 21 April 2015 19:46:32 Patrick Marquetecken patrick@marquetecken.be wrote:
Yes, i had the same problem and disabling the strict setting solved my problem.
Op 21-apr.-2015 om 20:31 heeft Asensio Sánchez, Juan jasensios@indra.es
het volgende geschreven:
This also happened to me. I think you must disable strict mode in MySQL.
Hope it helps.
Enviado con Aquamail para Android http://www.aqua-mail.com
El 21 de abril de 2015 20:20:24 Shaun Courtney shaun@cybersmart.co.za
escribio:
Hi
I’m having an issue with 0.15.4.6392.
When polling devices I get
./discovery.php -d -h 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
Este correo electrónico y, en su caso, cualquier fichero anexo al mismo,
contiene información de carácter confidencial exclusivamente dirigida a su destinatario o destinatarios. Si no es vd. el destinatario indicado, queda notificado que la lectura, utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. En el caso de haber recibido este correo electrónico por error, se ruega notificar inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente.
Evite imprimir este mensaje si no es estrictamente necesario.
This email and any file attached to it (when applicable) contain(s)
confidential information that is exclusively addressed to its recipient(s). If you are not the indicated recipient, you are informed that reading, using, disseminating and/or copying it without authorisation is forbidden in accordance with the legislation in effect. If you have received this email by mistake, please immediately notify the sender of the situation by resending it to their email address.
Avoid printing this message if it is not absolutely necessary. _______________________________________________ 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
It's already in there for the CentOS guide.
A small percentage of people seem to not follow the install guide and act surprised when it doesn't work ;-)
Tom
On 04/21/2015 08:51 PM, Adam Armstrong wrote:
We probably need to add a note about this to the install guide. A small percentage of people seem to love using the mysql.com http://mysql.com packages with strict mode enabled!
Adam.
Sent with AquaMail for Android http://www.aqua-mail.com
On 21 April 2015 19:46:32 Patrick Marquetecken patrick@marquetecken.be wrote:
Yes, i had the same problem and disabling the strict setting solved my problem.
Op 21-apr.-2015 om 20:31 heeft Asensio Sánchez, Juan <jasensios@indra.es mailto:jasensios@indra.es> het volgende geschreven:
This also happened to me. I think you must disable strict mode in MySQL.
Hope it helps.
Enviado con Aquamail para Android http://www.aqua-mail.com
El 21 de abril de 2015 20:20:24 Shaun Courtney <shaun@cybersmart.co.za mailto:shaun@cybersmart.co.za> escribio:
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
Este correo electrónico y, en su caso, cualquier fichero anexo al mismo, contiene información de carácter confidencial exclusivamente dirigida a su destinatario o destinatarios. Si no es vd. el destinatario indicado, queda notificado que la lectura, utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. En el caso de haber recibido este correo electrónico por error, se ruega notificar inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente. Evite imprimir este mensaje si no es estrictamente necesario.
This email and any file attached to it (when applicable) contain(s) confidential information that is exclusively addressed to its recipient(s). If you are not the indicated recipient, you are informed that reading, using, disseminating and/or copying it without authorisation is forbidden in accordance with the legislation in effect. If you have received this email by mistake, please immediately notify the sender of the situation by resending it to their email address. Avoid printing this message if it is not absolutely necessary. _______________________________________________ observium mailing list observium@observium.org mailto: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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Anyway, I think the best solution is not try to insert null values in a non-default or not-null defined column.
Regards.
________________________________________ De: observium [observium-bounces@observium.org] En nombre de Tom Laermans [tom.laermans@powersource.cx] Enviado el: martes, 21 de abril de 2015 21:16 Para: Observium Network Observation System Asunto: Re: [Observium] New hosts ports are not discovered?
It's already in there for the CentOS guide.
A small percentage of people seem to not follow the install guide and act surprised when it doesn't work ;-)
Tom
On 04/21/2015 08:51 PM, Adam Armstrong wrote:
We probably need to add a note about this to the install guide. A small percentage of people seem to love using the mysql.comhttp://mysql.com packages with strict mode enabled!
Adam.
Sent with AquaMail for Android http://www.aqua-mail.com
On 21 April 2015 19:46:32 Patrick Marquetecken patrick@marquetecken.bemailto:patrick@marquetecken.be wrote:
Yes, i had the same problem and disabling the strict setting solved my problem.
Op 21-apr.-2015 om 20:31 heeft Asensio Sánchez, Juan <jasensios@indra.esmailto:jasensios@indra.es> het volgende geschreven:
This also happened to me. I think you must disable strict mode in MySQL.
Hope it helps.
Enviado con Aquamail para Android http://www.aqua-mail.com
El 21 de abril de 2015 20:20:24 Shaun Courtney <shaun@cybersmart.co.zamailto:shaun@cybersmart.co.za> escribio:
Hi
I’m having an issue with 0.15.4.6392.
When polling devices I get
./discovery.php -d -h hostname.domain.comhttp://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
________________________________ Este correo electrónico y, en su caso, cualquier fichero anexo al mismo, contiene información de carácter confidencial exclusivamente dirigida a su destinatario o destinatarios. Si no es vd. el destinatario indicado, queda notificado que la lectura, utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. En el caso de haber recibido este correo electrónico por error, se ruega notificar inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente. Evite imprimir este mensaje si no es estrictamente necesario.
This email and any file attached to it (when applicable) contain(s) confidential information that is exclusively addressed to its recipient(s). If you are not the indicated recipient, you are informed that reading, using, disseminating and/or copying it without authorisation is forbidden in accordance with the legislation in effect. If you have received this email by mistake, please immediately notify the sender of the situation by resending it to their email address. Avoid printing this message if it is not absolutely necessary. _______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Este correo electrónico y, en su caso, cualquier fichero anexo al mismo, contiene información de carácter confidencial exclusivamente dirigida a su destinatario o destinatarios. Si no es vd. el destinatario indicado, queda notificado que la lectura, utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. En el caso de haber recibido este correo electrónico por error, se ruega notificar inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente. Evite imprimir este mensaje si no es estrictamente necesario.
This email and any file attached to it (when applicable) contain(s) confidential information that is exclusively addressed to its recipient(s). If you are not the indicated recipient, you are informed that reading, using, disseminating and/or copying it without authorisation is forbidden in accordance with the legislation in effect. If you have received this email by mistake, please immediately notify the sender of the situation by resending it to their email address. Avoid printing this message if it is not absolutely necessary.
participants (5)
-
Adam Armstrong -
Asensio Sánchez, Juan -
Patrick Marquetecken -
Shaun Courtney -
Tom Laermans