Thanks a lot!
I dont know why Freeradius and MySQL suddenly works after I did the following step.
1 insert into radgroupreply (groupname,attribute,op,values) values ('user'，'Auth-Type',':=','Local');
　　insert into radgroupreply (groupname,attribute,op,values) values ('user'，'Service-Type',':=','Framed-User');
　　insert into radgroupreply (groupname,attribute,op,values) values ('user'，'Framed-IP-Address',':=',' 255.255.255.254');
　　insert into radgroupreply (groupname,attribute,op,values) values ('user'，'Framed-IP-Netmask',':=',' 255.255.255.0');
insert into radcheck (username,attribute,op,value) values ('test','User-Password',':=','test') ；
insert into usergroup (username,groupname) values ('test','user');

2 change the setting of sql.conf
server = "localhost"   => server = "202.117.X.X"
3 # cp /home/ygx/mysql- standard-5.0.20-linux-i686/support-files/my-medium.cnf /etc/my.cnf
4 # /home/ygx/mysql-standard-5.0.20-linux-i686/bin/safe_mysqld --user = root
5 # radiusd -X
6 #radtest test teset localhost 0 testing123

It seems Freeradius and MySQL works as follow:
[root@nic219 freeradius-1.0.5]# radtest test test localhost 0 testing123
Sending Access-Request of id 211 to 127.0.0.1:1812
        User-Name = "test"
        User-Password = "test"
        NAS-IP-Address = nic219
        NAS-Port = 0
rad_recv: Access-Accept packet from host 127.0.0.1:1812, id=211, length=38
        Service-Type = Framed-User
        Framed-IP-Address = 255.255.255.254
        Framed-IP-Netmask = 255.255.255.0
And I use NTRadping on a XP machine , it returns correctly.

But i couldn't use " mysql -u root -p rootpass" to enter the command line enviroment any longer. The output is :ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). Seems strange,isnt? Anyway, I might better re-install Mysql.

   Thanks again!

2007/1/29, satish patel <linuxtrap@yahoo.co.in>:

this is problem of mysql configuration check /etc/my.cnf file for socket path and check your mysql working ??? or some mysql put mysql.sock file in /tmp/mysql.sock so plz check where your sock file in your env ?

install mysql again and try it

Edvin Seferovic <edvin.seferovic@kolp.at> wrote:

rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
rlm_sql (sql): Failed to connect DB handle #0
rlm_sql (sql): Failed to connect to any SQL server.

your socket file is not in the place.. maybe you should use an IP in your sql.conf instead of the "localhost" !

Regards,

E:S

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Here's a new way to find what you're looking for - Yahoo! Answers

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html