I changed my config to the following and it still isn't working. I can
still authenticate and log to a flat file, but no accounting in mysql. When
I turn on trace, I see it inserting and deleting stuff from RADONLINE for
the session database, but I never see an attempt to use RADUSAGE. I changed
radacct.cgi to point to RADUSAGE and it connects ok, but it doesn't display
data (obviously, there isn't anything to display). Also, I can manually
connect to the mysql database and see the RADUSAGE table, but there's no
data in it. Any other ideas?? Thanks.
PA
------------------------
Foreground
LogStdout
Trace 4
AuthPort 1812
AcctPort 1813
LogDir /var/log/radiator
DbDir /etc/raddb
DictionaryFile %D/radiator.dictionary
<Client DEFAULT>
Secret xxxx
</Client>
<SessionDatabase SQL>
DBSource dbi:mysql:radmin
DBUsername radmin
DBAuth radmin
</SessionDatabase>
<Realm DEFAULT>
AuthByPolicy ContinueAlways
<AuthBy SQL>
DBSource dbi:mysql:radmin
DBUsername radmin
DBAuth radmin
AuthSelect
AccountingTable RADUSAGE
</AuthBy>
<AuthBy RADIUS>
Host y.y.y.y
Secret xxxx
</AuthBy>
AcctLogFileName %L/logfile.%Y.%m
</Realm>
----- Original Message -----
From: "Hugh Irvine" <[EMAIL PROTECTED]>
To: "Peder - Voralt" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 15, 2000 6:17 PM
Subject: Re: (RADIATOR) RADIUS Proxy and mySQL
>
> Hello Peder -
>
> On Wed, 16 Feb 2000, Peder - Voralt wrote:
> > I'm trying to setup RADIUS proxy and accounting to mySQL. I've got the
> > RADIUS proxy working, I've got user session logging to mySQL, but I
can't
> > figure out how to send the accounting info to mySQL. The example that
comes
> > with Radiator shows it for authentication and accounting via mySQL, but
not
> > splitting it up. I'm sure this is fairly common, but I just can't
figure it
> > out. My config is below. Any ideas? Thanks.
> >
>
> Sure - configuration follows:
>
> # configuration for voralt.net
>
> Foreground
> LogStdout
>
> AuthPort 1812
> AcctPort 1813
>
> LogDir /var/log/radiator
> DbDir /etc/raddb
>
> DictionaryFile %D/radiator.dictionary
>
> # configure clients
>
> <Client DEFAULT>
> Secret xxxxxx
> </Client>
>
> # configure session database
>
> <SessionDatabase SQL>
> DBSource dbi:mysql:radmin
> DBUsername radmin
> DBAuth radmin
> </SessionDatabase>
>
> # configure default realm
> # note AuthByPolicy and cascaded AuthBy's
> # AuthBy SQL has empty AuthSelect to disable authentication
>
> <Realm DEFAULT>
> AuthByPolicy ContinueAlways
> <AuthBy SQL>
> DBSource dbi:mysql:radmin
> DBUsername radmin
> DBAuth radmin
>
> AuthSelect
> AccountingTable RADUSAGE
> </AuthBy>
> <AuthBy RADIUS>
> Host x.x.x.x
> Secret xxxxxx
> </AuthBy>
> AcctLogFileName %L/logfile.%Y.%m
> </Realm>
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
