10-23-2019, 12:43 PM
@lurkio
There's an old joke about a drunkard searching around a streetlamp at midnight. When asked what he's doing, he replies that he's looking for his car keys. When asked if this is where he dropped them, he says, "no, I dropped them in that dark alley but here under the streetlamp is where I can see." That's what I'm doing with a check of the keyboard output
OK, so here's how to examine the stored PSK. From the moOde CLI, we query the cfg_network table in the moOde sqlite3 database:
I ran the first sqlite command ".schema" just to show the organization of the network config table. The second command is the money maker. It should return exactly the same 64-character character string you generated by hand using wpa_passphrase. (I hand-edited 20 characters in my result to asterisks! The threat is low but I don't like passing any kind of security credential in plaintext.).
Regards,
Kent
PS - There's a curious remark you made back in post #20.
I have no way of replicating this. I believe Tim's a Mac user. I wonder if he can comment whether this is a clue or a distraction.
There's an old joke about a drunkard searching around a streetlamp at midnight. When asked what he's doing, he replies that he's looking for his car keys. When asked if this is where he dropped them, he says, "no, I dropped them in that dark alley but here under the streetlamp is where I can see." That's what I'm doing with a check of the keyboard output
OK, so here's how to examine the stored PSK. From the moOde CLI, we query the cfg_network table in the moOde sqlite3 database:
Code:
pi@moode4b:~ $ sqlite3 /var/local/www/db/moode-sqlite3.db
SQLite version 3.27.2 2019-02-25 16:06:06
Enter ".help" for usage hints.
sqlite> .schema cfg_network
CREATE TABLE cfg_network (id INTEGER PRIMARY KEY, iface CHAR (5), method CHAR (6), ipaddr CHAR (15), netmask CHAR (15), gateway CHAR (15), pridns CHAR (15), secdns CHAR (15), wlanssid CHAR (32), wlansec CHAR (4), wlanpwd CHAR (64), wlan_psk CHAR (64), wlan_country CHAR (2), wlan_channel CHAR (3));
sqlite> select wlan_psk from cfg_network where iface="wlan0";
e0cdc20da23a5fc6133a6********************b99e5a06c79683b9983d842
sqlite> .exit
pi@moode4b:~ $I ran the first sqlite command ".schema" just to show the organization of the network config table. The second command is the money maker. It should return exactly the same 64-character character string you generated by hand using wpa_passphrase. (I hand-edited 20 characters in my result to asterisks! The threat is low but I don't like passing any kind of security credential in plaintext.).
Regards,
Kent
PS - There's a curious remark you made back in post #20.
Quote:There is a funny behavior where safari suggests a password on the network configuration page but seems to get confused with the access point password field below it, however we have checked that is is registering and providing a key so I don't think it can be that
I have no way of replicating this. I believe Tim's a Mac user. I wonder if he can comment whether this is a clue or a distraction.
