Forum GLPI-Project

romnvll

Member

Registered: 2009-10-20

Posts: 46

Inventaire SNMP switchs

Bonjour à tous .

j'ai des switchs qui ont été découvert par fusion inventory .

quand je passe le plugin NetInventory .

Sur mon agent qui fait l'inventaire, j'ai cette erreur dans les logs :

[Fri Oct 20 11:55:15 2023][info] running task NetInventory
[Fri Oct 20 11:55:21 2023][error] [http server] unknown path: %1E%EA%F9%E0%D6e%C2p%03%CE%DE
[Fri Oct 20 11:55:22 2023][error] [http server] unknown path: h%99%0F%BA(
[Fri Oct 20 11:55:46 2023][error] [thread 5] #1, [http client] communication error: 500 Internal Server Error
[Fri Oct 20 11:56:16 2023][error] [thread 5] #2, [http client] communication error: 500 Internal Server Error

et coté serveur, ça se complique !
[Fri Oct 20 11:55:46.718106 2023] [php:error] [pid 2918980] [client 192.168.15.24:54361] PHP Fatal error:  Error preparing query INSERT INTO `glpi_networkports_vlans` (`networkports_id`, `vlans_id`, `tagged`) VALUES (?, ?, ?) in /var/www/html/glpi/src/Inventory/Asset/NetworkPort.php on line 526
[Fri Oct 20 11:56:16.734643 2023] [php:error] [pid 2919109] [client 192.168.15.24:54409] PHP Fatal error:  Error preparing query INSERT INTO `glpi_networkports_vlans` (`networkports_id`, `vlans_id`, `tagged`) VALUES (?, ?, ?) in /var/www/html/glpi/src/Inventory/Asset/NetworkPort.php on line 526

glpisqllog.ERROR: DBmysql::prepare() in /var/www/html/glpi/src/DBmysql.php line 465
  *** MySQL prepare error:
  SQL: INSERT INTO `glpi_networkports_vlans` (`networkports_id`, `vlans_id`, `tagged`) VALUES (?, ?, ?)
  Error: Unknown column 'tagged' in 'field list'
  Backtrace :

Quelqu'un à deja eu ce problme ?

Bonne journée.

Cordialement

romnvll

Member

Registered: 2009-10-20

Posts: 46

Re: Inventaire SNMP switchs

il me manquait un champ dans ma BDD, alors pourquoi ??

je l'ai ajouté :
ALTER TABLE `glpi_networkports_vlans` ADD `tagged` TINYINT(10) NOT NULL DEFAULT 0;

est ce que c'est le bon type ? this is the question ^^

homebrewtainy

Member

Registered: 2020-04-04

Posts: 151

Re: Inventaire SNMP switchs

re Bonjour romnvll :-)

Confère : \glpi-10.0.10\glpi\install\mysql\glpi-empty.sql

Tu trouveras ton bonheur.

### Dump table glpi_networkports_vlans

DROP TABLE IF EXISTS `glpi_networkports_vlans`;
CREATE TABLE `glpi_networkports_vlans` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `networkports_id` int unsigned NOT NULL DEFAULT '0',
  `vlans_id` int unsigned NOT NULL DEFAULT '0',
  `tagged` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`networkports_id`,`vlans_id`),
  KEY `vlans_id` (`vlans_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

Cordialement.

---

Creuser, creuser... creuser.
GLPI 10.0.16 [ Linux el 9.4 | Apache/2.4.xx | mysql 15.1 MariaDB 10.5.xx | PHP 8.3.x ] - Apache HTTPS r-proxy [ Linux el 9.4 | Apache/2.4.xx ]
GLPI Inventory 1.3.5 | Data Injection 2.13.5 | Treeview (Arborescence) 1.10.2 | Behaviors (Comportements) 2.7.3
-- Any exchange not written in French comes from an automatic translation. --