Update database

Question

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?

Answer 1

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.

Answer 2

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

Answer 3

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

Answer 4

[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