Processor not displaying with OCSNG Agent

gmourani · 2017-07-19 17:09:34

I've OCS-NG_WINDOWS_AGENT_v2.1.1.3 installed on my Windows 10 machine with ocsinventory-server-2.1.2 installed on Linux CentOS 6.x with GLPI 9.1.5. In the OCS Inventory reports page, I can see my processor type but in GLPI this field do not appears?

Regards,

tsmr · 2017-07-19 17:49:02

When you go on this page http://.../plugins/ocsinventoryng/front/ocsserver.form.php?id=X, you will see the OCS server version : Exemple 7005..

Can you give me the value of version ?

gmourani · 2017-07-19 17:57:36

It's version 7006

tsmr · 2017-07-19 17:58:22

Have you activate the processors import into server setup into the plugin ?

gmourani · 2017-07-19 20:59:50

Yes, everything are activate under 'Components'. Processor, Hard drive, Graphics device, etc... If I check inside the SQL database under the 'glpi_deviceprocessors' table, I can see the entry related to the processor type onto the designation column.

tsmr · 2017-07-20 10:29:32

Can you see if you have errors into glpi/files/logs related to ocs ?

gmourani · 2017-07-20 14:43:32

This one seem to be related to fusioninventory and come from the sql-errors.log file:
*** MySQL query error:
SQL: SELECT *
FROM `glpi_plugin_fusioninventory_collects` WHERE ( `glpi_plugin_fusioninventory_collects`.`entities_id` IN () )
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') )' at line 2
Backtrace :
inc/commondbtm.class.php:263
plugins/fusioninventory/inc/collect.class.php:131 CommonDBTM->find()
plugins/fusioninventory/hook.php:264 PluginFusioninventoryCollect::getSearchOptionsToAdd()
inc/plugin.class.php:1287 plugin_fusioninventory_getAddSearchOptions()
inc/search.class.php:5462 Plugin::getAddSearchOptions()
inc/log.class.php:124 Search::getOptions()
inc/commondbtm.class.php:381 Log::constructHistory()
inc/commondbtm.class.php:1146 CommonDBTM->updateInDB()
...ins/ocsinventoryng/inc/ocsserver.class.php:3286 CommonDBTM->update()
...ins/ocsinventoryng/inc/ocsserver.class.php:2954 PluginOcsinventoryngOcsServer::updateHardware()
...ins/ocsinventoryng/inc/ocsserver.class.php:2591 PluginOcsinventoryngOcsServer::updateComputer()
...ins/ocsinventoryng/inc/ocsserver.class.php:2072 PluginOcsinventoryngOcsServer::importComputer()
...s/ocsinventoryng/scripts/ocsng_fullsync.php:410 PluginOcsinventoryngOcsServer::processComputer()
...s/ocsinventoryng/scripts/ocsng_fullsync.php:290 plugin_ocsinventoryng_importFromOcsServer()
...s/ocsinventoryng/scripts/ocsng_fullsync.php:160 SecondPass()

This one comme from the php-errors.log file:
*** PHP Notice(8): Undefined index: COMPUTERS
Backtrace :
...s/ocsinventoryng/scripts/ocsng_fullsync.php:214
...ns/ocsinventoryng/scripts/ocsng_fullsync.php:96 FirstPass()

Backtrace :
:
...inventoryng/inc/ipdiscoverocslink.class.php:670 fopen()
plugins/ocsinventoryng/front/ocsng.php:59 PluginOcsinventoryngIpdiscoverOcslink::loadMacConstructor()
2017-07-18 14:37:18 [2@blesk0.privalodc.lan]
*** PHP Warning(2): fopen(/var/www/html/glpi/plugins/ocsinventoryng/files/macManufacturers.txt): failed to open stream: No such file or directory

But I can't see nothing related to processors on the logs.

tsmr · 2017-07-20 15:44:55

Which version of ocsinventoryng plugin please ?

gmourani · 2017-07-20 15:49:55

Version 1.3.3.

tsmr · 2017-07-20 16:03:16

Can you try to unactivate Fusion plugin & try to force synchronization for see if you have error logs or if cpu are imported ?

gmourani · 2017-07-20 16:09:28

The result is the same, CPU still not displayed on the WUI of GLPI but available onto the database under the 'glpi_deviceprocessors' table.

tsmr · 2017-07-20 17:15:59

And no errors on logs ?

gmourani · 2017-07-20 17:57:56

No, nothing in the logs. Look to me that the agent installed on Windows send the information to the OCSNG DB and that GLPI also get the information from the OCSNG DB correctly but for some strange reason, CPU Type information do not appears in GLPI WUI. I've suspected that maybe it's a bug in the SQL request on the code, but here again, nothing in the logs.

Maybe it's something with the display in GLPI that hide the CPU part information ?

tsmr · 2017-07-24 09:16:27

Have you activate Logs in files option into GLPI setup ? or Debug mode ?

Maximiliano · 2017-08-02 16:36:19

I have the some problem. My version of GLPI is 9.14 and the OCS 2.3.1 version 7011. Thanks

jgosse · 2017-08-03 17:27:38

I have the same probleme . When i see in mysql table glpi_items_device_processors the last_id 42709 , last computers id=7108 and in the table glpi_computers the last id is 7705
I think Ocs import not increment table glpi_items_device_processors . Do you have a idea ?

Last edited by jgosse (2017-08-03 17:30:10)

gmourani · 2017-08-16 20:09:40

Correction: The glpi_deviceprocessors table is empty and doesn't contains the Processor entry available under the OCSNG DB. Look like this part is not imported into GLPI! The Processor component is set to 'Yes' under "Data to import" tab.

CIVODUL4 · 2017-10-27 22:40:07

Does any of you find an answer guys ?

I'm having the same problem. My own topic

gmourani · 2017-10-28 01:54:58

Yes, I've been able to make it work by updating the OCS Agent installed on Windows to version 2.1.1.3.

freeall · 2017-11-02 09:48:11

Have you activate the processors import into server setup into the plugin ?

Forum GLPI-Project

Announcement

#1 2017-07-19 17:09:34

Processor not displaying with OCSNG Agent

#2 2017-07-19 17:49:02

Re: Processor not displaying with OCSNG Agent

#3 2017-07-19 17:57:36

Re: Processor not displaying with OCSNG Agent

#4 2017-07-19 17:58:22

Re: Processor not displaying with OCSNG Agent

#5 2017-07-19 20:59:50

Re: Processor not displaying with OCSNG Agent

#6 2017-07-20 10:29:32

Re: Processor not displaying with OCSNG Agent

#7 2017-07-20 14:43:32

Re: Processor not displaying with OCSNG Agent

#8 2017-07-20 15:44:55

Re: Processor not displaying with OCSNG Agent

#9 2017-07-20 15:49:55

Re: Processor not displaying with OCSNG Agent

#10 2017-07-20 16:03:16

Re: Processor not displaying with OCSNG Agent

#11 2017-07-20 16:09:28

Re: Processor not displaying with OCSNG Agent

#12 2017-07-20 17:15:59

Re: Processor not displaying with OCSNG Agent

#13 2017-07-20 17:57:56

Re: Processor not displaying with OCSNG Agent

#14 2017-07-24 09:16:27

Re: Processor not displaying with OCSNG Agent

#15 2017-08-02 16:36:19

Re: Processor not displaying with OCSNG Agent

#16 2017-08-03 17:27:38

Re: Processor not displaying with OCSNG Agent

#17 2017-08-16 20:09:40

Re: Processor not displaying with OCSNG Agent

#18 2017-10-27 22:40:07

Re: Processor not displaying with OCSNG Agent

#19 2017-10-28 01:54:58

Re: Processor not displaying with OCSNG Agent

#20 2017-11-02 09:48:11

Re: Processor not displaying with OCSNG Agent

Board footer