• NAME
• MAJOR OUTSTANDING ISSUES
• MINOR OUTSTANDING ISSUES
• Fixed Bugs

NAME

CHANGE LOG - List of changes

<span style='font-size:14.0pt;font-family:Arial'>

=head2 DESCRIPTION

This file lists known bugs and contains the latest release notes, create dynamically by our source code control system.

MAJOR OUTSTANDING ISSUES

None known

MINOR OUTSTANDING ISSUES

 * doesn't check alarm db prerequesits (like truncate log on checkpoint...)
 * troubleshoot is still a bit sloppy
 * Installer does put stuff in your web server cgi-bin
 * historical server reporter packaged separately
 * monitor lacks drill down and integrated windows perfmon 
 * oracle
 * unix logs need be set up manually.  recommend central syslogd

Fixed Bugs

Build 705 (Apr 9 2008)

 
Build 704 (Apr  9 2008)

 
Build 703 (Apr  9 2008)
ROllup Release. Lots of doc changes. Oteher stuff too.
 
Build 702 (Mar 18 2008)
documentation on batch jbos
 
Build 701 (Mar 14 2008)
another release
 
Build 700 (Feb  7 2008)
backup scripts updated
 
Build 699 (Nov 14 2007)
doc updates for procs & backups srcripts
 
Build 698 (Nov 12 2007)
Another RRelease
 
Build 697 (Nov 11 2007)
LATEST & GREATEST BETA
 
Build 696 (Nov  7 2007)
user interface changes - freegem ssh/rsh/ftp toggles etc
 
Build 695 (Nov  1 2007)
FONT FIX FOR LARGER DEISPLAYS
 
Build 694 (Oct 23 2007)

 
Build 693 (Oct 23 2007)
FULL VERSION TR
 
Build 692 (Oct  1 2007)
Lots of minor things - too numerous to remember
 
Build 690 (Jun 20 2007)
Lots of misc cleanup - i need to keep better notes
 
Build 689 (May 29 2007)
Release Build
 
Build 688 (May 15 2007)
Variety of upgrades focused on data collection and logging
 
Build 687 (Mar 30 2007)
New Upload release
 
Build 686 (Mar 17 2007)
Rollup Release
 
Build 685 (Dec 22 2006)
might as well release something
 
Build 684 (Dec 14 2006)
ROLLUP RELEASE - SEE LATEST_NEWS
 
Build 683 (Dec  5 2006)
Major Release - See To Do List
 
Build 682 (Nov  1 2006)
November Port For Linux - Try #1
 
Build 681 (Sep 25 2006)
rollup release
 
Build 680 (Sep 12 2006)
Sqlsvr sp__dbspace update, documentation
 
Build 679 (Sep  8 2006)
many. sql audits werent working. multiple minor fixes.
 
Build 678 (Aug 25 2006)
Rollup Release - Minor Tweaks & Doc Fixes
 
Build 677 (Aug  3 2006)
Final Pre Techwave Build (???)
 
Build 676 (Aug  1 2006)
MLpReports.pm was calling MlpAlarms too soon...
 
Build 675 (Aug  1 2006)
Removed extraneous DBG DBG prints from old diagnostic messages
 
Build 674 (Aug  1 2006)
osql/isql check on configure.pl startup now reflects db picklist appropriately
 
Build 673 (Aug  1 2006)
New Reports & Report Manager, New screen for reports on configure.pl
 
Build 672 (Jul 24 2006)
Continuing console cleanup
 
Build 671 (Jul 22 2006)
Significant Console Cleanup for consistency
 
Build 670 (Jul 13 2006)
SQL Server Only Build - Removed dies for $SYBASE, Tightened Prints & Error Messages
 
Build 669 (Jul 13 2006)
Added Server Type Checkboxes to Configure.pl & Console
 
Build 668 (Jul  6 2006)
Failed the last build
 
Build 667 (Jul  6 2006)
Threshold Report/Frag Report on Console werent displaying right
 
Build 666 (Jun 13 2006)
RELEASE VERSION
 
Build 665 (Jun 13 2006)
Prep for Release Beta2
 
Build 664 (Jun  9 2006)
minor revisions - working on hourglass consistency
 
Build 663 (Jun  8 2006)
Moved configure.pl to one RegisterServer() and made console header changes for clarity
 
Build 662 (Jun  7 2006)
working on autodetection...
 
Build 661 (Jun  6 2006)
Full build - apparently some of the libs were not passed correctly to subshells
 
Build 660 (Jun  6 2006)
Updated Rep Monitoring, Updated Batch Script/Console Documentation
 
Build 659 (Jun  1 2006)
Release version - fixed up some gotchas in unix-autodetect (was leaving comm path as SSH even if it could only get to the system via FTP)
 
Build 658 (May 31 2006)
Rotate Large Files, Do_RSH has better quoting, port_monitor.pl is signlethreaded by default
 
Build 657 (May 30 2006)
more none...
 
Build 656 (May 30 2006)
none
 
Build 655 (May 30 2006)
no notes
 
Build 654 (May 23 2006)
errr... aborted the last one - same - minor perl -w cleanup, fixed win32 configure.pl freezeups
 
Build 653 (May 23 2006)
perl -w testing. win32 configure.pl freezeups fixed
 
Build 652 (May 18 2006)
mod to autogen purge_files cfg files, sample cfg file redocumented
 
Build 651 (May 17 2006)
Final Alarms Screen Work, Updated Replication Monitor to better handle multiple rep servers
 
Build 650 (May 16 2006)
Some bug fixes in initial surveys to deal with multiple external SYBASE directories
 
Build 649 (May 12 2006)
added $SYBASE predefineds to surveys, more maint plan stuff
 
Build 648 (May 11 2006)
Plan Wizard Logic Added
 
Build 647 (May  5 2006)
Major Release
 
Build 646 (May  4 2006)
if SSH fails in configure.pl wizard - it trys FTP mode
 
Build 645 (May  3 2006)
Massive checks that METHOD is appropriately used in myFTP
 
Build 644 (May  3 2006)
CommonHeader.pm syntax error, removed junk docs
 
Build 643 (May  3 2006)
added dont_skip button
 
Build 642 (May  3 2006)
Auto Sybase Env in CommonHeader.pm, Version Report Updated, Handles Multiple Tempdb's better, Custom Titles in cgi-script, New cgi-script build process
 
Build 641 (May  1 2006)
bunch of minor stuff - not sure what
 
Build 640 (Apr 27 2006)
backup updates, bug fixes, puttering
 
Build 639 (Apr 19 2006)
updated backup docs, reorg moved before updstats, troubleshoot.pl halfway ported to gui mode (its broken now tho)
 
Build 638 (Apr 17 2006)
Added InstallState File To Clean Errors 
 
Build 637 (Apr 17 2006)
Update docs (pricing). Depricate --OVERRIDE. Add Facilities for Install State
 
Build 636 (Apr 13 2006)
Updated configure.pl to make a better console plus minor stuff
 
Build 635 (Apr 12 2006)
Added DUMP_FILES_PER_SUBDIR option to backup.pl/dump-database.pl/load_datbase.pl
 
Build 634 (Apr 10 2006)
MDA procs update / pod update for these procs
 
Build 633 (Apr  7 2006)
2 syntax errors in backup.pl
 
Build 632 (Apr  7 2006)
Build and Copy Console added to configure.pl
 
Build 631 (Apr  7 2006)
Print Handlers added to myFTP and do_rsh
 
Build 630 (Apr  7 2006)
Some Win32 Stuff Ended Up Running in Unix Only Build
 
Build 629 (Apr  6 2006)
Another Test Release - AM/PM fix within load_all_tranlogs.pl (was giving spurious error messages)
 
Build 628 (Apr  6 2006)
Test Version
 
Build 627 (Apr  4 2006)
bug fix to ssh code
 
Build 626 (Apr  4 2006)
SSH features added
 
Build 625 (Mar 20 2006)
renamed nt_batch_scripts to win32_batch_scripts
 
Build 624 (Mar 17 2006)
Console Update - Broke it up into clearer batch jobs
 
Build 623 (Feb 21 2006)
added perlargs env variable. Modified ping for linux versions
 
Build 622 (Feb 17 2006)
reorg_rebuild.pl optdiag_analyze.pl mssql_attachscript.pl minor mods
 
Build 621 (Feb 14 2006)

 
Build 620 (Feb 14 2006)
oopsie rebuilding configure.pl
 
Build 619 (Feb 14 2006)
Updated thresholds_overrides.dat
 
Build 618 (Feb  8 2006)
Backup Script Documentation, ping_systems.pl only alarms if reping fails, tracert.pl minor formatting
 
Build 617 (Feb  2 2006)
2 more updates to monitor.pl, df -k changed to df -kl
 
Build 616 (Feb  2 2006)
update to monitor.pl, update blackout reports
 
Build 615 (Jan 23 2006)
none
 
Build 614 (Jan 23 2006)
none
 
Build 613 (Jan 20 2006)
console changes; threshold manager; port monitor generator; stored proc changes
 
Build 612 (Jan 13 2006)
pass on wizard for installs - removing messages. nothing big
 
Build 611 (Jan  9 2006)
Test For Full Release. COnsole Changes. Audit Changes.
 
Build 610 (Dec 21 2005)
yes its build 610
 
Build 609 (Dec 13 2005)
full installer unit test
 
Build 608 (Dec 10 2005)
Mostly Done - All But The Plan Manager Reverse Engineering
 
Build 607 (Dec  8 2005)
again
 
Build 606 (Dec  8 2005)
oops - needed a tarbal
 
Build 605 (Dec  8 2005)
more bug fixes
 
Build 604 (Dec  6 2005)
Almost Done...
 
Build 603 (Dec  5 2005)
More minor configure.pl updates
 
Build 602 (Nov 30 2005)
Updates to the configuration utility
 
Build 601 (Nov 22 2005)
disabled buttons, new browser buttons for the configuration utility
 
Build 600 (Nov 18 2005)
updated runcommand to a window. broke out post-configure tasks in configure.lp
 
Build 599 (Nov 10 2005)
troubleshoot.pl rewrite
 
Build 598 (Nov  4 2005)
A few new reports and fixed logshipping full db resync
 
Build 597 (Nov  3 2005)
updated docs. worked on configure.pl.
 
Build 596 (Nov  2 2005)
Add Server Wizard
 
Build 595 (Oct 28 2005)
rename mlpalarms to gemalarms. fixed 2 batch jobs. added 2 new batch jobs
 
Build 594 (Oct 27 2005)
forgot 2 batch jobs, sql svr stored proc mods
 
Build 593 (Oct 19 2005)
upgrade.pl working and tested
 
Build 592 (Oct 19 2005)
Proc Lib Mods for Win32, 3 New Console Reports, Sys15 finished?
 
Build 591 (Oct 14 2005)
internals in configure.pl for backup_plan simplification
 
Build 590 (Oct 13 2005)
Final Testing Completed on System 15 - procs and alarm installer (probably need to do a full test on it but thats for later)
 
Build 589 (Oct 12 2005)
Phew... more and more documentation! pass 1 of the doc is done
 
Build 588 (Oct  7 2005)
New Standard GEM Reports, very minor look and feel tweaks
 
Build 587 (Oct  5 2005)
Documentation Upgrade
 
Build 586 (Sep 30 2005)
minor pg1 doc changes for configure.pl
 
Build 585 (Sep 30 2005)
PcCleanup made hourly; Post Install Tasks Doc Mod; Text change for Scheduled Task Manager
 
Build 584 (Sep 29 2005)
Updated Unix Log FIle Monitor
 
Build 583 (Sep 23 2005)
Documentation Bundle, Rep Server Screens Redone, Mostly a repackaging for shipping to the web site
 
Build 582 (Sep 21 2005)
system 15 modifications for Extended Stored Procedure Library
 
Build 581 (Sep 19 2005)
minor chg to a few reports, replication monitoring
 
Build 580 (Sep  9 2005)
FINAL VERSION FOR HOME TESTING
 
Build 579 (Sep  8 2005)
Test Version For Full Release! Console changes, Server Registration. Docs.
 
Build 578 (Sep  2 2005)
Pre Final - Redoing Server Entry Screens, Sybase Replication
 
Build 577 (Aug 27 2005)
pre vacation. console changes. working on data entry
 
Build 576 (Aug 22 2005)
Updated Console Reports (major upgrade). Many minor edits.
 
Build 575 (Aug  1 2005)
August Distribution
 
Build 574 (Aug  1 2005)
Final Backup Tab Changes, Minor weekend tweaks
 
Build 573 (Jul 31 2005)
UPgrade Documentation - console changes - finishing backup tab on config Jcombobox
 
Build 572 (Jun 14 2005)
Update of Console Layout, Directory Structure Changes, Minor Fixes

Build 571 (May 29 2005) Version for Release - Full Beta 1

Build 570 (May 26 2005)
crontab creation mods for clarity

Build 569 (May 21 2005)
Test unix and windows install - modified a few cosmetics

Build 568 (May 19 2005)
Retest Unix Installer; Updated Documentation; Javascript Console Menus

Build 553 * update the files tab to be clearer - save the files information into xml in better format * Setup.pl - needs a check on Win32 perl if you are on samba - but i dont do it * fix the fonts so stuff is readable - make them user defined * Add SQL Servers to Auto Documentation Schema * how wierd... wrong sa password works fine for odbc sql server connections. Guess windows networking is used by default. hmmm.... * use the internal connection for the stored procedure library installer instead of osql. Fact is... trusted connections work. move configure.pl for procs into a library add $* to .ksh interactive scripts Separate Validation and Installation Tabs - validation should have step by step validation Test Each button press in configure.pl Validate Alarm Installation Unimplemented

Build 552 * whole list of configure.pl cosmetic fixes. * win32 version freezes when you expand the friggin databases (click on plus) need my debugger

Build 543 * blocked process monitor was failing to detect log suspend * better mimi install * Worked on Win32 Batch scripts

Build 541 * setup process will build empty directories - apparently winzip does not create them * worked on documentation * integrated RosettaStone.pm * refresh explorer colors to reflect connection status * modified maint plans plugin - expanded navigator name and added rtclicks * modified the monitoring plugin to remove bug that occurred when you changed pages

Build 540 This release is the ``porting release''. I have attempted to run the *same* code line under multiple windows and unix boxes using multiple versions of perl. There were a several nightmares with Tk libraries causing freeze ups - and what i learned is that there is tight coupling between the versioning of the Tk add on libraries. This means that you cant just add perl modules like i had been doing and expect it to work every time every where. The solution is to require a reasonably recent version of Tk.pm to be installed so i dont need to provide the missing functionality. To summarize, i am removing the dependencies on perl and adding a dependency on your having a somewhat recent version of Tk.

I also had to remove some features that were screwing things up. Specifically, i removed the Bitmap images that were on the top left of the page. They were nice and allowed future features to be put in as image clicks, but unneeded since the buttons were not tied to anything useful.

 * worked on right clicks some more

Build 539 * turn off stdout prints - save instead to log file (it freees screen) * test the servers on the validation page of configure.pl * search and remove print statements - replace with _statusmsg() * prefetch DBI DSNs * remove choice of DSN for servers -> auto choose and require odbc * remove std output prints unless ur talking debug or god mode

Build 537 * rebuild of installer and testing * sp__stat2 prints error in procs/configure.pl * menuitems seem to function ok * added mda table viewing for ASE * need hourglass for busy * added Win32 and unix html viewing * helpdbdev - was incorrectly formatting

Build 536 * sp__lock page number not fitting in char(8) field Msg 265, Level 16, State 1 Server 'IMAGSYB1', Procedure 'sp__lock', Line 82 Insufficient result space for explicit conversion of INT value '106949706' to a CHAR field. * need a run_cmd module that works interactively instead of freezing TK * finished download capability for plugins * colorize the servers in explorer window * Added Copyright Notice * minor mod to sqlsvr sp__whodo * added error handling to rtclick

Build 535 * check adjustment of Mlpalarm.pm based on config falues * rebuild configure.pl * Cant install sql server stuff from unix (of course) - annotate * make a survey/discover function that works from setup better and shows result * rearchitected surveys * use connectionmanager in configure.pl * added RunCommand module * added sp__helpdb for sql server * added event model * modified backup scripts for -J options on a few other things * configure.pl for procedures seems to print use and dump statements

Build 534 * Added File Tab to configure.pl

Build 532 * Finish Backups Tab * reinvented cron jobs yet again * modified some code so dynamic repathing validation works better * add config screens cross tools so configure.pl is in gem.pl etc... * if NT the use ODBC, if Unix then Use Sybase... its that simple * Numerous fixes to a variety of things. * Integration of configure.pl and gem.pl * Color Coded Tree * Worked on Monitoring and Backups Plugin

Build 531 * build nt_local_scripts and unix_local_scripts correctly * fix translator for read_configfile to handle things correctly * dual perl includes - so it works both nt and unix * Finalize the configure.pl * dual environment stuff for shared Unix/Nt on samba drives

Build 530 * Mondified monitor_appslog to use File::Tail instead of File::Multitail

Build 529 (Sep 7 2005) * modified version string in gem.pl - was showing wrong. * several integration changes * removed all Win32 calls from bin/gem.pl - they were getting called even though they were in an eval block * Changed error message when creating crontab with bad file structure. * Added dist subdirectory to the conf subdirectory for raw files (saved) * documenter - changed default output destination to data/DAILY_REPORTS * change lock file location to data/lockfiles in CommonFunc.pm

Build 528 (Sep 7 2005)

 * Final Alpha Cleanup
 * MlpAlarms.pm has hard coded server in it
 * Significant FInal Cleanup
 * Add Mlpalarms to screen
 * Test Brand New Install
 * Use CONFIG{SYBASE} instead of $SYBASE

Build 526: Tue Jun 12 10:38:52 EDT 2001 remote symlinks for directories now supported better. Logdumps were not being purged when the directory was a symlink because the ftp fspec would return the symlink info not the info on the directory contents. Build 526: Mon Jun 4 10:42:59 EDT 2001 changed #BEIGE to BEIGE so odd colors not showing up in reports modifed config_report.pl so that image data from syscharsets not dumped added bin/newsuid.pl program to change suids on a server removed underscores in titles on documenter reports Build 306: Fri May 25 14:49:46 EDT 2001 modified server documenter look and feel modified config report to add some new tables to those being selected Build 305: Tue Mar 27 16:09:26 EST 2001 modified backup procedures to enhance hot backups via ftp modified several server documenter reports (minor) Build 304: Wed Feb 21 16:13:48 EST 2001 modified procedures.pl - was not taking DDL reports database as argument Build 303: Tue Feb 20 12:16:00 EST 2001 modified helpdb - for some reason status2&0x01=0x01 does not work where status2&1=1 does.... this inaccuratly showed some db options Build 302: Tue Feb 13 13:42:49 EST 2001 Modified troubleshoot.pl to change order of includes and to remove TERM::ANSIColor Build 301: Thu Feb 8 12:35:21 EST 2001 dbcc checker - reverse order of days shown core dump checker - summary report at end modified width of non formated sp__diskdevice - somehow it got>80 characters Build 293 fixed format of dbcc checker added check for login without legit def db Build 292 added dbcc checker Build 291 Mon Jan 29 14:24:02 EST 2001 Much cleanup on webmonitor screens added test for logins without default database Build 289 Tue Jan 23 10:16:46 EST 2001 renamed rsh_run_cmd.pl to run_cmd_on_all_hosts.pl modified messages for configuration problems with backup scripts added -o option for dbcc - output directory for raw output timestamped remote agent messages (remote_agent.pl) modified format on webmonitor procedures.pl screen modified version identification in webmonitor fixed webmonitor backup screen fixed debugging comment for greyed out buttons in webmonitor fixed problem ftping on nt servers (pwd() function in myFTP.pm) modified webmonitor screen selection for default users modified monitor screen comments when remote_agent is not up modified badindex stored procedure - changed defn of bad index to 90 bytes put $^X stmts into document_all.pl - there was a problem on pc's without it modified startup comment in dbcompare.pl utilitiy modified check_sybase_for_blocks for cleanliness of output modified format on configure screen added in sh.exe - a nt /bin/sh (had been omitted accidentally from release)

Sat Jan 20 15:53:28 EST 2001 modified server documenter for pc environment - put $^X so interpreter can deal etc... myFTP.pm modified for pwd() for local host (needed on pc's).

Thu Feb 14 11:56:07 EST 2002 Added First 100 Rows to extracter

Wed Mar 13 20:45:57 EST 2002 Multitude of install simplifications for the bad values in the config file situations. changed rev_db to output additional space between end and go. changed sp_addalias to remove aliases in model removed update stats bad message from

Thu May 29 08:49:45 EDT 2003 removed sybsystemdb from the list of 10011 error db's (data&log on same device)