diff options
| author | Cy Schubert <cy@FreeBSD.org> | 2024-07-21 18:51:46 +0000 |
|---|---|---|
| committer | Cy Schubert <cy@FreeBSD.org> | 2024-07-21 18:51:46 +0000 |
| commit | 6377230b3cf4f238dcd0dc2d76ff25943d3040e5 (patch) | |
| tree | 2483f51eeccad28990306ede909a674305ac4488 /hostapd/hostapd.eap_user_sqlite | |
| parent | 950d2f43375b87e95ebc0ecda9b281b84b2213d7 (diff) | |
wpa: Import hostapd 2.11 into wpavendor/wpa
Diffstat (limited to 'hostapd/hostapd.eap_user_sqlite')
| -rw-r--r-- | hostapd/hostapd.eap_user_sqlite | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/hostapd/hostapd.eap_user_sqlite b/hostapd/hostapd.eap_user_sqlite new file mode 100644 index 000000000000..411b9eafa264 --- /dev/null +++ b/hostapd/hostapd.eap_user_sqlite @@ -0,0 +1,42 @@ +CREATE TABLE users( + identity TEXT PRIMARY KEY, + methods TEXT, + password TEXT, + remediation TEXT, + phase2 INTEGER, + t_c_timestamp INTEGER +); + +CREATE TABLE wildcards( + identity TEXT PRIMARY KEY, + methods TEXT +); + +INSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1); +INSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1); + +INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS'); +INSERT INTO wildcards(identity,methods) VALUES ('0','AKA'); + +CREATE TABLE authlog( + timestamp TEXT, + session TEXT, + nas_ip TEXT, + username TEXT, + note TEXT +); + +CREATE TABLE pending_tc( + mac_addr TEXT PRIMARY KEY, + identity TEXT +); + +CREATE TABLE current_sessions( + mac_addr TEXT PRIMARY KEY, + identity TEXT, + start_time TEXT, + nas TEXT, + hs20_t_c_filtering BOOLEAN, + waiting_coa_ack BOOLEAN, + coa_ack_received BOOLEAN +); |
