Hello Adrian -
The debug you include below only shows an access request, not an accounting
request.
If you are not receiving any accounting requests from your NAS, you will not
see anything in the debug.
You will need to check the configuration of your NAS equipment to verify if it
is sendin
Hi :
I have a problem with the SQL accounting. Radiator do not process the
accounting- request. Below are my radius.cfg and the trace 4. I have
checked the ports on my server and are ok. I'm using port 1812 for
Radius and 1813 for accounting.
# windows.cfg
#
# Example Radiator configuratio
Hello Fred -
I'm afraid I don't quite understand what you mean by this:
I wanted to have the AuthBy SQLAccounting within this AuthBy group
since that would disable the LDAP file logging.
Can you explain what you mean?
The usual way to do what you describe is something like this:
AuthBy
Hi,
I have a setup where we have an EAP-TTLS outter authentication loop
and an inner authentication that uses two LDAP servers for authentication.
I had hoped I could do something like
AuthByPolicy ContinueAlways
AuthBy SQLAccounting
AuthBy CheckLDAP1
AuthBy Ch
7;,'%{Acct-Session-Time}'
Ross Kusler
Senior Database Administrator
InReach Internet LLC
[EMAIL PROTECTED]
> - Original Message -
> From: "Robert Blayzor" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED
Hello Justin -
As has already been mentioned on the list (thanks Frank), there is a
mechanism in the Radius protocol for exactly this purpose.
The Class attribute can be returned to a NAS in an Access-Accept, and the NAS
will subsequently include the Class attribute in all accounting request
http://www.dataonair.com
-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 1:52 PM
To: [EMAIL PROTECTED]
Subject: (RADIATOR) SQL Accounting able to pick up a var from SQL
subscribers table?
Hi guys,
I have another thing I'm trying to
Hi guys,
I have another thing I'm trying to wrap my brain around here, that I can't seem to
figure out.
My client's reason for choosing Radiator is so that they can seamlessly integrate it
into their custom billing/accounting package (which is going great!)
However, the billing system needs t
Hello Robert -
I can't think of an easy way to do what you describe below, other than
writing a custom hook to add some pseudo-attributes to the current request
for the integer values you require, and then using them in the
AcctSQLStatement.
There are some example hooks in the distribution i
;%{Acct-Input-Octets}','%{Acct-Output-Octets}','%{Acc
t-Session-Time}'
A more advanced SQL statement?
--
Robert Blayzor, BOFH
INOC, LLC
[EMAIL PROTECTED]
> -Original Message-----
> From: Hugh Irvine [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 03, 2002 11:38 P
Hello Robert -
You can do this with AcctColumnDef's:
AcctColumnDef NASPORT,NAS-Port,integer
Have a look at section 6.28.13 in the Radiator 2.19 reference manual.
regards
Hugh
On Fri, 4 Jan 2002 13:43, Robert Blayzor wrote:
> > My first inclination would be to archive the accounting
> My first inclination would be to archive the accounting data
> on a periodic
> basis (every day, every week, every month, whatever). One
> easy way to do this
> is to set up a different table for each month (week, day,
> whatever) for
> example and then use the Radiator special characters
Hello Robert -
My first inclination would be to archive the accounting data on a periodic
basis (every day, every week, every month, whatever). One easy way to do this
is to set up a different table for each month (week, day, whatever) for
example and then use the Radiator special characters
We have a very high number of accounting records that get stored on our
SQL servers, our goal is to reduce space consumption a bit. Is there a
way to have Radiator store the actual value of the RADIUS accounting
attributes and not the dictionary definitions?
Ie:
EXEC sp_RadiusAcctInsert '0',
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 i
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/
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 t
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
> From: Gildas PERROT [mailto:[EMAIL PROTECTED]]
>
> - only Insert in RADONLINE for Alive packets and not Start
> packets (I am
> using Cisco AS and IP is not present in Start but Alive packets)
>
You can also configure the Cisco box to delay the accounting start until it
has finished the clien
Hello Gildas -
On Mon, 09 Oct 2000, Gildas PERROT wrote:
> Hi,
>
> I would like to modify SQL accounting in order to :
>
> - only Insert in RADONLINE for Alive packets and not Start packets (I am
> using Cisco AS and IP is not present in Start but Alive packets)
>
The session database code a
Hi,
I would like to modify SQL accounting in order to :
- only Insert in RADONLINE for Alive packets and not Start packets (I am
using Cisco AS and IP is not present in Start but Alive packets)
- only Insert in ACCOUNTING for Stop packets where FRAMEDIPADDRESS is not
null. Sometimes, due to a p
the way I would do it too. As ever, careful testing is
recommended before deploying in a live environment.
Cheers.
On Apr 2, 4:08pm, Robert Saunders wrote:
> Subject: Re: (RADIATOR) SQL accounting question
>
> [ Attachment (text/enriched): 4017 bytes
> Character set: us-ascii
{NAS-Port}', '%{Framed-Address}',\
'%{realm-id}', '%{realm-type}');
Thanks again.
Bob Saunders
At 07:50 PM 4/2/00 -0500, you wrote:
>Hello Robert,
>
>On Apr 1, 10:25pm, Robert Saunders wrote:
>> Subject: (RADIATOR) SQL accounting question
>>
The problem is, I tried using %R in my INSERT statement, and all I got was
a NULL value. Could you suggest the proper way to format the %R so that
the value is extracted during the INSERT.
Also, I can not figure out the correct way to use the %R in a PreAuthHook.
Can you t
I would like to save realm information into rows that I have defined in my
accounting table.
The two new rows are:
realm_id
realm_type
I have been able to get the INSERT to work with no problem, but have
struggled with parsing the User-Name information, in
--- Forwarded mail from [EMAIL PROTECTED] (Hugh Irvine)
Date: Tue, 20 Jul 1999 11:04:58 +1000
To: [EMAIL PROTECTED]
From: [EMAIL PROTECTED] (Hugh Irvine)
Subject: (RADIATOR) SQL accounting
>>Received: from yarrina.connect.com.au (yarrina.connect.com.au
>>[192.18
I have successfully created a database call ACCOUNTING on my SQL server with
all the tables I need ...
how can I make it authenticate via RODOPI as usual and also send just the
accounting records to another database (while still sending them to my
rodopi database also)
my config which works fine
27 matches
Mail list logo
