OCS Inventory NG Forums

OCS Inventory NG, an OpenSource computer inventory and package deployement system for Windows and Unix

You are not logged in.

#1 2011-07-21 14:47:42

t.schulz
Member
Registered: 2011-07-19
Posts: 27

Installation of MSofficeKey Plugin

Hello,


i have problems setting up the Plugin correctly. The Documentation on this (http://wiki.ocsinventory-ng.org/index.p … SofficeKey)
is a litte bit confusing.


Communication Server


1. First it is written to create the directory "ms_<your_module_name>"  in  /plugins/computer_detail directory. After that, the .php file has to
be copied in /plugins/cd_officepack/? What is the right Directory for /cd_officepack now? /plugins/computer_detail or /plugins?


2. The .php file should be renamed into "cd_officepack.php". A few lines later i shall fix good permissions on cd_officekey.php! What is the
right name for the .php file; cd_officepack.php or cd_officekey.php?


Both variants didn´t working for me.


The Windows Agent is sending the correct Key and Version to the Server. All steps of the howto are done. Are there any ways to find the
Problem within a logfile or so?

Offline

#2 2011-07-21 15:07:42

frankb
OCS Team
From: France (Angers)
Registered: 2009-01-12
Posts: 3,644
Website

Re: Installation of MSofficeKey Plugin

I have made modifications on the wiki page. There was a mistake: ms is false, replaced by cd

Offline

#3 2011-07-21 15:15:00

t.schulz
Member
Registered: 2011-07-19
Posts: 27

Re: Installation of MSofficeKey Plugin

Thanks for the fast response.


Is this here correct?;


Thu Jul 21 16:28:12 2011;12751;113;HPLAPTOP-2011-07-19-21-11-48;127.0.0.1;OCS-NG_WINDOWS_AGENT_v2.0.0.20;inventory;u:officepack


After this line follows;


Thu Jul 21 16:28:12 2011;12751;515;HPLAPTOP-2011-07-19-21-11-48;127.0.0.1;OCS-NG_WINDOWS_AGENT_v2.0.0.20;end;error


(ocsinventory-server.log)

Last edited by t.schulz (2011-07-21 15:15:31)

Offline

#4 2011-07-21 15:32:42

frankb
OCS Team
From: France (Angers)
Registered: 2009-01-12
Posts: 3,644
Website

Re: Installation of MSofficeKey Plugin

Have you an error in apache error log file too?

Offline

#5 2011-07-21 15:41:06

t.schulz
Member
Registered: 2011-07-19
Posts: 27

Re: Installation of MSofficeKey Plugin

No, there is nothing in error.log of Apache.


Has to be there a cd_officepack.php AND a cd_officekey.php? If it is so, where these two files have to be?


/plugins/computer_detail/cd_officepack/cd_officepack.php


AND


/plugins/computer_detail/cd_officekey.php?


Or the other way round?


Sorry, i don´t understand this part of the howto...

Last edited by t.schulz (2011-07-21 15:42:15)

Offline

#6 2011-07-21 16:10:45

frankb
OCS Team
From: France (Angers)
Registered: 2009-01-12
Posts: 3,644
Website

Re: Installation of MSofficeKey Plugin

I have rename cd_officekey.php to cd_officepack.php on the wiki. So all must be pack not key or key not pack, but not a mix of both.

Offline

#7 2011-07-21 16:21:01

t.schulz
Member
Registered: 2011-07-19
Posts: 27

Re: Installation of MSofficeKey Plugin

Thank you. But i still get the error message in activity.log. Where can be the fault? In Map.pm, cd_officepack.php or in the script at the agent?

Offline

#8 2011-07-21 16:31:55

frankb
OCS Team
From: France (Angers)
Registered: 2009-01-12
Posts: 3,644
Website

Re: Installation of MSofficeKey Plugin

If you have rightly copied all from the wiki, it must running correctly. So i suggest you to verify all copied files with the wiki.

Offline

#9 2011-07-21 17:05:55

t.schulz
Member
Registered: 2011-07-19
Posts: 27

Re: Installation of MSofficeKey Plugin

I have checked all files, even if Map.pm is a valid perl file after the modifications. Connection only works without the vbs script on the agent.
Are there any options to get a more detailed error message from the ocs server?

Offline

#10 2011-07-26 11:15:09

t.schulz
Member
Registered: 2011-07-19
Posts: 27

Re: Installation of MSofficeKey Plugin

*push*

Any suggestions how to find the reason for the error?

Offline

#11 2011-07-26 11:28:57

t.schulz
Member
Registered: 2011-07-19
Posts: 27

Re: Installation of MSofficeKey Plugin

Here the error Message together with all other Messages from the concerned client (activity.log on OCS-Server);


Tue Jul 26 12:42:43 2011;1982;310;HPLAPTOP-2011-07-19-21-11-48;127.0.0.1;OCS-NG_WINDOWS_AGENT_v2.0.0.20;handler;trusted_computer
Tue Jul 26 12:42:43 2011;1982;319;HPLAPTOP-2011-07-19-21-11-48;127.0.0.1;OCS-NG_WINDOWS_AGENT_v2.0.0.20;session;found
Tue Jul 26 12:42:43 2011;1982;104;HPLAPTOP-2011-07-19-21-11-48;127.0.0.1;OCS-NG_WINDOWS_AGENT_v2.0.0.20;inventory;incoming
Tue Jul 26 12:42:43 2011;1982;113;HPLAPTOP-2011-07-19-21-11-48;127.0.0.1;OCS-NG_WINDOWS_AGENT_v2.0.0.20;inventory;u:softwares
Tue Jul 26 12:42:43 2011;1982;113;HPLAPTOP-2011-07-19-21-11-48;127.0.0.1;OCS-NG_WINDOWS_AGENT_v2.0.0.20;inventory;u:drives
Tue Jul 26 12:42:43 2011;1982;113;HPLAPTOP-2011-07-19-21-11-48;127.0.0.1;OCS-NG_WINDOWS_AGENT_v2.0.0.20;inventory;u:officepack
Tue Jul 26 12:42:43 2011;1982;515;HPLAPTOP-2011-07-19-21-11-48;127.0.0.1;OCS-NG_WINDOWS_AGENT_v2.0.0.20;end;error

Last edited by t.schulz (2011-07-26 11:29:45)

Offline

#12 2011-07-26 11:35:28

frankb
OCS Team
From: France (Angers)
Registered: 2009-01-12
Posts: 3,644
Website

Re: Installation of MSofficeKey Plugin

and error_log of apache?

Offline

#13 2011-07-26 13:37:32

t.schulz
Member
Registered: 2011-07-19
Posts: 27

Re: Installation of MSofficeKey Plugin

Sorry, no messages in error.log about this. I started a new inventory notification from the client and checked the error.log with tail -f at the same time.


In access.log i have a couple of entries like this;


"POST /ocsinventory HTTP/1.0" 500 829 "-" "OCS-NG_WINDOWS_AGENT_v2.0.0.20"

Last edited by t.schulz (2011-07-26 13:41:06)

Offline

#14 2011-07-26 13:44:28

frankb
OCS Team
From: France (Angers)
Registered: 2009-01-12
Posts: 3,644
Website

Re: Installation of MSofficeKey Plugin

"POST /ocsinventory HTTP/1.0" 500 829 "-" "OCS-NG_WINDOWS_AGENT_v2.0.0.20". The bold value signals an error and i suspect an mysql error.
Can you edit z-ocsinventory-server.conf and set OCS_OPT_DBI_PRINT_ERROR to 1. By default, it's 0.
Save and restart apache.
Next relaunch an inventory.
Next post the content of error.log file.

Offline

#15 2011-07-26 15:05:55

t.schulz
Member
Registered: 2011-07-19
Posts: 27

Re: Installation of MSofficeKey Plugin

It seems you are right;


DBD::mysql::st execute failed: Duplicate entry '0-23' for key 'PRIMARY' at /usr/local/share/perl/5.10.0/Apache/Ocsinventory/Server/Inventory/Update.pm line 147.

Offline

#16 2011-07-26 15:11:54

frankb
OCS Team
From: France (Angers)
Registered: 2009-01-12
Posts: 3,644
Website

Re: Installation of MSofficeKey Plugin

Verify that id field is set to auto_increment.

Offline

#17 2011-07-26 15:20:04

t.schulz
Member
Registered: 2011-07-19
Posts: 27

Re: Installation of MSofficeKey Plugin

No, it wasn´t! Now it is, and it is working! But i have to say that i don´t created the tables and fields in mysql manually. This was done by the script setup.sh out of PluginOcsOfficekey.tar.gz.   

Thanks a lot! Now only the Webservice remains... ;-)

I´ve checked the script creation_table_officepack.sql, there is missing AUTO_INCREMENT for ID!

Last edited by t.schulz (2011-07-26 15:42:43)

Offline

Board footer

Powered by FluxBB

Serveur dédié, hébergement web, infogérance et nom  de domaine - NFrance Conseil