You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2012-08-30 12:30:14

adrianmarsh
Member
Registered: 2006-08-28
Posts: 379

NIC Cards = Huge database

Hi All,

I'm running GLPI 0.84.3, and OCS 1.01.    Yes the OCS is an old version, but at this point I can't upgrade it just yet.

What I've noticed is that in GLPI, when looking at NIC cards (macs etc), it shows many hundreds of duplicates (same mac/nic etc), for a lot of PCs.   So many, that when I do an SQL backup, the NIC table in GLPI is 700,000 entries, but I've only 400 PCs.

Looking at the OCS database, that only shows the correct number of NICs and MACs..

So - something in the Sync seems to be causing this, and I think its been happening for sometime.

I've two questions:

1) Is this a known issue ?
2) If I hack the GLPI database, and delete the whole NIC table contents, will GLPI/OCS re-sync the macs etc back into GLPI properly at the next sync ?

Fom the GUI I can't seem to 'delete' NICs manually.  Doesn't seem to do this with CPUs, memory, USB ports etc.


GLPI 0.83.91/CENTOS5 - OCS 1.01/Win2003

Offline

#2 2012-08-30 12:34:33

adrianmarsh
Member
Registered: 2006-08-28
Posts: 379

Re: NIC Cards = Huge database

Correction:  Its also doing this on Bluetooth PAN networks as well


GLPI 0.83.91/CENTOS5 - OCS 1.01/Win2003

Offline

#3 2012-08-30 13:08:28

adrianmarsh
Member
Registered: 2006-08-28
Posts: 379

Re: NIC Cards = Huge database

ok, as a test I manually deleted a NIC from my own PCs list.  I then re-ran the OCS inventory tool, and that re-sync'd across ok, just one NIC entry per NIC.

I then deleted my own PCs other NICs, but didn't run an Inventory...  GLPI listed these NICs as 'locked' under the OCS_NG tab.  I Unlocked them, and now they appear, but I'll see if the next sync creates duplicates.


GLPI 0.83.91/CENTOS5 - OCS 1.01/Win2003

Offline

#4 2013-04-09 17:06:05

adrianmarsh
Member
Registered: 2006-08-28
Posts: 379

Re: NIC Cards = Huge database

Anyone else seeing this that has a fix ??

My GLPI database is filling up with 1000s of duplicate NICs, making it almost unmanageable


GLPI 0.83.91/CENTOS5 - OCS 1.01/Win2003

Offline

#5 2013-04-09 17:07:27

adrianmarsh
Member
Registered: 2006-08-28
Posts: 379

Re: NIC Cards = Huge database

Note: Checking OCS itself, it only shows the right number of NICs. So its something in the sync thats making this happen.

Now onv:  1.01 OCS and 0.83.4 of GLPI

I've not seen anything up to 0.83.70 release notes indicating an issue thats been fixed.


GLPI 0.83.91/CENTOS5 - OCS 1.01/Win2003

Offline

Board footer

Powered by FluxBB