Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.8 available

The official documentation can be found on http://wiki.ocsinventory-ng.org. Read it before asking your question.

ERROR: HTTP status code 500

Hi all

when my agent want to contact the ocs server 2.5, I have this error in the log :

HTTP SERVER: Sending prolog query...ERROR: HTTP status code 500

I tried to change any values on config files, replace name by ip, verify id/pw, but this problem is always present ...

on error.log apache2, I have :

Can't call method "rollback" on an undefined value
at /usr/share/perl5/Apache/Ocsinventory/Server/System.pm line 282 \n
DBI connect

failed: Access denied for user 'ocs'@'localhost' (using password: YES) at /usr/share/perl5/Apache/Ocsinventory/Server/System.pm line 187

could you help me please

thanks

in OCS Inventory NG agent for Unix by (200 points)

2 Answers

0 votes
maybe because i'm in mysql 8.0 ? :/

but i can't reinstall all

And I can me connect normaly to http://localhost/ocsreports/index.php
by (200 points)
edited by
0 votes

I think to have repaired the problem, le problem was the pass in ocsinventory-server.conf file ...

other problem, after the agent contact, I have in apache2 error.log, otherthing

DBD::mysql::db
do failed: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' at
/usr/share/perl5/Apache/Ocsinventory/Server/System.pm line 193. DBD::mysql::st execute failed: You have an error
in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
near 'groups
    g LEFT OUTER JOIN locks l
    ON l.HARDWARE_ID=g.HARDWARE_ID
    WHE' at line 2 at /usr/share/perl5/Apache/Ocsinventory/Server/Groups.pm line 72.
DBD::mysql::db do failed: Out of range value for column 'QUALITY' at row 1 at /usr/share/perl5/Apache/Ocsinventory/Serv>
[Thu Apr 29 14:38:48] [mpm_prefork:notice] [pid 2542] AH00169: caught SIGTERM, shutting down

xml seems ok but not send :

    XML Update Storage Peripherals: OK (1 objects).
    XML Update System Controllers...
    XML Update System Controllers: OK (5 objects).
    XML Update System Slots...
    XML Update System Slots: OK (7 objects).
    XML Update Video Adapters...
    XML Update Video Adapters: OK (1 objects).
XML Update Device properties: OK.
WMI Disconnect: Disconnected from WMI namespace.
HTTP SERVER: Creating CInternetSession to send inventory results...OK.
HTTP SERVER: Getting HTTP Connection to server ip port 80 using no authentication...OK
HTTP SERVER: INV : SEND received, sending inventory...ERROR: HTTP status code 500
OK.
HTTP SERVER: INV : ERROR : No server answer concerning the account update

by (200 points)
edited by
 
Powered by Question2Answer
...