Server IP changed and "FreeRADIUS+MySQL" does not work

yao guoxian yaoguoxian at gmail.com
Wed May 16 04:15:28 CEST 2007


Thanks to all of you.
    I can connect to MySQL using MySQL command-line program.
    The problem seems having been resolved , yet not completely. I logined
as super user "ygx" other  than  "root".  And  "FreeRADIUS + MySQL"  works
again.  I  didnt  make  any  other changes except editing sql.conf  to
login as user "ygx".
    The problem maybe exist in the table "user " of the database "mysql",
which is as follow:
mysql> select Host,User,Password from user;
+-------------------------------+--------+-----------------------------------------------------------------------------------+
| Host                         | User  |
Password                                  |
+-------------------------------+--------+-----------------------------------------------------------------------------------+
| localhost                  | root    |
*639C78D0EC361EE7FBD5E7B2EE7D4356079DB335 |
| 202.117.54.251         | root    |
*639C78D0EC361EE7FBD5E7B2EE7D4356079DB335 |
| %                            | ygx    |     *
95FF347796503B19B351447515672881EB314534     |
| %                            | root    |
*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+------------------------------+---------+-----------------------------------------------------------------------------------+
Note that user 'root'  has  different  Password  .

Regards
Guoxian.

2007/5/15, Alan Dekok <aland at deployingradius.com>:
>
> yao guoxian wrote:
> ...
> >   rlm_sql_mysql: Couldn't connect socket to MySQL server
> > root at 202.117.54.251:radius
> >   rlm_sql_mysql: Mysql error 'Access denied for user
> > 'root'@'202.117.54.251'
>
>   Can you connect from that IP to MySQL using the MySQL command-line
> program?  If not, check the ACL's on the machine running MySQL.
>
>   Alan DeKok.
> --
>   http://deployingradius.com       - The web site of the book
>   http://deployingradius.com/blog/ - The blog
> -
> 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/20070516/85307965/attachment.html>


More information about the Freeradius-Users mailing list