Is there a timetable for the next release?
is nearly impossible to use ocs as an inventory system if the half of our linux client can´t send a successful inventory.
Talking about this: OCSInventory-NG/OCSInventory-ocsreports@8debb53

Alternatively can you give me a hint where i can fix this in my installation?

I tried to install , but I got the error:

+----------------------------------------------------------+
| Installing files for Administration server... |
+----------------------------------------------------------+

Creating PHP directory /usr/share/ocsinventory-reports/ocsreports.
Copying PHP files to /usr/share/ocsinventory-reports/ocsreports.
*** ERROR: Unable to copy files in /usr/share/ocsinventory-reports/ocsreports, please look at error in /home/alclogti/download/OCSInventory-Server/ocs_server_setup.log and fix !

ocs_server_setup.log

cp: cannot stat 'ocsreports/*': No such file or directory

setup.sh:1445

I searched the ocsreports within the installation directory and I did not find.

Thanks!

[Mon Jun 15 16:11:48 2015] -e: DBD::mysql::db do failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at /usr/local/share/perl/5.20.2/Apache/Ocsinventory/Server/Inventory/Cache.pm line 34.
[Mon Jun 15 16:11:48 2015] -e: DBD::mysql::db do failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at /usr/local/share/perl/5.20.2/Apache/Ocsinventory/Server/Inventory/Cache.pm line 34.
[Mon Jun 15 16:11:48 2015] -e: DBD::mysql::db do failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at /usr/local/share/perl/5.20.2/Apache/Ocsinventory/Server/Inventory/Cache.pm line 34.
[Mon Jun 15 16:11:48 2015] -e: DBD::mysql::db do failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at /usr/local/share/perl/5.20.2/Apache/Ocsinventory/Server/Inventory/Cache.pm line 34.
[Mon Jun 15 16:11:48 2015] -e: DBD::mysql::db do failed: Illegal mix of collations (latin1_

hi,
when i connect http://127.0.0.1/ocsinterface
return error 2015-06-16 10:36:58 ERROR 500: Internal Server Error.
apache2 config
<location /ocsinterface>
SetHandler perl-script
PerlHandler "Apache::Ocsinventory::SOAP"
Require all granted
# By default, you can query web service from everywhere with a valid user
# Order deny,allow
# Allow from all
# AuthType Basic
#AuthName "OCS Inventory SOAP Area"
# Use htpasswd to create/update soap-user (or another granted user)
#AuthUserFile "APACHE_AUTH_USER_FILE"
#require "SOAP_USER"

so log error Illegal field name 'APR::Table=HASH(0x7f8b5cb3bea0)' at /usr/local/share/perl/5.20.1/SOAP/Transport/HTTP2.pm line 103.\n

Any roadmap for using an ORM (ex: Doctrine) for the persistance layer ? it's important to switch between different databases.

After using login demo/demo on your website I get the folllowing error.

Catchable fatal error: Argument 1 passed to XMLUrlsSerializer::serialize() must be an instance of Urls, boolean given, called in /home/www/www_demo/html/require/config/include.php on line 57 and defined in /home/www/www_demo/html/require/config/XMLUrlsSerializer.php on line 29

Maybe I'm in the wrong place, if so I can understand to go away either in English, either in French, so feel free to replay in the language you like best.

What in the subject is what I see in the apache log error at startup on Ubuntu 14 server lts (about 1 GB RAM, 2 CPU, about 100 GB disk) as VM under VMWare 5.5

After goint to the end (of the setup some time) I notices at setup of OCSInventory that I've got:

+----------------------------------------------------------+
| Checking for optional Perl Modules... |
+----------------------------------------------------------+

Checking for Apache2::SOAP PERL module...
*** Warning: PERL module Apache2::SOAP is not installed !
This module is only required by OCS Inventory NG SOAP Web Service.
Do you wish to continue ([y]/n] ?n

Installation aborted !

But if I look for such module to install it, I get:

root@mui:/OCSNG_UNIX_SERVER-2.2.1# cpan install Apache2::SOAP
Loading internal null logger. Install Log::Log4perl for logging messages
Reading '/root/.cpan/Metadata'
Database was generated on Fri, 29 Jul 2016 02:29:03 GMT
Apache2::SOAP is up to date (0.73).
root@mui:/OCSNG_UNIX_SERVER-2.2.1#

So I can't understand why the setup tell me that Apache2::SOAP is not
installed when if I try to install it I give the reply that it is
already installed.

Some hints, please?

Regards, Andrea

General informations

Operating system : FreeBSD 10.3-RELEASE-p11

Server informations

Perl version : v5.20.3
Mysql version : 5.7.15

OCS Inventory informations

Ocs server version : 2.3.0.0 or 2.3.1 (fresh install).

Problem's description

I have a fresh install of OCS 2.3.0.0, and I've added an usbdevices table to DB.
But AUTO_DUPLICATE_LVL (hostname+uuid) function doesn't work.

Ex. I've one host in OCS with hostname KBP-WIN8-VM and uuid AA434E54-2E8F-44A4-8C3E-8F9B59AF2B60 on Windows 8.1 with Agent 2.3.0.0. I've gotten new host with same hostname and uuid in OCS after full reinstall of an agent on the host.
I've gotten one error ERROR *** AGENT => Failed to send Inventory <HTTP Status Code #403> only after the first run agent on the host. Next runs are without errors.

UPDATE
AUTO_DUPLICATE_LVL function doesn't work (without a 403 error) if enabled TRACE_DELETED option.

When "building" the package on Debian, we get these warnings during the "clean":

make[1]: Entering directory '(...)/Apache'
/usr/bin/perl "-MExtUtils::Manifest=fullcheck" -e fullcheck
Not in MANIFEST: Ocsinventory/Interface/Snmp.pm
Not in MANIFEST: Ocsinventory/Plugins.pm
Not in MANIFEST: Ocsinventory/Plugins/Apache.pm
Not in MANIFEST: Ocsinventory/Plugins/Modules.pm

I suppose you just need to update the list of files?

Hi,
I had upgrade my server from Debian 7 to Debian 8. I am using OCS NG 2.1.2
And I found a couple of issues.

1. /etc/apache2/conf.d not longer valid
   mv ocsinventory-reports.conf and z-ocsinventory-server.conf /etc/apache2/conf-enabled
   a2enconf ocsinventory-reports
   a2enconf z-ocsinventory-server

2. Perl Path
   mv /usr/local/share/perl/5.14.2 /usr/local/share/perl/5.20.2

3. require "SOAP_USER" error
   This is just a note for anyone seen this bug report.
   Change Require "SOAP_USER" > Require user "SOAP_USER" on z-ocsinventory-server.conf

la table 'devices' ne possède ni clé primaire ni index unique.
Cela pose problème dans une architecture avec réplication (parc de machines important, table devices très grosse)

Une requête du genre
UPDATE devices SET TVALUE='NOTIFIED', COMMENTS=? WHERE NAME='DOWNLOAD' AND HARDWARE_ID=? AND TVALUE IS NULL
dans le module OCSInventory-Server/Apache/Ocsinventory/Server/Capacities/Download.pm
peut prendre énormément de temps sur la base esclave ( full scan de la table devices sur l'esclave pour retrouver la ligne)

référence et explication du bug mysql 5.1
https://bugs.mysql.com/bug.php?id=53375

le problème semble exister également sur Mysql 5.6
https://bugs.mysql.com/bug.php?id=76252

There is a bad entry in the help menu : Old Forums.
The old forums is not anymore online and this entry must be removed.

I find this references :
OCSInventory-ocsreports/config/main_menu.xml:
OCSInventory-ocsreports/config/main_menu.xml: ms_forums
OCSInventory-ocsreports/config/profiles/admin.xml: ms_forums
OCSInventory-ocsreports/config/profiles/dde_teledeploy.xml: ms_forums
OCSInventory-ocsreports/config/profiles/ladmin.xml: ms_forums
OCSInventory-ocsreports/config/profiles/sadmin.xml: ms_forums
OCSInventory-ocsreports/config/urls.xml:

and of course, the file OCSInventory-ocsreports/plugins/main_sections/ms_help/ms_forums.php

It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.

General informations

Operating system : Centos 7 minimal

Server informations

Perl version : (v5.16.3)
Mysql / Mariadb / Percona version : 4.1

OCS Inventory informations

Ocs server version : 2.31

Problem's description

Describe your problem here

I can't run httpd service.

systemctl restart httpd

Job for httpd.service failed because the control process exited with error code. See "systemctl status httpd.service" and "journalctl -xe" for details.

#systemctl status httpd

jun 08 13:18:29 localhost.localdomain systemd[1]: Starting The Apache HTTP Server...
jun 08 13:18:29 localhost.localdomain systemd[1]: httpd.service: main process exited, code=exited, status=1/FAILURE
jun 08 13:18:29 localhost.localdomain kill[7128]: kill: cannot find process ""
jun 08 13:18:29 localhost.localdomain systemd[1]: httpd.service: control process exited, code=exited status=1
jun 08 13:18:29 localhost.localdomain systemd[1]: Failed to start The Apache HTTP Server.
jun 08 13:18:29 localhost.localdomain systemd[1]: Unit httpd.service entered failed state.
jun 08 13:18:29 localhost.localdomain systemd[1]: httpd.service failed.

#nano /var/log/httpd/error_log

[Thu Jun 08 12:20:59.897839 2017] [perl:error] [pid 6600] Compress::Raw::Zlib version 2.074 required--this is only version 2.061 at /usr/local/lib64/perl5/Compress/$
[Thu Jun 08 12:20:59.898112 2017] [perl:error] [pid 6600] Can't load Perl module Compress::Zlib for server localhost:0, exiting...

Someone can help me!

General informations

Operating system Server : Debian GNU/Linux 7
Operating system Client : Windows 10 build 1703 x64
Apache Server version : 2.2.22

Server informations

Perl version : 5.14.2
Mysql version : 5.5.55

OCS Inventory informations

OCS server version : 2.3.1
OCS Agent version : 2.3

Problem's description

Empty plugins data in OCS Server

DSKEPIZARRO XML
VIRTUAL MACHINES

Show entries
Search :
Name VM Statut VM Operating system VM Type VM UUID Processor(s) VM Memory VM Computer Operating system
No data available in table
Showing 0 to 0 of 0 entrie
PreviousNext
NETWORK SHARE

Show entries
Search :
Drive Path
No data available in table
Showing 0 to 0 of 0 entrie
PreviousNext
TEAMVIEWER

Show entries
Search :
ID Version
No data available in table
Showing 0 to 0 of 0 entrie
PreviousNext
WINDOWS UPDATE STATE

Show entries
Search :
Scheduled Install Date Last Succes Time Detect Succes Time Download Succes Time
No data available in table

If I push to local file from agent I get plugin data localy. For example:

...

<SECURITYCENTER>
	<SCV>2</SCV>
	<CATEGORY>AntiVirus</CATEGORY>
	<COMPANY>Microsoft Corporation</COMPANY>
	<PRODUCT>Windows Defender</PRODUCT>
	<VERSION>4.11.15063.0</VERSION>
	<ENABLED>0</ENABLED>
	<UPTODATE>0</UPTODATE>
</SECURITYCENTER>
<SECURITYCENTER>
	<SCV>2</SCV>
	<CATEGORY>AntiVirus</CATEGORY>
	<COMPANY>ESET</COMPANY>
	<PRODUCT>ESET Smart Security 9.0.408.1</PRODUCT>
	<VERSION>9.0.407.0</VERSION>
	<ENABLED>1</ENABLED>
	<UPTODATE>1</UPTODATE>
</SECURITYCENTER>

...

Plugins into C:\Program Files (x86)\OCS Inventory Agent\Plugins with permissions

DO_NOT_REMOVE.txt Todos:(I)(RX,W)
ENTIDAD DE PAQUETES DE APLICACIONES\TODOS LOS PAQUETES DE APLICACIONES:(I)(F)
ENTIDAD DE PAQUETES DE APLICACIONES\TODOS LOS PAQUETES DE APLICACIÓN RESTRINGIDOS:(I)(F)
NT AUTHORITY\SYSTEM:(I)(F)
BUILTIN\Administradores:(I)(F)
BUILTIN\Usuarios:(I)(RX)

msofficekey.vbs Todos:(I)(RX,W)
ENTIDAD DE PAQUETES DE APLICACIONES\TODOS LOS PAQUETES DE APLICACIONES:(I)(F)
ENTIDAD DE PAQUETES DE APLICACIONES\TODOS LOS PAQUETES DE APLICACIÓN RESTRINGIDOS:(I)(F)
NT AUTHORITY\SYSTEM:(I)(F)
BUILTIN\Administradores:(I)(F)
BUILTIN\Usuarios:(I)(RX)

networkshare.vbs Todos:(I)(RX,W)
ENTIDAD DE PAQUETES DE APLICACIONES\TODOS LOS PAQUETES DE APLICACIONES:(I)(F)
ENTIDAD DE PAQUETES DE APLICACIONES\TODOS LOS PAQUETES DE APLICACIÓN RESTRINGIDOS:(I)(F)
NT AUTHORITY\SYSTEM:(I)(F)
BUILTIN\Administradores:(I)(F)
BUILTIN\Usuarios:(I)(RX)

security.vbs Todos:(I)(RX,W)
ENTIDAD DE PAQUETES DE APLICACIONES\TODOS LOS PAQUETES DE APLICACIONES:(I)(F)
ENTIDAD DE PAQUETES DE APLICACIONES\TODOS LOS PAQUETES DE APLICACIÓN RESTRINGIDOS:(I)(F)
NT AUTHORITY\SYSTEM:(I)(F)
BUILTIN\Administradores:(I)(F)
BUILTIN\Usuarios:(I)(RX)

teamviewer.vbs Todos:(I)(RX,W)
ENTIDAD DE PAQUETES DE APLICACIONES\TODOS LOS PAQUETES DE APLICACIONES:(I)(F)
ENTIDAD DE PAQUETES DE APLICACIONES\TODOS LOS PAQUETES DE APLICACIÓN RESTRINGIDOS:(I)(F)
NT AUTHORITY\SYSTEM:(I)(F)
BUILTIN\Administradores:(I)(F)
BUILTIN\Usuarios:(I)(RX)

winupdate.vbs Todos:(I)(RX,W)
ENTIDAD DE PAQUETES DE APLICACIONES\TODOS LOS PAQUETES DE APLICACIONES:(I)(F)
ENTIDAD DE PAQUETES DE APLICACIONES\TODOS LOS PAQUETES DE APLICACIÓN RESTRINGIDOS:(I)(F)
NT AUTHORITY\SYSTEM:(I)(F)
BUILTIN\Administradores:(I)(F)
BUILTIN\Usuarios:(I)(RX)

The dafault data is pushed correctly from agent to server. For example:

...

<CONTROLLERS>
	<ID>80295</ID>
	<MANUFACTURER>Microsoft</MANUFACTURER>
	<NAME>Microsoft Storage Spaces Controller</NAME>
	<CAPTION>Microsoft Storage Spaces Controller</CAPTION>
	<DESCRIPTION>Microsoft Storage Spaces Controller</DESCRIPTION>
	<VERSION />
	<TYPE>SCSI Controller</TYPE>
</CONTROLLERS>

...

Logs from agent

==============================================================================
Starting OCS Inventory NG Agent on Thursday, June 01, 2017 20:02:26.
AGENT => Running OCS Inventory NG Agent Version 2.3.0.0
AGENT => Using OCS Inventory NG FrameWork Version 2.3.0.0
AGENT => Loading plug-in(s)
	DLL PLUGIN => Searching for Plug-in DLL(s) in folder <C:\Program Files (x86)\OCS Inventory Agent\plugins>
	DLL PLUGIN => 0 DLL Plug-in(s) successfully loaded on 0 DLL(s) found
AGENT => Using network connection with Communication Server
	COM PROVIDER => Loading Communication Provider <C:\Program Files (x86)\OCS Inventory Agent\ComHTTP.dll>
AGENT => Using Communication Provider <OCS Inventory NG cURL Communication Provider> Version <2.3.0.0>
AGENT => Sending Prolog
	DID_CHECK => Read DeviceID <DSKEPIZARRO-2017-06-01-14-35-44> and MACs <******> in file <ocsinventory.dat>
	COM SERVER => Initializing cURL library for sendRequest
	COM SERVER => Using cURL without server authentication
	COM SERVER => Disabling cURL proxy support
	COM SERVER => Disabling cURL SSL server validation support
	COM SERVER => Sending HTTP Post request to URL <http://192.168.10.25/ocsinventory>
	COM SERVER => HTTP Post response received <HTTP Status Code #200>
	COM SERVER => Cleaning cURL library
================= TRACE START ===============
<?xml version='1.0' encoding='UTF-8'?>
<REPLY>
  <OPTION>
    <NAME>DOWNLOAD</NAME>
    <PARAM FRAG_LATENCY="10" PERIOD_LATENCY="1" ON="0" TYPE="CONF" CYCLE_LATENCY="60" TIMEOUT="30" PERIOD_LENGTH="10" EXECUTION_TIMEOUT="120" />
  </OPTION>
  <RESPONSE>SEND</RESPONSE>
  <INVENTORY_ON_STARTUP>1</INVENTORY_ON_STARTUP>
  <PROLOG_FREQ>24</PROLOG_FREQ>
</REPLY>

================= TRACE STOP ===============
AGENT => Prolog successfully sent
SUPPORT => No support detected, Registration key : N/A
	AGENT => Prolog Frequency set to 24 hour(s)
	AGENT => Inventory on startup option set to 1 
AGENT => Inventory required
AGENT => Launching hardware and software checks
	INVENTORY => Loading Download history
	INVENTORY => Logged on user ID is <******>
	INVENTORY => Operating System is <Microsoft Windows 10 Enterprise 10.0.15063 >, description <>
	INVENTORY => Operating System uses 64 bits memory address width
	INVENTORY => Computer domain or workgroup is <WORKGROUP>
	INVENTORY => User domain is <>
	INVENTORY => System Manufacturer <System manufacturer>, System Model <System Product Name>, System S/N <System Serial Number>, Bios Manufacturer <American Megatrends Inc.>, Bios Date <07/02/2013>, Bios Version <0504>, Motherboard Manufacturer <ASUSTeK COMPUTER INC.>, Motherboard Model <H61M-K>, Motherboard S/N <******>
	INVENTORY => 1 processor(s) Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz [4 core(s) x86_64] at 3401 MHz
	INVENTORY => OS Memory 16331 MB, OS Swap size 32715 MB
	INVENTORY => 2 memory slot(s) found
	INVENTORY => 2 input device(s) found
	INVENTORY => 17 system port(s) found
	INVENTORY => 3 system slot(s) found
	INVENTORY => 5 system controller(s) found
	INVENTORY => 3 storage peripheral(s) found
	INVENTORY => 7 sound device(s) found
	INVENTORY => 1 modem(s) found
	INVENTORY => 5 network adapter(s) found
	INVENTORY => 2 system printer(s) found
	INVENTORY => 1 video adapter(s) found
	INVENTORY => 1 system monitor(s) found
	INVENTORY => Default IPv4 address is <******>
	INVENTORY => Registered company <>, registered owner <******>, Product ID <******-******...>
	INVENTORY => Product key <******-******...>
	INVENTORY => 428 software found
	INVENTORY => Computer/VM UUID is <******-*****-******-******-******>
	INVENTORY => Computer seems to be Microsoft virtual host
	INVENTORY => System Memory set to 16384 (instead of 16331)
	INVENTORY => Reading last inventory state
	EXECUTABLE PLUGIN => Searching for VBS script(s) in folder <C:\Program Files (x86)\OCS Inventory Agent\plugins>
	EXECUTABLE PLUGIN => Found executable plugin <msofficekey.vbs>
================= TRACE START ===============

================= TRACE STOP ===============
	EXECUTABLE PLUGIN => Plugin <msofficekey.vbs> executed successfully
	EXECUTABLE PLUGIN => Found executable plugin <networkshare.vbs>
================= TRACE START ===============

================= TRACE STOP ===============
	WARNING *** EXECUTABLE PLUGIN => Plugin <C:\Program Files (x86)\OCS Inventory Agent\plugins\networkshare.vbs> does not produce any output
	EXECUTABLE PLUGIN => Found executable plugin <security.vbs>
================= TRACE START ===============

================= TRACE STOP ===============
	EXECUTABLE PLUGIN => Plugin <security.vbs> executed successfully
	EXECUTABLE PLUGIN => Found executable plugin <teamviewer.vbs>
================= TRACE START ===============

================= TRACE STOP ===============
	EXECUTABLE PLUGIN => Plugin <teamviewer.vbs> executed successfully
	EXECUTABLE PLUGIN => Found executable plugin <winupdate.vbs>
================= TRACE START ===============

================= TRACE STOP ===============
	EXECUTABLE PLUGIN => Plugin <winupdate.vbs> executed successfully
	EXECUTABLE PLUGIN => Searching for executable(s) in folder <C:\Program Files (x86)\OCS Inventory Agent\plugins>
AGENT => Sending Inventory
	INVENTORY => Checking last inventory state
	INVENTORY => Logical drives inventory state changed
INVENTORY => Inventory changed since last run
	INVENTORY => Generating XML document with Device properties
	INVENTORY => XML Update BIOS
	INVENTORY => XML Update 1 CPU(s)
	INVENTORY => XML Update 2 Memory Slot(s)
	INVENTORY => XML Update 2 Input Device(s)
	INVENTORY => XML Update 17 System Port(s)
	INVENTORY => XML Update 5 System Controller(s)
	INVENTORY => XML Update 3 System Slot(s)
	INVENTORY => XML Update 7 Sound Device(s)
	INVENTORY => XML Update 3 Storage Peripheral(s)
	INVENTORY => XML Update 3 Logical Drive(s)
	INVENTORY => XML Update 1 Modem(s)
	INVENTORY => XML Update 5 Network Adapter(s)
	INVENTORY => XML Update 1 Video Adapter(s)
	INVENTORY => XML Update 1 Monitor(s)
	INVENTORY => XML Update 2 Printer(s)
	INVENTORY => XML Update 429 Software
	INVENTORY => XML Update 0 Registry Value(s)
	INVENTORY => XML Update Administrative Information(s)
	INVENTORY => XML Update common Device properties
	COM SERVER => Initializing cURL library for sendRequest
	COM SERVER => Using cURL without server authentication
	COM SERVER => Disabling cURL proxy support
	COM SERVER => Disabling cURL SSL server validation support
	COM SERVER => Sending HTTP Post request to URL <http://192.168.10.25/ocsinventory>
	COM SERVER => HTTP Post response received <HTTP Status Code #200>
	COM SERVER => Cleaning cURL library
================= TRACE START ===============
<?xml version='1.0' encoding='UTF-8'?>
<REPLY>
  <RESPONSE>NO_ACCOUNT_UPDATE</RESPONSE>
</REPLY>

================= TRACE STOP ===============
AGENT => Inventory successfully sent
	INVENTORY => Writing new inventory state
AGENT =>  Communication Server ask for Package Download
	DOWNLOAD => Package history file cleaning not required
	DOWNLOAD => Download disabled by server
AGENT => Unloading communication provider
AGENT => Unloading plug-in(s)
AGENT => Execution duration: 00:00:11.

We are accessing the web service as described here:
http://wiki.ocsinventory-ng.org/index.php?title=Developers:Web_services

The service works OK and returns data, but it appears to only return machines that have NOT been seen within the last 3 days. In other words, if a machine has contacted the server recently, then it does not come back in the query get_computers_v1.

Is there any option to get the serial numbers of the printers connected to a PC (via USB) within the software?

This option is very useful!
Transfer printers in GLPI turns into a complete ass.

It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.

General informations

Operating system : Debian jessie

Server informations

Perl version : v5.20.2
Mysql / Mariadb / Percona version : 5.5.54-0+deb8u1

OCS Inventory informations

Ocs server version : 2.3

Problem's description

When installing and unstalling a plugin the plugin folder stay in /etc/ocsinventory-server/perl/Apache/Ocsinventory/Plugins/
So if you install again the same plugin you have a Err_05 : Residual directory found in perl dir ( by default -> /etc/ocsinventory-server/perl/Apache/Ocsinventory/Plugins/PLUGIN_NAME/ ) in OCS

Regards

Hello.

General informations

Operating system : FreeBSD 11.0-RELEASE-p9

Server informations

Perl version : v5.24.1
Mysql version : 5.6.36

OCS Inventory informations

Ocs server version : 2.3.1

Problem's description

I have tons of messages in apache error log:
Wide character in field 1 but mysql_enable_utf8 not set at /usr/local/lib/perl5/site_perl/Apache/Ocsinventory/Server/Inventory/Cache.pm line 46.
Wide character in field 1 but mysql_enable_utf8 not set at /usr/local/lib/perl5/site_perl/Apache/Ocsinventory/Server/Inventory/Cache.pm line 48.
Wide character in field 4 but mysql_enable_utf8 not set at /usr/local/lib/perl5/site_perl/Apache/Ocsinventory/Server/Inventory/Update.pm line 159.
Wide character in field 5 but mysql_enable_utf8 not set at /usr/local/lib/perl5/site_perl/Apache/Ocsinventory/Server/Inventory/Update.pm line 159.
Wide character in field 5 but mysql_enable_utf8 not set at /usr/local/lib/perl5/site_perl/Apache/Ocsinventory/Server/Inventory/Update.pm line 159.
Wide character in field 6 but mysql_enable_utf8 not set at /usr/local/lib/perl5/site_perl/Apache/Ocsinventory/Server/Inventory/Update.pm line 159.
Wide character in field 2 but mysql_enable_utf8 not set at /usr/local/lib/perl5/site_perl/Apache/Ocsinventory/Server/Inventory/Update.pm line 159.
Wide character in statement but mysql_enable_utf8 not set at /usr/local/lib/perl5/site_perl/Apache/Ocsinventory/Server/Inventory/Update/Hardware.pm line 77.

Seems something went wrong with data from windows system with russian localization.
It's new installation of ocs-inventory 2.3.1
Agent version is 2.3.0

It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.

General informations

Operating system : Windows 10

Server informations

Perl version : v5.18.2
Mysql / Mariadb / Percona version : MYSQL

OCS Inventory informations

Ocs server version : 2.3

Problem's description

Describe your problem here

After expire my SSL Certificate, I create a new one and re-deploy to my computers.
Now the agent can't connect with OCS-Server

==============================================================================
Starting OCS Inventory NG Agent on Wednesday, February 22, 2017 15:06:56.
AGENT => Running OCS Inventory NG Agent Version 2.1.1.1
AGENT => Using OCS Inventory NG FrameWork Version 2.1.1.1
AGENT => Loading plug-in(s)
DLL PLUGIN => Searching for Plug-in DLL(s) in folder <C:\Program Files (x86)\OCS Inventory Agent\plugins>
DLL PLUGIN => 0 DLL Plug-in(s) succesfully loaded on 0 DLL(s) found
AGENT => Using network connection with Communication Server
COM PROVIDER => Loading Communication Provider <C:\Program Files (x86)\OCS Inventory Agent\ComHTTP.dll>
AGENT => Using Communication Provider Version <2.1.1.1>
AGENT => Sending Prolog
DID_CHECK => Read DeviceID and MACs B8:88:E3:DC:65:1100:60:73:6C:CC:3C74:E5:43:16:C4:BC74:E5:43:16:C4:BC44:6D:57:87:29:7D02:50:41:00:00:0100:05:9A:3C:78:0054:72:F8:EE:51:0600:FF:D3:29:5B:C554:B4:39:07:55:0402:00:4C:4F:4F:50 in file <ocsinventory.dat>
COM SERVER => Initializing cURL library for sendRequest
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Enabling cURL SSL server validation support using CA Bundle <C:\ProgramData\OCS Inventory NG\Agent\companyname2017.pem>
COM SERVER => Sending HTTP Post request to URL https://ocs.companyname.com.br/ocsinventory
WARNING *** COM SERVER => Failed to send HTTP Post request <Problem with the SSL CA cert (path? access rights?)>
COM SERVER => Cleaning cURL library
================= TRACE START ===============

================= TRACE STOP ===============
ERROR *** AGENT => Failed to send Prolog <Problem with the SSL CA cert (path? access rights?)>
AGENT => Unloading communication provider
AGENT => Unloading plug-in(s)
AGENT => Execution duration: 00:00:02.

It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.

General informations

Windows Server 2012
Windows NT CC-ICT-SVR01001 6.2 build 9200 (Unknow Windows version Standard Edition) i586

Server informations

Perl version :
Xampp 1.77/ Mysql / Apache 2.2 / Percona version :
Apache/2.2.21 (Win32) mod_ssl/2.2.21 OpenSSL/1.0.0e PHP/5.3.8 mod_perl/2.0.4 Perl/v5.10.1
Apache HTTP Server Version 2.2
Perl 5 version 24.0
MySQL 5.7
Apache/2.2.21 (Win32) mod_ssl/2.2.21 OpenSSL/1.0.0e PHP/5.3.8 mod_perl/2.0.4 Perl/v5.10.1

OCS Inventory informations

Ocs server version : 2.1.2

Problem's description

OCS Inventory Agent not Synchronizing with Server

Hi Guys/Bonjour les amis,

I've extensively read all articles and questions on this topic but i'm not making head way. The OCS Windows agent is not synchronizing to my OSC Inventory Server on Windows Server 2012.

Please see my Agent log below:

==============================================================================
Starting OCS Inventory NG Agent on Friday, April 28, 2017 22:18:11.
AGENT => Running OCS Inventory NG Agent Version 2.3.0.0
AGENT => Using OCS Inventory NG FrameWork Version 2.3.0.0
AGENT => Loading plug-in(s)
DLL PLUGIN => Searching for Plug-in DLL(s) in folder <C:\Program Files (x86)\OCS Inventory Agent\plugins>
DLL PLUGIN => 0 DLL Plug-in(s) successfully loaded on 0 DLL(s) found
AGENT => Using network connection with Communication Server
COM PROVIDER => Loading Communication Provider <C:\Program Files (x86)\OCS Inventory Agent\ComHTTP.dll>
AGENT => Using Communication Provider Version <2.3.0.0>
AGENT => Sending getLabel request
COM SERVER => Initializing cURL library for getFile
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Disabling cURL SSL server validation support
COM SERVER => Sending fileGet request to URL https://X.X.X.X/ocsreports/deploy/label
COM SERVER => fileGet response received <HTTP Status Code #404>
COM SERVER => Cleaning cURL library
AGENT => Failed to retrieve Label <HTTP Status Code #404>
AGENT => Sending Prolog
DID_CHECK => Read DeviceID and MACs in file <ocsinventory.dat>
COM SERVER => Initializing cURL library for sendRequest
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Disabling cURL SSL server validation support
COM SERVER => Sending HTTP Post request to URL https://X.X.X.X/ocsreports
COM SERVER => HTTP Post response received <HTTP Status Code #200>
COM SERVER => Cleaning cURL library
================= TRACE START ===============

================= TRACE STOP ===============
AGENT => Prolog successfully sent
SUPPORT => No support detected, Registration key : N/A
AGENT => Prolog Frequency set to 10 hour(s)
AGENT => Inventory on startup option set to
AGENT => Unloading communication provider
AGENT => Unloading plug-in(s)
AGENT => Execution duration: 00:00:00.

The ocsinventory.ini is as seen below:

[OCS Inventory Agent]
ComProvider=ComHTTP.dll
Debug=2
Local=
NoSoftware=0
HKCU=0
NoTAG=0
IpDisc=
[HTTP]
Server=https://X.X.X.X/ocsreports
SSL=0
CaBundle=cacert.pem
AuthRequired=0
User=
Pwd=
ProxyType=0
Proxy=
ProxyPort=0
ProxyAuthRequired=0
ProxyUser=
ProxyPwd=
[OCS Inventory Service]
PROLOG_FREQ=10
INVENTORY_ON_STARTUP=0
OLD_PROLOG_FREQ=10
TTO_WAIT=35520

Please help anyone...pleaseeee !!

Bonjour,

lorsque nous voulons effectuer un export des informations dans "ALL COMPUTERS", nous avons le message suivant lorsque nous cliquons sur "Download" :
ERROR, the requested doesn't exists.

Quand nous allons regarder le error.log de Apache, nous voyons ceci :
[Thu Feb 09 15:49:37.843710 2017] [:error] [pid 27861] [client] PHP Warning: Invalid argument supplied for foreach() in /var/lib/ocsinventory-reports/plugins/main_sections/ms_export/ms_csv.php on line 46, referer: http://@IP/ocsreports/index.php?function=visu_computers

[Thu Feb 09 15:49:37.848237 2017] [:error] [pid 27861] [client] PHP Warning: Invalid argument supplied for foreach() in /var/lib/ocsinventory-reports/plugins/main_sections/ms_export/ms_csv.php on line 93, referer: http://@IP/ocsreports/index.php?function=visu_computers

Pour informations, notre version d'OCS serveur est la 2.3.0 révision 1.el7.ocs

Merci d'avance pour le retour

General informations

Operating system : CentOS

Server informations

Mariadb

OCS Inventory informations

Ocs server version : 2.3

Fields MMANUFACTURER, MMODEL and MSN from BIOS group are not sent to DB.

Ex., I've an XML on the agent:

        <BIOS>
            <SMANUFACTURER>ALG soft</SMANUFACTURER>
            <SMODEL>To be filled by O.E.M.</SMODEL>
            <SSN>418393</SSN>
            <TYPE>Desktop</TYPE>
            <BMANUFACTURER>American Megatrends Inc.</BMANUFACTURER>
            <BVERSION>F15</BVERSION>
            <BDATE>10/23/2013</BDATE>
            <MMANUFACTURER>Gigabyte Technology Co., Ltd.</MMANUFACTURER>
            <MMODEL>B75M-D3H</MMODEL>
            <MSN>CG3380 03129</MSN>
            <ASSETTAG>Gigabyte Technology Co., Ltd.</ASSETTAG>
        </BIOS>

but some info doesn't exist in DB on a server:

root@localhost [ocsweb]> select SSN, MMODEL from bios where hardware_id=2025;
+--------+--------+
| SSN    | MMODEL |
+--------+--------+
| 418393 | NULL   |
+--------+--------+

OCSInventory-Server v.2.3 RELEASE

General informations

Operating system : Debian GNU/Linux 8 (jessie)

Server informations

Perl version :
Mysql / Mariadb / Percona version : (Debian) version 5.5.54-0+deb8u1

OCS Inventory informations

Ocs server version : 2.3.1

Problem's description

Bonjour,

serait-il possible de créer un repository "up to date", "latest" (ou un lien symbolique pointant vers) pour le téléchargement des fichiers d'installation du serveur OCS Inventory Unix / Linux ?

En raison des différentes versions livrées à ce jour, des informations contradictoires (et la plupart obsolètes) persistent un peu partout sur Internet (cf. tuto d'internautes, ouvrages sur OCS Inventory, etc.) et lors du téléchargement / installation du serveur OCS Inventory NG, il me semble que l'on devrait pouvoir proposer en priorité la dernière version stable en date.

Bien cordialement, Stéphane

login into OCS Inventory

in the main > all computers
select MAC Address column
here you are able to see computer001 <> mac 00:01:02:03:04:05
click on the "computer001" > hardware

scroll down to Networks
here you'll have only

No data available in table
Showing 0 to 0 of 0 entries

Can OCS Inventory be extended to record the firewall state and configuration for UNIX (in particular Linux) systems as well as Windows hosts?

A few plugins exist here and there, but there isn't a cross platform solution.

Hello team,

After putting this line on my apache config, I noticed that OCS Agent was unable to send information

SSLProtocol -all +TLSv1.2

So I was forced to write "SSLProtocol -all +SSLv3 +TLSv1.2" in order to

• make agent communicate with server
• make my webserver accesible by web

Is it scheduled to add the support of TLS in the next version?

OCS Inventory informations

Ocs server version : 2.3

Problem's description

The wiki (klick) is telling:

Download and unzip the latest Windows agent from the Downloads section. This package contains 2 files:

Unfortenately is OcsLogon.exe missing in the Archiv which is provided to download at https://github.com/OCSInventory-NG/WindowsAgent/releases/download/2.3/OCSNG-Windows-Agent-2.3.0.0.zip

General informations

Operating system : FreeBSD 10.3-RELEASE-p11

Server informations

Perl version : v5.20.3
Mysql version : 5.7.15 with enabled an 'explicit-defaults-for-timestamp' option

OCS Inventory informations

Ocs server version : 2.3.1

Problem's description

An 'explicit-defaults-for-timestamp' MySQL option disables a nonstandard behaviors for TIMESTAMP data type column. The behaviors will be removed in a future MySQL release.
If the 'explicit-defaults-for-timestamp' option is enabled TRACE_DELETED option causes a fail of automerging in next code of Apache/Ocsinventory/Server/Duplicate.pm:270:

  # Trace duplicate if needed
  if($ENV{'OCS_OPT_TRACE_DELETED'}){
    unless(  $dbh->do('INSERT INTO deleted_equiv(DATE,DELETED,EQUIVALENT) VALUES(NULL,?,?)', {} , $device,$DeviceID)){
      &_unlock($device);
      return(1);
    }

$dbh->errstr returns Column 'DATE' cannot be null.

P.S. Need an enhancement tag.

General informations

Centos 6.9

Server informations

Perl version : v5.10.1
Mysql / Mariadb / Percona version :
Mysql 5.7.17

OCS Inventory informations

Ocs server version : 2.3.0.1

Problem's description

Hi, I think since I upgraded to version 2.3 the local import doesn't work anymore, I went to Manage -> import Local and chose the file .ocs, when I click send and message appear in a red box:

Error HTTP/1.1 403 Forbidden

The same thing occur using ocsinventory-injector.pl

[root@flinsvm006 ~]# ./ocsinventory-injector.pl -d . -u http://ocs.fln.esss.com.br/ocsinventory -r -v
Loading ./flinssv013-2017-04-04-18-21-10.ocs...ERROR: 403 Forbidden
Loading ./flinssv012-2017-04-07-12-26-24.ocs...ERROR: 403 Forbidden
Loading ./flinssv014.fln.esss.com.br-2017-02-10-11-52-35.ocs...ERROR: 403 Forbidden
Loading ./spinssv004.sp.esss.com.br-2016-12-27-17-49-39.ocs...ERROR: 403 Forbidden
Loading ./rjinssv006.fln.esss.com.br-2016-06-18-13-29-27.ocs...ERROR: 403 Forbidden

How can I trace the error? no message is showed in apache logs or ocs activity.log

Thanks for advance

It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.

General informations

Operating system : Ubuntu 16.04 / Windows 7

Server informations

Perl version : 7
Mysql / Mariadb / Percona version : 14.14

OCS Inventory informations

Ocs server version : 2.3.0.1

Problem's description

• Starting OCSLogon from cmd: C:\Users\asdf\Desktop>OcsLogon.exe /SERVER=https://ocsng/ocsinventory /PACKAGER /DEBUG
• Downloading the ocs package from Server fails with Downloading file <https://ocsng/ocsinventory/deploy/ocspackage.exe> without server authentication...SendRequest Error: Failed downloading file !
  -Open URL with Firefox->Download start

Where is the problem?

Under certain circumstances (that I did not lighten), it may lead to "duplicate;replacing_error" in log file resulting in duplicate host in database. Digging further I found that OCS Server try to delete old host informations according to Map.pm but declared table "usbdevices" does not exist, thus returning an error and stopping old host deletion.

I may not be clear, please ask me more information as needed.

It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.

General informations

Operating system :
CentOS Linux release 7.3.1611 (Core)

Server informations

Perl version : v5.16.3
Mysql / Mariadb / Percona version :
mariadb-server-5.5.52-1.el7.x86_64

OCS Inventory informations

Ocs server version :
ocsinventory-server-2.3.1-4.el7.ocs.noarch

Problem's description

When I install a plugin I receive the following error:

I have the same problem with all plugin installed and none works. The plugin I tryed to install are:
uptime, security, winupdate
I installed the plugin in the following way:

# cd /var/lib/ocsinventory-reports/plugins/download
# wget https://github.com/PluginsOCSInventory-NG/winupdate/releases/download/1.0/winupdate.zip
# chcon -u system_u *.zip
# chown apache winupdate.zip
# ls -laZ
drwxr-xr-x. apache root system_u:object_r:httpd_sys_rw_content_t:s0 .
drwxr-xr-x. apache root system_u:object_r:httpd_sys_rw_content_t:s0 ..
-rwxr-xr-x. apache root system_u:object_r:httpd_sys_rw_content_t:s0 README
-rw-r--r--. apache root system_u:object_r:httpd_sys_rw_content_t:s0 security.zip
-rw-r--r--. apache root system_u:object_r:httpd_sys_rw_content_t:s0 uptime.zip
-rw-r--r--. apache root system_u:object_r:httpd_sys_rw_content_t:s0 winupdate.zip
# service httpd restart

I go to plugin-manager then I install the plugin... and I have the error.

On a une machine (il semble que ce soit la seule sur notre réseau) qui nous rapporte des sections <USBDEVICES> dans son inventaire.

Ca fait planter le serveur (erreur 500):

[Wed Jan 18 12:35:43.097504 2017] [perl:error] [pid 7615] [client 10.4.4.50:36642] Not a HASH reference at /usr/local/share/perl/5.18.2/Apache/Ocsinventory/Server/Inventory/Data.pm line 126

J'ai rajouté des print STDERR sur le serveur, et j'en conclus que le problème vient du fait que le serveur stocke ces infos sous forme de ARRAY alors qu'il s'attend plus tard, lors du traitement de ces données, à recevoir un HASH.

Voici le code que j'ai ajouté dans Data.pm:

sub _get_bind_values{
  my ($refXml, $sectionMeta, $arrayToFeed) = @_;

  my ($bind_value, $xmlvalue, $xmlfield);

+#CBU
+if (ref($refXml) eq "ARRAY")
+{
+  print STDERR "refXml:\n";
+  for (@$refXml)
+  {
+      print STDERR Dumper($_);
+  }
+} else
+{
+  print STDERR "refXml: $refXml\n";
+}
+#CBU

  for my $field ( @{ $sectionMeta->{field_arrayref} } ) {
+    print STDERR "field = $field - refXml->field = $refXml->{$field}\n"; # CBU
    if(defined($refXml->{$field}) && !defined($sectionMeta->{fields}->{$field}->{type}) && $refXml->{$field} ne '' && $refXml->{$field} ne '??' && $refXml->{$field}!~/^N\/?A$/) {
      $bind_value = $refXml->{$field}
    }
    else{
       if( defined $sectionMeta->{fields}->{$field}->{fallback} ){
         $bind_value = $sectionMeta->{fields}->{$field}->{fallback};
         &_log( 000, 'fallback', "$field:".$sectionMeta->{fields}->{$field}->{fallback}) if $ENV{'OCS_OPT_LOGLEVEL'}>1;
       }
       else{
         &_log( 000, 'generic-fallback', "$field:".$sectionMeta->{fields}->{$field}->{fallback}) if $ENV{'OCS_OPT_LOGLEVEL'}>1;
         $bind_value = '';
       }
    }

Voici un extrait de mon error.log apache correspondant au problème.

refXml: HASH(0x7f43e02a93a0)
field = FILESIZE - refXml->field =
field = BITSWIDTH - refXml->field =
field = GUID - refXml->field =
field = SOURCE - refXml->field =
field = NAME - refXml->field = zlib
field = FILENAME - refXml->field =
field = LANGUAGE - refXml->field =
field = INSTALLDATE - refXml->field =
field = VERSION - refXml->field = 1:1.2.11-1
field = PUBLISHER - refXml->field =
field = COMMENTS - refXml->field =
field = FOLDER - refXml->field =
refXml: HASH(0x7f43e02a96a0)
field = FILESIZE - refXml->field =
field = BITSWIDTH - refXml->field =
field = GUID - refXml->field =
field = SOURCE - refXml->field =
field = NAME - refXml->field = zziplib
field = FILENAME - refXml->field =
field = LANGUAGE - refXml->field =
field = INSTALLDATE - refXml->field =
field = VERSION - refXml->field = 0.13.62-2
field = PUBLISHER - refXml->field =
field = COMMENTS - refXml->field =
field = FOLDER - refXml->field =
refXml:
$VAR1 = {
          'DESCRIPTION' => 'Digital DataTraveler SE9 64GB',
          'MANUFACTURER' => 'Kingston',
          'SERIAL' => '60A44C413B99B05129980011'
        };
$VAR1 = {
          'MANUFACTURER' => 'CHICONY',
          'TYPE' => 'Keyboard',
          'DESCRIPTION' => 'NetVista Full Width Keyboard'
        };
$VAR1 = {
          'MANUFACTURER' => 'CHICONY',
          'TYPE' => 'Mouse'
        };
$VAR1 = {
          'DESCRIPTION' => 'USB 2.0 Hub',
          'MANUFACTURER' => 'CHICONY',
          'TYPE' => 'Single TT'
        };
$VAR1 = {
          'SERIAL' => '0000:00:1d.3',
          'TYPE' => 'Full speed (or root) hub',
          'MANUFACTURER' => 'Linux',
          'DESCRIPTION' => '1.1 root hub'
        };
$VAR1 = {
          'SERIAL' => '0000:00:1d.2',
          'MANUFACTURER' => 'Linux',
          'TYPE' => 'Full speed (or root) hub',
          'DESCRIPTION' => '1.1 root hub'
        };
$VAR1 = {
          'TYPE' => 'Full speed (or root) hub',
          'MANUFACTURER' => 'Linux',
          'DESCRIPTION' => '1.1 root hub',
          'SERIAL' => '0000:00:1d.1'
        };
$VAR1 = {
          'SERIAL' => '0000:00:1d.0',
          'TYPE' => 'Full speed (or root) hub',
          'MANUFACTURER' => 'Linux',
          'DESCRIPTION' => '1.1 root hub'
        };
$VAR1 = {
          'MANUFACTURER' => 'Linux',
          'TYPE' => 'Full speed (or root) hub',
          'DESCRIPTION' => '1.1 root hub',
          'SERIAL' => '0000:00:1a.1'
        };
$VAR1 = {
          'SERIAL' => '0000:00:1a.0',
          'TYPE' => 'Full speed (or root) hub',
          'MANUFACTURER' => 'Linux',
          'DESCRIPTION' => '1.1 root hub'
        };
[Wed Jan 18 12:35:43.097504 2017] [perl:error] [pid 7615] [client 10.4.4.50:36642] Not a HASH reference at /usr/local/share/perl/5.18.2/Apache/Ocsinventory/Server/Inventory/Data.pm line 141.\n

On voit que le plante sur le dernier refXml qu'il traite, qui est un ARRAY au lieu d'être un HASH comme les 2 précédents. Et, en comparant les infos contenues dans cet ARRAY à un inventaire local de cette machine, on a pu déterminer que cet ARRAY correspond aux sections <USBDEVICES> de cet inventaire.

creating a user or alter a old one will prompt this errors in error_log ( apache )

[Mon Nov 28 19:19:05 2016] [error] [client 192.168.254.235] PHP Warning: constant(): Couldn't find constant in /usr/share/ocsinventory-reports/ocsreports/require/function_users.php on line 115, referer: http://ocs.mydomain.com/ocsreports/index.php?function=admin_user_details&user_id=ion.ionescu
[Mon Nov 28 19:19:05 2016] [error] [client 192.168.254.235] PHP Warning: password_hash(): Unknown password hashing algorithm: 0 in /usr/share/ocsinventory-reports/ocsreports/require/function_users.php on line 115, referer: http://ocs.mydomain.com/ocsreports/index.php?function=admin_user_details&user_id=ion.ionescu

(domain and user altered)

and the user cannot login any more

server
linux CentOS 6 - last update
uname -a
ocs.mydomain.com 2.6.32-642.11.1.el6.x86_64 #1 SMP Fri Nov 18 19:25:05 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux

httpd -v
Server version: Apache/2.2.15 (Unix)
Server built: Nov 18 2016 23:48:5

php -v
PHP 5.6.28 (cli) (built: Nov 10 2016 21:09:50)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies

It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.

General informations

Operating system : Debian jessie

Server informations

Perl version : v5.20.2
Mysql / Mariadb / Percona version : 5.5.54-0+deb8u1

OCS Inventory informations

Ocs server version : 2.3

Problem's description

When I uninstall a OCS plugins, OCS delete the folder:
/etc/ocsinventory-server/perl/Apache/Ocsinventory/Plugins

So when next you try to install a plugins you have Err_04 : Can't write in perl directory ( by default -> /etc/ocsinventory-server/perl/Apache/Ocsinventory/Plugins
And you need to recreat the folder.
So this break all other plugins, who need to be installed again.

I have 2 different hdd in my server, but in OCS it looks a little bit strange

Same model - wrong
different size - correct
same firmware - wrong

OCS_INVENTORY_WRITE_DIFF ne fonctionne pas avec des tables possédant un champ DateTime ( ou Date)

pour reproduire les problèmes (tests réalisés avec l’agent 2.0.5 et 2.1.1.1) :

• activer l’option INVENTORY_WRITE_DIFF dans la console
• déboguer les variables $comp_db et $comp_xml du module Apache/Ocsinventory/Server/Inventory/Update.pm ( situées lignes 106 & 107)

-ajouter / supprimer un logiciel (ou positionner mask => 0 dans le fichier Map.pm pour la section softwares) pour déclencher les comparaisons XML vs BDD

1. l’agent OCS retourne les dates sous le format AAAA/MM/JJ
   la BD stocke les dates sous le format AAAA-MM-JJ 00:00:00
   La comparaison est toujours en échec
   exemple avec la table softwares :

comp_xml :Langue neutreMicrosoft .NET Framework 4.5.2Microsoft Corporation2015/12/05{3911CF56-9EF2-39BA-846A-C27BD3CD0685}04.5.51209321
comp_db :Langue neutreMicrosoft .NET Framework 4.5.2Microsoft Corporation2015-12-05 00:00:00{3911CF56-9EF2-39BA-846A-C27BD3CD0685}04.5.51209321

2. l’agent OCS retourne la valeur 0000//0/0/00 lorsqu’il ne peut pas déterminer la date (au moins pour la section softwares)
   cette valeur est transformée en 0000-00-00 00:00:00 dans la base

comp_xml :OCS Inventory NG Agent 2.1.1.1OCS Inventory NG Team0000//0/0/00OCS Inventory NG Agent02.1.1.1321
comp_db :OCS Inventory NG Agent 2.1.1.1OCS Inventory NG Team0000-00-00 00:00:00OCS Inventory NG Agent02.1.1.1321

3. pour la table drives :

-aucune date n’est retournée par l’agent, la BD stocke la date par défaut:

comp_xml :D:0CD-Rom Drive00
comp_db :D:0CD-Rom Drive000000-00-00

contournement : donner une valeur fallback dans Map.pm au champs CREATEDATE

 CREATEDATE => {fallback=>'0000-00-00'}

File etc/ocsinventory-reports.conf contains <IfModule mod_php5.c>

When you install the server for the first time, there's no way to select the install language.
You'll be able to select it only when you login on the web console.

Operating system

OS Name : Linux x86_64
Version : 2.6.32-642.11.1.el6.x86_64
RAM installed : 3832 Mo
Free RAM :
CPU : Common KVM processor
Distribution : CentOS release 6.8 (Final)

Software

PHP Version : 5.6.28 (apache2handler)
Web Server : Apache/2.2.15 (CentOS)
Database Server : Source distribution version 5.1.73
Version OCSReports: 2.3

OCS updated from 2.1.1

build a new package to update OCS-NG-Windows-Agent
(
make a zip with the exe , and build the package to run the command
OCS-NG-Windows-Agent-Setup.exe /S /UPGRADE /NOSPLASH /NO_SYSTRAY /SSL=0 /SERVER=http://ocs.mydomain.com/ocsinventory
)

activate, for manual only,

test on one instance as
find the appropriate computer > cluck on the computer name > Deployment > Add package > use advanced... NO + VALIDATE > select from the list the appropriate package and click on the small square on the right,

wait the right amount of time ( or force the computer to contact the server )
the package is SUCCESS

MASS DEPLOY

" search with various criteria " > will result in a list of 5~10 computers
select all or some of them > deploy > Mass affectation = "for selection" > Use advanced ... for teledeply = "NO" + VALIDATE >
without any obvious error (even on the log file )
Mass affectation = "for selection" > Use advanced ... for teledeply = "NO" + VALIDATE >
...
Mass affectation = "for selection" > Use advanced ... for teledeply = "NO" + VALIDATE >

NO list for packages to select from

On install Plugins take this error The communication server encountered the following error on install : Err_02

General informations

Operating system :
CentOS 7.3 x64

Server informations

Perl version : 5.16.3
Mysql / Mariadb / Percona version :
Percona-Server 5.7.17-11

OCS Inventory informations

Ocs server version :
2.3

Problem's description

On error log httpd server

[Fri Mar 03 15:11:02.809043 2017] [php7:warn] [pid 7061] [client 10.128.1.62:60925] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197
[Fri Mar 03 15:11:18.251413 2017] [php7:warn] [pid 7077] [client 10.128.1.62:60941] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197
[Fri Mar 03 15:11:21.188128 2017] [php7:warn] [pid 7077] [client 10.128.1.62:60941] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/
[Fri Mar 03 15:11:25.409652 2017] [php7:warn] [pid 7077] [client 10.128.1.62:60941] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/
[Fri Mar 03 15:11:36.042489 2017] [php7:warn] [pid 7064] [client 10.128.1.62:60957] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/
[Fri Mar 03 15:11:36.862132 2017] [php7:warn] [pid 7064] [client 10.128.1.62:60957] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/
[Fri Mar 03 15:11:38.063886 2017] [php7:warn] [pid 7064] [client 10.128.1.62:60957] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/
[Fri Mar 03 15:11:38.547069 2017] [php7:warn] [pid 7064] [client 10.128.1.62:60957] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/
[Fri Mar 03 15:11:39.741255 2017] [php7:warn] [pid 7064] [client 10.128.1.62:60957] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/
[Fri Mar 03 15:11:40.908124 2017] [php7:warn] [pid 7064] [client 10.128.1.62:60957] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/
[Fri Mar 03 15:11:41.047855 2017] [php7:warn] [pid 7064] [client 10.128.1.62:60957] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/?function=visu_computers
[Fri Mar 03 15:11:45.801414 2017] [php7:warn] [pid 7064] [client 10.128.1.62:60957] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/?function=visu_computers
[Fri Mar 03 15:16:30.621887 2017] [php7:warn] [pid 7079] [client 10.128.1.62:61245] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/index.php?function=account_config&head=1
[Fri Mar 03 15:16:30.758288 2017] [php7:warn] [pid 7079] [client 10.128.1.62:61245] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/index.php?function=pluginsmanager
[Fri Mar 03 15:16:32.811900 2017] [php7:warn] [pid 7079] [client 10.128.1.62:61245] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/index.php?function=account_config&head=1
[Fri Mar 03 15:16:32.929047 2017] [php7:warn] [pid 7079] [client 10.128.1.62:61245] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/index.php?function=pluginsmanager
[Fri Mar 03 15:16:38.176266 2017] [php7:warn] [pid 7064] [client 10.128.1.62:61264] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/index.php?function=pluginsmanager
[Fri Mar 03 15:16:38.468429 2017] [php7:warn] [pid 7064] [client 10.128.1.62:61264] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /usr/share/ocsinventory-reports/ocsreports/require/header.php on line 197, referer: http://ocs.inside.mts.by/index.php?function=pluginsmanager

Try to reinstall, same problem. Try to install last committed ocs inventory server and ocsreports - same error!
Any idea?

Hello,

Can you guys please check how the compression of the tar file. The name of the file contains .tar.gz, but it is not gzipped, so when i execute the command:

tar -zxvf OCSNG_UNIX_SERVER-2.2.tar.gz

Return this:

gzip: stdin: not in gzip format
tar: Child returned status 1
tar: Error is not recoverable: exiting now

General informations

Operating system : Ubuntu 4.4.0-67-generic

Server informations

Perl version : 5.22.1
Mysql version : 5.7.17-0ubuntu0.16.04.1

OCS Inventory informations

Ocs server version : 2.3.1

Problem's description

OCS maps the virtual machines to the host systems, which is a very nice and powerful feature.
Unfortunately it isn´t working correct if we have the vms on multiple hosts (only on one host running) .
On the host that runs the vm i don´t see the name or any information about the vm, i see only that it is running.
If the vm is tunred off i see the name, uuid, memory and processor of the vm.

So in our case the runnig vm is mapped to the wrong host cause ocs see the vm only on the on which the vm is turned off.

I don´t now if it´s possible to fix this, but it would be very nice.

Attached some screenshots:
VM is mapped to the wrong vhost

Some vms are running on the host but i don´t see any information about them

as you can see vm is turned off on this host, and now i can see some information about it

Bonjour,

La taille totale d'un disque dur de 1 To s'inscrit 1 MB dans la base de données "ocsweb" et dans l'affichage "ocsreports" comme le montre le fichier "export.txt" ci-joint.

Est-il possible de corriger ce problème ?

Environnement:

• #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux
• OCSNG_UNIX_SERVER-2.2.1
• Ocsinventory-Unix-Agent-2.1.1

export.txt

General informations

Operating system : Centos 6.6 x86_64

Server informations

Perl version : v5.10.1
Mysql / Mariadb / Percona version : Mysql 5.7.17

OCS Inventory informations

Ocs server version : 2.3.0.0

Problem's description

Hi, after upgraded to 2.3.0.0 a lot of computers start to get duplicated I can't find the solution.
The activity.log just appear:

OCS-NG_WINDOWS_AGENT_v2.3.0.0;duplicate;replacing_error

thanks for advance

General informations

Operating system : debian

Server informations

Perl version : last
Mysql / Mariadb / Percona version : Mysql 5.5

OCS Inventory informations

Ocs server version : 2.3

Problem's description

All is running good except counters in the main page (index.php) i mean if i add a new computer installing one new agent i see it in "all computers" section but to see counters updated in the main page i have to logoff login

Do you know why?

Hello,

As I (try to) update the Android Agent, i'm searching for a documentation of all possibles tags and values that can be send by the agent.
I wasn't able to find this. I just find the DTD elements.

Is it anywhere ?
If no, should be a great idea to add this imho :)

Version OCS : 2.2.1

Actuellement dans IPdiscover, je me retrouve avec des données obsolètes (exemple : découverte réseau datant de Juin)

Il serait intéressant de pouvoir définir un paramètre de suppression automatique des enregistrements IPDiscover datant de plus de XX jours

hi, sorry my english :)
my os: Linux app 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt9-3~deb8u1 (2015-04-24) x86_64
mysql : 5.6
DATABASE ocsweb /*!40100 COLLATE 'utf8_general_ci' */
error : -e: DBD::mysql::db do failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at /usr/local/share/perl/5.20.2/Apache/Ocsinventory/Server/Inventory/Cache.pm line 34

i find google and found: https://www.webgui.org/etcetera/dbdmysqlst-execute-failed-illegal-mix-of-collations/1
[mysqld]
default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci

[client]
default-character-set=utf8

so still faulty .
thanks

Bonjour,
J'ai un problème sur la version 2.2.1.
J'ai effectué une mise à jour depuis la version 2.1.2 qui possédait déjà la config ldap à la fois dans l'interface de configuration et dans les fichiers auth.php et identity.php

Lors de la mise à jour, j'ai du remettre la ligne $list_methode=array(0=>"ldap.php",1=>"local.php"); dans les fichiers auth et idendity (comme indiqué dans le wiki).

Lorsque je me logue avec un user du ldap, pas de problèmes, par contre avec mon user local admin, mon profil est cassé, je n'ai plus de droits pour modifier, créér un user, je n'ai plus accès au plugins, j'avais caché les warning du GUI etc...
En plus, le menu a un comportement bizarre 👍

Dites moi quoi envoyer pour faire l'analyse du problème.