Please, how does ocs sync work? So far no luck :( GLPI 0.78

pchamorro · 2010-11-11 01:29:56

I have the most recent versions of GLPI and OCS under CentOS 5.4 but the synchronization is not working well.

I have 1059 computers in OCS and 1059 in GLPI. That's ok. The sync task is scheduled and working too.

What doesn't work is the sync of components. Specifically, I'm trying doing this kind of tests:

Test 1.

- I have a computer with 2 GB of RAM, imported in GLPI.
- I remove 1 GB of RAM and update the inventory in OCS, but after a sync for that computer, in GLPI it keeps showing 2 GB. No sync.

Test 2.

I have in OCS a computer with 2 GB, in GLPI these memories appear like these:

1 Memory A0 (No ECC) ----> 1 GB
1 Memory A0 (No ECC) ----> 1 GB

Total: 2 GB

Then, I change those values by hand, like this:

1 Memory A0 (No ECC) ----> 1 GB
2 Memory A0 (No ECC) ----> 2 GB

Total: 3 GB

Then, I do a sync to the computer but GLPI keeps showing 3 GB of RAM. No sync.

I've tried with and without the automatic link feature and no luck so far. I've tried also installing the ocsmassimport plugin with the same unsuccessful results.

I appreciate any help.

Pablo Chamorro

pchamorro · 2010-11-11 15:15:47

In the second test I meant to write A0 and A1 (I wrote A0 in both lines).

pchamorro · 2010-11-13 17:24:56

Anyone please? Is it a bug? Is it a non-implemented feature?

steffens · 2010-11-14 23:09:59

Have a look on the OCS tab of the computer and verify you have no locked fields, if you edit fields which OCS syncs to GLPI manually, they will be locked to remain your manual changes! You can unlock them and try to force a sync.

Best regards, Steffens.

pchamorro · 2010-11-16 04:14:31

Steffens, thank you for the answer. I click on the OCSNG tab, and found no fields blocked.

Another test: I deleted some components from my test computer: the processor and memories, and the sync failed again.

I already have the debug mode activated. Here what I got after the test computer sync:

GLPI MODE DEBUG
SQL REQUEST : 9 Queries took 0.091s
N° Queries Time Errors
1 SELECT *
FROM `glpi_plugins`
WHERE (`directory` = 'massocsimport') 0.000
2 SHOW COLUMNS
FROM `glpi_computers` 0.002
3 SHOW COLUMNS
FROM `glpi_computers` 0.002
4 SELECT *
FROM `glpi_displaypreferences`
WHERE `itemtype` = 'Computer' AND `users_id` = '7'
ORDER BY `rank` 0.001
5 SELECT *
FROM `glpi_displaypreferences`
WHERE `itemtype` = 'Computer' AND `users_id` = '0'
ORDER BY `rank` 0.000
6 SHOW COLUMNS
FROM `glpi_computers` 0.002
7 SET SESSION group_concat_max_len = 9999999; 0.000
8 SELECT `glpi_computers`.`name` AS ITEM_0, `glpi_computers`.`id` AS ITEM_0_2, `glpi_manufacturers`.`name` AS ITEM_1, `glpi_computers`.`serial` AS ITEM_2, `glpi_computertypes`.`name` AS ITEM_3, `glpi_computermodels`.`name` AS ITEM_4, `glpi_operatingsystems`.`name` AS ITEM_5, `glpi_locations`.`completename` AS ITEM_6, `glpi_computers`.`date_mod` AS ITEM_7, `glpi_computers`.`contact` AS ITEM_8, GROUP_CONCAT(DISTINCT `glpi_deviceprocessors`.`designation` SEPARATOR '$$$$') AS ITEM_9, SUM(`glpi_computers_devicememories`.`specificity`) / COUNT(`glpi_computers_devicememories`.`id`) * COUNT(DISTINCT `glpi_computers_devicememories`.`id`) AS ITEM_10, `glpi_domains`.`name` AS ITEM_11, `glpi_users_users_id_tech`.`name` AS ITEM_12, `glpi_users_users_id_tech`.`realname` AS ITEM_12_2, `glpi_users_users_id_tech`.`id` AS ITEM_12_3, `glpi_users_users_id_tech`.`firstname` AS ITEM_12_4, SUM(`glpi_computers_deviceprocessors`.`specificity`) / COUNT(`glpi_computers_deviceprocessors`.`id`) AS ITEM_13, SUM(`glpi_computers_deviceharddrives`.`specificity`) / COUNT(`glpi_computers_deviceharddrives`.`id`) * COUNT(DISTINCT `glpi_computers_deviceharddrives`.`id`) AS ITEM_14, `glpi_computers`.`id` AS id
FROM `glpi_computers`
LEFT JOIN `glpi_manufacturers` ON (`glpi_computers`.`manufacturers_id` = `glpi_manufacturers`.`id`)
LEFT JOIN `glpi_computertypes` ON (`glpi_computers`.`computertypes_id` = `glpi_computertypes`.`id`)
LEFT JOIN `glpi_computermodels` ON (`glpi_computers`.`computermodels_id` = `glpi_computermodels`.`id`)
LEFT JOIN `glpi_operatingsystems` ON (`glpi_computers`.`operatingsystems_id` = `glpi_operatingsystems`.`id`)
LEFT JOIN `glpi_locations` ON (`glpi_computers`.`locations_id` = `glpi_locations`.`id`)
LEFT JOIN `glpi_computers_deviceprocessors` ON (`glpi_computers`.`id` = `glpi_computers_deviceprocessors`.`computers_id`)
LEFT JOIN `glpi_deviceprocessors` ON (`glpi_computers_deviceprocessors`.`deviceprocessors_id` = `glpi_deviceprocessors`.`id`)
LEFT JOIN `glpi_computers_devicememories` ON (`glpi_computers`.`id` = `glpi_computers_devicememories`.`computers_id`)
LEFT JOIN `glpi_domains` ON (`glpi_computers`.`domains_id` = `glpi_domains`.`id`)
LEFT JOIN `glpi_users` AS glpi_users_users_id_tech ON (`glpi_computers`.`users_id_tech` = `glpi_users_users_id_tech`.`id`)
LEFT JOIN `glpi_computers_deviceharddrives` ON (`glpi_computers`.`id` = `glpi_computers_deviceharddrives`.`computers_id`)
WHERE `glpi_computers`.`is_deleted` = '0' AND `glpi_computers`.`is_template` = '0' AND ( ( `glpi_computers`.`name` LIKE '%chavas%' OR `glpi_manufacturers`.`name` LIKE '%chavas%' OR `glpi_computers`.`serial` LIKE '%chavas%' OR `glpi_computertypes`.`name` LIKE '%chavas%' OR `glpi_computermodels`.`name` LIKE '%chavas%' OR `glpi_operatingsystems`.`name` LIKE '%chavas%' OR `glpi_locations`.`completename` LIKE '%chavas%' OR `glpi_computers`.`date_mod` LIKE '%chavas%' OR `glpi_computers`.`contact` LIKE '%chavas%' OR `glpi_domains`.`name` LIKE '%chavas%' OR (`glpi_users_users_id_tech`.`firstname` LIKE '%chavas%' OR `glpi_users_users_id_tech`.`realname` LIKE '%chavas%' OR CONCAT(`glpi_users_users_id_tech`.`firstname`,' ', `glpi_users_users_id_tech`.`realname`) LIKE '%chavas%' OR `glpi_users_users_id_tech`.`name` LIKE '%chavas%' ) ) ) GROUP BY `glpi_computers`.`id`
ORDER BY ITEM_0 ASC 0.082
9 SHOW COLUMNS
FROM `glpi_computers` 0.002
AUTOLOAD

Search, Computer, CommonDropdown, CommonTreeDropdown, Location, Dropdown, Bookmark, DisplayPreference, Infocom, Document, Contract
POST VARIABLE
KEY => VALUE
itemtype => Computer
num => 0
field => view
searchtype => contains
value => chavas
meta => 0
GET VARIABLE
KEY => VALUE
start => 0
order => ASC
is_deleted => 0
distinct => N
link =>
field =>
KEY => VALUE
0 => view
contains =>
KEY => VALUE
0 => chavas
searchtype =>
KEY => VALUE
0 => contains
link2 =>
field2 =>
KEY => VALUE
0 => view
contains2 =>
KEY => VALUE
0 =>
itemtype2 =>
searchtype2 =>
sort => 1
SESSION VARIABLE
KEY => VALUE
glpi_plugins =>
KEY => VALUE
4 => massocsimport
glpicookietest => testcookie
glpi_use_mode => 2
glpiID => 7
glpiname => xxxxxxxx
glpirealname => xxxxx xxxxxx
glpifirstname => xxxxxx xxxxx
glpidefault_entity => 0
glpiusers_idisation => 1
glpiextauth => 1
glpiauthtype => 3
glpiroot => /glpi
glpicrontimer => 1289872823
glpi_tabs =>
KEY => VALUE
central => 1
computer => 1
glpidate_format => 1
glpidefault_requesttypes_id => 4
glpidropdown_chars_limit => 50
glpifollowup_private => 0
glpitask_private => 0
glpiis_categorized_soft_expanded => 0
glpiis_ids_visible => 0
glpiis_not_categorized_soft_expanded => 1
glpilanguage => es_AR
glpilist_limit => 20
glpinumber_format => 0
glpipriority_1 => #fff2f2
glpipriority_2 => #ffe0e0
glpipriority_3 => #ffcece
glpipriority_4 => #ffbfbf
glpipriority_5 => #ffadad
glpipriority_6 => #ff5555
glpishow_jobs_at_login => 0
glpiuse_flat_dropdowntree => 0
glpiprofiles =>
KEY => VALUE
3 =>
KEY => VALUE
name => admin
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 0
2 =>
KEY => VALUE
name => normal
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 0
1 =>
KEY => VALUE
name => post-only
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 0
4 =>
KEY => VALUE
name => super-admin
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 1
glpiactiveprofile =>
KEY => VALUE
id => 4
name => super-admin
interface => central
is_default => 0
computer => w
monitor => w
software => w
networking => w
printer => w
peripheral => w
cartridge => w
consumable => w
phone => w
notes => w
contact_enterprise => w
document => w
contract => w
infocom => w
knowbase => w
faq => w
reservation_helpdesk => 1
reservation_central => w
reports => r
ocsng => w
view_ocsng => r
sync_ocsng => w
dropdown => w
entity_dropdown => w
device => w
typedoc => w
link => w
config => w
rule_ticket => r
entity_rule_ticket => w
rule_ocs => w
rule_ldap => w
rule_softwarecategories => w
search_config => w
search_config_global => w
check_update => r
profile => w
user => w
user_authtype => w
group => w
entity => w
transfer => w
logs => r
reminder_public => w
bookmark_public => w
backup => w
create_ticket => 1
delete_ticket => 1
add_followups => 1
group_add_followups => 1
global_add_followups => 1
global_add_tasks => 1
update_ticket => 1
update_priority => 1
own_ticket => 1
steal_ticket => 1
assign_ticket => 1
show_all_ticket => 1
show_assign_ticket => 1
show_full_ticket => 1
observe_ticket => 1
update_followups => 1
update_tasks => 1
show_planning => 1
show_group_planning => 1
show_all_planning => 1
statistic => 1
password_update => 1
helpdesk_hardware => 3
helpdesk_item_type =>
KEY => VALUE
0 => Computer
1 => Software
2 => Phone
helpdesk_status =>
show_group_ticket => 0
show_group_hardware => 0
rule_dictionnary_software => w
rule_dictionnary_dropdown => w
budget => w
import_externalauth_users => w
notification => w
rule_mailcollector => w
date_mod =>
comment =>
validate_ticket => 1
create_validation => 1
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 1
glpiactiveentities =>
KEY => VALUE
0 => 0
glpisearch =>
KEY => VALUE
Computer =>
KEY => VALUE
is_deleted => 0
field =>
KEY => VALUE
0 => view
searchtype =>
KEY => VALUE
0 => contains
contains =>
KEY => VALUE
0 => chavas
itemtype => Computer
start => 0
order => ASC
distinct => N
link =>
link2 =>
field2 =>
KEY => VALUE
0 => view
contains2 =>
KEY => VALUE
0 =>
itemtype2 =>
searchtype2 =>
sort => 1
glpisearchcount =>
KEY => VALUE
Computer => 1
glpisearchcount2 =>
KEY => VALUE
Computer => 0
glpiactiveentities_string => '0'
glpiparententities =>
glpiparententities_string =>
glpiactive_entity => 0
glpiactive_entity_name => Entidad Raíz (estructura de arbol)
glpiactive_entity_shortname => Entidad Raíz (estructura de arbol)
glpishowallentities => 1
glpigroups =>
glpi_currenttime => 2010-11-15 21:01:41
MESSAGE_AFTER_REDIRECT =>
glpi_multientitiesmode => 0
ocsservers_id => 1
glpimassiveactionselected =>
glpilisttitle =>
KEY => VALUE
Computer => Lista
DeviceMotherboard => Computador = PAS-CHAVAS
DeviceProcessor => Computador = PAS-CHAVAS
DeviceMemory => Computador = PAS-CHAVAS
DeviceHardDrive => Computador = PAS-CHAVAS
DeviceNetworkCard => Computador = PAS-CHAVAS
DeviceDrive => Computador = PAS-CHAVAS
DeviceControl => Computador = PAS-CHAVAS
DeviceGraphicCard => Computador = PAS-CHAVAS
DeviceSoundCard => Computador = PAS-CHAVAS
DevicePci => Computador = PAS-CHAVAS
DeviceCase => Computador = PAS-CHAVAS
DevicePowerSupply => Computador = PAS-CHAVAS
ComputerDisk => Computador = PAS-CHAVAS
NetworkPort => Computador = PAS-CHAVAS
glpilistitems =>
KEY => VALUE
Computer =>
KEY => VALUE
0 => 1206
DeviceMotherboard =>
DeviceProcessor =>
DeviceMemory =>
DeviceHardDrive =>
DeviceNetworkCard =>
DeviceDrive =>
KEY => VALUE
0 => 5
1 => 147
2 => 148
DeviceControl =>
DeviceGraphicCard =>
KEY => VALUE
0 => 6
1 => 11
2 => 15
3 => 23
DeviceSoundCard =>
KEY => VALUE
0 => 11
1 => 17
DevicePci =>
KEY => VALUE
0 => 8
1 => 9
2 => 12
3 => 169
DeviceCase =>
DevicePowerSupply =>
ComputerDisk =>
KEY => VALUE
0 => 2364
1 => 2365
NetworkPort =>
KEY => VALUE
0 => 1548
glpilisturl =>
KEY => VALUE
Computer => /glpi/front/computer.php
DeviceMotherboard => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
DeviceProcessor => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
DeviceMemory => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
DeviceHardDrive => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
DeviceNetworkCard => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
DeviceDrive => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
DeviceControl => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
DeviceGraphicCard => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
DeviceSoundCard => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
DevicePci => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
DeviceCase => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
DevicePowerSupply => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
ComputerDisk => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
NetworkPort => https://ocs.xxxxxxxx.gov.co/glpi/front/ … hp?id=1206
glpicronuserrunning =>

Thank you

Forum GLPI-Project

Announcement

#1 2010-11-11 01:29:56

Please, how does ocs sync work? So far no luck :( GLPI 0.78

#2 2010-11-11 15:15:47

Re: Please, how does ocs sync work? So far no luck :( GLPI 0.78

#3 2010-11-13 17:24:56

Re: Please, how does ocs sync work? So far no luck :( GLPI 0.78

#4 2010-11-14 23:09:59

Re: Please, how does ocs sync work? So far no luck :( GLPI 0.78

#5 2010-11-16 04:14:31

Re: Please, how does ocs sync work? So far no luck :( GLPI 0.78

Board footer