Hello hakim, In regard to your problem, could the following help?
Simple put in Authby realm the following: AuthSelect select decode(NVL(b.password, 'NotFound'), 'NotFound', 'Whatever invalid msg', 'whatever valid msg') from wp_member b where username = %n and password = <whatever password> AuthColumnDef 0, User-Password, check Then replace "decode" function by whatever pl/sql fct/procedure you want to have; where the pl/sql lives inside the Oracle. I found this approach working extremely well for us. Hope this helps! On the other note, the previous posting I made few days ago about authentication hung between XP and my Cisco AP, I got it to work again under Aegis client. So, it's the IBM security module in the hardware that possibly caused the problem. Having said, and heard no reply from this list, I also concluded that whenever client got stud in the EAP auth, it could hang radiator to work properly and could block the auth requests of others. Something that I have serious concern .... since admin basically has no way to prevent a user to "improperly" configure the client. Anyone cares to offer a work around? Bon On Tue, 26 Aug 2003, hakim wrote: > hi Pavel!!! > Thanx for the reply. But if you dig the radiator mailing list, in one of the emails > Mike has replied that Radiator expects a recordset to be returned. > Also the method you are suggesting if done that way, the user is always > AUTHENTICATED even if the username and/or password is wrong. > > I feel what I am doing wrong is binding of the variables OUT parameter (Cursor). > Any feedback/help would be appreciated!!! > Regards > Hakim > ---------- Original Message ---------------------------------- > From: Pavel A Crasotin <[EMAIL PROTECTED]> > Reply-To: Pavel A Crasotin <[EMAIL PROTECTED]> > Date: Tue, 26 Aug 2003 08:57:41 +0400 > > >Hello Hakim - > > > >There is no need to use cursors (it is possible but I dont think about > >it :)). > > > >Just create sp_auth2 as > > > >procedure sp_Auth2(sUsername in varchar2,sPassword out varchar2) > > is > >begin > > select password > > into sPassword > > from authenticationtable_000 where > > username=sUsername; > >exception > > when others then > > null; > >end sp_Auth2; > > > >There is plsql.cfg it the goodies/ dir in Radiator distribution. > >Try to read it. Hope it helps. > > > > > > > >h> hello!!! > >h> What I am doing wrong here??? Any help would be appreciated!!! > > > > > >h> ----SAMPLE CONFIG FILE---- > >h> Trace 4 > >h> AuthPort 1812 > >h> AcctPort 1813 > >h> LogDir c:\Radiator3.6\dump > >h> DictionaryFile ./dictionary > >h> UsernameCharset [EMAIL PROTECTED] > >h> LogFile %L/%Y-%m-2logfile.log > > > >h> DefineFormattedGlobalVar dbSourceODBC tas_sys > >h> DefineFormattedGlobalVar dbSourceOracle tas > >h> DefineFormattedGlobalVar dbUsername xxx > >h> DefineFormattedGlobalVar dbAuth xxx > > > >h> <Client localhost> > >h> Secret mysecret > >h> DupInterval 300 > >h> </Client> > > > >h> <SessionDatabase SQL> > >h> DBSource dbi:Oracle:tas3 > >h> DBUsername xxx > >h> DBAuth xxx > >h> AddQuery insert into RADONLINE (username,code) values ('%n','000') > >h> </SessionDatabase> > > > >h> <Handler> > >h> <AuthBy PLSQL> > >h> NoDefault > >h> DBSource dbi:Oracle:tas > >h> DBUsername %{GlobalVar:dbUsername} > >h> DBAuth %{GlobalVar:dbAuth} > >h> AuthBlock begin \ > >h> tasradius.sp_Auth2('%n',:sReturnValue); \ > >h> end; > >h> AuthParamDef :sReturnValue,User-Password,Check > >h> </AuthBy> > >h> </Handler> > > > >h> ----END OF SAMPLE CONFIG FILE --- > > > >h> -----STORED PROCEDURE --------- > >h> CREATE OR REPLACE package tasradius > >h> is > >h> type Cursors is ref cursor return radreturn%rowtype; > >h> procedure sp_Auth2(sUsername in varchar2,sReturn out tasradius.Cursors); > >h> end tasradius; > > > >h> procedure sp_Auth2(sUsername in varchar2,sReturn out tasradius.Cursors) > >h> is > >h> begin > >h> open sReturn for select password from authenticationtable_000 where > >username='test'; > >h> exception > >h> when others then > >h> null; > >h> end sp_Auth2; > >h> end tasradius; > >h> ----- END OF STORED PROCEDURE --------- > > > >h> Regards > >h> Hakim > >h> === > >h> Archive at http://www.open.com.au/archives/radiator/ > >h> Announcements on [EMAIL PROTECTED] > >h> To unsubscribe, email '[EMAIL PROTECTED]' with > >h> 'unsubscribe radiator' in the body of the message. > > > > > >With respect, > >Pavel A Crasotin > >____________________________________ > >OJSC SeverTransCom > >Tel/Fax: +7 (0852) 58-01-00, 72-17-28 > > > >=== > >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. > > > === > 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. > === 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.