Why Freeradius and Mysql dont work?
yao guoxian
yaoguoxian at gmail.com
Mon Jan 29 12:33:53 CET 2007
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 at 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 at 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 at 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070129/70e93d1e/attachment.html>
More information about the Freeradius-Users
mailing list