[BUG] Error 500 on import about ocsinventory-ocsreports HOT 6 OPEN

Hi,

Just to be sure, did you restart the apache service after changing the setting ?

Regards,
Gilles DUBOIS.

from ocsinventory-ocsreports.

Yes, I already try this.

from ocsinventory-ocsreports.

Same problem here.

I tried restarting apache2 - it didn't solve the problem;
I tried restarting my server where OCS Inventory is installed - it didn't help;
I also tried restarting the machine where the OCS Agent is installed - it didn't help;

from ocsinventory-ocsreports.

Hi,

Without logs from OCS_OPT_DBI_PRINT_ERROR won't be able to help much more.
If this setting doesn't work could you try to enable general query logs from mysql ? That way you'll see all queries that goes trought the SQL server before returning the 500.

500 errors on the agent are most of the time related to a datamodel mismatch.

Regards,
Gilles DUBOIS.

from ocsinventory-ocsreports.

Hello everyone, sorry for the delay and thanks for the DBI_PRINT_ERROR tip.

After that I realized that I had left the wrong server configuration, which was causing the error. So, I made the correction and everything worked correctly, at least for me.

Thank you ^^

from ocsinventory-ocsreports.

I'm facing the same problem here on a fresh installation using the same server and client versions as reported by @Parnoud.
No errors on error.log and OCS_OPT_DBI_PRINT_ERROR didn´t change anything.

Checking the mysql's log files I come to conclusion that the 500 errors are indeed caused by model mismatch. What I can't understand is why it is happening and why OCS_OPT_DBI_PRINT_ERROR does not report any error.

Regards,

Anderson

from ocsinventory-ocsreports.