r3921 getDomainVLANs(): rewrite SQL query to speed it up
[racktables] / ChangeLog
1 0.18.5
2 bugfix: attribute map editor was broken (#353)
3 bugfix: speed up IPv4 VLAN selector (by Boris Lytochkin)
4 0.18.4 2010-07-13
5 bugfix: a race condition could be triggered in permissions editor
6 new feature: "any mode" of user port in VLAN switch template
7 new feature: LLDP support for VRP 5.50 software
8 update: improved error handling code
9 update: fixes in 802.1Q
10 0.18.3 2010-06-15
11 bugfix: fix mktemp not working on Slackware (by Rafael Ganascim)
12 bugfix: Nexus 802.1Q fixes
13 bugfix: fix incorrect quoting of port reservation comment
14 new feature: "Live CDP" now works with Nexus devices
15 new feature: Huawei NDP support
16 0.18.2 2010-06-10
17 bugfix: don't restore last opened tab, which won't be permitted anyway
18 update: completely switch to PDO prepared queries (#120)
19 update: don't allow duplicate rack row names (#344)
20 new feature: Live LLDP
21 0.18.1 2010-06-03
22 update: initial SNMP support of Summit switches
23 update: switch from deprecated ereg extension to PCRE (#262)
24 update: don't use deprecated magic_quoes extension (#315)
25 update: switch more tables to InnoDB engine
26 update: removed dependency on SPL extension, which 0.18.0 had introduced
27 0.18.0 2010-05-27
28 new feature: Live CDP (#58)
29 new feature: 802.1Q management (#182, original idea by Justin Ellison)
30 0.17.11 2010-06-14
31 update: usual SNMP updates
32 update: Bulk port form (#321)
33 update: 2960G-8TC SNMP patch by Jonathan Stanton
34 bugfix: updateObject() saves DB records for dict values when not set. (#273)
35 bugfix: argument validation was broken for value of 0 (#272)
36 bugfix: "Add/update multiple ports" did not work (#326)
37 bugfix: "bulk ports" form added more ports, than requested (#340)
38 bugfix: improve compatibility with eDirectory (by Joep van Ingen)
39 bugfix: static filter was hard to reset (#343)
40 0.17.10 2010-05-05
41 update: make object form messages consistent (by Tyler J. Wagner)
42 update: sort object ports in a more reasonable manner
43 update: enable class methods as handlers (by James Tutton)
44 update: better support of Huawei S5300 switches
45 update: better support of Brocade/Foundry FastIron switches
46 update: also list WS-C3524-XL (#320)
47 update: better support of Nexus switches
48 update: maintain filter per page load and isolated per realm (#217)
49 bugfix: ldap cache timestamp fix (#332)
50 bugfix: completely fix ticket:211
51 bugfix: declare charset in HTTP header (#312)
52 bugfix: PHP warning with certain auth setups (#310)
53 bugfix: don't add AC-in port for switches, which don't have it (#316)
54 bugfix: accept MAC addresses returned by newer Catalysts
55 bugfix: IPv4 management page was sometimes broken (#309)
56 0.17.9 2010-02-17
57 new feature: added per-user UI options (ticket:29)
58 new feature: LDAP cache can be disabled now (ticket:247)
59 bugfix: error message was lost on SNMP tab (reported by Tommi Hokkanen)
60 bugfix: expand/collapse links on IPv4 tree view (ticket:308)
61 bugfix: local.php did not work with SNMP
62 bugfix: added error handling to gateway function (ticket:303)
63 bugfix: user's local real name was ignored with LDAP (ticket:252)
64 update: SNMP support for more Catalyst switches
65 0.17.8 2009-12-25
66 bugfix: triggers disable tabs completely now (ticket:211)
67 bugfix: properly delete objects with linked ports (ticket:300)
68 bugfix: completely remove warnings caused by ticket:277 (by Jason Lifsey)
69 update: restore PortCompat editor functionality (ticket:263)
70 update: don't show inacessible links in index (by Jeroen Benda)
71 update: consider permitted VLANs in switchvlans (#302 by Boris Lytochkin)
72 update: regular dictionary update
73 bugfix: ajax code verifier response code bugfix
74 0.17.7 2009-11-09
75 bugfix: work around unbuffered query in ports pop-up (ticket:297)
76 update: add inline mode switcher by Jens Groh (ticket:298)
77 0.17.6 2009-10-31
78 update: voice/video devices
79 bugfix: PHP warning
80 bugfix: escaping of a newly created IPv4 network name (ticket:292)
81 bugfix: generate URLs more friendly for reverse proxies (ticket:246)
82 new feature: "proximity" view in port selector popup (ticket:284)
83 new feature: "$no_asset_tag" autotag (ticket:283)
84 0.17.5 2009-09-16
85 bugfix: corrected reference counters in tag tree
86 bugfix: "cn" autotag was not generated for objects
87 new feature: make text in the "added new object X" message clickable (ticket:280) (by Boris Lytochkin)
88 new feature: support for Ethernet transceivers (ticket:64) and WDM grids
89 new feature: initial support of APC switched rack PDUs (ticket:175)
90 update: power port type was split into input and output (ticket:261)
91 0.17.4 2009-08-13
92 bugfix: remove PHP warnings on IPv4 space management tab (ticket:277)
93 bugfix: work around array_fill_keys() from PHP 5.2 (ticket:278)
94 bugfix: delete real servers on RS pool deletion (ticket:233)
95 bugfix: "Same type, same tags" form was broken (ticket:279)
96 update: add more InnoDB foreign keys
97 update: also search object ports by label text
98 0.17.3 2009-08-08
99 update: even better search function (ticket:20)
100 update: suggest tag selector for new files and users (ticket:205)
101 update: "multiple ports" form is now hidden by default (ticket:274)
102 new feature: tags quick list on "Tags" tab (ticket:259)
103 bugfix: removed PHP warnings on "Rackspace" tab
104 bugfix: rack row removal sometimes failed (by Marcin Suchocki)
105 bugfix: improve usage counters for IPv4 networks
106 bugfix: make ADDNEW_AT_TOP options really work everywhere (ticket:213)
107 bugfix: authorize file preview as a download (ticket:241)
108 bugfix: dictionary stats report didn't work correctly
109 0.17.2 2009-07-22
110 new feature: configure default SNMP community (by jthurman)
111 new feature: "$untagged", "$portless", "$nameless" and "$masklen_OP_NN" autotags
112 new feature: knight button in IPv4 tree
113 new feature: searching by attribute value or port reservation comment
114 update: show appropriate message, if a record cannot be found
115 update: add Cisco dictionary entry for WS-CBS3030-DEL. closes ticket 225 (by jthurman)
116 update: add OS, router, fibre switch dictionary entries for ticket 238 (by Aaron)
117 update: allow variations of FC WWN as an L2 address (by killsystem)
118 update: port L2 address can be reused on the same object
119 update: same port name can be repeated for an object with different types
120 update: added comment field for IPv4 networks
121 update: NetApp records (by Sander Klein)
122 update: APC records (by Ray Robertson)
123 bugfix: do not produce PHP warning on LivePTR tab
124 bugfix: wrong port type set for WS-C2950-24. closes ticket 229 (by jthurman)
125 bugfix: improved IOS detection and fixed a logic error. closes ticket 232 (by jthurman)
126 bugfix: user account autotags were not generated under certain conditions (reported by Jason Hamilton)
127 bugfix: correctly remove tags, when deleting files
128 bugfix: switchvlans failed on "%" or "~" character in port name (by Boris Lytochkin)
129 bugfix: search failed, when only one RS pool was found for request
130 bugfix: large images could not be rendered often due to memory limit hit
131 new feature: rackspace tab is shown only if there is at least one rack
132 in the system. Closes ticket 234.
133 0.17.1 2009-06-03
134 bugfix: tags were not displayed on "File" page
135 bugfix: multiline comment for an added file was stored incorrectly
136 bugfix: user's displayed name was sometimes lost with LDAP auth
137 bugfix: rackspace rows highlightling was broken in previous release
138 bugfix: IPv4 address picker window was broken
139 bugfix: string value "0" was incorrectly handled, when displaying or entering data
140 bugfix: rackspace allocation history recording did not work in 0.17.0
141 bugfix: boolean expressions parsing in RackCode now honours priorities
142 bugfix: upgrade script could fail sometimes
143 update: removed unused database index
144 0.17.0 2009-05-20
145 new feature: file attachments (by Aaron)
146 new feature: ability to delete objects (by Aaron)
147 new feature: external "httpd" user authentication
148 new feature: validator in RackCode editor
149 new feature: vendor sieve for stickers
150 new feature: RackCode expressions as source for load balancer lists
151 new feature: wireless hardware in dictionary
152 new feature: "racks per row" option (by Frank Brodbeck)
153 new feature: LDAP cache
154 update: display row name when listing objects. closes ticket 16 (by Aaron)
155 update: ability to manage rows from the Rackspace page in addition to the Dictionary (by Aaron)
156 update: allow port type to be changed if it isn't linked. closes ticket 137 (by Aaron)
157 update: add network security chapter and dictionary entries. closes ticket 148 (by Aaron)
158 update: add HP and Juniper dictionary entries. closes tickets 145 and 165 (by Aaron)
159 update: combined two forms on object properties page into one. closes tickets 36 and 87 (by Aaron)
160 update: display and edit the dictionary chapter by chapter (ticket:151)
161 update: 'enabled' user acount flag was dropped
162 update: switchvlans gateway has been updated
163 update: RackTables installation is now done only through install.php
164 update: records for F5 hardware
165 update: don't require HASH extension any more
166 update: rack thumb dimensions aren't configured any more
167 update: SNMP code for Nexus and HP switches (with help from killsystem)
168 update: tag filter has been completely rewritten
169 bugfix: show error message if snmp module isn't loaded. closes ticket 43 (by Aaron)
170 bugfix: fixed IIS-specific issues with accessing via HTTP or from docroot (reported by Sean Brown)
171 0.16.6 2009-01-12
172 bugfix: it was possible to access the system as any existing
173 LDAP user w/o his password (reported by Igor Shishkin)
174 0.16.5 2008-12-23
175 bugfix: suppress several meaningless PHP warnings
176 bugfix: better handle IPv4 addresses w/o a covering prefix
177 bugfix: show error message for duplicate IPv4 network record
178 update: IPv4 calculations were optimized for better speed
179 update: resolved performance issue for systems with many L2 ports
180 update: enable username handling in Cisco switch connector
181 update: introduce icons for routers and SLB
182 new feature: IPv4 tree expand/collapse switch
183 new feature: IPV4_TREE_SHOW_USAGE option controls IPv4 performance
184 0.16.4 2008-11-04
185 bugfix: display VS/RS config block in RS pool view
186 bugfix: resolve tabindex issues in many forms
187 bugfix: NAT rules were not displayed for IP address
188 bugfix: less PHP warnings
189 update: enable user search by real name
190 update: allow empty names for IPv4 networks
191 update: refactor snmp.php to support Cisco 3032, 3750, 4506 switches
192 (by Aaron, w/data & testing from Luis Fernando Lacayo and Ray Robertson)
193 update: add SNMP discovery support for Cisco 2950-24 (patch by Russ, ticket 177)
194 0.16.3 2008-10-02
195 new feature: tell line number for lexical and syntax errors
196 new feature: CodePress editor enables line numbers and syntax
197 highlightling for RackCode editing
198 new feature: one more input format for RS manager
199 new feature: standalone RackCode report with warnings
200 new feature: unified IPv4 address tree
201 bugfix: tags are now properly displayed for users
202 bugfix: the JavaScript error isn't generated any more (fix by Aaron)
203 bugfix: tag tree is now always correctly sorted
204 bugfix: fix a typo in NAT rules displaying code (pointed out by Piotr Nowacki)
205 bugfix: error message was broken in the installer (reported by Thomas Thep)
206 bugfix: IPv4 network check sometimes failed to detect duplicate networks
207 bugfix: lexical scanner could mistakenly fail in some rare cases
208 bugfix: drop DB index mistakenly introduced in 0.16.1
209 0.16.2 2008-08-21
210 bugfix: IP address picker was broken
211 bugfix: more message processing fixes
212 bugfix: work around some NET-SNMP builds (reported by Walery Wysotsky)
213 bugfix: some characters in password could break user access
214 bugfix: pre-assigned tags didn't work for racks
215 bugfix: tag roller could produce incorrect tag chains sometimes
216 new feature: "router" addresses allocations
217 new feature: support for local extensions and reports
218 new feature: LDAP username to UID mapping by Walery Wysotsky
219 new feature: extended IPv4 view mode (enabled by default)
220 new feature: tag roller now processes objects in racks too
221 new feature: start cutting off excessively long strings on the generated pages
222 update: 3 more switches in SNMP code by Walery Wysotsky
223 update: added a missing DB index (Aaron Dummer's advice)
224 update: "slbconfig" gateway has been replaced by "sendfile"
225 update: more detailed tag report
226 update: "virtual" addresses are now "loopback" and "regular" became "connected"
227 update: "placeholders" are now "spacers"
228 update: more records were put into the demo data
229 0.16.1 2008-07-30
230 new feature: pre-assigned tags for new VS and RS pools records
231 new feature: cache RackCode parse tree for better performance
232 new feature: display tags inline for IPv4 and SLB data
233 new feature: optionally remember the last tab for each page
234 bugfix: don't escape Greek letters to enable them in tag names
235 bugfix: port manager messages were incorrect
236 bugfix: shorten URLs to enable longer message logs
237 bugfix: added missing index to database
238 update: adjusted database for bigger texts
239 update: better "origin" highlighting for browsing
240 update: merged Petr Kohts' highlight patch
241 update: better tags in demo data
242 0.16.0 2008-07-09
243 new feature: tag roller
244 new feature: taggable user accounts
245 new feature: RackCode configuration
246 new feature: "my account" page
247 update: page layout fixes and improvements
248 update: dictionary updates
249 0.15.1 2008-06-05
250 bugfix: fix auth headers in upgrade script (broken in 0.15.0)
251 new feature: fetch switch serial number via SNMP (by killsystem)
252 new feature: adding multiple racks
253 new feature: IP address reservation release on allocation
254 updates: user interface cleanups and improvements
255 0.15.0 2008-05-10
256 new feature: tags
257 new feature: automatic option groups
258 new feature: rendered links in dictionary view
259 new feature: trunk support in switchvlans gateway
260 new feature: Tango icon set
261 update: added Force10, NETGEAR, D-Link, 3Com and Extreme Networks
262 switches, Raisecom MUXes, updated Cisco routers
263 update: async port type has been split
264 update: don't allow duplicate rack names in one row
265 update: internal help system has been dropped
266 update: SSV format for RS import
267 bugfix: handle "routed" switch ports
268 bugfix: make switchvlans gateway work on Linux
269 0.14.12 2008-02-29
270 new feature: default value for RS inservice status
271 new feature: AutoPorts feature
272 new feature: HTTP installer
273 new feature: default object type
274 new feature: UTF-8 support
275 bugfix: router HW type list was broken
276 update: added Aten KVM switches and consoles
277 update: added Tainet MUXes
278 update: updated HP servers
279 0.14.11 2008-02-15
280 bugfix: rackspace allocation was broken by magic_quotes fix
281 bugfix: don't generate error messages by accessing _GET array
282 bugfix: thumbs cache wasn't updated in rare cases
283 bugfix: LivePTR: fixed warnings, tabindex, name reset and color markup
284 update: KVM port type has been split (see wiki page)
285 update: Avocent KVM switches, RAD and Cronyx multiplexers
286 0.14.10 2008-02-01
287 bugfix: avoid hitting GET limit on object and rack update
288 bugfix: sticker reset icon did not work sometimes
289 bugfix: don't fail rendering an empty rack row
290 bugfix: rack operations were broken in 0.14.9
291 bugfix: upgrade script didn't authenticate users properly
292 new feature: LDAP authentication
293 new feature: borrow URL detection from Mantis BTS (suggested by Joakim Kasimir)
294 new feature: Live PTR tab for DNS sync
295 new feature: rack population threshold for rackspace allocation
296 0.14.9 2008-01-30
297 bugfix: upgrade to 0.14.8 broke IPv4 prefix creation
298 bugfix: more DB cleanups
299 bugfix: SNMP didn't work properly for C4948 ports
300 bugfix: rowspan attribute was computed incorrectly sometimes
301 bugfix: protect referenced dictionary records from deletion
302 bugfix: config reset was wrong for default port type
303 bugfix: fixed incorrect string escaping caused by PHP magic_quotes
304 update: Live VLANs color legend now distinguishes between 1 and 0
305 MAC addresses on a port
306 update: fixed tabindex in NATv4 rules form
307 update: better dictionary editor layout
308 update: get FQDN over SNMP
309 update: accept one more multiport format
310 update: help pages have been removed
311 new feature: more information for rack view
312 new feature: rack thumbnails caching
313 new feature: rackspace and IPv4 subnets utilization indicator
314 new feature: IPv4 and NATv4 tabs are now context-dependent
315 new feature: initial SLB management, keepalived support
316 0.14.8 2007-12-22
317 bugfix: adjusted hardcoded values in VLAN trigger
318 bugfix: adjusted HW, SW and port types in SNMP data collector
319 bugfix: Cisco connector: tolerate switch ports in suspended state
320 bugfix: nameless object in link list could not be clicked
321 bugfix: fix SQL tables structure
322 bugfix: Live VLANs displayed VLANs missing from switch table improperly
323 bugfix: sort auth data by username
324 bugfix: NATv4 rules were added incorrectly
325 update: corrected some dictionary entries
326 update: better layout for Live VLANs tab
327 update: better logo
328 update: stick with GPL version 2, not any later version
329 new feature: UI option to control asset tag warning
330 new feature: UUID (RFC4122) sticker
331 new feature: empty rackspace detector
332 new feature: initial wiki-style markup support in dictionary
333 0.14.7 2007-12-05
334 bugfix: provide better SQL dumps for new installations
335 bugfix: gateways/switchvlans minor updates
336 bugfix: logout link could fail sometimes
337 bugfix: avoid short PHP tags for better compatibility across
338 different PHP installations (reported by Tom Laermans)
339 bugfix: remove odd records from IPAddress once more
340 bugfix: fixed IPv4 address browsing for MySQL-4 DB
341 update: better attributes edit form by Aaron Dummer
342 update: numerous UI adjustments across all pages
343 update: new Dell, Foundry and Cisco records in the dictionary
344 new feature: more cisco models support in gateways/switchvlans
345 new feature: initial implementation of SNMP port data importer
346 new feature: UI configuration reset tab
347 new feature: initial reports code
348 0.14.6 2007-10-15
349 new feature: browser-side validation for a new IPv4 network
350 (contributed by Aaron Dummer)
351 new feature: logout link (same author)
352 new feature: key hint in dictionary browser
353 new feature: switch VLANs gateway with Cisco connector (others to come)
354 new feature: one more form for objects mass-creation
355 new feature: automatic database upgrades
356 bugfix: don't hide IPv4 address name for a free address
357 update: new stock values in dictionary chapters: server OS type,
358 PortType, switch models
359 update: make GigE default port type
360 update: configuration is now stored in the database
361 0.14.5 2007-03-08
362 bugfix: lots of adjustments to allow database be MySQL 4.0
363 0.14.4 2007-02-21
364 bugfix: provide proper SQL init files
365 bugfix: produce less PHP warnings
366 bugfix: corrected error messages
367 bugfix: don't fail on an empty database
368 bugfix: multi-object form works again
369 bugfix: fixed CSS errors
370 bugfix: don't list the same port more than once in pop-up list
371 bugfix: don't allow to ban admin access
372 0.14.3 2007-02-15
373 initial release