3 /***************************************************************************
4 * conf.h rlm_sql - FreeRADIUS SQL Module *
6 * Configuration options for the SQL module *
8 * Mike Machado <mike@innercite.com> *
9 ***************************************************************************/
11 typedef struct sql_config {
19 char *sql_acct_table2;
20 char *sql_authcheck_table;
21 char *sql_authreply_table;
22 char *sql_groupcheck_table;
23 char *sql_groupreply_table;
24 char *sql_usergroup_table;
28 char *default_profile;
30 char *authorize_check_query;
31 char *authorize_reply_query;
32 char *authorize_group_check_query;
33 char *authorize_group_reply_query;
34 char *accounting_onoff_query;
35 char *accounting_update_query;
36 char *accounting_update_query_alt;
37 char *accounting_start_query;
38 char *accounting_start_query_alt;
39 char *accounting_stop_query;
40 char *accounting_stop_query_alt;
41 char *simul_count_query;
42 char *simul_verify_query;
43 char *groupmemb_query;
49 int deletestalesessions;
51 int connect_failure_retry_delay;
52 char *sql_postauth_table;
56 /* individual driver config */
62 #define CHECKRAD1 "/usr/sbin/checkrad"
63 #define CHECKRAD2 "/usr/local/sbin/checkrad"
65 /* Hack for funky ascend ports on MAX 4048 (and probably others)
66 The "NAS-Port-Id" value is "xyyzz" where "x" = 1 for digital, 2 for analog;
67 "yy" = line number (1 for first PRI/T1/E1, 2 for second, so on);
68 "zz" = channel number (on the PRI or Channelized T1/E1).
69 This should work with normal terminal servers, unless you have a TS with
70 more than 9999 ports ;^).
71 The "ASCEND_CHANNELS_PER_LINE" is the number of channels for each line into
72 the unit. For my US/PRI that's 23. A US/T1 would be 24, and a
73 European E1 would be 30 (I think ... never had one ;^).
74 This will NOT change the "NAS-Port-Id" reported in the detail log. This
75 is simply to fix the dynamic IP assignments a la Cistron.
76 WARNING: This hack works for me, but I only have one PRI!!! I've not
77 tested it on 2 or more (or with models other than the Max 4048)
79 -- dgreer@austintx.com
82 #define ASCEND_PORT_HACK
83 #define ASCEND_CHANNELS_PER_LINE 23
84 #define CISCO_ACCOUNTING_HACK
87 #define MAX_QUERY_LEN 4096
88 #define SQL_LOCK_LEN MAX_QUERY_LEN
89 #define SQLTRACEFILE RADLOG_DIR "/sqltrace.sql"
92 #define SQL_DOWN 1 /* for re-connect */
94 #define MAX_COMMUNITY_LEN 50
95 #define MAX_SQL_SOCKS 256
96 #define MAX_TABLE_LEN 20
97 #define MAX_AUTH_QUERY_LEN 256
98 #define AUTH_STRING_LEN 128
100 #endif /* SQL_CONF_H */