Importing OCS database to GLPI

-ICEBOX- · 2012-06-26 13:23:51

Hi,

I just want to ask regarding on my GLPI testing server. I tried to import 17000+ computers into GLPI. But, I encounter some bug/issue or something that the GLPI got hang upon importing. When I tried to click the "Import new computers" from OCS database the GLPI will hang and nothing will appear. I tried to reduce the count from 17000+ to 14500 to be exact then it will appear all computers on the list. Upon importing and choose 10000 items it will only import 999 computers then after importing I tried again to click the "Import new computers" it will hang again and again.. Is there other settings or configuration to be made in the server or plugins so that it will sync all the computers... What is the cause of hanging upon importing is it on server specs? My server specs is Core 2 with 2GB memory and 250HDD. Hope someone can assist me regarding on my concern...

Thanks..

wawa · 2012-06-28 07:46:54

hello
what's your php's memory_limit ?

teguh.umar · 2012-07-02 03:56:10

as wawa said, it probably caused by php time out, php memory limit in php config file, may be you can try changing the value to meet your need

teguh.umar · 2012-07-02 04:45:03

sorry wrong room

Last edited by teguh.umar (2012-07-02 04:56:27)

-ICEBOX- · 2012-07-05 03:20:02

The maximum memory_limit was 128M but I tried it to 256M, 384M and 512M but its still got hang.. Is there other way to fix this? I try this only in testing environment which have 17,287 computers to be exact but I can't syn them. I already remove 3,000+ to 4,000+ computers on my GLPI testing environment and it can only read 14,400. Upon synchronizing the 999 computers then it will hang again. Is there other way to read all the data without removing some records? we have more than 18,000 computers record on productions.. Thanks...

teguh.umar · 2012-07-05 04:26:19

what about max_execution_time? or may be you could try ocs import plugin, and setup the plugin to import from OCS with your desire time. I have use it and i have never import form ocs to glpi manually

-ICEBOX- · 2012-07-05 06:09:29

thanks for the info.. i tried to change max_execution_time and max_input_time to 1800(in seconds) and now its working.. GLPI can now read 17,000+ workstations.. Thanks...

remi · 2012-07-05 06:37:25

For large DB, I will recommend you to use masscosimport plugin instead of buildin feature.

As sync is run from command line, there is no memory time limit
Sync is also faster (can be parallelized on linux)

teguh.umar · 2012-07-05 06:50:45

Agree with remi, that is the best way

-ICEBOX- · 2012-07-12 08:15:15

the syncing of WS more than 17ooo workstation are now working.. but there's a problem in software.. its not syncing.. there's no record coming from OCS database going to GLPI. there's an empty software.. but the configuration of OCS importing is "Use the OCSNG software dictionary - yes" and "software - yes". is there other things to do?

by the way i'm using the latest/stable version and using latest plugins for ocsmassimport... thanks.

Last edited by -ICEBOX- (2012-07-12 08:45:39)

teguh.umar · 2012-07-12 09:38:03

I've had that problem too, but I forgot where is exactly the problem is. May be you can try to setup :
Home >Setup >OCSNG mode, and choose at software = unit import

-ICEBOX- · 2012-07-12 10:28:54

I already did that but unfortunately nothing happen.. but when im using the old one 0.80.2 if im not mistaken.. its easy to configure that settings.. but in 0.83 i dont know what is wrong on my configuration...

-ICEBOX- · 2012-07-13 04:42:40

I tried to upgrade to 0.83.31 version and all plugins to its newest version but still there are no list in software category.. im using OCS dictionary and the software with unit import value. anyone know how to fix this issue.. thanks..

-ICEBOX- · 2012-07-13 04:53:03

sorry for confusing.. I already fixed my issue.. thanks.. now its totally working..

-ICEBOX- · 2012-07-13 09:16:28

I am now going to sync all the workstation on GLPI but when I choose 1000 workstation its say's

"The action you have requested is not allowed. Reload previous page before doing action again."

I'm using the "glpi" user. Is there other configuration to edit just to make a thousand workstation to sync?

Thanks..

-ICEBOX- · 2012-07-17 05:17:22

I encountered this message again in configuration of email. I tried to set an email admin account but after clicking the updating this message "The action you have requested is not allowed. Reload previous page before doing action again." will prompt again.. I'm using the super-admin account so im aware that super-admin account is allowed to configure that notification. anyone how to re-configure this message so that I can granted the user to use the email notification. Thanks..

Last edited by -ICEBOX- (2012-07-17 06:03:04)

Forum GLPI-Project

Announcement

#1 2012-06-26 13:23:51

Importing OCS database to GLPI

#2 2012-06-28 07:46:54

Re: Importing OCS database to GLPI

#3 2012-07-02 03:56:10

Re: Importing OCS database to GLPI

#4 2012-07-02 04:45:03

Re: Importing OCS database to GLPI

#5 2012-07-05 03:20:02

Re: Importing OCS database to GLPI

#6 2012-07-05 04:26:19

Re: Importing OCS database to GLPI

#7 2012-07-05 06:09:29

Re: Importing OCS database to GLPI

#8 2012-07-05 06:37:25

Re: Importing OCS database to GLPI

#9 2012-07-05 06:50:45

Re: Importing OCS database to GLPI

#10 2012-07-12 08:15:15

Re: Importing OCS database to GLPI

#11 2012-07-12 09:38:03

Re: Importing OCS database to GLPI

#12 2012-07-12 10:28:54

Re: Importing OCS database to GLPI

#13 2012-07-13 04:42:40

Re: Importing OCS database to GLPI

#14 2012-07-13 04:53:03

Re: Importing OCS database to GLPI

#15 2012-07-13 09:16:28

Re: Importing OCS database to GLPI

#16 2012-07-17 05:17:22

Re: Importing OCS database to GLPI

Board footer