6 # The rlm_sql_log module appends the SQL queries in a log
7 # file which is read later by the radsqlrelay program.
9 # This module only performs the dynamic expansion of the
10 # variables found in the SQL statements. No operation is
11 # executed on the database server. (this could be done
12 # later by an external program) That means the module is
13 # useful only with non-"SELECT" statements.
15 # See rlm_sql_log(5) manpage.
17 # This same functionality could also be implemented by logging
18 # to a "detail" file, reading that, and then writing to SQL.
19 # See raddb/sites-available/buffered-sql for an example.
22 path = "${radacctdir}/sql-relay"
23 acct_table = "radacct"
24 postauth_table = "radpostauth"
25 sql_user_name = "%{%{User-Name}:-DEFAULT}"
28 # Setting this to "yes" will allow UTF-8 characters to be
29 # written to the log file. Otherwise, they are escaped
30 # as being potentially invalid.
34 Start = "INSERT INTO ${acct_table} (AcctSessionId, UserName, \
35 NASIPAddress, FramedIPAddress, AcctStartTime, AcctStopTime, \
36 AcctSessionTime, AcctTerminateCause) VALUES \
37 ('%{Acct-Session-Id}', '%{User-Name}', '%{NAS-IP-Address}', \
38 '%{Framed-IP-Address}', '%S', '0', '0', '');"
39 Stop = "INSERT INTO ${acct_table} (AcctSessionId, UserName, \
40 NASIPAddress, FramedIPAddress, AcctStartTime, AcctStopTime, \
41 AcctSessionTime, AcctTerminateCause) VALUES \
42 ('%{Acct-Session-Id}', '%{User-Name}', '%{NAS-IP-Address}', \
43 '%{Framed-IP-Address}', '0', '%S', '%{Acct-Session-Time}', \
44 '%{Acct-Terminate-Cause}');"
45 Alive = "INSERT INTO ${acct_table} (AcctSessionId, UserName, \
46 NASIPAddress, FramedIPAddress, AcctStartTime, AcctStopTime, \
47 AcctSessionTime, AcctTerminateCause) VALUES \
48 ('%{Acct-Session-Id}', '%{User-Name}', '%{NAS-IP-Address}', \
49 '%{Framed-IP-Address}', '0', '0', '%{Acct-Session-Time}','');"
51 Post-Auth = "INSERT INTO ${postauth_table} \
52 (username, pass, reply, authdate) VALUES \
53 ('%{User-Name}', '%{User-Password:-Chap-Password}', \
54 '%{reply:Packet-Type}', '%S');"