thank you Hugh! I fogot to insert (inside myssql clause) correctly the AuthColumnDef parameters!!!
MaTTeo JuRMaN [EMAIL PROTECTED] http://www.matteo-ale.org/ ----- Original Message ----- From: "Hugh Irvine" <[EMAIL PROTECTED]> To: "Matteo Jurman" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 > > [EMAIL PROTECTED] > > 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
