hi list, there's something wrong with variable expansion; can someone help us with this? regards, duffy (41) Found Auth-Type = EAP (41) # Executing group from file /etc/raddb/sites-enabled/default (41) group authenticate { (41) - entering group authenticate {...} (41) eap : Expiring EAP session with state 0xbdf36a23b8a07fd1 (41) eap : Finished EAP session with state 0xbdf36a23b8a07fd1 (41) eap : Previous EAP request found for state 0xbdf36a23b8a07fd1, released from the list (41) eap : Peer sent TTLS (21) (41) eap : EAP TTLS (21) (41) eap : Calling eap_ttls to process EAP data (41) eap_ttls : Authenticate (41) eap_ttls : processing EAP-TLS (41) eap_ttls : eaptls_verify returned 7 (41) eap_ttls : Done initial handshake (41) eap_ttls : eaptls_process returned 7 (41) eap_ttls : Session established. Proceeding to decode tunneled attributes. (41) eap_ttls : Got tunneled request User-Name = "test@fr3" MS-CHAP-Challenge = 0x84957d49e3ccb7ccbd30bb106b860eb3 MS-CHAP2-Response = 0x210052f234bbc6cc836c72ed546bc0837d250000000000000000b848ba4232812ff9babc1732f8b9b2921892f0e2a55148a1 (41) eap_ttls : Sending tunneled request User-Name = "test@fr3" MS-CHAP-Challenge = 0x84957d49e3ccb7ccbd30bb106b860eb3 MS-CHAP2-Response = 0x210052f234bbc6cc836c72ed546bc0837d250000000000000000b848ba4232812ff9babc1732f8b9b2921892f0e2a55148a1 server inner-tunnel { (41) # Executing section authorize from file /etc/raddb/sites-enabled/inner-tunnel (41) group authorize { (41) - entering group authorize {...} (41) mschap : Found MS-CHAP attributes. Setting 'Auth-Type = mschap' (41) [mschap] = ok (41) suffix : Looking up realm "fr3" for User-Name = "test@fr3" (41) suffix : Found realm "fr3" (41) suffix : Adding Stripped-User-Name = "test" (41) suffix : Adding Realm = "fr3" (41) suffix : Authentication realm is LOCAL. (41) [suffix] = ok (41) update control { (41) Proxy-To-Realm := "LOCAL" (41) } # update control = ok(41) [files] = noop (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 (41) ERROR: sql : Error generating query rlm_sql (sql): Released connection (41) rlm_sql (sql): Opening additional connection (42) rlm_sql (sql): Closing connection (40): Hit idle_timeout, was idle for 90 seconds rlm_sql (sql): You probably need to lower "min" rlm_sql_mysql: Socket destructor called, closing socket (41) [sql] = fail ^C Program received signal SIGINT, Interrupt. 0x00007ffff60084d3 in __select_nocancel () from /lib64/libc.so.6(gdb) bt full#0 0x00007ffff60084d3 in __select_nocancel () from /lib64/libc.so.6 No symbol table info available. #1 0x00007ffff73b8013 in fr_event_loop (el=0xaea650) at src/lib/event.c:390 i = <value optimized out> rcode = <value optimized out> maxfd = 49 when = {tv_sec = 0, tv_usec = 0} wake = <value optimized out> read_fds = {fds_bits = {985162418487296, 0 <repeats 15 times>}} master_fds = {fds_bits = {985162418487296, 0 <repeats 15 times>}} #2 0x000000000041e74c in main (argc=<value optimized out>, argv=<value optimized out>) at src/main/radiusd.c:468 rcode = <value optimized out> argval = <value optimized out> spawn_flag = 0 dont_fork = 1 write_pid = 0 flag = 0 act = {__sigaction_handler = {sa_handler = 0x41eac0 <sig_fatal>, sa_sigaction = 0x41eac0 <sig_fatal>}, sa_mask = {__val = {0 <repeats 16 times>}}, sa_flags = 0, sa_restorer = 0} (gdb)