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.18k stars 1.28k forks source link

[10.0.0-rc3] Problem with inventory #11195

Closed Badkempachi closed 2 years ago

Badkempachi commented 2 years ago

Code of Conduct

Is there an existing issue for this?

Version

10.0.0-rc3

Bug description

Good afternoon. A little backstory. Previously, we had a physical server, which was subsequently converted and transferred to a virtual machine. The GLPI-Agent-1.2-gitcdc8de06-x64 agent was installed on it, but this virtual machine was not added to Assets/Computers. The agent for this virtual machine could be found in Home/Administration/Inventory/Agents. There are errors in the agent logs like “[http client] communication error: 500 Internal Server Error” and that the strangest connection was created and the data was sent to the server, or is it the result of the server rejecting the received data? There are also "Win32::OLE ERROR: Invalid namespace" errors. GLPI version night bild master.8b6a4ee.tar 06.04.2022 When I import a local inventory file, I get the following errors: PHP Warning(2): preg_match_all(): Delimiter must not be alphanumeric or backslash in /var/www/html/glpi/src/RuleCriteria.php at line 490 PHP Notice (8): Undefined index: nok_8LawAIOVdM$$$$560 in /var/www/html/glpi/src/Inventory/Asset/Software.php at line 668 PHP User Error (256): Column 'softwares_id' cannot be null in /var/www/html/glpi/src/DBmysql.php at line 1945

please help me to solve this problem

Relevant log output

No response

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

Information about system installation and configuration
GLPI 10.0.0-rc3 ( => /var/www/html/glpi)
Installation mode: TARBALL
Current language:en_GB

Server
 
Operating system: Linux glpi.localhost.com 5.4.17-2136.305.5.4.el8uek.x86_64 #2 SMP Mon Mar 28 19:05:22 PDT 2022 x86_64
PHP 7.4.28 fpm-fcgi (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bz2, calendar, cgi-fcgi, ctype, curl,
    date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysql, mysqli,
    mysqlnd, openssl, pcre, pdo_mysql, pdo_sqlite, posix, session, shmop, sockets, sodium, sqlite3, standard, sysvmsg, sysvsem,
    sysvshm, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="30" memory_limit="256M" post_max_size="8M" safe_mode="" session.save_handler="files"
    upload_max_filesize="2M" 
Software: Apache/2.4.37 (Oracle Linux) OpenSSL/1.1.1k ()
    Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101 Firefox/91.0
Server Software: MariaDB Server
    Server Version: 10.3.28-MariaDB
    Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    Parameters: root@localhost/GLPI
    Host info: Localhost via UNIX socket

PHP version (7.4.28) 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 (10.3.28) is supported.
The log file has been created successfully.
Write access to /var/www/html/glpi/files/_cache has been validated.
Write access to /var/www/html/glpi/config has been validated.
Write access to /var/www/html/glpi/files/_cron has been validated.
Write access to /var/www/html/glpi/files has been validated.
Write access to /var/www/html/glpi/files/_dumps has been validated.
Write access to /var/www/html/glpi/files/_graphs has been validated.
Write access to /var/www/html/glpi/files/_lock has been validated.
Write access to /var/www/html/glpi/files/_pictures has been validated.
Write access to /var/www/html/glpi/files/_plugins has been validated.
Write access to /var/www/html/glpi/files/_rss has been validated.
Write access to /var/www/html/glpi/files/_sessions has been validated.
Write access to /var/www/html/glpi/files/_tmp has been validated.
Write access to /var/www/html/glpi/files/_uploads has been validated.
Web access to the files directory should not be allowed but this cannot be checked automatically on this instance.
Make sure access to error log file (/files/_log/php-errors.log) is forbidden; otherwise review .htaccess file and web server configuration.
For security reasons, SELinux mode should be Enforcing.
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/html/glpi/marketplace has been validated.
Timezones seems loaded in database.

GLPI constants
 
GLPI_ROOT: /var/www/html/glpi
GLPI_CONFIG_DIR: /var/www/html/glpi/config
GLPI_VAR_DIR: /var/www/html/glpi/files
GLPI_MARKETPLACE_DIR: /var/www/html/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_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/html/glpi/files
GLPI_CACHE_DIR: /var/www/html/glpi/files/_cache
GLPI_CRON_DIR: /var/www/html/glpi/files/_cron
GLPI_DUMP_DIR: /var/www/html/glpi/files/_dumps
GLPI_GRAPH_DIR: /var/www/html/glpi/files/_graphs
GLPI_LOCAL_I18N_DIR: /var/www/html/glpi/files/_locales
GLPI_LOCK_DIR: /var/www/html/glpi/files/_lock
GLPI_LOG_DIR: /var/www/html/glpi/files/_log
GLPI_PICTURE_DIR: /var/www/html/glpi/files/_pictures
GLPI_PLUGIN_DOC_DIR: /var/www/html/glpi/files/_plugins
GLPI_RSS_DIR: /var/www/html/glpi/files/_rss
GLPI_SESSION_DIR: /var/www/html/glpi/files/_sessions
GLPI_TMP_DIR: /var/www/html/glpi/files/_tmp
GLPI_UPLOAD_DIR: /var/www/html/glpi/files/_uploads
GLPI_INVENTORY_DIR: /var/www/html/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/html/glpi/locales
GLPI_VERSION: 10.0.0-rc3
GLPI_SCHEMA_VERSION: 10.0.0-rc3@95da1cf53007a5c27622e99b82f61e98c6e97906
GLPI_MARKETPLACE_PRERELEASES: 1
GLPI_MIN_PHP: 7.4.0
GLPI_MAX_PHP: 8.2.0
GLPI_YEAR: 2022

Libraries
 
htmlawed/htmlawed version 1.2.6 in (/var/www/html/glpi/vendor/htmlawed/htmlawed)
phpmailer/phpmailer version 6.6.0 in (/var/www/html/glpi/vendor/phpmailer/phpmailer/src)
simplepie/simplepie version 1.5.8 in (/var/www/html/glpi/vendor/simplepie/simplepie/library)
mpdf/mpdf in (/var/www/html/glpi/vendor/mpdf/mpdf/src)
michelf/php-markdown in (/var/www/html/glpi/vendor/michelf/php-markdown/Michelf)
true/punycode in (/var/www/html/glpi/vendor/true/punycode/src)
iamcal/lib_autolink in (/var/www/html/glpi/vendor/iamcal/lib_autolink)
sabre/dav in (/var/www/html/glpi/vendor/sabre/dav/lib/DAV)
sabre/http in (/var/www/html/glpi/vendor/sabre/http/lib)
sabre/uri in (/var/www/html/glpi/vendor/sabre/uri/lib)
sabre/vobject in (/var/www/html/glpi/vendor/sabre/vobject/lib)
laminas/laminas-i18n in (/var/www/html/glpi/vendor/laminas/laminas-i18n/src)
laminas/laminas-servicemanager in (/var/www/html/glpi/vendor/laminas/laminas-servicemanager/src)
monolog/monolog in (/var/www/html/glpi/vendor/monolog/monolog/src/Monolog)
sebastian/diff in (/var/www/html/glpi/vendor/sebastian/diff/src)
donatj/phpuseragentparser in (/var/www/html/glpi/vendor/donatj/phpuseragentparser/src/UserAgent)
elvanto/litemoji in (/var/www/html/glpi/vendor/elvanto/litemoji/src)
symfony/console in (/var/www/html/glpi/vendor/symfony/console)
scssphp/scssphp in (/var/www/html/glpi/vendor/scssphp/scssphp/src)
laminas/laminas-mail in (/var/www/html/glpi/vendor/laminas/laminas-mail/src/Protocol)
laminas/laminas-mime in (/var/www/html/glpi/vendor/laminas/laminas-mime/src)
rlanvin/php-rrule in (/var/www/html/glpi/vendor/rlanvin/php-rrule/src)
blueimp/jquery-file-upload in (/var/www/html/glpi/vendor/blueimp/jquery-file-upload/server/php)
ramsey/uuid in (/var/www/html/glpi/vendor/ramsey/uuid/src)
psr/log in (/var/www/html/glpi/vendor/psr/log/Psr/Log)
psr/simple-cache in (/var/www/html/glpi/vendor/psr/simple-cache/src)
psr/cache in (/var/www/html/glpi/vendor/psr/cache/src)
league/csv in (/var/www/html/glpi/vendor/league/csv/src)
mexitek/phpcolors in (/var/www/html/glpi/vendor/mexitek/phpcolors/src/Mexitek/PHPColors)
guzzlehttp/guzzle in (/var/www/html/glpi/vendor/guzzlehttp/guzzle/src)
guzzlehttp/psr7 in (/var/www/html/glpi/vendor/guzzlehttp/psr7/src)
glpi-project/inventory_format in (/var/www/html/glpi/vendor/glpi-project/inventory_format/lib/php)
wapmorgan/unified-archive in (/var/www/html/glpi/vendor/wapmorgan/unified-archive/src)
paragonie/sodium_compat in (/var/www/html/glpi/vendor/paragonie/sodium_compat/src)
symfony/cache in (/var/www/html/glpi/vendor/symfony/cache)
html2text/html2text in (/var/www/html/glpi/vendor/html2text/html2text/src)
symfony/dom-crawler in (/var/www/html/glpi/vendor/symfony/dom-crawler)
twig/twig in (/var/www/html/glpi/vendor/twig/twig/src)
twig/string-extra in (/var/www/html/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/html/glpi/vendor/symfony/polyfill-php80)
symfony/polyfill-php81 in (/var/www/html/glpi/vendor/symfony/polyfill-php81)

LDAP directories
 
Server: '192.199.60.190', Port: '3268', BaseDN: 'DC=localhost,DC=com', Connection filter:
        '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN:
        'CN=ldapsearch-glpi,OU=Special,DC=localhost,DC=com', Use TLS: none

SQL replicas
 
Not active

Notifications
 
Way of sending emails: SMTP (anonymous@mail2.localhost.com)

Plugins list
 
    connections          Name: Connections                    Version: 10.0.0-rc2 State: Not installed
    manageentities       Name: Entities portal                Version: 4.0.0-rc1  State: Not installed
    financialreports     Name: Financial reports              Version: 3.0.0-rc2  State: Not installed
    glpiinventory        Name: GLPI Inventory                 Version: 1.0.0-rc7  State: Enabled
    addressing           Name: IP Adressing                   Version: 3.0.0-rc2  State: Not installed
    mreporting           Name: More Reporting                 Version: 1.8.0-rc3  State: Not installed
    protocolsmanager     Name: Protocols manager              Version: 1.4.2      State: Not installed
    reports              Name: Reports                        Version: 1.14.1     State: Installed / not activated
    tag                  Name: Tag Management                 Version: 2.9.0-rc4  State: Enabled
    useditemsexport      Name: Used items export              Version: 2.5.0-rc2  State: Enabled
    shellcommands        Name: Служебные команды        Version: 4.0.0-rc2  State: Installed / not activated
    printercounters      Name: Счетчики принтера        Version: 2.0.0-rc2  State: Installed / not activated
    typology             Name: Типологий                      Version: 3.0.0-rc1  State: Installed / not activated

Anything else?

sql-error.txt php-error.txt glpi-agent.log 1

cedric-anne commented 2 years ago

Hi,

You have a rule software dictionnary based on a regex pattern, and this pattern seems to be invalid. Can you export your rules ? You can do it using massive actions in the Administration > Dictionnaries > Software page.

Badkempachi commented 2 years ago

Hi,

You have a rule software dictionnary based on a regex pattern, and this pattern seems to be invalid. Can you export your rules ? You can do it using massive actions in the Administration > Dictionnaries > Software page.

Hi, @cedric-anne here's what's active at the moment rules.txt

trasher commented 2 years ago

<pattern>perl-</pattern> sounds incorrect.

Badkempachi commented 2 years ago

Hi @trasher , Please clarify according to these rules “Rules for assigning an item to an entity” is also not correctly configured for me? 6 5

Badkempachi commented 2 years ago

<pattern>perl-</pattern> sounds incorrect.

And could you suggest what would be the best way?

cedric-anne commented 2 years ago

Problem is not in Rules for assigning an item to an entity, but in dictionnary section.

Badkempachi commented 2 years ago

Problem is not in Rules for assigning an item to an entity, but in dictionnary section. @cedric-anne @trasher

I am deleted all the dictionnary, but the following messages appear in php-errors

[2022-04-06 16:48:14] glpiphplog.ERROR: *** PHP User Error (256): Column 'softwares_id' cannot be null in /var/www/html/glpi/src/DBmysql.php at line 1945 backtrace: src/DBmysql.php:1945 trigger_error() src/Inventory/Asset/Software.php:700 DBmysql->executeStatement() src/Inventory/Asset/Software.php:377 Glpi\Inventory\Asset\Software->storeVersions() src/Inventory/Asset/MainAsset.php:765 Glpi\Inventory\Asset\Software->handle() src/Inventory/Asset/MainAsset.php:686 Glpi\Inventory\Asset\MainAsset->handleAssets() src/RuleImportAsset.php:951 Glpi\Inventory\Asset\MainAsset->rulepassed() src/Rule.php:1505 RuleImportAsset->executeActions() src/RuleCollection.php:1589 Rule->process() src/Inventory/Asset/MainAsset.php:517 RuleCollection->processAllRules() src/Inventory/Inventory.php:670 Glpi\Inventory\Asset\MainAsset->handle() src/Inventory/Inventory.php:312 Glpi\Inventory\Inventory->handleItem() src/Inventory/Request.php:363 Glpi\Inventory\Inventory->doInventory() src/Inventory/Request.php:88 Glpi\Inventory\Request->inventory() src/Agent/Communication/AbstractRequest.php:323 Glpi\Inventory\Request->handleAction() src/Agent/Communication/AbstractRequest.php:235 Glpi\Agent\Communication\AbstractRequest->handleJSONRequest() front/inventory.php:83 Glpi\Agent\Communication\AbstractRequest->handleRequest() ...tplace/glpiinventory/front/communication.php:72 include_once() marketplace/glpiinventory/index.php:45 include_once()

github-actions[bot] commented 2 years ago

There has been no activity on this issue for some time and therefore it is considered stale and will be closed automatically in 10 days.

If this issue is related to a bug, please try to reproduce on latest release. If the problem persist, feel free to add a comment to revive this issue. If it is related to a new feature, please open a topic to discuss with community about this enhancement on suggestion website.

You may also consider taking a subscription to get professionnal support or contact GLPI editor team directly.