I use Awstats web log analyzer to get Apache web server log reports.
Currently the report is HTML report.
Need this exported to database.
Reason, I want to report web stats and also some figures from the user registration table I have in the MySQL database.
What I need:
1. Script to run awstats web log analyzer daily.
2. Output result to MySQL tables.
2.1 One table for each stat e.g. visitors table, pages table, hits table.
2.2 Each day create new record in each stat table.
2.3 Each table has today date, server, day, month, quarter, year
You must have good experience with Apache log, stats engines, MySQL and Linux. This is NOT a request to move apache log to MySQL. I need the RESULT of Log ANALYZER put to tables.
Can consider other options for reporting database and web stats together.
5 freelancers estão ofertando em média $87 para este trabalho
Sounds like an interesting project. Personally I like these sorts of data mining projects and would provide you with a quality product. For more details see PMB.