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"
<[email protected]>
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"
>> <[email protected]>
>> 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
