Inventory not updating [closed]

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. Below prints of the situation

In LOG, i'm getting the following error:

Wed May  8 03:36:59 2024;799775;521;NA;10.10.5.71;OCS-NG_WINDOWS_AGENT_v2.9.2.0;database_connect;Access denied for user 'ocs'@'localhost' (using password: >Wed May  8 03:36:59 2024;799775;505;NA;10.10.5.71;OCS-NG_WINDOWS_AGENT_v2.9.2.0;handler;Database connection

SQL SERVER:

At the moment, it worked with no problem, i never changed the password of the system.

Ubuntu 20.04.6 LTS

Answer 1

I change password for ocs user:

ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here';

FLUSH PRIVILEGES;

and it's works!

The new password is different from the root password.

Changing the password to the default: "ocs" solves the problem. When I changed the password to one that is not default, the problem occurs.

I think that starting the agent does not use the z-.....conf and zz-....conf files because the agent works when the username and password are different in the configuration files and different in the database.

database:

- ocs, ocsuser

z-ocsinventory-server.conf

- ocsuser

zz-ocsinventory-restapi.conf

- ocsuser

When the ocs user - for the database has a default password (ocs) the agent works. When I change the password of the ocs user in the database, the agent does not work.

I do not know why this is happening.

Answer 2

file /etc/apache2/sites-enabled/z-ocsinventory-server.conf
has ocs and ocs

I changed the password in the file and it works!