subject:"\(RADIATOR\) Accounting log"

Re: (RADIATOR) Accounting Log file format

2002-11-06 Thread Hugh Irvine


Hello Shan -

You would use an AcctFileFormat specification in your Realm or Handler.

Section 6.16.5 in the Radiator 3.3.1 reference manual ("doc/ref.html").

Alternatively you could write a hook to do the same thing.

regards

Hugh



On Thursday, November 7, 2002, at 03:14 PM, Mike McCauley wrote:




--  Forwarded Message  --

Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from [S  
H A N
<[EMAIL PROTECTED]>]
Date: Wed, 6 Nov 2002 17:14:25 -0600
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]

From [EMAIL PROTECTED] Wed Nov  6 17:14:24 2002

Received: from smtp12.singnet.com.sg (smtp12.singnet.com.sg  
[165.21.6.32])
	by server1.open.com.au (8.11.0/8.11.0) with ESMTP id gA6NENC03921
	for <[EMAIL PROTECTED]>; Wed, 6 Nov 2002 17:14:24 -0600
Received: from singapura.singnet.com.sg (singapura.singnet.com.sg
 [165.21.10.10]) by smtp12.singnet.com.sg (8.12.6/8.12.6) with ESMTP id
 gA746kLE016649 for <[EMAIL PROTECTED]>; Thu, 7 Nov 2002 12:06:46  
+0800
Received: (from shanali@localhost) by singapura.singnet.com.sg  
(8.8.5/8.7.2)
 id MAA26714 for [EMAIL PROTECTED]; Thu, 7 Nov 2002 12:06:40 +0800  
(SST)
 Date: Thu, 7 Nov 2002 12:06:40 +0800
From: S H A N <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Accounting Log file format
Message-ID: <[EMAIL PROTECTED]>
Mail-Followup-To: [EMAIL PROTECTED]
Mime-Version: 1.0
Content-Type: multipart/mixed; boundary="EVF5PPMfhYS0aIcm"
Content-Disposition: inline
User-Agent: Mutt/1.4i


--EVF5PPMfhYS0aIcm
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

hi,

	attached is the derised format of accounting log file format.
	what would be the best way in radiator to accomplish the same?

thanks
--
S H A N

--EVF5PPMfhYS0aIcm
Content-Type: text/plain; charset=us-ascii
Content-Disposition: attachment; filename=detail
Content-Transfer-Encoding: quoted-printable

"Date","Time","User-Name","NAS-IP-Address","NAS-Port","Service- 
Type","Frame=
d-Protocol","Framed-IP-Address","Framed-IP-Netmask","Framed- 
Routing","Filte=
r-Id","Framed-MTU","Framed-Compression","Login-IP-Host","Login- 
Service","Lo=
gin-TCP-Port","Callback-Number","Callback-Id","Framed-Route","Framed- 
IPX-Ne=
twork","Class","Vendor-Specific","Session-Timeout","Idle- 
Timeout","Terminat=
ion-Action","Called-Station-Id","Calling-Station-Id","NAS- 
Identifier","Prox=
y-State","Login-LAT-Service","Login-LAT-Node","Login-LAT- 
Group","Framed-App=
leTalk-Link","Framed-AppleTalk-Network","Framed-AppleTalk-Zone","Acct- 
Statu=
s-Type","Acct-Delay-Time","Acct-Input-Octets","Acct-Output- 
Octets","Acct-Se=
ssion-Id","Acct-Authentic","Acct-Session-Time","Acct-Input- 
Packets","Acct-O=
utput-Packets","Acct-Terminate-Cause","Acct-Multi-Session-Id","Acct- 
Link-Co=
unt","NAS-Port-Type","Port-Limit","Login-LAT-Port","Ascend-User-Acct- 
Type",=
"Ascend-User-Acct-Host","Ascend-User-Acct-Port","Ascend-User-Acct- 
Key","Asc=
end-User-Acct-Base","Ascend-User-Acct-Time","Ascend-Event- 
Type","Ascend-Ses=
sion-Svr-Key","Ascend-Multilink-ID","Ascend-Num-In-Multilink","Ascend- 
First=
-Dest","Ascend-Pre-Input-Octets","Ascend-Pre-Output-Octets","Ascend- 
Pre-Inp=
ut-Packets","Ascend-Pre-Output-Packets","Ascend-Disconnect- 
Cause","Ascend-C=
onnect-Progress","Ascend-Data-Rate","Ascend-PreSession-Time","Ascend- 
Number=
-Sessions"
"2001-02- 
04","11:26:37","user3.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.13","ou=3DCompanyA",,,"Start",1459617792,,, 
"307=
404956","RADIUS",,,"Async",,
"2001-02- 
04","11:50:38","user2.domain","xxx.xxx.xxx.227",20103,,1,"xxx.xxx.=
xxx.14","ou=3DCompanyA",,,"Start",905969664,,," 
3074=
04957","RADIUS",,,"Async",,
"2001-02- 
04","12:50:37","user3.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.13","ou=3DCompanyA",,,"Stop",1207959552,343 
857,=
571682,"307404956","RADIUS",5056,6685,1596"Async","224. 
0.0.=
2",385,242,9,13,185,60,26400,25,
"2001-02- 
04","12:51:15","user2.domain","xxx.xxx.xxx.227",20103,,1,"xxx.xxx.=
xxx.14","ou=3DCompanyA",,,"Stop",33554432,78719 
5,75=
90014,"307404957","RADIUS",3690,16800,7522"Async","129. 
10.1=
.11",385,236,8,12,45,60,28800,35,
"2001-02- 
04","15:16:27","user1.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.15""Start",0,,,"307404959","RADIUS" 
,,,"=
Async",,
"2001-02- 
04","15:19:29","user1.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.15""Stop",0,3757,17881,"307404959","RAD 
IUS"=
,181,84,88"Async","203.120.90.40",427,248,11,12,45,60,2 
8800=
,30,
"2001-02- 
04","18:08:11","user2.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.16","ou=3DCompanyA",,,"Start",0,,,"30740496 
1","=
RADIUS",,,"Async",,
"2001-02- 
04","18:21:50","user2.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.16","

(RADIATOR) Accounting Log file format

2002-11-06 Thread Mike McCauley



--  Forwarded Message  --

Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from [S H A N 
<[EMAIL PROTECTED]>]
Date: Wed, 6 Nov 2002 17:14:25 -0600
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]

>From [EMAIL PROTECTED] Wed Nov  6 17:14:24 2002
Received: from smtp12.singnet.com.sg (smtp12.singnet.com.sg [165.21.6.32])
by server1.open.com.au (8.11.0/8.11.0) with ESMTP id gA6NENC03921
for <[EMAIL PROTECTED]>; Wed, 6 Nov 2002 17:14:24 -0600
Received: from singapura.singnet.com.sg (singapura.singnet.com.sg
 [165.21.10.10]) by smtp12.singnet.com.sg (8.12.6/8.12.6) with ESMTP id
 gA746kLE016649 for <[EMAIL PROTECTED]>; Thu, 7 Nov 2002 12:06:46 +0800
Received: (from shanali@localhost) by singapura.singnet.com.sg (8.8.5/8.7.2)
 id MAA26714 for [EMAIL PROTECTED]; Thu, 7 Nov 2002 12:06:40 +0800 (SST)
 Date: Thu, 7 Nov 2002 12:06:40 +0800
From: S H A N <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Accounting Log file format
Message-ID: <[EMAIL PROTECTED]>
Mail-Followup-To: [EMAIL PROTECTED]
Mime-Version: 1.0
Content-Type: multipart/mixed; boundary="EVF5PPMfhYS0aIcm"
Content-Disposition: inline
User-Agent: Mutt/1.4i


--EVF5PPMfhYS0aIcm
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

hi,

attached is the derised format of accounting log file format.
what would be the best way in radiator to accomplish the same?

thanks
--
S H A N

--EVF5PPMfhYS0aIcm
Content-Type: text/plain; charset=us-ascii
Content-Disposition: attachment; filename=detail
Content-Transfer-Encoding: quoted-printable

"Date","Time","User-Name","NAS-IP-Address","NAS-Port","Service-Type","Frame=
d-Protocol","Framed-IP-Address","Framed-IP-Netmask","Framed-Routing","Filte=
r-Id","Framed-MTU","Framed-Compression","Login-IP-Host","Login-Service","Lo=
gin-TCP-Port","Callback-Number","Callback-Id","Framed-Route","Framed-IPX-Ne=
twork","Class","Vendor-Specific","Session-Timeout","Idle-Timeout","Terminat=
ion-Action","Called-Station-Id","Calling-Station-Id","NAS-Identifier","Prox=
y-State","Login-LAT-Service","Login-LAT-Node","Login-LAT-Group","Framed-App=
leTalk-Link","Framed-AppleTalk-Network","Framed-AppleTalk-Zone","Acct-Statu=
s-Type","Acct-Delay-Time","Acct-Input-Octets","Acct-Output-Octets","Acct-Se=
ssion-Id","Acct-Authentic","Acct-Session-Time","Acct-Input-Packets","Acct-O=
utput-Packets","Acct-Terminate-Cause","Acct-Multi-Session-Id","Acct-Link-Co=
unt","NAS-Port-Type","Port-Limit","Login-LAT-Port","Ascend-User-Acct-Type",=
"Ascend-User-Acct-Host","Ascend-User-Acct-Port","Ascend-User-Acct-Key","Asc=
end-User-Acct-Base","Ascend-User-Acct-Time","Ascend-Event-Type","Ascend-Ses=
sion-Svr-Key","Ascend-Multilink-ID","Ascend-Num-In-Multilink","Ascend-First=
-Dest","Ascend-Pre-Input-Octets","Ascend-Pre-Output-Octets","Ascend-Pre-Inp=
ut-Packets","Ascend-Pre-Output-Packets","Ascend-Disconnect-Cause","Ascend-C=
onnect-Progress","Ascend-Data-Rate","Ascend-PreSession-Time","Ascend-Number=
-Sessions"
"2001-02-04","11:26:37","user3.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.13","ou=3DCompanyA",,,"Start",1459617792,,,"307=
404956","RADIUS",,,"Async",,
"2001-02-04","11:50:38","user2.domain","xxx.xxx.xxx.227",20103,,1,"xxx.xxx.=
xxx.14","ou=3DCompanyA",,,"Start",905969664,,,"3074=
04957","RADIUS",,,"Async",,
"2001-02-04","12:50:37","user3.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.13","ou=3DCompanyA",,,"Stop",1207959552,343857,=
571682,"307404956","RADIUS",5056,6685,1596"Async","224.0.0.=
2",385,242,9,13,185,60,26400,25,
"2001-02-04","12:51:15","user2.domain","xxx.xxx.xxx.227",20103,,1,"xxx.xxx.=
xxx.14","ou=3DCompanyA",,,"Stop",33554432,787195,75=
90014,"307404957","RADIUS",3690,16800,7522"Async","129.10.1=
.11",385,236,8,12,45,60,28800,35,
"2001-02-04","15:16:27","user1.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.15""Start",0,,,"307404959","RADIUS",,,"=
Async",,
"2001-02-04","15:19:29","user1.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.15""Stop",0,3757,17881,"307404959","RADIUS"=
,181,84,88"Async","203.120.90.40",427,248,11,12,45,60,28800=
,30,
"2001-02-04","18:08:11","user2.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.16","ou=3DCompanyA",,,"Start",0,,,"307404961","=
RADIUS",,,"Async",,
"2001-02-04","18:21:50","user2.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.16","ou=3DCompanyA",,,"Stop",0,1439934,261541,"=
307404961","RADIUS",819,27008,1946"Async","224.0.0.2",393,2=
42,11,13,45,60,26400,35,
"2001-02-04","20:13:33","user4.domain","xxx.xxx.xxx.227",20102,,1,"xxx.xxx.=
xxx.17""Start",385875968,,,"307404964","RADIUS"=
,,,"Async",,
"2001-02-

Re: (RADIATOR) accounting log format

2002-01-14 Thread Hugh Irvine



Salut Merad -

Ca va la vie?

On Tue, 15 Jan 2002 03:55, [EMAIL PROTECTED] wrote:
> Hi,
> I have a Radiator 2.18.4 installed on an OpenBSD.
> I have a realm authenticated by LDAP2.
> To make this, I had to use the RewriteUsername to strip the Realm before
> send it to the LDAP.
> My problem is that in the accounting logs the realm doesn't appear. I only
> get the login which is a problem for me because I  have to count the
> connection by realm.
>

There are a variety of ways to do this and the answer depends on what else 
you are doing in your configuration file. If you send me a copy of your 
configuration file (no secrets) and a description of your requirements I will 
be happy to take a look and make some suggestions.

A+

Hugues


-- 
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.

(RADIATOR) accounting log format

2002-01-14 Thread abdelkrim . merad


Hi,
I have a Radiator 2.18.4 installed on an OpenBSD.
I have a realm authenticated by LDAP2.
To make this, I had to use the RewriteUsername to strip the Realm before send 
it to the LDAP.
My problem is that in the accounting logs the realm doesn't appear. I only get 
the login which is a problem for me because I  have to count the connection by 
realm.


thanks
===
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) Accounting log problem

2000-11-13 Thread Hugh Irvine



Hello Toni -

I think your NAS is not correctly configured. The reason you don't see an
accounting log is because you are not receiving any accounting packets from the
NAS.

hth

Hugh

On Tue, 14 Nov 2000, Toni Riekkinen wrote:
> Hello,
> 
> I've problem with accounting logs, I can't get any accounting log at all,
> not in plain detail-file nor in our database. Authentication works just fine
> from users-file or database.
> 
> I've Solaris 8 (5.8) and Oracle8i Release 2 (8.1.6). I've installed timeout
> patch.
> 
> This is my current radius.cfg with database support:
> As I said, I've also tried for example with "AcctLogFileName
> /opt/radius/log/detail" and authentication from users file, no help.
> 
> Foreground
> LogStdout
> LogDir  /opt/radius/log
> DbDir   /opt/radius/raddb
> LogFile %L/radiusd.log
> Trace   4
> 
> 
> Secret  
> DupInterval 5
> NasType Cisco
> StatusServerShowClientDetails
> 
> 
> 
> MaxSessions 1
> 
> DBSourcedbi:Oracle:X
> DBUsername  X
> DBAuth  X
> AuthSelect  select accesspw from kpy_customers where
> accesslogin='%n'
> AccountingTable kpy_radaccount
> #   AcctColumnDef   aika,Timestamp,formatted-date,to_date\
> #   ('%e %m %Y %H:%M:%S', 'DD MM  HH24:MI:SS')
> AcctColumnDef   user_name,User-Name
> AcctColumnDef   nas_ip_address,NAS-IP-Address
> AcctColumnDef   nas_port,NAS-Port,integer
> AcctColumnDef   framed_ip_address,Framed-IP-Address
> AcctColumnDef   called_station_id,Called-Station-Id
> AcctColumnDef   nas_port_type,NAS-Port-Type
> AcctColumnDef   acct_input_octets,Acct-Input-Octets,integer
> AcctColumnDef
> acct_output_octets,Acct-Output-Octets,integer
> AcctColumnDef   acct_session_id,Acct-Session-Id
> AcctColumnDef   acct_session_time,Acct-Session-Time,integer
> AcctColumnDef   acct_terminate_cause,Acct-Terminate-Cause
> Timeout 15
> AddToReply  Service-Type=Framed-User,
> Framed-Protocol=PPP, Framed-Routing = None, Framed-MTU = 1500,
> Framed-Compression = Van-Jacobson-TCP-IP
> 
> 
> --
> 
> With tracelevel 4, I get this:
> 
> --
> Mon Nov 13 16:10:22 2000: DEBUG: Packet dump:
> *** Received from xxx.xxx.xxx.xxx port 1645 
> Code:   Access-Request
> Identifier: 43
> Authentic:  k<145><5><15><209>T$<250><150>'<223>zN<167><189><217>
> Attributes:
> NAS-IP-Address = xxx.xxx.xxx.xxx
> NAS-Port = 30001
> NAS-Port-Type = ISDN
> User-Name = "testi1"
> Called-Station-Id = "173636057"
> Calling-Station-Id = "0173643572"
> CHAP-Password = "X"
> Service-Type = Framed-User
> Framed-Protocol = PPP
> 
> Mon Nov 13 16:10:22 2000: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Mon Nov 13 16:10:22 2000: DEBUG:  Deleting session for testi1,
> xxx.xxx.xxx.xxx, 30001
> Mon Nov 13 16:10:22 2000: DEBUG: Handling with Radius::AuthSQL
> Mon Nov 13 16:10:26 2000: DEBUG: Handling with Radius::AuthSQL
> Mon Nov 13 16:10:26 2000: DEBUG: Query is: select accesspw from
> kpy_customers where accesslogin='testi1'
> 
> Mon Nov 13 16:10:26 2000: DEBUG: Radius::AuthSQL looks for match with testi1
> Mon Nov 13 16:10:26 2000: DEBUG: Radius::AuthSQL ACCEPT:
> Mon Nov 13 16:10:26 2000: DEBUG: Access accepted for testi1
> Mon Nov 13 16:10:26 2000: DEBUG: Packet dump:
> *** Sending to xxx.xxx.xxx.xxx port 1645 
> Code:   Access-Accept
> Identifier: 43
> Authentic:  k<145><5><15><209>T$<250><150>'<223>zN<167><189><217>
> Attributes:
> Service-Type = Framed-User
> Framed-Protocol = PPP
> Framed-Routing = None
> Framed-MTU = 1500
> Framed-Compression = Van-Jacobson-TCP-IP
> 
> --
> 
> What I have configured wrong? I believe I should see atleast some
> AcctColumnDef information at debug, but there is nothing?
> 
> Also I'd like to get BOTH accounting logging methods work at same time, to
> database and into detail-file. Though even another of those would be nice
> for start... :)
> 
> ++Toni
> 
> 
> 
> ===
> Archive at http://www.starport.net/~radiator/
> Announcements on [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.



===
Archive at http:/

(RADIATOR) Accounting log problem

2000-11-13 Thread Toni Riekkinen


Hello,

I've problem with accounting logs, I can't get any accounting log at all,
not in plain detail-file nor in our database. Authentication works just fine
from users-file or database.

I've Solaris 8 (5.8) and Oracle8i Release 2 (8.1.6). I've installed timeout
patch.

This is my current radius.cfg with database support:
As I said, I've also tried for example with "AcctLogFileName
/opt/radius/log/detail" and authentication from users file, no help.

Foreground
LogStdout
LogDir  /opt/radius/log
DbDir   /opt/radius/raddb
LogFile %L/radiusd.log
Trace   4


Secret  
DupInterval 5
NasType Cisco
StatusServerShowClientDetails



MaxSessions 1

DBSourcedbi:Oracle:X
DBUsername  X
DBAuth  X
AuthSelect  select accesspw from kpy_customers where
accesslogin='%n'
AccountingTable kpy_radaccount
#   AcctColumnDef   aika,Timestamp,formatted-date,to_date\
#   ('%e %m %Y %H:%M:%S', 'DD MM  HH24:MI:SS')
AcctColumnDef   user_name,User-Name
AcctColumnDef   nas_ip_address,NAS-IP-Address
AcctColumnDef   nas_port,NAS-Port,integer
AcctColumnDef   framed_ip_address,Framed-IP-Address
AcctColumnDef   called_station_id,Called-Station-Id
AcctColumnDef   nas_port_type,NAS-Port-Type
AcctColumnDef   acct_input_octets,Acct-Input-Octets,integer
AcctColumnDef
acct_output_octets,Acct-Output-Octets,integer
AcctColumnDef   acct_session_id,Acct-Session-Id
AcctColumnDef   acct_session_time,Acct-Session-Time,integer
AcctColumnDef   acct_terminate_cause,Acct-Terminate-Cause
Timeout 15
AddToReply  Service-Type=Framed-User,
Framed-Protocol=PPP, Framed-Routing = None, Framed-MTU = 1500,
Framed-Compression = Van-Jacobson-TCP-IP


--

With tracelevel 4, I get this:

--
Mon Nov 13 16:10:22 2000: DEBUG: Packet dump:
*** Received from xxx.xxx.xxx.xxx port 1645 
Code:   Access-Request
Identifier: 43
Authentic:  k<145><5><15><209>T$<250><150>'<223>zN<167><189><217>
Attributes:
NAS-IP-Address = xxx.xxx.xxx.xxx
NAS-Port = 30001
NAS-Port-Type = ISDN
User-Name = "testi1"
Called-Station-Id = "173636057"
Calling-Station-Id = "0173643572"
CHAP-Password = "X"
Service-Type = Framed-User
Framed-Protocol = PPP

Mon Nov 13 16:10:22 2000: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Nov 13 16:10:22 2000: DEBUG:  Deleting session for testi1,
xxx.xxx.xxx.xxx, 30001
Mon Nov 13 16:10:22 2000: DEBUG: Handling with Radius::AuthSQL
Mon Nov 13 16:10:26 2000: DEBUG: Handling with Radius::AuthSQL
Mon Nov 13 16:10:26 2000: DEBUG: Query is: select accesspw from
kpy_customers where accesslogin='testi1'

Mon Nov 13 16:10:26 2000: DEBUG: Radius::AuthSQL looks for match with testi1
Mon Nov 13 16:10:26 2000: DEBUG: Radius::AuthSQL ACCEPT:
Mon Nov 13 16:10:26 2000: DEBUG: Access accepted for testi1
Mon Nov 13 16:10:26 2000: DEBUG: Packet dump:
*** Sending to xxx.xxx.xxx.xxx port 1645 
Code:   Access-Accept
Identifier: 43
Authentic:  k<145><5><15><209>T$<250><150>'<223>zN<167><189><217>
Attributes:
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Routing = None
Framed-MTU = 1500
Framed-Compression = Van-Jacobson-TCP-IP

--

What I have configured wrong? I believe I should see atleast some
AcctColumnDef information at debug, but there is nothing?

Also I'd like to get BOTH accounting logging methods work at same time, to
database and into detail-file. Though even another of those would be nice
for start... :)

++Toni



===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Re: (RADIATOR) Accounting log

1999-10-27 Thread Hugh Irvine

Hello Philip -

On Thu, 28 Oct 1999, Philip Buckley wrote:
> Hi Everyone,
> 
> 
> I have problem where I want Radiator to log one
> particular user or a group of users. Can this be done. Thanks in advance
> for your help.
> 

Not at the moment, no. You can only set up different logging for different
Realms or Handlers.

Improved configurability for logging is on the to-do list.

cheers

Hugh

--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsod

===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

(RADIATOR) Accounting log

1999-10-27 Thread Philip Buckley


Hi Everyone,


I have problem where I want Radiator to log one
particular user or a group of users. Can this be done. Thanks in advance
for your help.


===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

(RADIATOR) Accounting log file

1999-08-25 Thread Aurelien Requiem


Hello
I need to add informations into the Accounting log file.
I would like to know wich pakages i need to use and
where can i found all functions associated please !
Thanks a lot to answer me.


===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

(RADIATOR) Accounting log

1999-03-12 Thread Joanne Davis



I've forwarded this to the list.

Joanne

>
>Hi Radiator users,
>We are an Spanish ISP (INFASE), and we have running radiator evaluation
>version as a proxy radius.
>We want to know if radiator running as proxy radius is capable to
>collect accounting info locally and to pass this info to radius servers, an
>example:
>I've have configured radiator when a user's come in with @infase realm,
>it passes accounting info to Infase's radius, but I want that it passes this
>info and radiator registres this info also.
>
>Thank's in advance.
>
>Regards.
>
>David Ferruz
>[EMAIL PROTECTED]
>http://www.infase.es/
>Avd. Pianista Martinez Carrasco, 2
>Entresuelo   C.P. 46.026
>INFASE Comunicaciones, S.L.
>Telf.: (96)335 50 16
>Fax.: (96) 335 56 07
>
>Hi Radiator users,
>We
>are an Spanish ISP (INFASE), and we have running radiator evaluation
>version as a proxy radius.
>We
>want to know if radiator running as proxy radius is capable to collect
>accounting info locally and to pass this info to radius servers, an
>example:
>I've
>have configured radiator when a user's come in with @infase realm, it
>passes accounting info to Infase's radius, but I want that it passes this
>info and radiator registres this info also.
>
>Thank's in advance.
>
>Regards.
>
> 
>David Ferruz 
>[EMAIL PROTECTED] 
>HREF="http://www.infase.es/">http://www.infase.es/
>
>Avd. Pianista Martinez Carrasco, 2  
>Entresuelo   C.P. 46.026 
>INFASE Comunicaciones, S.L. 
>Telf.: (96)335 50 16 
>Fax.: (96) 335 56 07 
>
>

--
--

Joanne Davis
Irvine & Associates  Telephone +61 3 9596 0793
PO Box 2202  Caulfield Junction Vic 3161 Australia
Company e-mail  [EMAIL PROTECTED]



===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Re: (RADIATOR) Accounting Log Error

1999-03-04 Thread Mike McCauley


Hello Ferhat,
from this log file, I would say that you have not created the ACCOUNTING or
RADONLINE  tables. At any rate, Radiator cant find it in the default
database for your ODBC user . Is it possible you created them in a different
database, perhaps master?

What happens if you connect using isqlw, log in to SQL as the same user that
Radiator logs ion as, and do "select * from ACCOUNTING"


Hope that helps.
Cheers.



---
Mike McCauley [EMAIL PROTECTED]
Open System Consultants +61 3 9598 0985

Mike is travelling right now, and there may be delays
in our correspondence.
-Original Message-
From: Ferhat Dilman <[EMAIL PROTECTED]>
To: 'Mike McCauley' <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Wednesday, March 03, 1999 2:40 AM
Subject: (RADIATOR) Accounting Log Error


>Hi,
>
>I am trying a configuration using Windows/NT (for special purpose
>authentication) using SQLserver.
>
>I use ODBC, and SQLserver v7.0. Authentication works well. However I
receive
>error message in accounting using radpwtst. When I issue the insert
>statement using sqlquery program, it works..
>
>The tables exist and since it does authentication well I assume
>perlDBI/DBD/ODBC works too.
>
>Any ideas?
>
>Ferhat
>
>Tue Mar  2 17:11:57 1999: DEBUG: Packet dump:
>*** Received from 127.0.0.1 port 1528 
>Code:   Access-Request
>Identifier: 207
>Authentic:  1234567890123456
>Attributes:
> User-Name = "dilman"
> Service-Type = Framed-User
> NAS-IP-Address = 203.63.154.1
> NAS-Port = 1234
> NAS-Port-Type = Async
> User-Password = "<149><228>)<200><155>9r<147><206>@<9><160><216>}x<153>"
>
>Tue Mar  2 17:11:57 1999: DEBUG: Handling request with Handler
>'Realm=DEFAULT'
>Tue Mar  2 17:11:57 1999: DEBUG: Handling with Radius::AuthSQL
>Tue Mar  2 17:11:57 1999: DEBUG: Handling with Radius::AuthSQL
>Tue Mar  2 17:11:57 1999: DEBUG: Query is: select PASSWORD from SUBSCRIBERS
>where USERNAME='dilman'
>
>Tue Mar  2 17:11:58 1999: DEBUG: Radius::AuthSQL looks for match with
dilman
>Tue Mar  2 17:11:58 1999: DEBUG: Radius::AuthSQL ACCEPT:
>Tue Mar  2 17:11:58 1999: DEBUG: Access accepted for dilman
>Tue Mar  2 17:11:58 1999: DEBUG: Packet dump:
>*** Sending to 127.0.0.1 port 1528 
>Code:   Access-Accept
>Identifier: 207
>Authentic:  1234567890123456
>Attributes:
>
>Tue Mar  2 17:11:58 1999: DEBUG: Packet dump:
>*** Received from 127.0.0.1 port 1528 
>Code:   Accounting-Request
>Identifier: 208
>Authentic:  <198><243>(<144>2/<189>-W<181><135><228><180><136>M<134>
>Attributes:
> User-Name = "dilman"
> Service-Type = Framed-User
> NAS-IP-Address = 203.63.154.1
> NAS-Port = 1234
> NAS-Port-Type = Async
> Acct-Session-Id = "1234"
> Acct-Status-Type = Start
>
>Tue Mar  2 17:11:58 1999: DEBUG: Handling request with Handler
>'Realm=DEFAULT'
>Tue Mar  2 17:11:58 1999: DEBUG: Handling with Radius::AuthSQL
>Tue Mar  2 17:11:58 1999: DEBUG: Handling accounting with Radius::AuthSQL
>Tue Mar  2 17:11:58 1999: DEBUG: do query is: insert into ACCOUNTING
> (USERNAME, ACCTSTATUSTYPE, TIME_STAMP, NASPORT, ACCTSESSIONID)
> values
> ('dilman', 'Start', 920387518, 1234, '1234')
>
>Tue Mar  2 17:11:58 1999: ERR: do failed for 'insert into ACCOUNTING
> (USERNAME, ACCTSTATUSTYPE, TIME_STAMP, NASPORT, ACCTSESSIONID)
> values
> ('dilman', 'Start', 920387518, 1234, '1234')': [Microsoft][ODBC SQL
>Server Driver][SQL Server]Invalid object name 'ACCOUNTING'.
(SQL-S0002)(DBD:
>st_execute/SQLExecute err=-1)
>Tue Mar  2 17:11:58 1999: DEBUG:  Adding session for dilman, 203.63.154.1,
>1234
>Tue Mar  2 17:11:58 1999: DEBUG: do query is: delete from RADONLINE where
>NASIDENTIFIER='203.63.154.1' and NASPORT=1234
>
>Tue Mar  2 17:11:58 1999: ERR: do failed for 'delete from RADONLINE where
>NASIDENTIFIER='203.63.154.1' and NASPORT=1234': [Microsoft][ODBC SQL Server
>Driver][SQL Server]Invalid object name 'RADONLINE'. (SQL-S0002)(DBD:
>st_execute/SQLExecute err=-1)
>Tue Mar  2 17:11:58 1999: DEBUG: do query is: insert into RADONLINE
>(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
>FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('dilman',
'203.63.154.1',
>1234, '1234', 920387518, '', 'Async', 'Framed-User')
&g

(RADIATOR) Accounting Log Error

1999-03-02 Thread Ferhat Dilman


Hi,

I am trying a configuration using Windows/NT (for special purpose
authentication) using SQLserver.

I use ODBC, and SQLserver v7.0. Authentication works well. However I receive
error message in accounting using radpwtst. When I issue the insert
statement using sqlquery program, it works..

The tables exist and since it does authentication well I assume
perlDBI/DBD/ODBC works too.

Any ideas?

Ferhat

Tue Mar  2 17:11:57 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 1528 
Code:   Access-Request
Identifier: 207
Authentic:  1234567890123456
Attributes:
User-Name = "dilman"
Service-Type = Framed-User
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
User-Password = "<149><228>)<200><155>9r<147><206>@<9><160><216>}x<153>"

Tue Mar  2 17:11:57 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Tue Mar  2 17:11:57 1999: DEBUG: Handling with Radius::AuthSQL
Tue Mar  2 17:11:57 1999: DEBUG: Handling with Radius::AuthSQL
Tue Mar  2 17:11:57 1999: DEBUG: Query is: select PASSWORD from SUBSCRIBERS
where USERNAME='dilman'

Tue Mar  2 17:11:58 1999: DEBUG: Radius::AuthSQL looks for match with dilman
Tue Mar  2 17:11:58 1999: DEBUG: Radius::AuthSQL ACCEPT:
Tue Mar  2 17:11:58 1999: DEBUG: Access accepted for dilman
Tue Mar  2 17:11:58 1999: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 1528 
Code:   Access-Accept
Identifier: 207
Authentic:  1234567890123456
Attributes:

Tue Mar  2 17:11:58 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 1528 
Code:   Accounting-Request
Identifier: 208
Authentic:  <198><243>(<144>2/<189>-W<181><135><228><180><136>M<134>
Attributes:
User-Name = "dilman"
Service-Type = Framed-User
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "1234"
Acct-Status-Type = Start

Tue Mar  2 17:11:58 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Tue Mar  2 17:11:58 1999: DEBUG: Handling with Radius::AuthSQL
Tue Mar  2 17:11:58 1999: DEBUG: Handling accounting with Radius::AuthSQL
Tue Mar  2 17:11:58 1999: DEBUG: do query is: insert into ACCOUNTING
(USERNAME, ACCTSTATUSTYPE, TIME_STAMP, NASPORT, ACCTSESSIONID)
values
('dilman', 'Start', 920387518, 1234, '1234')

Tue Mar  2 17:11:58 1999: ERR: do failed for 'insert into ACCOUNTING
(USERNAME, ACCTSTATUSTYPE, TIME_STAMP, NASPORT, ACCTSESSIONID)
values
('dilman', 'Start', 920387518, 1234, '1234')': [Microsoft][ODBC SQL
Server Driver][SQL Server]Invalid object name 'ACCOUNTING'. (SQL-S0002)(DBD:
st_execute/SQLExecute err=-1)
Tue Mar  2 17:11:58 1999: DEBUG:  Adding session for dilman, 203.63.154.1,
1234
Tue Mar  2 17:11:58 1999: DEBUG: do query is: delete from RADONLINE where
NASIDENTIFIER='203.63.154.1' and NASPORT=1234

Tue Mar  2 17:11:58 1999: ERR: do failed for 'delete from RADONLINE where
NASIDENTIFIER='203.63.154.1' and NASPORT=1234': [Microsoft][ODBC SQL Server
Driver][SQL Server]Invalid object name 'RADONLINE'. (SQL-S0002)(DBD:
st_execute/SQLExecute err=-1)
Tue Mar  2 17:11:58 1999: DEBUG: do query is: insert into RADONLINE
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('dilman', '203.63.154.1',
1234, '1234', 920387518, '', 'Async', 'Framed-User')

Tue Mar  2 17:11:59 1999: ERR: do failed for 'insert into RADONLINE
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('dilman', '203.63.154.1',
1234, '1234', 920387518, '', 'Async', 'Framed-User')': [Microsoft][ODBC
SQL Server Driver][SQL Server]Invalid object name 'RADONLINE'.
(SQL-S0002)(DBD: st_execute/SQLExecute err=-1)
Tue Mar  2 17:11:59 1999: DEBUG: Accounting accepted
Tue Mar  2 17:11:59 1999: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 1528 
Code:   Accounting-Response
Identifier: 208
Authentic:  <198><243>(<144>2/<189>-W<181><135><228><180><136>M<134>
Attributes:

Tue Mar  2 17:11:59 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 1528 
Code:   Accounting-Request
Identifier: 209
Authentic:  ]<223><190><224>l<155>9A<255>5<147>$"u<18><233>
Attributes:
User-Name = "dilman"
Service-Type = Framed-User
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "1234"
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Time = 1000
Acct-Input-Octets = 2
Acct-Output-Octets = 3

Tue Mar  2 17:11:59 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Tue Mar  2 17:11:59 1999: DEBUG: Handling with Radius::AuthSQL
Tue Mar  2 17:11:59 1999: DEBUG: Handling accounting with Radius::AuthSQL
Tue Mar  2 17:11:59 1999: DEBUG: do query is: insert into ACCOUNTING
(US

Re: (RADIATOR) Accounting Log file format

(RADIATOR) Accounting Log file format

Re: (RADIATOR) accounting log format

(RADIATOR) accounting log format

Re: (RADIATOR) Accounting log problem

(RADIATOR) Accounting log problem

Re: (RADIATOR) Accounting log

(RADIATOR) Accounting log

(RADIATOR) Accounting log file

(RADIATOR) Accounting log

Re: (RADIATOR) Accounting Log Error

(RADIATOR) Accounting Log Error

12 matches

Site Navigation

Mail list logo

Footer information