search

OCSInventory-NG / OCSInventory-Server

Communication server of OCS Inventory
http://www.ocsinventory-ng.org/
GNU General Public License v2.0
344 stars 139 forks source link

Typo related to OCS_inventory.DEVICE in Inventory.pm? #342

Closed TheFiZi closed 1 year ago

TheFiZi commented 3 years ago

General informations

Operating system : CentOS Linux release 7.9.2009 (Core)

Server informations

Perl version : v5.16.3 Mysql / Mariadb / Percona version : 5.5.68-MariaDB

OCS Inventory informations

Ocs server version : 2.9.1

Problem's description

I do not know if this was happening before but since upgrading to OCS 2.9.1 we are seeing this MySQL error in our logs:

DBD::mysql::st execute failed: Table 'OCS_inventory.DEVICE' doesn't exist at /usr/local/share/perl5/Apache/Ocsinventory/Server/Capacities/Snmp/Inventory.pm line 146.

It is happening randomly and not constantly. Checking the MySQL database I think there might be a typo and it should be OCS_inventory.DEVICES and not OCS_inventory.DEVICE?

Or do I need to rename that table?

charleneauger commented 1 year ago

Hi @TheFiZi ,

This error is related to the old snmp scan feature. I think you have some old agents using snmp scan.

Be sure to disable SNMP scanning for UNIX agents below version 2.8.1 or update them to a newer version.

Best regards, Charlene

TheFiZi commented 1 year ago

Alright. Thank you.