Find Jobs
Hire Freelancers

Tshark / Wireshark output direct to MySQL DB

£20-250 GBP

완료함
게시됨 7년 이상 전

£20-250 GBP

제출할때 지불됩니다
I am looking for someone who has experience in Tshark ( Wireshark command line ), MySQL and Python. I am running a Tshark command that gathers 4 pieces of information. MAC Address, TimeStamp, RSSI Value and SSID. The Tshark command is already being used and works as expected and is being run on a Raspberry PI 3 using a KALI ( Debian ) build. The Tshark command is as follows; /usr/bin/tshark -l -I -i wlan1 -T fields -e [login to view URL] -e frame.time_epoch -e radiotap.dbm_antsignal -e [login to view URL] -E occurrence=f type mgt subtype probe-req of which the results would be Capturing on 'wlan1' 60:f1:89:16:0d:c2 1482945369.483895578 -33 O2 Wifi 60:f1:89:16:0d:c2 1482945369.485306917 -35 O2 Wifi.1x 60:f1:89:16:0d:c2 1482945369.486678152 -34 Wifi Extra What i need to do is send the output of the Tshark command direct to a local MySQL database. I have read that this should be possible via a pipe and "awk" command ?? See this post - [login to view URL] The RPI has MySQL server installed and running locally with a single DB and a Table which has 4 fields MAC - Timestamp - RSSI - DroneID I'm not actually interested in the SSID but collect it anyway. The DroneID is set via a config file ( php ) on the RPI and will need to be inserted onto the table as part of the import. This is critical as i run several RPI's, each with there own ID an id need to know which one the traffic is related to as eventually the plan is to synchronize all localhost DB's with primary server at AWS.... see below This is an initial mini project part of a larger plan ( all based around this initial stage ) which i would be happy to discuss once i know you skill set and you have proven you know what your doing by completing this. Please only respond if you have experience and skills in using Tshark / Wireshark / Libpcap, MySQL and Python, although Python is part of the bigger project and not really necessary for this.. ** If you know what your doing i wouldn't expect this to take much more than an hour to complete and i will require a successful test on my own dev RPI to complete this work. If you need more info please ask.
프로젝트 ID: 12629527

프로젝트 정보

6 제안서
원격근무 프로젝트
활동 중 7년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
Hi, yes via pipe and python (or any similar) is a simpliest solution. If you will respond quickly i will do it today ~1-1.5h. My timezone is gmt+3, i have 1.5h before sleep. Also I can do it tomorrow if possible.
£50 GBP 1일에
5.0 (29 건의 리뷰)
4.9
4.9
6 이 프로젝트에 프리랜서들의 평균 입찰은 £75 GBP입니다.
사용자 아바타
I understand well what you want I can start right now dont waste your time ******************************************
£111 GBP 2일에
5.0 (17 건의 리뷰)
5.5
5.5
사용자 아바타
Hi, thank you for explaining the project in such detail. From my experience it should not take more than 3 hours to make and test the script. If you can share connection details to your RPI it would make things much faster. Please ping me if that is possible, and i will try my best to make you happy with final product. BR, Jurica
£50 GBP 1일에
5.0 (15 건의 리뷰)
3.8
3.8
사용자 아바타
seems straight forward. I would just need to make sure the db has enough bandwidth and i/o to handle the inserts.
£150 GBP 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I 've already worked on something similar and have the script that you need 80% done. i assume the number of rows for the tshark output is variable, correct?
£38 GBP 3일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED KINGDOM)
Hinckley, United Kingdom
5.0
2
결제 수단 확인
12월 20, 2015부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.