I now have freeradius running and loading the mysql module, but it
doesn't actually write log entries to the database. I installed db_mysql.sql
into the mysql database. I can see radiusd log in to mysql, but it does not
make any log entries into the database. Users still authenticate just fine
and the logs go to /var/log/radacct/ipaddy/detail
and
/var/log/radius.log
Here is what I have in my logs referring to sql:
Info: rlm_sql: Driver rlm_sql_mysql loaded and linked
Info: rlm_sql: Attempting to connect to root@xxxxxxx:/dbname
Debug: rlm_sql: Connected new DB handle, #0
Debug: rlm_sql: Connected new DB handle, #1
Debug: rlm_sql: Connected new DB handle, #2
Debug: rlm_sql: Connected new DB handle, #3
Debug: rlm_sql: Connected new DB handle, #4
I might be missing something simple. Here is where radiusd -xx shows
where it is set to log:
Module: Instantiated files (files)
Module: Loaded detail
detail: detailfile = "/var/log/radacct/%{Client-IP-Address}/detail"
detail: detailperm = 384
detail: dirperm = 493
Module: Instantiated detail (detail)
It looks like I need to tell radiusd that it needs to use mysql for the
details logs, but how do I do that?
Can someone provide some insite for me? Does anyone have a radiusd.conf that
works with mysql, that I can use for reference?
Thanks,
Nick
--
Nick Davis
Associate Systems Administrator
[EMAIL PROTECTED]
Internet Exposure, Inc.
http://www.iexposure.com
(612)676-1946
Web Development-Web Marketing-ISP Services
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
