(RADIATOR) MySQL auth

[Matteo Jurman]

thank you Hugh! I fogot to insert (inside myssql clause) correctly the
AuthColumnDef parameters!!!

MaTTeo JuRMaN
matteoj at libero.it
http://www.matteo-ale.org/
----- Original Message ----- 
From: "Hugh Irvine" <hugh at open.com.au>
To: "Matteo Jurman" <matteoj at libero.it>
Cc: <radiator at open.com.au>
Sent: Tuesday, July 29, 2003 2:20 AM
Subject: Re: (RADIATOR) MySQL auth


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