Simultaneous-Use problem with Mikrotik NAS clients

Fajar A. Nugraha fajar at fajar.net
Thu Feb 11 16:52:06 CET 2010


2010/2/11 Fojtán Balázs István <balazs at fojtan.hu>:
> simul_count_query = "SELECT COUNT(*) \
> FROM ${acct_table1} \
> WHERE username = '%{SQL-User-Name}' \
> AND acctstoptime IS NULL"

it uses ${acct_table1} (should be radacct by default). Have you
enabled accounting?

> mysql> select * from radcheck;
> +----+----------+---------------+----+------------+
> | id | UserName | Attribute     | op | Value      |
> +----+----------+---------------+----+------------+
> |  1 | hz00001  | user-password | == | Tfregep5uy |

what does radacct look like? What's the result of  (for example)

SELECT COUNT(*) \
 FROM radacct \
 WHERE username = 'hz00001' \
 AND acctstoptime IS NULL;

-- 
Fajar




More information about the Freeradius-Users mailing list