Fwd: (RADIATOR) Quoted and escaped password

[Mike McCauley]

Hello


On Jun 27,  5:34pm, Hugh Irvine wrote:
> Subject: Fwd: (RADIATOR) Quoted and escaped password
>
> Mikey -
>
> Could you help on this one please?
>
> ta
>
> Hugh
>
>
> >  >Received: (from majordomo at localhost)
> >	by server1.open.com.au (8.11.0/8.11.0) id f5QHK6H11169
> >	for radiatorzz-list; Tue, 26 Jun 2001 12:20:06 -0500
> >X-Authentication-Warning: server1.open.com.au: majordomo set sender
> >to owner-radiator at open.com.au using -f
> >From: <talist at vif.com>
> >To: <radiator at open.com.au>
> >Subject: (RADIATOR) Quoted and escaped password
> >Date: Tue, 26 Jun 2001 15:13:54 -0400
> >X-Priority: 3
> >Sender: owner-radiator at open.com.au
> >
> >Hello,
> >
> >I would like to add the definition of a variable that would provide the
> >quoted and escaped password returned from the NAS.
> >Something similar to %0 (for username) but for returned passwords in the
> >AuthSQL context.
> >Could someone tell me where is the %0 defined in the radiator perl modules.
> >The current %P (decrypted user password) is fine but my custom update query
> >is failing whenever the dialin user is sending quotes.

The replacement of %P is done by Radius::Util::format_special.
%0, %1 etc is also replace by Radius::Util::format_special, but with
contect-dependent data passed by the caller.

It is usual to use the DBI quote function to quote and esacpe SQL strings.
It would be possible for you to add another argument to the call to
format_special in Radius::AuthSQL::findUSer so that the quoted password was
available as %1

Hope that helps.
Cheers.

> >
> >
> >
> >
> >
> >
> >===
> >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.
>
> --
>
> NB: I am travelling this week, so there may be delays in our correspondence.
>
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
> Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
>
>-- End of excerpt from Hugh Irvine



-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc 
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
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.