On Tue, 2013-06-04 at 11:30 +0200, duffy wrote:
hi list, there's something wrong with variable expansion; can someone help us with this? regards, duffy
[...]
(41) sql : expand: '%{%{Stripped-User-Name}:-%{%{User-Name}:-none}}' -> 'test' (41) sql : SQL-User-Name updated rlm_sql (sql): Reserved connection (41) (41) ERROR: sql : SELECT id, inner_id, attribute, val, op FROM radcheck(COALESCE(NULLIF('%{Event-Timestamp}', ''), '%S')::timestamp with time zone,'%{SQL-User-Name}','%{Realm}','%{Nas-Ip-Address}'::inet,'%{Calling-Station-Id}'::macaddr,parse_bssid(NULLIF('%{WiMAX-BS-Id}', '')),COALESCE(NULLIF('%{WiMAX-PDFID}', ''), '0')::smallint); (41) ERROR: sql :
^ Invalid variable expansion
To be clear, the complaint is about %{SQL-User-Name}, which makes little sense since it was just updated. -- Stelian Ionescu a.k.a. fe[nl]ix Quidquid latine dictum sit, altum videtur. http://common-lisp.net/project/iolib