invalid variable

Stelian Ionescu sionescu at cddr.org
Tue Jun 11 17:37:51 CEST 2013


On Tue, 2013-06-11 at 16:22 +0100, Matthew Newton wrote:
> On Tue, Jun 11, 2013 at 05:02:33PM +0200, Stelian Ionescu wrote:
> > then the SQL fragment
> > 
> > «COALESCE(NULLIF('%{Event-Timestamp}', ''), '%S')::timestamp with time zone,'%{SQL-User-Name}'»
> > 
> > gets translated into
> > 
> > «COALESCE(NULLIF('Jun  7 2013 18:02:09 CEST=27=2C =27=27=29=2C =271970-01-01 01:00:00=27=29::timestamp with time zone=2C=27test'»
> > 
> > Notice how the apostrophes and commas are getting hex-encoded, thereby
> > making the resulting query invalid.
> 
> Check out 'safe-characters' in sql/*/dialup.conf

I've never had to change safe-characters before, and queries
worked(until recently).

-- 
Stelian Ionescu a.k.a. fe[nl]ix
Quidquid latine dictum sit, altum videtur.
http://common-lisp.net/project/iolib

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.freeradius.org/pipermail/freeradius-devel/attachments/20130611/3a6be8f9/attachment.pgp>


More information about the Freeradius-Devel mailing list