Error Last Inventory and HTTP Status Code # 500

Question

Hello

I have a problem with Ocsinventory Server 2.5. (Apache 2.4.25, Mariadb 10.1.26, PHP 7.0.30, Debian 9.1)

The last inventory field no longer updates, while the last contact field yes.
The error appeared between this morning and tonight without any change on the server. I tested my connection to the data bse that works perfectly.
I have the following error:
DBD :: mysql :: st execute failed: Out of range value for column 'ID' at row 1 at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Server/Inventory/Update.pm line 165.
On the clients I have the error:
ERROR *** AGENT => Failed to send Inventory <HTTP Status Code # 500>

Possible database problem?

Thanks for your help

Answer 1

Hi,

To correct the problem you have to change id column of table "softwares" from int to bigint. I have one question : do you delete machines (and their softwares associated) that are not more inventoried? Actually this feature is not implemented yet but we are working on it.

Regards

Frank

Answer 2

Verify archive  z-ocsinventory-server.conf in the apache

Answer 3

This file is correct. Parameters are ok.

Answer 4

please search for the number 2147483647 in the whole Database.
use adimer to do this

https://www.adminer.org/en/
2147483647 ist the biggest value a signed int field can store.
It can happen that a int field overflows. Change the type to bigint.

Now you should be able to use OCS Inventory without problems (hopefully)

Answer 5

Thank you very much it works.
Indeed we delete machines when we remove them from the inventory but we never delete linked software.

Answer 6

/Quote Frank

do you delete machines (and their softwares associated) that are not more inventoried? Actually this feature is not implemented yet but we are working on it.

/quote off

please do not implement a autodelete if we can't manually steer it.

For us even a very old computer which never inventoried for years are important for the following reasons.

1. We have offline PC's - which are used - but they should not contact the internet or even ocs-inventory for security reasons

2. computers which are thrown away should also beeing searchable. so even after years we can say - the old computer has the following software or bios ans so forth

kind regards sokatra