You should have something like this in your radiusd.conf
$INCLUDE ${confdir}/sql.conf
Then you should have this in sql.conf (or the file pointed to by the
include, my example is with mysql, could be another engine)
sql {
# Database type
# Current supported are: rlm_sql_mysql, rlm_sql_postgresql,
# rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc, rlm_sql_freetds
driver = "rlm_sql_mysql"
# Connect info
server = "localhost"
login = "user"
password = "user"
# Database table configuration
radius_db = "radius"
# 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"
....
and then some accounting_*_query that inserts or updates the ${acct_table1}
or ${acct_table2}.
Then your "accounting {" section in radiusd.conf should have a line saying
"sql" or the sql instance name (if you are using more than the default
instance for sql module).
And then you must have the "radius" database and the "radacct" table.
If all this is ok, then I don't know for sure, you should check your
radius.log for errors in the sql module.
----- Original Message -----
From: "Ben Dowling" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org>
Sent: Wednesday, September 28, 2005 2:30 PM
Subject: Re: SQL Accouting
I previously mentioned, the accounting section contains just 'sql'. I
have no sql section in radiusd.conf though (perhaps this is my problem?)
and no sql_accouting definitions in my sql.conf, but the sql accouting
queries are defined there, and they are correct.
The sql connection is working, and post auth data gets logged fine, just
not the accouting stuff.
Cheers, Ben
On Wed, 2005-09-28 at 09:11 -0300, Paolo Rotela wrote:
Yep, but I need some more info. Your sql section in radiusd.conf and your
sql_accounting* definitions in sql.conf. Also the "accounting" section in
radiusd.conf, in wich it must be a "sql" instance.
Ing. Paolo Rotela
Jefe Técnico
Blue Telecom
Eng. Paolo Rotela
CTO
Blue Telecom
----- Original Message -----
From: "Ben Dowling" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list"
<freeradius-users@lists.freeradius.org>
Sent: Tuesday, September 27, 2005 6:00 PM
Subject: SQL Accouting
> Hi,
>
> I'm still having problems getting FreeRadius-1.0.4 to log accounting
> data to sql. I know it is receiving the data, as I can log it to file.
> In my accounting section I have 'sql', and the SQL queries are there in
> sql.conf. However, when looking at the sqltrace log the only queries
> are
> inserts to radpostauth. Can anyone help?
>
> Thanks in advance, Ben
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
