Syslog-ng to parse message to mysql in separate column

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->>[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.

Keahlian: Linux, PHP, XML, MySQL, Shell Script

Lihat lebih lanjut: php script read pop3 email message mysql database, php script parse email mysql, php parse xml mysql, parse html mysql, mysql loop column, error message 1054 unknown column pproducts_id clause advanced_search_resultphp, loop mysql rows column php, perl script parse log mysql, parse email message mysql, mysql lookup column, parse email mysql, mysql unknown column clause count, asterisk auto dial deliver message mysql, php mysql loop column results, mysql unknown column

Tentang Pemberi kerja:
( 4 ulasan ) Sylhet, Bangladesh

ID Proyek: #24690791

6 freelancer menawar dengan rata-rata $55 untuk pekerjaan ini


I am good in shell script, perl, php along with log parsing, please let me know if you are good to award this project to me

$110 USD dalam 7 hari
(39 Ulasan)

Hi, This can be achieved with shell script. You may need a different table to hold the splitted fields. Shell script can handle mysql data easily. By the way i would also like to verify the syslog-ng configuration as i Lebih banyak

$65 USD dalam 2 hari
(48 Ulasan)

Hi, I am confident that I can write a PHP script to extract data to different columns as per your requirements. Please send me few sample messages i.e 15 messages or so, so that I can test my script. I am confident bec Lebih banyak

$30 USD dalam 2 hari
(20 Ulasan)

hi, im good at script, shell or python can do this. as your said we can set a cron job for this. hope i can helo you do this. thanks

$50 USD dalam 3 hari
(0 Ulasan)

I'm system Engineer with more 15 years of experience. In that 15 years I management different kind of S.O Linux, Windows and Unix such as: Debian, Ubuntu, Centos and Red Hat. But I feel good with Linux. Also I have pro Lebih banyak

$20 USD dalam 7 hari
(0 Ulasan)

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?

$56 USD dalam 5 hari
(0 Ulasan)