Hi,
I was trying to setup sqltrace to see what is being sent to mysql. When
running radiusd in debug mode, I get the following:
Module: Loaded SQL
sql: driver = "mysql"
sql: server = "sql1.int.pa.net"
sql: port = ""
sql: login = ""
sql: password = ""
sql: radius_db = "radius"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "login"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
Bad value "0" for boolean variable sqltrace
radiusd.conf[850]: xx_sql1: Module instantiation failed.
radiusd.conf entries are:
modules {
...
$INCLUDE ${confdir}/sql.conf
sql sql1 {
server="sql1.int.pa.net"
authcheck_table="login"
}
sql sql2 {
server="sql2.int.pa.net"
authcheck_table="login"
}
...
}
...
authenticate {
...
authtype SQL {
redundant {
sql1
sql2
}
}
...
}
sql.conf settings are (all others are defaults):
sql {
...
sqltrace = on
sqltracefile = ${logdir}/sqltrace.sql
...
}
I'm not a C god (yet), but looking through the source I see that the default
for sqltrace is 0, not no. I'm running RH7.3 with mysql libraries installed.
Does anyone have a suggestion I can try that will resolve this problem?
Also, looking at other rlm files I saw that several PW_TYPE_BOOLEAN vars have
a default of yes/no while others have a default of 0/1. Looking at the
function which checks the config file(s), I see that the former should be
used. Perhaps the defaults or the cf_section_parse function should be
updated.
Thanks for your time,
Kevin Bonner
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
