RackTables bug tracker - Issues

2107: Deleting an IPv4Network with VLANIPv4 assigned results in error: FK violation

Tue, 14 Jan 2025 15:21:24 +0100

After assigning a VLAN to an IPv4 network (probably IPv6 too?), we can't simply delete the network - without first unlinking it from the VLAN.
The error returned is a FK violation, which is not very user-friendly, but what I'd expect is the resource to be deleted along with all related entity links, as it happens with other resources.

2105: database tables can't be created on MySQL >= 8.4 because KEY is not unique

Mon, 23 Dec 2024 16:51:16 +0100

When using MySQL 8.4 or higher, there are a few tables that can't be created because a Key is not unique and there is a foreign key that references it, and from MySQL 8.4 it's not allowed to reference non-unique KEYs.

the keys that are bad (not UNIQUE) are:
Object.id-tid
TagTree.id-is_assignable

The fix:
ALTER TABLE Object DROP KEY `id-tid`, ADD UNIQUE KEY `id-tid` (`id`,`objtype_id`);
ALTER TABLE TagTree DROP KEY `id-is_assignable`, ADD UNIQUE KEY `id-is_assignable` (`id`,`is_assignable`);

2103: Patchpanel Ports could only be assigned 1 time

Wed, 02 Oct 2024 13:31:39 +0200

The Patchpanel Port could only be assigned 1 time.
It would be great if you could assign them 2 time.

First assigenment:
device to patchpanel

Second assignment
patchpanel to switch

2093: Link between virtual switch/physical switch

Mon, 26 Aug 2024 23:25:23 +0200

Hello,

we want to link Virtual Machine to Virtual Switch and this Virtual Switch to Physical switch. How it is possible? Because on Virtual switch we cannot link port to physical switch and on VM we cannot link port to virtual switch.

In compatible spare ports we didn't see any port. Any suggestion?

Thanks

2097: Feature Request - display HardDisks per server

Wed, 10 Jul 2024 16:33:46 +0200

Ability to have a table for several HDDs per server (similar to the IP address/network port table).
e.g.
Server1 has
- 4 NVMe with 512GB
- 16 SAS SSDs with 2.4TB

2081: RackTables installation: step 5 of 7

Tue, 12 Mar 2024 21:53:03 +0100

http://localhost/racktables/wwwroot/?module=installer

RackTables installation: step 5 of 7
Your database is already holding 74 tables, so I will stop here and let you check it yourself.
There is some important data there probably.

borre la base y la cree de nuevo, borre las tablas probe varias formas, pero siempre quedo en el paso 5 de 7, las tablas se crean automaticamente

2095: Feature Request: Add IIFs

Tue, 12 Mar 2024 21:26:15 +0100

Hi,
please add the following inner interface types:
QSFP-DD
OASFP

it would be very convinient to be able to add IIFs or edit the list of Inner Interface Types.

Thank you very much
Thomas

2083: Search for WWPN/WWNN works only if colons are removed

Fri, 26 Jan 2024 18:14:06 +0100

Searching for WWPN doesn't work if colons are included.
e.g.
A search for 21:00:00:e0:8b:05:05:04 returns: Nothing found for '21:00:00:e0:8b:05:05:04'
A search for 210000e08b050504 takes us right to the correct port.

Annoying as the colon notation is how Racktables displays the WWPN addresses. It was only upon looking into the database that I saw they are stored without punctuation and tried to search that way, successfully.

Less importantly, some equipment reports WWPNs without colons, but with a leading "0x". e.g.: 0x210000F08B050504
It would be desirable for search to handle that notation as well.

With (shorter) MAC addresses, search handles similar colon notation as well as periods (Cisco) properly.

2087: Unable To Connect Front to Back Ports

Wed, 06 Dec 2023 08:47:23 +0100

When I try to connect front port with back ports in the 'Link Management' section then I receive a error message "PDOException".
Also when I try to connect front port and front port, then I receive the same error message.

Otherwise when I connect the ports within the 'ports' section, then it is working, but I can only connect one to one instead when I use multipe patch panels.

PDOException
SQLSTATE[HY000]: General error: 1442 Can't update table 'port' in stored function/trigger because it is already used by statement which invoked this stored function/trigger (HY000)
at file /var/www/racktables/wwwroot/inc/database.php, line 3940

/var/www/racktables/wwwroot/inc/database.php:3940 execute()
/var/www/racktables/plugins/linkmgmt/plugin.php:4069 usePreparedInsertBlade()
/var/www/racktables/plugins/linkmgmt/plugin.php:3990 linkmgmt_linkPorts()
/var/www/racktables/wwwroot/inc/functions.php:5679 linkmgmt_oplinkPort()
/var/www/racktables/plugins/linkmgmt/plugin.php:4098 getOutputOf()
/var/www/racktables/wwwroot/inc/functions.php:6032 linkmgmt_opPortLinkDialog()
/var/www/racktables/wwwroot/index.php:238 universalOpHandler()
Error info:
Array
(
[0] => HY000
[1] => 1442
[2] => Can't update table 'port' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
)
Parameters:
GET
(array)
module redirect
page object
tab linkmgmt
object_id 131
allports 1
op PortLinkDialog
port 1831
linktype front
POST
(array)
port 1831
filter-obj
filter-port
in_rack 1
remote_object 461
remote_ports
(array)
0 7174
cable
do_link Link front
COOKIE
(array)
__cmpcpcu7702 __51__
__cmpconsent7702 BP0LbLkP0LbLkAfSABDEABAAAAAAAA
__cmpcvcu7702 __s23_s2612_s1409_s24_s1475_s893_c43145_c2838_c2837_U__
PHPSESSID 67m3rkvea2vi8or7h0qtn5c8ls

2091: Cannot link device in different racks

Sun, 19 Nov 2023 22:43:02 +0100

Hi all,
is there a way to link devices in different racks that are in different locations ?
I have a datacenter with four rooms(manged with location in racktables),
every room have 6 rows of racks and every row have 10 racks.
Now in the room A row 1 rack 1 there is a router and I want to link a port to a device's port located in room B row 1 rack 1.
Changed the proximity from 0 to different value but there is no way to have in the window to link the port a list of ports not in the same row.

2079: Configuration SNMP switch

Sun, 09 Apr 2023 18:51:40 +0200

Hi,
I plugged in a Cissco Catalist 2960X-48FPD-L switch configured community snmp v2c but it always returns "Fatal SNMP failure".
I have also done the same configuration with some Alcatel switches for testing but I still get the same error.
Could you help me identify the problem?
Thanks

2077: Change color or image of the rack - add logo organization

Sat, 25 Mar 2023 23:14:56 +0100

Hi,
could you help me understand how I can change the background color or the image of the racks in the "Rackspace" page
then how to insert a logo instead of the name of the organization
thank you and congratulations for the excellent work.

2071: Helpdesk Banner usage not consistent

Tue, 21 Mar 2023 22:37:38 +0100

The Helpdesk Banner which can be added to the bottom of exceptions is not included in all instances

2075: Unknown OID '11.2.3.7.11.182.21' Aruba JL357A 2540-48G-PoE+-4SFP+ Switch

Fri, 16 Dec 2022 09:44:43 +0100

Hello together,

I always get the Error "Unknown OID '11.2.3.7.11.182.21' " when I do the SNMP sync on an Aruba JL357A 2540-48G-PoE+-4SFP+ Switch.

Must I add the MIB Information somewhere manual?

Best regards,
Martin

1899: Documentation on plugin upgrade code is not clear

Mon, 31 Oct 2022 17:29:57 +0100

When looking through the plugin upgrade code, the documentation makes reference to pluign_PLUGINNAME_install, etc. It then gives an example of upgrade code for 'myplugin' as:

Example modeled after the core RackTables upgrader:



function plugin_myplugin_upgrade ()

{

	$db_info = getPlugin ('myplugin');

	$v1 = $db_info['db_version'];

	$code_info = plugin_plugin_info ();

	$v2 = $code_info['version'];

2069: Fatal error: Uncaught TypeError: Unsupported operand types when searched a string with three dots.

Mon, 26 Sep 2022 22:11:23 +0200

With Racktables 0.22.0, when searching for a string with three dots, it returns the following error:

"
Fatal error: Uncaught TypeError: Unsupported operand types: string * int in /usr/share/webapps/RackTables/wwwroot/inc/functions.php:2542 Stack trace: #0 /usr/share/webapps/RackTables/wwwroot/inc/functions.php(2647): ip6_parse() #1 /usr/share/webapps/RackTables/wwwroot/inc/functions.php(5043): ip6_checkparse() #2 /usr/share/webapps/RackTables/wwwroot/inc/interface.php(3683): searchEntitiesByText() #3 /usr/share/webapps/RackTables/wwwroot/index.php(43): searchHandler() #4 {main} thrown in /usr/share/webapps/RackTables/wwwroot/inc/functions.php on line 2542
"

With any other number of "dots" in the string, it works fine.

2003: Reports plugin produces line breaks in exported comments (cvs)

Fri, 12 Aug 2022 00:06:45 +0200

This is a report about: https://github.com/RackTables/racktables-contribs/tree/master/

If there is a line break in comments in Rack Tables, it breaks the exported csv.

999: add pictures to objects

Fri, 12 Aug 2022 00:01:50 +0200

I'd like to be able to add pictures to objects, which could be displayed as scaled background of the table cells.

965: Possibility to have an history on objects changes

Wed, 01 Jun 2022 11:16:24 +0200

It would be awesome to have a change tracking system on the objects so that we can know what have been changed on them and by whom at what time.
I think it could be a new tab on each object, like you already did for IP addresses.
What I would like to know, for example is when we upgrade the amount of RAM of a server. Or When we switched it off. Or when we upgraded the operating system. Even, when we unpugged it from one switch and replugged it on another switch. Or when we changed its location from one rack to another.
Everything should be tracked so we have a better control on what has been done in our datacenter. Also, it would prevent us to restore DB each time we made an error in changing something on the object and don't remembering what it was.

Thank you

2043: Unknown OID '.iso.org.dod.internet.private.enterprises.9.1.516' Cisco C3750E

Wed, 28 Jul 2021 14:19:58 +0200

Please add this Switch to object list.

System Informations
sysDescr: Cisco IOS Software, C3750E Software (C3750E-UNIVERSALK9-M), Version 12.2(55)SE5, RELEASE SOFTWARE (fc1) Technical Support: http://www.cisco.com/techsupport Copyright (c) 1986-2012 by Cisco Systems, Inc. Compiled Thu 09-Feb-12 18:14 by prod_rel_team
sysObjectID: .iso.org.dod.internet.private.enterprises.9.1.516

Please let me know if additional informations needed.

Thx lot. Mx.

2041: Unknown OID '9.12.3.1.3.932' Cisco Nexus 7009

Wed, 28 Jul 2021 14:09:40 +0200

Please add this Switch to object list.

SNMPv2-MIB::sysDescr.0 = STRING: Cisco NX-OS(tm) n7000, Software (n7000-s2-dk9), Version 8.2(5), RELEASE SOFTWARE Copyright (c) 2002-2019 by Cisco Systems, Inc. Compiled 8/31/2019 22:00:00
SNMPv2-MIB::sysObjectID.0 = OID: SNMPv2-SMI::enterprises.9.12.3.1.3.932

Please let me know if additional informations needed.

Thx lot. Mx.

2033: Plugins can disable error reporting leading to false negatives

Fri, 23 Jul 2021 13:30:17 +0200

Whilst investigating an issue with LDAP connectivity for a new system, plugins taken from the older system masked the errors being reported. This is because one of them override the PHP error_reporting value and set it to fatal only. This meant warnings and notices went undisplayed and caused a login loop. Later after resolving part of the issue, other errors which had been occurring for some time suddenly became visible highlighting other problems which had not been noticed in the current system as the plugin which disabled the error reporting did not have a problem but another one did which needed to be resolved.

2035: Common Name vs Visible Label

Tue, 13 Jul 2021 17:32:54 +0200

The display name ('dname') applied to $cell is usually taken from $cell['name'] unless it is blank (then the object type is used). However, as common name ($cell['name']) can be quite long, this can be problematic in racks with lots of long FQDN's. There should be an option within the system configuration to allow visible label to be used over common name. I've included the one line change I did to make things much better for my client but this may not be to everyone's taste so a configuration option to control this makes sense.

Additionally, it may be worth having some form of hook to allow plugins to adjust the displayname when needed.

1955: SNMP Sync issue "Unknown OID '11.2.3.7.11.136'

Fri, 09 Jul 2021 21:39:38 +0200

When I try the SNMP Sync with a HP 2530-48G-PoEP Switch (J9772A) it says the following message "Unknown OID '11.2.3.7.11.136'

2015: Datacenter power tracking

Fri, 26 Feb 2021 19:50:04 +0100

As a feature request, a standard fill-in attribute for PSUs/PDUs/UPSs for "Power Rating" and "CircuitID", as well as a calculated attribute "Max Draw". Then, for all other devices that draw power a standard fill-in attribute for "Power Draw". Finally, within the UI, if the sum of the draw of all devices plugged into a PSU/PDU/UPS exceeds its power rating, visually display that there is a problem with the PDU, specifically calling out that the maximum potential draw exceeds the rating for the PDU/UPS