Find Jobs
Hire Freelancers

Syslog-ng to parse message to mysql in separate column

$10-30 USD

Closed
Posted almost 4 years ago

$10-30 USD

Paid on delivery
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->9.9.9.9: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.
Project ID: 24690791

About the project

6 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average $55 USD for this job
User Avatar
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 in 7 days
5.0 (39 reviews)
5.3
5.3
User Avatar
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 it allows to log seperate fields. Thanks
$65 USD in 2 days
5.0 (48 reviews)
5.2
5.2
User Avatar
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 because I have done this kind of project very recently which was to extract data from SMTP server's log file and save it in mysql db. Let me know if you have any question. Regards Suresh
$30 USD in 2 days
4.9 (20 reviews)
4.6
4.6
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 programmed different scripts in Bash, Perl and Python. I read all requirements, I’m ready to start now. Write or hire me to discuss about this project.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BANGLADESH
Sylhet, Bangladesh
5.0
4
Payment method verified
Member since Aug 19, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.