ocsinventoryng icon indicating copy to clipboard operation
ocsinventoryng copied to clipboard

SNMP database dropped

Open blippercop opened this issue 2 years ago • 1 comments

  *** MySQL query error:
  SQL: SELECT DISTINCT `snmp`.`ID`
                  FROM `snmp`, `snmp_accountinfo`
                        WHERE `snmp`.`SNMPDEVICEID` NOT LIKE '\_%'
                        AND `snmp`.`ID` = `snmp_accountinfo`.`SNMP_ID`  AND `snmp`.`ID` NOT IN (16,15,14,13,2,1,24,25,23,22,21,20,19,18,17,12,10,9)
  Error: Table 'ocsweb.snmp' doesn't exist
  Backtrace :
  ...s/ocsinventoryng/inc/ocsdbclient.class.php:1543
  ...s/ocsinventoryng/inc/snmpocslink.class.php:2283 PluginOcsinventoryngOcsDbClient->getSnmp()
  ...s/ocsinventoryng/front/ocsngsnmp.import.php:127 PluginOcsinventoryngSnmpOcslink::showSnmpDeviceToAdd()
  {"user":"1@server"}

Table snmp doesnt exists anymore in OCS: https://github.com/OCSInventory-NG/OCSInventory-ocsreports/blob/master/files/update/7054.sql

OCS Inventory NG ocsinventoryng 2.0.1

blippercop avatar Jun 29 '22 12:06 blippercop

Same case, I can't import inventory SNMP to GLPI

imagen

GLPI 10.0.3 PHP 8.1 MySQL 8.0.30 CentOS 7.9

cmoreno038 avatar Oct 01 '22 00:10 cmoreno038