pluginsglpi / addressing Goto Github PK
View Code? Open in Web Editor NEWPlugin addressing for GLPI
License: GNU General Public License v2.0
Plugin addressing for GLPI
License: GNU General Public License v2.0
Version of GLPI : 9.2
Version of plugin : 2.6.1
I would like to know why it is not possible to reserve an IP adress when I ask to ping IP for the report.
Works fine when I don't use the ping tool for the report.
Any tips
Hello,
I tried to install the IP Report plugin on my GLPI / FI server, but unsuccessfully.
I downloaded the proper version from github, unzipped it onto /var/..../glpi/plugins but the plugin does not appear in Configuration/Plugins on the GLPI web interface.
I tried with GLPI 0.85 and GLPI 0.90.5, same result.
This is very strange as I already have plugins enabled on GLPI.
Is this bug known ? If so, is there a way to solve this issue ?
Is it possible to include items created by the Generic Objects plugin with an assigned IP address, please?
I've just installed this plugin in a fresh glpi install 9.2.1 con centos 7.
Plugin is showed as described in object. Clean action lead to nothing, refreshing plugin page after bit it is showed in the same state.
Php error log :
2018-03-13 11:46:47 [[email protected]]
*** PHP Warning(2): include_once(/usr/share/glpi/plugins/addressing/setup.php): failed to open stream: Permission denied
Backtrace :
inc/plugin.class.php:257
inc/plugin.class.php:257 include_once()
inc/plugin.class.php:398 Plugin->checkStates()
front/plugin.php:95 Plugin->listPlugins()
2018-03-13 11:46:47 [[email protected]]
*** PHP Warning(2): include_once(): Failed opening '/usr/share/glpi/plugins/addressing/setup.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php')
Backtrace :
inc/plugin.class.php:257
inc/plugin.class.php:257 include_once()
inc/plugin.class.php:398 Plugin->checkStates()
front/plugin.php:95 Plugin->listPlugins()
2018-03-13 11:46:47 [[email protected]]
From Plugin::getInfo() in /usr/share/glpi/inc/plugin.class.php line 1373
plugin_version_addressing method must be defined!
System :
GLPI 9.2.1 (/glpi => /usr/share/glpi)
Installation mode: RPM
Operating system: Linux glpi.local.domain.com 3.10.0-693.21.1.el7.x86_64 #1 SMP Wed Mar 7 19:03:37 UTC 2018 x86_64
PHP 7.2.3 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, 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, pdo_sqlite, posix, session, shmop, sockets, sqlite3, standard, sysvmsg,
sysvsem, sysvshm, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="30" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files"
upload_max_filesize="2M"
Software: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.2.3 ()
Mozilla/5.0 (X11; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0
Server Software: MariaDB Server
Server Version: 5.5.56-MariaDB
Server SQL Mode:
Parameters: [email protected]/glpi
Host info: 127.0.0.1 via TCP/IP
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
OK/etc/glpi : OK
OK/var/lib/glpi/files : OK
OK/var/lib/glpi/files/_dumps : OK
OK/var/lib/glpi/files/_sessions : OK
OK/var/lib/glpi/files/_cron : OK
OK/var/lib/glpi/files/_graphs : OK
OK/var/lib/glpi/files/_lock : OK
OK/var/lib/glpi/files/_plugins : OK
OK/var/lib/glpi/files/_tmp : OK
OK/var/lib/glpi/files/_cache : OK
OK/var/lib/glpi/files/_rss : OK
OK/var/lib/glpi/files/_uploads : OK
OK/var/lib/glpi/files/_pictures : OK
OK/var/log/glpi : OK
Web access to files directory is protectedWeb access to files directory is protected : OK
OKSELinux mode is Enforcing
OKSELinux boolean configuration for httpd_can_network_connect --> on
OKSELinux boolean configuration for httpd_can_network_connect_db --> on
OKSELinux 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.13 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: 'local.domain.com', Port: '389', BaseDN: 'ou=local,dc=local,dc=domain,dc=com', Connection filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN: '[email protected]', Use TLS: none
Not active
Way of sending emails: PHP
appliances Name: Appliances Version: 2.3.1 State: Enabled
addressing Name: IP Adressing Version: 2.6.1 State: To be cleaned
archires Name: Network Architectures Version: 2.5.0 State: Enabled
ocsinventoryng Name: OCS Inventory NG Version: 1.4.3 State: Enabled
Host: 192.168.0.1
Connection: Ok
Use the OCSNG software dictionary: No
thx for all
Alessio
Hi my friend,
The plugin search the IP adress in machines / network but not in PDU...
Thanks for you help
On GLPI 9.1, IP Addressing ver 2.4
Unable to reserve IP, error
PHP Notice: Undefined index: id in .../inc/reservedip.class at line 105
(I know, not compatible yet)
Bonjour, apres avoir fait la mise a jour en version 9.1.1 et le nouveau plugin , j'ai des erreurs http500...
Je vois bien ces traces d'erreurs mais je ne sais pas quoi faire...
Pouvez vous m'aider?
merci
[Thu Nov 24 09:22:31.126375 2016] [:error] [pid 1937] [client Y.Y.Y.Y:56524] PHP Fatal error: Uncaught exception 'Zend\I18n\Exception\InvalidArgumentException' with message 'Could not find or open file /var/www/glpi/plugins/addressing/locales/ for reading' in /var/www/glpi/vendor/zendframework/zend-i18n/src/Translator/Loader/Gettext.php:49\nStack trace:\n#0 /var/www/glpi/vendor/zendframework/zend-i18n/src/Translator/Translator.php(700): Zend\I18n\Translator\Loader\Gettext->load('language', '/var/www/glpi/p...')\n#1 /var/www/glpi/vendor/zendframework/zend-i18n/src/Translator/Translator.php(572): Zend\I18n\Translator\Translator->loadMessagesFromFiles('addressing', 'language')\n#2 /var/www/glpi/vendor/zendframework/zend-i18n/src/Translator/Translator.php(440): Zend\I18n\Translator\Translator->loadMessages('addressing', 'language')\n#3 /var/www/glpi/vendor/zendframework/zend-i18n/src/Translator/Translator.php(388): Zend\I18n\Translator\Translator->getTranslatedMessage('IP Adressing', 'language', 'addressing')\n#4 /var/www/glpi/inc/autoload.function.php(171): Zend\I18n\Translator\Translator->translatePlural('IP in /var/www/glpi/vendor/zendframework/zend-i18n/src/Translator/Loader/Gettext.php on line 49, referer: https://X.X.X.X/
Great plugin - I'm still having trouble setting up the IP reservation. There is a "reserve" designator but it doesn't really seem to set anything in the database with a 'reserved' flag. Running GLPI 9.1.1 - fusioninventory and assists are being queried correctly and show in the IP report.
"If in GLPI, you declare the name of a port of equipment (except network hardware) with the string “reserve” within its name, the IP will appear in the plugin as reserved."
So to be clear, I need to create phantom ports someplace and then add 'reserve' to the port name?
If this isn't the correct place for functional questions please direct. Thank you
Hello,
I'm not sure it's a bug but since GLPI 9.4.1.1 I can't use fping anymore. After a few search, I must enter fullpath to exec command :
exec("/usr/sbin/fping -r1 -c1 -t100 ".$ip, $list);
And I have this message at the end of report
Without that, it dosen't work.
Any idea / workaround ?
Thanks for you help !
I have many PHP errors like this :
glpiphplog.WARNING: *** PHP Warning (2): include(): Failed opening '/glpi/plugins/addressing/ajax/seePingTab.php' for inclusion ....
And the "Save" button disapear in the computers form.
I installed this plugin from the marketplace.
The problem is in the pinginfo.class.php file :
The same with the line 224, there is :
include(GLPI_ROOT . "/plugins/addressing/ajax/seePingTab.php");
i replace this line qith :
include(GLPI_ROOT . "/marketplace/addressing/ajax/seePingTab.php");
Hello,
GLPI 9.2.1 is hosted in IIS on Windows Server 2008 R2. If we try to ping equipment, it shows an error message related to the -c parameter that is not supported. Well, on Windows systems it true.
Has a work around I switch Case 0 and Case 1 from ping_equipment.class.php. So it's working now, but I'just want to make sure that it won't affect anything else - I guess not ?!
function ping($system, $ip) {
$error = 1;
$list ='';
switch ($system) {
case 0 :
//windows
exec("ping.exe -n 1 -w 1 -i 4 ".$ip, $list, $error);
break;
case 1 :
// linux ping
exec("ping -c 1 -w 1 ".$ip, $list, $error);
break;
Hello,
I get the following message while trying to reserve an IP address:
PHP Fatal error: Uncaught Error: Class 'Event' not found in /var/www/glpi-9.4.3/plugins/addressing/inc/reserveip.class.php:125\nStack trace:\n#0 /var/www/glpi-9.4.3/plugins/addressing/front/reserveip.form.php(36): PluginAddressingReserveip->reserveip(Array)\n#1 {main}\n thrown in /var/www/glpi-9.4.3/plugins/addressing/inc/reserveip.class.php on line 125, referer: http://fqdn/plugins/addressing/front/addressing.form.php?id=5
Furthemore, even when commenting out these lines, the reservation doesn't work.
We are using GLPI 9.4.3.
Thanks a lot.
website link in setup - plugins goes not to github. at the old repository are only old versions.
(this is the way i check for new updates....)
When I add a reservation I have a blank page with this url : http://glpiserv/plugins/addressing/front/reserveip.form.php.
GLPI version : 9.4.5
Plugin addressing version : 2.8.0
I have added a item in assets->computers , but i couldn't find it in addressing
Hi,
How to install addressing plugin with GLPI 9.1 ? or maybe better to wait new release ?
Thanks in advance
Hello there, please see my post in the GLPI forum - https://forum.glpi-project.org/viewtopic.php?pid=490104#p490104
I really like the addressing plugin but am missing some client-based functionality as described in the post. Do you see a chance to incorporate such features in future development of the addressing plugin, or would you recommend me to make my own?
Hello,
I have a network equipment on which I added several IP addresses on its ethernet port. But they are not displayed as used (or reserved) on the IP report.
Is there a trick to achieve this?
Thanks a lot.
We are currently creating an GLPI 10 System.
The service is hosted inside our local DMZ.
It has no Connection from DMZ to our local networks. But a communication from local to DMZ is possible through a firewall.
This means the glpi plugin can not ping IP Subnet outside the DMZ directly.
Do you have a solution for this?
I can only think of an agent like glpi-inventory pulling the order to ping for used IPs.
But it is far from being convenient as this plugin is capable of.
Does anyone have a suggestion to establish an IPAM with our szenario?
Hello,
How to make an IP report per site ?
regards
If a device or computer has a network port with no name defined, or just a "0", it won't show up on the report list. Adding a name or changing it from something other than "0" then displays on the listing. Possible data type problem?
Hello,
Plugin is no longer working in version 9.5+3.0 :
PHP Notice: Undefined index: totalcount in /var/www/glpi/inc/search.class.php on line 136, referer: https://XXX/plugins/addressing/front/addressing.php
Crash on this line :
136 : if ($data['data']['totalcount'] > 0) {
$data['data'] is an empty var.
Hi, is that possible to implement arp-scan instead of ping ?
some pc have firewall that blocks icmp ..
Hello,
We are using the plugin with success so far!
We have an issue regarding the access. If a user is not admin
or super-admin
, the menu is not display and can't access the plugin.
How is it working since I can be good to allow user to see or use it without have all right on the entity or everything.
Best regards
Dear
Is it possible to create a rule of assigning computers to an entity based on the IP addressing name not the from IP address.
Thanks
Changing the export of IP
We are setting up GLPI for the first time and are running the latest version. Will the IP addressing plugin be available for GLPI version 9.3 soon?
Hi, I try reserve an IP and had a error, sql-errors.log file said:
[2019-10-22 13:35:34] glpisqllog.ERROR: DBmysql::query() in /home/company/www/glpi/inc/dbmysql.class.php line 188
*** MySQL query error:
SQL: SHOW COLUMNS FROM glpi_plugin_addressing_reserveips
Error: Table 'glpi.glpi_plugin_addressing_reserveips' doesn't exist
Backtrace :
inc/dbmysql.class.php:431
inc/commondbtm.class.php:557 DBmysql->list_fields()
inc/commondbtm.class.php:3007 CommonDBTM->getEmpty()
inc/commondbtm.class.php:2920 CommonDBTM->isEntityAssign()
inc/commondbtm.class.php:2018 CommonDBTM->checkEntity()
inc/commondbtm.class.php:2803 CommonDBTM->canCreateItem()
inc/commondbtm.class.php:2899 CommonDBTM->can()
plugins/addressing/front/reserveip.form.php:35 CommonDBTM->check()
{"user":"6@glpiocs","mem_usage":"0.000", 4.92Mio)"}
I didn't find any .sql in script about this table
Error to open
PHP Notice: Use of undefined constant PHP_INT_MIN - assumed 'PHP_INT_MIN' in /usr/share/glpi/plugins/addressing/inc/report.class.php at line 313
Update plugin for glpi 9.2
Thank you very much.
Hello,
I'm using GLPI 9.2.1 with the plugin Addressing 2.6.0.
Before I upgraded from 9.1.6 with plugin 2.5.0, everything worked well.
Now, when I generate my reports, the column IP is empty. When I switch on the debug mode, I can see this PHP Warning:
I've tested to add a Network on my computers
The two computers (S2LApp2, S2LApp3) which have the Network filled are displayed, but without IP.
The other computer which have no Network are not displayed at all.
When I try to generate a report for an other ip range, with Devices and not Computer, the same error occurs:
I cannot reserve an IP address from any of the defined ranges. Tested in 2.7.1 (with glpi 9.3) and 2.8.0 (whit glpi 9.4.5).
It seems that everything is correct but when I return to the report screen it continues to appear in blue color and with the reservation option enabled.
When a network port is deleted the field "is_deleted = 1" (table glpi_networkports), but the plugin doesn't control this and show several records in red as if the IP were duplicated.
It is my first time here hope I`m note posting in the wrong place, but it does not work with glpi 9.1, I tried to install like I install several times like I install the other pluggins and nothing.
thank you
When I try to upgrade the plugin for GLPI 9.3, after clicking the Upgrade button from Setup -> Plugins, I receive a 500 internal server error.
This appears in the Apache error log:
PHP Fatal error: Uncaught Error: Call to undefined method DbUtils::getAllDatasFromTable() in /var/www/glpi93/plugins/addressing/inc/profile.class.php:184\nStack trace:\n#0 /var/www/glpi93/plugins/addressing/hook.php(124): PluginAddressingProfile::migrateProfiles()\n#1 /var/www/glpi93/inc/plugin.class.php(701): plugin_addressing_install()\n#2 /var/www/glpi93/front/plugin.form.php(47): Plugin->install('4')\n#3 {main}\n thrown in /var/www/glpi93/plugins/addressing/inc/profile.class.php on line 184, referer: http://***/front/plugin.php
When adding more than 32 records in a subnet/24, only the first 32 records are shown.
No more reservations, no more assinged computer/network devices.
Issue is shown at GLPI 9.1.6 / addressing 2.5.0 and GLPI 9.2 / addressing 2.6.0
Thanks for checking
This plugin needs a release update for 9.1
Hi !
sorry for my bad English!
I have machine that have ip address . now I delete machine and I want to free ip address
how can I do that?
Hello,
I have two problems with addressing 2.9.0
I have upgraded GLPI to 9.5 and update adressing 2.8.0 -> 2.9.0 and now, IP reservation doesn't work and all IP disappear.
Any Idea ?
(GLPI 9.4.3 and addressing 2.8.0 works)
Thanks for helps ;)
When i open a report the IP adress collumn is empty even if IP address exist.
Plug in version 2.5.0
GLPI Version 9.1.6
Hello,
Suddenly our addressing plugin stopped working as usual.
Previously it was showing computer names on ip ranges but now isn't.
In file /var/www/html/glpi/files/_log/sql-errors.log shows:
2017-04-10 17:05:05 [273@servername]
*** MySQL query error:
SQL: SELECT `port`.`id`,
\'NetworkEquipment\' AS itemtype,
`dev`.`id` AS on_device,
`dev`.`name` AS dname,
\'\' AS pname,
`glpi_ipaddresses`.`name` as ip,
`port`.`mac`,
`dev`.`users_id`,
INET_ATON(`glpi_ipaddresses`.`name`) AS ipnum
FROM `glpi_networkports` port
LEFT JOIN `glpi_networkequipments` dev ON (`port`.`items_id` = `dev`.`id`
AND `port`.`itemtype` = \'NetworkEquipment\')
LEFT JOIN `glpi_networknames` ON (`port`.`id` = `glpi_networknames`.`items_id`)
LEFT JOIN `glpi_ipaddresses` ON (`glpi_ipaddresses`.`items_id` = `glpi_networknames`.`id`)
WHERE INET_ATON(`glpi_ipaddresses`.`name`) >= \'181923841\'
AND INET_ATON(`glpi_ipaddresses`.`name`) <= \'181923845\'
AND `dev`.`is_deleted` = 0
AND `dev`.`is_template` = 0 UNION SELECT `port`.`id`,
\'Computer\' AS `itemtype`,
`port`.`items_id`,
`dev`.`name` AS dname,
`port`.`name` AS pname,
`glpi_ipaddresses`.`name` as ip,
`port`.`mac` ,`dev`.`users_id` , INET_ATON(`glpi_ipaddresses`.`name`) AS ipnum FROM `glpi_networkports` port
LEFT JOIN `glpi_computers` dev ON (`port`.`items_id` = `dev`.`id`
AND `port`.`itemtype` = \'Computer\')
LEFT JOIN `glpi_networknames` ON (`port`.`id` = `glpi_networknames`.`items_id`)
LEFT JOIN `glpi_ipaddresses` ON (`glpi_ipaddresses`.`items_id` = `glpi_networknames`.`id`)
WHERE INET_ATON(`glpi_ipaddresses`.`name`) >= \'181923841\'
AND INET_ATON(`glpi_ipaddresses`.`name`) <= \'181923845\' AND `dev`.`is_deleted` = \'0\' AND `dev`.`is_template` = \'0\' UNION SELECT `port`.`id`,
\'NetworkEquipment\' AS `itemtype`,
`port`.`items_id`,
`dev`.`name` AS dname,
`port`.`name` AS pname,
`glpi_ipaddresses`.`name` as ip,
`port`.`mac` ,`dev`.`users_id` , INET_ATON(`glpi_ipaddresses`.`name`) AS ipnum FROM `glpi_networkports` port
LEFT JOIN `glpi_networkequipments` dev ON (`port`.`items_id` = `dev`.`id`
AND `port`.`itemtype` = \'NetworkEquipment\')
LEFT JOIN `glpi_networknames` ON (`port`.`id` = `glpi_networknames`.`items_id`)
LEFT JOIN `glpi_ipaddresses` ON (`glpi_ipaddresses`.`items_id` = `glpi_networknames`.`id`)
WHERE INET_ATON(`glpi_ipaddresses`.`name`) >= \'181923841\'
AND INET_ATON(`glpi_ipaddresses`.`name`) <= \'181923845\' AND `dev`.`is_deleted` = \'0\' AND `dev`.`is_template` = \'0\' UNION SELECT `port`.`id`,
\'Peripheral\' AS `itemtype`,
`port`.`items_id`,
`dev`.`name` AS dname,
`port`.`name` AS pname,
`glpi_ipaddresses`.`name` as ip,
`port`.`mac` ,`dev`.`users_id` , INET_ATON(`glpi_ipaddresses`.`name`) AS ipnum FROM `glpi_networkports` port
LEFT JOIN `glpi_peripherals` dev ON (`port`.`items_id` = `dev`.`id`
AND `port`.`itemtype` = \'Peripheral\')
LEFT JOIN `glpi_networknames` ON (`port`.`id` = `glpi_networknames`.`items_id`)
LEFT JOIN `glpi_ipaddresses` ON (`glpi_ipaddresses`.`items_id` = `glpi_networknames`.`id`)
WHERE INET_ATON(`glpi_ipaddresses`.`name`) >= \'181923841\'
AND INET_ATON(`glpi_ipaddresses`.`name`) <= \'181923845\' AND `dev`.`is_deleted` = \'0\' AND `dev`.`is_template` = \'0\' UNION SELECT `port`.`id`,
\'Phone\' AS `itemtype`,
`port`.`items_id`,
`dev`.`name` AS dname,
`port`.`name` AS pname,
`glpi_ipaddresses`.`name` as ip,
`port`.`mac` ,`dev`.`users_id` , INET_ATON(`glpi_ipaddresses`.`name`) AS ipnum FROM `glpi_networkports` port
LEFT JOIN `glpi_phones` dev ON (`port`.`items_id` = `dev`.`id`
AND `port`.`itemtype` = \'Phone\')
LEFT JOIN `glpi_networknames` ON (`port`.`id` = `glpi_networknames`.`items_id`)
LEFT JOIN `glpi_ipaddresses` ON (`glpi_ipaddresses`.`items_id` = `glpi_networknames`.`id`)
WHERE INET_ATON(`glpi_ipaddresses`.`name`) >= \'181923841\'
AND INET_ATON(`glpi_ipaddresses`.`name`) <= \'181923845\' AND `dev`.`is_deleted` = \'0\' AND `dev`.`is_template` = \'0\' UNION SELECT `port`.`id`,
\'Printer\' AS `itemtype`,
`port`.`items_id`,
`dev`.`name` AS dname,
`port`.`name` AS pname,
`glpi_ipaddresses`.`name` as ip,
`port`.`mac` ,`dev`.`users_id` , INET_ATON(`glpi_ipaddresses`.`name`) AS ipnum FROM `glpi_networkports` port
LEFT JOIN `glpi_printers` dev ON (`port`.`items_id` = `dev`.`id`
AND `port`.`itemtype` = \'Printer\')
LEFT JOIN `glpi_networknames` ON (`port`.`id` = `glpi_networknames`.`items_id`)
LEFT JOIN `glpi_ipaddresses` ON (`glpi_ipaddresses`.`items_id` = `glpi_networknames`.`id`)
WHERE INET_ATON(`glpi_ipaddresses`.`name`) >= \'181923841\'
AND INET_ATON(`glpi_ipaddresses`.`name`) <= \'181923845\' AND `dev`.`is_deleted` = \'0\' AND `dev`.`is_template` = \'0\' UNION SELECT `port`.`id`,
\'PluginFusioninventoryUnmanaged\' AS `itemtype`,
`port`.`items_id`,
`dev`.`name` AS dname,
`port`.`name` AS pname,
`glpi_ipaddresses`.`name` as ip,
`port`.`mac` ,`dev`.`users_id` , INET_ATON(`glpi_ipaddresses`.`name`) AS ipnum FROM `glpi_networkports` port
LEFT JOIN `glpi_plugin_fusioninventory_unmanageds` dev ON (`port`.`items_id` = `dev`.`id`
AND `port`.`itemtype` = \'PluginFusioninventoryUnmanaged\')
LEFT JOIN `glpi_networknames` ON (`port`.`id` = `glpi_networknames`.`items_id`)
LEFT JOIN `glpi_ipaddresses` ON (`glpi_ipaddresses`.`items_id` = `glpi_networknames`.`id`)
WHERE INET_ATON(`glpi_ipaddresses`.`name`) >= \'181923841\'
AND INET_ATON(`glpi_ipaddresses`.`name`) <= \'181923845\' AND `dev`.`is_deleted` = \'0\' UNION SELECT `port`.`id`,
\'PluginGenericobjectElectrocardiografo\' AS `itemtype`,
`port`.`items_id`,
`dev`.`name` AS dname,
`port`.`name` AS pname,
`glpi_ipaddresses`.`name` as ip,
`port`.`mac` ,`dev`.`users_id` , INET_ATON(`glpi_ipaddresses`.`name`) AS ipnum FROM `glpi_networkports` port
LEFT JOIN `glpi_plugin_genericobject_electrocardiografos` dev ON (`port`.`items_id` = `dev`.`id`
AND `port`.`itemtype` = \'PluginGenericobjectElectrocardiografo\')
LEFT JOIN `glpi_networknames` ON (`port`.`id` = `glpi_networknames`.`items_id`)
LEFT JOIN `glpi_ipaddresses` ON (`glpi_ipaddresses`.`items_id` = `glpi_networknames`.`id`)
WHERE INET_ATON(`glpi_ipaddresses`.`name`) >= \'181923841\'
AND INET_ATON(`glpi_ipaddresses`.`name`) <= \'181923845\' AND `dev`.`is_deleted` = \'0\'
Error: Unknown column 'dev.users_id' in 'field list'
Backtrace :
plugins/addressing/inc/addressing.class.php:385
plugins/addressing/inc/addressing.class.php:413 PluginAddressingAddressing->compute()
plugins/addressing/inc/addressing.class.php:514 PluginAddressingAddressing->showReport()
inc/commonglpi.class.php:465 PluginAddressingAddressing::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
How can we fix this? Can we upload any aditional info?
Thanks.
Hi
My problem is Ip addressing is not recursive. I created some reports in the root entity but not visible in the sub entities
Thanks
When i try to install plugin IP Report in GLPI 9.5.3, my GLPI server don't see plugin in plugin section. I install plugin in
"/web/glpi/marketplace/" repository in my Synology nas.
Thanks for your help.
Added two fields.
Addition of the location and the domain internet:
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.