TheFont Posted May 6, 2019 Share Posted May 6, 2019 Today I needed to fix my pineapple.db file for the second time in an hour. My ssids in pool is empty en the Home page shows 103 ssids in pool. What I do to solve this is downloading the pineapple.db file and remove corrupted entries in the ssid table. I upload the corrected file and then I can see all ssids in the pool again. Is there a way to prevent corrupt entries from being entered in the table? Link to comment Share on other sites More sharing options...
TheFont Posted May 7, 2019 Author Share Posted May 7, 2019 If I do a select statement on the table ssids I get the following error: sqlite3.OperationalError: Could not decode to UTF-8 column 'ssid' with text 'g▒isQ▒J▒)ͺ▒▒▒▒F|▒T▒▒vZ.c3▒ɚ' Link to comment Share on other sites More sharing options...
TheFont Posted May 9, 2019 Author Share Posted May 9, 2019 Can anyone tell me how to execute a python script from the web interface? I wrote a script that cleans up the pineapple.db file so all SSIDS in Pool are visible again after running this script. The script is not complete yet but it is functional already. If I can integrate it in the web interface I would love to share it as a plugin for the pineapple tetra and hopefully also nano. Link to comment Share on other sites More sharing options...
shellprompt Posted May 10, 2019 Share Posted May 10, 2019 I am seeing the same problem on a nano running 2.5.4. @TheFont what is your method for resolution? Link to comment Share on other sites More sharing options...
TheFont Posted May 12, 2019 Author Share Posted May 12, 2019 On 5/10/2019 at 8:47 PM, shellprompt said: I am seeing the same problem on a nano running 2.5.4. @TheFont what is your method for resolution? I am doing it manually by downloading the pineapple.db from /etc/pineapple and then edit it whit a sqlite editor. If you look at the ssids table you will see some corrupted entries. You have to remove these entries and then upload the file back to the pinaeapple. I am working on a script that does this automatically for me. Once the script works I will try and get it uploaded as a module to my pineapple so this can be resolved via the pineapple without downloading and uploading. Link to comment Share on other sites More sharing options...
Foxtrot Posted May 20, 2019 Share Posted May 20, 2019 Hi, Thank you for reporting this issue - it's something I've been looking into the past couple of days to try and narrow down, but could do with some more information. Did you add the SSIDs manually? Either by typing the SSID into the Pool management box in the UI, or by adding it to the Pool via a Recon scan in the UI, or was the SSID added to the database automatically through the "Capture SSIDs to Pool" PineAP option? If you could attach the /etc/pineapple/pineapple.db database here, it would be very helpful. Be aware that the database will contain other information, such as Filter MAC Addresses and SSIDs, so remove those if you don't want them public. Kind Regards, Foxtrot Link to comment Share on other sites More sharing options...
shellprompt Posted May 20, 2019 Share Posted May 20, 2019 I literally just cleared it again. I will get you one within the next 24 hours. Link to comment Share on other sites More sharing options...
shellprompt Posted May 20, 2019 Share Posted May 20, 2019 To answer your other question @Foxtrot I have not added any SSID's manually. The corruption is occurring for me from collated SSID's only. Link to comment Share on other sites More sharing options...
shellprompt Posted May 20, 2019 Share Posted May 20, 2019 @Foxtrot corruption has occurred again after around 4-5 hours, and I have the DB. looks like row 19 is the offender. You can download https://drive.google.com/open?id=1MG5p7MUDcS4AfrsHVbooT_oAq7p__obg I had to delete a few rows as I have API keys. If you want the original DB please let me know how to get it to you directly. Link to comment Share on other sites More sharing options...
shellprompt Posted May 21, 2019 Share Posted May 21, 2019 @Foxtrot did you get what you needed? This is happening to me within 2 hour windows. Link to comment Share on other sites More sharing options...
b0N3z Posted May 22, 2019 Share Posted May 22, 2019 I have had the same issues with just PineAP enabled and collecting ssid. usually after about 2hrs it starts recording these jacked up ssid's. No recon adds or manual entries. both on nano and tetra. But have been noticing more on the nano than the tetra and my tetra is on almost 24/7 collecting ssid Link to comment Share on other sites More sharing options...
TheFont Posted May 24, 2019 Author Share Posted May 24, 2019 Hello @Foxtrot , thank you for your reply. The corrupted entries are all added to the database automatically through the "Capture SSIDs to Pool" PineAP. Attached to this message you will find a pinapple.db file with only the corrupted entries. pineapple.db Link to comment Share on other sites More sharing options...
Keld Norman Posted October 1, 2022 Share Posted October 1, 2022 I am seeing the same error (strange SSID names ) at 2022 running pineapple version 2.1.2 - it seems like this error have never been fixed ? Link to comment Share on other sites More sharing options...
dark_pyrro Posted October 3, 2022 Share Posted October 3, 2022 If running the Tetra on firmware 2.1.2 then it needs to be updated. There are several Tetra updates available up to the most recent 2.6.2. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.