Dear All,
I found the following in my freeradius 2.1.0 debug on Ubuntu
8.10 for my simultaneous use check:
...
Sat Jan 10 10:21:47 2009 :
Debug: expand: SELECT
COUNT(*)
FROM
radacct
WHERE username = '%{SQL-User-Name}'
AND acctstoptime IS
NULL
AND callingstationid <> '{%Calling-Station-Id}' -> SELECT
COUNT(*)
FROM radacct
WHERE username = 'yubvef23'
AND acctstoptime IS
NULL
AND callingstationid <> '{anyonealling-Station-Id}'
...
It appears that after expansion of {%Calling-Station-Id} the
looked for value is {anyonealling-Station-Id}. The {} suggest this si a value
that should have been expanded/replaced further. The spelling - {anyonealling-Station-Id}
as opposed to {anyonecalling-Station-Id} as one might expect – suggested the
expansion/replacement fails due to a syntax error. I have looked in the
sql.conf and includes where the SQL statements are defined. The SQL statement
looks OK but I cannot find any definition of or reference to {anyonealling-Station-Id}.
I would like to confirm firstly that this is indeed a syntax
error and secondly, where the value of {anyonealling-Station-Id} may be defined,
so I can fix this.
Thanks