Hullo together,
OCS possibly maybe a great tool, but... for me it doesn't work... And after a few days of research, there's no idea where it is stucked...
Apache? Runs and works well.
mysql? Runs and works well.
OCS - Server? Runs and works well.
Agents? Runs on Windows/Linux/Android... but Server doesn't receive any data, or the database, for what reason ever, doesn't collect and write it down... :(
Where else can I search for errors? Please give me a hint.
Here the collected data for U. So U can see there is no error or what ever blocked the data to write down into database...
- PHP-Version : 7.3.11
Webserver : Apache/2.4.38 (Debian)
Datenbank-Server : Debian 10 version 10.3.22-MariaDB-0+deb10u1
Version OCSReports: 2.6
- BS-Name : Linux x86_64
- Version : 4.19.0-8-amd64
- Installierter Speicher : 16042 MB
- Freier Speicher : 15192 MB
- Prozessor : Intel(R) Xeon(R) Gold 5118 CPU @ 2.30GHz
- Distribution : Debian GNU/Linux 10 (buster)
- root@debcmdb:~# uname -a
Linux debcmdb 4.19.0-8-amd64 #1 SMP Debian 4.19.98-1 (2020-01-26) x86_64 GNU/Linux
<code>
root@debcmdb:~# uname -a
Linux debcmdb 4.19.0-8-amd64 #1 SMP Debian 4.19.98-1 (2020-01-26) x86_64 GNU/Linux
root@debcmdb:~# netstat -tlnp
Aktive Internetverbindungen (Nur Server)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 10839/mysqld
tcp 0 0 127.0.0.1:11211 0.0.0.0:* LISTEN 476/memcached
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 10706/apache2
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 674/sshd
tcp6 0 0 :::22 :::* LISTEN 674/sshd
tcp6 0 0 :::6556 :::* LISTEN 1/init
root@debcmdb:~# curl localhost:3306
Warning: Binary output can mess up your terminal. Use "--output -" to tell
Warning: curl to output it to your terminal anyway, or consider "--output
Warning: <FILE>" to save to a file.
root@debcmdb:~# tail -f /var/log/mysql/error.log
2020-02-14 12:55:08 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-02-14 12:55:08 0 [Note] InnoDB: 10.3.22 started; log sequence number 132703983; transaction id 241898
2020-02-14 12:55:08 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-02-14 12:55:08 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-02-14 12:55:08 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-02-14 12:55:08 0 [Note] Reading of all Master_info entries succeeded
2020-02-14 12:55:08 0 [Note] Added new Master_info '' to hash table
2020-02-14 12:55:08 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.22-MariaDB-0+deb10u1' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 10
2020-02-14 12:55:10 0 [Note] InnoDB: Buffer pool(s) load completed at 200214 12:55:10
cat /var/log/apache2/access.log | grep -i agent
172.17.1.166 - - [14/Feb/2020:12:33:26 +0100] "POST /ocsinventory HTTP/1.1" 200 12847 "-" "OCS-NG_WINDOWS_AGENT_v2.6.0.0"
172.17.0.58 - - [14/Feb/2020:12:33:35 +0100] "POST /ocsinventory HTTP/1.1" 200 12903 "-" "OCS-NG_unified_unix_agent_v2.4.2"
172.17.1.70 - - [14/Feb/2020:12:33:45 +0100] "POST /ocsinventory HTTP/1.1" 200 12903 "-" "OCS-NG_Android_agent_v2.3.1"
root@debcmdb:~# cat /var/log/apache2/error.log
[Fri Feb 14 12:38:49.061593 2020] [mpm_prefork:notice] [pid 11931] AH00163: Apache/2.4.38 (Debian) mod_fcgid/2.3.9 mod_perl/2.0.10 Perl/v5.28.1 configured -- resuming normal operations
[Fri Feb 14 12:38:49.061666 2020] [core:notice] [pid 11931] AH00094: Command line: '/usr/sbin/apache2'
AGENTS:
Linux-agent, running in same environment like the OCS server himself:
root@debcmdb:~# cat /etc/ocsinventory/ocsinventory-agent.cfg
server=http://localhost/ocsinventory
SSL=0
Windows-Agent (gave him credentials to check if that is the fault... it doesn't...):
ocsinvetory.ini:
[OCS Inventory Agent]
ComProvider=ComHTTP.dll
Debug=1
Local=
NoSoftware=0
HKCU=0
NoTAG=0
IpDisc=
[HTTP]
Server=http://172.17.0.58:80/ocsinventory
SSL=0
CaBundle=cacert.pem
AuthRequired=0
User=p7Nd9LFb+sEhPNvnnhEa9A==|||TISI7P//C6P8Jdu2v2l4qg==
Pwd=kVjNWMBhN2PN6hrE2QuzEw==|||QHYmXnxK4pRPkLWu1s9kdw==
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=35580
OCSInventory.log (an example with full of datas):
==============================================================================
Starting OCS Inventory NG Agent on Friday, February 14, 2020 08:00:42.
AGENT => Running OCS Inventory NG Agent Version 2.6.0.0
AGENT => Using OCS Inventory NG FrameWork Version 2.6.0.0
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 NG cURL Communication Provider> Version <2.6.0.0>
AGENT => Sending Prolog
DID_CHECK => Read DeviceID <KEGLAP057-2020-01-30-09-30-16> and MACs <00:Ejhfdjhdhjdjhdjhd0:B6:A5:D3:84> 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://172.17.0.58:80/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 10 hour(s)
AGENT => Inventory on startup option set to
AGENT => Inventory change forced by /NOTIFY option
AGENT => Launching hardware and software checks
INVENTORY => Logged on user ID is <go>
INVENTORY => Operating System is <Microsoft Windows 10 Pro 10.0.18363 >, description <>
INVENTORY => Operating System uses 64 bits memory address width
INVENTORY => Computer domain or workgroup is <XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX>
INVENTORY => User domain is <>
INVENTORY => System Manufacturer <LENOVO>, System Model <20KF001GGE>, System S/N <PC10EJFX>, Bios Manufacturer <LENOVO>, Bios Date <20/11/2019>, Bios Version <N20ET50W
.
.
.
INVENTORY => Reading last inventory state
AGENT => Sending Inventory
.
.
.
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://172.17.0.58:80/ocsinventory>
COM SERVER => HTTP Post response received <HTTP Status Code #200>
COM SERVER => Cleaning cURL library
AGENT => Inventory successfully sent
INVENTORY => Writing new inventory state
AGENT => Unloading communication provider
AGENT => Unloading plug-in(s)
AGENT => Execution duration: 00:00:05.
</code>
