Got that problem too, but not all Servers are shown twice, some are not. Observium CE 0.16.1.7533 (26th January 2016)
Von: observium [mailto:observium-bounces@observium.org] Im Auftrag von Christian Gerbrandt Gesendet: Mittwoch, 3. Februar 2016 10:00 An: Observium Network Observation System Betreff: Re: [Observium] duplicate entries in vminfo table . [SEC=UNCLASSIFIED]
I have the same with our monitoring. All the vmware servers show all vms twice.
On Feb 02, 2016, at 11:48 PM, Peter.Hine@familycourt.gov.aumailto:Peter.Hine@familycourt.gov.au wrote:
vCE 0.16.1.7533
going to the VMs tab of a vmWare server shows duplicate entries.
hunting this down in the code shows the following in html/pages/device/vm.inc.php
foreach (dbFetchRows("SELECT * FROM vminfo WHERE device_id = ? ORDER BY vm_name", array($device['device_id'])) as $vm) { print_vm_row($vm, $device); }
so running it on the command line echo 'SELECT * FROM vminfo WHERE device_id = '586' ORDER BY vm_name' | mysql --user=observium --password=not_my_pass observium
reveals the entries to be duplicated in the table.
they all seem to have the last field as a difference. there must be something missing in the code for adding the entries to not find the first entries and update them.
" 2586 586 vmware cbr-desktop E: tools not running 3072 2 powered off 4239aa20-542a-f088-dedf-afb508da6a9c NULL 2757 586 vmware cbr-desktop E: tools not running 3072 2 powered off 4239aa20-542a-f088-dedf-afb508da6a9c vmware-snmp "
either NULL or vmware-snmp.
Can someone in the Team give me a sql to remove the bad rows ?
thanks
Peter Hine Senior Technical Support Engineer (Servers) FCoA ITS peter.hine@familycourt.gov.aumailto:peter.hine@familycourt.gov.au
********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************
_______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium Wichtiger Hinweis f?r Mitteilungen an die Stadtverwaltung Neustadt: F?r die rechtsverbindliche elektronische Kommunikation mit der Stadtverwaltung Neustadt an der Weinstra?e steht Ihnen ausschlie?lich folgende E-Mail-Adresse zur Verf?gung: stv-neustadt-weinstrasse@poststelle.rlp.de Bitte beachten Sie unsere Hinweise unter http://www.neustadt.eu/impressum#email