First I would like to say I feel your software is amazing, I've used IAS
that's built into win2k for a while now and think it is so primitive to
radiator, I sure wish I knew what I was missing before I began revolving
our user base around NT users... I read where you pointed me to but now
I would like to try something else. I am currently using an AuthBy SQL
to record the accounting data with a blank AuthSelect and then another
AuthBy NT to actually authenticate from. Now, AFTER the user has
Authenticated using the AuthBy NT and it is Access-Accept, I want to
write that Username and Password to the MySql SUBSCIBERS so that I may
eventually rotate to using just the MySql db.. Could someone help with
the formatting and syntax for such an operation?
Zack
Currently
<Realm DEFAULT>
AuthByPolicy ContinueAlways
RewriteUsername s/^([^@]+).*/$1/
<SessionDatabase SQL>
DBSource dbi:mysql:....
DBUsername ...
DBAuth ...
</SessionDatabase>
<Log SQL>
DBSource dbi:mysql:....
DBUsername ...
DBAuth ...
</Log>
<AuthBy SQL>
DBSource dbi:mysql:....
DBUsername ...
DBAuth ...
AuthSelect
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,integer
AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
</AuthBy>
<AuthBy NT>
</AuthBy>
# Log accounting to a detail file
AcctLogFileName ./detail
</Realm>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Hugh Irvine
Sent: Wednesday, August 14, 2002 10:23 PM
To: Zack W. Kneisley
Cc: [EMAIL PROTECTED]
Subject: Re: (RADIATOR) getting user information running AuthBy Test
Hello Zack -
You could use an AuthSQLStatement in the AuthBy SQL clause to add the
user entry.
Have a look at section 6.28.14 in the Radiator 3.1 reference manual
("doc/ref.html").
regards
Hugh
On Thursday, August 15, 2002, at 11:30 AM, Zack W. Kneisley wrote:
>
> Basicly I want to use AuthBy SQL using the MySql Db that I created
using
> the .sql file in the goodies dir if the username isn't there I want it
> to be created with the password they used, thus creating their record
so
> then next time they log on it will be challenged. I'm not sure where I
> was going with authby Test (long day)
>
> Zack
>
>
>
>
> Hello Zack -
>
> I am not quite sure what you mean below, could you give me a few more
> details on what you want to do with the AuthBy TEST?
>
> For your second question, the ENCRYPTEDPASSWORD is a UNIX encrypted
> password. Other forms of encryption are supported with prefixes as
> described in sections 13.1.1 and 13.1.2 in the Radiator reference
manual
>
> ("doc/ref.html").
>
> regards
>
> Hugh
>
>
>
> On Thursday, August 15, 2002, at 03:55 AM, Zack W. Kneisley wrote:
>
>> I'm currently using a windows2000 IAS server for our radius, but am
>> Going to be using radiator soon.. I know I can have Radiator
>> authenticate Using AuthBy ADSI to my domain controler, But I want to
>> move this to a MySQL db for authentication. Because Win2000 does not
>> allow passwords to be exported, I would like to use AuthBy Test and
> have
>> the user records automatically created. How can this be done? I also
>> have another question, How are the ENCRYPTEDPASSWORD field in the
> MySQL
>> Db created? I'm a new user to radiator so please bear with me.
>
>
> ===
> 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.
