Problem expanding "%{Calling-Station-Id}"

Ana Gallardo Gómez anaougu at gmail.com
Fri May 6 14:53:39 CEST 2016


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 at 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 at 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 ::
::::::::::::::::::::::::::::::::::::


More information about the Freeradius-Users mailing list