Hello,
(9) Received Access-Request Id 251 from 192.168.1.15:34136 to
192.168.1.6:1812 length 80 (9) User-Name = 'nodowifi@nodo.unex.es' (9) User-Password = 'pass' (9) Calling-Station-Id = 'f0:f6:1c:58:da:cd'
And that shows the Calling-Station-Id exists, and is expanded properly.
So... what's wrong?
Here I don't have Calling-Station-Id to my sql query: (9) preprocess: Executing select query: SELECT username FROM radpostauth WHERE client like 'PA%' and reply='Access-Accept' and mac='' and authdate > (SELECT DATE_SUB(NOW(),INTERVAL 1 DAY)) order by authdate desc limit 1 (9) preprocess: SQL query returned no results rlm_sql (sqllocal): Released connection (6) (9) preprocess: EXPAND %{sqllocal:SELECT username FROM radpostauth WHERE client like 'PA%%' and reply='Access-Accept' and mac='%{Calling-Station-Id}' and authdate > (SELECT DATE_SUB(NOW(),INTERVAL 1 DAY)) order by authdate desc limit 1} and here in postauth section, I have: (9) sqllocal: EXPAND INSERT INTO radpostauth (username, mac, client, reply, authdate, codreject, radauth) VALUES ( LOWER('%{User-Name}'), UPPER('%{Calling-Station-Id}'), '%{Client-Shortname}', '%{reply:Packet-Type}', '%S', '%{reply:Codigo-Reject}', 'radiusprueba') (9) sqllocal: --> INSERT INTO radpostauth (username, mac, client, reply, authdate, codreject, radauth) VALUES ( LOWER('nodowifi@nodo.unex.es'), UPPER('f0:f6:1c:58:da:cd'), 'cau1PC', 'Access-Reject', '2016-05-06 14:01:04', 'Sin-Relacion-UEX', 'radiusprueba') Thank you. :::::::::::::::::::::::::::::::::::: :: Ana Gallardo Gómez :: ::::::::::::::::::::::::::::::::::::