Re: [Glpi-dev] Add VirtualMachine to Server.

2011-04-11 Thread Ludovic Hutin

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.

2011-04-11 Thread Walid nouh
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