rafaelse
commented
1 month ago Digging a little deeper in the code, we found out that this issues was caused by manually deleting quite high amount of unmanaged devices from the database, which were inserted by our weekly running inventory tasks.
So, the solution we came up with was deleting all network port connections that involved the deleted unmanaged devices:
DELETE FROM glpi_networkports_networkports AS con WHERE networkports_id_2 IN
(SELECT port.id FROM glpi_networkports AS port WHERE port.itemtype = 'Unmanaged' AND NOT EXISTS
(SELECT unm.id FROM glpi_unmanageds AS unm WHERE unm.id = port.items_id));Now, all the ports are being displayed normally for all the users.
Next time, we delete unmanaged devices only through the UI.
Code of Conduct
Is there an existing issue for this?
Version
10.0.16
Bug description
We noticed that network ports aren't being displayed on inventoried equipments like printers, for example. However, some users report having no problems seeing those ports. We tried viewing the ports under similar circumstances (permissions and entity) as those who managed to access them, but no luck. Even as super-admin, they won't get displayed. It's come to our attention that this issue has been happening for a while, through several GLPI versions.
Please, see the images below which illustrate the case described.
Also, notice that the an non displayed port is still accessible via its URL.
Relevant log output
Page URL
front/printer.form.php?id=158
Steps To reproduce
No response
Your GLPI setup information
Information about system installation and configuration
Server
Operating system: Linux production-7c77d8d784-85nrl 5.10.219-208.866.amzn2.x86_64 #1 SMP Tue Jun 18 14:00:06 UTC 2024 x86_64 PHP 8.3.9 fpm-fcgi (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, bz2, cgi-fcgi, ctype, curl, date, dom, exif, fileinfo, filter, gd, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_sqlite, posix, random, readline, redis, session, soap, sodium, sqlite3, standard, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, zip, zlib) Setup: max_execution_time="300" memory_limit="768M" post_max_size="20M" safe_mode="" session.save_handler="files" upload_max_filesize="20M" disable_functions="pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,exec,passthru,shell_exec,system,proc_open,popen,curl_multi_exec,parse_ini_file,show_source" Software: nginx Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Server Software: Source distribution Server Version: 8.0.36 Server SQL Mode: NO_ENGINE_SUBSTITUTION PHP version (8.3.9) is supported. Sessions configuration is OK. Allocated memory is sufficient. mysqli extension is installed. Following extensions are installed: dom, fileinfo, filter, libxml, json, simplexml, xmlreader, xmlwriter. curl extension is installed. gd extension is installed. intl extension is installed. zlib extension is installed. The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (8.0.36) is supported. No files from previous GLPI version detected. The log file has been created successfully. Write access to /var/lib/glpi/_cache has been validated. Write access to /var/lib/glpi/_cron has been validated. Write access to /var/lib/glpi has been validated. Write access to /var/lib/glpi/_dumps has been validated. Write access to /var/lib/glpi/_graphs has been validated. Write access to /var/lib/glpi/_lock has been validated. Write access to /var/lib/glpi/_pictures has been validated. Write access to /var/lib/glpi/_plugins has been validated. Write access to /var/lib/glpi/_rss has been validated. Write access to /var/lib/glpi/_sessions has been validated. Write access to /var/lib/glpi/_tmp has been validated. Write access to /var/lib/glpi/_uploads has been validated. Web server root directory configuration seems safe. Sessions configuration is secured. OS and PHP are relying on 64 bits integers. exif extension is installed. ldap extension is installed. openssl extension is installed. Following extensions are installed: bz2, Phar, zip. Zend OPcache extension is installed. Following extensions are installed: ctype, iconv, mbstring, sodium. Write access to /var/www/html/marketplace has been validated. Timezones seems loaded in database.GLPI constants
Libraries
SQL replicas
Plugins list
news Name: Alerts Version: 1.12.3 State: Enabled Install Method: Marketplace formcreator Name: Form Creator Version: 2.13.9 State: Enabled Install Method: Marketplace glpiinventory Name: GLPI Inventory Version: 1.3.5 State: Enabled Install Method: Marketplace itilcategorygroups Name: Grupos ItilCategory Version: 2.5.1 State: Not installed Install Method: Marketplace manufacturersimports Name: Importação de fornecedores Version: 3.0.8 State: Enabled Install Method: MarketplaceAnything else?
No response