Need a database to store big mail server logs. It needs to read POP, SMTP, IMAP & Delivery logs (examples will be provided).
We need a script that runs daily that will read the next generated file for the day. For example at 5Am each day the script will run to match the file format for that day and dump that into SQL DB.
The database needs to be searchable and each of those seperate tables are in the same database.
The name of the file (which is the date) needs to be a column in that database as well so when it pulls the file name it needs to add it to the database in a new column called date.
If you have any questions please fee free to ask or place your bid so we can have further discussion
data needs to be encrypted example INSERT INTO maildata-pop3 VALUES ("2015-05-01 20:40:21", AES_ENCRYPT("126.96.36.199", 'mypassword'), AES_ENCRYPT("USER email@example.com", 'mypassword'));
For the end result we would need a powershell script or a bat script that we can run in the task scheduler but you can use php or script as long as we can get the task scheduler to run it
45 freelancers are bidding on average $1281 for this job
Hi, I'm senior web developer and I'm very interested in your project. I've done many projects. Hope I will have a chance to work for you on this project. Please contact me. Thanks