dem2144 Posted February 19, 2019 Share Posted February 19, 2019 Good afternoon, I am working on a project to see if it is possible to record the mac addresses that appear in the recon mode or devices that connect to the wifi pineapple network. Is this possible? if so please let me to the right direction to perform this solution. Thanks, Link to comment Share on other sites More sharing options...
Foxtrot Posted February 20, 2019 Share Posted February 20, 2019 I'm not sure what the title is referring to, but - you can read all the MAC addresses from your Recon results by browsing the sqlite3 database in /tmp/recon.db (or the path you specified via the Web UI). Link to comment Share on other sites More sharing options...
dem2144 Posted February 21, 2019 Author Share Posted February 21, 2019 Thank you for responding. Well, basically I need to be able to export the data from the recon.db file and import it into my host MySQL database some way. I am also attempting to find a solution without having to do it manually. Here are the steps I am attempting to automate 1. Run a time interval recon scan report 2. Export the report (it could be in a recon.db file or direct connection to my host server) 3. Import the new data into my hosted MySQL database via insert query If this is not possible Then I would not mind being able to export the recon.db generated file to my local machine and then I can run a script to complete the solution. Whatever recommendations you would be appreciated. Thank you for your help. Link to comment Share on other sites More sharing options...
Foxtrot Posted February 21, 2019 Share Posted February 21, 2019 You'll be able to run a recon scan for a specified amount of seconds with 'pineap /tmp/pineap.conf run_scan <seconds> 0'. If the PineAP Daemon is not running, start it with '/etc/init.d/pineap start'. The WiFi landscape that Recon sees will get written to /tmp/recon.db. The SQLite has multiple tables for APs and Clients. You can see more in depth by just opening it with sqlite3 or similar tool to browse the DB. You will have to do the importing to MySQL on your own. Use cron to automate the process every X hours, etc. Link to comment Share on other sites More sharing options...
dem2144 Posted March 1, 2019 Author Share Posted March 1, 2019 Thank you, with your guidance, I was able to solve my problem. sqlite3, batch files, and task scheduler became my new friends during my research. My final issue if you could help me, please. I would like to temporarily allow the user to connect to the network using EP so that I can run a query and then I want to close the connection and return them to the captive portal. I believe this line "exec("iptables -t nat -I PREROUTING -s {$clientIP} -j ACCEPT");" In the portal.php is the line that connects the user to the network. How can I drop the user from the network AFTER they connect and then redirect them to a "confirmation page" within EP? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.