I need the following created - it should be a cron script running on Linux, you may program this in PHP or Perl (PHP is preferred):
1. MySQL Database Backend
? ? ? ? a. tbl_computers: unique ID, IP address, and account #
? ? ? ? b. tbl_account: unique ID, fname, lname, company, email
? ? ? ? c. tbl_blacklists: unique ID, name, access method, lookup address
? ? ? ? d. tbl\_statistics: unique ID, tbl\[login to view URL], tbl\[login to view URL], error\_txt
2. Tests and Notification Which Must Be Implemented
? ? ? ? a. Open Relay Check against the computers listed in tbl_computers
? ? ? ? b. Reverse DNS Check against the computers listed in tbl_computers
? ? ? ? c. Blacklist Monitoring
? ? ? ? ? ? ? ? a.? <[login to view URL]>? -?
? ? ? ? ? ? ? ? b.? <[login to view URL]>? - includes a list of DNSBL's that we want to implement for the blacklist check / monitoring.? ? We want to implement \*all\* of the non-paid inclusion lists.? These are simple DNS query checks, so we should be able to add them to tbl_blacklists and have the? script check? each computer against each blacklist in a fairly expedient manner.
? ? ? ? ? ? ? ? c. Notification via Email when a computer becomes "listed" on one of the DNSBL's.
? ? ? ? ? ? ? ? d.? Every? time a computer? is "checked" it should be recorded to tbl_statistics.