Forum GLPI-Project

pierg75

Member

Registered: 2007-05-23

Posts: 7

Sync with ocs

Hi all.
I'm using glpi with ocsinventory-ng and i'm very satisfied.
Since few days i noticed that glpi computer database is not syncronize anymore with ocsinventory database. Even if i do it manually it tells me no new computer or no updates (in ocsinventory i see computer getting upodated every day).
I tried debug mode but i see no errors.
What could it be?
Thank you

Pier

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: Sync with ocs

Are the inventories updated in OCS ?

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

pierg75

Member

Registered: 2007-05-23

Posts: 7

Re: Sync with ocs

Yes it is.

Pier

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: Sync with ocs

which valuehave the CHECKSUM field ?

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

pierg75

Member

Registered: 2007-05-23

Posts: 7

Re: Sync with ocs

This one?

N° 8 :
SELECT *
FROM hardware
WHERE (CHECKSUM & 130503) > 0
ORDER BY LASTDATE
Time: 0.000s

Pier

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: Sync with ocs

non what is really the value of teh CHECKSUM field in the hardware table in the OCS database.

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

pierg75

Member

Registered: 2007-05-23

Posts: 7

Re: Sync with ocs

Ahhh...sorry :-)
This is the value: 568

Pier

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: Sync with ocs

Hum 568 AND 130503 says that no new information have been updated in OCS.

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

nhoeller

Member

From: Toronto, Ontario, Canada

Registered: 2007-05-04

Posts: 9

Re: Sync with ocs

I am seeing the same problem.  I installed perl-doc on one the monitored servers on May 22.  When I checked today, OCS included perl-doc in its inventory.  GLPI had last synchronised on May 21.  When I accessed GLPI today, it synchronised with OCS and showed that OCS data had been imported from the server in question on May 24th.  However, GLPI does not show perl-doc in its software inventory. 

The CHECKSUM value in the OCS hardware table is 568 for all hosts (including the server in question), except for one, which shows 66104 and was lasted imported into GLPI on May 21. 

What sets the CHECKSUM value? 
    thanks, Norbert

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: Sync with ocs

OCS sevrer set the CHECKSUM on inventory.
And GLPI reset this one when datas are imported in GLPI.

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

pierg75

Member

Registered: 2007-05-23

Posts: 7

Re: Sync with ocs

Today i noticed something strange....i checked in the ocsinventory hardware table and i saw there were few computer with checksum 66104.
I made a sync in glpi with ocs and rightly updated these few computers.
Then i check in the computer view and made them in order from by updates....i see no computer be marked as updated today...it looks like the computer are well updated with ocs now, but them are not showed in the computer view.
I have to say that i modify the column view in computer view, but i don't think this could be the problem.

Pier

nhoeller

Member

From: Toronto, Ontario, Canada

Registered: 2007-05-04

Posts: 9

Re: Sync with ocs

There seem to be a number of issues.  I am testing with four hosts inventoried by OCS.  GLPI is etup to synchronise 99 computers during a cron run.  My R40 server was last synchronized on May 21.  The GLPI log showed two cron runs yesterday.  R40 changes were not imported, and the CHECKSUM value showed 66104.  Today, I did a manual sync - GLPI indicated R40 needed to be updated.  After completing the update (a hardware change), CHECKSUM now shows 66104.

In addition, I suspect GLPI is not picking up software adds or deletes when OCS data is imported.

Can someone point me to the code that handles automatic OCS synchronization and detection of changed software?  I'll throw in some traces to see if I can narrow down what the problem might be.
      Thanks, Norbert

nhoeller

Member

From: Toronto, Ontario, Canada

Registered: 2007-05-04

Posts: 9

Re: Sync with ocs

Correction to last post - after doing the manual update, the CHECKSUM value for the R40 server shows 568.

nhoeller

Member

From: Toronto, Ontario, Canada

Registered: 2007-05-04

Posts: 9

Re: Sync with ocs

I am not sure if this is related.  When I checked the glpi_history table and compared the FK_glpi_device value against glpi_computers, I was able to match two entries to their respective servers (verified through the Historical tab).  However, one entry had an FK_glpi_device value that did not exist in glpi_computers.  Also, the first entry glpi_computers (ID=1) has a blank NAME value.
 
Norbert

nataw

Member

Registered: 2007-05-17

Posts: 7

Re: Sync with ocs

where can  you find the CHECKSUM value? Sorry, I'm still new to OCS.

nhoeller

Member

From: Toronto, Ontario, Canada

Registered: 2007-05-04

Posts: 9

Re: Sync with ocs

in mysql, I did a 'use ocsweb;' and then

mysql> select id, checksum from hardware;
+----+----------+
| id | checksum |
+----+----------+
|  4 |    66360 |
|  3 |    66361 |
|  2 |   131071 |
|  1 |   131071 |
+----+----------+