pluginsglpi / addressing Goto Github PK

View Code? Open in Web Editor NEW

36.0 36.0 19.0 730 KB

Plugin addressing for GLPI

License: GNU General Public License v2.0

CSS 0.83% JavaScript 2.35% PHP 95.88% Shell 0.26% Perl 0.67%

addressing's People

Contributors

Stargazers

Watchers

Forkers

flegastelois matiasnquiroga cbka lgwozniak leangjia p-bo mbs-technologie xshro bentoti milotype cconard96 jacac 99net venkarian ppasserini akorezin esutwo eduardomozart

addressing's Issues

IP reservation not possible when we choose ping IP

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

[GLPI 0.85 & 0.90.5] Plugin not detected

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 ?

Generic Objects Plugin

Is it possible to include items created by the Generic Objects plugin with an assigned IP address, please?

Unable to install - No CSRF compliant clean required [SOLVED]

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

No IP with PDU

Hi my friend,

The plugin search the IP adress in machines / network but not in PDU...

Thanks for you help

Unable to reserve IP

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)

PHP Fatal error

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/

IP Reserve

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

GLPI 9.4.1.1 fping

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 !

[2.9.1] Include error

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 :

line 215, there is :
$CFG_GLPI["root_doc"] . "/plugins/addressing/ajax/seePingTab.php",
I replace this line by :
$CFG_GLPI["root_doc"] . "/marketplace/addressing/ajax/seePingTab.php",

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");

Ping IP unable to detect the proper system

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;

Class 'Event' not found

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 wrong in setup - plugins

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....)

plugin on GLPI 9.2.2 , can not plugin

IP Adressing | 2.6.1 | GPLv2+ | Error / To Clean

Error with reservation

Hi ,

problem with reservation / link IP
As i reserve : Error HTTP 500
it create new item , and IP still show as unused

I create IP on a equipement
still show unused

GLPI 9.4.4

blank page when adding reservation

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

Computers IP address couldn't link to addressing

I have added a item in assets->computers , but i couldn't find it in addressing

Testing on GLPI 9.1

Hi,
How to install addressing plugin with GLPI 9.1 ? or maybe better to wait new release ?
Thanks in advance

More features possible with this plugin?

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?

IP addresses associated with an ethernet port

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.

Request: Scan through Agent outside DMZ (other net-segment)

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?

Problem with ip display

When only free IPs are previewed, the list may be empty.
It displays by default the first 20 results but without taking into account the following search filter:

Report IP by Site

Hello,
How to make an IP report per site ?

regards

Won't display on IP report if Port has no name defined

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?

Undefined index: totalcount

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.

arp-scan instead of ping

Hi, is that possible to implement arp-scan instead of ping ?
some pc have firewall that blocks icmp ..

User right to access plugin

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

Ip addressing

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

Export report ip

Changing the export of IP

search in IP adressing

Dear
When I search for example all items with the ip address starting with 172,I just received one result despite I changed the search criteria. What is the best way to have in the results all IP starting with 172 for example.
Thanks

Will this be available for GLPI version 9.3 soon?

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?

Reserve an IP unavailable table on mysql

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

PHP Notice: Use of undefined constant PHP_INT_MIN

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.

IP field empty and computer not showing

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:

reservation not working

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.

[Bug][GLPI 0.90.5] Control of deleted ports

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.

Doesn`t work with glpi 9.1

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

Order of IP

Hi thanks you for your god job.
Please can you help me with the order of adress when we list all of me network for exemple:
10.1.1.1
10.100.1.1
10.2.1.1
but i would like
10.1.1.1
10.2.1.1
10.100.1.1

Thank you !

Error updaing plugin after GLPI 9.3 upgrade

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

not more than 32 IP addresses shown in report

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

9.1 support

This plugin needs a release update for 9.1

Crashed using glpi 9.4.5

have some problem wity IP addressing plugins, after instal it, configure it, the plugins is crashed and now it has broom icon

did i miss something?

GLPI 9.4.5
Installation mode: RPM
IP Adressing addressing 2.8.0

free ip address from poweroffed machine

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?

IP reservation with GLPI 9.5 and addressing 2.9.0

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 ;)

IP adress field empty

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

Error: Unknown column 'dev.users_id' in 'field list'

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.

Addition of the location and internet domain field in the IP address record

Added the field location and internet domain when booking, which prefilled with the data indicated in the IP address record.

The location and the domain internet will be added when creating the object if they have been indicated.

pluginsglpi / addressing Goto Github PK

addressing's People

Contributors

Stargazers

Watchers

Forkers

addressing's Issues

Recommend Projects

Recommend Topics

Recommend Org