[root@ns1 bravo]# more sql.conf # Database type # Current supported are: rlm_sql_mysql, rlm_sql_postgresql, # rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc, rlm_sql_freetds database = "oracle" driver = "rlm_sql_oracle" # Connect info server = "10.221.1.173" login = "aaa_admin" password = "aaa_admin" # Database table configuration radius_db = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.221.1.173)(PORT=15 21)(CONNECT_DATA=(SID=ora11g)))" # If you want both stop and start records logged to the # same SQL table, leave this as is. If you want them in # different tables, put the start table in acct_table1 # and stop table in acct_table2 #acct_table1 = "radacct" #acct_table2 = "radacct" authcheck_table = "radcheck" authreply_table = "radreply" groupcheck_table = "radgroupcheck" groupreply_table = "radgroupreply" usergroup_table = "usergroup" # Remove stale session if checkrad does not see a double login deletestalesessions = yes # Print all SQL statements when in debug mode (-x) sqltrace = yes sqltracefile = ${logdir}/sqltrace.sql