invalid variable

[duffy]

thank you for your reply alan!
actually it seems the variable expansion issue is not really solved..
duffy


(6) sql :       expand: 
'%{%{Stripped-User-Name}:-%{%{User-Name}:-none}}' -> 'test'
(6) sql : SQL-User-Name updated
rlm_sql (sql): Reserved connection (39)
(6) sql :       expand: 'SELECT id, inner_id, attribute, val, op FROM 
radcheck(COALESCE(NULLIF('%{Event-Timestamp}', ''), '%S')::timestamp 
with time zone,'%{SQL-User-Name}','%{Realm}','%
ddr,parse_bssid(NULLIF('%{WiMAX-BS-Id}', 
'')),COALESCE(NULLIF('%{WiMAX-PDFID}', ''), '0')::smallint);' -> 'SELECT 
id, inner_id, attribute, val, op FROM radcheck(COALESCE(NULLIF('0=27=2C
with time 
zone=2C=27test','fr3','=3F.=3F.=3F.=3F'::inet,'_'::macaddr,parse_bssid(NULLIF('0x=3F=3F', 
'')),COALESCE(NULLIF('0', ''), '0')::smallint);'
rlm_sql (sql): Executing query: 'SELECT id, inner_id, attribute, val, op 
FROM radcheck(COALESCE(NULLIF('0=27=2C =27=27=29=2C =271970-01-01 
01:00:00=27=29::timestamp with time zone=2C=27t
_bssid(NULLIF('0x=3F=3F', '')),COALESCE(NULLIF('0', ''), '0')::smallint);'
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: Error syntax error at or near ","
rlm_sql_postgresql: Postgresql Fatal Error: [42601: SYNTAX ERROR] Occurred!!
rlm_sql (sql): Database query error 'ERROR:  syntax error at or near "," 
LINE 1: ...0=27=29::timestamp with time 
zone=2C=27test','fr3','=3F.=3F....
(6) ERROR: sql : SQL query error
rlm_sql (sql): Released connection (39)


Il 04/06/13 14.52, Alan DeKok ha scritto:
> duffy wrote:
>> hi list,
>> there's something wrong with variable expansion; can someone help us
>> with this?
>
>    I've pushed a fix.
>
>    Alan DeKok.
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
>