Tshark / Wireshark output direct to MySQL DB

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 [url removed, login to view] -e frame.time_epoch -e radiotap.dbm_antsignal -e [url removed, login to view] -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 - [url removed, login to view]

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.

Compétences : MySQL, Python, Architecture Logicielle

en voir plus : software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, prevent direct download file php, software write books, export mysql query file php, create excel file php mysql, software write protection, upload multi file php mysql, free software write book, upload pdf file php mysql, create report excel file php mysql, upload doc file php mysql, software write book, output excel file php, upload csv file php mysql, convert data mysql pdf file php, mysql output tab delimited file, upload file php mysql script

Concernant l'employeur :
( 2 commentaires ) Hinckley, United Kingdom

Nº du projet : #12629527

Décerné à:


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.

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% GBP en 1 jour
(28 Commentaires)

6 freelance font une offre moyenne de £75 pour ce travail


I understand well what you want I can start right now dont waste your time ******************************************

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(14 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(13 Commentaires)

Dear Sir ! I think you need something similar like this: while true do tshark-command 'blabla' -b duration:600 |awk 'BEGIN {FS=":"};{print "insert into tbl_name (MAC,Timestamp,RSSI,Droneid) values (\047 $1 \047 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(4 Commentaires)

seems straight forward. I would just need to make sure the db has enough bandwidth and i/o to handle the inserts.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)

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?

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)