Inventory not updating on last inventory

Question

Hello,

I noticed that my inventory updates are not working as normal. I tried to run manually the OCS Agent on a windows computer, but doesn't update that list. My server is running on Unix.

Answer 1

BEFORE asking, you SHOULD search in log files(agent and server), verify if Apache is running, ...

Answer 2

Hi @jacquesh.

In the log, there is this message, plenty of times:

Mon Apr  8 08:48:53 2024;1473840;521;NA;172.14.2.30;OCS-NG_WINDOWS_AGENT_v2.9.2.0;database_connect;Access denied for user 'ocs'@'localhost' (using password: YES)

Mon Apr  8 08:48:53 2024;1473840;505;NA;172.14.2.30;OCS-NG_WINDOWS_AGENT_v2.9.2.0;handler;Database connection

Mon Apr  8 08:49:45 2024;1480938;521;NA;172.14.2.170;OCS-NG_WINDOWS_AGENT_v2.9.0.0;database_connect;Access denied for user 'ocs'@'localhost' (using password: YES)

Mon Apr  8 08:49:45 2024;1480938;505;NA;172.14.2.170;OCS-NG_WINDOWS_AGENT_v2.9.0.0;handler;Database connection

Answer 3

(This log is 'activity.log', the main log file on OCS server).

So, the reason is easy, now, to find : it's an access problem to MySQL or MySQL isn't running ...or there is not enough dataspace ...

Answer 4

I checked my SQL and hardrives, seems to be OK

Maybe could be something in z-ocsinventory-server.conf and dbconfig.inc.php files?

Observation: i already have 99 computers on OCS, is there an limitation?

Answer 5

I note you've checked 'activity.log' : it's OCS log for /ocsinventory, so error are in a file you ask for (my first idea).

There is no limitation in hardware count : I've worked in a company with 14.000 hardware !