pluginsGLPI / ocsinventoryng

Plugin ocsinventoryng for GLPI
GNU General Public License v2.0
68 stars 52 forks source link

SNMP database dropped #324

Open blippercop opened 2 years ago

blippercop commented 2 years ago
  *** 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
cmoreno038 commented 1 year ago

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