Procedures available for download
Controlling the system and access is something to be done regularly. Two of these tasks are scanning the web access log for deliberate abuse attempts (weekly) and the mail statistics (monthly).
Checking the weblogs means scanning hundreds of lines, and the number of actual attempt is rather low, and getting the mail statistics is just a matter of counting records in the logs. Both very boring activities the system can do faster and with less errors than any human can.
So I wrote DCL procedures to do it: WeblogScan.com for scanning the WASD logfiles, and pmas.com for counting mail statistics from the PMAS logfiles. You cannot user them without chnaging some information, but what to adapt has been noted well in the scripts.
Another handy procedure – that requires some localilty settings adapted as well – is my MYSQL watchdog. It allows MySQL to be down for a maximum of 15 minutes after a crash.
All files are free, you can use them to make your life a bit easier.
Don’t rely on them blindly. They work for me and I’m satisfied with them. That they work for me doesn’t automatically mean they work for you. No guarantee, no support (well, if you knwo a way to enhance them, please supply feedback so everyone can benefit of your experience).
You may pass them on but please leave the header intact.