SNMP Credentials Issue

[DYKenoby]

After upgrade GLPI 9.5 to GLPI 10.
Unable to normally assosiate snmp credential with ip range.

After click assosiate button empty record appeared and Error in _log/php-errors.log

`[2022-05-11 19:14:04] glpiphplog.WARNING:   *** PHP Warning (2): Undefined array key "snmpcredentials_id" in /var/www/glpi/marketplace/glpiinventory/inc/iprange_snmpcredential.class.php at line 164
  Backtrace :
  ...entory/inc/iprange_snmpcredential.class.php:114 PluginGlpiinventoryIPRange_SNMPCredential->showItemForm()
  src/CommonGLPI.php:687                             PluginGlpiinventoryIPRange_SNMPCredential::displayTabContentForItem()
  ajax/common.tabs.php:107                           CommonGLPI::displayStandardTab()

[2022-05-11 19:14:04] glpiphplog.WARNING:   *** PHP Warning (2): Undefined array key "snmpcredentials_id" in /var/www/glpi/marketplace/glpiinventory/inc/iprange_snmpcredential.class.php at line 164
  Backtrace :
  ...entory/inc/iprange_snmpcredential.class.php:114 PluginGlpiinventoryIPRange_SNMPCredential->showItemForm()
  src/CommonGLPI.php:687                             PluginGlpiinventoryIPRange_SNMPCredential::displayTabContentForItem()
  ajax/common.tabs.php:107                           CommonGLPI::displayStandardTab()

[2022-05-11 19:14:04] glpiphplog.WARNING:   *** PHP Warning (2): Undefined array key "snmpcredentials_id" in /var/www/glpi/marketplace/glpiinventory/inc/iprange_snmpcredential.class.php at line 221
  Backtrace :
  ...entory/inc/iprange_snmpcredential.class.php:114 PluginGlpiinventoryIPRange_SNMPCredential->showItemForm()
  src/CommonGLPI.php:687                             PluginGlpiinventoryIPRange_SNMPCredential::displayTabContentForItem()
  ajax/common.tabs.php:107                           CommonGLPI::displayStandardTab()

[2022-05-11 19:14:04] glpiphplog.WARNING:   *** PHP Warning (2): Undefined array key "snmpversion" in /var/www/glpi/src/SNMPCredential.php at line 100
  Backtrace :
  ...entory/inc/iprange_snmpcredential.class.php:225 SNMPCredential->getRealVersion()
  ...entory/inc/iprange_snmpcredential.class.php:114 PluginGlpiinventoryIPRange_SNMPCredential->showItemForm()
  src/CommonGLPI.php:687                             PluginGlpiinventoryIPRange_SNMPCredential::displayTabContentForItem()
  ajax/common.tabs.php:107                           CommonGLPI::displayStandardTab()

[2022-05-11 19:14:04] glpiphplog.WARNING:   *** PHP Warning (2): Undefined array key "snmpcredentials_id" in /var/www/glpi/marketplace/glpiinventory/inc/iprange_snmpcredential.class.php at line 221
  Backtrace :
  ...entory/inc/iprange_snmpcredential.class.php:114 PluginGlpiinventoryIPRange_SNMPCredential->showItemForm()
  src/CommonGLPI.php:687                             PluginGlpiinventoryIPRange_SNMPCredential::displayTabContentForItem()
  ajax/common.tabs.php:107                           CommonGLPI::displayStandardTab()

[2022-05-11 19:14:04] glpiphplog.WARNING:   *** PHP Warning (2): Undefined array key "snmpversion" in /var/www/glpi/src/SNMPCredential.php at line 100
  Backtrace :
  ...entory/inc/iprange_snmpcredential.class.php:225 SNMPCredential->getRealVersion()
  ...entory/inc/iprange_snmpcredential.class.php:114 PluginGlpiinventoryIPRange_SNMPCredential->showItemForm()
  src/CommonGLPI.php:687                             PluginGlpiinventoryIPRange_SNMPCredential::displayTabContentForItem()
  ajax/common.tabs.php:107                           CommonGLPI::displayStandardTab()`

[steph461]

add user SNMP for exmample or create user snmp. Delete blank user

bug migration maybe

[DYKenoby]

Good day, and thanks for your answer.
Unfortunatelly result the same:

[trasher]

You probably had an issue during plugin migration. Restore your database, play the migration again; and check logs at this time.

[DYKenoby]

Good day.
I found issue, it's look like sql table was not updated during migration...
I performed migration once again on backup image of 9.5 version with the same result.
Then i made clean installation of glpi 10 on new VM, then i found difference in sql database:
Colum in table "glpi_plugin_glpiinventory_ipranges_snmpcredentials" had old name "plugin_glpiinventory_configsecurities_id" in clean version it is "snmpcredentials_id" so i renamed it:

ALTER TABLE `glpi_plugin_glpiinventory_ipranges_snmpcredentials` CHANGE `plugin_glpiinventory_configsecurities_id` `snmpcredentials_id` INT(10) UNSIGNED NOT NULL DEFAULT '0';

Then new credentials added sucessfully.

[brunnersm]

@DYKenoby thanks for the solution!

[stonebuzz]

I do not reproduce ATM

Maybe an inconsistency database.

I close this issue

feel free to reopen if needed

Best regards