Re: (RADIATOR) Multiple SessionDatabases per Handler?

2001-07-06 Thread Hugh Irvine


Hello Janet -

You can specify multiple database targets in a single SessionDatabase SQL.

# define multiple databases

SessionDatabase SQL
Identifier DSL-SessionCheck
DBSource ..
DBSource ..
..
/SessionDatabase


hth

Hugh


At 15:24 +1000 01/7/6, Janet N del Mundo wrote:
Hi,

Is it possible to have more than one SessionDatabase (for SQL fallback
purposes) within one Handler?  If not, how do I go about handling my
SessionDatabase SQL when the SQL cannot be reached?

I tried to add a SessionDatabase NULL for a fallback from my
SessionDatabase SQL, but I received error messages when I restarted
Radiator.


Fri Jul  6 14:44:22 2001: ERR: Unknown keyword 'SessionDatabase' in
radius_dsl.cfg line 394
Fri Jul  6 14:44:22 2001: ERR: Unknown keyword 'SessionDatabase' in
radius_dsl.cfg line 395

# Handle DSL users logging into the Shasta #
Handler NAS-IP-Address = /xxx.xxx.xx.x|xxx.xxx.xx.x/
 AuthBy GROUP
 AuthByPolicy ContinueWhileIgnore
 SessionDatabase DSL-SessionCheck
 SessionDatabase NULL
 /AuthBy
 AuthByPolicy ContinueWhileAccept
 AuthBy Check-DSL-Users
 AuthBy Check-SQL-DSLUSERS
 AuthBy DoAccounting
/Handler

Any suggestions or comments?
Thanks,
Janet

--
_
Janet del Mundo
Internet Administrator, Startec Global Communications
135 Chalan Santo Papa  Agana, Guam  96910
Email: [EMAIL PROTECTED]
===
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.

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

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://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) Using Radiator for Wholesale Dialup and SessionDatabase

2001-07-06 Thread Hugh Irvine


Hello Tom -

At 12:17 -0400 01/7/5, Tom Daly wrote:
Hello,
We are currently using Radiator and MySQL for a SessionDB. As a wholesale
provider, we have two ways for our wholesalers to access accounts.

1. Per Port - An ISP is assigned a unique DNIS to which all radius requested
are directed at thier radius server by proxy. We do this by the following
method.

CalledStationId /..3400/
 AuthBy RADIUS
 Host xxx.xxx.xxx.xxx
 Secret VeryVerySecret
 AuthPort 1645
 AcctPort 1646
 Retries 5
 RetryTimeout 15
 /AuthBy

This method seems to be slow, as we have to search through a few hundred
DNISs for the same provider, if they have multiple DNISs. So I am looking
for a way to use one statement that will search each providers list of
DNISs. Also, when a customer dials in, thier username is just username. It
there a way to make the session database show [EMAIL PROTECTED], but
still pass username to the proxy radius server?


If you are using the CalledStationId.pm file from the goodies 
section of the distribution, there is almost no overhead, as the 
number that is specified in the definition is used as a key to 
directly access that clause. This is by far the fastest way to 
process large numbers of phone numbers.

For your second question, you can use RewriteUsername(s) and custom 
queries for the SessionDatabase to do what you require.


2. Per User - An ISP is assigned a Unique REALM via a Realm or Handler
Realm= Clause. This gets very very complicated, so it there a way to
simplify this?


I don't understand the problem, sorry. Can you elaborate?


Also, 1 ISP does not use a realm, so is there a way to make
the session database show [EMAIL PROTECTED] and the radius server check
for just username?

See above - RewriteUsername(s) and custom queries.

regards

Hugh

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

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://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) IPs allocated forever

2001-07-06 Thread Hugh Irvine


Hi Jon -

At 12:11 +0200 01/7/5, Jon Omagojeaskoa wrote:
Thanks Hugh

My config-file was like:

ClientListSQL
 DBSource   ...
 DBUsername  ...
 DBAuth  ...

 GetClientQueryselect NASIDENTIFIER,SECRET,NULL,NULL, \
  DEFAULTREALM,NASTYPE,SNMPCOMMUNITY \
 from RADCLIENTLIST
/ClientListSQL



I've added the DUPINTERVAL field to my RADCLIENTLIST table with 
value 4  for the problematic NAS and:

 GetClientQueryselect 
NASIDENTIFIER,SECRET,NULL,DUPINTERVAL, \
  DEFAULTREALM,NASTYPE,SNMPCOMMUNITY \
 from RADCLIENTLIST


Problem solved !!


Good.




There are still lost IPs due to lost Stop-Packets, but I can clean 
them once a day with a crontab-script that sets STATE=0 to those IPs 
on RADPOOL that are not in RADONLINE.FRAMEDIPADDRESS. Is there a way 
to do the same cleaning within radiusd using

 ReclaimQuery
 DefaultLeasePeriod
 LeaseReclaimInterval

I work with MySQL database an nested SELECT querys are not allowed :-(


I think you will be better off doing your housekeeping outside Radiator.

hth

Hugh

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

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://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) Strange accounting record Acct-Status-Type =Accounting-On

2001-07-06 Thread Hugh Irvine


Hello Stafanita -

These are normal startup packets from a NAS after it reboots, but it 
looks like you are not responding to them correctly. I suspect you 
may not have a Client entry for this NAS in the Radiator 
configuration file.

I will need to see a copy of your configuration file (no secrets) 
together with a trace 4 debug from Radiator showing what is happening.

thanks

Hugh


At 15:10 +0300 01/7/5, Stefanita Vilcu wrote:
Hello,

I have an Max TNT (sw ver. 8.0.3) and a Radiator (2.18.2) on a RedHat
Linux 6.2.
I receive some strage accounting packets very often, is there any way to
stop/ignore them?

Thank you,

Stefanita Vilcu

*** Received from x.x.x.x port 7011 

Packet length = 61
04 2c 00 3d 1f 81 a7 c0 8f 3f 32 43 bd 1a 00 b3
b1 6e 94 6c 04 06 c1 e2 64 45 1a 0c 00 00 02 11
56 06 00 00 00 00 28 06 00 00 00 07 29 06 00 00
04 a2 2c 0b 37 32 30 30 31 30 36 30 32
Code:   Accounting-Request
Identifier: 44
Authentic:  31129167192143?2C189260179177n148l
Attributes:
   NAS-IP-Address = x.x.x.x
   Ascend-Owner-IP-Addr = 0.0.0.0
   Acct-Status-Type = Accounting-On
   Acct-Delay-Time = 1186
   Acct-Session-Id = 720010602

14:19:21.797673 eth0  bucharest2 7011  xxx.radacct: udp 61
14:19:26.795443 eth0  bucharest2 7011  xxx.radacct: udp 61
14:19:31.795295 eth0  bucharest2 7011  xxx.radacct: udp 61
14:20:56.817318 eth0  bucharest2 7011  xxx.radacct: udp 61
14:21:01.798182 eth0  bucharest2 7011  xxx.radacct: udp 61
14:21:06.794379 eth0  bucharest2 7011  xxx.radacct: udp 61
14:25:13.787386 eth0  bucharest2 7011  xxx.radacct: udp 61
14:25:18.787312 eth0  bucharest2 7011  xxx.radacct: udp 61
14:25:23.787621 eth0  bucharest2 7011  xxx.radacct: udp 61
14:37:36.768373 eth0  bucharest2 7011  xxx.radacct: udp 61
14:37:41.770545 eth0  bucharest2 7011  xxx.radacct: udp 61
14:37:46.767644 eth0  bucharest2 7011  xxx.radacct: udp 61


--
Stefanita Valeriu Vilcu, [EMAIL PROTECTED]
Dynamic Network Technologies, Romania
Tel: +40-1-2106863 Fax: +40-1-3122745


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

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

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://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) Simultaneous Use Problems

2001-07-06 Thread Kitabjian, Dave

I didn't know PM3's supported SNMP. You might want to find out whether SNMP
or Finger works with your equipment. If SNMP, you might want to specify an
SNMPCommunity entry for the Client.

Also, look in /var/log/radiator/radius.log and it will show you what
Radiator tries to do when it should be enforcing sim use. In the case of
SNMP, I know it will show you the whole Unix commanline that it runs, which
you can copy and paste onto your command line to test directly.

Also, if you're not sure what's in your SessionDatabase, you might want to
use a SessionDatabase DBM and then use the cgi to see who RADIATOR thinks is
online.

Dave

 -Original Message-
 From: Jonathon Lindbo [mailto:[EMAIL PROTECTED]] 
 Sent: Friday, July 06, 2001 12:34 PM
 To: [EMAIL PROTECTED]
 Subject: (RADIATOR) Simultaneous Use Problems
 
 
 Hi,
 
 I have been trying for the past 4 days to get my Simultaneous Login 
 restrictions to work.  I am currently working with PM3's and 
 have SNMP 
 enabled on them all.  I'm not sure what I am doing wrong.  
 Below is the 
 config that I am using.  Any ideas ?  Where should I look for 
 debugging 
 information on this.  I am not seeing much in the radius.log.
 
 Thanks
 Jon Lindbo
 
 
 ### BASE CONFIGURATION ###
 Trace   5
 PidFile /tmp/radiusd.pid
 AuthPort1645
 AcctPort1646
 LogDir  /var/log/radiator
 DbDir   /etc/radiator/raddb
 LogFile %L/radius.log
 SnmpgetProg /usr/local/bin/snmpget
 FingerProg  /usr/bin/finger
 #LivingstonOffs 23
 #LivingstonHole 1
 LivingstonHole  0
 
 ### CLIENT CONFIGURATION ###
 Client DEFAULT
  Secret BBsecretKEY
  DupInterval 2
  NasType Livingston
 /Client
 
 ### REALM CONFIGURATION ###
 
 Realm DEFAULT
  RewriteUsername s/^([^@]+).*/$1/
  AcctLogFileName %L/%Ndetail
  AcctLogFileFormat %{Timestamp} %{Acct-Session-Id} 
 %{User-Name}
  PasswordLogFileName %L/password.log
  MaxSessions 1
  AuthBy UNIX
  Identifier System
  Filename /etc/shadow
  Match ^([^:]*):([^:]*):?[^:]*:?([^:]*)
  DefaultSimultaneousUse 1
  AddToReply Service-Type = Framed-User, 
 Framed-Protocol = PPP, Session-Timeout = 14400, Idle-Timeout = 1500
  /AuthBy
 
 /Realm
 
 ===
 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.
 
===
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) Simultaneous Use Problems

2001-07-06 Thread Hugh Irvine


Hello Jonathon -

I will need to see the trace debug from Radiator to see what is going on.

thanks

Hugh


At 9:34 -0700 01/7/6, Jonathon Lindbo wrote:
Hi,

I have been trying for the past 4 days to get my Simultaneous Login 
restrictions to work.  I am currently working with PM3's and have 
SNMP enabled on them all.  I'm not sure what I am doing wrong. 
Below is the config that I am using.  Any ideas ?  Where should I 
look for debugging information on this.  I am not seeing much in the 
radius.log.

Thanks
Jon Lindbo


### BASE CONFIGURATION ###
Trace   5
PidFile /tmp/radiusd.pid
AuthPort1645
AcctPort1646
LogDir  /var/log/radiator
DbDir   /etc/radiator/raddb
LogFile %L/radius.log
SnmpgetProg /usr/local/bin/snmpget
FingerProg  /usr/bin/finger
#LivingstonOffs 23
#LivingstonHole 1
LivingstonHole  0

### CLIENT CONFIGURATION ###
Client DEFAULT
 Secret BBsecretKEY
 DupInterval 2
 NasType Livingston
/Client

### REALM CONFIGURATION ###

Realm DEFAULT
 RewriteUsername s/^([^@]+).*/$1/
 AcctLogFileName %L/%Ndetail
 AcctLogFileFormat %{Timestamp} %{Acct-Session-Id} %{User-Name}
 PasswordLogFileName %L/password.log
 MaxSessions 1
 AuthBy UNIX
 Identifier System
 Filename /etc/shadow
 Match ^([^:]*):([^:]*):?[^:]*:?([^:]*)
 DefaultSimultaneousUse 1
 AddToReply Service-Type = Framed-User, 
Framed-Protocol = PPP, Session-Timeout = 14400, Idle-Timeout = 1500
 /AuthBy

/Realm

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

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

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://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) Using Radiator for Wholesale Dialup and SessionDatabase

2001-07-06 Thread Tom Daly

Hi,

By default, what entry does Radiator to put into the Session Database? From
what I can see, it seems that it copies the Username as entered by the
user, before any rewrite username, or other functions are used.

Tom

- Original Message -
From: Hugh Irvine [EMAIL PROTECTED]
To: Tom Daly [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 5:44 AM
Subject: Re: (RADIATOR) Using Radiator for Wholesale Dialup and
SessionDatabase



 Hello Tom -

 At 12:17 -0400 01/7/5, Tom Daly wrote:
 Hello,
 We are currently using Radiator and MySQL for a SessionDB. As a wholesale
 provider, we have two ways for our wholesalers to access accounts.
 
 1. Per Port - An ISP is assigned a unique DNIS to which all radius
requested
 are directed at thier radius server by proxy. We do this by the following
 method.
 
 CalledStationId /..3400/
  AuthBy RADIUS
  Host xxx.xxx.xxx.xxx
  Secret VeryVerySecret
  AuthPort 1645
  AcctPort 1646
  Retries 5
  RetryTimeout 15
  /AuthBy
 
 This method seems to be slow, as we have to search through a few hundred
 DNISs for the same provider, if they have multiple DNISs. So I am looking
 for a way to use one statement that will search each providers list of
 DNISs. Also, when a customer dials in, thier username is just username.
It
 there a way to make the session database show [EMAIL PROTECTED], but
 still pass username to the proxy radius server?


 If you are using the CalledStationId.pm file from the goodies
 section of the distribution, there is almost no overhead, as the
 number that is specified in the definition is used as a key to
 directly access that clause. This is by far the fastest way to
 process large numbers of phone numbers.

 For your second question, you can use RewriteUsername(s) and custom
 queries for the SessionDatabase to do what you require.


 2. Per User - An ISP is assigned a Unique REALM via a Realm or Handler
 Realm= Clause. This gets very very complicated, so it there a way to
 simplify this?


 I don't understand the problem, sorry. Can you elaborate?


 Also, 1 ISP does not use a realm, so is there a way to make
 the session database show [EMAIL PROTECTED] and the radius server
check
 for just username?

 See above - RewriteUsername(s) and custom queries.

 regards

 Hugh

 --

 NB: I am travelling this week, so there may be delays in our
correspondence.

 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://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) Using Radiator for Wholesale Dialup andSessionDatabase

2001-07-06 Thread Hugh Irvine


Hi Tom -

By default Radiator uses the username string as received from the 
NAS, as that is what it needs if it is to query the NAS directly to 
verify connections.

regards

Hugh


At 12:29 -0400 01/7/6, Tom Daly wrote:
Hi,

By default, what entry does Radiator to put into the Session Database? From
what I can see, it seems that it copies the Username as entered by the
user, before any rewrite username, or other functions are used.

Tom

- Original Message -
From: Hugh Irvine [EMAIL PROTECTED]
To: Tom Daly [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 5:44 AM
Subject: Re: (RADIATOR) Using Radiator for Wholesale Dialup and
SessionDatabase



  Hello Tom -

  At 12:17 -0400 01/7/5, Tom Daly wrote:
  Hello,
  We are currently using Radiator and MySQL for a SessionDB. As a wholesale
  provider, we have two ways for our wholesalers to access accounts.
  
  1. Per Port - An ISP is assigned a unique DNIS to which all radius
requested
  are directed at thier radius server by proxy. We do this by the following
  method.
  
  CalledStationId /..3400/
   AuthBy RADIUS
   Host xxx.xxx.xxx.xxx
   Secret VeryVerySecret
   AuthPort 1645
   AcctPort 1646
   Retries 5
   RetryTimeout 15
   /AuthBy
  
  This method seems to be slow, as we have to search through a few hundred
  DNISs for the same provider, if they have multiple DNISs. So I am looking
  for a way to use one statement that will search each providers list of
  DNISs. Also, when a customer dials in, thier username is just username.
It
  there a way to make the session database show [EMAIL PROTECTED], but
  still pass username to the proxy radius server?


  If you are using the CalledStationId.pm file from the goodies
  section of the distribution, there is almost no overhead, as the
  number that is specified in the definition is used as a key to
  directly access that clause. This is by far the fastest way to
  process large numbers of phone numbers.

  For your second question, you can use RewriteUsername(s) and custom
  queries for the SessionDatabase to do what you require.


  2. Per User - An ISP is assigned a Unique REALM via a Realm or Handler
  Realm= Clause. This gets very very complicated, so it there a way to
  simplify this?


  I don't understand the problem, sorry. Can you elaborate?


  Also, 1 ISP does not use a realm, so is there a way to make
  the session database show [EMAIL PROTECTED] and the radius server
check
  for just username?

  See above - RewriteUsername(s) and custom queries.

  regards

  Hugh

  --

  NB: I am travelling this week, so there may be delays in our
correspondence.

  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.


-- 

NB: I am travelling this week, so there may be delays in our correspondence.

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://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) Using Radiator for Wholesale Dialup andSessionDatabase

2001-07-06 Thread Tom Daly

Hugh,

I would say my problem then is this. I am using CalledStation.pm to send
users to radius proxy which does not use a realm, so users will dialup with
'username'. Now, our ISP does not require users to have a realm name either,
so they also dialup with 'username'. In the case of two identical usernames
between ISPs, one user will not be authenticated. Is there a way I can add a
realm name to the CalledStation.pm users for the sake of the session
database, however, still send the proxy server just 'username'. I am
guessing this will need to be done with some sort of hook.

--Tom

- Original Message -
From: Hugh Irvine [EMAIL PROTECTED]
To: Tom Daly [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 12:21 PM
Subject: Re: (RADIATOR) Using Radiator for Wholesale Dialup
andSessionDatabase



 Hi Tom -

 By default Radiator uses the username string as received from the
 NAS, as that is what it needs if it is to query the NAS directly to
 verify connections.

 regards

 Hugh


 At 12:29 -0400 01/7/6, Tom Daly wrote:
 Hi,
 
 By default, what entry does Radiator to put into the Session Database?
From
 what I can see, it seems that it copies the Username as entered by the
 user, before any rewrite username, or other functions are used.
 
 Tom
 
 - Original Message -
 From: Hugh Irvine [EMAIL PROTECTED]
 To: Tom Daly [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Friday, July 06, 2001 5:44 AM
 Subject: Re: (RADIATOR) Using Radiator for Wholesale Dialup and
 SessionDatabase
 
 
 
   Hello Tom -
 
   At 12:17 -0400 01/7/5, Tom Daly wrote:
   Hello,
   We are currently using Radiator and MySQL for a SessionDB. As a
wholesale
   provider, we have two ways for our wholesalers to access accounts.
   
   1. Per Port - An ISP is assigned a unique DNIS to which all radius
 requested
   are directed at thier radius server by proxy. We do this by the
following
   method.
   
   CalledStationId /..3400/
AuthBy RADIUS
Host xxx.xxx.xxx.xxx
Secret VeryVerySecret
AuthPort 1645
AcctPort 1646
Retries 5
RetryTimeout 15
/AuthBy
   
   This method seems to be slow, as we have to search through a few
hundred
   DNISs for the same provider, if they have multiple DNISs. So I am
looking
   for a way to use one statement that will search each providers list
of
   DNISs. Also, when a customer dials in, thier username is just
username.
 It
   there a way to make the session database show [EMAIL PROTECTED],
but
   still pass username to the proxy radius server?
 
 
   If you are using the CalledStationId.pm file from the goodies
   section of the distribution, there is almost no overhead, as the
   number that is specified in the definition is used as a key to
   directly access that clause. This is by far the fastest way to
   process large numbers of phone numbers.
 
   For your second question, you can use RewriteUsername(s) and custom
   queries for the SessionDatabase to do what you require.
 
 
   2. Per User - An ISP is assigned a Unique REALM via a Realm or
Handler
   Realm= Clause. This gets very very complicated, so it there a way to
   simplify this?
 
 
   I don't understand the problem, sorry. Can you elaborate?
 
 
   Also, 1 ISP does not use a realm, so is there a way to make
   the session database show [EMAIL PROTECTED] and the radius server
 check
   for just username?
 
   See above - RewriteUsername(s) and custom queries.
 
   regards
 
   Hugh
 
   --
 
   NB: I am travelling this week, so there may be delays in our
 correspondence.
 
   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.
 

 --

 NB: I am travelling this week, so there may be delays in our
correspondence.

 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://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) Multiple SessionDatabases per Handler?

2001-07-06 Thread Chris M

I assume that specifying multiple databases means that both would be
written/updated at the appropriate times, and that you wouldn't have to
figure out how to replicate them in any way

Chris

 From: Hugh Irvine [EMAIL PROTECTED]
 Date: Fri, 6 Jul 2001 19:34:20 +1000
 To: Janet N del Mundo [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: Re: (RADIATOR) Multiple SessionDatabases per Handler?
 
 
 Hello Janet -
 
 You can specify multiple database targets in a single SessionDatabase SQL.
 
 # define multiple databases
 
 SessionDatabase SQL
 Identifier DSL-SessionCheck
 DBSource ..
 DBSource ..
 ..
 /SessionDatabase
 
 
 hth
 
 Hugh
 
 
 At 15:24 +1000 01/7/6, Janet N del Mundo wrote:
 Hi,
 
 Is it possible to have more than one SessionDatabase (for SQL fallback
 purposes) within one Handler?  If not, how do I go about handling my
 SessionDatabase SQL when the SQL cannot be reached?
 
 I tried to add a SessionDatabase NULL for a fallback from my
 SessionDatabase SQL, but I received error messages when I restarted
 Radiator.
 
 
 Fri Jul  6 14:44:22 2001: ERR: Unknown keyword 'SessionDatabase' in
 radius_dsl.cfg line 394
 Fri Jul  6 14:44:22 2001: ERR: Unknown keyword 'SessionDatabase' in
 radius_dsl.cfg line 395
 
 # Handle DSL users logging into the Shasta #
 Handler NAS-IP-Address = /xxx.xxx.xx.x|xxx.xxx.xx.x/
 AuthBy GROUP
 AuthByPolicy ContinueWhileIgnore
 SessionDatabase DSL-SessionCheck
 SessionDatabase NULL
 /AuthBy
 AuthByPolicy ContinueWhileAccept
 AuthBy Check-DSL-Users
 AuthBy Check-SQL-DSLUSERS
 AuthBy DoAccounting
 /Handler
 
 Any suggestions or comments?
 Thanks,
 Janet
 
 --
 _
 Janet del Mundo
 Internet Administrator, Startec Global Communications
 135 Chalan Santo Papa Agana, Guam  96910
 Email: [EMAIL PROTECTED]
 ===
 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.
 
 -- 
 
 NB: I am travelling this week, so there may be delays in our correspondence.
 
 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://www.open.com.au/archives/radiator/
 Announcements on [EMAIL PROTECTED]
 To unsubscribe, email '[EMAIL PROTECTED]' with
 'unsubscribe radiator' in the body of the message.

===
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) Conditionals?

2001-07-06 Thread Griff Hamlin

Hello,

Is it possible to do a different select statement in an AuthBy SQL
clause based on the value of a global variable set previously in the
config file? If so, how is it done?

Griff Hamlin, III


===
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) restartWrapper

2001-07-06 Thread Griff Hamlin

Can anyone tell me how restartWrapper determines whether or not to
restart radius? Is it only of the radiusd process stops or does it
restart it if it crashes (for example if it cannot access the mysql
database anymore?).

Griff Hamlin, III

===
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) Conditionals?

2001-07-06 Thread Hugh Irvine


Hello Griff -

The answer to this depends on your exact requirements, however it may 
be as simple as using special characters, or it may involve writing a 
Hook, or it may be possible to do something clever in the 
configurtain file.

If you send me a more detailed description of what you want to do 
I'll try to make some sensible suggestions.

regards

Hugh


At 11:57 -0700 01/7/6, Griff Hamlin wrote:
Hello,

Is it possible to do a different select statement in an AuthBy SQL
clause based on the value of a global variable set previously in the
config file? If so, how is it done?

Griff Hamlin, III


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

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

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://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) Using Radiator for Wholesale DialupandSessionDatabase

2001-07-06 Thread Hugh Irvine


Hello Tom -

How are you going to know which customer is which?

regards

Hugh


At 12:51 -0400 01/7/6, Tom Daly wrote:
Hugh,

I would say my problem then is this. I am using CalledStation.pm to send
users to radius proxy which does not use a realm, so users will dialup with
'username'. Now, our ISP does not require users to have a realm name either,
so they also dialup with 'username'. In the case of two identical usernames
between ISPs, one user will not be authenticated. Is there a way I can add a
realm name to the CalledStation.pm users for the sake of the session
database, however, still send the proxy server just 'username'. I am
guessing this will need to be done with some sort of hook.

--Tom

- Original Message -
From: Hugh Irvine [EMAIL PROTECTED]
To: Tom Daly [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 12:21 PM
Subject: Re: (RADIATOR) Using Radiator for Wholesale Dialup
andSessionDatabase



  Hi Tom -

  By default Radiator uses the username string as received from the
  NAS, as that is what it needs if it is to query the NAS directly to
  verify connections.

  regards

  Hugh


  At 12:29 -0400 01/7/6, Tom Daly wrote:
  Hi,
  
  By default, what entry does Radiator to put into the Session Database?
From
  what I can see, it seems that it copies the Username as entered by the
  user, before any rewrite username, or other functions are used.
  
  Tom
  
  - Original Message -
  From: Hugh Irvine [EMAIL PROTECTED]
  To: Tom Daly [EMAIL PROTECTED]; [EMAIL PROTECTED]
  Sent: Friday, July 06, 2001 5:44 AM
  Subject: Re: (RADIATOR) Using Radiator for Wholesale Dialup and
  SessionDatabase
  
  
  
Hello Tom -
  
At 12:17 -0400 01/7/5, Tom Daly wrote:
Hello,
We are currently using Radiator and MySQL for a SessionDB. As a
wholesale
provider, we have two ways for our wholesalers to access accounts.

1. Per Port - An ISP is assigned a unique DNIS to which all radius
  requested
are directed at thier radius server by proxy. We do this by the
following
method.

CalledStationId /..3400/
 AuthBy RADIUS
 Host xxx.xxx.xxx.xxx
 Secret VeryVerySecret
 AuthPort 1645
 AcctPort 1646
 Retries 5
 RetryTimeout 15
 /AuthBy

This method seems to be slow, as we have to search through a few
hundred
DNISs for the same provider, if they have multiple DNISs. So I am
looking
for a way to use one statement that will search each providers list
of
DNISs. Also, when a customer dials in, thier username is just
username.
  It
there a way to make the session database show [EMAIL PROTECTED],
but
still pass username to the proxy radius server?
  
  
If you are using the CalledStationId.pm file from the goodies
section of the distribution, there is almost no overhead, as the
number that is specified in the definition is used as a key to
directly access that clause. This is by far the fastest way to
process large numbers of phone numbers.
  
For your second question, you can use RewriteUsername(s) and custom
queries for the SessionDatabase to do what you require.
  
  
2. Per User - An ISP is assigned a Unique REALM via a Realm or
Handler
Realm= Clause. This gets very very complicated, so it there a way to
simplify this?
  
  
I don't understand the problem, sorry. Can you elaborate?
  
  
Also, 1 ISP does not use a realm, so is there a way to make
the session database show [EMAIL PROTECTED] and the radius server
  check
for just username?
   
See above - RewriteUsername(s) and custom queries.
  
regards
  
Hugh
  
--
  
NB: I am travelling this week, so there may be delays in our
  correspondence.
  
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.
  

  --

  NB: I am travelling this week, so there may be delays in our
correspondence.

  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://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, 

Re: (RADIATOR) Problems with Bay 8000 RAC

2001-07-06 Thread Hugh Irvine


Hello Sergio -

I have no direct experience with Bay hardware, but it sounds like 
either a software version or a software configuration issue on the 
NAS itself.

You can see what attributes the NAS is sending by turning hexidecimal 
packet dumps on in Radiator with a trace 5 debug.

regards

Hugh


At 18:51 -0500 01/7/6, Sergio Gonzalez wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi there.


I got some problems trying to make a bay 8000 RAC to receive and 
send the appropriate data from/to the radius radiator server. First 
problem, when a ppp session starts for a particular user in radiator 
(that has a static IP address, sent via Frame-IP-Address), the bay 
8000 RAC doesn't care about it, and just puts an IP address from its 
own dynamic pool. I got the same radiator listening and serving to 
other 2 RASes without problems when using that specific user. The 
other problem I've is when the session stops, the bay 8000 RAC 
doesn't send the speed used by the user ( the receive speed used by 
the user). Instead of that info, the bay RAC doesn't send anything 
(I got just nulls).


Somebody has an example of the particular attributes I've to use in 
order to make the Bay 8000 RAC to take care about the
Framed-IP-Address and send back to radiator - in accounting stop 
packets - the speed used?.



PD: Sombody here in this list has a good example of a config.annex 
file?. If someone, please send me a copy to my email address. I 
really appreciate if someone can give a hand with that file.


Thanks.

Sergio Alejandro Gonzalez
Director Operativo
SkyNet de Colombia.
Bogota, Colombia, South America.
57 (+1) 6 422 020
57 (+3) 7 285 094

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

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

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://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) Radiator Profiles

2001-07-06 Thread Hugh Irvine


Hello Kyle -

You will need to add the following to your configuration file:

# specify an AuthByPolicy to control multiple AuthBy clauses

Realm 
AuthByPolicy ContinueWhileAccept
.
/Realm


hth

Hugh


At 12:42 -0400 01/7/6, Kyle wrote:
Hi guys, I'm trying to make profiles work from a mySql table. I've
followed the example provided in the goodies directory, dealing with
doing from file authentication. I'm adding a reply field of Profile in
my first AuthBy SQL clause, added a second AuthBy SQL clause
immediatly following it, and my AuthBy DYNADDRESS clause is last. I've
added a StripFromReply at the end of the second AuthBy to take out the
Profile field. It does not appear to be using the second AuthBy when
authenticating an user. I see the Profile field in the reply packet.
I've included my realms.cfg file. file for examination. -- Kyle
Content-Type: application/x-ns-proxy-autoconfig;
  name=realms.cfg
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
  filename=realms.cfg

Attachment converted: Macintosh HD:realms.cfg (/) (0001FEEF)

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

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://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) restartWrapper

2001-07-06 Thread Hugh Irvine


Hello Griff -

The restartWrapper program runs radiusd as a child process and 
waits for it to exit. If the child process exits for any reason, 
restartWrapper will restart it.

hth

Hugh


At 12:54 -0700 01/7/6, Griff Hamlin wrote:
Can anyone tell me how restartWrapper determines whether or not to
restart radius? Is it only of the radiusd process stops or does it
restart it if it crashes (for example if it cannot access the mysql
database anymore?).

Griff Hamlin, III

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

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

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://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) Auth by Text Questions

2001-07-06 Thread Hugh Irvine


Hello Todd -

At 13:49 -0700 01/7/6, Todd Dokey wrote:
I just had Radiator dropped into my lap this last week amidst other things.

I must be missing a REAL OBVIOUS issue, but I can't get my Radiator to auth
off of a file.

This is on a Linux box with the rpm file for the install.

The file is traditional in that it points the logfiles and gets the users
file from the normal spots.
The files are there.

In radius.cfg is where I have the case of the DUHs going on.

The only Authby Text clause I have is at the bottom (the standard DEFAULT)
and have added above it Client lists of the modems sending the requests.

Those I sorted by location and type, so they swap out dictionaries as
needed.


You can only specify a single dictionary file for Radiator, and you 
should start off with the standard dictionary file and add any 
additional entries to it with your favourite text editor.


That is about all I did.  Radiator starts okay, but won't authenticate off
localhost (yes, built that entry.. once as in the example localhost and
redone as 127.0.0.1.

I looked over the logs, it seems to start, but then doesn't complete.

I will need to see a copy of the configuration file (no secrets), 
together with a trace 4 debug from Radiator showing what is happening 
at startup.

thanks

Hugh

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

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://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.