[Nocupdates] GRNOC DB Upgrade to 1.6.3

Wed Jan 13 08:40:04 CST 2010

Hi Everyone

I've upgraded the OneNet GRNOC DB instance to 1.6.3, here is the change log from your previous version

grnocdb 1.6.3 [2010 Jan 8]
----------------------------
Major Changes:
  * ISSUE=587 PROJ=102 Added Stale Device Report to show child devices that are still in the network, but have older last update times than the root node. Made decom and rma and move to storage actions set an out of service time on a device record. Moving to storage also now creates a record for the device in storage.

Minor Changes:
  * Fixed NCREN contact notification report to ignore entities who have been deleted -- i.e. entity.is_active=0  ISSUE=642
  * ISSUE=633 PROJ=102 Circuit summary was not respecting administrative network access policy.
  * ISSUE=633 PROJ=102 Util die_error had a typo in formatting.
  * ISSUE=617 PROJ=102 Change Footprints Integration views for MCNC to have both the address in 1 field and the address broken out.
  * ISSUE=5250 PROJ=101 Adding the simple ckt populator the grnocdb trunk
  * ISSUE=241 PROJ=102 Fixed prefix approval to properly create tickets
  * ISSUE=627 PROJ=102 Fixed adding channels so that it uses ckt_role_membership properly
  * ISSUE=625 PROJ=102 removing if (0) from netblock tuner so it will populate netblock table again
  * ISSUE=623 PROJ=102 remove Add New Method Type button so people can't add new contact method types
  * ISSUE=547 PROJ=102 adding NCREN contact notification report to grnocdb svn, but not linking to it publicly
  * ISSUE=423 PROJ=102 Adding circuits "above" set the path to an incorrect default value, causing sorting to be messed up.  The correct default vlaue, an empty string, is now set.
  * ISSUE=611 PROJ=102 the add / edit a node should now be stricter on what sorts of values it will accept

grnocdb 1.6.2 [2009 Dec 17]
----------------------------
Major Changes:
 * ISSUE=610 PROJ=102 Resolved issue where some serial numbers were being missed or truncated in the quick search due to group_concat_max_len being set very low

Minor Changes:
 * ISSUE=615 PROJ=102 Added the ability to edit node roles in the admin section
 * ISSUE=545 PROJ=102 Added the ability to add/delete circuit roles in the admin section
 * ISSUE=610 PROJ=102 Resolved issue where some serial numbers were being missed or truncated in the quick search due to group_concat_max_len being set very low
 * ISSUE=591 PROJ=102 browsers save .csv as a download when device change reports exports to CSV

grnocdb 1.6.1 [2009 Dec 11]
----------------------------

Major Changes:
 * Added department and Fax fields to materialized views for software as a service customers with footprints integration  
 * ISSUE=589 PROJ=102 Adjusted the 15454 capacity reporting tool to correctly model the new internal representation of 15454 units 
Minor Changes:
 * Incremented minor revision number from 1.5.x to 1.6.x to reflect previous upgrades in schema after internal discussion.

grnocdb 1.5.41 [2009 Dec 03]
----------------------------

Major Changes:

 * ISSUE=432 PROJ=102 added editable Circuit Types section in Admin menu
 * ISSUE=576 PROJ=102 setting up radius / ldap queries to only pull nodes with a managed role

Minor Changes:

* ISSUE=585 PROJ=102 fix alertmon device finder to find affected elements in children (multi-shelf) 15454 nodes
* ISSUE=576 PROJ=102 support for differently colored nodes in the rack diagram based on managed or not
* ISSUE=581 PROJ=102 Display wavelengths with decomed circuits on routes page
* ISSUE=577 PROJ=102 added "Previously associated with" text to inventory searches when the connecting device is out of serivce
* ISSUE=572 PROJ=102 small change to get_device_by_serial for blacklister support
* ISSUE=477 PROJ=102 added support for blacklisting of devices with multiple serial numbers
* ISSUE=563 PROJ=102 added --No State-- as an option for contact information

grnocdb 1.5.40 [2009 Nov 19]
---------------------------
Major Changes:

* ISSUE=307 PROJ=102 Support for adding non virtual children nodes to nodes.

Minor Changes:

* Added grnoc_admin user type when displaying contact update option on entity page
* Adding support for Sentry rancid poller type
* ISSUE=555 PROJ=102 changed int_id back to interface_id which fixed issue
* ISSUE=553 PROJ=102 Adding a simple math question to all confirmation popups
* ISSUE=479 PROJ=102 do warning popup whenever adding a new user with grnoc_admin or admin level privs to confirm its OK
* ISSUE=477 PROJ=102 adding a few queries for blacklisting support

grnocdb 1.5.39 [2009 Nov 12]
---------------------------
Major Changes:

* ISSUE=541 PROJ=102 Table view of a node now handles multi-slot cards and should properly sort according to slot better.
* ISSUE=549 PROJ=102 Fixed issue where netblock_auth was being superceded by a need for engineer or higher level access.

Minor Changes:

* ISSUE=551 PROJ=102 Made repairs to Netblock.pm where validate_block was being overzealous, and therefore overly slow
* ISSUE=549 PROJ=102 Creating a new root netblock was impacted by previous work. Ensured functionality of both features with this update.
* ISSUE = 548 PROJ=102 Modified Prefs.pm to not crash with a NULL value in user_prefs
* ISSUE=447 PROJ=102 Added blacklist column for devices in preparation for addressing duplicate serial number issue.
* ISSUE=337 PROJ=102 Added another speedup to the node quicksearch page to account for the duplicate device issue.
* ISSUE=464 PROJ=102 Allow admin_net to be optional for radius/ldap login rule with just a node role
* ISSUE=552 PROJ=102 Now turns interface monitoring status if the node is being monitored by a check containing the word "interface" in it
* Made the delete POP button NOOP until further review