Hey guys,

this is my first tutorial so be nice

In this tutorial i will show you some sqlite commands in combination with airolib-ng.

In this tutorial i will use the database "testdb".

First we have to know the database schema:

Code:
airolib-ng testdb sql 'SELECT * FROM sqlite_master'
Now we will see the tables, relations and datatypes which are in the database.

Code:
airolib-ng testdb sql 'SELECT passwd FROM passwd' > passwd.txt
Will write all passwords which are included in the database to the file "passwd.txt".

Code:
airolib-ng testdb sql 'DELETE FROM essid WHERE essid = "deletewlan"'
Will delete the essid "deletewlan" (without quotes) in our database.
All relations to the PMKs and the PMKs for the essid will be deleted too.

I will add more commands from time to time.

Feel free to post comments.

regards