[RADIATOR] Multi-Line Handler issues with 4.10

2012-07-02 Thread Aaron Holtz
Hello - I've noticed with 4.10 that you can no longer have multi-line 
Handler statements.

Under 4.9 something like this loads properly:

Handler Called-Station-Id=/(7103925369|7105941010|\
563974|4445690321|3335774198)/, CHAP-Password=/[\w]+/

Under 4.10 I'm getting:

Sun Jul  1 13:27:43 2012: ERR: Unknown keyword 'Handler' in 
/etc/raddb/test.cfg line 6


Is this a bug?  We have a fairly complex config file with several 
multi-line handlers and upgrading to 4.10 isn't going to be possible 
without having some seriously long Handler statements.

Thanks.

-
Aaron Holtz aho...@bright.net
Com Net, Inc.
-
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator


Re: (RADIATOR) Keeping only Acct-Statu-Type = Stop

2000-09-09 Thread Aaron Holtz

Wayne,

Use the following in your radius.cfg file:

AuthBy ...
  AccountingStopsOnly
/AuthBy

I believe that should work - it does for me.

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--

On Sep 9, Wayne molded the electrons to say

I know that in 15.5 of the documentation it say that Every
Accounting-Request regardless of the Acct-Status_type is stored in the
log file. Is there anyway of tossing the start and alive messages
generated by my cisco boxes ?  I need to have the messages in order to
keep track of the IP address in the online.db but if I could keep them
out of my log file this would cut my size in 1/3. If anyone has made
this change or could point me in the right direction that would be
great.

Wayne


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



===
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) Sim. use control by Ping

2000-06-15 Thread Aaron Holtz

I'm not sure that is correct.  If you look at the code, DeleteQuery runs
right before a new session is entered into the online database.  So if
your query includes removing the Framed IP from the database you should be
good to go.  Using the ping type and changing up your DeleteQuery should
keep your online database almost perfect.  The only instance where things
can get goofy are when a Stop packet is lost and the next user who gets
the Framed IP of the lost Stop packet user has their Start packet lost.
Just modify your DeleteQuery statement per Mike's previous suggestion and
you should be all set.

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--

On Jun 15, Clement molded the electrons to say

I downloaded 2.16.1 and checked the document.  It says "DeleteQuery" "is
executed whenever a user session finishes".  So this modification will
not work because the problem that we want to fix is a loss of the
account close packet.  And that sessions are not closed properly.

I suppose the change is to allow 2 SQL statements for "AddQuery".  One
like this to delete any pre-existing one.  And the normal one to create
the record.  This can be made the default as no 2 sessions should share
the same IP address or same NASID and NASPORT pair.


Mike McCauley wrote:
 The DeleteQuery gets run just before adding a new session. I wonder if the
 right thing is to alter the DeleteQuery so it deletes the IP address too:
 
 DeleteQuery delete from RADONLINE where (NASIDENTIFIER='%N' and
 NASPORT=0%{NAS-Port}) or FRAMEDIPADDRESS = '%{Framed-IP-Address}'
 
 Thoughts?
 
 Cheers.

Regards,

Clement
ANS Communications P/L
===
Post Addr:  P O Box 6626 Blacktown BC, NSW 2148
Tel: (02) 9552 1655 Fax: (02) 9972 2633

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



===
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) Sim. use control by Ping

2000-06-14 Thread Aaron Holtz

That makes pretty good sense.  As the one who added the
DeleteIPQuery code and made this suggestion earlier, the mod offered by
Mike allows you to modify the delete query without changing any internal
code.  No?   

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--

On Jun 15, Mike McCauley molded the electrons to say

On Jun 15,  8:33am, Hugh Irvine wrote:
 Subject: Re: (RADIATOR) Sim. use control by Ping

 Hello Clement -

 On Wed, 14 Jun 2000, Clement wrote:
  Hi Mike and Hugh,
 
  Thank you very much for the new feature.  Most of the time, it works
  well.  However, we just come into a situation when the old IP was
  reallocated and the PING test just failed to tell.
 
  I think the solution is simple.  Before writing a new session record,
  remove any existing one with the same IP address.  This should be true
  in all situations.  An IP address just cannot be used by 2 or more
  connections at the same time.  For session data base using SQL, which we
  are, it may need only one SQL statement like this to do the job.
 
 delete * from RADONLINE where FRAMEDIPADDRESS = 'new.ip.addr';
 
  Can you gentlemen make the change?  I think it can be a 2 minute job for
  you experts.

 This is exactly what one of our other customers has done - he added a
 "DeleteIPQuery" to the session database. We haven't yet included this in
 Radiator because we are concerned about the potential for the session
database
 to become corrupted in some circumstances.

 I've forwarded your thoughts to Mike.
The DeleteQuery gets run just before adding a new session. I wonder if the
right thing is to alter the DeleteQuery so it deletes the IP address too:

DeleteQuerydelete from RADONLINE where (NASIDENTIFIER='%N' and
NASPORT=0%{NAS-Port}) or FRAMEDIPADDRESS = '%{Framed-IP-Address}'

Thoughts?

Cheers.


 many thanks for your contributions

 regards

 Hugh

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



-- End of excerpt from Hugh Irvine



-- 
Mike McCauley   [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985   Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc 
on Unix, Win95/8, 2000, NT, MacOS X
===
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.



===
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) 2.16 LogQuery and format_special not being expanded

2000-06-07 Thread Aaron Holtz

I'm setting up a custom LogQuery for my Log SQL function and it appears
that not all the % variables are getting expanded like I would expect
that they should.  Here is my config:

Log SQL
   Table radlog
   LogQuery insert into radlog values (%t, '%N', '%h', $p, $s)
   include %D/connections/logsql.remote.connection
   Trace 3
/Log


Here is a snippet of the output:

*** Received from 205.212.1.1 port 1187 
Code:   Access-Request
Identifier: 140
Authentic:  1234567890123456
Attributes:
User-Name = "primus"
Service-Type = Framed-User
NAS-IP-Address = 205.212.1.1
NAS-Port = 1234
NAS-Port-Type = Async
Framed-IP-Address = 255.255.255.254
Password =
"164R196236p150219214Q{156237156187234229"


Fri Jun  2 12:56:58 2000: DEBUG: do query is: insert into radlog values
(959965018, '', 'radiator.comnetohio.com', 3, 'Access for \'primus\'
rejected: Bad Encrypted password')


%N should have no problem being expanded as there is a NAS-IP-Address
attribute.  Some other attributes don't show up either (%n, %U to name
two.)  I'm using radpwtst -gui to send this access packet.  Not sure why
these aren't getting expanded like they should.  It's as if the contents
of the packet are the ones that don't get expanded, just those variables
that are internal to the program (like the DbDir and hostname, etc.)   I
didn't see any docs on using LogQuery or caveats so maybe I'm missing
something here.  Thanks.


------
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--



===
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) Oddness with 2.16 and SessionDatabase Identifiers

2000-06-07 Thread Aaron Holtz

With 2.16 I'm seeing two things that don't seem to fit with the docs.
One is that the last database defined in the config is not
the one used as the default, it is the first one listed.  Second is that
the SessionDatabase item in the Handler sections are not being
honored.  Here is my config that is relevant:

Handler Realm=/^mail.comnetohio.com/i
SessionDatabase MEMNULL
/Handler

Handler Realm="", User-Name=/^[a-z0-9\-\.]+$/
SessionDatabase SQLDB
AuthByPolicy ContinueWhileReject
AuthBy SQL
AuthSelect
AccountingTable detail
. 
/Handler


SessionDatabase SQL
Identifier SQLDB
include %D/connections/sessiondb.remote.connection
include %D/connections/sessiondb.queries
/SessionDatabase

SessionDatabase NULL
Identifier MEMNULL
/SessionDatabase

Since NULL is listed last it should be the default.  But no matter what
query I send, it always uses the SQLDB Identifier (at least the debug  
output shows that is so and the query printed shows it is talking to   
the database):


Fri Jun  2 10:13:18 2000: DEBUG: Packet dump:
*** Received from 205.212.1.1 port 1186  
Code:   Access-Request
Identifier: 94
Authentic:  1234567890123456
Attributes:
User-Name = "[EMAIL PROTECTED]"
Service-Type = Framed-User
NAS-IP-Address = 205.212.1.1
NAS-Port = 1234
NAS-Port-Type = Async
Framed-IP-Address = 255.255.255.254
Password =
"164R196236p150219139Q{156237156187234229"

Fri Jun  2 10:13:18 2000: DEBUG: Rewrote user name to
[EMAIL PROTECTED]
Fri Jun  2 10:13:18 2000: DEBUG: Rewrote user name to
[EMAIL PROTECTED]
Fri Jun  2 10:13:18 2000: DEBUG: Check if Handler
Realm=/^mail.comnetohio.com/i should be used to handle this request
Fri Jun  2 10:13:18 2000: DEBUG: Handling request with Handler
'Realm=/^mail.comnetohio.com/i'
Fri Jun  2 10:13:18 2000: DEBUG: SQLDB Deleting session for
[EMAIL PROTECTED], 205.212.1.1, 1234

Fri Jun  2 10:13:18 2000: INFO: Access rejected for
[EMAIL PROTECTED]:
Fri Jun  2 10:13:18 2000: DEBUG: do query is: insert into radlog
(TIME_STAMP, PRIORITY, MESSAGE) values (959955198, 3, 'Access rejected for
[EMAIL PROTECTED]: ')

Fri Jun  2 10:13:18 2000: DEBUG: Packet dump:
*** Sending to 205.212.112.1 port 1186   
Code:   Access-Reject
Identifier: 94
Authentic:  1234567890123456
Attributes:
Reply-Message = "Request Denied"


Now if I were to switch the position of NULL and SQLDB in the config file,
then NULL becomes the sole database used by all Handlers.  This is a fresh
unpack of 2.16 in its own directory.  I get no errors on startup.  But I
have noticed that order in the configuration file for some clauses is very
important.  For example: I get no debug output from the Log SQL clause
unless it appears BEFORE the SessionDatabase ... clauses.  Is there
something I should be watching out for?  My Log SQL option is as
follows:


Log SQL
   Table radlog
   include %D/connections/logsql.remote.connection
   Trace 3
/Log


In my packet dump above you can see that it shows entering in the error
message to the sql log, but that line never shows up (nor does the log sql
query sent at radiusd startup) if Log SQL appears after the
SessionDatabase .. clauses in the config file.  Any input is  
appreciated.


------
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--



===
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) How do I get a cisco as5300 to give me framed-ip-addressina start record

2000-03-25 Thread Aaron Holtz

Not sure of the version.  I know 2.14 and higher.  Check the Handler.pm
module for the word 'Alive'.  Also, it may be possible that you are
filtering out that packet before the update could occur in your
radius.cfg file - but I won't say that for sure.

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--

On Mar 25, Steve Lalonde molded the electrons to say

I already have this

aaa accounting update newinfo

but it does not update my online list

what version of radiator do i need to get this to work?

Steve Lalonde
Systems Manager
ENTANET International Ltd
I believe the technical term is "Oops!"


- Original Message -
From: "Aaron Holtz" [EMAIL PROTECTED]
To: "Steve Lalonde" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, March 25, 2000 4:02 PM
Subject: Re: (RADIATOR) How do I get a cisco as5300 to give me
framed-ip-addressin a start record


 It doesn't show up in the Start record as it hasn't been assigned yet by
 the Cisco (at the time the record is generated).  Add the following
 command to your aaa statements:

 aaa accounting update newinfo

 You will now get a second record (Called an Alive record, not a Start
 record).  Radiator understands this packet and will update your online
 databases and other things accordingly with the new information for the
 user. This packet is generated after ppp is negotiated and the user has
 their framed IP.

 ------
 Aaron Holtz
 ComNet Inc.
 UNIX Systems Administration/Network Operations
 "It's not broken, it just lacks duct tape."
 --

 On Mar 25, Steve Lalonde molded the electrons to say

 Hi all
 
 How do I get a cisco as5300 to give me framed-ip-address in an auth
record
 like my 3com hipers do?
 
 the cisco is running 12.1.1
 
 
 here is a sample from the cisco
 
 Code:   Accounting-Request
 Identifier: 57
 Authentic:  2208T99230176207i*6141238n%
 Attributes:
 Client-Id = 192.168.115.1
 NAS-Port = 1
 Cisco-NAS-Port = "Async1"
 NAS-Port-Type = Async
 User-Name = "steve"
 Called-Station-Id = ""
 Calling-Station-Id = "xx"
 Acct-Status-Type = Start
 Acct-Authentic = RADIUS
 Service-Type = Framed-User
 Acct-Session-Id = "000E"
 Framed-Protocol = PPP
 Acct-Delay-Time = 0
 
 
 heres what i want (3com hiperarc)
 
 Code:   Accounting-Request
 Identifier: 239
 Authentic:  195B222-227MY208167241159"27185230233
 Attributes:
 User-Name = "000110"
 Client-Id = 192.168.110.1
 Acct-Status-Type = Start
 Acct-Session-Id = "117965522"
 Acct-Delay-Time = 0
 Acct-Authentic = RADIUS
 Service-Type = Framed-User
 NAS-Port-Type = ISDN
 NAS-Port = 1801
 USR-Modem-Training-Time = 1
 USR-Interface-Index = 3057
 Chassis-Call-Slot = 8
 Chassis-Call-Span = 1
 Chassis-Call-Channel = 9
 Unauthenticated-Time = 0
 Calling-Station-Id = ""
 Called-Station-Id = ""
 Modulation-Type = 0
 Simplified-MNP-Levels = synchronousNone
 Simplified-V42bis-Usage = none
 Connect-Speed = 64000-BPS
 Framed-Protocol = PPP
 Framed-IP-Address = 192.168.117.251
 VTS-Session-Key =
"j167j232234A131"221,}8167241158g"
 Call-Arrived-time = 133539306
 
 
 Framed-IP-Address is all i need but Connect-Speed would be nice to.
 
 this must be posible.
 
 Any ideas?
 
 
 
 TIA
 
 Steve Lalonde
 Systems Manager
 Entanet International Ltd.
 Do not meddle in the affairs of sysadmins, for they are
 easy to annoy and have the root password.
 
 
 
 
 
 
 ===
 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.
 


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



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



===
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) Problems installing IpassPerl 1.5

2000-03-13 Thread Aaron Holtz

Gerald,

Try changing Makefile.PL to the following:

WriteMakefile(
'NAME' = 'Ipass',
'DISTNAME' = 'IpassPerl',
'VERSION_FROM' = 'Ipass.pm', # finds $VERSION
'LIBS' = ["-L$ipass_lib -lip -lssl -lcrypto -lndbm"],
'DEFINE'   = '',
'INC'  = "-I$ipass_include",
 dist  = {
 COMPRESS = 'gzip -f',
 SUFFIX   = 'gz',
 },
# You may need this on RedHat 6.1. See note above
 dynamic_lib   = {
OTHERLDFLAGS = '-Xlinker -static'
 },
);


Then rerun perl Makefile.PL and make to see if that helps.  I had a
similiar issue and this fixed it.

------
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--


On Mar 13, Gerald Faerber molded the electrons to say

Hello,

when trying to install IpassPerl 1.5 we get the following error message.
Did anybody here already experience the same error? This is a RedHat 6.0
system,
with Perl 5.005_03.

Kind Regards,
Gerald Faerber


# make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/usr/lib/perl5/5.00503/i386-linux -I/usr/lib/perl5/5.00503 test.pl
1..6
Can't load 'blib/arch/auto/Ipass/Ipass.so' for module Ipass:
blib/arch/auto/Ipass/Ipass.so: undefined symbol: __srandom at
/usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169.

 at test.pl line 19
BEGIN failed--compilation aborted at test.pl line 19.
not ok 1
make: *** [test_dynamic] Error 255

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



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



Re: (RADIATOR) Framed-IP-Address on Radonline

2000-02-11 Thread Aaron Holtz

You need to add the following statement to your Cisco (and you may want to
have it send stop records only as this statement can basically replace
your Start record.):

aaa accounting update newinfo

This will include the Framed-IP after the PPP stream is started.  Since
you end up with 2 records with this statement, you can have the Cisco only
send Stop records and use this Alive record (as it will be called in the
logs) to get the info you want.  Radiator is built to handle these packets
and will update your radonline table with the information.


--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--

On Feb 11, Tuncay MARGILIC molded the electrons to say

Hi there,

I have use the verison 2.14.1 with 5300 Networt Access Servers. Users are
able to authanticate. Radiator also writes the stoponly accounting
information to the accounting table (including the FRAMED-IP-ADDRESS). But I
have a problem with radonline table, the FRAMED-IP-ADDRESS is not sent to
the insert statement. And I cannot see the IP adresses of the online users.
Do I have to do modifications on cisco side or is there a problem with my
Radiator or should I do something on the .cfg file to get every connected
users IP with snmpget??? 


PS: the version of the snmpget is UCD-snmp version:4.0.1

Tuncay Margilic
Siemens Business Services - Turkey
System Administrator




-
SessionDatabase SQL  
DBSource dbi:Oracle:radora  
DBUsername radius
DBAuth **
AddQuery insert into RADONLINE (USERNAME,NASIDENTIFIER,NASPORT,\
ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NASPORTTYPE,\
SERVICETYPE) values
('%U','%{NAS-IP-Address}',%{NAS-Port},'%{Acct-Session-Id}',\
%{Timestamp},'%{Framed-IP-Address}','%{NAS-Port-Type}','%{Framed-Protocol}')
/SessionDatabase

-


-
AccountingStopsOnly
AccountingTable ACCOUNTING
   AcctColumnDef   USERNAME,User-Name
   AcctColumnDef   TIME_STAMP,Timestamp,integer
   AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type
   AcctColumnDef   ACCTDELAYTIME,Acct-Delay-Time,integer
   AcctColumnDef   ACCTINPUTOCTETS,Acct-Input-Octets,integer
   AcctColumnDef   ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
   AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
   AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time
   AcctColumnDef
ACCTTERMINATECAUSE,Ascend-Disconnect-Cause,integer
   AcctColumnDef   NASIDENTIFIER,NAS-IP-Address
   AcctColumnDef   NASPORT,NAS-Port,integer
   AcctColumnDef   FRAMEDADDRESS,Framed-IP-Address
   AcctColumnDef   CALLERID,Calling-Station-Id
   AcctColumnDef   DATARATE,Ascend-Data-Rate,integer
   AcctColumnDef   XMITRATE,Ascend-Xmit-Rate,integer
   AcctColumnDef   CLIENTDNIS,Called-Station-Id
   AcctColumnDef   LOGDATE,Timestamp,integer-date

-



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



(RADIATOR) Re: Cisco update newinfo Question

2000-02-11 Thread Aaron Holtz

Well, what you don't know in a brand new Alive/Start packet is information
about lost Stop records.  Anything from the time of the lost record (which
may or may not be a big deal) to the radius accounting ID assigned to the
session (which again, may or may not be important.)   Radiator tries to be
self healing in that if a new person comes on and gets a modem of someone
in the database, it removes them and then inserts the new user.  Radiator
can also query the remote NAS unit to verify a user's connection and take
action from there.  Maybe you might want to check that out.  Although with
a little hacking, I'm sure a preclienthook or preauthhook could do a
little logic and magic on your radonline database and remove bad entries
to avoid contacting the NAS unit.

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--


On Feb 11, Lutfi YUNUSOGLU molded the electrons to say

Hi,
We have another problem which can be solved this way. But I'm not sure.
We have some POP's on different cities which are connected to our main
location with point to point leased lines. Sometimes because of telco
problems we loose connection to this POP's. At this moment if some user
disconnects of course we don't have the stop record. Is it possible to use
this setting (in such situation) to insert stop records to the accounting
table.

Regards
Lutfi Yunusoglu
Siemens Business Services
System Administrator 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Aaron Holtz
Sent: Friday, February 11, 2000 2:54 PM
To: Tuncay MARGILIC
Cc: [EMAIL PROTECTED]
Subject: Re: (RADIATOR) Framed-IP-Address on Radonline


You need to add the following statement to your Cisco (and you may want to
have it send stop records only as this statement can basically replace
your Start record.):

aaa accounting update newinfo

This will include the Framed-IP after the PPP stream is started.  Since
you end up with 2 records with this statement, you can have the Cisco only
send Stop records and use this Alive record (as it will be called in the
logs) to get the info you want.  Radiator is built to handle these packets
and will update your radonline table with the information.


------
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--

On Feb 11, Tuncay MARGILIC molded the electrons to say

Hi there,

I have use the verison 2.14.1 with 5300 Networt Access Servers. Users are
able to authanticate. Radiator also writes the stoponly accounting
information to the accounting table (including the FRAMED-IP-ADDRESS). But
I
have a problem with radonline table, the FRAMED-IP-ADDRESS is not sent to
the insert statement. And I cannot see the IP adresses of the online users.
Do I have to do modifications on cisco side or is there a problem with my
Radiator or should I do something on the .cfg file to get every connected
users IP with snmpget??? 


PS: the version of the snmpget is UCD-snmp version:4.0.1

Tuncay Margilic
Siemens Business Services - Turkey
System Administrator



---
-
-
SessionDatabase SQL  
DBSource dbi:Oracle:radora  
DBUsername radius
DBAuth **
AddQuery insert into RADONLINE (USERNAME,NASIDENTIFIER,NASPORT,\
ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NASPORTTYPE,\
SERVICETYPE) values
('%U','%{NAS-IP-Address}',%{NAS-Port},'%{Acct-Session-Id}',\
%{Timestamp},'%{Framed-IP-Address}','%{NAS-Port-Type}','%{Framed-Protocol}'
)
/SessionDatabase
---
-
-

---
-
-
AccountingStopsOnly
AccountingTable ACCOUNTING
   AcctColumnDef   USERNAME,User-Name
   AcctColumnDef   TIME_STAMP,Timestamp,integer
   AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type
   AcctColumnDef   ACCTDELAYTIME,Acct-Delay-Time,integer
   AcctColumnDef   ACCTINPUTOCTETS,Acct-Input-Octets,integer
   AcctColumnDef   ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
   AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
   AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time
   AcctColumnDef
ACCTTERMINATECAUSE,Ascend-Disconnect-Cause,integer
   AcctColumnDef   NASIDENTIFIER,NAS-IP-Address
   AcctColumnDe

Re: (RADIATOR) OFF TOPIC: authentication for large-scale internetmail applications

2000-02-09 Thread Aaron Holtz

I believe Solaris 7 and 8 support ldap as a name service switch. Hence,
any system calls (getpwnam, getspnam, etc.) are passed to ldap and then to
anything else you've specified in /etc/nsswitch.conf   

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--


On Feb 9, John Coy molded the electrons to say

Oh, I want to clarify that we're *not* on NT -- I'm using
Sun Solaris boxes (2.5.1 and 2.6) for RADIUS, sendmail, and
POP3 services.


At 08:17 AM 2/9/00 +0100, [EMAIL PROTECTED] wrote:
On Tue, Feb 08, 2000 at 06:53:30PM -0600, John Coy wrote:
  use Radiator for dial-up authentication.  I was wondering if
  there are solutions out there which integrate Radius (or LDAP,
  or whatever is the appropriate piece) along with Sendmail and
  POP3 services.  What I'm looking for is a way to distribute e-mail
  systems across multiple servers with a common authentication (and user
  directory) scheme.

we're using Radiator with mysql and qmail with a virtual domain addon
(www.inter7.com/vpopmail) that uses the same mysql database to store users
for receiving mail and authorizing pop. it shouldnt be a problem to use
vpopmail on more servers...
if you want to stick to NT... if i'm not mistaken, exchange supports LDAP
and so does radiator...

Ricardo.


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



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



Re: (RADIATOR) Cisco NAS-IP oddity

2000-02-01 Thread Aaron Holtz

Is this a multihomed router and/or does it have two paths out of the box
over to your radius server?  You can use the:
ip radius source-interface
command to force radius out a specific interface if that is the case.  I
haven't seen this 11.3 IOS's or 12.x so far.  Though I get a TON of
'radius server dead/responding errors' from the version of 12 we've been
running.  Anyone else seeing this?  I know my radius servers are just
fine.  :-)

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--


On Feb 1, tom minchin molded the electrons to say

Hi,
   This is not a Radiator question per se, has anyone experienced this
gruesome 'bug' with Cisco?

Tue Feb  1 00:30:00 2000: DEBUG: Packet dump:
*** Received from 203.23.1.184 port 1645 
Code:   Access-Request
Identifier: 114
Authentic:  O1721721784158129220160232$=135v173-
Attributes:
NAS-IP-Address = 203.23.1.183

   I'm pretty sure that Radiator would not be messing with the
NAS-IP-Address, as it's only a couple of the NAS'es which are affected
and they all reduce by one (ie 184 says it's 183). 

[EMAIL PROTECTED]

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




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



Re: (RADIATOR) Cisco 2511 - Not supplying allocated IP addresstoRadiator

1999-11-15 Thread Aaron Holtz

I'd say that is your problem.  If you don't log Start packets, I'm
guessing that Alive packets aren't processed either.  Anything but a Stop
is ignored (or acknowledged and then ignored.)  You'll need to remove that
statement to get those entries into your online db I believe.  Do you have
anything other than 2511's on this Realm that are logging to the radonline
db?

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--


On Nov 15, Brian Morris molded the electrons to say

I understand,  but I am still not getting them into my radonline database.

Could it be because I have "AccountingStopsOnly" for this realm??

Thanks for the feedback.

Brian

- Original Message -
From: Hugh Irvine [EMAIL PROTECTED]
To: Aaron Holtz [EMAIL PROTECTED]; Brian Morris [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, November 15, 1999 4:29 PM
Subject: Re: (RADIATOR) Cisco 2511 - Not supplying allocated IP address
toRadiator



 Hello Aaron and Brian -

 On Mon, 15 Nov 1999, Aaron Holtz wrote:
  Yes, I believe that the radiator code looks for the Alive packet as well
  as a Start packet just for this case.  Be sure you are running a newer
  version of radiator - I believe that 2.13 and up should support it, but
  don't quote me on that.
 

 if ($status_type eq 'Start' || $status_type eq 'Alive')
 {
 # Some Ciscos dont send accounting-on, so we will
 # detect a reboot with the first session (ID 0001)
 $sessdb-clearNas($nas_id, $p)
 if $session_id eq '0001';

 # Ciscos sometimes sends Alive. Use them to make _sure_
 # there is an entry in the database
 $sessdb-add($original_username, $nas_id, $nas_port, $p);


 Aaron is quite correct, here's the relevant code from Handler.pm (Radiator
 2.14.1).

 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, Rhapsody




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



Re: (RADIATOR) Help! Static IP assignments not working!

1999-11-15 Thread Aaron Holtz

Jay,

What's in your file for the authby file?  Is it anything other
than the DEFAULT user?  Maybe you should drop the file and put everything
into the db.  Put replyattr's for just those users with special setups and
use something like this in your config:

DefaultReply \
Service-Type=Framed-User,Framed-IP-Address=255.255.255.254,\
Framed-IP-Netmask=255.255.255.255,Framed-MTU=1500,\
Framed-Compression=Van-Jacobson-TCP-IP


That way those without replyattr's in the db will get a default set.  
Then put everything that a special user would need in the db for just that
user. Also, I'd wonder if the quotes around the reply items in the db
aren't causing some issues. Maybe reput those items into your db without
the quotes.  On a Trace 4 is that testuser getting the right attributes in
the reply packet?


--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--

On Nov 15, Jay West molded the electrons to say

My full configuration was included in a previous email about 'problems with
authbysql'.

I'm now having a problem with static IP addresses.

Note the file settings:
mysql  select * from SUBSCRIBERS
- where Username='testuser';
+--+--+---+---+-
-+
| USERNAME | PASSWORD | ENCRYPTEDPASSWORD | CHECKATTR | REPLYATTR
|
+--+--+---+---+-
-+
| testuser |  | NULL  | NULL  | Framed-IP-Address =
"192.168.1.73",Framed-IP-Netmask = "255.255.255.252",Idle-Timeout = "0" |
+--+--+---+---+-
-+
1 row in set (0.00 sec)

And since I'm using authbysql followed by authbyfile with
continuewhileaccept this is important:
DEFAULT Service-Type = Framed-User
Service-Type = Framed-User,
Framed-Protocol = PPP,
Framed-Routing = None,
Framed-MTU = 1500,
Framed-Compression = Van-Jacobson-TCP-IP

However, I've just verified that when this user (testuser) logs in, they're
getting assigned an IP address from a pool defined on the router (via
255.255.255.254) instead of the specific IP address listed in SUBSCRIBERS
(as well as a host route of 255.255.255.255 instead of the 252 above).

Help (and THANKS IN ADVANCE!)

Jay West



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



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



Re: (RADIATOR) Cisco 2511 - Not supplying allocated IP address toRadiator

1999-11-14 Thread Aaron Holtz

Brian,

Add:

aaa accounting update newinfo

You need 11.3 or higher if I'm not mistaken.  Cisco doesn't send the
Framed-IP-Address in the Start packet like some others do - however,
radiator will handle the Alive packet that the above command sends once
the user has authenticated PPP and has a Framed address.

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--

On Nov 15, Brian Morris molded the electrons to say

Hi All,

I have setup some Cisco 2511's to authenticate with Radiator and they are
all working fine, users can get on etc without any troubles at all.

However, the 2511 does not report the IP address it allocated to the user
into Radiator at all.  Other NAS's are working fine, so I suspect it is
something in the cisco 2511 config.

Has anyone else had this problem?  How would I fix it?

Config details follow...

Regards,  Brian Morris.


IOS 11.1.24

aaa new-model
aaa authentication login TELNET-USERS local
aaa authentication login no_radius enable
aaa authentication login consoleport none
aaa authentication ppp default if-needed radius
aaa authorization network radius
aaa accounting exec start-stop radius
aaa accounting network start-stop radius
aaa accounting connection start-stop radius
aaa accounting system start-stop radius





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



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



Re: (RADIATOR) Cisco 2511 - Not supplying allocated IP addresstoRadiator

1999-11-14 Thread Aaron Holtz

Yes, I believe that the radiator code looks for the Alive packet as well
as a Start packet just for this case.  Be sure you are running a newer
version of radiator - I believe that 2.13 and up should support it, but
don't quote me on that.  

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--

On Nov 15, Brian Morris molded the electrons to say

Thanks Aaron,

Yes, the alive packet does have the IP address, but unless I am mistaken
this does not get inserted into RADONLINE  which is what I would really
like.

Is there a way around this?



- Original Message -----
From: Aaron Holtz [EMAIL PROTECTED]
To: Brian Morris [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, November 15, 1999 1:31 PM
Subject: Re: (RADIATOR) Cisco 2511 - Not supplying allocated IP address
toRadiator


 Brian,

 Add:

 aaa accounting update newinfo

 You need 11.3 or higher if I'm not mistaken.  Cisco doesn't send the
 Framed-IP-Address in the Start packet like some others do - however,
 radiator will handle the Alive packet that the above command sends once
 the user has authenticated PPP and has a Framed address.

 ------
 Aaron Holtz
 ComNet Inc.
 UNIX Systems Administration/Network Operations
 "It's not broken, it just lacks duct tape."
 --

 On Nov 15, Brian Morris molded the electrons to say

 Hi All,
 
 I have setup some Cisco 2511's to authenticate with Radiator and they are
 all working fine, users can get on etc without any troubles at all.
 
 However, the 2511 does not report the IP address it allocated to the user
 into Radiator at all.  Other NAS's are working fine, so I suspect it is
 something in the cisco 2511 config.
 
 Has anyone else had this problem?  How would I fix it?
 
 Config details follow...
 
 Regards,  Brian Morris.
 
 
 IOS 11.1.24
 
 aaa new-model
 aaa authentication login TELNET-USERS local
 aaa authentication login no_radius enable
 aaa authentication login consoleport none
 aaa authentication ppp default if-needed radius
 aaa authorization network radius
 aaa accounting exec start-stop radius
 aaa accounting network start-stop radius
 aaa accounting connection start-stop radius
 aaa accounting system start-stop radius
 
 
 
 
 
 ===
 Archive at http://www.thesite.com.au/~radiator/
 To unsubscribe, email '[EMAIL PROTECTED]' with
 'unsubscribe radiator' in the body of the message.
 


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



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



Re: (RADIATOR) Client-Id matching in Handler's not working

1999-10-29 Thread Aaron Holtz

Hugh,

I've discovered the problem - only Clients designated by a
Client/Client clause work - anything labled as an IdenticalClients
does not work.  Example:

Client 111.111.111.20
Secret pw
/Client


That would match Client-Id for 111.111.111.20 whether it is with a regex
or direct.  However,

Client 111.111.111.3
IdenticalClients 111.111.111.20
Secret pw
/Client


That would NOT match 111.111.111.20 because it isn't on the Client line.
Can a patch be made to include the IdenticalClients listed to work with
the Client-Id check item?  It seems practical that IdenticalClients 
should/could be subject to checks just like the listed Client IP's would
be.  Thoughts?

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--


On Oct 29, Hugh Irvine molded the electrons to say


Hello Aaron -

On Thu, 28 Oct 1999, Aaron Holtz wrote:
 After making changes to match on Client-Id instead of Nas-IP-Address, I
 don't seem to be able to make any matches whether I do exact matches or a
 regex.  Trace 4 dump:
 

I have just tested this here with no problems. Note that the Client-Id check
item was added to Radiator 2.14.1. From the revision history:

   Added support for NasType and Client-Id check items 

   (http://www.open.com.au/radiator/history.html)

hth

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, Rhapsody



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



Re: (RADIATOR) Client-Id matching in Handler's not working

1999-10-29 Thread Aaron Holtz

It won't match .20 because that is the ID of the nas unit sending the
information, so only 1 ip can be sending the packet.  IdenticalClients is
useful if you have a large number of dial-up boxes that all have the same
attributes (type, secret, etc.)   You'd fill up a file big-time with
Client/Client clauses otherwise.  Since I'm matching based on the ID
of the unit sending the request, it seems logical to be able to make a
match on it when I'm in my Handler's regardless of where I define it in
the configuration files.

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--


On Oct 29, Jason Godsey molded the electrons to say



On Fri, 29 Oct 1999, Aaron Holtz wrote:

 Date: Fri, 29 Oct 1999 09:03:24 -0400 (EDT)
 From: Aaron Holtz [EMAIL PROTECTED]
 To: Hugh Irvine [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Re: (RADIATOR) Client-Id matching in Handler's not working
 
 Hugh,
 
  I've discovered the problem - only Clients designated by a
 Client/Client clause work - anything labled as an IdenticalClients
 does not work.  Example:
 
 Client 111.111.111.20
  Secret pw
 /Client
 
 
 That would match Client-Id for 111.111.111.20 whether it is with a regex
 or direct.  However,
 
 Client 111.111.111.3
  IdenticalClients 111.111.111.20
 Secret pw
 /Client

Will it match 111.111.111.3 even when they are dialed into .20?
If so, this is the behavior I'd want.  If you want to match .20, then
it's not identical to .3

Just my point of view.
Jason


 
 
 That would NOT match 111.111.111.20 because it isn't on the Client line.
 Can a patch be made to include the IdenticalClients listed to work with
 the Client-Id check item?  It seems practical that IdenticalClients 
 should/could be subject to checks just like the listed Client IP's would
 be.  Thoughts?
 
 ------
 Aaron Holtz
 ComNet Inc.
 UNIX Systems Administration/Network Operations
 "It's not broken, it just lacks duct tape."
 --
 
 
 On Oct 29, Hugh Irvine molded the electrons to say
 
 
 Hello Aaron -
 
 On Thu, 28 Oct 1999, Aaron Holtz wrote:
  After making changes to match on Client-Id instead of Nas-IP-Address, I
  don't seem to be able to make any matches whether I do exact matches or a
  regex.  Trace 4 dump:
  
 
 I have just tested this here with no problems. Note that the Client-Id check
 item was added to Radiator 2.14.1. From the revision history:
 
 Added support for NasType and Client-Id check items 
 
 (http://www.open.com.au/radiator/history.html)
 
 hth
 
 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, Rhapsody
 
 
 
 ===
 Archive at http://www.thesite.com.au/~radiator/
 To unsubscribe, email '[EMAIL PROTECTED]' with
 'unsubscribe radiator' in the body of the message.
 



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



Re: (RADIATOR) Fw: LDAP Request

1999-10-28 Thread Aaron Holtz

Are you authing' by SQL?  If so, setup a field in your db that is for
reply attributes.  Only fill in that field for the users who get something
special.  Then in your auth clause setup something like:

DefaultReply Service-Type=Framed-User,Framed-IP-Address=255.255.255.254,\
 Framed-IP-Netmask=255.255.255.255,Framed-MTU=1500,\
 Framed-Compression=Van-Jacobson-TCP-IP


Change your select statement and column definitions to:


AuthSelect select PW, REPLYATTRS from PASSWD where USERNAME='%n'
AuthColumnDef 0,Encrypted-Password,check
AuthColumnDef 1,GENERIC,reply



Now any user with no reply attributes (an empty field in your sql table)
will get the DefaultReply items.  However, anyone with something in the
REPLYATTRS field will get those instead.Sure beats using flat text
files as everything is read on the fly   There is an example of what
that REPLYATTRS field should look like in the radiator docs.

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--

On Oct 28, Steven E. Ames molded the electrons to say



 Would it be possible to modify the way that AuthLDAP handles reply
 attributes? Right now they are all listed in a singly replyattr
 attribute. This is unwieldy for a lot of our tools and increases the
 complexity of the parsing.

 A better mechanism would be to handle them the same way as SQL is
 handled. Under SQL you can put up a statement such as:

 AuthColumnDef 2, Session-Timeout, reply

Following right behind on this topic... What's the best way to set
default values for reply attributes and then let a matching user record
override these defaults?

-Steve



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



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



(RADIATOR) getNasId() question/problem

1999-10-27 Thread Aaron Holtz

Hello - I've got a Handler that looks at the Nas-IP-Address to determine
what to do.  I've also got a bad nas that doesn't send Nas-IP-Address in
the access packet.  I used to have a preclienthook to set this up, but
that is now built into radiator.  I've put a log statement in the getNasId
and the last statement that is supposed to fix this is indeed working.
However, my Handler isn't being matched.   From Trace 4:


Wed Oct 27 12:25:27 1999: DEBUG: Packet dump:
*** Received from 111.111.49.2 port 1536 
Code:   Access-Request
Identifier: 181
Authentic:  r23198~#18~_e 4255_Yp
Attributes:
User-Name = "usera"
Password = "254a%G22510d218OW186!28159cT"
Service-Type = Framed-User
Framed-Protocol = PPP
NAS-Port = 9

Wed Oct 27 12:25:27 1999: DEBUG: Check if Handler
NAS-IP-Address=/111.111.(49|59).2/, Service-Type=Framed-User should be
used to handle this request

Wed Oct 27 12:25:27 1999: DEBUG: Check if Handler Realm="",
User-Name=/^[a-z0-9\-\.]+$/ should be used to handle this request

Wed Oct 27 12:25:27 1999: DEBUG: Handling request with Handler 'Realm="",
User-Name=/^[a-z0-9\-\.]+$/'



I have another similiar Handler clause for a set of nas units that do send
the Nas-IP-Address in the access packet and they work as intended.
Any thoughts on why this may not be working?  This is version 2.14.1
For posterity here is my old PreClientHook - which I have not tried under
2.14.1 as of yet:


PreClientHook sub { \
 if (${$_[0]}-getAttrByNum(4) eq '')\
 {\
my @l = Socket::unpack_sockaddr_in(${$_[0]}-{RecvFrom});\
my $x = Socket::inet_ntoa($l[1]);\
${$_[0]}-addAttrByNum(4, $x);\
${$_[0]}-{CachedAttrs}{4} = $x;\
 }\
}


------
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--



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



(RADIATOR) Suggestion for changing SQL backoff behaviour

1999-10-14 Thread Aaron Holtz

I'd like to suggest a change in the way that SQL servers and backups are
treated in radiator.  What I'd like to see is the FailureBackoffTime
represent the amount of time that an SQL servers is to be not be contacted
again and the backup used.  As it stands now, if the primary server
doesn't respond, the backup SQL server is used until it times out and then
it moves back through the list of db's to contact.  The behaviour I'd like
to see is that the backup server is used when the primary doesn't respond
until FailureBackoffTime is reached - then the primary is recontacted.  
If it responds then the process starts over again.  Right now the
secondary/backup would take all requests forever or until it times out and
then the list is retried.  Since many db's have a cleanup routine where it
can become unavailable for a short amount of time this behaviour would
make more sense to me.  You could tune FailureBackoffTime to be around the
length of time your cleanup job takes so that the backup server would get
your through that period.  The main issue I've got is that you don't
really know that the requests are going to the secondary/backup server and
it may stay there for quite some time degrading performance (assuming that
your primary db is setup to give better response due to location, machine
type, etc.)  Thoughts?

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--



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



Re: (RADIATOR) IpassPerl 1.4 module errors

1999-10-11 Thread Aaron Holtz

Chris,

I had the same problem - it's because the Ipass libraries posted
on their site are NOT the ones that Mike used to create the module.  
Email Mike and he can hook you up with the latest Solaris and/or Linux
libraries and header files.  He is now authorized by Ipass to do so - I
needed them as well.  Again, the ones you get from Ipass (version 3.2 I
believe) will not allow the 1.4 module to compile.  I've got this working
now if you have any questions that I can help with.  I tried to get the
libs from Ipass themselves with no luck

--
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--

On Sun, 10 Oct 1999, Chris M wrote:

I'm getting the following errors when compiling on a RedHat 4.2 
system, can anyone provide any clues?

Thanks,
Chris

cc -c -I/usr/ipass/include -Dbool=char -DHAS_BOOL -O2 
-DVERSION=\"1.4\" -DXS_
VERSION=\"1.4\" -fpic -I/usr/lib/perl5/i386-linux/5.00404/CORE  Ipass.c
Ipass.xs: In function `XS_Ipass_remote_auth':
Ipass.xs:385: structure has no member named `nas_port_type'
Ipass.xs:387: structure has no member named `called_number'
Ipass.xs:389: `IPASS_MAXPHONELEN' undeclared (first use this function)
Ipass.xs:389: (Each undeclared identifier is reported only once
Ipass.xs:389: for each function it appears in.)
Ipass.xs:391: structure has no member named `calling_number'
Ipass.xs: In function `XS_Ipass_remote_auth_chap':
Ipass.xs:442: structure has no member named `nas_port_type'
Ipass.xs:444: structure has no member named `called_number'
Ipass.xs:446: `IPASS_MAXPHONELEN' undeclared (first use this function)
Ipass.xs:448: structure has no member named `calling_number'
Ipass.xs: In function `XS_Ipass_remote_acct':
Ipass.xs:512: structure has no member named `nas_port_type'
Ipass.xs:514: structure has no member named `called_number'
Ipass.xs:516: `IPASS_MAXPHONELEN' undeclared (first use this function)
Ipass.xs:518: structure has no member named `calling_number'

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



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



Re: (RADIATOR) radiator cgi script hosting

1999-08-24 Thread Aaron Holtz

Jay,

Yes, this is very doable if you are writing the online data into
an sql database.  If your database engine supports remote tcp/ip
connections, then you can edit the cgi scripts to provide the proper
username/password combination to talk to the radiator machine.  If you are
using the internal session database, then it would be pretty hard to get
that information as it is being saved in memory or on disk in a .db file.
An example of how to talk to a remote db follows (a snippet from the
radwho.cgi script):

$DBSource = 'dbi:Pg:dbname=passwd;host=remote.server.com';
$DBUsername = 'raduser';
$DBAuth = 'radPassword';


This would allow the radwho.cgi script to query the remote database on
remote.server.com using the username raduser and the password
radPassword.  You'll have to modify according to the db you are using.

--
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email:  [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--


On Tue, 24 Aug 1999, Jay West wrote:

There's a cgi program included in radiator that can be called from a
webbrowser to see who's currently online, etc. etc.

Is there any way that this cgi can be run on a different machine than the
radiator server? I hate mucking up my nice radius servers with web server
software when I have quite a few perfectly good web servers sitting next to
them. Is this possible and what (in general terms) is required?

Thanks in advance!!

Jay West


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



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



Re: (RADIATOR) script question

1999-08-10 Thread Aaron Holtz

Hmmm... in perl it shouldn't matter until it hits the ';'.  But how about
this?

$query = "UPDATE abacbill..logins set Password='$password' where
  UserName='$username' AND DialAccount = 1";
$sth = $dbh-prepare("$query");

I would think that would work.  Unless I'm mis-understanding the question
about it being multiple line...

------
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email:  [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--


On Aug 10, Jamie Orzechowski molded the electrons to say

I have a script that will preform SQL commands via my unix machine .. the
problem is that I need to run a large (more than 2 line) SQL statement

I have the line:

$sth = $dbh-prepare("UPDATE abacbill..logins set Password='$password' where
UserName='$username' AND DialAccount = 1");

this is the actual statement ... anyone have any ideas how I can make this a
multiple line statement??

here is the script
---

#!/usr/bin/perl

$ENV{'SYBASE'}="/opt/sybase";
$ENV{'DSQUERY'}="rodopi";

use DBI;
$|=1;

$sql_data_source="dbi:Sybase:";
$sql_username="xxx";
$sql_auth="";

$dbh = DBI-connect($sql_data_source, $sql_username, $sql_auth);

open(OUTPUT,"output");
while(OUTPUT) {
  ($username,$password)=split;
  $sth = $dbh-prepare("UPDATE abacbill..logins set Password='$password'
where UserName='$username'
  $rv = $sth-execute;
  if($rv) {
 print "+";
  }  else {
 print ".";
  }
   $sth-finish;
}
close(OUTPUT);

$dbh-disconnect || warn $dbh-errstr;



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



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



Re: (RADIATOR) Wishlist: command line utilities

1999-06-10 Thread Aaron Holtz

Well the drivers used to talk to the db's are perl modules.  This could be
done as a command line utility and maybe a little ncurses programming
would make it feasible.  I suppose you could always use 'lynx' from the
unix side to access those web utilities from a console.  ;-)  I've done
some heavy duty radiator stuff, including incorporating the error logs and
db search utilities into our tech support software.  Makes it quite nice
for a tech to see if a user is online as well as why they haven't been
getting connected!  It helps if you know perl and I'm afraid I'm not sure
how well my perl scripts would port to NT (I shudder at the thought.)


--
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email:  [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--


On Jun 10, Felix Izquierdo molded the electrons to say


Hi Radiators!

My wishlist for the next version: command line utilities, in special
versions of radwho and radacct. I know that is trivial to adapt
radwho.cgi in a command line version, but it would be better if it is
included with the distribution. Another beautifull utility that needs a
command line version is nasclear.cgi by Aaron Holtz, now in goodies
directory. 

I think that more Radiator users feel the lack of this feature...

Cheers.

Félix
__
DATAGRAMA SERVICIOS INTERNET
C/ Acer 30Tlf: +34 3 223 00 98
08038 BARCELONA ( Spain ) Fax: +34 3 223 12 66
mailto:[EMAIL PROTECTED] http://www.datagrama.net
__

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



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



(RADIATOR) Using Log SYSLOG

1999-06-01 Thread Aaron Holtz

I've been trying to get this to work to no avail.  I'm trying to get
radiator to push its error logs to local0.  I've tried:

Log SYSLOG
   Facility LOG_LOCAL0
/Log
Log SYSLOG
   Facility local0
/Log
Log SYSLOG
   Facility LOCAL0
/Log


all to no avail.  Using 'logger' I can send message to local0 just fine
and they get into the log as expected.  Any guesses?  syslog.ph exists as
does Sys::Syslog.  I don't have any errors in the normal radiator logfile
so I'm not sure why these aren't making it as expected. syslog.ph has:

unless(defined(LOG_LOCAL0)) {
sub LOG_LOCAL0 () {(163);}  
}
 
I also ran h2ph just to be sure...  Thanks.

--
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email:  [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--




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



(RADIATOR) A ton of these errors...

1999-05-12 Thread Aaron Holtz

I've been logging these errors every few seconds from only my 2511's.
They are all running at least 11.3(7).  I have a large number of 5200
and 5300's that are not generating these errors from what I can tell.  Has
anyone seen this before and know what could be the deal?  No idea were
this would come from - I doubt that it is radiator but there sure are a
lot of them.  Is it some type of update coming from the router?  Way odd.
We aren't getting a lot of calls and they occur at all hours of the day so
I'm wondering if it is something in the IOS or some type of update that is
getting sent to the radius server.  Just curious if anyone else has seen
this one.


Wed May 12 10:59:43 1999: INFO: Access rejected for ~!E: No such user

A trace 4 does indeed show that is the username passed along:

Wed May 12 08:29:35 1999: DEBUG: Packet dump:
*** Received from 1.1.1.1 port 1645 
Code:   Access-Request
Identifier: 202
Authentic:  191[h228179~1173Qr196Q222Jc
Attributes:
NAS-IP-Address = 1.1.1.1
NAS-Port = 14
NAS-Port-Type = Async
User-Name = "~!E"
Password =
"180206h254e223133149168141194199159168220253"





------
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email:  [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--



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



(RADIATOR) Combatting a bad NAS...

1999-05-11 Thread Aaron Holtz

I have a NAS unit (An Osicom IQX - read: junk) that doesn't send the
NAS-IP-Address in the authentication packet.  Is there a down and dirty
way to pull that information out of the packet header and use it?  The
reason I ask is that I have a Handler based on NAS address that doesn't
work from this unit because of this missing information (this is confirmed
missing via a trace 4 dump of the authenticator packet.)   I believe I
saw something similiar elsewhere in one of the radius modules, but wasn't
sure how/where I could implement this.  Thanks in advance.
Here is the packet dump:

Mon Apr 19 13:48:19 1999: DEBUG: Packet dump:
*** Received from 1.1.1.1 port 1611 
Code:   Access-Request
Identifier: 2
Authentic:  F725h13KCT157241436246317r
Attributes:
User-Name = "test"
Password = "178@.2330230224180R189$163.C(%"
Service-Type = Framed-User
Framed-Protocol = PPP
NAS-Port = 29


I see in Radius.pm that Socket::inet_ntoa($l[1]) can be the IP of the
sending unit.  Is there a place I can setup a test to see if during the
Access-Request phase the NAS-IP-Address is set and if not, make it from
the packet?  The information is there during the accounting phases but it
appears that Osicom is quite slow in implementing this change that we've
asked..  It doesn't *technically* violate the RFC but I believe it
suggests in all caps that the NAS ip be sent during this phase..

------
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email:  [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--




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



(RADIATOR) Making a db call within Handler.pm

1999-03-25 Thread Aaron Holtz

Hello,

I'd like to add a db call in Handler.pm just before the session is
put into the radonline table.  Can anyone give me a hint of what I need to
do?   Basically during the Accounting phase I have some additional
information about the user that's in a db that I also want in the
radonline table.  I haven't had luck using class attributes or other ways,
so I thought this would work.  Basically I want to use the $name variable
(the username) and grab out the attributes from the subscribers db that I
need.  Then, along with the other info, I'll pass that information to the
$sessdb-add command.  I'm a bit confused, so any assistance or other
thoughts of how to get that information into the online db would be most
helpful.  If I modify this line in Handler.pm:

$sessdb-add($name, $nas_id, $nas_port, $p);

to include my extra entries, what other file(s)/areas need to be modified
to ensure it's added properly?  Thanks.

--
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email:  [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--




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



(RADIATOR) Answered my own question...

1999-03-25 Thread Aaron Holtz

... I figured out how to get my extra db information into the radonline
db.  After studying the code I see that in order to be able to use the
AddQuery structure, I need to get my value into the current packet.  Once
it passes through format_special then I can access it via %{value}
Once I figured that out, it wasn't a tough fix.  Thanks in advance.

--
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email:  [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--



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



Re: (RADIATOR) syncing multiple users files question...

1999-03-22 Thread Aaron Holtz

I use 'rsync' combined with 'ssh'.  This allows for secure transmission
between the servers and rsync is a more advanced version of rdist (plus it
uses the ssh stuff for security.)

rysnc:

http://rsync.samba.org

ssh:

http://www.cs.hut.fi/ssh

--
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email:  [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--


On Mar 22, Jay West molded the electrons to say

Greetings!

We have two radiator servers, each is independent but the configurations and
user files are identical. Our NAS is setup to query the first, and if there
is no reply to query the second. In this way, if one server fails the other
is available to respond.

Is there a slick neato way to sync up the users file between the two? It's a
pain to have to add new users in two places. We'd prefer to not have one
spot (like a remote SQL database, etc.) because this introduces a single
point of failure. The first method that comes to mind is setting up a cron
job to rcp or ftp the users file on one machine or the other. We're not
crazy about allowing rcp or ftp into our radius servers though... Is there
another method anyone has found?

Jay West


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



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



Re: (RADIATOR) Retrieving/Collecting Conection Parameter

1999-03-21 Thread Aaron Holtz

Richard,

I've tried getting connect speeds too using:

radius-server host xxx.xxx.xxx.xxx non-standard

with no success.  Another reader on this list said they had the Ascend
compatibility code working with connect speeds using the above line.
In order to get the IP in the start record, you'll need to do the
following:

aaa accounting update newinfo

This sends an "Alive" record (vs. Start or Stop record) right after they
start their PPP session that includes their IP address.  We've set things
up to not send Start records and I only deal with the Alive records.
Radiator is setup to handle the Alive record and will update your online
DB with the new information when it arrives.  Make sure you are using at
least 11.3 IOS.

------
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email:  [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--


On Mar 21, Richard Cameron molded the electrons to say

First, I am new to this list and have been using Radiator since 10
Mar 99.  Our site uses a Cisco 5300 as a NAS, with IP address allocated
from a pool on the NAS.

I would like to be able to retrieve the IP address allocated at the
start of a session vice at the stop of the session - the allocated IP
address is not sent at the start.  As well, I would like to collect the
NAS receive and transmit speeds for the port.  Using TACACS+, the
receive and transmit speeds were sent with the end of session messages.

Any suggestions on how I can configure Radiator or the NAS to do
this?

Rich Cameron
Network Manager RMC


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



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



(RADIATOR) Anyone know....

1999-02-22 Thread Aaron Holtz

How to get the user's group ID during the accouting phase?  I don't think
it would be difficult.  I've made a small patch to radiator that makes
auth'ing out of /etc/shadow emulate /etc/passwd in that the $user-{Group}
hash is built during startup.  This allows me to track and test a user
for rejection based on their group ID in the password file in addition to
their entry in /etc/group.  I would also like to log into my sessionDB
their group ID as well. The problem I'm having (I think) is how to get the
hash value for the username to get the info out of the array that I want.
In Handler.pm (around line 467) I can't simply do as a test:

main::log($main::LOG_DEBUG, "This user's group is: $name-{Group}");

I get the error:  

Can't use string ("username") as a HASH ref while "strict
refs" in use at .

The 'username' is replaced with the person's username.  Anyone know how I
can turn that username into a proper hash value to get the information I
want?  I would think there is a subroutine to pack that username (if that
is the proper method) to get the info I want.  Any help is appreciated!
Thanks much.

------
Aaron Holtz
ComNet Inc.
Manager, Unix Systems Administration
Email:  [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--




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