2 * sql_mysql.c SQL Module
6 * This program is free software; you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation; either version 2 of the License, or
9 * (at your option) any later version.
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
16 * You should have received a copy of the GNU General Public License
17 * along with this program; if not, write to the Free Software
18 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA
20 * Copyright 2000,2006 The FreeRADIUS server project
21 * Copyright 2000 Mike Machado <mike@innercite.com>
22 * Copyright 2000 Alan DeKok <aland@ox.org>
25 #include <freeradius-devel/ident.h>
28 #include <freeradius-devel/autoconf.h>
35 #include <freeradius-devel/radiusd.h>
39 #ifdef HAVE_MYSQL_MYSQL_H
40 #include <mysql/errmsg.h>
41 #include <mysql/mysql.h>
51 typedef struct rlm_sql_mysql_sock {
58 /*************************************************************************
60 * Function: sql_create_socket
62 * Purpose: Establish connection to the db
64 *************************************************************************/
65 static int sql_init_socket(SQLSOCK *sqlsocket, SQL_CONFIG *config)
67 rlm_sql_mysql_sock *mysql_sock;
69 if (!sqlsocket->conn) {
70 sqlsocket->conn = (rlm_sql_mysql_sock *)rad_malloc(sizeof(rlm_sql_mysql_sock));
71 if (!sqlsocket->conn) {
75 mysql_sock = sqlsocket->conn;
76 memset(mysql_sock, 0, sizeof(*mysql_sock));
78 radlog(L_INFO, "rlm_sql_mysql: Starting connect to MySQL server for #%d",
81 mysql_init(&(mysql_sock->conn));
82 mysql_options(&(mysql_sock->conn), MYSQL_READ_DEFAULT_GROUP, "freeradius");
83 if (!(mysql_sock->sock = mysql_real_connect(&(mysql_sock->conn),
88 atoi(config->sql_port),
90 CLIENT_FOUND_ROWS))) {
91 radlog(L_ERR, "rlm_sql_mysql: Couldn't connect socket to MySQL server %s@%s:%s", config->sql_login, config->sql_server, config->sql_db);
92 radlog(L_ERR, "rlm_sql_mysql: Mysql error '%s'", mysql_error(&mysql_sock->conn));
93 mysql_sock->sock = NULL;
102 /*************************************************************************
104 * Function: sql_destroy_socket
106 * Purpose: Free socket and any private connection data
108 *************************************************************************/
109 static int sql_destroy_socket(SQLSOCK *sqlsocket, UNUSED SQL_CONFIG *config)
111 free(sqlsocket->conn);
112 sqlsocket->conn = NULL;
118 /*************************************************************************
120 * Function: sql_check_error
122 * Purpose: check the error to see if the server is down
124 *************************************************************************/
125 static int sql_check_error(int error)
128 case CR_SERVER_GONE_ERROR:
131 radlog(L_DBG, "rlm_sql_mysql: MYSQL check_error: %d, returning SQL_DOWN", error);
137 case CR_OUT_OF_MEMORY:
138 case CR_COMMANDS_OUT_OF_SYNC:
139 case CR_UNKNOWN_ERROR:
141 radlog(L_DBG, "rlm_sql_mysql: MYSQL check_error: %d received", error);
148 /*************************************************************************
150 * Function: sql_query
152 * Purpose: Issue a query to the database
154 *************************************************************************/
155 static int sql_query(SQLSOCK * sqlsocket, SQL_CONFIG *config, char *querystr)
157 rlm_sql_mysql_sock *mysql_sock = sqlsocket->conn;
159 if (config->sqltrace)
160 radlog(L_DBG,"rlm_sql_mysql: query: %s", querystr);
161 if (mysql_sock->sock == NULL) {
162 radlog(L_ERR, "rlm_sql_mysql: Socket not connected");
166 mysql_query(mysql_sock->sock, querystr);
167 return sql_check_error(mysql_errno(mysql_sock->sock));
171 /*************************************************************************
173 * Function: sql_store_result
175 * Purpose: database specific store_result function. Returns a result
178 *************************************************************************/
179 static int sql_store_result(SQLSOCK * sqlsocket, UNUSED SQL_CONFIG *config)
181 rlm_sql_mysql_sock *mysql_sock = sqlsocket->conn;
183 if (mysql_sock->sock == NULL) {
184 radlog(L_ERR, "rlm_sql_mysql: Socket not connected");
187 if (!(mysql_sock->result = mysql_store_result(mysql_sock->sock))) {
188 radlog(L_ERR, "rlm_sql_mysql: MYSQL Error: Cannot get result");
189 radlog(L_ERR, "rlm_sql_mysql: MYSQL Error: %s",
190 mysql_error(mysql_sock->sock));
191 return sql_check_error(mysql_errno(mysql_sock->sock));
197 /*************************************************************************
199 * Function: sql_num_fields
201 * Purpose: database specific num_fields function. Returns number
202 * of columns from query
204 *************************************************************************/
205 static int sql_num_fields(SQLSOCK * sqlsocket, UNUSED SQL_CONFIG *config)
208 rlm_sql_mysql_sock *mysql_sock = sqlsocket->conn;
210 #if MYSQL_VERSION_ID >= 32224
211 if (!(num = mysql_field_count(mysql_sock->sock))) {
213 if (!(num = mysql_num_fields(mysql_sock->sock))) {
215 radlog(L_ERR, "rlm_sql_mysql: MYSQL Error: No Fields");
216 radlog(L_ERR, "rlm_sql_mysql: MYSQL error: %s",
217 mysql_error(mysql_sock->sock));
223 /*************************************************************************
225 * Function: sql_select_query
227 * Purpose: Issue a select query to the database
229 *************************************************************************/
230 static int sql_select_query(SQLSOCK *sqlsocket, SQL_CONFIG *config,
235 ret = sql_query(sqlsocket, config, querystr);
238 ret = sql_store_result(sqlsocket, config);
243 /* Why? Per http://www.mysql.com/doc/n/o/node_591.html,
244 * this cannot return an error. Perhaps just to complain if no
247 sql_num_fields(sqlsocket, config);
253 /*************************************************************************
255 * Function: sql_num_rows
257 * Purpose: database specific num_rows. Returns number of rows in
260 *************************************************************************/
261 static int sql_num_rows(SQLSOCK * sqlsocket, UNUSED SQL_CONFIG *config)
263 rlm_sql_mysql_sock *mysql_sock = sqlsocket->conn;
265 if (mysql_sock->result)
266 return mysql_num_rows(mysql_sock->result);
272 /*************************************************************************
274 * Function: sql_fetch_row
276 * Purpose: database specific fetch_row. Returns a SQL_ROW struct
277 * with all the data for the query in 'sqlsocket->row'. Returns
278 * 0 on success, -1 on failure, SQL_DOWN if database is down.
280 *************************************************************************/
281 static int sql_fetch_row(SQLSOCK * sqlsocket, UNUSED SQL_CONFIG *config)
283 rlm_sql_mysql_sock *mysql_sock = sqlsocket->conn;
286 * Check pointer before de-referencing it.
288 if (!mysql_sock->result) {
292 sqlsocket->row = mysql_fetch_row(mysql_sock->result);
294 if (sqlsocket->row == NULL) {
295 return sql_check_error(mysql_errno(mysql_sock->sock));
301 /*************************************************************************
303 * Function: sql_free_result
305 * Purpose: database specific free_result. Frees memory allocated
308 *************************************************************************/
309 static int sql_free_result(SQLSOCK * sqlsocket, UNUSED SQL_CONFIG *config)
311 rlm_sql_mysql_sock *mysql_sock = sqlsocket->conn;
313 if (mysql_sock->result) {
314 mysql_free_result(mysql_sock->result);
315 mysql_sock->result = NULL;
323 /*************************************************************************
325 * Function: sql_error
327 * Purpose: database specific error. Returns error associated with
330 *************************************************************************/
331 static char *sql_error(SQLSOCK * sqlsocket, UNUSED SQL_CONFIG *config)
333 rlm_sql_mysql_sock *mysql_sock = sqlsocket->conn;
335 if (mysql_sock == NULL || mysql_sock->sock == NULL) {
336 return "rlm_sql_mysql: no connection to db";
338 return mysql_error(mysql_sock->sock);
342 /*************************************************************************
344 * Function: sql_close
346 * Purpose: database specific close. Closes an open database
349 *************************************************************************/
350 static int sql_close(SQLSOCK * sqlsocket, UNUSED SQL_CONFIG *config)
352 rlm_sql_mysql_sock *mysql_sock = sqlsocket->conn;
354 if (mysql_sock && mysql_sock->sock){
355 mysql_close(mysql_sock->sock);
356 mysql_sock->sock = NULL;
363 /*************************************************************************
365 * Function: sql_finish_query
367 * Purpose: End the query, such as freeing memory
369 *************************************************************************/
370 static int sql_finish_query(UNUSED SQLSOCK * sqlsocket, UNUSED SQL_CONFIG *config)
377 /*************************************************************************
379 * Function: sql_finish_select_query
381 * Purpose: End the select query, such as freeing memory or result
383 *************************************************************************/
384 static int sql_finish_select_query(SQLSOCK * sqlsocket, SQL_CONFIG *config)
386 sql_free_result(sqlsocket, config);
392 /*************************************************************************
394 * Function: sql_affected_rows
396 * Purpose: End the select query, such as freeing memory or result
398 *************************************************************************/
399 static int sql_affected_rows(SQLSOCK * sqlsocket, UNUSED SQL_CONFIG *config)
401 rlm_sql_mysql_sock *mysql_sock = sqlsocket->conn;
403 return mysql_affected_rows(mysql_sock->sock);
407 /* Exported to rlm_sql */
408 rlm_sql_module_t rlm_sql_mysql = {
422 sql_finish_select_query,