[Help-gnu-radius] problem in authentication with Mysql

[wuxp]

I have installed gnu-radius-0.96.2 on Redhat 7.2 with Mysql support. When
authentication  type is local and password is plaintext,radius server is
working. but when my 'users' file is following:
---------------------------------------------
     DEFAULT Auth-Type = Local,
                Password-Location = SQL
             Service-Type = Framed-User,
                Framed-Protocol = PPP
---------------------------------------------

and use command: radauth -v wuxp
the results:
--------------------------------------------------
server 192.168.200.1:1812
send code 1 (RT_AUTHENTICATION_REQUEST)
      send: User-Name = wuxp
      send: Password = 159753
      send: NAS-Port-Id = 0
recv code 3 (RT_AUTHENTICATION_REJECT)
      recv: Reply-Message = \015\012Access denied\015\012
expect 2
got    3
FAIL
----------------------------------------------------------

in the 'radius.log' file :
----------------------------------------------------------------------------
May 28 11:03:10: Auth.error: wuxp: SQL authentication not available
----------------------------------------------------------------------------
-

What wrong with my RADIUS server?

Thanks for your help!

Wu Xiaoping



I have establish MYSQL Database RADIUS and the tables contents is following:
-----------------------------------------------------------------
mysql> select * from passwd;
+-----------+------------+----------+--------+
| user_name | service    | password | active |
+-----------+------------+----------+--------+
| wuxp      | Framed-PPP | 159753   | Y      |
+-----------+------------+----------+--------+
1 row in set (0.00 sec)

mysql> select * from groups;
+-----------+------------+
| user_name | user_group |
+-----------+------------+
| wuxp      | default    |
+-----------+------------+
1 row in set (0.00 sec)

mysql> select * from attrib;
+-----------+-------------------+-----------+------+
| user_name | attr              | value     | op   |
+-----------+-------------------+-----------+------+
| wuxp      | NAS-IP-ADDRESS    | 127.0.0.1 | NULL |
| wuxp      | NAS-Port-Id       | 20        | <    |
| wuxp      | Framed-Protocol   | NULL      | NULL |
| wuxp      | Framed-IP-Address | NULL      | NULL |
+-----------+-------------------+-----------+------+
4 rows in set (0.00 sec)