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.01k stars 1.26k forks source link

Network task inventory not working for somes switchs #13980

Closed cencen99 closed 1 year ago

cencen99 commented 1 year ago

Code of Conduct

Is there an existing issue for this?

Version

10.0.6

Bug description

The network inventory is not working properly for some switches. There is only one available port: management. I have errors in the SQL error log: Error: -Out of range value for column 'netmask_3' at row 1 for glpi_ipnetworks -Error: Out of range value for column 'binary_0' at row 1 for glpi_ipaddresses

I expect to get all port inventoried.

*IP and Mac address were modified in log

Page URL

.

Steps To reproduce

Launch glpi task netinventory on network

Your GLPI setup information

Informations sur le système, l'installation et la configuration
GLPI 10.0.6 ( => C:\inetpub\wwwroot\glpi)
Installation mode: TARBALL
Current language:fr_FR
Server
 
Operating system: Windows NT GLPI 10.0 build 14393 (Windows Server 2016) i586
PHP 7.4.13 cgi-fcgi (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, bcmath, bz2, calendar, cgi-fcgi, ctype, curl,
    date, dom, exif, fileinfo, filter, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl,
    pcre, pdo_mysql, pdo_sqlite, readline, session, soap, sodium, standard, tidy, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, zip,
    zlib)
Setup: max_execution_time="300" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files"
    upload_max_filesize="2M" 
Software: Microsoft-IIS/10.0
    Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36
Server Software: MySQL Community Server - GPL
    Server Version: 8.0.21
    Server SQL Mode: STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
    Parameters: glpidb_user@localhost/glpi
    Host info: localhost via TCP/IP

PHP version (7.4.13) 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.21) is supported.
No files from previous GLPI version detected.
The log file has been created successfully.
Write access to C:\inetpub\wwwroot\glpi/files/_cache has been validated.
Write access to C:\inetpub\wwwroot\glpi/config has been validated.
Write access to C:\inetpub\wwwroot\glpi/files/_cron has been validated.
Write access to C:\inetpub\wwwroot\glpi/files has been validated.
Write access to C:\inetpub\wwwroot\glpi/files/_dumps has been validated.
Write access to C:\inetpub\wwwroot\glpi/files/_graphs has been validated.
Write access to C:\inetpub\wwwroot\glpi/files/_lock has been validated.
Write access to C:\inetpub\wwwroot\glpi/files/_pictures has been validated.
Write access to C:\inetpub\wwwroot\glpi/files/_plugins has been validated.
Write access to C:\inetpub\wwwroot\glpi/files/_rss has been validated.
Write access to C:\inetpub\wwwroot\glpi/files/_sessions has been validated.
Write access to C:\inetpub\wwwroot\glpi/files/_tmp has been validated.
Write access to C:\inetpub\wwwroot\glpi/files/_uploads has been validated.
The following directories should be placed outside "C:\inetpub\wwwroot\glpi":
‣ "C:\inetpub\wwwroot\glpi/files" ("GLPI_VAR_DIR")
‣ "C:\inetpub\wwwroot\glpi\config" ("GLPI_CONFIG_DIR")
You can ignore this suggestion if you are certain that these directories are not accessible through your web server.
Sessions configuration is secured.
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 C:\inetpub\wwwroot\glpi/marketplace has been validated.
Timezones seems loaded in database.
GLPI constants
 
GLPI_ROOT: "C:\\inetpub\\wwwroot\\glpi"
GLPI_CONFIG_DIR: "C:\\inetpub\\wwwroot\\glpi/config"
GLPI_VAR_DIR: "C:\\inetpub\\wwwroot\\glpi/files"
GLPI_MARKETPLACE_DIR: "C:\\inetpub\\wwwroot\\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: false
GLPI_SERVERSIDE_URL_ALLOWLIST: ["/^(https?|feed):\\/\\/[^@:]+(\\/.*)?$/"]
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: true
GLPI_MARKETPLACE_MANUAL_DOWNLOADS: true
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: "C:\\inetpub\\wwwroot\\glpi/files"
GLPI_CACHE_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_cache"
GLPI_CRON_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_cron"
GLPI_DUMP_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_dumps"
GLPI_GRAPH_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_graphs"
GLPI_LOCAL_I18N_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_locales"
GLPI_LOCK_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_lock"
GLPI_LOG_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_log"
GLPI_PICTURE_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_pictures"
GLPI_PLUGIN_DOC_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_plugins"
GLPI_RSS_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_rss"
GLPI_SESSION_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_sessions"
GLPI_TMP_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_tmp"
GLPI_UPLOAD_DIR: "C:\\inetpub\\wwwroot\\glpi/files/_uploads"
GLPI_INVENTORY_DIR: "C:\\inetpub\\wwwroot\\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: "C:\\inetpub\\wwwroot\\glpi/locales"
GLPI_VERSION: "10.0.6"
GLPI_SCHEMA_VERSION: "10.0.6"
GLPI_MARKETPLACE_PRERELEASES: false
GLPI_MIN_PHP: "7.4.0"
GLPI_MAX_PHP: "8.3.0"
GLPI_YEAR: "2023"
Libraries
 
htmlawed/htmlawed version 1.2.9 in (C:\inetpub\wwwroot\glpi\vendor\htmlawed\htmlawed)
phpmailer/phpmailer version 6.6.0 in (C:\inetpub\wwwroot\glpi\vendor\phpmailer\phpmailer\src)
simplepie/simplepie version 1.5.8 in (C:\inetpub\wwwroot\glpi\vendor\simplepie\simplepie\library)
tecnickcom/tcpdf version 6.6.2 in (C:\inetpub\wwwroot\glpi\vendor\tecnickcom\tcpdf)
michelf/php-markdown in (C:\inetpub\wwwroot\glpi\vendor\michelf\php-markdown\Michelf)
true/punycode in (C:\inetpub\wwwroot\glpi\vendor\true\punycode\src)
iamcal/lib_autolink in (C:\inetpub\wwwroot\glpi\vendor\iamcal\lib_autolink)
sabre/dav in (C:\inetpub\wwwroot\glpi\vendor\sabre\dav\lib\DAV)
sabre/http in (C:\inetpub\wwwroot\glpi\vendor\sabre\http\lib)
sabre/uri in (C:\inetpub\wwwroot\glpi\vendor\sabre\uri\lib)
sabre/vobject in (C:\inetpub\wwwroot\glpi\vendor\sabre\vobject\lib)
laminas/laminas-i18n in (C:\inetpub\wwwroot\glpi\vendor\laminas\laminas-i18n\src)
laminas/laminas-servicemanager in (C:\inetpub\wwwroot\glpi\vendor\laminas\laminas-servicemanager\src)
monolog/monolog in (C:\inetpub\wwwroot\glpi\vendor\monolog\monolog\src\Monolog)
sebastian/diff in (C:\inetpub\wwwroot\glpi\vendor\sebastian\diff\src)
donatj/phpuseragentparser in (C:\inetpub\wwwroot\glpi\vendor\donatj\phpuseragentparser\src\UserAgent)
elvanto/litemoji in (C:\inetpub\wwwroot\glpi\vendor\elvanto\litemoji\src)
symfony/console in (C:\inetpub\wwwroot\glpi\vendor\symfony\console)
scssphp/scssphp in (C:\inetpub\wwwroot\glpi\vendor\scssphp\scssphp\src)
laminas/laminas-mail in (C:\inetpub\wwwroot\glpi\vendor\laminas\laminas-mail\src\Protocol)
laminas/laminas-mime in (C:\inetpub\wwwroot\glpi\vendor\laminas\laminas-mime\src)
rlanvin/php-rrule in (C:\inetpub\wwwroot\glpi\vendor\rlanvin\php-rrule\src)
blueimp/jquery-file-upload in (C:\inetpub\wwwroot\glpi\vendor\blueimp\jquery-file-upload\server\php)
ramsey/uuid in (C:\inetpub\wwwroot\glpi\vendor\ramsey\uuid\src)
psr/log in (C:\inetpub\wwwroot\glpi\vendor\psr\log\Psr\Log)
psr/simple-cache in (C:\inetpub\wwwroot\glpi\vendor\psr\simple-cache\src)
psr/cache in (C:\inetpub\wwwroot\glpi\vendor\psr\cache\src)
league/csv in (C:\inetpub\wwwroot\glpi\vendor\league\csv\src)
mexitek/phpcolors in (C:\inetpub\wwwroot\glpi\vendor\mexitek\phpcolors\src\Mexitek\PHPColors)
guzzlehttp/guzzle in (C:\inetpub\wwwroot\glpi\vendor\guzzlehttp\guzzle\src)
guzzlehttp/psr7 in (C:\inetpub\wwwroot\glpi\vendor\guzzlehttp\psr7\src)
glpi-project/inventory_format in (C:\inetpub\wwwroot\glpi\vendor\glpi-project\inventory_format\lib\php)
wapmorgan/unified-archive in (C:\inetpub\wwwroot\glpi\vendor\wapmorgan\unified-archive\src)
paragonie/sodium_compat in (C:\inetpub\wwwroot\glpi\vendor\paragonie\sodium_compat\src)
symfony/cache in (C:\inetpub\wwwroot\glpi\vendor\symfony\cache)
html2text/html2text in (C:\inetpub\wwwroot\glpi\vendor\html2text\html2text\src)
symfony/css-selector in (C:\inetpub\wwwroot\glpi\vendor\symfony\css-selector)
symfony/dom-crawler in (C:\inetpub\wwwroot\glpi\vendor\symfony\dom-crawler)
twig/twig in (C:\inetpub\wwwroot\glpi\vendor\twig\twig\src)
twig/string-extra in (C:\inetpub\wwwroot\glpi\vendor\twig\string-extra)
symfony/polyfill-ctype not found
symfony/polyfill-iconv not found
symfony/polyfill-mbstring not found
symfony/polyfill-php80 in (C:\inetpub\wwwroot\glpi\vendor\symfony\polyfill-php80)
symfony/polyfill-php81 in (C:\inetpub\wwwroot\glpi\vendor\symfony\polyfill-php81)
symfony/polyfill-php82 in (C:\inetpub\wwwroot\glpi\vendor\symfony\polyfill-php82)
LDAP directories
 
Server: 'ldap://dc.company.com', Port: '636', BaseDN: 'OU=Utilisateurs,OU=service,DC=company,DC=com', Connection
        filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN:
        'glpi@aurar-run.com', Use TLS: none
SQL replicas
 
Not active
Notifications
 
Way of sending emails: SMTP (anonymous@192.168.5.116)
Plugins list
 
    addressing           Name: Adressage IP                   Version: 3.0.1      State: Installed / not activated               
        Install Method: Marketplace
    webapplications      Name: Applications Web               Version: 4.0.1      State: Installed / not activated               
        Install Method: Marketplace
    badges               Name: Badges                         Version: 3.0.0      State: Installed / not activated               
        Install Method: Marketplace
    fields               Name: Champs supplémentaires         Version: 1.20.0     State: Enabled                                 
        Install Method: Marketplace
    cmdb                 Name: CMDB                           Version: 3.0.3      State: Installed / not activated               
        Install Method: Marketplace
    behaviors            Name: Comportements                  Version: 2.7.2      State: Enabled                                 
        Install Method: Marketplace
    printercounters      Name: Compteurs Imprimantes          Version: 1.7.0      State: Not installed                           
        Install Method: Manual
    credit               Name: Crédits                        Version: 1.11.3     State: Installed / not activated               
        Install Method: Marketplace
    mydashboard          Name: Dashboard                      Version: 2.1.4      State: Installed / not activated               
        Install Method: Marketplace
    datainjection        Name: Data Injection                 Version: 2.10.1     State: Installed / not activated               
        Install Method: Manual
    purchaserequest      Name: Demande d'achat                Version: 3.0.1      State: Enabled                                 
        Install Method: Marketplace
    dataflows            Name: Flux de données                Version: 2.2.18     State: Installed / not activated               
        Install Method: Marketplace
    formcreator          Name: Form Creator                   Version: 2.13.4     State: Enabled                                 
        Install Method: Marketplace
    fusioninventory      Name: FusionInventory                Version: 9.5+4.2    State: Not installed                           
        Install Method: Manual
    genericobject        Name: Gestion d'objets               Version: 2.11.1     State: Installed / not activated               
        Install Method: Manual
    order                Name: Gestion des commandes          Version: 2.7.6      State: Not installed                           
        Install Method: Manual
    glpiinventory        Name: GLPI Inventory                 Version: 1.1.0      State: Enabled                                 
        Install Method: Marketplace
    pdf                  Name: Impression pdf                 Version: 3.0.0      State: Installed / not activated               
        Install Method: Marketplace
    tasklists            Name: Liste des tâches               Version: 2.0.3      State: Installed / not activated               
        Install Method: Marketplace
    mailbehaviours       Name: Mail Behaviours                Version: 1.0.3      State: Installed / not activated               
        Install Method: Manual
    metademands          Name: Meta-Demandes                  Version: 3.2.13     State: To update                               
        Install Method: Marketplace
    moreticket           Name: More ticket                    Version: 1.7.1      State: Enabled                                 
        Install Method: Marketplace
    dashboard            Name: Tableau de bord                Version: 1.0.2      State: Installed / not activated               
        Install Method: Manual
    typology             Name: Typologies                     Version: 2.7.2      State: Installed / not activated               
        Install Method: Manual

Anything else?

Already tryed with a fresh installation with debian 11, apache2, mariadb: still no inventory from some switches with same error.

stonebuzz commented 1 year ago

Hi @cencen99 Can you provide inventory file, to try to reproduce on my side?

Best regards

stonebuzz commented 1 year ago

Are you on 32bit OS?

cencen99 commented 1 year ago

``

Hi @cencen99 Can you provide inventory file, to try to reproduce on my side?

Best regards

netinv.xml.log

cencen99 commented 1 year ago

i dont understand, i can import the file on fresh glpi installation (debian 11 apache2), but on my production environnement, i have this error: Le fichier n'a pas été importé: JSON does not validate. Violations: Integer expected, null received at #->properties:content->properties:network_ports->items[9]:9->properties:ifoutbytes

cencen99 commented 1 year ago

Are you on 32bit OS?

Windows 64 bit, IIS 10, php x86

stonebuzz commented 1 year ago

I do not reproduce issue with your file, however if this one has been modified for security reasons, I can't say that everything is OK.

Is it possible to send me (via my professional email address) the XML file in question (unaltered)?

Best regards

cencen99 commented 1 year ago

Thank you very much for your help. The problem was the use of php x86. I switched to php x64 and everything is working correctly.