[Nocupdates] GRNOC DB Upgraded

Tue Nov 30 11:53:56 CST 2010

Hi Guys

I upgraded the OneNet DB from version 1.8.1 to 1.9.0

Here is the change list for all of the upgrades.

A.J.

grnocdb 1.9.0 [2010 Nov 19]
---------------------------
Major Changes:

  * ISSUE=1499 PROJ=102 fixing inventory new parts check-in page (broken drop down boxes due to 1.8.10 YUI changes)
  * ISSUE=1410 PROJ=102 adding support in the frontend for monitoring circuits or circuit roles in the monitoring rules section
  * ISSUE=1452 PROJ=102 add vlan monitoring as a configurable option per admin network
  * ISSUE=300 PROJ=102 adding edit support for # of available channels on a circuit
  * Packaging GlobalNOC DB as an RPM

Minor Changes:

  * ISSUE=300 PROJ=102 routes page now lists wavelength frequency numbers for each channel circuit (if # of channels on route set)

grnocdb 1.8.10 [2010 Nov 11]
----------------------------

Major Changes:
  * ISSUE=1388 PROJ=102 Added associated interfaces section to entity page.
  * ISSUE=962  PROJ=102 Routes page now supports setting customer, carrier, and owner entities.

Minor Changes:
  * ISSUE=1086 PROJ=102 Increased POP Code character size limit and added proper unique key constraints to both POP codess and admin network abbreviated names.
  * ISSUE=1458 PROJ=102 Fixed issue on the update node page that would cause certain values to crash the page.
  * ISSUE=1462 PROJ=102 YUI libraries now linked to the GRNOC RPM instead of a symlink

grnocdb 1.8.9 [2010 Nov 5]
--------------------------
Minor Changes:
  * ISSUE=1455 PROJ=102 I2 Prefix approval page uses the correct table and points to the TR-CPS now instead of I2-CPS.
  * ISSUE=1453 PROJ=102 Fixed pagination in the netblock section
  * ISSUE=1451 PROJ=102 Caught the case in which a POP exists but isn't on the current admin network.  If the POP is in another admin network, offers the user the option to redirect into that admin network if they have permission.

grnocdb 1.8.8 [2010 Oct 28]
---------------------------
Minor Changes:
  * ISSUE=1409 PROJ=102 improved error handling on the patch panel wizard
  * ISSUE=1435 PROJ=102 fixed typo in HTML that prevented Internet Explorer from loading page
  * ISSUE=1436 PROJ=102 added SNAPP URL to database schema for admin networks
  * ISSUE=858 PROJ=102 Restored ability for admin and grnoc_admin users to override netblock permissions

grnocdb 1.8.7 [2010 Oct 21]
---------------------------
Major Changes:
  *  ISSUE=1378 PROJ=102 the listed tables have had primary keys added in upgrade and base schema. ckt_hierarchy already had an auto_increment id, so just added a primary key to it
  *  ISSUE=1086 PROJ=102 added unique key for bgp_peers (node + bgp peer address)

Minor Changes:
 * ISSUE=1359 PROJ=102 Made changes to allow search on cable_label column in Circuits
 * cleaned up rule and hostgroup interfaces
 * ISSUE=1397 PROJ=102 changed logic around so that searching with an exact match highlights the row green, separate tables for parent netblock matches for /32s and normal results, spruced up look and feel for searching
 * ISSUE=1392 PROJ=102 Was not adding devices to all necessary tables when adding a new part to asset control section. This is now fixed.
 * ISSUE=1398 PROJ=102 Added the linux_populator_shell to the list of shells

grnocdb 1.8.6 [2010 Oct 15]
---------------------------
Major Changes:
 * ISSUE=736 PROJ=102 moved prefix request tool tables out of grnocdb database

Minor Changes:
 * ISSUE=1389 PROJ=102 Moved the Atlas map of circuits to its own column so it could be view next to the list of circuits.
 * ISSUE=1347 PROJ=102 Made base ticket url configurable per admin network
 * ISSUE=1383 Resolved issues with adding and displaying Exclusions to Hostgroups
 * Modified IPG service ID populator

grnocdb 1.8.5 [2010 Oct 11]
---------------------------
Minor Changes:
 * ISSUE=940 PROJ=102 Modified Schema to remove superfluous column from entity table
 * ISSUE=1237 PROJ=102 additional circuit roles sorted alphabetically now
 * ISSUE=1311 PROJ=102 fixed a couple of things in parts checkin. The integrity checks are all done before any submissions are done, preventing things from getting 1/2 done. 
    If there is already an inventory record with that serial, it aborts. Also fixed a bug I came across regarding the dummy serial generation not working past the 1st checkbox.
 * ISSUE=1329 PROJ=102 Added the ability to set the model,vendor, and Owner globally on the part checkin page, which then removes them from the tab order for more efficient data entry.
 * ISSUE=1342 PROJ=102 Corrected add new device type function to use placeholders. Which should correct the blank screen bug.
 * ISSUE=1340 PROJ=102 Fixed html typo in monitoring section.

grnocdb 1.8.4 [2010 Sep 30]
---------------------------
Major Changes:
 * ISSUE=1247 PROJ=102 Engineers can edit a netblock as long as they are in the admin network.

Minor Changes:
 * ISSUE=1290 PROJ=102 Timezone dropdowns in Contact section ordered first by offset, then alphabetically.
 * ISSUE=1318 PROJ=102 Added unavailable as a possible circuit status.

grnoccb 1.8.3 [2010 Sep 17]
---------------------------
Major Changes:
 * ISSUE=1271 PROJ=102 Added a timezone table to the DB, linked contact section to the TZ

Minor Changes:
 * ISSUE=808 PROJ=102 Sorted while maintaining default at top
 * ISSUE=1245 PROJ=102 Added trim, removal of newlines and semicolons from contact methods
 * ISSUE=1264 PROJ=102 Provide an appropriate default admin network when loading grnocdb

grnocdb 1.8.2 [2010 Sep 10]
---------------------------

Minor Changes:
 * ISSUE=1221 PROJ=102 fix broken node device table when including interfaces
 * ISSUE=1230 PROJ=102 Added variable admin_network_id to reflect lower ckt admin networks in link to circuit
 * ISSUE=1230 PROJ=102 added admin_network_id to query to reflect actual admin network of circuit under sub get_ckt
 * ISSUE=1238 PROJ=102 updated non-admin user section of show_destinations to use "Asset Control" nomenclature
 * ISSUE=730 PROJ=102 Migrated data source for network element Monitoring Summary to the new data backend