(RADIATOR) Help Required

2002-04-22 Thread Wasim Ahmed Khan

Dear Sir,

I have a new query in which I would need your help.

We need to configure one package that should allow users to connect 
from 11:00 a.m. to 5:00 p.m. only. Users attempting to connect anytime 
before 11:00 should not be allowed and so the users attemtping to 
connect after 5:00 p.m. 

I would require your kind help to enable me to configure this through 
DATABASE only. Means the account type should be daytime (between 11:00 
a.m. to 5:00 p.m.) only.

Thank you and awiating your kind input.

Regards,
Wasim Ahmed Khan.
Application Programmer.
eWorld Internet Services.
Karachi,
Pakistan.
Ph:(92-21)111-246-246.

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

2002-04-22 Thread Hugh Irvine


Hello Arnulfo -

How are you programming the amount of time that a user is allowed to use? 
Most Radiator users employ an SQL database for user definitions and 
accounting and it is relatively easy to provide pre-paid services such as you 
describe in this way.

This topic has been discussed many times on the mailing list, so have a look 
at the archive site and do a search.

http://www.open.com.au/archives/radiator

regards

Hugh


On Mon, 22 Apr 2002 16:10, Arnulfo Rojas Yanquen wrote:
 Hugh
 our company offer services of Internet acces, the users hire this service
 by time determined, when has finished this time the Radiator must avoid
 that the user may connect again. This function is not doing the Radiator,
 and I not find the cause possible.

 Radiator is setup over RedHat 7, and use for authetication passwd-shadow
 and the version is Radiator 2.18.1
 THANKS

 Arnulfo


 _
 Chat with friends online, try MSN Messenger: http://messenger.msn.com

 ===
 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: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Help Required

2002-04-22 Thread Hugh Irvine


Hello Wasim -

You should use the Time = . check item.

If you could tell me how you are going to distinguish these users, I will be 
able to make more detailed suggestions.

Have a look at section 13.1.13 in the Radiator 3.0 reference manual.
(doc/ref.html).

regards

Hugh


On Mon, 22 Apr 2002 17:21, Wasim Ahmed Khan wrote:
 Dear Sir,

 I have a new query in which I would need your help.

 We need to configure one package that should allow users to connect
 from 11:00 a.m. to 5:00 p.m. only. Users attempting to connect anytime
 before 11:00 should not be allowed and so the users attemtping to
 connect after 5:00 p.m.

 I would require your kind help to enable me to configure this through
 DATABASE only. Means the account type should be daytime (between 11:00
 a.m. to 5:00 p.m.) only.

 Thank you and awiating your kind input.

 Regards,
 Wasim Ahmed Khan.
 Application Programmer.
 eWorld Internet Services.
 Karachi,
 Pakistan.
 Ph:(92-21)111-246-246.

 ===
 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: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: Fwd: (RADIATOR) Emerald 4

2002-04-22 Thread Mike McCauley

Hello Jacob,

thanks for asking us about this.

In fact, we will be releasing a new Emerald 4 module shortly, hopefully in 
the next few days.
Would you care to test it when it becomes available?

Cheers.


 --  Forwarded Message  --

 Subject: (RADIATOR) Emerald 4
 Date: Thu, 18 Apr 2002 18:52:02 -0700
 From: Jacob Leaver [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]

 Hello, are there any emerald 4 users out there that have made AuthBy
 EMERALD work?   Is there going to be, or is there already a new module?  
 I've got to connect at least temporarily to an Emerald database to do
 authentication, and I'd rather not re-invent the wheel if I don't have to.

 Thanks,

 Jacob Leaver
 Senior Systems Administrator
 ReachONE Internet


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

 ---

-- 
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 9, MacOS X etc etc
===
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) MyStatus

2002-04-22 Thread mahmoodi

Dear Sir,
This is Iqbal, I want to know something about Radiator 
Radius Software.

Basically we have two systems for this purpose both
are 2.7 Solaris Sparce based server with 512MB RAM
and Ultra-250 Processor currently we are facing 
very trouble with existing software and we are ready
to switch radius software to RADIATOR as soon as 
possible due to these problem. 

OUR NEED

We want to run Primary Name server and Radiator Radius
server on System-1 but, want to authentication via 
UNIX (/etc/shadow and /etc/passwd file) or access 
CLI via MySQL/Radius Attributes allocation via MySQL 
database (Profile wise) which is exists on different 
UNIX servers I mean System-2.


The second system will run Secondary Name server and
MySQL database server, which handle all accounting 
log of radius which is running on system-1.

Basically I want to run Radiator but Authentication 
server will be different host and Accounting server
will be different host please tell either it is 
possible or not.


Also I want to know the features of radiator software
either I can use dialup Users Connectivity Time-Limitations 
(Policy wise).

Regards,
Iqbal
===
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) RE: PDF file for 2.18 Documentation

2002-04-22 Thread William Hernandez

Hugh,

Please ignore this message. I found the ref.html in the doc 
subdirectory.

William

-Original Message-
From: William Hernandez 
Sent: Monday, April 22, 2002 11:24 AM
To: Hugh Irvine ([EMAIL PROTECTED])
Subject: PDF file for 2.18 Documentation


Hello Hugh,

Would it be possible to download via ftp the 2.18.x Radiator Server
Manual?

Thanks in advance,

William Hernández
ESS/PR Webmasters
San Juan, P.R.
Tel: 787-723-5000
Fax: 787-722-6242 

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

2002-04-22 Thread Rolando Riley

I have been searching thru the mailing list a solution to make loggings on
RADLOG with this format TIME_STAMP

Log SQL
 DBSourcedbi:mysql:radius:localhost
 DBUsername  myuser
 DBAuth  mypass
   LogQueryinsert into %3 (TIME_STAMP, PRIORITY, MESSAGE)\
   values ('%m/%d/%Y %H:%M:%S', %0, %2)
Trace 3
/Log


This is not working on my Radiator 3.0 . Bellow is the SQL output when I
query it.

  4  3 Server started: Radiator 3.0 on dns.ayayai.com
  4  3 Connecting to 200.24.128.3, port 389
  4  3 Attempting to bind with cn=admin, dc=ayayai, dc=com, copycat (server
xx.xx.xx.xx:)
  4  2 SIGTERM received: stopping


I am thinking to use a function that convert seconds TIME_STAMP to a unix
TIME_STAMP from a perl cgi if I don't get this working. Anybody know a perl
function that does this?


cheers,


---
Ing. Rolando Riley
Gerente de Sistemas
AYAYAI.COM S.A.
Tel: (507) 265-2424 ext. 408
---

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

2002-04-22 Thread Hugh Irvine


Hello Iqbal -

I responded to this mail already, but I will resend a copy now.

regards

Hugh


On Mon, 22 Apr 2002 22:51, [EMAIL PROTECTED] wrote:
 Dear Sir,
 This is Iqbal, I want to know something about Radiator
 Radius Software.

 Basically we have two systems for this purpose both
 are 2.7 Solaris Sparce based server with 512MB RAM
 and Ultra-250 Processor currently we are facing
 very trouble with existing software and we are ready
 to switch radius software to RADIATOR as soon as
 possible due to these problem.

 OUR NEED
 
 We want to run Primary Name server and Radiator Radius
 server on System-1 but, want to authentication via
 UNIX (/etc/shadow and /etc/passwd file) or access
 CLI via MySQL/Radius Attributes allocation via MySQL
 database (Profile wise) which is exists on different
 UNIX servers I mean System-2.


 The second system will run Secondary Name server and
 MySQL database server, which handle all accounting
 log of radius which is running on system-1.

 Basically I want to run Radiator but Authentication
 server will be different host and Accounting server
 will be different host please tell either it is
 possible or not.


 Also I want to know the features of radiator software
 either I can use dialup Users Connectivity Time-Limitations
 (Policy wise).

 Regards,
 Iqbal
 ===
 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: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) LogQuery

2002-04-22 Thread Hugh Irvine


Hello Rolando -

I don't quite understand what you are showing below.

The Unix timestamp is available directly as %{Timestamp} - it just needs to 
be inserted into an integer column.

regards

Hugh


On Tue, 23 Apr 2002 06:41, Rolando Riley wrote:
 I have been searching thru the mailing list a solution to make loggings on
 RADLOG with this format TIME_STAMP

 Log SQL
  DBSourcedbi:mysql:radius:localhost
  DBUsername  myuser
  DBAuth  mypass
LogQueryinsert into %3 (TIME_STAMP, PRIORITY, MESSAGE)\
values ('%m/%d/%Y %H:%M:%S', %0, %2)
 Trace 3
 /Log


 This is not working on my Radiator 3.0 . Bellow is the SQL output when
 I query it.

   4  3 Server started: Radiator 3.0 on dns.ayayai.com
   4  3 Connecting to 200.24.128.3, port 389
   4  3 Attempting to bind with cn=admin, dc=ayayai, dc=com, copycat (server
 xx.xx.xx.xx:)
   4  2 SIGTERM received: stopping


   I am thinking to use a function that convert seconds TIME_STAMP to a unix
 TIME_STAMP from a perl cgi if I don't get this working. Anybody know a perl
 function that does this?


 cheers,


 ---
 Ing. Rolando Riley
 Gerente de Sistemas
 AYAYAI.COM S.A.
 Tel: (507) 265-2424 ext. 408
 ---

 ===
 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: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



(RADIATOR) Lost Stop Record Scripts

2002-04-22 Thread Paul

Dear All,

Does anyone have any scripts that can scan through a logfile and/or an SQL
table and locate lost stop records, or identify which sessions have been
lost based on Alive packets. We are having problems with Lost stop records
and need to locate them so we can pass them onto our developers. Any advice
or scripts would be apprciated.

Thanks

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



(RADIATOR) AUTHLOG SQL

2002-04-22 Thread Michael Saunders



Thanks for all the help on the list I know have 
AUTHLOG SQL working.
My only problem is that some people are sending 
through usernames that have ' ^ and  " in them
is there anyway I can rewrite these usernames to be 
only alphabetical and numeric. 
I have seen the rewrite function 
unfortunately I am not good with perl.
Has anyone done this before and maybe have a 
pre-written string

Michael Saunders


Re: (RADIATOR) Lost Stop Record Scripts

2002-04-22 Thread Hugh Irvine


Hello Paul -

The lost stop record problem is in many ways directly due to the design of 
the radius protocol, as it is based on UDP and records can and do go missing. 
There are also various NAS software bugs that can cause accounting packets to 
go missing as well.

Most operators tend to do their accounting based on stop records alone and 
treat the lost records as operating overhead. 

Note that you could do something with a cron job that scans the session 
database and generates a stop record for any stale record and then deletes 
it. This is not a standard Radiator feature however.

regards

Hugh


On Tue, 23 Apr 2002 11:24, Paul wrote:
 Dear All,

 Does anyone have any scripts that can scan through a logfile and/or an SQL
 table and locate lost stop records, or identify which sessions have been
 lost based on Alive packets. We are having problems with Lost stop records
 and need to locate them so we can pass them onto our developers. Any advice
 or scripts would be apprciated.

 Thanks

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

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) AUTHLOG SQL

2002-04-22 Thread Hugh Irvine


Hello Mick -

I usually recommend the UsernameCharset parameter to define the list of 
acceptable characters (all others are rejected). This tends to be a safer 
approach.

See section 6.4.30 in the Radiator 3.0 reference manual.

There are also a number of RewriteUsername examples in the manual.

regards

Hugh


On Tue, 23 Apr 2002 13:08, Michael Saunders wrote:
 Thanks for all the help on the list I know have AUTHLOG SQL working.
 My only problem is that some people are sending through usernames that have
 ' ^ and   in them is there anyway I can rewrite these usernames to be
 only alphabetical and numeric. I  have seen the rewrite function
 unfortunately I am not good with perl. Has anyone done this before and
 maybe have a pre-written string

 Michael Saunders

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Lost Stop Record Scripts

2002-04-22 Thread Paul

Hugh,

Do you know where I could find one of the below mentioned scripts to run in
cron to scan the session table?

- Original Message -
From: Hugh Irvine
To: Paul ; [EMAIL PROTECTED]
Sent: Tuesday, April 23, 2002 12:53 PM
Subject: Re: (RADIATOR) Lost Stop Record Scripts



Hello Paul -

The lost stop record problem is in many ways directly due to the design of
the radius protocol, as it is based on UDP and records can and do go
missing.
There are also various NAS software bugs that can cause accounting packets
to
go missing as well.

Most operators tend to do their accounting based on stop records alone and
treat the lost records as operating overhead.

Note that you could do something with a cron job that scans the session
database and generates a stop record for any stale record and then deletes
it. This is not a standard Radiator feature however.

regards

Hugh


On Tue, 23 Apr 2002 11:24, Paul wrote:
 Dear All,

 Does anyone have any scripts that can scan through a logfile and/or an SQL
 table and locate lost stop records, or identify which sessions have been
 lost based on Alive packets. We are having problems with Lost stop records
 and need to locate them so we can pass them onto our developers. Any
advice
 or scripts would be apprciated.

 Thanks

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

--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

===
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) Lost Stop Record Scripts

2002-04-22 Thread Hugh Irvine


Hello Paul -

No I don't, but someone else on the list might know.

Anyone?

regards

Hugh


On Tue, 23 Apr 2002 15:09, Paul wrote:
 Hugh,

 Do you know where I could find one of the below mentioned scripts to run in
 cron to scan the session table?

 - Original Message -
 From: Hugh Irvine
 To: Paul ; [EMAIL PROTECTED]
 Sent: Tuesday, April 23, 2002 12:53 PM
 Subject: Re: (RADIATOR) Lost Stop Record Scripts



 Hello Paul -

 The lost stop record problem is in many ways directly due to the design
 of the radius protocol, as it is based on UDP and records can and do go
 missing.
 There are also various NAS software bugs that can cause accounting packets
 to
 go missing as well.

 Most operators tend to do their accounting based on stop records alone and
 treat the lost records as operating overhead.

 Note that you could do something with a cron job that scans the session
 database and generates a stop record for any stale record and then
 deletes it. This is not a standard Radiator feature however.

 regards

 Hugh

 On Tue, 23 Apr 2002 11:24, Paul wrote:
  Dear All,
 
  Does anyone have any scripts that can scan through a logfile and/or an
  SQL table and locate lost stop records, or identify which sessions have
  been lost based on Alive packets. We are having problems with Lost stop
  records and need to locate them so we can pass them onto our developers.
  Any

 advice

  or scripts would be apprciated.
 
  Thanks
 
  ===
  Archive at http://www.open.com.au/archives/radiator/
  Announcements on [EMAIL PROTECTED]
  To unsubscribe, email '[EMAIL PROTECTED]' with
  'unsubscribe radiator' in the body of the message.

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.