(RADIATOR) MySQL auth

[Hugh Irvine]

Hello Matteo -

I am not quite sure I understand what you are wanting to do.

The AuthBy SQL clause should look like this if you want to use the 
CHECKATTR and REPLYATTR columns in the database for the check and reply 
attributes:

	<AuthBy SQL>

		DBSource	dbi:mysql:radius
		DBUsername  	radius

		AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \
			from SUBSCRIBERS where USERNAME=%0

		AuthColumnDef 0, Password, check
		AuthColumnDef 1, GENERIC, check
		AuthColumnDef 2, GENERIC, reply

	</AuthBy>

regards

Hugh


On Tuesday, Jul 29, 2003, at 01:12 Australia/Melbourne, Matteo Jurman 
wrote:

> Hi everybody!
> Now all works, but I have still a few questions:
> after installing DBI:mysql support I'm in the condition to request
> authentication via both radpwtst and a client interface on which I'm
> working, but the attributes are shown uncorrectly (first case, 
> radpwtst) or
> quite not shown (second case, my pretty client)...
> So the first question is this: to make the attributes shown, what 
> command I
> have to insert in the clause <AuthBySQL>, assuming that the SUBSCRIBERS
> table is the one in which I have to insert the attributes...
> Otherwise, if my reasoning is wrong , in which table I have to insert 
> those
> attributes to make Radiator read them and write them?
>
>
>
> MaTTeo JuRMaN
> matteoj at libero.it
> http://www.matteo-ale.org/
> <attach.txt><radius.cfg>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

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