Forum GLPI-Project

ToToR

Member

Registered: 2010-01-27

Posts: 7

Plug in Fusioninventory et adressage IP

Bonjour,

J'utilise GLPI en version 0.78, avec les plugins adressage ip ( 1.8) et fusioninventory (2.3.1).

J'ai bien ma liste d'équipement lorsque je visualise la liste des ip. En revanche, dès que j'active le plugin Fusion inventory, ma liste d'ip d'adressage IP est vide, toutes les ip sont considérées comme libre.

Si je désactive le plugin fusioninventory, la liste est de nouveaux renseignée....

D'autres personnes ont-elles constatées ces disfonctionnements ?

Merci de vos remarques et propositions ...

ddurieux

Plugins Dev

From: Propières, France

Registered: 2005-06-17

Posts: 7,521

Re: Plug in Fusioninventory et adressage IP

En debug, t'as des erreurs?

ToToR

Member

Registered: 2010-01-27

Posts: 7

Re: Plug in Fusioninventory et adressage IP

En mode debug et à travers l'interface, je n'ai pas d'erreur au niveau des requetes SQL lorsque j'affiche la liste des ip et ce avec le plugin fusioninventory activé ou non ...

Sinon, où puis-je trouver des infos qui te renseignerai ?

Merci d'avance,

edit:

après une courte recherche, j'ai effectivement des erreurs présentes dans file\_logs\sql-errors.log. Il semble que la table glpi_plugin_fusioninventory_unknowndevices' n'existe pas :

*** MySQL query error :
***
SQL: SELECT 0 AS id, \'NetworkEquipment\' AS itemtype, `id` AS on_device, `dev`.`name` AS dname, \'\' AS pname, `ip`, `mac`, `users_id`, INET_ATON(`ip`) AS ipnum FROM `glpi_networkequipments`  dev WHERE INET_ATON(`ip`) >= \'174396929\' AND INET_ATON(`ip`) <= \'174396948\' AND `is_deleted` = 0 AND `is_template` = 0  UNION SELECT `port`.`id`, `itemtype`, `items_id`, `dev`.`name` AS dname, `port`.`name` AS pname, `port`.`ip`, `port`.`mac`, `users_id`, INET_ATON(`port`.`ip`) AS ipnum FROM `glpi_networkports` port, `glpi_computers` dev WHERE `itemtype` = \'Computer\' AND `port`.`items_id` = `dev`.`id` AND INET_ATON(`port`.`ip`) >= \'174396929\' AND INET_ATON(`port`.`ip`) <= \'174396948\' AND `is_deleted` = 0 AND `is_template` = 0  UNION SELECT `port`.`id`, `itemtype`, `items_id`, `dev`.`name` AS dname, `port`.`name` AS pname, `port`.`ip`, `port`.`mac`, `users_id`, INET_ATON(`port`.`ip`) AS ipnum FROM `glpi_networkports` port, `glpi_networkequipments` dev WHERE `itemtype` = \'NetworkEquipment\' AND `port`.`items_id` = `dev`.`id` AND INET_ATON(`port`.`ip`) >= \'174396929\' AND INET_ATON(`port`.`ip`) <= \'174396948\' AND `is_deleted` = 0 AND `is_template` = 0  UNION SELECT `port`.`id`, `itemtype`, `items_id`, `dev`.`name` AS dname, `port`.`name` AS pname, `port`.`ip`, `port`.`mac`, `users_id`, INET_ATON(`port`.`ip`) AS ipnum FROM `glpi_networkports` port, `glpi_printers` dev WHERE `itemtype` = \'Printer\' AND `port`.`items_id` = `dev`.`id` AND INET_ATON(`port`.`ip`) >= \'174396929\' AND INET_ATON(`port`.`ip`) <= \'174396948\' AND `is_deleted` = 0 AND `is_template` = 0  UNION SELECT `port`.`id`, `itemtype`, `items_id`, `dev`.`name` AS dname, `port`.`name` AS pname, `port`.`ip`, `port`.`mac`, `users_id`, INET_ATON(`port`.`ip`) AS ipnum FROM `glpi_networkports` port, `glpi_peripherals` dev WHERE `itemtype` = \'Peripheral\' AND `port`.`items_id` = `dev`.`id` AND INET_ATON(`port`.`ip`) >= \'174396929\' AND INET_ATON(`port`.`ip`) <= \'174396948\' AND `is_deleted` = 0 AND `is_template` = 0  UNION SELECT `port`.`id`, `itemtype`, `items_id`, `dev`.`name` AS dname, `port`.`name` AS pname, `port`.`ip`, `port`.`mac`, `users_id`, INET_ATON(`port`.`ip`) AS ipnum FROM `glpi_networkports` port, `glpi_phones` dev WHERE `itemtype` = \'Phone\' AND `port`.`items_id` = `dev`.`id` AND INET_ATON(`port`.`ip`) >= \'174396929\' AND INET_ATON(`port`.`ip`) <= \'174396948\' AND `is_deleted` = 0 AND `is_template` = 0  UNION SELECT `port`.`id`, `itemtype`, `items_id`, `dev`.`name` AS dname, `port`.`name` AS pname, `port`.`ip`, `port`.`mac`, `users_id`, INET_ATON(`port`.`ip`) AS ipnum FROM `glpi_networkports` port, `glpi_plugin_fusioninventory_unknowndevices` dev WHERE `itemtype` = \'PluginFusioninventoryUnknownDevice\' AND `port`.`items_id` = `dev`.`id` AND INET_ATON(`port`.`ip`) >= \'174396929\' AND INET_ATON(`port`.`ip`) <= \'174396948\' AND `is_deleted` = 0 AND `is_template` = 0
Error: Table 'glpi.glpi_plugin_fusioninventory_unknowndevices' doesn't exist
Backtrace :
E:\serveur\xampp\htdocs\infosar\plugins\addressing\inc\addressing.class.php&nbsp;:338        DBmysql->query()
E:\serveur\xampp\htdocs\infosar\plugins\addressing\inc\addressing.class.php&nbsp;:364        PluginAddressingAddressing->compute()
E:\serveur\xampp\htdocs\infosar\plugins\addressing\ajax\addressing.tabs.php&nbsp;:56        PluginAddressingAddressing->showReport()
E:/serveur/xampp/htdocs/infosar/plugins/addressing/ajax/addressing.tabs.php

Last edited by ToToR (2011-04-27 18:23:05)

ToToR

Member

Registered: 2010-01-27

Posts: 7

Re: Plug in Fusioninventory et adressage IP

apres une dés-installation et ré-installation complète du plugin fusioninventory, j'ai maitenant ce message d'erreur quand j'ouvre un rapport d'IP:
2011-04-27 19:09 [2@XXXX-OCS-B]
*** MySQL query error :
***
SQL: SELECT 0 AS id, \'NetworkEquipment\' AS itemtype, `id` AS on_device, `dev`.`name` AS dname, \'\' AS pname, `ip`, `mac`, `users_id`, INET_ATON(`ip`) AS ipnum FROM `glpi_networkequipments`  dev WHERE INET_ATON(`ip`) >= \'175049729\' AND INET_ATON(`ip`) <= \'175049748\' AND `is_deleted` = 0 AND `is_template` = 0  UNION SELECT `port`.`id`, `itemtype`, `items_id`, `dev`.`name` AS dname, `port`.`name` AS pname, `port`.`ip`, `port`.`mac`, `users_id`, INET_ATON(`port`.`ip`) AS ipnum FROM `glpi_networkports` port, `glpi_computers` dev WHERE `itemtype` = \'Computer\' AND `port`.`items_id` = `dev`.`id` AND INET_ATON(`port`.`ip`) >= \'175049729\' AND INET_ATON(`port`.`ip`) <= \'175049748\' AND `is_deleted` = 0 AND `is_template` = 0  UNION SELECT `port`.`id`, `itemtype`, `items_id`, `dev`.`name` AS dname, `port`.`name` AS pname, `port`.`ip`, `port`.`mac`, `users_id`, INET_ATON(`port`.`ip`) AS ipnum FROM `glpi_networkports` port, `glpi_networkequipments` dev WHERE `itemtype` = \'NetworkEquipment\' AND `port`.`items_id` = `dev`.`id` AND INET_ATON(`port`.`ip`) >= \'175049729\' AND INET_ATON(`port`.`ip`) <= \'175049748\' AND `is_deleted` = 0 AND `is_template` = 0  UNION SELECT `port`.`id`, `itemtype`, `items_id`, `dev`.`name` AS dname, `port`.`name` AS pname, `port`.`ip`, `port`.`mac`, `users_id`, INET_ATON(`port`.`ip`) AS ipnum FROM `glpi_networkports` port, `glpi_printers` dev WHERE `itemtype` = \'Printer\' AND `port`.`items_id` = `dev`.`id` AND INET_ATON(`port`.`ip`) >= \'175049729\' AND INET_ATON(`port`.`ip`) <= \'175049748\' AND `is_deleted` = 0 AND `is_template` = 0  UNION SELECT `port`.`id`, `itemtype`, `items_id`, `dev`.`name` AS dname, `port`.`name` AS pname, `port`.`ip`, `port`.`mac`, `users_id`, INET_ATON(`port`.`ip`) AS ipnum FROM `glpi_networkports` port, `glpi_peripherals` dev WHERE `itemtype` = \'Peripheral\' AND `port`.`items_id` = `dev`.`id` AND INET_ATON(`port`.`ip`) >= \'175049729\' AND INET_ATON(`port`.`ip`) <= \'175049748\' AND `is_deleted` = 0 AND `is_template` = 0  UNION SELECT `port`.`id`, `itemtype`, `items_id`, `dev`.`name` AS dname, `port`.`name` AS pname, `port`.`ip`, `port`.`mac`, `users_id`, INET_ATON(`port`.`ip`) AS ipnum FROM `glpi_networkports` port, `glpi_phones` dev WHERE `itemtype` = \'Phone\' AND `port`.`items_id` = `dev`.`id` AND INET_ATON(`port`.`ip`) >= \'175049729\' AND INET_ATON(`port`.`ip`) <= \'175049748\' AND `is_deleted` = 0 AND `is_template` = 0  UNION SELECT `port`.`id`, `itemtype`, `items_id`, `dev`.`name` AS dname, `port`.`name` AS pname, `port`.`ip`, `port`.`mac`, `users_id`, INET_ATON(`port`.`ip`) AS ipnum FROM `glpi_networkports` port, `glpi_plugin_fusioninventory_unknowndevices` dev WHERE `itemtype` = \'PluginFusioninventoryUnknownDevice\' AND `port`.`items_id` = `dev`.`id` AND INET_ATON(`port`.`ip`) >= \'175049729\' AND INET_ATON(`port`.`ip`) <= \'175049748\' AND `is_deleted` = 0 AND `is_template` = 0
Error: Unknown column 'users_id' in 'field list'
Backtrace :
E:\serveur\xampp\htdocs\infosar\plugins\addressing\inc\addressing.class.php&nbsp;:338        DBmysql->query()
E:\serveur\xampp\htdocs\infosar\plugins\addressing\inc\addressing.class.php&nbsp;:364        PluginAddressingAddressing->compute()
E:\serveur\xampp\htdocs\infosar\plugins\addressing\ajax\addressing.tabs.php&nbsp;:56        PluginAddressingAddressing->showReport()
E:/serveur/xampp/htdocs/infosar/plugins/addressing/ajax/addressing.tabs.php

Bon je ne sais pas si c'est une avancée, mais ça évolue ....

ddurieux

Plugins Dev

From: Propières, France

Registered: 2005-06-17

Posts: 7,521

Re: Plug in Fusioninventory et adressage IP

Corrigé : http://forge.fusioninventory.org/issues/861

ToToR

Member

Registered: 2010-01-27

Posts: 7

Re: Plug in Fusioninventory et adressage IP

Merci pour ta réactivité. vivement la 2.3.2 ...