Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.12.3 available

The official documentation can be found on http://wiki.ocsinventory-ng.org. Read it before asking your question.

Update database

Hello guys

I need to update my database with the latest structure.

Is there any command that can be executed so that OCS updates the structure of the tables so that it is correct?
in OCS Inventory NG server for Unix by (200 points)

4 Answers

0 votes
OCS Server is

- a database

- a 'Communication Server', set of perl scripts designed to receive inventory and update data in database

- a 'Administrative Console', set of php scripts designed to retrieve informations from database or configure the solution

The three components are totaly imbricated, so you CANNOT change database structure (to an upper version) WITHOUT changing others components.

The only action you can do is upgrade OCS Server. Please search in the wiki how to do it.
by (19.8k points)
0 votes

I have updated to version 2.9.2 and the problem I have is that it registers the equipment in the inventory but not its data

by (200 points)
0 votes
You need to verify

- logs files for apache -> /var/log/apache2/access.log

- logs files for OCS -> /var/log/ocsinventory-server/activity.log  <- log receiving inventory

- tables from the database
by (19.8k points)
0 votes
[root@ocs]# tailf /var/log/httpd/access_log

Wed Jul 13 13:59:09 2022;15132;322;SCO-PL032-2021-09-29-13-16-10;192.168.1.132;OCS-NG_WINDOWS_AGENT_v2.3.1.1;notify;IP

Wed Jul 13 13:59:09 2022;15132;323;SCO-PL032-2021-09-29-13-16-10;192.168.1.132;OCS-NG_WINDOWS_AGENT_v2.3.1.1;notify;F4:6D:04:9F:18:14<192.168.1.132>

[root@ocs lib]# tailf /var/log/httpd/access_log

192.168.1.226 - - [13/Jul/2022:14:59:11 -0400] "POST /ocsinventory HTTP/1.1" 500 527 "-" "OCS-NG_WINDOWS_AGENT_v2.3.0.0"

192.168.1.226 - - [13/Jul/2022:15:01:09 -0400] "POST /ocsinventory HTTP/1.1" 200 235 "-" "OCS-NG_WINDOWS_AGENT_v2.3.0.0"

Sorry, I don't know what to compare the database tables against
by (200 points)
 
Powered by Question2Answer
...