(RADIATOR) Building MySql Db

Thu Aug 15 17:25:11 CDT 2002

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: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] On
Behalf Of Hugh Irvine
Sent: Wednesday, August 14, 2002 10:23 PM
To: Zack W. Kneisley
Cc: radiator at open.com.au
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 radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' 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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.