I have remote sites running on CENTOS Linux logging event detail information locally to a MYSQL database. (Remote Sites)
I would like to create a simple WEB/PHP/MYSQL application on a host machine to query the remote sites, manipulate and filter data, and report and email results. (Host Site)
I envision the host application that will run on CentOS linux in a LAMP environment.
The host web application will contain a simple table of target sites (remote sites).? This will be a password protected application what will allow the addition, deletion and modification of remote sites data to include information as to IP address, report email address, site id, email message, MYSQL credentials and report scheduling options such as monthly, weekly and on demand.
For each target remote site there will be a report definition screen to contain the report criteria for each remote site report.? This will be a one page screen to be able to enter filter/report criteria for each remote target site.? The remote sites all have the same database/table structure which is 12 fields.
Two development servers will be provided for this application.? One server to develop the host reporting code and another server with sample remote site with sample data.
The design goal would be to have all code, report definitions and options reside on the (host site) with only remote query’s to the remote sites.
Please advise on the feasibility