Please only apply if you have confident about it to accomplish.
I am using syslog-ng on a ubuntu machine.I am getting all the log as a message on mysql db.
This is how i am receiving the message DST_RTR forward: in:<pppoe-user1> out:vlan100-Default-Internet, src-mac 11:22:33:44:55:66, proto TCP (ACK,FIN), [login to view URL]:42670->[login to view URL], NAT ([login to view URL]:42670->18.104.22.168:42670)->[login to view URL], len 52
Now i want to separate this messages in different column like- time,username,src mac,src ip,dst ip, nat ip to save it on mysql. And also i want to save log in a temp folder and parse them to mysql separately with the required column with crontab or maybe a php script? I have seen some xml script regarding parsing data separably to mysql .Maybe this can be achieve with xml. But Not sure.
6 freelancer menawar dengan rata-rata $55 untuk pekerjaan ini
I did a project for monitoring windows,unix,router [login to view URL] unix and router I worked on [login to view URL] I can help you in [login to view URL] you send me sample log?