Code of Conduct
- [X] I agree to follow this project's Code of Conduct
Is there an existing issue for this?
- [X] I have searched the existing issues
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: [email protected]
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: '[email protected]', Use TLS: none
SQL replicas
Not active
Notifications
Way of sending emails: SMTP ([email protected])
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
Need feedback