2 * sql_unixodbc.c unixODBC rlm_sql driver
4 * This program is free software; you can redistribute it and/or modify
5 * it under the terms of the GNU General Public License as published by
6 * the Free Software Foundation; either version 2 of the License, or
7 * (at your option) any later version.
9 * This program is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU General Public License for more details.
14 * You should have received a copy of the GNU General Public License
15 * along with this program; if not, write to the Free Software
16 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA
18 * Copyright 2000 The FreeRADIUS server project
19 * Copyright 2000 Dmitri Ageev <d_ageev@ortcc.ru>
22 #include <freeradius-devel/autoconf.h>
26 #include <freeradius-devel/radiusd.h>
31 typedef struct rlm_sql_unixodbc_sock {
37 } rlm_sql_unixodbc_sock;
43 /* Forward declarations */
44 static char *sql_error(SQLSOCK *sqlsocket, SQL_CONFIG *config);
45 static int sql_state(long err_handle, SQLSOCK *sqlsocket, SQL_CONFIG *config);
46 static int sql_free_result(SQLSOCK *sqlsocket, SQL_CONFIG *config);
47 static int sql_affected_rows(SQLSOCK *sqlsocket, SQL_CONFIG *config);
48 static int sql_num_fields(SQLSOCK *sqlsocket, SQL_CONFIG *config);
51 /*************************************************************************
53 * Function: sql_init_socket
55 * Purpose: Establish connection to the db
57 *************************************************************************/
58 static int sql_init_socket(SQLSOCK *sqlsocket, SQL_CONFIG *config) {
59 rlm_sql_unixodbc_sock *unixodbc_sock;
62 if (!sqlsocket->conn) {
63 sqlsocket->conn = (rlm_sql_unixodbc_sock *)rad_malloc(sizeof(rlm_sql_unixodbc_sock));
64 if (!sqlsocket->conn) {
68 unixodbc_sock = sqlsocket->conn;
69 memset(unixodbc_sock, 0, sizeof(*unixodbc_sock));
71 /* 1. Allocate environment handle and register version */
72 err_handle = SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&unixodbc_sock->env_handle);
73 if (sql_state(err_handle, sqlsocket, config))
75 radlog(L_ERR, "rlm_sql_unixodbc: Can't allocate environment handle\n");
78 err_handle = SQLSetEnvAttr(unixodbc_sock->env_handle, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);
79 if (sql_state(err_handle, sqlsocket, config))
81 radlog(L_ERR, "rlm_sql_unixodbc: Can't register ODBC version\n");
82 SQLFreeHandle(SQL_HANDLE_ENV, unixodbc_sock->env_handle);
85 /* 2. Allocate connection handle */
86 err_handle = SQLAllocHandle(SQL_HANDLE_DBC, unixodbc_sock->env_handle, &unixodbc_sock->dbc_handle);
87 if (sql_state(err_handle, sqlsocket, config))
89 radlog(L_ERR, "rlm_sql_unixodbc: Can't allocate connection handle\n");
90 SQLFreeHandle(SQL_HANDLE_ENV, unixodbc_sock->env_handle);
94 /* 3. Connect to the datasource */
95 err_handle = SQLConnect(unixodbc_sock->dbc_handle,
96 (SQLCHAR*) config->sql_server, strlen(config->sql_server),
97 (SQLCHAR*) config->sql_login, strlen(config->sql_login),
98 (SQLCHAR*) config->sql_password, strlen(config->sql_password));
99 if (sql_state(err_handle, sqlsocket, config))
101 radlog(L_ERR, "rlm_sql_unixodbc: Connection failed\n");
102 SQLFreeHandle(SQL_HANDLE_DBC, unixodbc_sock->dbc_handle);
103 SQLFreeHandle(SQL_HANDLE_ENV, unixodbc_sock->env_handle);
107 /* 4. Allocate the statement */
108 err_handle = SQLAllocStmt(unixodbc_sock->dbc_handle, &unixodbc_sock->stmt_handle);
109 if (sql_state(err_handle, sqlsocket, config))
111 radlog(L_ERR, "rlm_sql_unixodbc: Can't allocate the statement\n");
119 /*************************************************************************
121 * Function: sql_destroy_socket
123 * Purpose: Free socket and private connection data
125 *************************************************************************/
126 static int sql_destroy_socket(SQLSOCK *sqlsocket, SQL_CONFIG *config)
128 free(sqlsocket->conn);
129 sqlsocket->conn = NULL;
134 /*************************************************************************
136 * Function: sql_query
138 * Purpose: Issue a non-SELECT query (ie: update/delete/insert) to
141 *************************************************************************/
142 static int sql_query(SQLSOCK *sqlsocket, SQL_CONFIG *config, char *querystr) {
143 rlm_sql_unixodbc_sock *unixodbc_sock = sqlsocket->conn;
147 if (config->sqltrace)
148 radlog(L_DBG, "query: %s", querystr);
150 /* Executing query */
151 err_handle = SQLExecDirect(unixodbc_sock->stmt_handle, (SQLCHAR *)querystr, strlen(querystr));
152 if ((state = sql_state(err_handle, sqlsocket, config))) {
153 if(state == SQL_DOWN)
154 radlog(L_INFO, "rlm_sql_unixodbc: rlm_sql will attempt to reconnect\n");
161 /*************************************************************************
163 * Function: sql_select_query
165 * Purpose: Issue a select query to the database
167 *************************************************************************/
168 static int sql_select_query(SQLSOCK *sqlsocket, SQL_CONFIG *config, char *querystr) {
169 rlm_sql_unixodbc_sock *unixodbc_sock = sqlsocket->conn;
170 SQLINTEGER column, len;
174 /* Only state = 0 means success */
175 if((state = sql_query(sqlsocket, config, querystr)))
178 numfields=sql_num_fields(sqlsocket, config);
182 /* Reserving memory for result */
183 unixodbc_sock->row = (char **) rad_malloc((numfields+1)*sizeof(char *));
184 unixodbc_sock->row[numfields] = NULL;
186 for(column=1; column<=numfields; column++) {
187 SQLColAttributes(unixodbc_sock->stmt_handle,((SQLUSMALLINT) column),SQL_COLUMN_LENGTH,NULL,0,NULL,&len);
188 unixodbc_sock->row[column-1] = (SQLCHAR*)rad_malloc((int)++len);
189 SQLBindCol(unixodbc_sock->stmt_handle, column, SQL_C_CHAR, (SQLCHAR *)unixodbc_sock->row[column-1], len, NULL);
195 /*************************************************************************
197 * Function: sql_store_result
199 * Purpose: database specific store_result function. Returns a result
202 *************************************************************************/
203 static int sql_store_result(SQLSOCK *sqlsocket, SQL_CONFIG *config) {
209 /*************************************************************************
211 * Function: sql_num_fields
213 * Purpose: database specific num_fields function. Returns number
214 * of columns from query
216 *************************************************************************/
217 static int sql_num_fields(SQLSOCK *sqlsocket, SQL_CONFIG *config) {
218 rlm_sql_unixodbc_sock *unixodbc_sock = sqlsocket->conn;
222 err_handle = SQLNumResultCols(unixodbc_sock->stmt_handle,(SQLSMALLINT *)&num_fields);
223 if (sql_state(err_handle, sqlsocket, config))
230 /*************************************************************************
232 * Function: sql_num_rows
234 * Purpose: database specific num_rows. Returns number of rows in
237 *************************************************************************/
238 static int sql_num_rows(SQLSOCK *sqlsocket, SQL_CONFIG *config) {
239 return sql_affected_rows(sqlsocket, config);
243 /*************************************************************************
245 * Function: sql_fetch_row
247 * Purpose: database specific fetch_row. Returns a SQL_ROW struct
248 * with all the data for the query in 'sqlsocket->row'. Returns
249 * 0 on success, -1 on failure, SQL_DOWN if 'database is down'.
251 *************************************************************************/
252 static int sql_fetch_row(SQLSOCK *sqlsocket, SQL_CONFIG *config) {
253 rlm_sql_unixodbc_sock *unixodbc_sock = sqlsocket->conn;
257 sqlsocket->row = NULL;
259 err_handle = SQLFetch(unixodbc_sock->stmt_handle);
260 if(err_handle == SQL_NO_DATA_FOUND)
262 if ((state = sql_state(err_handle, sqlsocket, config))) {
263 if(state == SQL_DOWN)
264 radlog(L_INFO, "rlm_sql_unixodbc: rlm_sql will attempt to reconnect\n");
267 sqlsocket->row = unixodbc_sock->row;
272 /*************************************************************************
274 * Function: sql_finish_select_query
276 * Purpose: End the select query, such as freeing memory or result
278 *************************************************************************/
279 static int sql_finish_select_query(SQLSOCK * sqlsocket, SQL_CONFIG *config) {
280 rlm_sql_unixodbc_sock *unixodbc_sock = sqlsocket->conn;
282 sql_free_result(sqlsocket, config);
283 SQLFreeStmt(unixodbc_sock->stmt_handle, SQL_CLOSE);
287 /*************************************************************************
289 * Function: sql_finish_query
291 * Purpose: End the query, such as freeing memory
293 *************************************************************************/
294 static int sql_finish_query(SQLSOCK *sqlsocket, SQL_CONFIG *config) {
295 rlm_sql_unixodbc_sock *unixodbc_sock = sqlsocket->conn;
297 SQLFreeStmt(unixodbc_sock->stmt_handle, SQL_CLOSE);
301 /*************************************************************************
303 * Function: sql_free_result
305 * Purpose: database specific free_result. Frees memory allocated
308 *************************************************************************/
309 static int sql_free_result(SQLSOCK *sqlsocket, SQL_CONFIG *config) {
310 rlm_sql_unixodbc_sock *unixodbc_sock = sqlsocket->conn;
311 int column, numfileds=sql_num_fields(sqlsocket, config);
313 /* Freeing reserved memory */
314 if(unixodbc_sock->row != NULL) {
315 for(column=0; column<numfileds; column++) {
316 if(unixodbc_sock->row[column] != NULL) {
317 free(unixodbc_sock->row[column]);
318 unixodbc_sock->row[column] = NULL;
321 free(unixodbc_sock->row);
322 unixodbc_sock->row = NULL;
327 /*************************************************************************
329 * Function: sql_close
331 * Purpose: database specific close. Closes an open database
332 * connection and cleans up any open handles.
334 *************************************************************************/
335 static int sql_close(SQLSOCK *sqlsocket, SQL_CONFIG *config) {
336 rlm_sql_unixodbc_sock *unixodbc_sock = sqlsocket->conn;
338 SQLFreeStmt(unixodbc_sock->stmt_handle, SQL_DROP);
339 SQLDisconnect(unixodbc_sock->dbc_handle);
340 SQLFreeConnect(unixodbc_sock->dbc_handle);
341 SQLFreeEnv(unixodbc_sock->env_handle);
346 /*************************************************************************
348 * Function: sql_error
350 * Purpose: database specific error. Returns error associated with
353 *************************************************************************/
354 static char *sql_error(SQLSOCK *sqlsocket, SQL_CONFIG *config) {
357 SQLINTEGER errornum = 0;
358 SQLSMALLINT length = 255;
359 static char result[1024]; /* NOT thread-safe! */
361 rlm_sql_unixodbc_sock *unixodbc_sock = sqlsocket->conn;
363 error[0] = state[0] = '\0';
366 unixodbc_sock->env_handle,
367 unixodbc_sock->dbc_handle,
368 unixodbc_sock->stmt_handle,
375 sprintf(result, "%s %s", state, error);
376 result[sizeof(result) - 1] = '\0'; /* catch idiot thread issues */
380 /*************************************************************************
382 * Function: sql_state
384 * Purpose: Returns 0 for success, SQL_DOWN if the error was
385 * connection related or -1 for other errors
387 *************************************************************************/
388 static int sql_state(long err_handle, SQLSOCK *sqlsocket, SQL_CONFIG *config) {
391 SQLINTEGER errornum = 0;
392 SQLSMALLINT length = 255;
395 rlm_sql_unixodbc_sock *unixodbc_sock = sqlsocket->conn;
397 if(SQL_SUCCEEDED(err_handle))
398 return 0; /* on success, just return 0 */
400 error[0] = state[0] = '\0';
403 unixodbc_sock->env_handle,
404 unixodbc_sock->dbc_handle,
405 unixodbc_sock->stmt_handle,
412 if(state[0] == '0') {
414 case '1': /* SQLSTATE 01 class contains info and warning messages */
415 radlog(L_INFO, "rlm_sql_unixodbc: %s %s\n", state, error);
416 case '0': /* SQLSTATE 00 class means success */
419 case '8': /* SQLSTATE 08 class describes various connection errors */
420 radlog(L_ERR, "rlm_sql_unixodbc: SQL down %s %s\n", state, error);
423 default: /* any other SQLSTATE means error */
424 radlog(L_ERR, "rlm_sql_unixodbc: %s %s\n", state, error);
433 /*************************************************************************
435 * Function: sql_affected_rows
437 * Purpose: Return the number of rows affected by the query (update,
440 *************************************************************************/
441 static int sql_affected_rows(SQLSOCK *sqlsocket, SQL_CONFIG *config) {
442 rlm_sql_unixodbc_sock *unixodbc_sock = sqlsocket->conn;
446 err_handle = SQLRowCount(unixodbc_sock->stmt_handle, (SQLINTEGER *)&affected_rows);
447 if (sql_state(err_handle, sqlsocket, config))
450 return affected_rows;
454 /* Exported to rlm_sql */
455 rlm_sql_module_t rlm_sql_unixodbc = {
469 sql_finish_select_query,