ocsinventory-ng / ocsinventory-server Goto Github PK
View Code? Open in Web Editor NEWCommunication server of OCS Inventory
Home Page: http://www.ocsinventory-ng.org/
License: GNU General Public License v2.0
Communication server of OCS Inventory
Home Page: http://www.ocsinventory-ng.org/
License: GNU General Public License v2.0
[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_
It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.
Windows Server 2012
Windows NT CC-ICT-SVR01001 6.2 build 9200 (Unknow Windows version Standard Edition) i586
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 server version : 2.1.2
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 !!
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
Is it scheduled to add the support of TLS in the next version?
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
It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.
Operating system : Centos 7 minimal
Perl version : (v5.16.3)
Mysql / Mariadb / Percona version : 4.1
Ocs server version : 2.31
Describe your problem here
I can't run httpd service.
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!
Operating system : Centos 6.6 x86_64
Perl version : v5.10.1
Mysql / Mariadb / Percona version : Mysql 5.7.17
Ocs server version : 2.3.0.0
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
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
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
Ocs server version : 2.3
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
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.
Operating system : FreeBSD 10.3-RELEASE-p11
Perl version : v5.20.3
Mysql version : 5.7.15 with enabled an 'explicit-defaults-for-timestamp' option
Ocs server version : 2.3.1
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.
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
Hello.
Operating system : FreeBSD 11.0-RELEASE-p9
Perl version : v5.24.1
Mysql version : 5.6.36
Ocs server version : 2.3.1
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
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.
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.
It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.
Operating system : Debian jessie
Perl version : v5.20.2
Mysql / Mariadb / Percona version : 5.5.54-0+deb8u1
Ocs server version : 2.3
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.
File etc/ocsinventory-reports.conf
contains <IfModule mod_php5.c>
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.
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
Operating system : Debian GNU/Linux 8 (jessie)
Perl version :
Mysql / Mariadb / Percona version : (Debian) version 5.5.54-0+deb8u1
Ocs server version : 2.3.1
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
Centos 6.9
Perl version : v5.10.1
Mysql / Mariadb / Percona version :
Mysql 5.7.17
Ocs server version : 2.3.0.1
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.
Operating system : Windows 10
Perl version : v5.18.2
Mysql / Mariadb / Percona version : MYSQL
Ocs server version : 2.3
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.
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?
It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.
Operating system :
CentOS Linux release 7.3.1611 (Core)
Perl version : v5.16.3
Mysql / Mariadb / Percona version :
mariadb-server-5.5.52-1.el7.x86_64
Ocs server version :
ocsinventory-server-2.3.1-4.el7.ocs.noarch
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.
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
On install Plugins take this error The communication server encountered the following error on install : Err_02
Operating system :
CentOS 7.3 x64
Perl version : 5.16.3
Mysql / Mariadb / Percona version :
Percona-Server 5.7.17-11
Ocs server version :
2.3
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?
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
Operating system : CentOS
Mariadb
Ocs server version : 2.3
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?
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
It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.
Operating system : Debian jessie
Perl version : v5.20.2
Mysql / Mariadb / Percona version : 5.5.54-0+deb8u1
Ocs server version : 2.3
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
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/OCSNG_UNIX_SERVER-2.2.1#
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:
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
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 :)
Operating system Server : Debian GNU/Linux 7
Operating system Client : Windows 10 build 1703 x64
Apache Server version : 2.2.22
Perl version : 5.14.2
Mysql version : 5.5.55
OCS server version : 2.3.1
OCS Agent version : 2.3
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
...
<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>
...
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)
...
<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>
...
==============================================================================
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.
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.
Operating system : debian
Perl version : last
Mysql / Mariadb / Percona version : Mysql 5.5
Ocs server version : 2.3
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?
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.
Operating system : Ubuntu 16.04 / Windows 7
Perl version : 7
Mysql / Mariadb / Percona version : 14.14
Ocs server version : 2.3.0.1
C:\Users\asdf\Desktop>OcsLogon.exe /SERVER=https://ocsng/ocsinventory /PACKAGER /DEBUG
Downloading file <https://ocsng/ocsinventory/deploy/ocspackage.exe> without server authentication...SendRequest Error: Failed downloading file !
Where is the problem?
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
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!
Operating system : Ubuntu 4.4.0-67-generic
Perl version : 5.22.1
Mysql version : 5.7.17-0ubuntu0.16.04.1
Ocs server version : 2.3.1
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
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.
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.
/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
Perl Path
mv /usr/local/share/perl/5.14.2 /usr/local/share/perl/5.20.2
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
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) :
-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
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
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
-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'}
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:
Operating system : FreeBSD 10.3-RELEASE-p11
Perl version : v5.20.3
Mysql version : 5.7.15
Ocs server version : 2.3.0.0 or 2.3.1 (fresh install).
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.
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
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.