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