Glpi: History on Simcard Items not working

[Megachip]

---

• Steps to reproduce (which actions have you made) :
  Change something on the simcard item.

• Expected result :
  get an history entry

• Actual result :
  no history entry

• URL of the page :
  front/item_devicesimcard.form.php?id=1

• Screenshot of the problem (if pertinent) :

• Your GLPI setup (you can find it in Setup > General menu, System tab) :

[code]   GLPI 9.2.3 ( => /usr/share/glpi) Installation mode: RPM
--

Operating system: Linux glpi.xxx.com 4.15.3-300.fc27.x86_64 #1 SMP Tue Feb 13 17:02:01 UTC 2018 x86_64 PHP 7.1.18 fpm-fcgi (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bcmath, bz2, calendar, cgi-fcgi, ctype,    curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imagick, imap, intl, json, ldap, libxml, mbstring,  mysqli, mysqlnd, openssl, pcre, pdo_mysql, pdo_sqlite, posix, session, shmop, soap, sockets, sqlite3, standard, sysvmsg,    sysvsem, sysvshm, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zlib) Setup: max_execution_time="30" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files"  upload_max_filesize="10M"  Software: Apache/2.4.33 (Fedora) OpenSSL/1.1.0h-fips ()  Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1.2 Safari/605.1.15 Server Software: MariaDB Server     Server Version: 10.2.14-MariaDB     Server SQL Mode:    Parameters: glpi@localhost/glpidb   Host info: Localhost via UNIX socket     mysqli extension is installed ctype extension is installed fileinfo extension is installed json extension is installed mbstring extension is installed zlib extension is installed curl extension is installed gd extension is installed simplexml extension is installed xml extension is installed ldap extension is installed imap extension is installed Zend OPcache extension is installed APCu extension is installed xmlrpc extension is installed /etc/glpi : OK /var/lib/glpi/files : OK /var/lib/glpi/files/_dumps : OK /var/lib/glpi/files/_sessions : OK /var/lib/glpi/files/_cron : OK /var/lib/glpi/files/_graphs : OK /var/lib/glpi/files/_lock : OK /var/lib/glpi/files/_plugins : OK /var/lib/glpi/files/_tmp : OK /var/lib/glpi/files/_cache : OK /var/lib/glpi/files/_rss : OK /var/lib/glpi/files/_uploads : OK /var/lib/glpi/files/_pictures : OK /var/log/glpi : OK SELinux mode is Enforcing SELinux boolean configuration for httpd_can_network_connect --> on SELinux boolean configuration for httpd_can_network_connect_db --> on SELinux boolean configuration for httpd_can_sendmail --> on

htmLawed version 1.2.4 in (/usr/share/php/htmLawed) phpCas version 1.3.5 in (/usr/share/pear) PHPMailer version 5.2.26 in (/usr/share/php/PHPMailer) SimplePie version 1.5.1 in (/usr/share/php/php-simplepie) TCPDF version 6.2.17 in (/usr/share/php/tcpdf) michelf/php-markdown in (/usr/share/php/Michelf) true/punycode in (/usr/share/php/TrueBV) iacaml/autolink in (/usr/share/php/php-iamcal-lib-autolink) sabre/vobject in (/usr/share/php/Sabre/VObject4)

Server: 'ucs.xxx.com', Port: '389', BaseDN: 'dc=xxx,dc=com', Connection filter:         '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN:        'cn=glpi,cn=Computers,dc=xxx,dc=com', Use TLS: '1' Server: 'ipa.xxx.com', Port: '636', BaseDN: 'dc=xxx,dc=com', Connection filter: none, RootDN: none, Use TLS: none Server: 'ucs.xxx.com', Port: '7389', BaseDN: 'dc=xxx,dc=com', Connection filter: none, RootDN:         'uid=ldapsearch,cn=users,dc=xxx,dc=com', Use TLS: '1'

Not active

Way of sending emails: SMTP+TLS ([email protected]@smtp.gmail.com)

Name: '[email protected]' Active: Yes    Server: '{imap.gmail.com:993/imap/ssl/novalidate-cert}INBOX' Login: '[email protected]' Password: Yes

accounts             Name: Accounts                       Version: 2.3.2      State: Enabled    fields               Name: Additionnal fields             Version: 1.7.0      State: Enabled    appliances           Name: Appliances                     Version: 2.3.2      State: Enabled    financialreports     Name: Asset situation                Version: 2.4.1      State: Enabled    behaviors            Name: Behaviours                     Version: 2.0.2      State: Enabled    browsernotification  Name: Browser Notification           Version: 1.1.9      State: Enabled    dashboard            Name: Dashboard                      Version: 0.9.3      State: Enabled    dnsinventory         Name: DNS Inventory                  Version: 1.0.0      State: Not activated  domains              Name: Domains                        Version: 1.9.0      State: Enabled    manageentities       Name: Entities portal                Version: 2.2.0      State: New    fusioninventory      Name: FusionInventory                Version: 9.2+2.0    State: Enabled    mod                  Name: GLPI Modifications             Version: 1.1.8      State: Not activated  addressing           Name: IP Adressierung                Version: 2.6.1      State: Enabled    positions            Name: Kartographie                   Version: 4.4.0      State: Enabled    mailanalyzer         Name: Mail Analyzer                  Version: 1.3.8      State: Not installed  resources            Name: Mitarbeiter                    Version: 2.4.3      State: Enabled    monitoring           Name: Monitoring                     Version: 0.90+1.1   State: Not installed  mreporting           Name: More Reporting                 Version: 1.4.1      State: Enabled    moreldap             Name: MoreLDAP                       Version: 0.2.3      State: Not installed  mydashboard          Name: My Dashboard                   Version: 1.5.2      State: Not activated  archires             Name: Network Architectures          Version: 2.5.1      State: Enabled    genericobject        Name: Objects management             Version: 2.5.2      State: Enabled    order                Name: Orders management              Version: 2.0.2      State: Enabled    racks                Name: Rack Gehäuse Verwaltung        Version: 1.8.0      State: Enabled    room                 Name: Raumplan                       Version: 3.1.0      State: Enabled    reports              Name: Reports                        Version: 1.11.3     State: Not activated  manufacturersimports Name: Suppliers imports              Version: 2.0.0      State: Enabled    telegrambot          Name: TelegramBot                    Version: 2.0.0      State: Enabled    webservices          Name: Web Services                   Version: 1.8.0      State: Enabled
[/code]

[Megachip]

BTW, its glpi 9.2.4 (funny bug)

[trasher]

Please try with 9.3.1; 9.2.x is non longer maintained.

[cedric-anne]

Hi,

Same for all item_device elements. Reproduced in 9.3/bugfixes.

Regards

[cedric-anne]

The problem is that history is that the form refers to the relation between an item and a device. When a change is made, an history entry is created on the related item.

It could be possible to also add an history entry on the relation, but it may increase log volumes.
It could be also possible, in order to limit amount of data, to add columns into history table in order to be able to store the relation when an history entry is related to a relation between 2 items.

For now, I do not know what is the best option.

[Megachip]

@cedric-anne But what about relations to the relation? e.g. Line (phone number) to simcard? Or simcard to phone. For me this is necessary which simcard was on which phone.

Do you think this would create such an amount of data?

[cedric-anne]

Hi,

4677 should fix your problem. There is already a huge amount of data on logs table, mainly due to FusionInventory plugin for people using it, so it will not be a problem.

Regards