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 );
   8
   9 CREATE TABLE wildcards(
  10         identity TEXT PRIMARY KEY,
  11         methods TEXT
  12 );
  13
  14 INSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1);
  15 INSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1);
  16
  17 INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS');
  18 INSERT INTO wildcards(identity,methods) VALUES ('0','AKA');
  19
  20 CREATE TABLE authlog(
  21         timestamp TEXT,
  22         session TEXT,
  23         nas_ip TEXT,
  24         username TEXT,
  25         note TEXT
  26 );