(RADIATOR) Configure SQL connection

2001-01-03 Thread Mohammed AbdusSami

Dear All,

I have MS-SQL server on NT  perl on Unix. I want to create SQL connection
between them. Can anybody tell me how can I do that.

Tnx in advance.

Regards

Mohammed AbdusSami


===
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) MD5 crypt()..

2001-01-03 Thread Chris Keladis

Hi folks,

I'm a little unclear about encrypted passwords in a Radiator database.

I would like to MD5 encrypt all our user passwords.

I've been experimenting with Digest::MD5 and Crypt::PasswordMD5, and so
far only Crypt::PasswordMD5 gives me what i see as a 'true' MD5
password. (The salt beginning with '$1$').

I'm a little confused as to the standards regarding the salt, and if
Radiator will understand the MD5 hashed passwords i create.

Am i going about the issue the wrong way? How can i store well-encrypted
passwords in my database to be used for authentication?




Thanks,

Chris.


===
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) defunct-processes on solaris 8

2001-01-03 Thread Toni Riekkinen

Hello againg,

I'm using Radiator 2.17.1 with Oracle 8.1.6 (same db for both auth and acct)
in same host. For some reason, I get few defunct processes for oracle -user.
Parent process (21708) seems to be radiusd. I know, defunct processes
doesn't use any resources, but it still would be nice to find out what
causes these. I can send my radius.cfg privately to you, Hugh, or anyone
else, if interested... :)

  oracle 26559 21708  0   0:00 defunct
  oracle 14930 21708  0   0:00 defunct
  oracle 11497 21708  0   0:00 defunct
  oracle  6421 21708  0   0:00 defunct
  oracle 24448 21708  0   0:00 defunct
  oracle 27572 21708  0   0:00 defunct
  oracle 15206 21708  0   0:00 defunct
  oracle 29064 21708  0   0:00 defunct
  oracle  9173 21708  0   0:00 defunct
  oracle 18199 21708  0   0:00 defunct
  oracle 27580 21708  0   0:00 defunct
  oracle 15296 21708  0   0:00 defunct

root 21708 1  1   Dec 19 ?   195:40 /usr/local/bin/perl
/usr/local/bin/radiusd -config_file /opt/radius/radius.cfg

Also, if i look radwho.cgi, sometimes User-Name or Framed-IP-Address etc.
field might be empty for some users, does this happen to others? Those are
missing also from detail -log, so it isn't radwho.cgi what bugs, should I
doubt NAS? Anyway, if users could log in, and User-Name field is empty, it
can only be in accounting information what bugs, right? (can't log in
without username)

++Toni



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



Re: (RADIATOR) active session mrtg

2001-01-03 Thread Robin Gruyters

No, I mean how many users are logged in

On Wed, Jan 03, 2001 at 08:21:28AM +1100, Hugh Irvine wrote:
 
 Hello Robin -
 
 On Wednesday 03 January 2001 07:25, Robin Gruyters wrote:
  Hi,
 
  Isit possible to get active session trough SNMP? Because I want to create
  stats with MRTG. (maybe someone here has already done this?!)
 
   http://www.open.com.au/radiator/faq.html#50
 
 hth
 
 Hugh
 
 -- 
 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.

-- 
Regards,

 Robin Gruyters - [EMAIL PROTECTED] - WISH-Noknok - RIPE: AS9133
 http://www.wish.nl - tel: +31(0)205358535 - fax. +31(0)208762628
 PGP key ID 88E5D96A - Sr. IT Engineer / Web Designer / B.O.F.H.
 Excuse of the day: Well fix that in the next (upgrade, update, patch release, service 
pack).

===
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) Default Framed-IP-Address

2001-01-03 Thread Ken Kirkby

Im trying to send back static ips from an Mysql Database to Cisco
servers. 

What value of Framed-IP-Address should I use to fill the database  
send back so as to  Ciscos to ignore the value and deliver the IP
address from the appropriate dialup pool? 


0.0.0.0 255.255.255.255 or '' ..

Sorry Im not thinking as clear as I might do. 

Wishing everyone a great new year.

-- 
 Ken Kirkby
PLC Peripherals * Nobbys Net + Terrigal Net 
http://www.plc-peripherals.com
 Real Time Hardware and Software - Cisco Certified Regional ISP.
PO Box 815 Terrigal NSW 2260  Australia. ph +61 2 4385 2335 fx +61 2
4385 3720

===
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) active session mrtg

2001-01-03 Thread SJ

Hello

...how many users are logged in
If you need the number of users logged in to an access server find that
oid and have MRTG poll it. You can add up the users of several NASs too.

Janos SUTO
GTS-Datanet

On Wed, 3 Jan 2001, Robin Gruyters wrote:

 No, I mean how many users are logged in
 
 On Wed, Jan 03, 2001 at 08:21:28AM +1100, Hugh Irvine wrote:
  
  Hello Robin -
  
  On Wednesday 03 January 2001 07:25, Robin Gruyters wrote:
   Hi,
  
   Isit possible to get active session trough SNMP? Because I want to create
   stats with MRTG. (maybe someone here has already done this?!)
  
  http://www.open.com.au/radiator/faq.html#50
  
  hth
  
  Hugh
  
  -- 
  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.
 
 -- 
 Regards,
 
  Robin Gruyters - [EMAIL PROTECTED] - WISH-Noknok - RIPE: AS9133
  http://www.wish.nl - tel: +31(0)205358535 - fax. +31(0)208762628
  PGP key ID 88E5D96A - Sr. IT Engineer / Web Designer / B.O.F.H.
  Excuse of the day: Well fix that in the next (upgrade, update, patch release, 
service pack).
 
 ===
 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) active session mrtg

2001-01-03 Thread Jesús M Díaz

Hi,

you can use MRTG against your radiator online data without SNMP (i do
that). simply write a script who return data you need (i.e. current
online and max current sessions) and call it from 'target' tag of
your mrtf cfg file.

i have an script that query my msql db about how many users are
online, and it is called from mrtg.

bye.

On Wed, 3 Jan 2001 12:45:59 +0100, Robin Gruyters wrote:

No, I mean how many users are logged in

On Wed, Jan 03, 2001 at 08:21:28AM +1100, Hugh Irvine wrote:
 
 Hello Robin -
 
 On Wednesday 03 January 2001 07:25, Robin Gruyters wrote:
  Hi,
 
  Isit possible to get active session trough SNMP? Because I want to create
  stats with MRTG. (maybe someone here has already done this?!)
 
  http://www.open.com.au/radiator/faq.html#50
 
 hth
 
 Hugh
 
 -- 
 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.

-- 
Regards,

 Robin Gruyters - [EMAIL PROTECTED] - WISH-Noknok - RIPE: AS9133
 http://www.wish.nl - tel: +31(0)205358535 - fax. +31(0)208762628
 PGP key ID 88E5D96A - Sr. IT Engineer / Web Designer / B.O.F.H.
 Excuse of the day: Well fix that in the next (upgrade, update, patch release, 
service pack).

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


Jesus M Diaz [EMAIL PROTECTED]

Telia Iberia, S.A.
Planificación y Diseño de Red
Tfno: +34 91 623 2909
Fax: +34 91 623 2911



===
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) MD5 crypt()..

2001-01-03 Thread SJ

Hello Chris

You may confuse MD5 with DES. DES uses a salt unlike MD5.
A little hack in the code will help you. Hugh or others may
give you hints where to modify if needed.

Janos SUTO
GTS-Datanet

On Wed, 3 Jan 2001, Chris Keladis wrote:

 Hi folks,
 
 I'm a little unclear about encrypted passwords in a Radiator database.
 
 I would like to MD5 encrypt all our user passwords.
 
 I've been experimenting with Digest::MD5 and Crypt::PasswordMD5, and so
 far only Crypt::PasswordMD5 gives me what i see as a 'true' MD5
 password. (The salt beginning with '$1$').
 
 I'm a little confused as to the standards regarding the salt, and if
 Radiator will understand the MD5 hashed passwords i create.
 
 Am i going about the issue the wrong way? How can i store well-encrypted
 passwords in my database to be used for authentication?
 
 
 
 
 Thanks,
 
 Chris.
 
 
 ===
 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) Configure SQL connection

2001-01-03 Thread Ray Carpenter

I don't know what version of unix you are running but I got this to work by
installing the Sybase engine which includes client connection software.
This is free for Linux.  You may be able to find just the client connection
software for your version.  Check www.sysbase.com   When you configure the
client connection you must use Microsofts tcpip port of 1433 in order to
connect to MS SQL.  You could also look for odbc drivers.  Hope this helps.

Ray

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Mohammed AbdusSami
Sent: Wednesday, January 03, 2001 6:06 AM
To: [EMAIL PROTECTED]
Subject: (RADIATOR) Configure SQL connection


Dear All,

I have MS-SQL server on NT  perl on Unix. I want to create SQL connection
between them. Can anybody tell me how can I do that.

Tnx in advance.

Regards

Mohammed AbdusSami


===
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) MD5 crypt()..

2001-01-03 Thread Hugh Irvine


Hello Chris -

On Wednesday 03 January 2001 22:08, Chris Keladis wrote:
 Hi folks,

 I'm a little unclear about encrypted passwords in a Radiator database.

 I would like to MD5 encrypt all our user passwords.

 I've been experimenting with Digest::MD5 and Crypt::PasswordMD5, and so
 far only Crypt::PasswordMD5 gives me what i see as a 'true' MD5
 password. (The salt beginning with '$1$').

 I'm a little confused as to the standards regarding the salt, and if
 Radiator will understand the MD5 hashed passwords i create.

 Am i going about the issue the wrong way? How can i store well-encrypted
 passwords in my database to be used for authentication?


The first thing to understand is that you can only use PAP authentication 
with encrypted passwords in your database.

For additional comments on password encryption, I have copied this to Mike so 
he can add his clarification.

regards

Hugh


-- 
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.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Default Framed-IP-Address

2001-01-03 Thread Hugh Irvine


Hello Ken -

On Thursday 04 January 2001 01:01, Ken Kirkby wrote:
 Im trying to send back static ips from an Mysql Database to Cisco
 servers.

 What value of Framed-IP-Address should I use to fill the database  
 send back so as to  Ciscos to ignore the value and deliver the IP
 address from the appropriate dialup pool?


 0.0.0.0 255.255.255.255 or '' ..

 Sorry Im not thinking as clear as I might do.


The exact value depends on the NAS and whether you have multiple pools set 
up, however, "255.255.255.254", is usually a good bet.

hth

Hugh

-- 
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.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



Re: (RADIATOR) Configure SQL connection

2001-01-03 Thread Hugh Irvine


Hello Mohammed -

On Wednesday 03 January 2001 22:06, Mohammed AbdusSami wrote:
 Dear All,

 I have MS-SQL server on NT  perl on Unix. I want to create SQL connection
 between them. Can anybody tell me how can I do that.


This topic has been discussed numerous times before.

Have a look at the FAQ:

http://www.open.com.au/radiator/faq.html#13

And also have a look at the archive site:

http://www.starport.net/~radiator

regards

Hugh

-- 
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.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



(RADIATOR) Radiator and Win2k

2001-01-03 Thread Eric Elliston

Does anyone know the trick to get Radiator to work on Win2k Server.  I
keep getting "Could not bind Authentication Socket RadiusD Line352"  

this is bizzare...

Thank you,

Eric Elliston
Network Administrator
--Neosmart.com
941-332-4900
[EMAIL PROTECTED]
 


===
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) MD5 crypt()..

2001-01-03 Thread Mike McCauley

Hi Chris,

Thanks for your question,

Radiator uses a similar implementation to Crypt::PasswordMD5 to generate Linux
compatible MD5 password hashes. The code that Radiator uses is in Util.pm, sub
md5crypt

The salt in a Linux MD5 password is the 0 to 8 characters following the $!$ up
to the next $, eg in:

$1$cTpht$Obu9PLSMst1TDou.mN5bk0

the salt is
cTpht

Any characters from the set:

./0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz

are permitted in the salt

Hope that helps.

Cheers.

On Jan 4, 10:04am, Hugh Irvine wrote:
 Subject: Re: (RADIATOR) MD5 crypt()..

 Hello Chris -

 On Wednesday 03 January 2001 22:08, Chris Keladis wrote:
  Hi folks,
 
  I'm a little unclear about encrypted passwords in a Radiator database.
 
  I would like to MD5 encrypt all our user passwords.
 
  I've been experimenting with Digest::MD5 and Crypt::PasswordMD5, and so
  far only Crypt::PasswordMD5 gives me what i see as a 'true' MD5
  password. (The salt beginning with '$1$').
 
  I'm a little confused as to the standards regarding the salt, and if
  Radiator will understand the MD5 hashed passwords i create.
 
  Am i going about the issue the wrong way? How can i store well-encrypted
  passwords in my database to be used for authentication?
 

 The first thing to understand is that you can only use PAP authentication
 with encrypted passwords in your database.

 For additional comments on password encryption, I have copied this to Mike so
 he can add his clarification.

 regards

 Hugh


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

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