Re: Simultaneous-Use problem with Mikrotik NAS clients

2010/2/11 Fojtán Balázs István <balazs@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