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

Pages: 1

Topic closed

#1 2008-12-30 09:52:42

pravinpanday
Member
Registered: 2008-12-30
Posts: 47

GLPI fields do not match with OCS

Hi,

I am running OCS 1.01 server with XAMPP ( that has perl,php,mysql,apache) and GLPI 0.68. With this combination I can import computers from OCS and all the inventory fields match with imported computers.

But when I use any glpi version like 0.70 or above it imports the computers successfully but the fields do not macth at all.

Ex: Status, Manufacturer, Serial number, Type, Model all the fields are blank. The Name displays the computername perfectly. Please help. I would like to use a later version of glpi rather than 0.68.

Offline

#2 2008-12-30 10:51:38

remi
GLPI-DEV
From: Champagne
Registered: 2007-04-28
Posts: 7,127
Website

Re: GLPI fields do not match with OCS

Check you OCSNG mode configuration.

++

Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

Offline

#3 2008-12-30 12:51:03

wawa
GLPI-DEV
From: Montpellier / France
Registered: 2006-07-03
Posts: 6,019
Website

Re: GLPI fields do not match with OCS

and in debug mode ? and in the logs ?
what's your ocsng configuration ?

Offline

#4 2008-12-30 14:33:54

pravinpanday
Member
Registered: 2008-12-30
Posts: 47

Re: GLPI fields do not match with OCS

It is same in Debug mode as well. Also in the logs I do not see any errors however the log is quite big so I do not know what exactly to see there. In the error column there is nothing.

I tried importing 4 computers and the import was successful but the when I go to --> Inventory --> Computers It only shows the name and no other information. When I click on the name of the computer all the I see is the name of computer and other fields are blank.

I repeat. This works perfectly with glpi 0.68.

My OCS config is :

OCS server : 1.01 Running on Windows XP professional
I have installed the OCS server 1.01 package which comes with XAMPP.

The machines in OCS show all the information.

Offline

#5 2008-12-30 14:42:44

pravinpanday
Member
Registered: 2008-12-30
Posts: 47

Re: GLPI fields do not match with OCS

I will check and revert

Offline

#6 2008-12-30 14:44:29

pravinpanday
Member
Registered: 2008-12-30
Posts: 47

Re: GLPI fields do not match with OCS

Sorry for this "I will check and revert" in my above reply it was meant for another post.

Offline

#7 2008-12-31 08:43:11

pravinpanday
Member
Registered: 2008-12-30
Posts: 47

Re: GLPI fields do not match with OCS

No success Please help. I have found no errors in Debug mode.

Do I need to do something in mysql.

PLease Helpppppppp.

Offline

#8 2008-12-31 14:14:55

pravinpanday
Member
Registered: 2008-12-30
Posts: 47

Re: GLPI fields do not match with OCS

Any Hints Please help

Offline

#9 2008-12-31 14:33:56

pravinpanday
Member
Registered: 2008-12-30
Posts: 47

Re: GLPI fields do not match with OCS

Here is the SQL log

SELECT *
FROM glpi_computers
WHERE (ID = 15)    0.000    
2    SELECT name
FROM glpi_computers
WHERE ID='15'    0.000    
3    SELECT glpi_computers.ID
FROM glpi_computers
WHERE ( glpi_computers.name > 'TXTAOIT-PRAVIN' OR (glpi_computers.name = 'TXTAOIT-PRAVIN' AND glpi_computers.ID > '15') ) AND glpi_computers.deleted='0' AND glpi_computers.is_template='0'
ORDER BY glpi_computers.name ASC, glpi_computers.ID ASC    0.000    
4    SELECT name
FROM glpi_computers
WHERE ID=15    0.000    
5    SELECT glpi_computers.ID
FROM glpi_computers
WHERE (glpi_computers.name < 'TXTAOIT-PRAVIN' OR (glpi_computers.name = 'TXTAOIT-PRAVIN' AND glpi_computers.ID < '15') ) AND glpi_computers.deleted='0'AND glpi_computers.is_template='0'
ORDER BY glpi_computers.name DESC, glpi_computers.ID DESC    0.000    
6    SELECT *
FROM glpi_type_computers
WHERE 1 AND ID NOT IN (0)
ORDER BY name     0.001    
7    SELECT *
FROM glpi_dropdown_model
WHERE 1 AND ID NOT IN (0)
ORDER BY name     0.001    
8    SELECT DISTINCT glpi_users.*
FROM glpi_users
LEFT JOIN glpi_users_profiles ON (glpi_users.ID = glpi_users_profiles.FK_users)
WHERE glpi_users.ID > '1' AND ( glpi_users_profiles.FK_entities = '0' ) AND glpi_users.deleted='0' AND glpi_users.active='1'
ORDER BY glpi_users.realname,glpi_users.firstname, glpi_users.name     0.006    
9    SELECT *
FROM glpi_dropdown_locations
WHERE 1 AND ( glpi_dropdown_locations.FK_entities = '0' )
ORDER BY FK_entities, completename     0.002    
10    SELECT *
FROM glpi_dropdown_locations
WHERE (ID = '0')    0.000    
11    SELECT *
FROM glpi_groups
WHERE 1 AND ID NOT IN (0) AND ( glpi_groups.FK_entities = '0' )
ORDER BY name     0.001    
12    SELECT *
FROM glpi_dropdown_manufacturer
WHERE 1 AND ID NOT IN (0)
ORDER BY name     0.001    
13    SELECT DISTINCT glpi_users.*
FROM glpi_users
LEFT JOIN glpi_users_profiles ON (glpi_users.ID = glpi_users_profiles.FK_users)
LEFT JOIN glpi_profiles ON (glpi_profiles.ID= glpi_users_profiles.FK_profiles)
WHERE glpi_profiles.interface='central' AND ( glpi_users_profiles.FK_entities = '0' ) AND glpi_users.deleted='0' AND glpi_users.active='1'
ORDER BY glpi_users.realname,glpi_users.firstname, glpi_users.name     0.006    
14    SELECT *
FROM glpi_dropdown_os
WHERE 1 AND ID NOT IN (0)
ORDER BY name     0.002    
15    SELECT *
FROM glpi_dropdown_network
WHERE 1 AND ID NOT IN (0)
ORDER BY name     0.001    
16    SELECT *
FROM glpi_dropdown_os_version
WHERE 1 AND ID NOT IN (0)
ORDER BY name     0.001    
17    SELECT *
FROM glpi_dropdown_domain
WHERE 1 AND ID NOT IN (0)
ORDER BY name     0.001    
18    SELECT *
FROM glpi_dropdown_os_sp
WHERE 1 AND ID NOT IN (0)
ORDER BY name     0.001    
19    SELECT *
FROM glpi_dropdown_state
WHERE 1 AND ID NOT IN (0)
ORDER BY name     0.001    
20    SELECT *
FROM glpi_ocs_link
WHERE glpi_id='15'    0.001    
21    SELECT *
FROM glpi_dropdown_auto_update
WHERE 1 AND ID NOT IN (0)
ORDER BY name     0.001    
22    SELECT ocs_server_id
FROM glpi_ocs_link
WHERE glpi_ocs_link.glpi_id='15'    0.000    
23    SELECT ocs_server_id
FROM glpi_ocs_link
WHERE glpi_ocs_link.glpi_id='15'    0.000    
24    SELECT *
FROM glpi_ocs_config
WHERE ID='1'    0.001    
25    SELECT ocs_agent_version
FROM glpi_ocs_link
WHERE (glpi_id = '15')    0.000    
26    SELECT *
FROM glpi_computers
WHERE (ID = 15)    0.001    
27    SELECT count(*) AS NB, ID, device_type, FK_device, specificity
FROM glpi_computer_device
WHERE FK_computers = '15' GROUP BY device_type, FK_device, specificity
ORDER BY device_type, ID

POST VARIABLE
KEY    =>    VALUE
searchText    =>    *
value    =>    0
table    =>    glpi_type_computers
myname    =>    type
limit    =>    50
comments    =>    1
rand    =>    140687823
entity_restrict    =>    -1
update_item    =>   
used    =>   


* This all information of logs I have received in debug mode. Please see if you can find out anything. I do not see any errors but when click on any PC that has been imported no information appears accept the computer name.

Offline

#10 2008-12-31 14:36:28

pravinpanday
Member
Registered: 2008-12-30
Posts: 47

Re: GLPI fields do not match with OCS

This is from the sql_error.log file

2008-12-31 10:02:20
*** MySQL query error :
***
SQL: SELECT DISTINCT glpi_dropdown_kbcategories.* FROM glpi_dropdown_kbcategories WHERE ID IN Array AND  (glpi_dropdown_kbcategories.parentID = \'0\') ORDER  BY name ASC
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 'Array AND  (glpi_dropdown_kbcategories.parentID = '0') ORDER  BY name ASC' at line 1
Backtrace :
C:\Program Files\OCS Inventory NG\xampp\htdocs\glpi\inc\knowbase.function.php:148        DBmysql->query()
C:\Program Files\OCS Inventory NG\xampp\htdocs\glpi\front\helpdesk.faq.php:79        showKbCategoriesFirstLevel()
C:/Program Files/OCS Inventory NG/xampp/htdocs/glpi/front/helpdesk.faq.php

The crons log file follows below:

2008-12-31 07:17:19
Launch ocsng
2008-12-31 07:17:19
Check updates from server localhost
2008-12-31 07:17:19
Update computer 287
2008-12-31 07:17:19
ocsng Successfull (0.16s)
2008-12-31 07:23:24
Launch mailgate
2008-12-31 07:23:24
mailgate Successfull (0.00s)
2008-12-31 07:23:34
Launch dbreplicate
2008-12-31 07:23:34
dbreplicate Nothing to do (0.00s)
2008-12-31 07:23:45
Launch ocsng
2008-12-31 07:23:45
Check updates from server localhost
2008-12-31 07:23:45
Update computer 8
2008-12-31 07:23:45
ocsng Successfull (0.15s)
2008-12-31 07:30:28
Launch dbreplicate
2008-12-31 07:30:28
dbreplicate Nothing to do (0.00s)
2008-12-31 07:38:43
Launch ocsng
2008-12-31 07:38:43
Check updates from server localhost
2008-12-31 07:38:43
Update computer 210
2008-12-31 07:38:43
ocsng Successfull (0.15s)
2008-12-31 08:00:35
Launch mailgate
2008-12-31 08:00:35
mailgate Successfull (0.00s)
2008-12-31 08:12:34
Launch dbreplicate
2008-12-31 08:12:34
dbreplicate Nothing to do (0.00s)
2008-12-31 08:19:17
Launch ocsng
2008-12-31 08:19:17
Check updates from server localhost
2008-12-31 08:19:17
Update computer 248
2008-12-31 08:19:17
ocsng Successfull (0.16s)
2008-12-31 09:41:12
Launch mailgate
2008-12-31 09:41:12
mailgate Successfull (0.00s)
2008-12-31 09:46:29
Launch dbreplicate
2008-12-31 09:46:29
dbreplicate Nothing to do (0.00s)
2008-12-31 09:51:01
Launch ocsng
2008-12-31 09:51:01
Check updates from server localhost
2008-12-31 09:51:01
Update computer 348
2008-12-31 09:51:01
ocsng Successfull (0.16s)
2008-12-31 09:52:22
Launch mailgate
2008-12-31 09:52:22
mailgate Successfull (0.00s)
2008-12-31 09:56:46
Launch dbreplicate
2008-12-31 09:56:46
dbreplicate Nothing to do (0.00s)
2008-12-31 09:58:37
Launch ocsng
2008-12-31 09:58:37
Check updates from server localhost
2008-12-31 09:58:38
Update computer 349
2008-12-31 09:58:38
ocsng Successfull (1.16s)
2008-12-31 10:02:31
Launch dbreplicate
2008-12-31 10:02:31
dbreplicate Nothing to do (0.00s)
2008-12-31 10:17:50
Launch mailgate
2008-12-31 10:17:50
mailgate Successfull (0.00s)
2008-12-31 10:22:28
Launch ocsng
2008-12-31 10:22:28
Check updates from server localhost
2008-12-31 10:22:28
Update computer 351
2008-12-31 10:22:28
ocsng Successfull (0.17s)
2008-12-31 10:23:10
Launch dbreplicate
2008-12-31 10:23:10
dbreplicate Nothing to do (0.00s)
2008-12-31 12:22:54
Launch ocsng
2008-12-31 12:22:54
Check updates from server localhost
2008-12-31 12:22:55
Update computer 33
2008-12-31 12:22:55
ocsng Successfull (0.24s)
2008-12-31 12:27:59
Launch plugin_mass_ocs_import
2008-12-31 12:27:59
Clean mass_ocs_import : nothing to do
2008-12-31 12:27:59
plugin_mass_ocs_import Nothing to do (0.09s)

Offline

#11 2008-12-31 14:38:15

remi
GLPI-DEV
From: Champagne
Registered: 2007-04-28
Posts: 7,127
Website

Re: GLPI fields do not match with OCS

We can't help you if you don't give us any information about your configuration.
+

Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

Offline

#12 2008-12-31 15:07:50

pravinpanday
Member
Registered: 2008-12-30
Posts: 47

Re: GLPI fields do not match with OCS

Sorry for the trouble remmi.

I got it solved. You can close this thread. I made some changes in OCSNG mode configuration. I do not what did the trick but just kept playing with the options and finally it worked. Now I can see all the information in inventory fields.

Again I apologize. I referred the wiki forums of glpi for OCSNG mode configuration. For other newbies to refer this is the link

http://glpi-project.org/wiki/doku.php?id=en:faqocsng

thanks again for the assistance.

Offline

#13 2008-12-31 15:45:28

remi
GLPI-DEV
From: Champagne
Registered: 2007-04-28
Posts: 7,127
Website

Re: GLPI fields do not match with OCS

ok. I close.

Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

Offline

Pages: 1

Topic closed

Board footer

Powered by FluxBB