update 2.8.1 , AGENT => Failed to send Prolog [closed]

Question

Hello Team,

      when we upgraded the server version (2.7--2.8.1), we found only five clients can upload the  computer inventory information to  the server , other clients all 500 error :(

      COM SERVER => Sending HTTP Post request to URL <http://server/ocsinventory>

COM SERVER => HTTP Post response received <HTTP Status Code #500>

COM SERVER => Cleaning cURL library

        ERROR *** AGENT => Failed to send Inventory <HTTP Status Code #500>

         AGENT =>  Communication Server asked for Package Download

and http error log:

       2211  DBD::mysql::db do failed: Unknown column 'NAME' in 'field list' at /usr/local/share/perl5/Apache/Ocsinventory/Server/Inventory/Cache.pm line 79.

  2212  DBD::mysql::db do failed: Duplicate entry '4662' for key 'PRIMARY' at /usr/local/share/perl5/Apache/Ocsinventory/Server/Inventory/Update/AccountInfos.pm line 66.

  2213  DBD::mysql::st execute failed: Unknown column 'NAME' in 'field list' at /usr/local/share/perl5/Apache/Ocsinventory/Server/Inventory/Update.pm line 159.

  2214  DBD::mysql::db do failed: Unknown column 'NAME' in 'field list' at /usr/local/share/perl5/Apache/Ocsinventory/Server/Inventory/Cache.pm line 79.

  2215  DBD::mysql::st execute failed: Unknown column 'NAME' in 'field list' at /usr/local/share/perl5/Apache/Ocsinventory/Server/Inventory/Update.pm line 159.

  2216  [Fri Jan 13 12:52:52.896580 2023] [mpm_prefork:notice] [pid 21439] AH00170: caught SIGWINCH, shutting down gracefully

Answer 1

When you upgrade a server, you need

- upgrade the server (/ocsinventory and all Perl service),

- upgrade the database structure (usually using web) : look at GUI_VERSION in table 'config'.

So you have a problem : you change the Perl service and the database is NOT at the good level before upgrade !

When I do this, I stop Apache and I upgrade MYSELF the database structure : you need to execute all SQL scripts in /files/update from GUI_VERSION+1  up to last .sql. After upgrade OCS server, as a configured file is changed, ALLWAYS you need to act again error 500 with an elementary operation (you have enough about error 500 here ...) : enough for me these error 500 !

Answer 2

I checked the DB and found miss some software tables ,executed the sql script .

Now , it works fine.

Thanks!