search

OCSInventory-NG / OCSInventory-Server

Communication server of OCS Inventory
http://www.ocsinventory-ng.org/
GNU General Public License v2.0
344 stars 139 forks source link

No information about software on server #315

Closed nohnaimer closed 3 years ago

nohnaimer commented 3 years ago

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 8 x64

Server informations

Perl version : 5.26.3 Percona version : 8.0.21

OCS Inventory informations

Ocs server version : 2.8

Problem's description

On agent log:

==============================================================================
Starting OCS Inventory Agent on Wednesday, March 31, 2021 13:31:15.
AGENT => Running OCS Inventory Agent Version 2.8.0.1
AGENT => Using OCS Inventory FrameWork Version 2.8.0.1
AGENT => Loading plug-in(s)
    DLL PLUGIN => Searching for Plug-in DLL(s) in folder <C:\Program Files\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\OCS Inventory Agent\ComHTTP.dll>
AGENT => Using Communication Provider <OCS Inventory cURL Communication Provider> Version <2.8.0.1>
    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 => Enabling cURL SSL server validation support using CA Bundle <cacert.pem>
    COM SERVER => Sending fileGet request to URL <https://ocsi.inside.mts.by/ocsinventory/deploy/label>
    COM SERVER => fileGet response received <HTTP Status Code #400>
    COM SERVER => Cleaning cURL library
    AGENT => Failed to retrieve Label <HTTP Status Code #400>
AGENT => Sending Prolog
    DID_CHECK => Read DeviceID <M1AUTO99V-2021-03-31-13-22-44> and MACs <14:8A:20:52:41:5300:50:56:91:7E:C9> 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 <cacert.pem>
    COM SERVER => Sending HTTP Post request to URL <https://ocsi.inside.mts.by/ocsinventory>
    COM SERVER => HTTP Post response received <HTTP Status Code #200>
    COM SERVER => Cleaning cURL library
AGENT => Prolog successfully sent
    AGENT => Prolog Frequency set to 1 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 <ma>
    INVENTORY => Operating System is <Microsoft Windows 7   INVENTORY => Operating System uses 64 bits memory address width
    INVENTORY => Computer domain or workgroup is <mts.loc>
    WARNING *** INVENTORY => Failed to retrieve user domain
    INVENTORY => System Manufacturer <VMware, Inc.>, System Model <VMware Virtual Platform>, System S/N <VMware-42 11 af 13 b7 85 e5 bc-ff 4a 5f 8c 14 2f 12 3c>, Bios Manufacturer <Phoenix Technologies LTD>, Bios Date <14/04/2014>, Bios Version <6.00>, Motherboard Manufacturer <Intel Corporation>, Motherboard Model <>, Motherboard S/N <None>
    INVENTORY => 1 processor(s) Intel(R) Xeon(R) CPU           X7560  @ 2.27GHz [2 core(s) x86_64] at 2261 MHz
    INVENTORY => OS Memory 2048 MB, OS Swap size 4208 MB
    INVENTORY => 64 memory slot(s) found
    INVENTORY => 2 input device(s) found
    INVENTORY => 4 system port(s) found
    INVENTORY => 7 system slot(s) found
    INVENTORY => 5 system controller(s) found
    INVENTORY => 3 storage peripheral(s) found
    WARNING *** INVENTORY => Failed to retrieve sound devices
    WARNING *** INVENTORY => Failed to retrieve modems
    INVENTORY => 6 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 <10.128.217.28>
    INVENTORY => Registered company <>, registered owner <and1>, Product ID <00371-OE...>
    INVENTORY => Product key <2WCJK-R8...>
    INVENTORY => 111 software found
    INVENTORY => Computer/VM UUID is <13AF1142-85B7-BCE5-FF4A-5F8C142F123C>
    INVENTORY => Computer seems to be VMware virtual host
    INVENTORY => System Memory set to 2048 (instead of 2048)
    INVENTORY => Reading last inventory state
    EXECUTABLE PLUGIN => Searching for VBS script(s) in folder <C:\Program Files\OCS Inventory Agent\plugins>
    EXECUTABLE PLUGIN => Found executable plugin <winusers.vbs>
    EXECUTABLE PLUGIN => Plugin <winusers.vbs> executed successfully
    EXECUTABLE PLUGIN => Found executable plugin <winusers_test.vbs>
    EXECUTABLE PLUGIN => Plugin <winusers_test.vbs> executed successfully
    EXECUTABLE PLUGIN => Found executable plugin <winusers_test_remote_user.vbs>
    EXECUTABLE PLUGIN => Plugin <winusers_test_remote_user.vbs> executed successfully
    EXECUTABLE PLUGIN => Searching for PS1 script(s) in folder <C:\Program Files\OCS Inventory Agent\plugins>
    EXECUTABLE PLUGIN => Found executable plugin <Saas.ps1>
    WARNING *** EXECUTABLE PLUGIN => Plugin <C:\Program Files\OCS Inventory Agent\plugins\Saas.ps1> does not produce any output
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 64 Memory Slot(s)
    INVENTORY => XML Update 2 Input Device(s)
    INVENTORY => XML Update 4 System Port(s)
    INVENTORY => XML Update 5 System Controller(s)
    INVENTORY => XML Update 7 System Slot(s)
    INVENTORY => XML Update 0 Sound Device(s)
    INVENTORY => XML Update 3 Storage Peripheral(s)
    INVENTORY => XML Update 3 Logical Drive(s)
    INVENTORY => XML Update 0 Modem(s)
    INVENTORY => XML Update 6 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 112 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 => Enabling cURL SSL server validation support using CA Bundle <cacert.pem>
    COM SERVER => Sending HTTP Post request to URL <https://ocsi.inside.mts.by/ocsinventory>
    COM SERVER => HTTP Post response received <HTTP Status Code #200>
    COM SERVER => Cleaning cURL library
ADMIN INFO => Couple ( TAG <=> NA ) added to configuration file
AGENT => Inventory successfully sent
    INVENTORY => Writing new inventory state
AGENT =>  Communication Server asked for Package Download
    DOWNLOAD => Package history file successfully cleaned for duplicate IDs
DOWNLOAD => Download and setup tool successfully started
AGENT => Unloading communication provider
AGENT => Unloading plug-in(s)
AGENT => Execution duration: 00:00:08.

I see INVENTORY => 111 software found and INVENTORY => XML Update 112 Software but on server no data by this computer. How debug this issue?

charleneauger commented 3 years ago

Hi @nohnaimer ,

Do you have any error in your apache error_log file on your server ?

Regards, Charlene Auger

nohnaimer commented 3 years ago

Only this errors:

can't find ANONSUB's 'anon15' entry.
can't find ANONSUB's 'anon18' entry.
can't find ANONSUB's 'anon27' entry.
can't find ANONSUB's 'anon27' entry.
can't find ANONSUB's 'anon9' entry.
can't find ANONSUB's 'anon32' entry.
can't find ANONSUB's 'anon6' entry.
can't find ANONSUB's 'anon6' entry.
can't find ANONSUB's 'anon6' entry.
can't find ANONSUB's 'anon22' entry.
can't find ANONSUB's 'anon302' entry.
can't find ANONSUB's 'anon25' entry.
can't find ANONSUB's 'anon16' entry.
can't find ANONSUB's 'anon10' entry.
can't find ANONSUB's 'anon40' entry.
can't find ANONSUB's 'anon9' entry.
can't find ANONSUB's 'anon42' entry.
can't find ANONSUB's 'anon528' entry.
can't find ANONSUB's 'anon2' entry.
can't find ANONSUB's 'anon25' entry.
can't find ANONSUB's 'anon16' entry.
can't find ANONSUB's 'anon25' entry.
can't find ANONSUB's 'anon12' entry.
can't find ANONSUB's 'anon17' entry.
can't find ANONSUB's 'anon42' entry.
can't find ANONSUB's 'anon9' entry.
can't find ANONSUB's 'anon13' entry.
can't find ANONSUB's 'anon8' entry.
can't find ANONSUB's 'anon13' entry.
can't find ANONSUB's 'anon14' entry.
can't find ANONSUB's 'anon37' entry.
can't find ANONSUB's 'anon138' entry.
can't find ANONSUB's 'anon22' entry.
can't find ANONSUB's 'anon21' entry.
can't find ANONSUB's 'anon11' entry.
can't find ANONSUB's 'anon8' entry.
[Thu Apr 01 08:22:53.323919 2021] [core:notice] [pid 818:tid 140511627671872] AH00052: child pid 3082602 exit signal Segmentation fault (11)
can't find ANONSUB's 'anon12' entry.
can't find ANONSUB's 'anon38' entry.
can't find ANONSUB's 'anon22' entry.
can't find ANONSUB's 'anon13' entry.
can't find ANONSUB's 'anon9' entry.
can't find ANONSUB's 'anon4' entry.
[Thu Apr 01 08:26:55.651976 2021] [core:notice] [pid 818:tid 140511627671872] AH00052: child pid 3083011 exit signal Segmentation fault (11)
can't find ANONSUB's 'anon10' entry.
can't find ANONSUB's 'anon11' entry.
can't find ANONSUB's 'anon2' entry.
can't find ANONSUB's 'anon6' entry.
can't find ANONSUB's 'anon45' entry.
[Thu Apr 01 08:29:19.866991 2021] [core:notice] [pid 818:tid 140511627671872] AH00052: child pid 3083345 exit signal Segmentation fault (11)
can't find ANONSUB's 'anon12' entry.
can't find ANONSUB's 'anon16' entry.
can't find ANONSUB's 'anon3' entry.
can't find ANONSUB's 'anon7' entry.
can't find ANONSUB's 'anon21' entry.
can't find ANONSUB's 'anon14' entry.
can't find ANONSUB's 'anon12' entry.
can't find ANONSUB's 'anon32' entry.
can't find ANONSUB's 'anon21' entry.
can't find ANONSUB's 'anon36' entry.
can't find ANONSUB's 'anon17' entry.
can't find ANONSUB's 'anon40' entry.
can't find ANONSUB's 'anon13' entry.
can't find ANONSUB's 'anon287' entry.
can't find ANONSUB's 'anon60' entry.
can't find ANONSUB's 'anon21' entry.
[Thu Apr 01 08:39:15.714728 2021] [core:notice] [pid 818:tid 140511627671872] AH00052: child pid 3084435 exit signal Segmentation fault (11)
can't find ANONSUB's 'anon7' entry.
can't find ANONSUB's 'anon18' entry.
can't find ANONSUB's 'anon29' entry.
can't find ANONSUB's 'anon19' entry.
can't find ANONSUB's 'anon17' entry.
can't find ANONSUB's 'anon31' entry.
can't find ANONSUB's 'anon11' entry.
can't find ANONSUB's 'anon14' entry.
can't find ANONSUB's 'anon39' entry.
can't find ANONSUB's 'anon40' entry.
can't find ANONSUB's 'anon10' entry.
[Thu Apr 01 08:45:26.214459 2021] [core:notice] [pid 818:tid 140511627671872] AH00052: child pid 3085119 exit signal Segmentation fault (11)
can't find ANONSUB's 'anon37' entry.
can't find ANONSUB's 'anon22' entry.
can't find ANONSUB's 'anon91' entry.
can't find ANONSUB's 'anon4' entry.
can't find ANONSUB's 'anon50' entry.
can't find ANONSUB's 'anon29' entry.
can't find ANONSUB's 'anon7' entry.
can't find ANONSUB's 'anon4' entry.

In activity.log only this errors:

Wed Mar 31 13:23:34 2021;2982637;104;M1AUTO99V-2021-03-31-13-22-44;10.128.217.28;OCS-NG_WINDOWS_AGENT_v2.8.0.1;snmp;error: agent must have a deviceid in database !!
Wed Mar 31 13:24:07 2021;2996022;517;M1AUTO99V-2021-03-31-13-22-44;10.128.217.28;OCS-NG_WINDOWS_AGENT_v2.8.0.1;duplicate;replacing_error
Wed Mar 31 13:24:07 2021;2996022;517;M1AUTO99V-2021-03-31-13-22-44;10.128.217.28;OCS-NG_WINDOWS_AGENT_v2.8.0.1;duplicate;replacing_error
nohnaimer commented 3 years ago

Fixed this error:

DBD::mysql::st execute failed: Duplicate entry '2147483647' for key 'software.PRIMARY' at /usr/share/perl5/vendor_perl/Apache/Ocsinventory/Server/Inventory/Software.pm line 59.

Change software ID from int to bigint. Now software works.