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<http://us.rd.yahoo.com/mail/in/yanswers/*http://in.answers.yahoo.com/>
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html