# # ChangeLog for trunk/cgi-bin # # Generated by Trac 1.6 # 12/22/24 20:10:16 Wed, 06 Apr 2005 21:08:15 GMT Kris Deugau [219] * trunk/cgi-bin/ipdb.psql (modified) /trunk Missed some tabledef changes in r218 Wed, 06 Apr 2005 21:06:28 GMT Kris Deugau [218] * trunk/cgi-bin/extras/db2rwhois.pl (modified) * trunk/cgi-bin/ipdb.psql (modified) /trunk Updated SQL tabledefs with timestamps for master block, ... Tue, 05 Apr 2005 18:24:52 GMT Kris Deugau [214] * trunk/cgi-bin/admin.cgi (modified) * trunk/cgi-bin/consistency-check.pl (modified) * trunk/cgi-bin/main.cgi (modified) * trunk/cgi-bin/newcity.cgi (modified) /trunk Port bugfixes from /branches/stable r203-206 and r209-213 ... Thu, 17 Mar 2005 17:30:51 GMT Kris Deugau [199] * trunk/cgi-bin/admin.cgi (modified) * trunk/cgi-bin/main.cgi (modified) * trunk/ipdb.css (modified) /trunk Update admin.cgi (such as it was) to newer IPDB backend ... Wed, 16 Mar 2005 20:58:48 GMT Kris Deugau [198] * trunk/cgi-bin/allocate.pl (copied) /trunk Port allocate.pl forward to trunk from /branches/stable r188 Thu, 10 Mar 2005 18:46:49 GMT Kris Deugau [191] * trunk/cgi-bin/main.cgi (modified) /trunk Fixed buglet that would have incorrectly allowed allocation ... Tue, 08 Mar 2005 22:40:12 GMT Kris Deugau [190] * trunk/cgi-bin/consistency-check.pl (modified) /trunk consistency-check.pl: Updated to be consistent with the ... Tue, 08 Mar 2005 22:37:46 GMT Kris Deugau [189] * trunk/cgi-bin/IPDB.pm (modified) * trunk/cgi-bin/ipdb.psql (modified) * trunk/cgi-bin/main.cgi (modified) /trunk Caught some buglets in the HairyPerl(TM) ('$1' vs "$1") ... Fri, 04 Mar 2005 23:12:54 GMT Kris Deugau [187] * trunk/cgi-bin/IPDB.pm (modified) * trunk/cgi-bin/ipdb.psql (modified) * trunk/cgi-bin/main.cgi (modified) * trunk/fb-assign.html (modified) /trunk Another herd of changes to alloctypes. This cleaned up the ... Thu, 03 Mar 2005 22:14:54 GMT Kris Deugau [186] * trunk/cgi-bin/IPDB.pm (modified) * trunk/cgi-bin/main.cgi (modified) /trunk First round of changes for "clean" handling of subblock ... Tue, 01 Mar 2005 21:22:39 GMT Kris Deugau [184] * trunk/cgi-bin/IPDB.pm (modified) * trunk/cgi-bin/main.cgi (modified) /trunk Tweaked another few fixes into place to make a "fresh" ... Tue, 01 Mar 2005 21:05:45 GMT Kris Deugau [183] * trunk/cgi-bin/IPDB.pm (modified) /trunk Change database connection check slightly to select from the ... Tue, 01 Mar 2005 20:57:53 GMT Kris Deugau [182] * trunk/cgi-bin/ipdb.psql (modified) /trunk Preseed alloctypes table with current types ("common" ones ... Tue, 01 Mar 2005 20:56:35 GMT Kris Deugau [181] * trunk/cgi-bin/ipdb.psql (modified) /trunk Change SQL definitions to create the database before ... Tue, 01 Mar 2005 19:44:40 GMT Kris Deugau [180] * trunk/cgi-bin/ipdb.psql (modified) /trunk Fix another buglet with the SQL definitions. Picky, picky... Tue, 01 Mar 2005 19:08:15 GMT Kris Deugau [179] * trunk/cgi-bin/ipdb.psql (modified) /trunk Fix buglet in SQL definitions (ported forward from ... Tue, 01 Mar 2005 18:31:45 GMT Kris Deugau [176] * trunk/cgi-bin/ipdb.psql (modified) /trunk Full update of ipdb.psql without extraneous pg_dump bits, ... Tue, 01 Mar 2005 16:49:46 GMT Kris Deugau [175] * trunk/cgi-bin/ipdb.psql (modified) /trunk Updated SQL table definitions - pg_dump format Thu, 24 Feb 2005 22:12:09 GMT Kris Deugau [173] * trunk/cgi-bin/main.cgi (modified) /trunk Merged additional SQL cleanup changes from ... Tue, 22 Feb 2005 19:25:58 GMT Kris Deugau [167] * trunk/cgi-bin/IPDB.pm (modified) * trunk/cgi-bin/consistency-check.pl (modified) * trunk/cgi-bin/main.cgi (modified) /trunk New feature: Different "default" CustIDs depending on the ... Tue, 22 Feb 2005 17:23:36 GMT Kris Deugau [166] * trunk/cgi-bin/main.cgi (modified) /trunk Merged bugfixes from /branches/stable r162-165. ** NB: ... Wed, 09 Feb 2005 22:56:08 GMT Kris Deugau [161] * trunk/cgi-bin/main.cgi (modified) /trunk Backport bugfix from /branches/stable r160 Tue, 08 Feb 2005 20:56:33 GMT Kris Deugau [157] * trunk/cgi-bin/IPDB.pm (modified) * trunk/cgi-bin/main.cgi (modified) /trunk Merge changes from /branches/sql-cleanup into mainline - ... Tue, 01 Feb 2005 22:02:39 GMT Kris Deugau [146] * trunk/cgi-bin/IPDB.pm (modified) * trunk/cgi-bin/admin.cgi (modified) * trunk/cgi-bin/extras/db2rwhois.pl (modified) * trunk/cgi-bin/freespace.pl (modified) /trunk Update copyright statements Fri, 28 Jan 2005 23:01:20 GMT Kris Deugau [143] * trunk/cgi-bin/extras/db2rwhois.pl (modified) /trunk Tweak/update db2rwhois with latest (My)IPDB interface Fri, 28 Jan 2005 19:04:55 GMT Kris Deugau [142] * trunk/cgi-bin/MyIPDB.pm (added) * trunk/cgi-bin/consistency-check.pl (modified) * trunk/cgi-bin/freespace.pl (modified) * trunk/cgi-bin/main.cgi (modified) * trunk/cgi-bin/newcity.cgi (modified) /trunk Wrap connectDB() function in a "module" so we don't get ... Fri, 28 Jan 2005 18:41:07 GMT Kris Deugau [141] * trunk/cgi-bin/extras/db2rwhois.pl (modified) /trunk Fix svn: properties on db2rwhois.pl. Really. Thu, 27 Jan 2005 22:31:57 GMT Kris Deugau [139] * trunk/assign.html (modified) * trunk/cgi-bin/newcity.cgi (added) * trunk/changes.html (modified) * trunk/newcity.html (added) /trunk Added ability to add cities/locations to database. Not yet ... Wed, 26 Jan 2005 22:31:33 GMT Kris Deugau [138] * trunk/cgi-bin/main.cgi (modified) /trunk Redesign alloctype check so that it checks alloctypes that ... Wed, 26 Jan 2005 22:07:26 GMT Kris Deugau [137] * trunk/cgi-bin/main.cgi (modified) /trunk Merge bugfix in /branches/stable r136 Wed, 26 Jan 2005 20:30:30 GMT Kris Deugau [135] * trunk/cgi-bin/IPDB.pm (modified) * trunk/cgi-bin/main.cgi (modified) /trunk Merge bugfixes from /branches/stable r130:134 Thu, 20 Jan 2005 20:30:33 GMT Kris Deugau [130] * trunk/cgi-bin/IPDB.pm (modified) /trunk Backported r128 and r129 bugfixes from /branches/stable Fri, 07 Jan 2005 16:00:06 GMT Kris Deugau [120] * trunk/cgi-bin/IPDB.pm (modified) /trunk Fixed some SQL bugs before they become problems - make sure ... Thu, 06 Jan 2005 20:42:50 GMT Kris Deugau [119] * trunk/cgi-bin/freespace.pl (copied) /trunk Port freespace.pl forward from /branches/stable r117 Thu, 06 Jan 2005 20:03:33 GMT Kris Deugau [118] * trunk/cgi-bin/IPDB.pm (modified) * trunk/cgi-bin/main.cgi (modified) /trunk SQL cleanup: - Made liberal use of "<<=" operator and ... Wed, 05 Jan 2005 16:35:29 GMT Kris Deugau [115] * trunk/cgi-bin/main.cgi (modified) /trunk Cosmetic fix in "Add new master" code Fri, 24 Dec 2004 20:10:56 GMT Kris Deugau [111] * trunk/cgi-bin/main.cgi (modified) * trunk/index.shtml (modified) /trunk Cleanup of display and fallthrough logic: - printFooter ... Fri, 24 Dec 2004 19:13:41 GMT Kris Deugau [108] * trunk/cgi-bin/IPDB.pm (modified) /trunk Fix SQL bug in static-IP section of allocateBlock() Fri, 24 Dec 2004 19:12:34 GMT Kris Deugau [107] * trunk/cgi-bin/IPDB.pm (modified) /trunk Fix error reporting in allocateBlock() to return the SQL ... Wed, 22 Dec 2004 21:25:59 GMT Kris Deugau [106] * trunk/cgi-bin/IPDB.pm (modified) * trunk/cgi-bin/consistency-check.pl (modified) * trunk/cgi-bin/main.cgi (modified) /trunk IPDB rewrite, first stable iteration. -> uses ... Wed, 22 Dec 2004 19:21:44 GMT Kris Deugau [105] * trunk/cgi-bin/CommonWeb.pm (modified) /trunk Updated printError function so that it does NOT exit, to ... Wed, 01 Dec 2004 20:53:28 GMT Kris Deugau [96] * trunk/cgi-bin/IPDB.pm (modified) /trunk Added city and POP list initialization Wed, 01 Dec 2004 20:46:46 GMT Kris Deugau [95] * trunk/cgi-bin/CommonWeb.pm (modified) * trunk/cgi-bin/IPDB.pm (modified) * trunk/cgi-bin/admin.cgi (modified) * trunk/cgi-bin/consistency-check.pl (modified) * trunk/cgi-bin/main.cgi (modified) /trunk Corrected incorrect or missing svn:* properties on Perl ... Wed, 01 Dec 2004 20:29:09 GMT Kris Deugau [93] * trunk/cgi-bin/IPDB.pm (modified) /trunk Add deleteBlock() sub Tue, 30 Nov 2004 20:42:30 GMT Kris Deugau [92] * trunk/assign.html (modified) * trunk/cgi-bin/ipdb.psql (modified) * trunk/cgi-bin/main.cgi (modified) * trunk/changes.html (modified) * trunk/fb-assign.html (modified) /trunk Port updates and bugfixes from /branches/stable r87:91 back ... Fri, 26 Nov 2004 22:28:19 GMT Kris Deugau [87] * trunk/assign.html (modified) * trunk/cgi-bin/main.cgi (modified) * trunk/changes.html (copied) * trunk/fb-assign.html (modified) * trunk/header.inc (modified) /trunk Port bugfixes and tweaks from /branches/stable r79:86 forward. Fri, 26 Nov 2004 17:50:01 GMT Kris Deugau [80] * trunk/cgi-bin/IPDB.pm (modified) /trunk Further tweaked allocateBlock()'s calls to initPool() to ... Fri, 26 Nov 2004 17:35:43 GMT Kris Deugau [79] * trunk/cgi-bin/IPDB.pm (modified) /trunk Redesigned error handling in allocateBlock() to return more ... Tue, 23 Nov 2004 22:44:12 GMT Kris Deugau [78] * trunk/cgi-bin/IPDB.pm (modified) /trunk Updated allocBlock() to properly handle and return errors ... Fri, 19 Nov 2004 22:43:36 GMT Kris Deugau [77] * trunk/cgi-bin/IPDB.pm (modified) /trunk Flesh out allocateBlock() and initPool() Begin work on ... Tue, 16 Nov 2004 20:10:08 GMT Kris Deugau [74] * trunk/assign.html (modified) * trunk/cgi-bin/ipdb.psql (modified) * trunk/cgi-bin/main.cgi (modified) * trunk/confirm.html (modified) * trunk/confirmRemove.html (modified) * trunk/editDisplay.html (modified) * trunk/updated.html (modified) /trunk Added a CircuitID field on both netblock and static IP ... Mon, 15 Nov 2004 21:55:54 GMT Kris Deugau [73] * trunk/cgi-bin/main.cgi (modified) /trunk Hack to allow manual allocation of specific static IPs by ... Mon, 15 Nov 2004 21:53:24 GMT Kris Deugau [72] * trunk/cgi-bin/main.cgi (modified) /trunk Fixed checks for static-ip allocation types. Really. For sure. Mon, 15 Nov 2004 17:37:23 GMT Kris Deugau [70] * trunk/cgi-bin/main.cgi (modified) /trunk Add email notification for static IP assignment - ... Mon, 15 Nov 2004 17:36:31 GMT Kris Deugau [69] * trunk/cgi-bin/IPDB.pm (modified) /trunk Fix for mailNotify() so it works Fri, 12 Nov 2004 21:57:59 GMT Kris Deugau [68] * trunk/cgi-bin/IPDB.pm (modified) /trunk Fixed broken headers in mailNotify() Fri, 12 Nov 2004 20:18:28 GMT Kris Deugau [67] * trunk/cgi-bin/consistency-check.pl (modified) /trunk Minor nitpicking cosmetic fix for consistency-check.pl Fri, 12 Nov 2004 20:17:59 GMT Kris Deugau [66] * trunk/cgi-bin/IPDB.pm (modified) /trunk Shell of allocateBlock() function added mailNotify ... Fri, 12 Nov 2004 20:12:45 GMT Kris Deugau [65] * trunk/cgi-bin/admin.cgi (modified) /trunk Major update to admin tool; adds more or less complete ... Fri, 12 Nov 2004 16:52:03 GMT Kris Deugau [63] * trunk/cgi-bin/main.cgi (modified) /trunk Clean up some error handling code relating to DB transactions Thu, 11 Nov 2004 21:27:28 GMT Kris Deugau [62] * trunk/cgi-bin/consistency-check.pl (modified) /trunk Updated consistency check script to check for anomalies in ... Thu, 11 Nov 2004 20:49:04 GMT Kris Deugau [61] * trunk/cgi-bin/main.cgi (modified) /trunk Numerous minor bugfixes in logic - pool IP types ... Wed, 10 Nov 2004 21:57:34 GMT Kris Deugau [58] * trunk/cgi-bin/admin.cgi (modified) /trunk Finished first "complete" edition of admin interface for IPDB. Wed, 10 Nov 2004 21:54:02 GMT Kris Deugau [57] * trunk/cgi-bin/ipdb.psql (modified) /trunk Updated schema dump for IPDB Fri, 05 Nov 2004 19:03:21 GMT Kris Deugau [54] * trunk/cgi-bin/admin.cgi (added) /trunk Added admin.cgi with mostly-complete "update allocation ... Tue, 02 Nov 2004 18:15:53 GMT Kris Deugau [51] * trunk/cgi-bin/main.cgi (modified) /trunk Merge bugfixes and updates from /branches/stable r49 and r50 Mon, 01 Nov 2004 17:05:34 GMT Kris Deugau [47] * trunk/cgi-bin/main.cgi (modified) /trunk Bugfixes on error reporting: Make sure to syslog before ... Mon, 01 Nov 2004 16:57:52 GMT Kris Deugau [46] * trunk/cgi-bin/main.cgi (modified) /trunk SQL bugfixes: - New static IP would not get assigned - ... Mon, 01 Nov 2004 16:14:37 GMT Kris Deugau [45] * trunk/assign.html (modified) * trunk/cgi-bin/main.cgi (modified) * trunk/header.inc (modified) /trunk Merge bugfixes from /branches/stable r43 and r44 Mon, 01 Nov 2004 15:49:35 GMT Kris Deugau [42] * trunk/cgi-bin/main.cgi (modified) /trunk Merge bugfix from /branches/stable r41 Thu, 28 Oct 2004 20:26:39 GMT Kris Deugau [40] * trunk/cgi-bin/main.cgi (modified) /trunk Bugfix for final stage of allocating a static IP Thu, 28 Oct 2004 18:14:03 GMT Kris Deugau [37] * trunk/cgi-bin/main.cgi (modified) /trunk Fixed some logic errors with respect to allocating IP pools Thu, 28 Oct 2004 16:31:12 GMT Kris Deugau [34] * trunk/cgi-bin/ipdb.psql (modified) /trunk Updated Postgres schema dump Wed, 27 Oct 2004 21:01:02 GMT Kris Deugau [33] * trunk/cgi-bin/main.cgi (modified) * trunk/editDisplay.html (modified) /trunk Allow changing "whole" netblock types (dynamic DSL, cable, ... Wed, 27 Oct 2004 16:34:06 GMT Kris Deugau [31] * trunk/assign.html (modified) * trunk/cgi-bin/main.cgi (modified) /trunk Allow selection of which master to allocate a block from Tue, 26 Oct 2004 21:22:22 GMT Kris Deugau [27] * trunk/cgi-bin/main.cgi (modified) Added Thunder Bay to list of POP cities in route-new-block check Tue, 26 Oct 2004 15:19:53 GMT Kris Deugau [23] * trunk/cgi-bin/main.cgi (modified) Add tweak to allow newly-entered custIDs to end with "-nn" Mon, 25 Oct 2004 21:38:34 GMT Kris Deugau [22] * trunk/cgi-bin/main.cgi (modified) Tweaked delete logging to make it clear what type of block was deleted Mon, 25 Oct 2004 21:38:02 GMT Kris Deugau [21] * trunk/cgi-bin/main.cgi (modified) * trunk/fb-assign.html (added) Added support for directly assigning blocks listed as "free" Mon, 25 Oct 2004 21:35:54 GMT Kris Deugau [20] * trunk/cgi-bin/main.cgi (modified) * trunk/editDisplay.html (modified) Allow updating city for an allocation Mon, 25 Oct 2004 21:33:36 GMT Kris Deugau [17] * trunk/cgi-bin/main.cgi (modified) Fixed incorrect syslog error statements Mon, 25 Oct 2004 21:32:50 GMT Kris Deugau [16] * trunk/cgi-bin/IPDB.pm (modified) /trunk/cgi-bin/IPDB.pm: Remove CommonWeb.pm dependency from ... Mon, 25 Oct 2004 21:32:05 GMT Kris Deugau [15] * trunk/cgi-bin/extras/db2rwhois.pl (modified) Updated db2rwhois.pl for new database format Mon, 25 Oct 2004 21:30:13 GMT Kris Deugau [13] * trunk/cgi-bin/main.cgi (modified) main.cgi: Fix broken or not-quite-right SQL statements Mon, 25 Oct 2004 21:29:26 GMT Kris Deugau [12] * trunk/cgi-bin/main.cgi (modified) cgi-bin/main.cgi: - Added wireless IP and IP pool types - Fixed ... Mon, 25 Oct 2004 21:28:12 GMT Kris Deugau [11] * trunk/cgi-bin/consistency-check.pl (modified) Near-complete rewrite of cgi-bin/consistency-check.pl - It works ... Mon, 25 Oct 2004 21:26:56 GMT Kris Deugau [9] * trunk/cgi-bin/main.cgi (modified) Minor bugfix on search display - one type of pool didn't show a ... Mon, 25 Oct 2004 21:26:10 GMT Kris Deugau [8] * trunk/cgi-bin/CommonWeb.pm (modified) * trunk/cgi-bin/IPDB.pm (modified) * trunk/cgi-bin/consistency-check.pl (modified) * trunk/cgi-bin/main.cgi (modified) Added SVN revision info section to cgi-bin/CommonWeb.pm, ... Mon, 25 Oct 2004 21:24:33 GMT Kris Deugau [7] * trunk/cgi-bin/add-alloc.php (deleted) * trunk/cgi-bin/add-route.php (deleted) * trunk/cgi-bin/edit-alloc.php (deleted) * trunk/cgi-bin/edit-route.php (deleted) * trunk/cgi-bin/httpauth.php (deleted) * trunk/cgi-bin/import.pl (deleted) * trunk/cgi-bin/import2.pl (deleted) * trunk/cgi-bin/main-alpha1.cgi (deleted) * trunk/cgi-bin/main-alpha2.cgi (deleted) * trunk/cgi-bin/main-beta1.cgi (deleted) * trunk/cgi-bin/manual.htm (deleted) * trunk/cgi-bin/showenv.cgi (deleted) * trunk/cgi-bin/upd-alloc.php (deleted) Remove non-critical legacy and development files Mon, 25 Oct 2004 21:17:49 GMT Kris Deugau [6] * trunk/cgi-bin/add-alloc.php (added) * trunk/cgi-bin/add-route.php (added) * trunk/cgi-bin/consistency-check.pl (added) * trunk/cgi-bin/edit-alloc.php (added) * trunk/cgi-bin/edit-route.php (added) * trunk/cgi-bin/httpauth.php (added) * trunk/cgi-bin/import.pl (added) * trunk/cgi-bin/import2.pl (added) * trunk/cgi-bin/main-alpha1.cgi (added) * trunk/cgi-bin/main-alpha2.cgi (added) * trunk/cgi-bin/main-beta1.cgi (added) * trunk/cgi-bin/manual.htm (added) * trunk/cgi-bin/showenv.cgi (added) * trunk/cgi-bin/upd-alloc.php (added) Add intermediate development files for posterity Mon, 25 Oct 2004 21:12:22 GMT Kris Deugau [4] * trunk/addmaster.shtml (added) * trunk/alloctypes.html (added) * trunk/assign.html (added) * trunk/cgi-bin/CommonWeb.pm (added) * trunk/cgi-bin/IPDB.pm (added) * trunk/cgi-bin/ipdb.psql (added) * trunk/cgi-bin/main.cgi (added) * trunk/cgi-bin/snCalc.cgi (added) * trunk/confirm.html (added) * trunk/confirmRemove.html (added) * trunk/editDisplay.html (added) * trunk/footer.inc (added) * trunk/header.inc (added) * trunk/help.html (added) * trunk/images (added) * trunk/images/logo.png (added) * trunk/index.shtml (added) * trunk/ipdb.css (added) * trunk/startsn.html (added) * trunk/updated.html (added) Import "new" IPDB development: March 2004 through end of August ... Mon, 25 Oct 2004 21:06:58 GMT Kris Deugau [2] * trunk/cgi-bin (added) * trunk/cgi-bin/extras (added) * trunk/cgi-bin/extras/db2rwhois.pl (added) /trunk Import rWHOIS export script based on old db