WillCool Code
Status: Beta
Brought to you by:
william_massey
| File | Date | Author | Commit |
|---|---|---|---|
| Image | 2009-01-07 | william_massey | [r10] |
| ajax.js | 2009-07-08 | william_massey | [r16] |
| errorcodes | 2009-01-07 | william_massey | [r10] |
| frame_aa.html | 2009-01-07 | william_massey | [r10] |
| frame_aa.pl | 2009-07-13 | william_massey | [r19] |
| frame_aa_get_data.php | 2009-01-07 | william_massey | [r10] |
| frame_bb.html | 2009-01-07 | william_massey | [r10] |
| frame_bb.pl | 2009-07-13 | william_massey | [r19] |
| frame_bb_get_data.php | 2009-01-07 | william_massey | [r10] |
| frame_cc.html | 2009-01-07 | william_massey | [r10] |
| frame_cc.pl | 2009-07-13 | william_massey | [r19] |
| frame_cc_get_data.php | 2009-01-07 | william_massey | [r10] |
| frame_dd.html | 2009-01-07 | william_massey | [r10] |
| frame_dd.pl | 2009-07-08 | william_massey | [r18] |
| frame_dd_get_data.php | 2009-01-07 | william_massey | [r10] |
| frame_main_bb.html | 2009-01-07 | william_massey | [r10] |
| frame_main_bb.pl | 2009-01-07 | william_massey | [r10] |
| frame_main_dd.html | 2009-01-07 | william_massey | [r10] |
| frame_main_dd.pl | 2009-01-07 | william_massey | [r10] |
| frame_main_get_data_bb.php | 2009-01-07 | william_massey | [r10] |
| frame_main_get_data_dd.php | 2009-01-07 | william_massey | [r10] |
| frame_month_bb.pl | 2009-01-07 | william_massey | [r10] |
| frame_month_dd.pl | 2009-01-07 | william_massey | [r10] |
| frame_month_get_graph_bb.php | 2009-01-07 | william_massey | [r10] |
| frame_month_get_graph_dd.php | 2009-01-07 | william_massey | [r10] |
| frame_realtime_1.html | 2009-01-07 | william_massey | [r10] |
| frame_realtime_1.pl | 2009-01-07 | william_massey | [r10] |
| frame_realtime_2.html | 2009-01-07 | william_massey | [r10] |
| frame_realtime_2.pl | 2009-01-07 | william_massey | [r10] |
| frame_realtime_get_data_1.php | 2009-01-07 | william_massey | [r10] |
| frame_realtime_get_data_2.php | 2009-01-07 | william_massey | [r10] |
| frame_title.html | 2009-01-07 | william_massey | [r10] |
| index.html | 2009-01-07 | william_massey | [r10] |
| license.txt | 2009-01-07 | william_massey | [r10] |
| readme.txt | 2009-02-17 | william_massey | [r14] removed 'hello william' |
| willcool.css | 2009-01-07 | william_massey | [r10] |
| willcool_crontab | 2009-01-07 | william_massey | [r10] |
Knowledge of Perl, HTML, Javascript and PHP is required to install and configure this software. Notes are sporadically inserted as comments in the code. - A perl script runs via crontab, logs onto the DB instance, creates a temp file and runs it, then deletes the temp file. - The output of the commands is captured and stored locally in a .tmp file. - The same perl script then scans this .tmp and extracts the required info, placing the formatted output into a .txt file. - The .html file reads this .txt data and displays it in realtime, making a call to re-read the file at regular intervals via a PHP interface. - A perl script exists for each clustered db. WillCool is designed to monitor up to 4 clustered databases with 2 nodes per cluster. - This can be adapted as required. Each perl script has been made fully configurable to accomodate the small variances between nodes in a network i.e. security policies/default shell/file system/oracle home location/other environment variables.