Mercurial > hg > freeDiameter
view extensions/app_diameap/diameap_mysql.c @ 1514:8912a0645645
Add 3GPP TS 29.234 V11.2.0 (2013-06)
Add AVPs:
- 3GPP-WLAN-APN-Id, OctetString, code 100, section 10.1.15
- Authentication-Method, Enumerated, code 300, section 10.1.5
- Authentication-Information-SIM, OctetString, code 301, section 10.1.6
- Authorization-Information-SIM, OctetString, code 302, section 10.1.7
- WLAN-User-Data, Grouped, code 303, section 10.1.8
- Charging-Data, Grouped, code 304, section 10.1.10
- WLAN-Access, Enumerated, code 305, section 10.1.11
- WLAN-3GPP-IP-Access, Enumerated, code 306, section 10.1.12
- APN-Authorized, Grouped, code 307, section 10.1.14
- APN-Barring-Type, Enumerated, code 309, section 10.1.16
- WLAN-Direct-IP-Access, Enumerated, code 310, section 10.1.17
- Session-Request-Type, Enumerated, code 311, section 10.1.23
- Routing-Policy, IPFilterRule, code 312, section 10.1.24
- Max-Requested-Bandwidth, OctetString, code 313, section 10.1.26
- Charging-Characteristics, Integer32, code 314, section 10.1.27
- Charging-Nodes, Grouped, code 315, section 10.1.28
- Primary-OCS-Charging-Function-Name, DiameterIdentity, code 316, section 10.1.29
- Secondary-OCS-Charging-Function-Name, DiameterIdentity, code 317, section 10.1.30
- Maximum-Number-Accesses, Unsigned32, code 319, section 10.1.38
APN-Id (308) OctetString only present from
3GPP TS 29.234 V6.2.0 (2005-03) to 3GPP TS 29.234 V6.4.0 (2005-09)
before being deprecated in 3GPP TS 29.234 V6.5.0 (2005-12).
(Not provided here.)
author | Luke Mewburn <luke@mewburn.net> |
---|---|
date | Wed, 08 Apr 2020 15:48:08 +1000 |
parents | 0117a7746b21 |
children |
line wrap: on
line source
/***************************************************************************************************** * Software License Agreement (BSD License) * Author : Souheil Ben Ayed <souheil@tera.ics.keio.ac.jp> * * Copyright (c) 2009-2010, Souheil Ben Ayed, Teraoka Laboratory of Keio University, and the WIDE Project * All rights reserved. * * Redistribution and use of this software in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * 1. Redistributions of source code must retain the above copyright * notice, this list of conditions and the following disclaimer. * * 2. Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * * 3. All advertising materials mentioning features or use of this software * must display the following acknowledgement: * This product includes software developed by Souheil Ben Ayed <souheil@tera.ics.keio.ac.jp>. * * 4. Neither the name of Souheil Ben Ayed, Teraoka Laboratory of Keio University or the WIDE Project nor the * names of its contributors may be used to endorse or promote products * derived from this software without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS ''AS IS'' AND ANY * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. *****************************************************************************************************/ #include "diameap_mysql.h" static pthread_mutex_t db_cs_mutex = PTHREAD_MUTEX_INITIALIZER; int diameap_get_eap_user(struct eap_user * user, char * username) { TRACE_ENTRY("%p %p",user,username); if (db_conn == NULL) { TRACE_DEBUG(INFO, "%sNot connected to the MySQL Database server.",DIAMEAP_EXTENSION); return EINVAL; } mysql_thread_init(); MYSQL_RES *res; MYSQL_ROW row; char * query; CHECK_MALLOC(query=(char *)malloc(sizeof(char)*255)); sprintf( query, "SELECT id,username,password,eapmethod, vendor FROM users WHERE users.username='%s' and users.active='Y' ", username); CHECK_POSIX(pthread_mutex_lock( &db_cs_mutex )); if (mysql_query(db_conn, query)) { CHECK_POSIX(pthread_mutex_unlock( &db_cs_mutex )); TRACE_DEBUG(INFO, "%sQuery execution fail. %s",DIAMEAP_EXTENSION, mysql_error(db_conn)); mysql_thread_end(); free(query); query = NULL; return EINVAL; } res = mysql_store_result(db_conn); CHECK_POSIX(pthread_mutex_unlock( &db_cs_mutex )); if ((row = mysql_fetch_row(res)) != NULL) { user->id = atoi(row[0]); CHECK_MALLOC(user->userid=malloc(strlen(row[1])+1)); memcpy(user->userid,row[1],strlen(row[1])+1); user->useridLength = strlen(row[1]); CHECK_MALLOC(user->password=malloc(strlen(row[2])+1)); memcpy(user->password, row[2],strlen(row[2])+1); user->passwordLength = strlen(row[2]); user->proposed_eap_method = atoi(row[3]); user->proposed_eap_method_vendor = atoi(row[4]); mysql_free_result(res); mysql_thread_end(); free(query); query = NULL; return 0; } TRACE_DEBUG(INFO, "%sUser unavailable.",DIAMEAP_EXTENSION); mysql_free_result(res); mysql_thread_end(); free(query); query = NULL; return EINVAL; } int diameap_authentication_get_attribs(struct eap_user *user, struct fd_list * attribute_list) { TRACE_ENTRY("%p %p",user,attribute_list); if (db_conn == NULL) { TRACE_DEBUG(INFO, "%sNot connected to the MySQL Database server.",DIAMEAP_EXTENSION); return EINVAL; } mysql_thread_init(); MYSQL_RES *res; MYSQL_ROW row; char * query; CHECK_MALLOC(query=malloc(sizeof(char)*255)); sprintf( query, "SELECT `authe`.`attribute` ,`authe`.`value` FROM `authe` WHERE `authe`.`grp` IN ( SELECT `user_grp`.`grp` FROM `user_grp` WHERE `user_grp`.`user` = %d ) ", user->id); CHECK_POSIX(pthread_mutex_lock( &db_cs_mutex )); if (mysql_query(db_conn, query)) { CHECK_POSIX(pthread_mutex_unlock( &db_cs_mutex )); TRACE_DEBUG(INFO, "%sQuery execution fail. %s",DIAMEAP_EXTENSION, mysql_error(db_conn)); mysql_thread_end(); free(query); query = NULL; return EINVAL; } res = mysql_store_result(db_conn); CHECK_POSIX(pthread_mutex_unlock( &db_cs_mutex )); while ((row = mysql_fetch_row(res))) { struct auth_attribute * attribute; CHECK_MALLOC(attribute = malloc(sizeof(struct auth_attribute))); memset(attribute, 0, sizeof(struct auth_attribute)); fd_list_init(&attribute->chain, NULL); attribute->attrib = strdup(row[0]); attribute->op = NULL; attribute->value = strdup(row[1]); fd_list_insert_before(attribute_list, &attribute->chain); } mysql_free_result(res); mysql_thread_end(); free(query); query = NULL; return 0; } int diameap_authorization_get_attribs(struct eap_user *user, struct fd_list * attribute_list) { TRACE_ENTRY("%p %p",user,attribute_list); if (db_conn == NULL) { TRACE_DEBUG(INFO, "%sNot connected to the MySQL Database server.",DIAMEAP_EXTENSION); return EINVAL; } mysql_thread_init(); MYSQL_RES *res; MYSQL_ROW row; char * query; CHECK_MALLOC(query=malloc(sizeof(char)*255)); sprintf( query, "SELECT `authz`.`attribute` , `authz`.`op` , `authz`.`value` FROM `authz` WHERE `authz`.`grp` IN ( SELECT `user_grp`.`grp` FROM `user_grp` WHERE `user_grp`.`user` = %d ) ", user->id); CHECK_POSIX(pthread_mutex_lock( &db_cs_mutex )); if (mysql_query(db_conn, query)) { CHECK_POSIX(pthread_mutex_unlock( &db_cs_mutex )); TRACE_DEBUG(INFO, "%sQuery execution fail. %s",DIAMEAP_EXTENSION, mysql_error(db_conn)); mysql_thread_end(); free(query); query = NULL; return EINVAL; } res = mysql_store_result(db_conn); CHECK_POSIX(pthread_mutex_unlock( &db_cs_mutex )); while ((row = mysql_fetch_row(res))) { struct auth_attribute * attribute; CHECK_MALLOC(attribute = malloc(sizeof(struct auth_attribute))); memset(attribute, 0, sizeof(struct auth_attribute)); fd_list_init(&attribute->chain, NULL); attribute->attrib = strdup(row[0]); attribute->op = strdup(row[1]); attribute->value = strdup(row[2]); fd_list_insert_before(attribute_list, &attribute->chain); } mysql_free_result(res); mysql_thread_end(); free(query); query = NULL; return 0; } void diameap_mysql_disconnect() { mysql_close(db_conn); }