CHANGELOG 0.98 * Added an additional check for the location of 'qshape.pl' (Bug 60) [TS : 2007-9-2] * Added a shell script to reset password when locked out of web-interface (Bug 64) [TS : 2007-10-16 ] * Fixed typo in install.sh (missing space between bracket) (Bug 62) [BJD : 2007-10-1] * Fixed some XHTML compliance issues [TS : 2007-12-15] * Added SHOW PROCESSLIST section to MySQL stats [TS : 2007-12-15] * Fixed an issue where the saved form feature of some web-browsers was causing the wrong username to be used when configuring options in the MySQL section (Bug 57) [TS : 2008-1-2] * Modified installation process to simplify installations using SVN versus standard releases (Bug 76) [TS : 2008-1-7] * Added a check to find the 'useradd' utility (Bug 78) [TS : 2008-1-9] * Fixed a broken link for viewing the large version of the disk 3 sectors graph [TS : 2008-1-9] * Added favicon [TS : 2008-1-23] * Added basic signal handling in graph.php (Bug 80) [BJD : 2008-1-24] 0.97 * Fixed an issue with the CPU Aggregate option (Bug 56) [TS : 2007-8-14] * Added a check in the installer to make sure install.sh is being run in the StatsDawg installation directory [TS : 2007-8-7] * Resolved an issue with the query cache hit rate being computed incorrectly [TS : 2007-7-24] * Changed Query Cache Graph to graph max data instead of average data [TS : 2007-7-16] * Added average questions per second to the MySQL Questions Graph (Bug 53) [TS : 2007-7-2] * Added MySQL uptime information (Bug 53) [TS : 2007-7-2] * Added Query Cache graph (Bug 52) [TS : 2007-7-3] * Added ability to configure a custom socket / port for MySQL Bug 54) [TS : 2007-7-3] 0.96 * Hardened configuration section by adding form validation and sanity checking. [TS : 2007-6-3] * Added checks to make sure user is running MySQL 5 when using InnoDB stats and graphs (Bug 49) [TS : 2007-6-3] * Modified code which grabs network statatistics to make sure it works on platforms which have non-standard devices such as Xen (Bug 50) [TS : 2007-6-3] * Added IceCast Listeners Graph [TS : 2007-6-3] 0.95 * Fixed an issue with install.sh not properly generating the initial configuration file correctly. (Bug 48) [TS : 2007-5-4] * Updated mysql.inc.php.dist (SVN only) to contain the default color scheme for the InnoDB Read / Write graph (Bug 48) [TS: 2007-5-4] 0.94 * Added MySQL InnoDB Reads / Writes Graph [TS : 2007-4-19] * Modified MySQL Connections graph to include connections running as well as open connections [TS : 2007-4-6] * Added Hit Rate to Key Buffer graph [TS : 2007-4-4] * Added Key Bufer and Buffer Pool Use % Graphs [TS : 2007-4-4] * XHTML 1.1 / CSS Compliance (Bug 41) * Added utils dir to include any sample files such as cron, httpd configuration files. Also include rpm spec file. * Changed Sort Using Table Scans to Sort Merge Passes since the former was not accurate (Bug 46) 0.93 * Added logout link in navigation bar * Check for SSL and report if not using SSL mode (Bug 40) * Added password hashing for auth module (Bug 39) * Setup installer to create a non-root user for StatsDawg (Bug 38) * Removed option to specify location of qshape.pl for Postfix graphs as it was a security risk. Working on a better solution. * Added file-locking to prevent multiple copies of collectstats.php and graph.php from running. (Bug 36) * Added command-line arguments to installer. This allows non-interactive installations. Useful for package-management systems (RPM, DEB, etc.). (Bug 37) * Added a colorizing function which, tied with CSS, will colorize values that are beyond certain thresholds. Useful for things like the MySQL key_buffer use percentage. (Bug 8) * Added a '-q' to PHP command for PW_HASH operation in install.sh in order to supress content header output from PHP command. (Bug 42) * Added a 'isHTTPS' function to lib/functions.inc.php, and check for SSL Mode in config/global.inc.php. Warn user if not connecting over HTTPS/SSL (Bug 40) 0.92 * Fixed major bugs in the installer which did not setup the proper permissions for Apache nor did it generate a compatible cronjob script that worked properly across various cron distributions. * Added more MySQL statistics * Added a configurable option for the Postfix Graph to specify the name and location of the 'qshape' utility. * Changed the default configuration of StatsDawg to enable the auth module by default. 0.91 * Added Web-Configuration Panel * Added an automated installer upgrader! 0.85 * Added Kernel Messages section to stats * Cleaned up the configuration a bit. * Added 'getMySQLVersion' to lib/functions.inc.php, and removed rrdConf global variable for MySQL Version * Re-ordered some of the configuration options out of the main config.inc.php and into the respective config files under 'conf' * Integrated graphs and statistics into their own respective section. For example, the MYSQL section contains both the MySQL graphs and information about the query cache, etc. This made the code for the front-end much cleaner, allows for easier module integration, and seems to make a bit more sense. * Change some of the variable-names. Most of the changes involved changing something like $rrdConf['useMySQLGraphs'] to $rrdConf['useMySQLStats']. * Removed obselete configuration options. * Added Apache error_log reporting in Apache section * Changed wording of some variables to conform to a more uniform standard. All variables that began with 'show' now begin with 'enable', etc. * Modules now use a 2D array (ie $rrdConf['mysql']['enableQuestionsGraph']) + Take some time out of your day to reflect on this change, since it was a huge pain in the ass to do :) + The DB definitions now actually use a 3D array to keep things separate without interfering with the modules themselves (all DBs are created at install regardless of whether or not they are used since they only take up a small amount of space) * Added $rrdConf['wordWrapThreshold'] to config.inc.php. That was those with bigger or smaller displays can tweak it as needed. * Added hard-disk graphs and Software RAID reporting * Removed additional network interface color options + Now there is only one set of colors to set for all network interface graphs. This simplified the graph generation code * Added simple user authentication 0.81 * Fixed an issue where abnormal spikes appear for the MySQL and Apache requests per second graphs. * Modified the method for enabling/disabling modules. Instead of uncommenting the lines in the config.inc.php file, all one needs to do is rename or copy the .inc.php.dist file for the module in question to inc.php and edit the contents. * Fixed an issue where the query cache reporting was not working correctly on MySQL versions prior to 5. * Added a variable in mail.inc.php to define where the qShape script is located (and what it is called). This was implemented since some distributions called the file 'qhsape' and other 'qshape.pl' Similarly, the file was found to be in various different locates on different systems. * Other misc bugfixes. 0.80 * Added MAX RRA's to all databases except the load-average database. * Impelmented peak / max output for Apache Requests, MySQL Questions, and + Network Interface graphs when viewing the graph over a period of time than a day. * Added support to graph postfix queues using qshape.pl (requires that StatsDawg be installed as root) * Attempetd to make configuration of StatsDawg easier by splitting out the extra configurable modules (Apache, MySQL, Postfix, etc.) into their own configuration files in a config directory. * Added option to change the sub-title * Made a small modification to the awk statsments used in the program. gawk supports --field-separateor, mawk and other variants to do. So it was replaced with -F, which is a POSIX standard extention. 0.76 * Fixed LAN/WAN graph legends. They were backwards * Change Load Average graph to use LINE2 instead of AREA * Added bandwidth totals for LAN/WAN graphs * Updated Help documentation, sorta