Re: [Glpi-dev] Add VirtualMachine to Server.
Hi, Well i just play with the inventory and it's work perfect, the ESX is link to virtual machine and the virtual machine is link to the ESX. (very very nice !) We do the inventory with the root password... too bad ! Which permission is required for the ESX to do that ? We try a read only access, but it doesn't work. I have another question about cluster, if we have a cluster with 3 ESX, a computer can automaticaly move to another ESX1/ESX2/ESX3. How it work's with the inventory ? It's only a real time snapshot ? Is there a link between the ESX to said there are un cluster mode ? Thanks, Ludovic. Le 11/04/2011 12:29, Walid nouh a écrit : Great news Ludovic ! I'm currently working on the UI to define ESX credentials, and send informations to the agents. Walid. On 11/04/2011 12:30, Ludovic Hutin wrote: Hello, Sorry for the mail, it's work perfect with an ESX 3.5.0 and with the fusioninventor 2.4.0-beta1 Ludovic. Le 11/04/2011 11:30, Walid nouh a écrit : Hello, For GLPI 0.80RC2, you need to use FusionInventory for GLPI 2.4.0 beta 1. Version 2.3.0 is only for 0.78.x. Walid. On 11/04/2011 11:29, Ludovic Hutin wrote: Hi, I have no yet tried with the last tarball, I just reinstall a fresh glpi 0.80 -rc2 with the fusionplugin 2.3.0-rc1 I hope this will help. PHP Error : Warning(2): mysql_num_rows() expects parameter 1 to be resource, boolean given Backtrace : /var/www/glpi-0.80-rc2/inc/common.function.php:342 userErrorHandlerNormal() /var/www/glpi-0.80-rc2/inc/dbmysql.class.php:241 mysql_num_rows() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/ruleimportequipment.class.php:485 DBmysql-numrows() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/rule.class.php:830 PluginFusioninventoryRuleImportEquipment-findWithGlobalCriteria() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/rule.class.php:774 PluginFusioninventoryRule-checkCriterias() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/rulecollection.class.php:666 PluginFusioninventoryRule-process() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/inc/inventory.class.php:135 PluginFusioninventoryRuleCollection-processAllRules() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/inc/importxml.class.php:89 PluginFusinvinventoryInventory-sendCriteria() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/front/importxml.php:52 PluginFusinvinventoryImportXML-importXMLFile() MySQL Erreur : 2011-04-11 11:16 [2@localhost] *** MySQL query error : *** SQL: SELECT `glpi_computers`.`id` FROM `glpi_computers` LEFT JOIN `glpi_networkports` ON (`glpi_computers`.`id` = `glpi_networkports`.`items_id` AND `glpi_networkports`.`itemtype` = \'Computer\') LEFT JOIN `glpi_plugin_fusinvinventory_computers` ON `glpi_plugin_fusinvinventory_computers`.`items_id` = `glpi_computers`.`id` WHERE `glpi_computers`.`is_template` = \'0\' AND `uuid`=\44454c4c-3000-1038-8043-b4c04f30344a\ GROUP BY `glpi_computers`.`id` ORDER BY `glpi_computers`.`is_deleted` ASC Error: Column 'uuid' in where clause is ambiguous Backtrace : /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/ruleimportequipment.class.phpnbsp;:483 DBmysql-query() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/rule.class.phpnbsp;:830 PluginFusioninventoryRuleImportEquipment-findWithGlobalCriteria() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/rule.class.phpnbsp;:774 PluginFusioninventoryRule-checkCriterias() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/rulecollection.class.phpnbsp;:666 PluginFusioninventoryRule-process() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/inc/inventory.class.phpnbsp;:135 PluginFusioninventoryRuleCollection-processAllRules() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/inc/importxml.class.phpnbsp;:89 PluginFusinvinventoryInventory-sendCriteria() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/front/importxml.phpnbsp;:52 PluginFusinvinventoryImportXML-importXMLFile() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/front/importxml.php I will try the last tarball. Thanks, Ludovic. Le 01/04/2011 12:49, Walid nouh a écrit : Hi Ludovic, Can you try the lastest FusionInventory for GLPI tarball ? http://prebuilt.fusioninventory.org/fusioninventory-4-glpi/devel/ Thanks, Walid. On 01/04/2011 12:10, Ludovic Hutin wrote: Hi, I am running the glpi 0.80 RC1 and fusioninventory 3.4.0 beta I try to import an inventory made by fusioninventory-agent-task-esx The esx is succesfully register but not the virtualmachine. When i login to glpi, and click to add news virtual machine, i got the error : *Vous n'avez pas les droits requis pour réaliser cette action. *I am log with the glpi user,
Re: [Glpi-dev] Add VirtualMachine to Server.
1) the idea is to have a form to declare credentials for ESX and link them to computers (hosts). in your case, you create a new Credential (root, with a password), and link it to the ESX computer in GLPI. 2) the fusioninventory-agent will ask the server what to do, and the server will give it the IP and credential of you ESX (see http://forge.fusioninventory.org/projects/fusioninventory-agent/wiki/API-REST-esx) 3) the host/vm link isn't store in DB. It's computed each time to display the forms. So if you move one vm to another, and then do remote host inventory, the vm shoud be inventoried correctly. The best would be to test it, but I don't have the hardware here. (if you want to test it, you're more than welcome !). Walid. On 11/04/2011 14:43, Ludovic Hutin wrote: Hi, Well i just play with the inventory and it's work perfect, the ESX is link to virtual machine and the virtual machine is link to the ESX. (very very nice !) We do the inventory with the root password... too bad ! Which permission is required for the ESX to do that ? We try a read only access, but it doesn't work. I have another question about cluster, if we have a cluster with 3 ESX, a computer can automaticaly move to another ESX1/ESX2/ESX3. How it work's with the inventory ? It's only a real time snapshot ? Is there a link between the ESX to said there are un cluster mode ? Thanks, Ludovic. Le 11/04/2011 12:29, Walid nouh a écrit : Great news Ludovic ! I'm currently working on the UI to define ESX credentials, and send informations to the agents. Walid. On 11/04/2011 12:30, Ludovic Hutin wrote: Hello, Sorry for the mail, it's work perfect with an ESX 3.5.0 and with the fusioninventor 2.4.0-beta1 Ludovic. Le 11/04/2011 11:30, Walid nouh a écrit : Hello, For GLPI 0.80RC2, you need to use FusionInventory for GLPI 2.4.0 beta 1. Version 2.3.0 is only for 0.78.x. Walid. On 11/04/2011 11:29, Ludovic Hutin wrote: Hi, I have no yet tried with the last tarball, I just reinstall a fresh glpi 0.80 -rc2 with the fusionplugin 2.3.0-rc1 I hope this will help. PHP Error : Warning(2): mysql_num_rows() expects parameter 1 to be resource, boolean given Backtrace : /var/www/glpi-0.80-rc2/inc/common.function.php:342 userErrorHandlerNormal() /var/www/glpi-0.80-rc2/inc/dbmysql.class.php:241 mysql_num_rows() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/ruleimportequipment.class.php:485 DBmysql-numrows() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/rule.class.php:830 PluginFusioninventoryRuleImportEquipment-findWithGlobalCriteria() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/rule.class.php:774 PluginFusioninventoryRule-checkCriterias() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/rulecollection.class.php:666 PluginFusioninventoryRule-process() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/inc/inventory.class.php:135 PluginFusioninventoryRuleCollection-processAllRules() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/inc/importxml.class.php:89 PluginFusinvinventoryInventory-sendCriteria() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/front/importxml.php:52 PluginFusinvinventoryImportXML-importXMLFile() MySQL Erreur : 2011-04-11 11:16 [2@localhost] *** MySQL query error : *** SQL: SELECT `glpi_computers`.`id` FROM `glpi_computers` LEFT JOIN `glpi_networkports` ON (`glpi_computers`.`id` = `glpi_networkports`.`items_id` AND `glpi_networkports`.`itemtype` = \'Computer\') LEFT JOIN `glpi_plugin_fusinvinventory_computers` ON `glpi_plugin_fusinvinventory_computers`.`items_id` = `glpi_computers`.`id` WHERE `glpi_computers`.`is_template` = \'0\' AND `uuid`=\44454c4c-3000-1038-8043-b4c04f30344a\ GROUP BY `glpi_computers`.`id` ORDER BY `glpi_computers`.`is_deleted` ASC Error: Column 'uuid' in where clause is ambiguous Backtrace : /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/ruleimportequipment.class.phpnbsp;:483 DBmysql-query() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/rule.class.phpnbsp;:830 PluginFusioninventoryRuleImportEquipment-findWithGlobalCriteria() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/rule.class.phpnbsp;:774 PluginFusioninventoryRule-checkCriterias() /var/www/glpi-0.80-rc2/plugins/fusioninventory/inc/rulecollection.class.phpnbsp;:666 PluginFusioninventoryRule-process() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/inc/inventory.class.phpnbsp;:135 PluginFusioninventoryRuleCollection-processAllRules() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/inc/importxml.class.phpnbsp;:89 PluginFusinvinventoryInventory-sendCriteria() /var/www/glpi-0.80-rc2/plugins/fusinvinventory/front/importxml.phpnbsp;:52