(RADIATOR) Building MySql Db

[Hugh Irvine]

Hello Zack -

As mentioned previously, an AuthSQLStatement in the AuthBy SQL clause 
will do the trick.

If you really want the database update to happen after the AuthBy NT, 
you will have to use a hook.

You will find some example hooks in the file "goodies/hooks.txt".

regards

Hugh


On Friday, August 16, 2002, at 08:25 AM, Zack W. Kneisley wrote:

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