SQL Accouting

[Ben Dowling]

That is exactly the setup I have, but it doesn't seem to be working.
There are no errors reported in radius.log, and no accounting queries in
sqltrace.sql. Any ideas?

Cheers, Ben

On Wed, 2005-09-28 at 15:08 -0300, Paolo Rotela wrote:
> 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" <bendowling at lineone.net>
> To: "FreeRadius users mailing list" <freeradius-users at 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" <bendowling at lineone.net>
> >> To: "FreeRadius users mailing list" 
> >> <freeradius-users at 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