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.