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