Badkempachi
commented
2 years ago inventory file wsus2.stolyarov.info-2022-03-12-21-45-56.txt
Closed Badkempachi closed 2 years ago
Badkempachi
commented
2 years ago inventory file wsus2.stolyarov.info-2022-03-12-21-45-56.txt
Badkempachi
commented
2 years ago P.s the agent itself collects information about installed antiviruses, but the server does not receive information sent to it.
trasher
commented
2 years ago Provided file is not valid XML, and does not contains any "antivirus" node. Once again, I'm not able to reproduce.
orthagh
commented
2 years ago @Badkempachi
You must check the files before attaching them and open issue.
As @trasher said, your current file doesn't have an <ANTIVIRUS> node so the error you mentioned in your issue is not triggered by the current file.
Having Dr.Web in a <SOFTWARE> node is not sufficient to have an antivirus management by the native inventory.
So 2 hypothesis:
Please check.
steph461
commented
2 years ago hello same issue
I join for example file computer.json
SQl ERROR : computer_0_156.json for example
[2022-05-18 09:22:23] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 370
*** MySQL query error:
SQL: UPDATE `glpi_computerantiviruses` SET `is_uptodate` = '' WHERE `id` = '247'
Error: Incorrect integer value: '' for column `glpi`.`glpi_computerantiviruses`.`is_uptodate` at row 1
Backtrace :
src/DBmysql.php:1431
src/CommonDBTM.php:660 DBmysql->update()
src/CommonDBTM.php:1649 CommonDBTM->updateInDB()
src/Inventory/Asset/Antivirus.php:124 CommonDBTM->update()
src/Inventory/Asset/MainAsset.php:775 Glpi\Inventory\Asset\Antivirus->handle()
src/Inventory/Asset/MainAsset.php:696 Glpi\Inventory\Asset\MainAsset->handleAssets()
src/RuleImportAsset.php:942 Glpi\Inventory\Asset\MainAsset->rulepassed()
src/Rule.php:1507 RuleImportAsset->executeActions()
src/RuleCollection.php:1591 Rule->process()
src/Inventory/Asset/MainAsset.php:522 RuleCollection->processAllRules()
src/Inventory/Inventory.php:694 Glpi\Inventory\Asset\MainAsset->handle()
src/Inventory/Inventory.php:330 Glpi\Inventory\Inventory->handleItem()
src/Inventory/Request.php:366 Glpi\Inventory\Inventory->doInventory()
src/Inventory/Request.php:90 Glpi\Inventory\Request->inventory()
src/Agent/Communication/AbstractRequest.php:325 Glpi\Inventory\Request->handleAction()
src/Agent/Communication/AbstractRequest.php:237 Glpi\Agent\Communication\AbstractRequest->handleJSONRequest()
src/Inventory/Conf.php:196 Glpi\Agent\Communication\AbstractRequest->handleRequest()
src/Inventory/Conf.php:138 Glpi\Inventory\Conf->importContentFile()
front/inventory.conf.php:47 Glpi\Inventory\Conf->importFile()
{"user":"7@srv-glpi"}
[2022-05-18 09:25:05] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/src/DBmysql.php line 370
*** MySQL query error:
SQL: UPDATE `glpi_computerantiviruses` SET `is_uptodate` = '' WHERE `id` = '247'
Error: Incorrect integer value: '' for column `glpi`.`glpi_computerantiviruses`.`is_uptodate` at row 1
Backtrace :
src/DBmysql.php:1431
src/CommonDBTM.php:660 DBmysql->update()
src/CommonDBTM.php:1649 CommonDBTM->updateInDB()
src/Inventory/Asset/Antivirus.php:124 CommonDBTM->update()
src/Inventory/Asset/MainAsset.php:775 Glpi\Inventory\Asset\Antivirus->handle()
src/Inventory/Asset/MainAsset.php:696 Glpi\Inventory\Asset\MainAsset->handleAssets()
src/RuleImportAsset.php:942 Glpi\Inventory\Asset\MainAsset->rulepassed()
src/Rule.php:1507 RuleImportAsset->executeActions()
src/RuleCollection.php:1591 Rule->process()
src/Inventory/Asset/MainAsset.php:522 RuleCollection->processAllRules()
src/Inventory/Inventory.php:694 Glpi\Inventory\Asset\MainAsset->handle()
src/Inventory/Inventory.php:330 Glpi\Inventory\Inventory->handleItem()
src/Inventory/Request.php:366 Glpi\Inventory\Inventory->doInventory()
src/Inventory/Request.php:90 Glpi\Inventory\Request->inventory()
src/Agent/Communication/AbstractRequest.php:325 Glpi\Inventory\Request->handleAction()
src/Agent/Communication/AbstractRequest.php:237 Glpi\Agent\Communication\AbstractRequest->handleJSONRequest()
src/Inventory/Conf.php:196 Glpi\Agent\Communication\AbstractRequest->handleRequest()
src/Inventory/Conf.php:138 Glpi\Inventory\Conf->importContentFile()
front/inventory.conf.php:47 Glpi\Inventory\Conf->importFile()
{"user":"7@srv-glpi"} I'm not able to reproduce with provided file :/ Antivirus seems correctly imported without errors (at least on current nighly):
steph461
commented
2 years ago computer 156 :
it is added well in the computer but it generates this sql file. error I don't know why
displays ok but generation sql.error :
trasher
commented
2 years ago I think I found the issue... Reporter says he uses php 7.4; but on my side, I reproduce only with php 8...
steph461
commented
2 years ago I think I found the issue... Reporter says he uses php 7.4; but on my side, I reproduce only with php 8...
I use PHP 8.0.18
Badkempachi
commented
2 years ago @Badkempachi
You must check the files before attaching them and open issue. As @trasher said, your current file doesn't have an
<ANTIVIRUS>node so the error you mentioned in your issue is not triggered by the current file. Having Dr.Web in a<SOFTWARE>node is not sufficient to have an antivirus management by the native inventory.So 2 hypothesis:
* you're sending to us the wrong file * you removed yourself the node.Please check.
Hey,
This is a screenshot of the Dr.web server software, the control panel and the agent itself are installed on it, and it does not show that the antivirus is installed. The situation is repeated on the Kaspersky server. Might need to be added somewhere. If the antivirus does not get into the 
trasher
commented
2 years ago You're talking about a different issue that the one reported here. This is an agent/windows issue, not a GLPI one.
Badkempachi
commented
2 years ago You're talking about a different issue that the one reported here. This is an agent/windows issue, not a GLPI one.
understood. Thank you
Code of Conduct
Is there an existing issue for this?
Version
GLPI 10.0.1
Bug description
Hello everyone, there is a problem. On the operating system (Microsoft Windows Server 2019, Microsoft Windows Server 2012 R2, Microsoft Windows Server 2016), the GLPI service page does not display antivirus software. Dr.Web Server, Dr.Web Agent version 13.0, Kaspersky Endpoint Security and Kaspersky Security Center are not displayed on the Windows platform. It displays normally on Windows 7 and Windows 10 workstations. On Linux, ClamAV antivirus is not displayed.
Relevant log output
Page URL
No response
Steps To reproduce
No response
Your GLPI setup information
Information about system installation and configuration
Server
Operating system: Linux glpi.stolyarov.info 5.4.17-2136.307.3.1.el8uek.x86_64 #2 SMP Mon May 9 17:29:47 PDT 2022 x86_64 PHP 7.4.29 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.32-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.29) 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.32) 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
Libraries
LDAP directories
Server: '192.168.30.190', Port: '3268', BaseDN: 'DC=localhost,DC=info', Connection filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN: 'CN=ldapsearch-glpi,OU=Special,DC=localhost,DC=info', Use TLS: noneSQL replicas
Notifications
Plugins list
archisw Name: Apps structures Version: 2.2.9 State: Enabled connections Name: Connections Version: 10.0.0 State: Installed / not activated archidata Name: Data structures Version: 1.0.9 State: Installed / not activated dataflows Name: Dataflows Version: 2.2.11 State: Enabled manageentities Name: Entities portal Version: 4.0.0 State: Installed / not activated financialreports Name: Financial reports Version: 3.0.0 State: Installed / not activated glpiinventory Name: GLPI Inventory Version: 1.0.0 State: Enabled addressing Name: IP Adressing Version: 3.0.0 State: Installed / not activated mreporting Name: More Reporting Version: 1.8.0 State: Installed / not activated printercounters Name: Printer counters Version: 2.0.0 State: Installed / not activated protocolsmanager Name: Protocols manager Version: 1.4.2 State: Not installed reports Name: Reports Version: 1.14.1 State: Installed / not activated shellcommands Name: Shell Commands Version: 4.0.0 State: Installed / not activated manufacturersimports Name: Suppliers imports Version: 3.0.0 State: Enabled tag Name: Tag Management Version: 2.9.0 State: Enabled typology Name: Typologies Version: 3.0.0 State: Installed / not activated useditemsexport Name: Used items export Version: 2.5.0 State: EnabledAnything else?
No response