Re: (RADIATOR) SQL Accounting, without Auth
Hello Andy - Instead of using a clause, use this: # define Handler for accounting starts and stops only AcctLogFileName /path/to/my/file . AcctResult ACCEPT Note that the AuthBy INTERNAL is only available in Radiator 2.19, but you can get the same result by using an AuthBy FILE. regards Hugh On Sat, 8 Dec 2001 02:34, Andy Coates wrote: > Hugh Irvine wrote: > > Hello Andy - > > > > On Thu, 6 Dec 2001 22:23, Andy Coates wrote: > > > Hey, > > > > > > I'm taking over a system which currently runs Radiator, who's job > > > is to simply log accounting requests. > > [snip] > > > > My config as it stands is: > > > > > > > > > AcctLogFileName /path/to/my/file > > > > > > > > > DBSource > > > DBUsername > > > DBAuth > > > > > > AuthSelect > > > AccountingTable accounting > > > AcctColumnDef timestamp,Timestamp,integer > > > AcctColumnDef type,Acct-Status-Type > > > AcctColumnDef session,Acct-Session-Id > > > AcctColumnDef online,Acct-Session-Time,integer > > > AcctColumnDef nas,NAS-IP-Address > > > AcctColumnDef caller,Calling-Station-Id > > > AcctColumnDef calling,Called-Station-Id > > > > > > > > > > > > > > > Would this setup therefore log accounting requests to the SQL server, > > > even if its doing no authentication? Or am I going about this the > > > wrong way entirely? :) > > > > Your configuration is correct. > > > > As long as this server is only receiving accounting requests, those > > requests will be written to the accounting log file and to the SQL > > database. > > Hi again, > > Worked after I had fixed DBI issues, but then came my next problem... > > Unfortunately I get EVERYTHING logged, i.e. Tunnel-Start and Stops, > which the server also receives accounting for. However, if I set > AccountingStartsOnly it does do just Start, and not Tunnel-Start. > So if I could do AccountingStopsOnly, it would just do Stops. > > But, you can't do AccountingStartsOnly and AccountingStopsOnly, > so I'm stuck - any way around this on the Radiator side? > > Cheers, > Andy. -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) SQL Accounting, without Auth
Hugh Irvine wrote: > > Hello Andy - > > On Thu, 6 Dec 2001 22:23, Andy Coates wrote: > > Hey, > > > > I'm taking over a system which currently runs Radiator, who's job > > is to simply log accounting requests. [snip] > > My config as it stands is: > > > > > > AcctLogFileName /path/to/my/file > > > > > > DBSource > > DBUsername > > DBAuth > > > > AuthSelect > > AccountingTable accounting > > AcctColumnDef timestamp,Timestamp,integer > > AcctColumnDef type,Acct-Status-Type > > AcctColumnDef session,Acct-Session-Id > > AcctColumnDef online,Acct-Session-Time,integer > > AcctColumnDef nas,NAS-IP-Address > > AcctColumnDef caller,Calling-Station-Id > > AcctColumnDef calling,Called-Station-Id > > > > > > > > > > Would this setup therefore log accounting requests to the SQL server, > > even if its doing no authentication? Or am I going about this the > > wrong way entirely? :) > > > > Your configuration is correct. > > As long as this server is only receiving accounting requests, those requests > will be written to the accounting log file and to the SQL database. Hi again, Worked after I had fixed DBI issues, but then came my next problem... Unfortunately I get EVERYTHING logged, i.e. Tunnel-Start and Stops, which the server also receives accounting for. However, if I set AccountingStartsOnly it does do just Start, and not Tunnel-Start. So if I could do AccountingStopsOnly, it would just do Stops. But, you can't do AccountingStartsOnly and AccountingStopsOnly, so I'm stuck - any way around this on the Radiator side? Cheers, Andy. -- Andy Coates, IP Systems Engineer e: [EMAIL PROTECTED] Carrier1 UK Ltd, London Docklands w: http://andy.carrier1.net "I felt guilty once, t: +44 207 001 6879 but she woke up half way through." -- Quagmire === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) SQL Accounting, without Auth
Hello Andy - On Thu, 6 Dec 2001 22:23, Andy Coates wrote: > Hey, > > I'm taking over a system which currently runs Radiator, who's job > is to simply log accounting requests. > > Its a very simple config, which basically has: > > > AcctLogFileName /path/to/my/file > > > > What I'd like to do is log to an SQL server instead, which is fine > if I have an section with AccountTable defined, but > since I'm not Authenticatng it doesn't want to take notice of it. > > I read the mailing list archives and did come across a similar > thread which talked about multiple accounting types - but in the > scenario used various Auth types. > > It did mention however that if you did have an AuthBy but used > the option "AuthSelect" without any parameters it would ignore > authentication - but would it still use the AccountingTable? > > My config as it stands is: > > > AcctLogFileName /path/to/my/file > > > DBSource > DBUsername > DBAuth > > AuthSelect > AccountingTable accounting > AcctColumnDef timestamp,Timestamp,integer > AcctColumnDef type,Acct-Status-Type > AcctColumnDef session,Acct-Session-Id > AcctColumnDef online,Acct-Session-Time,integer > AcctColumnDef nas,NAS-IP-Address > AcctColumnDef caller,Calling-Station-Id > AcctColumnDef calling,Called-Station-Id > > > > > Would this setup therefore log accounting requests to the SQL server, > even if its doing no authentication? Or am I going about this the > wrong way entirely? :) > Your configuration is correct. As long as this server is only receiving accounting requests, those requests will be written to the accounting log file and to the SQL database. regards Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.