Failed to send Prolog <#500> after drop user ocs

Question

Error uploading inventory to server.
ERROR *** AGENT => Failed to send Prolog <HTTP Status Code #500>

Problem started after creating new DB user and dropping user ocs@localhost following info from http://ask.ocsinventory-ng.org/6797/how-to-change-user-password-and-fix-error

Renaming info seems to be complete for website (<webserver>/ocsreports) but incomplete for inventory (<webserver>/ocsinventory)

When sending an inventory from client an error is logged in /var/log/httpd for every inventory upload from the client: DBI connect('database=ocs;host=localhost;port=3306','ocs',...) failed: Access denied for user 'ocs'@'localhost' (using password: YES) at /usr/local/share/perl5/Apache/Ocsinventory/Server/System.pm line 187

I couldn't find where user ocs is defined/called. Must be a .php or .pm used for adding inventory to the DB that is using wrong (hard coded?) credentials or some kind of mix-up in vars (OCS_DB_NAME vs OCS_DB_USER?)

For now recreated user ocs with non-default password. That's working fine. But would be nice if manual for renaming user is checked.

Answer 1

Hi

You have to change the password in z-ocsinventory-server.conf file, then restart apache after.

Best regards

Frank

Answer 2

Hi Frank,

find / -name z-ocs* -print
/etc/httpd/conf.d/z-ocsinventory-server.conf

Settings in z-ocsinventory-server.conf

  PerlSetEnv OCS_DB_USER myuser
  PerlSetVar OCS_DB_PWD myuser_password

If user ocs is missing in DB then error
DBI connect('database=ocs;host=localhost;port=3306','ocs',...) failed: Access denied for user 'ocs'@'localhost' (using password: YES) at /usr/local/share/perl5/Apache/Ocsinventory/Server/System.pm line 187

So, var "PerlSetEnv OCS_DB_USER myuser" is not effective for some reason.

Restarted httpd service and also restarted the complete server. Error stays the same.

Comments

try to stop and start apache. Sometimes, restart don't reload all files.

Answer 3

Even a complete restart of the server was no solution.