Miss 'operatingsystems_id' from SUSE Linux - Remote Inventory

[smurdza]

Bug reporting acknowledgment

Yes, I read it

Professional support

None

Describe the bug

When i try RemoteInventory from SUSE Linux 10, inventory don't execute it.
When i try use glpi-injector from file /tmp/SERVER1-2025-03-14-18-41-23.xml i get error:

glpi-injector -f /tmp/SERVER1-2025-03-14-18-41-23.xml --url https://serwer.glpi.pl/marketplace/glpiinventory/ --debug
Loading /tmp/SERVER1-2025-03-14-18-41-23.xml...[BCF822F7] DEBUG: Uncompressing received content
ERROR: 500 Internal Server Error, Column 'operatingsystems_id' cannot be null
DEBUG: <?xml version="1.0"?>
<REPLY><ERROR><![CDATA[Column 'operatingsystems_id' cannot be null]]></ERROR></REPLY>
These elements were not sent:
/tmp/SERVER1-2025-03-14-18-41-23.xml

To reproduce

1. Configure remote inventory on master host ( OS RockyLinux 9.5 / GLPI-Agent 1.11-2)
2. Add remote host to remote list SUSE Linux Enterprise Server 10 (i586)
3. Start glpi-agent on master host
4. RemoteHost don't inventory in GLPI.

Expected behavior

RemoteHost will be inventory in GLPI.

Operating system

Linux

GLPI Agent version

v1.11

GLPI version

10.0.18

GLPIInventory plugin or other plugin version

No response

Additional context

SERVER1:~ # uname -a
Linux SERVER1 2.6.16.60-0.21-bigsmp #1 SMP Tue May 6 12:41:02 UTC 2008 i686 i686 i386 GNU/Linux

# cat /etc/*release
SUSE Linux Enterprise Server 10 (i586)
VERSION = 10
PATCHLEVEL = 2
LSB_VERSION="core-2.0-noarch:core-3.0-noarch:core-2.0-ia32:core-3.0-ia32"

[g-bougard]

Hi @smurdza

you should have a server-issue, not directly related to glpi-agent.

This may be an issue related to migration problems or other plugin side-effect.
First start by running a database integrity check on your GLPI database: https://glpi-install.readthedocs.io/en/latest/command-line.html#database-schema-check

Also I'll move your issue in Q&A discussion.

[smurdza]

@g-bougard

I checked:

 php bin/console db:check_schema_integrity --check-all-migrations
Schema data base is OK.

By, i checked xml files and this file don't include 'operatingsystems_id'...

[smurdza]

I used resolv:

if ~/bin is in the path and before /sbin, create an executable ~/bin/dmidecode file with
#! /bin/sh
exec sudo /sbin/dmidecode $*

All data inventory apper in GLPI.