search

glpi-project / glpi

GLPI is a Free Asset and IT Management Software package, Data center management, ITIL Service Desk, licenses tracking and software auditing.
https://glpi-project.org
GNU General Public License v3.0
4.26k stars 1.29k forks source link

10.0.3 - mysql DB errors #13094

Closed vollkommenIrrelevant closed 1 year ago

vollkommenIrrelevant commented 2 years ago

Code of Conduct

Is there an existing issue for this?

Version

1.0.3

Bug description

I have a lot errors in sql-errors.log. Is anybody having an Idea how to handle this errors?

Relevant log output

> [2022-10-27 16:01:51] glpisqllog.WARNING: DBmysql::query() in /var/www/glpi/src/DBmysql.php line 404
  *** MySQL query warnings:
  SQL: SELECT `glpi_peripherals`.`id`, `glpi_networkports`.`id` AS `portid` FROM `glpi_peripherals` LEFT JOIN `glpi_networkports` ON (`glpi_peripherals`.`id` = `glpi_networkports`.`items_id` AND `glpi_networkports`.`itemtype` = 'Peripheral') WHERE (`glpi_networkports`.`mac` IN ('e0:07:1b:4e:68:10')) AND (`glpi_networkports`.`logical_number` = 'E0-07-1B-4E-68-12')
  Warnings:
1292: Truncated incorrect DOUBLE value: 'E0-07-1B-4E-68-12'
  Backtrace :
  src/DBmysqlIterator.php:110
  src/DBmysql.php:1048                               DBmysqlIterator->execute()
  src/RuleImportAsset.php:538                        DBmysql->request()
  src/Rule.php:1649                                  RuleImportAsset->findWithGlobalCriteria()
  src/Rule.php:1507                                  Rule->checkCriterias()
  src/RuleCollection.php:1591                        Rule->process()
  src/Inventory/Asset/NetworkPort.php:251            RuleCollection->processAllRules()
  src/Inventory/Asset/NetworkPort.php:514            Glpi\Inventory\Asset\NetworkPort->handleLLDPConnection()
  src/Inventory/Asset/NetworkPort.php:538            Glpi\Inventory\Asset\NetworkPort->handleConnections()
  src/Inventory/Asset/NetworkPort.php:533            Glpi\Inventory\Asset\NetworkPort->portChanged()
  src/Inventory/Asset/InventoryNetworkPort.php:610   Glpi\Inventory\Asset\NetworkPort->portCreated()
  src/Inventory/Asset/InventoryNetworkPort.php:120   Glpi\Inventory\Asset\NetworkPort->handleCreates()
  src/Inventory/Asset/NetworkPort.php:690            Glpi\Inventory\Asset\NetworkPort->handlePortsTrait()
  src/Inventory/Asset/NetworkPort.php:523            Glpi\Inventory\Asset\NetworkPort->handlePorts()
  src/Inventory/Asset/MainAsset.php:834              Glpi\Inventory\Asset\NetworkPort->handle()
  src/Inventory/Asset/MainAsset.php:754              Glpi\Inventory\Asset\MainAsset->handleAssets()
  src/Inventory/Asset/NetworkEquipment.php:221       Glpi\Inventory\Asset\MainAsset->rulepassed()
  src/RuleImportAsset.php:946                        Glpi\Inventory\Asset\NetworkEquipment->rulepassed()
  src/Rule.php:1510                                  RuleImportAsset->executeActions()
  src/RuleCollection.php:1591                        Rule->process()
  src/Inventory/Asset/MainAsset.php:554              RuleCollection->processAllRules()
  src/Inventory/Inventory.php:701                    Glpi\Inventory\Asset\MainAsset->handle()
  src/Inventory/Inventory.php:336                    Glpi\Inventory\Inventory->handleItem()
  ...inc/communicationnetworkinventory.class.php:156 Glpi\Inventory\Inventory->doInventory()
  marketplace/glpiinventory/hook.php:1096            PluginGlpiinventoryCommunicationNetworkInventory->import()
  src/Plugin.php:1523                                plugin_glpiinventory_network_inventory()
  src/Inventory/Request.php:278                      Plugin::doHookFunction()
  src/Inventory/Request.php:250                      Glpi\Inventory\Request->network()
  src/Inventory/Request.php:98                       Glpi\Inventory\Request->networkInventory()
                                                                                                                                                                                           10911,3       99%

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

Informationen über das System, die Installation und die Konfiguration
GLPI 10.0.3 ( => /var/www/glpi)
Installation mode: TARBALL
Current language:de_DE
Server
 
Operating system: Linux glpi 5.4.0-131-generic #147-Ubuntu SMP Fri Oct 14 17:07:22 UTC 2022 x86_64
PHP 7.4.3 apache2handler (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apc, apcu, bcmath,
    bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml,
    mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, readline, session, shmop, sockets, sodium, standard, sysvmsg,
    sysvsem, sysvshm, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="600" memory_limit="1024M" post_max_size="32M" safe_mode="" session.save_handler="files"
    upload_max_filesize="32M" 
Software: Apache/2.4.41 (Ubuntu) (Apache/2.4.41 (Ubuntu) Server at X.Y.lu Port 80
)
    Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Firefox/102.0
Server Software: (Ubuntu)
    Server Version: 8.0.31-0ubuntu0.20.04.1
    Server SQL Mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
    Parameters: X@localhost/glpi
    Host info: Localhost via UNIX socket

PHP version (7.4.3) is supported.
Sessions configuration is OK.
Allocated memory is sufficient.
mysqli extension is installed.
Following extensions are installed: dom, fileinfo, json, simplexml.
curl extension is installed.
gd extension is installed.
intl extension is installed.
libxml extension is installed.
zlib extension is installed.
The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present.
Database engine version (8.0.31) is supported.
The log file could not be created in /var/www/glpi/files/_log.
Write access to /var/www/glpi/files/_cache has been validated.
Write access to /var/www/glpi/config has been validated.
Write access to /var/www/glpi/files/_cron has been validated.
Write access to /var/www/glpi/files has been validated.
Write access to /var/www/glpi/files/_dumps has been validated.
Write access to /var/www/glpi/files/_graphs has been validated.
Write access to /var/www/glpi/files/_lock has been validated.
Write access to /var/www/glpi/files/_pictures has been validated.
Write access to /var/www/glpi/files/_plugins has been validated.
Write access to /var/www/glpi/files/_rss has been validated.
Write access to /var/www/glpi/files/_sessions has been validated.
Write access to /var/www/glpi/files/_tmp has been validated.
Write access to /var/www/glpi/files/_uploads has been validated.
Web access to files directory is protected
PHP directive "session.cookie_httponly" should be set to "on" to prevent client-side script to access cookie values.
exif extension is installed.
ldap extension is installed.
openssl extension is installed.
zip extension is installed.
bz2 extension is installed.
Zend OPcache extension is installed.
Following extensions are installed: ctype, iconv, mbstring, sodium.
Write access to /var/www/glpi/marketplace has been validated.
Timezones seems loaded in database.
GLPI constants
 
GLPI_ROOT: /var/www/glpi
GLPI_CONFIG_DIR: /var/www/glpi/config
GLPI_VAR_DIR: /var/www/glpi/files
GLPI_MARKETPLACE_DIR: /var/www/glpi/marketplace
GLPI_USE_CSRF_CHECK: 1
GLPI_CSRF_EXPIRES: 7200
GLPI_CSRF_MAX_TOKENS: 100
GLPI_USE_IDOR_CHECK: 1
GLPI_IDOR_EXPIRES: 7200
GLPI_ALLOW_IFRAME_IN_RICH_TEXT: 
GLPI_SERVERSIDE_URL_ALLOWLIST: Array
GLPI_TELEMETRY_URI: https://telemetry.glpi-project.org
GLPI_INSTALL_MODE: TARBALL
GLPI_NETWORK_MAIL: glpi@teclib.com
GLPI_NETWORK_SERVICES: https://services.glpi-network.com
GLPI_MARKETPLACE_ALLOW_OVERRIDE: 1
GLPI_MARKETPLACE_MANUAL_DOWNLOADS: 1
GLPI_USER_AGENT_EXTRA_COMMENTS: 
GLPI_DISABLE_ONLY_FULL_GROUP_BY_SQL_MODE: 1
GLPI_AJAX_DASHBOARD: 1
GLPI_CALDAV_IMPORT_STATE: 0
GLPI_DEMO_MODE: 0
GLPI_CENTRAL_WARNINGS: 1
GLPI_DOC_DIR: /var/www/glpi/files
GLPI_CACHE_DIR: /var/www/glpi/files/_cache
GLPI_CRON_DIR: /var/www/glpi/files/_cron
GLPI_DUMP_DIR: /var/www/glpi/files/_dumps
GLPI_GRAPH_DIR: /var/www/glpi/files/_graphs
GLPI_LOCAL_I18N_DIR: /var/www/glpi/files/_locales
GLPI_LOCK_DIR: /var/www/glpi/files/_lock
GLPI_LOG_DIR: /var/www/glpi/files/_log
GLPI_PICTURE_DIR: /var/www/glpi/files/_pictures
GLPI_PLUGIN_DOC_DIR: /var/www/glpi/files/_plugins
GLPI_RSS_DIR: /var/www/glpi/files/_rss
GLPI_SESSION_DIR: /var/www/glpi/files/_sessions
GLPI_TMP_DIR: /var/www/glpi/files/_tmp
GLPI_UPLOAD_DIR: /var/www/glpi/files/_uploads
GLPI_INVENTORY_DIR: /var/www/glpi/files/_inventories
GLPI_NETWORK_REGISTRATION_API_URL: https://services.glpi-network.com/api/registration/
GLPI_MARKETPLACE_PLUGINS_API_URI: https://services.glpi-network.com/api/glpi-plugins/
GLPI_I18N_DIR: /var/www/glpi/locales
GLPI_VERSION: 10.0.3
GLPI_SCHEMA_VERSION: 10.0.3@a130db99c7d9b131c2e2ea59fe0d6260fe93d831
GLPI_MARKETPLACE_PRERELEASES: 
GLPI_MIN_PHP: 7.4.0
GLPI_MAX_PHP: 8.3.0
GLPI_YEAR: 2022
Libraries
 
htmlawed/htmlawed version 1.2.9 in (/var/www/glpi/vendor/htmlawed/htmlawed)
phpmailer/phpmailer version 6.6.0 in (/var/www/glpi/vendor/phpmailer/phpmailer/src)
simplepie/simplepie version 1.5.8 in (/var/www/glpi/vendor/simplepie/simplepie/library)
tecnickcom/tcpdf version 6.5.0 in (/var/www/glpi/vendor/tecnickcom/tcpdf)
michelf/php-markdown in (/var/www/glpi/vendor/michelf/php-markdown/Michelf)
true/punycode in (/var/www/glpi/vendor/true/punycode/src)
iamcal/lib_autolink in (/var/www/glpi/vendor/iamcal/lib_autolink)
sabre/dav in (/var/www/glpi/vendor/sabre/dav/lib/DAV)
sabre/http in (/var/www/glpi/vendor/sabre/http/lib)
sabre/uri in (/var/www/glpi/vendor/sabre/uri/lib)
sabre/vobject in (/var/www/glpi/vendor/sabre/vobject/lib)
laminas/laminas-i18n in (/var/www/glpi/vendor/laminas/laminas-i18n/src)
laminas/laminas-servicemanager in (/var/www/glpi/vendor/laminas/laminas-servicemanager/src)
monolog/monolog in (/var/www/glpi/vendor/monolog/monolog/src/Monolog)
sebastian/diff in (/var/www/glpi/vendor/sebastian/diff/src)
donatj/phpuseragentparser in (/var/www/glpi/vendor/donatj/phpuseragentparser/src/UserAgent)
elvanto/litemoji in (/var/www/glpi/vendor/elvanto/litemoji/src)
symfony/console in (/var/www/glpi/vendor/symfony/console)
scssphp/scssphp in (/var/www/glpi/vendor/scssphp/scssphp/src)
laminas/laminas-mail in (/var/www/glpi/vendor/laminas/laminas-mail/src/Protocol)
laminas/laminas-mime in (/var/www/glpi/vendor/laminas/laminas-mime/src)
rlanvin/php-rrule in (/var/www/glpi/vendor/rlanvin/php-rrule/src)
blueimp/jquery-file-upload in (/var/www/glpi/vendor/blueimp/jquery-file-upload/server/php)
ramsey/uuid in (/var/www/glpi/vendor/ramsey/uuid/src)
psr/log in (/var/www/glpi/vendor/psr/log/Psr/Log)
psr/simple-cache in (/var/www/glpi/vendor/psr/simple-cache/src)
psr/cache in (/var/www/glpi/vendor/psr/cache/src)
league/csv in (/var/www/glpi/vendor/league/csv/src)
mexitek/phpcolors in (/var/www/glpi/vendor/mexitek/phpcolors/src/Mexitek/PHPColors)
guzzlehttp/guzzle in (/var/www/glpi/vendor/guzzlehttp/guzzle/src)
guzzlehttp/psr7 in (/var/www/glpi/vendor/guzzlehttp/psr7/src)
glpi-project/inventory_format in (/var/www/glpi/vendor/glpi-project/inventory_format/lib/php)
wapmorgan/unified-archive in (/var/www/glpi/vendor/wapmorgan/unified-archive/src)
paragonie/sodium_compat in (/var/www/glpi/vendor/paragonie/sodium_compat/src)
symfony/cache in (/var/www/glpi/vendor/symfony/cache)
html2text/html2text in (/var/www/glpi/vendor/html2text/html2text/src)
symfony/css-selector in (/var/www/glpi/vendor/symfony/css-selector)
symfony/dom-crawler in (/var/www/glpi/vendor/symfony/dom-crawler)
twig/twig in (/var/www/glpi/vendor/twig/twig/src)
twig/string-extra in (/var/www/glpi/vendor/twig/string-extra)
symfony/polyfill-ctype not found
symfony/polyfill-iconv not found
symfony/polyfill-mbstring not found
symfony/polyfill-php80 in (/var/www/glpi/vendor/symfony/polyfill-php80)
symfony/polyfill-php81 in (/var/www/glpi/vendor/symfony/polyfill-php81)
symfony/polyfill-php82 in (/var/www/glpi/vendor/symfony/polyfill-php82)
phpCas version 1.3.8 in (/usr/share/php/CAS/source)
LDAP directories
 
Server: 'X', Port: '389', BaseDN: 'dc=X,dc=local', Connection filter:
        '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2))(memberof=cn=app_glpi,ou=groups,ou=X,dc=X,dc=local))',
        RootDN: 'X@X.local', Use TLS: none
SQL replicas
 
Not active
Notifications
 
Way of sending emails: SMTP (anonymous@X.X.X.X)
Plugins list
 
    fields               Name: Additional fields              Version: 1.18.2     State: Enabled                                 
        Install Method: Marketplace
    datainjection        Name: Data injection                 Version: 2.12.0     State: Installed / not activated               
        Install Method: Marketplace
    glpiinventory        Name: GLPI Inventory                 Version: 1.0.4      State: Enabled                                 
        Install Method: Marketplace
    uninstall            Name: Item's Lifecycle (uninstall)   Version: 2.8.0      State: Enabled                                 
        Install Method: Marketplace
    satisfaction         Name: More satisfaction              Version: 1.6.1      State: Error / to clean                        
        Install Method: Manual
    genericobject        Name: Objects management             Version: 2.14.0     State: Enabled                                 
        Install Method: Marketplace
    printlabel           Name: Print Label                    Version: 0.0.1      State: Enabled                                 
        Install Method: Manual
    printlabelprinter    Name: Print Label Printer            Version: 0.0.1      State: Enabled                                 
        Install Method: Manual
    printercounters      Name: Printer counters               Version: 2.0.0      State: Error / to clean                        
        Install Method: Manual

Anything else?

No response

trasher commented 2 years ago

This seems related to an inventory, you have to provide inventory file we can use to reproduce.

vollkommenIrrelevant commented 2 years ago

This seems related to an inventory, you have to provide inventory file we can use to reproduce.

no problem. How can I publish it not public?

trasher commented 2 years ago

There is no way using community support; you have to anonymize data.

vollkommenIrrelevant commented 2 years ago 
<REQUEST>
<CONTENT>
<DEVICE>
<FIRMWARES>
<DESCRIPTION>device firmware</DESCRIPTION>
<MANUFACTURER>Hewlett-Packard</MANUFACTURER>
<NAME>1820-8G</NAME>
<TYPE>device</TYPE>
<VERSION>
U-Boot X (Y)
</VERSION>
</FIRMWARES>
<FIRMWARES>
<DESCRIPTION>HP Web Management Software version</DESCRIPTION>
<MANUFACTURER>HP</MANUFACTURER>
<NAME>HP-HttpMg-Version</NAME>
<TYPE>system</TYPE>
<VERSION>X</VERSION>
</FIRMWARES>
<INFO>
<COMMENTS>
HP 1820-8G Switch J9979A, X, Linux X, U-Boot X (Y)
</COMMENTS>
<CONTACT>XXX</CONTACT>
<FIRMWARE>
U-Boot X (Y)
</FIRMWARE>
<ID>X</ID>
<IPS>
<IP>X.X.X.X</IP>
</IPS>
<LOCATION>XXX</LOCATION>
<MAC>e0:07:1b:4e:68:10</MAC>
<MANUFACTURER>Hewlett-Packard</MANUFACTURER>
<MODEL>1820-8G</MODEL>
<NAME>HP 1820-8G</NAME>
<SERIAL>CN6XXXXXXX</SERIAL>
<TYPE>NETWORKING</TYPE>
<UPTIME>156 days, 22:03:19.00</UPTIME>
</INFO>
<PORTS>
<PORT>
<CONNECTIONS>
<CDP>1</CDP>
<CONNECTION>
<IFDESCR>Port #22</IFDESCR>
<IFNUMBER>22</IFNUMBER>
<SYSDESCR>
HP 1810-24G, X, Y, Z
</SYSDESCR>
<SYSMAC>88:51:fb:ba:2f:40</SYSMAC>
<SYSNAME>J9803A</SYSNAME>
</CONNECTION>
</CONNECTIONS>
<IFDESCR>1 Gigabit - Level</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>3611120417</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>41.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>1</IFNAME>
<IFNUMBER>1</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>939518749</IFOUTOCTETS>
<IFSPEED>1000000000</IFSPEED>
<IFSTATUS>1</IFSTATUS>
<IFTYPE>6</IFTYPE>
<MAC>e0:07:1b:4e:68:12</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>X</NUMBER>
<TAGGED>X</TAGGED>
</VLAN>
</VLANS>
</PORT>

...
[More Ports are not in file due privacy reason]
...

<PORT>
<IFDESCR>CPU Interface</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>3670229612</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>0.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>CPU</IFNAME>
<IFNUMBER>53</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>477519302</IFOUTOCTETS>
<IFSPEED>0</IFSPEED>
<IFSTATUS>1</IFSTATUS>
<IFTYPE>1</IFTYPE>
<IP>X</IP>
<IPS>
<IP>X</IP>
</IPS>
<MAC>e0:07:1b:4e:68:10</MAC>
</PORT>
<PORT>
<IFDESCR>TRK1</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>0</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>0.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>TRK1</IFNAME>
<IFNUMBER>54</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>0</IFOUTOCTETS>
<IFSPEED>0</IFSPEED>
<IFSTATUS>2</IFSTATUS>
<IFTYPE>161</IFTYPE>
<MAC>e0:07:1b:4e:68:12</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<IFDESCR>TRK2</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>0</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>0.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>TRK2</IFNAME>
<IFNUMBER>55</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>0</IFOUTOCTETS>
<IFSPEED>0</IFSPEED>
<IFSTATUS>2</IFSTATUS>
<IFTYPE>161</IFTYPE>
<MAC>e0:07:1b:4e:68:12</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<IFDESCR>TRK3</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>0</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>0.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>TRK3</IFNAME>
<IFNUMBER>56</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>0</IFOUTOCTETS>
<IFSPEED>0</IFSPEED>
<IFSTATUS>2</IFSTATUS>
<IFTYPE>161</IFTYPE>
<MAC>e0:07:1b:4e:68:12</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<IFDESCR>TRK4</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>0</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>0.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>TRK4</IFNAME>
<IFNUMBER>57</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>0</IFOUTOCTETS>
<IFSPEED>0</IFSPEED>
<IFSTATUS>2</IFSTATUS>
<IFTYPE>161</IFTYPE>
<MAC>e0:07:1b:4e:68:12</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
</PORTS>
</DEVICE>
<MODULEVERSION>X</MODULEVERSION>
<PROCESSNUMBER>X</PROCESSNUMBER>
</CONTENT>
<DEVICEID>x.y.z-2022-09-23-16-12-38</DEVICEID>
<QUERY>SNMPQUERY</QUERY>
</REQUEST>
trasher commented 2 years ago

Please try with data you provide. Several data are incorrect (ips, tag and so on).

vollkommenIrrelevant commented 2 years ago

Please try with data you provide. Several data are incorrect (ips, tag and so on).

There is no way using community support; you have to anonymize data.

cedric-anne commented 2 years ago

You have to anonymize data, but anonymized data should remains relevant.

If you want to have a support based on your real data without risking leak of sensitive informations, you can also consider taking a subscription to get professional support. With this, you will be able to transmit your data on private channels.

vollkommenIrrelevant commented 2 years ago

You have to anonymize data, but anonymized data should remains relevant.

I will check

If you want to have a support based on your real data without risking leak of sensitive informations, you can also consider taking a subscription to get professional support. With this, you will be able to transmit your data on private channels.

Of course.

vollkommenIrrelevant commented 2 years ago 
<REQUEST>
<CONTENT>
<DEVICE>
<FIRMWARES>
<DESCRIPTION>device firmware</DESCRIPTION>
<MANUFACTURER>Hewlett-Packard</MANUFACTURER>
<NAME>1820-8G</NAME>
<TYPE>device</TYPE>
<VERSION>
U-Boot AKTUAL_FIRMWARE_VERSION
</VERSION>
</FIRMWARES>
<FIRMWARES>
<DESCRIPTION>HP Web Management Software version</DESCRIPTION>
<MANUFACTURER>HP</MANUFACTURER>
<NAME>HP-HttpMg-Version</NAME>
<TYPE>system</TYPE>
<VERSION>PT.09.99</VERSION>
</FIRMWARES>
<INFO>
<COMMENTS>
HP 1820-8G Switch J9979A, PT.09.99, Linux AKTUAL_KERNEL, U-Boot AKTUAL_FIRMWARE_VERSION
</COMMENTS>
<CONTACT>ACTUAL_CONTACT</CONTACT>
<FIRMWARE>
U-Boot AKTUAL_FIRMWARE_VERSION
</FIRMWARE>
<ID>12345</ID>
<IPS>
<IP>192.168.100.1</IP>
</IPS>
<LOCATION>AKTUAL_LOCATION</LOCATION>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<MANUFACTURER>Hewlett-Packard</MANUFACTURER>
<MODEL>1820-8G</MODEL>
<NAME>HP 1820-8G</NAME>
<SERIAL>CN6AXXXXXX</SERIAL>
<TYPE>NETWORKING</TYPE>
<UPTIME>160 days, 00:34:23.00</UPTIME>
</INFO>
<PORTS>
<PORT>
<CONNECTIONS>
<CDP>1</CDP>
<CONNECTION>
<IFDESCR>Port #22</IFDESCR>
<IFNUMBER>22</IFNUMBER>
<SYSDESCR>
HP 1810-24G, PL.3.33, eCos-4.0, 9_99_9-customized-h
</SYSDESCR>
<SYSMAC>88:51:fb:aa:aa:aa</SYSMAC>
<SYSNAME>J9803A</SYSNAME>
</CONNECTION>
</CONNECTIONS>
<IFDESCR>1 Gigabit - Level</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>1667022238</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>41.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>1</IFNAME>
<IFNUMBER>1</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>1049351767</IFOUTOCTETS>
<IFSPEED>1000000000</IFSPEED>
<IFSTATUS>1</IFSTATUS>
<IFTYPE>6</IFTYPE>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<CONNECTIONS>
<CONNECTION>
<MAC>a4:bb:6d:aa:aa:ab</MAC>
</CONNECTION>
</CONNECTIONS>
<IFDESCR>2 Gigabit - Level</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>1370082409</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>159 days, 20:45:07.00</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>2</IFNAME>
<IFNUMBER>2</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>2921322464</IFOUTOCTETS>
<IFSPEED>1000000000</IFSPEED>
<IFSTATUS>1</IFSTATUS>
<IFTYPE>6</IFTYPE>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<CONNECTIONS>
<CONNECTION>
<MAC>e4:f7:a1:aa:aa:ac</MAC>
</CONNECTION>
</CONNECTIONS>
<IFDESCR>3 Gigabit - Level</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>101626912</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>149 days, 03:09:33.00</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>3</IFNAME>
<IFNUMBER>3</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>4259733348</IFOUTOCTETS>
<IFSPEED>100000000</IFSPEED>
<IFSTATUS>1</IFSTATUS>
<IFTYPE>6</IFTYPE>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<CONNECTIONS>
<CONNECTION>
<MAC>00:04:a3:aa:aa:ad</MAC>
</CONNECTION>
</CONNECTIONS>
<IFDESCR>4 Gigabit - Level</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>102594543</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>41.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>4</IFNAME>
<IFNUMBER>4</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>4253909425</IFOUTOCTETS>
<IFSPEED>100000000</IFSPEED>
<IFSTATUS>1</IFSTATUS>
<IFTYPE>6</IFTYPE>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<IFDESCR>5 Gigabit - Level</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>77995161</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>159 days, 21:04:06.00</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>5</IFNAME>
<IFNUMBER>5</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>995825353</IFOUTOCTETS>
<IFSPEED>10000000</IFSPEED>
<IFSTATUS>1</IFSTATUS>
<IFTYPE>6</IFTYPE>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<CONNECTIONS>
<CONNECTION>
<MAC>00:17:c8:aa:aa:ae</MAC>
</CONNECTION>
</CONNECTIONS>
<IFDESCR>6 Gigabit - Level</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>264850140</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>42.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>6</IFNAME>
<IFNUMBER>6</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>433180864</IFOUTOCTETS>
<IFSPEED>1000000000</IFSPEED>
<IFSTATUS>1</IFSTATUS>
<IFTYPE>6</IFTYPE>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<IFDESCR>7 Gigabit - Level</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>10252723</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>159 days, 21:30:28.00</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>7</IFNAME>
<IFNUMBER>7</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>80136130</IFOUTOCTETS>
<IFSPEED>100000000</IFSPEED>
<IFSTATUS>1</IFSTATUS>
<IFTYPE>6</IFTYPE>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<IFDESCR>8 Gigabit - Level</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>0</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>0.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>8</IFNAME>
<IFNUMBER>8</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>0</IFOUTOCTETS>
<IFSPEED>0</IFSPEED>
<IFSTATUS>2</IFSTATUS>
<IFTYPE>6</IFTYPE>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<IFDESCR>CPU Interface</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>3729525798</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>0.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>CPU</IFNAME>
<IFNUMBER>53</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>487801620</IFOUTOCTETS>
<IFSPEED>0</IFSPEED>
<IFSTATUS>1</IFSTATUS>
<IFTYPE>1</IFTYPE>
<IP>192.168.100.1</IP>
<IPS>
<IP>192.168.100.1</IP>
</IPS>
<MAC>e0:07:1b:aa:aa:af</MAC>
</PORT>
<PORT>
<IFDESCR>TRK1</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>0</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>0.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>TRK1</IFNAME>
<IFNUMBER>54</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>0</IFOUTOCTETS>
<IFSPEED>0</IFSPEED>
<IFSTATUS>2</IFSTATUS>
<IFTYPE>161</IFTYPE>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<IFDESCR>TRK2</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>0</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>0.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>TRK2</IFNAME>
<IFNUMBER>55</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>0</IFOUTOCTETS>
<IFSPEED>0</IFSPEED>
<IFSTATUS>2</IFSTATUS>
<IFTYPE>161</IFTYPE>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<IFDESCR>TRK3</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>0</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>0.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>TRK3</IFNAME>
<IFNUMBER>56</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>0</IFOUTOCTETS>
<IFSPEED>0</IFSPEED>
<IFSTATUS>2</IFSTATUS>
<IFTYPE>161</IFTYPE>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
<PORT>
<IFDESCR>TRK4</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>0</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>0.00 seconds</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>TRK4</IFNAME>
<IFNUMBER>57</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>0</IFOUTOCTETS>
<IFSPEED>0</IFSPEED>
<IFSTATUS>2</IFSTATUS>
<IFTYPE>161</IFTYPE>
<MAC>e0:07:1b:aa:aa:aa</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>
</PORTS>
</DEVICE>
<MODULEVERSION>9.9</MODULEVERSION>
<PROCESSNUMBER>99999</PROCESSNUMBER>
</CONTENT>
<DEVICEID>pcwithagent.Domain.local-2022-09-23-16-12-38</DEVICEID>
<QUERY>SNMPQUERY</QUERY>
</REQUEST>
trasher commented 2 years ago

I do not have any issue importing provided file; network equipment seems inventoried properly; and I have no errors in logs image

vollkommenIrrelevant commented 2 years ago

I do not have any issue importing provided file; network equipment seems inventoried properly; and I have no errors in logs image

Importing works for me proberly to, But I got a lot of errors in the sql-logfile (like described above) and believe the reason are the networkports.

stonebuzz commented 2 years ago

Have you a rule criteria based on network port logical_number?

best regards

vollkommenIrrelevant commented 2 years ago

Have you a rule criteria based on network port logical_number?

best regards

nope, only network port mac

stonebuzz commented 2 years ago

Can you post here criteria and action from this rule ?

vollkommenIrrelevant commented 2 years ago

Can you post here criteria and action from this rule ?

Kriterien --   | Asset > Art des Eintrags | ist gleich | Netzwerkgeräte   | Asset > Netzwerkport > MAC | vorhanden | Ja Aktionen --   | Inventory link | Zuweisen | Verknüpfung wenn möglich

and:

Kriterien --   | Asset > Art des Eintrags | ist gleich | Netzwerkgeräte   | Asset > Netzwerkport > MAC | vorhanden | Ja   | Asset > Netzwerkport > MAC | bereits vorhanden | Ja Aktionen --   | Inventory link | Zuweisen | Verknüpfung wenn möglich
stonebuzz commented 2 years ago

in english please ....

trasher commented 2 years ago

OK. We need a way to reproduce the issue; we cannot try to guess what in your configuration is faultly.

Please give us the way to reproduce your SQL errors using a fresh 10.0.3 install, or even better on latest 10.0 nightly build. Once we will be able to reproduce; we'll try to fix.

Thank you.

vollkommenIrrelevant commented 2 years ago

in english please ....

Can you post here criteria and action from this rule ?

Criteria

| Asset > Type of entry | is equal | Network devices | Asset > Network Port > MAC | exists | Yes Actions

| Inventory link | Assign | Link if possible

and: Criteria

| Asset > Type of entry | is equal | Network devices | Asset > Network Port > MAC | Existing | Yes | Asset > Network port > MAC | already exists | Yes Actions

| Inventory link | Assign | Link if possible

vollkommenIrrelevant commented 2 years ago

OK. We need a way to reproduce the issue; we cannot try to guess what in your configuration is faultly.

Please give us the way to reproduce your SQL errors using a fresh 10.0.3 install, or even better on latest 10.0 nightly build. Once we will be able to reproduce; we'll try to fix.

Thank you.

Perfect. What's you prefered way to give you the possibility to reproduce the issue?

stonebuzz commented 2 years ago

To be sure that it is not already fixed on the nightly build :

Best regards

vollkommenIrrelevant commented 2 years ago

To be sure that it is not already fixed on the nightly build :

* _step1_ : try with GLPI niglhty build on fresh install  (https://nightly.glpi-project.org/glpi/)  and without your data, give us the results of your tests.

* _if OK at step 1_ -> step 2 : try with GLPI niglhty build on fresh install (https://nightly.glpi-project.org/glpi/) with your data (SQL Dump) and give us the results of your tests

* _if NOK at step 1_ -> Normally not, as we tested in this condition

Best regards

Ok, that's a lot of work. I will check after the next official release again.

vollkommenIrrelevant commented 1 year ago

I udated now to the newest Version of Glpi. I think the Switch-Model is part of the problem. We have a lot of HP1820 and they are having all the same problem: In GLPI => Networkports there is mostly for every port the same macadress which results to Database-Errors in the logfile. grafik

I can imagine to possibilites:

Port 1: grafik

Port 2: grafik

Port 3: grafik

and so on...

The Webinterface of the switch shows: grafik grafik

@trasher What do you think?

trasher commented 1 year ago

I have no idea; we need a way to reproduce on our side in order to investigate or fix.

vollkommenIrrelevant commented 1 year ago

Unfortenately I'm not able to send you a switch...

cedric-anne commented 1 year ago

Hard to say if can fix your issue, but #13104 should improve way to handle LLDP related informations. Could you check?

vollkommenIrrelevant commented 1 year ago

Hard to say if can fix your issue, but #13104 should improve way to handle LLDP related informations. Could you check?

I found more errors in the logfile like problems because "not unique wireing" - https://github.com/glpi-project/glpi/pull/13104 may help. I have to wait for a release because at the moment I have no test environment.

trasher commented 1 year ago

If you cannot provide a way to reproduce, and cannot test on your side... That will be a problem.

I close this one, feel free to reopen if issue persists with nightly or next release (and if you can provide a way to reproduce).

po1vo commented 1 year ago

@cedric-anne , judging by the partial output provided i guess the input looked like this:

<CONNECTION>
    <IFNUMBER>E0-07-1B-4E-68-12</IFNUMBER>
    <SYSMAC>e0:07:1b:4e:68:10</SYSMAC>
</CONNECTION>

My patch will work if i convert E0-07-1B-4E-68-12 to a canonical mac form. But should i do this in my patch? Isn't this a task for inventory_format's Converter?

trasher commented 1 year ago

<IFNUMBER>E0-07-1B-4E-68-12</IFNUMBER> I'm not expert in network equipments domain, but that sounds terribly wrong

po1vo commented 1 year ago

@cedric-anne , @trasher , the thing is, LLDP provides PortID as either port's logical number or ifname or mac. I believe it's glpi-agent's job to figure out what is provided and pass PortID in either MAC, IFDESCR or IFNUMBER keys.

I haven't seen LLDP in the input though, only CDP, but that's the only explanation i have.

po1vo commented 1 year ago

I take back what is said about the converter, it's not it's task either.

po1vo commented 1 year ago

I haven't seen MACs in PortIDs, but i have the two other cases:

Port ID TLV
        Local: 3007
Port ID TLV
        Ifname: xe-1/0/27
cedric-anne commented 1 year ago

@cedric-anne , @trasher , the thing is, LLDP provides PortID as either port's logical number or ifname or mac. I believe it's glpi-agent's job to figure out what is provided and pass PortID in either MAC, IFDESCR or IFNUMBER keys.

I haven't seen LLDP in the input though, only CDP, but that's the only explanation i have.

Really, I do not know much about networking, and even less about networking equipment, so I cannot help on this part. It looks like you have a good knowledge of this part and produce good quality code, so I trust you to find the best solution.

po1vo commented 1 year ago

I thought a little more about the problem. If all ports have the same mac (E0-07-1B-4E-68-12) and there's no other data in CDP/LLDP output to identify each port (like logical number or ifname), there is no way to identify what goes where and to make connections in Glpi.

vollkommenIrrelevant commented 1 year ago

there is no way to identify what goes where and to make connections in Glpi.

and I think this is why I have a lot of errors (like not unique wireing) in the sql-errors.txt because of glpi is not aware of this case and runs in exceptions. In the provided file from above you have <PORT><MAC>xyz</MAC></PORT> which is the Mac of the attached device, this may be helpful?

po1vo commented 1 year ago

I don't see any attached files (?) and, yes, almost all ports have the same mac. We need to see where the string E0-07-1B-4E-68-12 came from to troubleshoot further.

vollkommenIrrelevant commented 1 year ago

I don't see any attached files (?)

https://github.com/glpi-project/glpi/issues/13094#issuecomment-1296833864

It's a differend Switch as from the screenshots, so the string differs and is e0:07:1b:aa:aa:aa there... Forgot the idea with <PORT><MAC>xyz</MAC></PORT> sorry for that.

po1vo commented 1 year ago

@vollkommenIrrelevant , could you provide a part of xml with the exact same string E0-07-1B-4E-68-12 ?

vollkommenIrrelevant commented 1 year ago

@vollkommenIrrelevant , could you provide a part of xml with the exact same string E0-07-1B-4E-68-12 ?

https://github.com/glpi-project/glpi/issues/13382#issuecomment-1324899965

The Mac of the Switch and some Information are substitued with XX for privacy. Mac-Adresses of the Ports are untouched... E0-07-1B-4E-68-12 is shown as e0:07:1b:4e:68:12 in xml.

po1vo commented 1 year ago

@vollkommenIrrelevant , no i need the string "E0-07-1B-4E-68-12" (capitalized and with dashes). Is there another switch connected to this one, which may have produced "E0-07-1B-4E-68-12"?

vollkommenIrrelevant commented 1 year ago

I check, one Minute

vollkommenIrrelevant commented 1 year ago

@vollkommenIrrelevant , no i need the string "E0-07-1B-4E-68-12" (capitalized and with dashes). Is there another switch connected to this one, which may have produced "E0-07-1B-4E-68-12"?

The another switch which is connect have produced E0-07-1B-4E-68-12. Heres the part of the xml:


<PORT>
<CONNECTIONS>
<CDP>1</CDP>
<CONNECTION>
<IFDESCR>1</IFDESCR>
<IFNUMBER>E0-07-1B-4E-68-12</IFNUMBER>
<SYSDESCR>
HPE OfficeConnect Switch 1820 8G J9979A, PT.02.XX, Linux X.X.X-XXXXXXX, U-Boot XXXX.XX-XXXXX-XXXXXXX (DATE)
</SYSDESCR>
<SYSMAC>e0:07:1b:4e:68:10</SYSMAC>
<SYSNAME>HP 1820-8G</SYSNAME>
</CONNECTION>
</CONNECTIONS>
<IFALIAS>22</IFALIAS>
<IFDESCR>Port: 22 Gigabit - Level</IFDESCR>
<IFINERRORS>0</IFINERRORS>
<IFINOCTETS>3164194863</IFINOCTETS>
<IFINTERNALSTATUS>1</IFINTERNALSTATUS>
<IFLASTCHANGE>243 days, 16:05:27.31</IFLASTCHANGE>
<IFMTU>1518</IFMTU>
<IFNAME>Port 22</IFNAME>
<IFNUMBER>22</IFNUMBER>
<IFOUTERRORS>0</IFOUTERRORS>
<IFOUTOCTETS>3038478003</IFOUTOCTETS>
<IFPORTDUPLEX>3</IFPORTDUPLEX>
<IFSPEED>1000000000</IFSPEED>
<IFSTATUS>1</IFSTATUS>
<IFTYPE>6</IFTYPE>
<MAC>88:51:fb:XX:XX:XX</MAC>
<VLANS>
<VLAN>
<NAME>default</NAME>
<NUMBER>1</NUMBER>
<TAGGED>0</TAGGED>
</VLAN>
</VLANS>
</PORT>```
po1vo commented 1 year ago

My guess was right, this part is wrong:

<CONNECTION>
    <IFDESCR>1</IFDESCR>
    <IFNUMBER>E0-07-1B-4E-68-12</IFNUMBER>
</CONNECTION>

Did you fiddle with LLDP/CDP settings?

vollkommenIrrelevant commented 1 year ago

My guess was right, this part is wrong:

<CONNECTION>
    <IFDESCR>1</IFDESCR>
    <IFNUMBER>E0-07-1B-4E-68-12</IFNUMBER>
</CONNECTION>

Did you fiddle with LLDP/CDP settings?

nope... to be shure I checked if all values have the default value. They have... This is what the Switch is showing in the gui for the remote device: grafik

vollkommenIrrelevant commented 1 year ago

Legend:

Local Interface | Chassis ID | Port ID | Port Description | System Name -- | -- | -- | -- | --
po1vo commented 1 year ago

@vollkommenIrrelevant can you make PortID a port number? Although MAC as a PortID is valid, it won't work as all of your ports have the same MAC.

po1vo commented 1 year ago

@cedric-anne @trasher , i see several issues:

  1. all ports having the same MAC address (nothing we can do about it)
  2. glpi-agent not processing PortID into MAC, IFDESCR or IFNUMBER
  3. inventory_format not enforcing data type: 
                  "ifnumber": {
                "type": "integer",
                "title": "Remote device ifindex, from CDP/LLDP"
              },
vollkommenIrrelevant commented 1 year ago

@vollkommenIrrelevant can you make PortID a port number? Although MAC as a PortID is valid, it won't work as all of your ports have the same MAC.

nope... This are all possible settings: grafik

trasher commented 1 year ago 
1. all ports having the same MAC address (nothing we can do about it)

We need an inventory file to reproduce and handle the case (if that cause an issue in glpi).

2. glpi-agent not processing PortID into `MAC`, `IFDESCR` or `IFNUMBER`

This is an agent issue, could you please open a ticket on agent repo with required information?

3. inventory_format not enforcing data type:

Not sure I understand. With an "integer" type as it's currently set, file won't validate if you put a string. I'd be surprised if a mac as logical number is really converted, I guess XML converter casts or drop it. Anyways this is not a case we've already seen; and since no inventory file has been provided, no tests has been done.

Thanks for your feedback.

cedric-anne commented 1 year ago

@po1vo

As I said, I do not know much about networking. If you have fixes to propose, they are welcome.