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:
[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>:
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 <[EMAIL PROTECTED]>* 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
