Lines Matching full:user
47 static char * db_get_session_val(struct hs20_svc *ctx, const char *user,
52 static xml_node_t * build_policy(struct hs20_svc *ctx, const char *user,
57 const char *user, const char *realm, in db_add_session() argument
65 sql = sqlite3_mprintf("INSERT INTO sessions(timestamp,id,user,realm," in db_add_session()
70 sessionid, user ? user : "", realm ? realm : "", in db_add_session()
86 static void db_update_session_password(struct hs20_svc *ctx, const char *user, in db_update_session_password() argument
93 "user=%Q AND realm=%Q", in db_update_session_password()
94 pw, sessionid, user, realm); in db_update_session_password()
107 const char *user, in db_update_session_machine_managed() argument
114 …sql = sqlite3_mprintf("UPDATE sessions SET machine_managed=%Q WHERE id=%Q AND user=%Q AND realm=%Q… in db_update_session_machine_managed()
115 pw_mm ? "1" : "0", sessionid, user, realm); in db_update_session_machine_managed()
128 static void db_add_session_pps(struct hs20_svc *ctx, const char *user, in db_add_session_pps() argument
139 "user=%Q AND realm=%Q", in db_add_session_pps()
140 str, sessionid, user, realm); in db_add_session_pps()
201 const char *user, const char *realm, in db_remove_session() argument
206 if (user == NULL || realm == NULL) { in db_remove_session()
211 "user=%Q AND realm=%Q AND id=%Q", in db_remove_session()
212 user, realm, sessionid); in db_remove_session()
226 const char *user, const char *realm, in hs20_eventlog() argument
235 if (user == NULL) { in hs20_eventlog()
237 "user"); in hs20_eventlog()
238 user = user_buf; in hs20_eventlog()
245 "(user,realm,sessionid,timestamp,notes,dump,addr)" in hs20_eventlog()
249 user, realm, sessionid, notes, in hs20_eventlog()
264 const char *user, const char *realm, in hs20_eventlog_node() argument
274 hs20_eventlog(ctx, user, realm, sessionid, notes, str); in hs20_eventlog_node()
279 static void db_update_mo_str(struct hs20_svc *ctx, const char *user, in db_update_mo_str() argument
284 if (user == NULL || realm == NULL || name == NULL) in db_update_mo_str()
288 name, str, user, realm); in db_update_mo_str()
293 debug_print(ctx, 1, "Failed to update user MO entry in sqlite " in db_update_mo_str()
300 static void db_update_mo(struct hs20_svc *ctx, const char *user, in db_update_mo() argument
309 db_update_mo_str(ctx, user, realm, name, str); in db_update_mo()
380 static char * db_get_val(struct hs20_svc *ctx, const char *user, in db_get_val() argument
389 user, realm); in db_get_val()
396 debug_print(ctx, 1, "Could not find user '%s'", user); in db_get_val()
402 debug_print(ctx, 1, "DB: user='%s' realm='%s' field='%s' dmacc=%d --> " in db_get_val()
403 "value='%s'", user, realm, field, dmacc, data.value); in db_get_val()
409 static int db_update_val(struct hs20_svc *ctx, const char *user, in db_update_val() argument
418 field, val, dmacc ? "osu_user" : "identity", user, in db_update_val()
425 "Failed to update user in sqlite database: %s", in db_update_val()
430 "DB: user='%s' realm='%s' field='%s' set to '%s'", in db_update_val()
431 user, realm, field, val); in db_update_val()
440 static char * db_get_session_val(struct hs20_svc *ctx, const char *user, in db_get_session_val() argument
447 if (user == NULL || realm == NULL) { in db_get_session_val()
452 "user=%Q AND realm=%Q AND id=%Q", in db_get_session_val()
453 field, user, realm, session_id); in db_get_session_val()
474 static int update_password(struct hs20_svc *ctx, const char *user, in update_password() argument
483 user); in update_password()
488 debug_print(ctx, 1, "Failed to update database for user '%s'", in update_password()
489 user); in update_password()
514 const char *user, const char *pw) in build_username_password() argument
523 add_text_node(ctx, node, "Username", user); in build_username_password()
536 const char *user, const char *pw) in add_username_password() argument
540 node = build_username_password(ctx, cred, user, pw); in add_username_password()
568 const char *user, const char *realm, in build_credential_pw() argument
579 if (add_username_password(ctx, cred, user, pw) < 0) { in build_credential_pw()
590 const char *user, const char *realm, in build_credential() argument
596 return build_credential_pw(ctx, user, realm, new_pw); in build_credential()
601 const char *user, const char *realm, in build_credential_cert() argument
678 const char *user, const char *realm, in build_sub_rem_resp() argument
691 real_user = db_get_val(ctx, user, realm, "identity", dmacc); in build_sub_rem_resp()
693 debug_print(ctx, 1, "Could not find user identity for " in build_sub_rem_resp()
694 "dmacc user '%s'", user); in build_sub_rem_resp()
699 cert = db_get_val(ctx, user, realm, "cert", dmacc); in build_sub_rem_resp()
703 cred = build_credential_cert(ctx, real_user ? real_user : user, in build_sub_rem_resp()
706 cred = build_credential(ctx, real_user ? real_user : user, in build_sub_rem_resp()
733 hs20_eventlog_node(ctx, user, realm, session_id, in build_sub_rem_resp()
735 "user remediation", cred); in build_sub_rem_resp()
744 db_add_session(ctx, user, realm, session_id, new_pw, NULL, in build_sub_rem_resp()
753 const char *user, in machine_remediation() argument
757 return build_sub_rem_resp(ctx, user, realm, session_id, 1, dmacc); in machine_remediation()
762 const char *user, const char *realm, in policy_remediation() argument
770 hs20_eventlog(ctx, user, realm, session_id, in policy_remediation()
773 db_add_session(ctx, user, realm, session_id, NULL, NULL, in policy_remediation()
776 policy = build_policy(ctx, user, realm, dmacc); in policy_remediation()
799 hs20_eventlog_node(ctx, user, realm, session_id, in policy_remediation()
816 debug_print(ctx, 1, "Missing redirectURI attribute for user " in browser_remediation()
834 static xml_node_t * user_remediation(struct hs20_svc *ctx, const char *user, in user_remediation() argument
840 hs20_eventlog(ctx, user, realm, session_id, in user_remediation()
841 "requires user remediation", NULL); in user_remediation()
846 db_add_session(ctx, user, realm, session_id, NULL, redirect_uri, in user_remediation()
856 const char *user, const char *realm, in free_remediation() argument
862 hs20_eventlog(ctx, user, realm, session_id, in free_remediation()
868 db_add_session(ctx, user, realm, session_id, NULL, redirect_uri, in free_remediation()
878 const char *user, const char *realm, in no_sub_rem() argument
883 hs20_eventlog(ctx, user, realm, session_id, in no_sub_rem()
893 const char *user, in hs20_subscription_remediation() argument
903 identity = db_get_val(ctx, user, realm, "identity", dmacc); in hs20_subscription_remediation()
905 hs20_eventlog(ctx, user, realm, session_id, in hs20_subscription_remediation()
906 "user not found in database for remediation", in hs20_subscription_remediation()
916 if (free_account && strcmp(free_account, user) == 0) { in hs20_subscription_remediation()
918 return no_sub_rem(ctx, user, realm, session_id); in hs20_subscription_remediation()
922 type = db_get_val(ctx, user, realm, "remediation", dmacc); in hs20_subscription_remediation()
926 val = db_get_val(ctx, user, realm, "shared", dmacc); in hs20_subscription_remediation()
932 return no_sub_rem(ctx, user, realm, session_id); in hs20_subscription_remediation()
935 if (type && strcmp(type, "user") == 0) in hs20_subscription_remediation()
936 ret = user_remediation(ctx, user, realm, session_id, in hs20_subscription_remediation()
939 ret = free_remediation(ctx, user, realm, session_id, in hs20_subscription_remediation()
942 ret = policy_remediation(ctx, user, realm, session_id, dmacc); in hs20_subscription_remediation()
944 ret = machine_remediation(ctx, user, realm, session_id, dmacc); in hs20_subscription_remediation()
951 static xml_node_t * build_policy(struct hs20_svc *ctx, const char *user, in build_policy() argument
958 policy_id = db_get_val(ctx, user, realm, "policy", use_dmacc); in build_policy()
990 pw = db_get_val(ctx, user, realm, "osu_password", use_dmacc); in build_policy()
992 build_username_password(ctx, node, user, pw) == NULL) { in build_policy()
1007 const char *user, const char *realm, in hs20_policy_update() argument
1017 identity = db_get_val(ctx, user, realm, "identity", dmacc); in hs20_policy_update()
1019 hs20_eventlog(ctx, user, realm, session_id, in hs20_policy_update()
1020 "user not found in database for policy update", in hs20_policy_update()
1029 policy = build_policy(ctx, user, realm, dmacc); in hs20_policy_update()
1036 db_add_session(ctx, user, realm, session_id, NULL, NULL, POLICY_UPDATE); in hs20_policy_update()
1054 hs20_eventlog_node(ctx, user, realm, session_id, "policy update", in hs20_policy_update()
1178 const char *user, in hs20_user_input_remediation() argument
1182 return build_sub_rem_resp(ctx, user, realm, session_id, 0, dmacc); in hs20_user_input_remediation()
1214 const char *user, const char *realm, in build_pps() argument
1264 userpw = build_username_password(ctx, cred, user, pw); in build_pps()
1279 const char *user, in spp_exec_get_certificate() argument
1305 xml_node_create_text(ctx->xml, enroll, ns, "estUserID", user); in spp_exec_get_certificate()
1316 db_update_session_password(ctx, user, realm, session_id, password); in spp_exec_get_certificate()
1331 char *user, *realm, *pw, *type, *mm; in hs20_user_input_registration() local
1337 user = db_get_session_val(ctx, NULL, NULL, session_id, "user"); in hs20_user_input_registration()
1341 if (!user || !realm || !pw) { in hs20_user_input_registration()
1344 free(user); in hs20_user_input_registration()
1362 hs20_eventlog(ctx, user, realm, session_id, in hs20_user_input_registration()
1364 ret = spp_exec_get_certificate(ctx, session_id, user, realm); in hs20_user_input_registration()
1365 free(user); in hs20_user_input_registration()
1376 free(user); in hs20_user_input_registration()
1390 pps = build_pps(ctx, user, realm, pw, in hs20_user_input_registration()
1395 free(user); in hs20_user_input_registration()
1404 db_update_session_password(ctx, user, realm, session_id, pw); in hs20_user_input_registration()
1405 db_update_session_machine_managed(ctx, user, realm, session_id, in hs20_user_input_registration()
1408 db_add_session_pps(ctx, user, realm, session_id, pps); in hs20_user_input_registration()
1410 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_user_input_registration()
1412 free(user); in hs20_user_input_registration()
1443 const char *user, in hs20_user_input_free_remediation() argument
1486 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_user_input_free_remediation()
1495 const char *user, in hs20_user_input_complete() argument
1502 val = db_get_session_val(ctx, user, realm, session_id, "operation"); in hs20_user_input_complete()
1512 return hs20_user_input_remediation(ctx, user, realm, dmacc, in hs20_user_input_complete()
1517 return hs20_user_input_free_remediation(ctx, user, realm, in hs20_user_input_complete()
1525 debug_print(ctx, 1, "User session %s not in state for user input " in hs20_user_input_complete()
1532 const char *user, in hs20_cert_enroll_completed() argument
1539 val = db_get_session_val(ctx, user, realm, session_id, "operation"); in hs20_cert_enroll_completed()
1551 debug_print(ctx, 1, "User session %s not in state for certificate " in hs20_cert_enroll_completed()
1558 const char *user, in hs20_cert_enroll_failed() argument
1568 val = db_get_session_val(ctx, user, realm, session_id, "operation"); in hs20_cert_enroll_failed()
1578 debug_print(ctx, 1, "User session %s not in state for " in hs20_cert_enroll_failed()
1591 db_remove_session(ctx, user, realm, session_id); in hs20_cert_enroll_failed()
1599 const char *user, in hs20_spp_post_dev_data() argument
1621 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1633 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1648 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1668 hs20_eventlog(ctx, user, realm, session_id, str, NULL); in hs20_spp_post_dev_data()
1674 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1681 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1684 hs20_eventlog(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1693 if (user) in hs20_spp_post_dev_data()
1694 db_update_mo(ctx, user, realm, "devinfo", devinfo); in hs20_spp_post_dev_data()
1700 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1707 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1710 hs20_eventlog(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1719 if (user) in hs20_spp_post_dev_data()
1720 db_update_mo(ctx, user, realm, "devdetail", devdetail); in hs20_spp_post_dev_data()
1722 if (user) in hs20_spp_post_dev_data()
1728 if (user && mo) { in hs20_spp_post_dev_data()
1729 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1732 hs20_eventlog(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1741 db_update_mo(ctx, user, realm, "pps", mo); in hs20_spp_post_dev_data()
1742 db_update_val(ctx, user, realm, "fetch_pps", "0", dmacc); in hs20_spp_post_dev_data()
1747 if (user && !mo) { in hs20_spp_post_dev_data()
1751 fetch = db_get_val(ctx, user, realm, "fetch_pps", dmacc); in hs20_spp_post_dev_data()
1764 if (db_add_session(ctx, user, realm, session_id, NULL, in hs20_spp_post_dev_data()
1770 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1777 if (user && strcasecmp(req_reason, "MO upload") == 0) { in hs20_spp_post_dev_data()
1778 char *val = db_get_session_val(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1803 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1808 if (user && strcasecmp(req_reason, "Subscription remediation") == 0) { in hs20_spp_post_dev_data()
1809 ret = hs20_subscription_remediation(ctx, user, realm, in hs20_spp_post_dev_data()
1812 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1817 if (user && strcasecmp(req_reason, "Policy update") == 0) { in hs20_spp_post_dev_data()
1818 ret = hs20_policy_update(ctx, user, realm, session_id, dmacc); in hs20_spp_post_dev_data()
1819 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1825 if (strcasecmp(req_reason, "User input completed") == 0) { in hs20_spp_post_dev_data()
1828 ret = hs20_user_input_complete(ctx, user, realm, dmacc, in hs20_spp_post_dev_data()
1830 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1831 "user input completed response", ret); in hs20_spp_post_dev_data()
1836 ret = hs20_cert_enroll_completed(ctx, user, realm, dmacc, in hs20_spp_post_dev_data()
1838 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1844 ret = hs20_cert_enroll_failed(ctx, user, realm, dmacc, in hs20_spp_post_dev_data()
1846 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_post_dev_data()
1852 debug_print(ctx, 1, "Unsupported requestReason '%s' user '%s'", in hs20_spp_post_dev_data()
1853 req_reason, user); in hs20_spp_post_dev_data()
1893 char *user, *realm, *pw, *pw_mm, *pps, *str; in add_subscription() local
1902 user = db_get_session_val(ctx, NULL, NULL, session_id, "user"); in add_subscription()
1915 if (!user || !realm || !pw) { in add_subscription()
1922 free_acc = free_account && strcmp(free_account, user) == 0; in add_subscription()
1926 "New subscription: user='%s' realm='%s' free_acc=%d", in add_subscription()
1927 user, realm, free_acc); in add_subscription()
1930 sql = sqlite3_mprintf("UPDATE eventlog SET user=%Q, realm=%Q WHERE " in add_subscription()
1931 "sessionid=%Q AND (user='' OR user IS NULL)", in add_subscription()
1932 user, realm, session_id); in add_subscription()
1944 hs20_eventlog(ctx, user, realm, session_id, in add_subscription()
1954 user, realm, cert ? "TLS" : "TTLS-MSCHAPV2", in add_subscription()
1962 debug_print(ctx, 1, "Failed to add user in sqlite database: %s", in add_subscription()
1972 ret = update_password(ctx, user, realm, pw, 0); in add_subscription()
1976 user, realm); in add_subscription()
1985 db_update_mo_str(ctx, user, realm, "pps", pps); in add_subscription()
1989 db_update_mo_str(ctx, user, realm, "devinfo", str); in add_subscription()
1995 db_update_mo_str(ctx, user, realm, "devdetail", str); in add_subscription()
2000 hs20_eventlog(ctx, user, realm, session_id, in add_subscription()
2005 free(user); in add_subscription()
2018 const char *user, in hs20_spp_update_response() argument
2038 val = db_get_session_val(ctx, user, realm, session_id, "operation"); in hs20_spp_update_response()
2041 "No session active for user: %s sessionID: %s", in hs20_spp_update_response()
2042 user, session_id); in hs20_spp_update_response()
2053 new_pw = db_get_session_val(ctx, user, realm, in hs20_spp_update_response()
2060 hs20_eventlog_node(ctx, user, realm, in hs20_spp_update_response()
2064 db_remove_session(ctx, user, realm, session_id); in hs20_spp_update_response()
2071 new_pw = db_get_session_val(ctx, user, realm, in hs20_spp_update_response()
2075 db_remove_session(ctx, user, realm, in hs20_spp_update_response()
2080 debug_print(ctx, 1, "Update user '%s' password in DB", in hs20_spp_update_response()
2081 user); in hs20_spp_update_response()
2082 if (update_password(ctx, user, realm, new_pw, dmacc) < in hs20_spp_update_response()
2084 debug_print(ctx, 1, "Failed to update user " in hs20_spp_update_response()
2085 "'%s' password in DB", user); in hs20_spp_update_response()
2089 hs20_eventlog_node(ctx, user, realm, in hs20_spp_update_response()
2092 db_remove_session(ctx, user, realm, session_id); in hs20_spp_update_response()
2095 hs20_eventlog(ctx, user, realm, in hs20_spp_update_response()
2096 session_id, "Updated user password " in hs20_spp_update_response()
2106 hs20_eventlog_node(ctx, user, realm, in hs20_spp_update_response()
2109 db_remove_session(ctx, user, realm, session_id); in hs20_spp_update_response()
2115 val = db_get_val(ctx, user, realm, "remediation", in hs20_spp_update_response()
2118 db_update_val(ctx, user, realm, "remediation", in hs20_spp_update_response()
2125 hs20_eventlog_node(ctx, user, realm, session_id, in hs20_spp_update_response()
2127 db_remove_session(ctx, user, realm, session_id); in hs20_spp_update_response()
2133 hs20_eventlog_node(ctx, user, realm, session_id, "Error occurred", ret); in hs20_spp_update_response()
2134 db_remove_session(ctx, user, realm, session_id); in hs20_spp_update_response()