Hallo all
Need to ask a Mysql auth question
I added another field to my radcheck table 'status'
mysql> desc radcheck
-> ;
+-----------+-------------+------+-----+----------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+----------+----------------+
| id | int(10) | | PRI | NULL | auto_increment |
| UserName | varchar(30) | | MUL | | |
| Attribute | varchar(30) | | | Password | |
| Value | varchar(40) | YES | | NULL | |
| status | varchar(16) | | | active | |
| op | char(2) | | | := | |
+-----------+-------------+------+-----+----------+----------------+
6 rows in set (0.00 sec)
Now I modified the query to look like below
authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM
${authcheck_table} WHERE Username = '%{SQL-User-Name}' AND status =
^^^^^^^^^^^^^
'active' ORDER BY id"
^^^^^^^
But it isn't working.
Anybody have any ideas ?
Tnx
Mozzi
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
