7 * This program is free software; you can redistribute it and/or modify
8 * it under the terms of the GNU General Public License version 2 only, as published by
9 * the Free Software Foundation.
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 version 2
17 * along with this program; if not, write to the Free Software
18 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
20 * Copyright 2009 Gabriel Blanchard gabe@teksavvy.com
23 #include <freeradius-devel/ident.h>
26 #include <freeradius-devel/radiusd.h>
35 static int query_timeout_handler(void *dbproc);
36 static int err_handler(UNUSED DBPROCESS *dbproc, UNUSED int severity, UNUSED int dberr, UNUSED int oserr, char *dberrstr, char *oserrstr);
38 // As defined in tds.h
39 #define TDS_INT_CONTINUE 1
40 #define TDS_INT_CANCEL 2
41 #define TDS_INT_TIMEOUT 3
43 typedef struct rlm_sql_freetds_sock {
45 } rlm_sql_freetds_sock;
48 * FreeTDS calls this handler when dbsqlexec() or dbsqlok() blocks every seconds
49 * This ensures that FreeTDS doesn't stay stuck on the same query for ever.
51 static int query_timeout_handler(void *dbproc) {
52 return TDS_INT_CONTINUE;
55 static int err_handler(UNUSED DBPROCESS *dbproc, UNUSED int severity, UNUSED int dberr, UNUSED int oserr, char *dberrstr, char *oserrstr)
57 radlog(L_ERR, "rlm_sql_freetds: FreeTDS error: %s\n", dberrstr);
58 radlog(L_ERR, "rlm_sql_freetds: OS error: %s\n", oserrstr);
61 /*************************************************************************
63 * Function: sql_create_socket
65 * Purpose: Establish connection to the db
67 *************************************************************************/
68 static int sql_init_socket(rlm_sql_handle_t *handle, rlm_sql_config_t *config)
71 rlm_sql_freetds_sock *freetds_sock;
74 handle->conn = (rlm_sql_freetds_sock *)rad_malloc(sizeof(struct rlm_sql_freetds_sock));
80 if (dbinit() == FAIL) {
81 radlog(L_ERR, "rlm_sql_freetds: Unable to init FreeTDS");
85 dbsetversion(DBVERSION_80);
86 dberrhandle(err_handler);
88 // Timeout so that FreeTDS doesn't wait for ever.
89 dbsetlogintime((unsigned long)config->query_timeout);
90 dbsettime((unsigned long)config->query_timeout);
92 freetds_sock = handle->conn;
93 memset(freetds_sock, 0, sizeof(*freetds_sock));
95 DEBUG("rlm_sql_freetds (%s): Starting connect to FreeTDS/MSSQL server", config->xlat_name);
97 if (!(login = dblogin())) {
98 radlog(L_ERR, "rlm_sql_freetds (%s): Unable to allocate login record", config->xlat_name);
102 DBSETLUSER(login, config->sql_login);
103 DBSETLPWD(login, config->sql_password);
105 if ((freetds_sock->dbproc = dbopen(login, config->sql_server)) == FAIL) {
106 radlog(L_ERR, "rlm_sql_freetds (%s): Unable to connect to FreeTDS/MSSQL server %s@%s",
107 config->xlat_name, config->sql_login, config->sql_server);
114 if ((dbuse(freetds_sock->dbproc, config->sql_db)) == FAIL) {
115 radlog(L_ERR, "rlm_sql_freetds (%s): Unable to select database on FreeTDS/MSSQL server %s@%s:%s",
116 config->xlat_name, config->sql_login, config->sql_server, config->sql_db);
120 /* I know this may look strange, but it sets a pointer to
121 the freetds_sock struct so that it can be used within the
122 query_timeout_handler function to be able to timeout properly */
123 dbsetinterrupt(freetds_sock->dbproc, query_timeout_handler, query_timeout_handler);
124 dbsetuserdata(freetds_sock->dbproc, (BYTE *)freetds_sock);
130 /*************************************************************************
132 * Function: sql_destroy_socket
134 * Purpose: Free socket and any private connection data
136 *************************************************************************/
137 static int sql_destroy_socket(rlm_sql_handle_t *handle, UNUSED rlm_sql_config_t *config)
146 /*************************************************************************
148 * Function: sql_query
150 * Purpose: Issue a query to the database
152 *************************************************************************/
153 static int sql_query(rlm_sql_handle_t *handle, rlm_sql_config_t *config, char *querystr)
155 rlm_sql_freetds_sock *freetds_sock = handle->conn;
157 if (freetds_sock->dbproc == NULL || DBDEAD(freetds_sock->dbproc)) {
158 radlog(L_ERR, "rlm_sql_freetds (%s): Socket not connected", config->xlat_name);
162 if ((dbcmd(freetds_sock->dbproc, querystr)) == FAIL) {
163 radlog(L_ERR, "rlm_sql_freetds (%s): Unable to allocate SQL query", config->xlat_name);
167 if ((dbsqlexec(freetds_sock->dbproc)) == FAIL) {
168 radlog(L_ERR, "rlm_sql_freetds (%s): SQL query failed", config->xlat_name);
176 /*************************************************************************
178 * Function: sql_select_query
180 * Purpose: Issue a select query to the database
182 *************************************************************************/
183 static int sql_select_query(rlm_sql_handle_t *handle, rlm_sql_config_t *config, char *querystr)
185 radlog(L_ERR, "rlm_sql_freetds sql_select_query(): unsupported");
190 /*************************************************************************
192 * Function: sql_store_result
194 * Purpose: database specific store_result function. Returns a result
197 *************************************************************************/
198 static int sql_store_result(UNUSED rlm_sql_handle_t *handle, UNUSED rlm_sql_config_t *config)
200 radlog(L_ERR, "rlm_sql_freetds sql_store_result(): unsupported");
205 /*************************************************************************
207 * Function: sql_num_fields
209 * Purpose: database specific num_fields function. Returns number
210 * of columns from query
212 *************************************************************************/
213 static int sql_num_fields(rlm_sql_handle_t *handle, UNUSED rlm_sql_config_t *config)
215 rlm_sql_freetds_sock *freetds_sock = handle->conn;
217 return dbnumcols(freetds_sock->dbproc);
221 /*************************************************************************
223 * Function: sql_num_rows
225 * Purpose: database specific num_rows. Returns number of rows in
228 *************************************************************************/
229 static int sql_num_rows(UNUSED rlm_sql_handle_t *handle, UNUSED rlm_sql_config_t *config)
235 /*************************************************************************
237 * Function: sql_fetch_row
239 * Purpose: database specific fetch_row. Returns a rlm_sql_row_t struct
240 * with all the data for the query in 'handle->row'. Returns
241 * 0 on success, -1 on failure, SQL_DOWN if database is down.
243 *************************************************************************/
244 static int sql_fetch_row(UNUSED rlm_sql_handle_t *handle, UNUSED rlm_sql_config_t *config)
250 /*************************************************************************
252 * Function: sql_free_result
254 * Purpose: database specific free_result. Frees memory allocated
257 *************************************************************************/
258 static int sql_free_result(UNUSED rlm_sql_handle_t *handle, UNUSED rlm_sql_config_t *config)
265 /*************************************************************************
267 * Function: sql_error
269 * Purpose: database specific error. Returns error associated with
272 *************************************************************************/
273 static const char *sql_error(UNUSED rlm_sql_handle_t *handle, UNUSED rlm_sql_config_t *config)
279 /*************************************************************************
281 * Function: sql_close
283 * Purpose: database specific close. Closes an open database
286 *************************************************************************/
287 static int sql_close(rlm_sql_handle_t *handle, UNUSED rlm_sql_config_t *config)
289 rlm_sql_freetds_sock *freetds_sock = handle->conn;
291 if (freetds_sock && freetds_sock->dbproc){
292 dbclose(freetds_sock->dbproc);
293 freetds_sock->dbproc = NULL;
300 /*************************************************************************
302 * Function: sql_finish_query
304 * Purpose: End the query, such as freeing memory
306 *************************************************************************/
307 static int sql_finish_query(UNUSED rlm_sql_handle_t *handle, UNUSED rlm_sql_config_t *config)
314 /*************************************************************************
316 * Function: sql_finish_select_query
318 * Purpose: End the select query, such as freeing memory or result
320 *************************************************************************/
321 static int sql_finish_select_query(rlm_sql_handle_t *handle, rlm_sql_config_t *config)
323 return sql_finish_query(handle, config);
327 /*************************************************************************
329 * Function: sql_affected_rows
331 * Purpose: End the select query, such as freeing memory or result
333 *************************************************************************/
334 static int sql_affected_rows(rlm_sql_handle_t *handle, UNUSED rlm_sql_config_t *config)
336 rlm_sql_freetds_sock *freetds_sock = handle->conn;
338 return dbcount(freetds_sock->dbproc);
342 /* Exported to rlm_sql */
343 rlm_sql_module_t rlm_sql_freetds = {
357 sql_finish_select_query,