hostapd.eap_user_sqlite 624 B

1234567891011121314151617181920212223242526
  1. CREATE TABLE users(
  2. identity TEXT PRIMARY KEY,
  3. methods TEXT,
  4. password TEXT,
  5. remediation TEXT,
  6. phase2 INTEGER
  7. );
  8. CREATE TABLE wildcards(
  9. identity TEXT PRIMARY KEY,
  10. methods TEXT
  11. );
  12. INSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1);
  13. INSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1);
  14. INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS');
  15. INSERT INTO wildcards(identity,methods) VALUES ('0','AKA');
  16. CREATE TABLE authlog(
  17. timestamp TEXT,
  18. session TEXT,
  19. nas_ip TEXT,
  20. username TEXT,
  21. note TEXT
  22. );