1*03f9172cSAndroid Build Coastguard WorkerINSERT INTO osu_config(realm,field,value) VALUES('example.com','fqdn','example.com'); 2*03f9172cSAndroid Build Coastguard WorkerINSERT INTO osu_config(realm,field,value) VALUES('example.com','friendly_name','Example Operator'); 3*03f9172cSAndroid Build Coastguard WorkerINSERT INTO osu_config(realm,field,value) VALUES('example.com','spp_http_auth_url','https://subscription-server.osu.example.com/hs20/spp.php?realm=example.com'); 4*03f9172cSAndroid Build Coastguard WorkerINSERT INTO osu_config(realm,field,value) VALUES('example.com','trust_root_cert_url','https://osu-server.osu.example.com/hs20/files/spp-root-ca.der'); 5*03f9172cSAndroid Build Coastguard WorkerINSERT INTO osu_config(realm,field,value) VALUES('example.com','trust_root_cert_fingerprint','5b393a9246865569485c2605c3304e48212b449367858299beba9384c4cf4647'); 6*03f9172cSAndroid Build Coastguard WorkerINSERT INTO osu_config(realm,field,value) VALUES('example.com','aaa_trust_root_cert_url','https://osu-server.osu.example.com/hs20/files/aaa-root-ca.der'); 7*03f9172cSAndroid Build Coastguard WorkerINSERT INTO osu_config(realm,field,value) VALUES('example.com','aaa_trust_root_cert_fingerprint','5b393a9246865569485c2605c3304e48212b449367858299beba9384c4cf4647'); 8*03f9172cSAndroid Build Coastguard WorkerINSERT INTO osu_config(realm,field,value) VALUES('example.com','free_account','free'); 9*03f9172cSAndroid Build Coastguard WorkerINSERT INTO osu_config(realm,field,value) VALUES('example.com','policy_url','https://subscription-server.osu.example.com/hs20/spp.php?realm=example.com'); 10*03f9172cSAndroid Build Coastguard WorkerINSERT INTO osu_config(realm,field,value) VALUES('example.com','remediation_url','https://subscription-server.osu.example.com/hs20/remediation.php?session_id='); 11*03f9172cSAndroid Build Coastguard WorkerINSERT INTO osu_config(realm,field,value) VALUES('example.com','free_remediation_url','https://subscription-server.osu.example.com/hs20/free-remediation.php?session_id='); 12*03f9172cSAndroid Build Coastguard WorkerINSERT INTO osu_config(realm,field,value) VALUES('example.com','signup_url','https://subscription-server.osu.example.com/hs20/signup.php?session_id='); 13*03f9172cSAndroid Build Coastguard Worker 14*03f9172cSAndroid Build Coastguard Worker 15*03f9172cSAndroid Build Coastguard WorkerINSERT INTO users(identity,realm,methods,password,phase2,shared) VALUES('free','example.com','TTLS-MSCHAPV2','free',1,1); 16*03f9172cSAndroid Build Coastguard Worker 17*03f9172cSAndroid Build Coastguard WorkerINSERT INTO wildcards(identity,methods) VALUES('','TTLS,TLS'); 18