hostapd/hostapd.eap_user_sqlite

   1 CREATE TABLE users(
   2         identity TEXT PRIMARY KEY,
   3         methods TEXT,
   4         password TEXT,
   5         remediation TEXT,
   6         phase2 INTEGER,
   7         t_c_timestamp INTEGER
   8 );
   9
  10 CREATE TABLE wildcards(
  11         identity TEXT PRIMARY KEY,
  12         methods TEXT
  13 );
  14
  15 INSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1);
  16 INSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1);
  17
  18 INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS');
  19 INSERT INTO wildcards(identity,methods) VALUES ('0','AKA');
  20
  21 CREATE TABLE authlog(
  22         timestamp TEXT,
  23         session TEXT,
  24         nas_ip TEXT,
  25         username TEXT,
  26         note TEXT
  27 );
  28
  29 CREATE TABLE pending_tc(
  30         mac_addr TEXT PRIMARY KEY,
  31         identity TEXT
  32 );
  33
  34 CREATE TABLE current_sessions(
  35         mac_addr TEXT PRIMARY KEY,
  36         identity TEXT,
  37         start_time TEXT,
  38         nas TEXT,
  39         hs20_t_c_filtering BOOLEAN,
  40         waiting_coa_ack BOOLEAN,
  41         coa_ack_received BOOLEAN
  42 );