Server IP changed and FreeRADIUS+MySQL does not work

2007-05-15 Thread yao guoxian
I have installed FreeRADIUS and MySQL on the same machine. FreeRADIUS + MySQL had worked well before Server IP changed. For some reason the server had to be carried to a new place and its IP must be changed. After the server IP changed, FreeRADIUS + MySQL does not work. I have

Re: Server IP changed and FreeRADIUS+MySQL does not work

2007-05-15 Thread Stefan Winter
Hi, rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Access denied for user 'root'@'202.117.54.251' (using password: YES)' rlm_sql (sql): Failed to connect DB handle #0 Well, that gives a strong hint, doesn't it? Your MySQL

Re: Server IP changed and FreeRADIUS+MySQL does not work

2007-05-15 Thread Alan Dekok
yao guoxian wrote: ... rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]: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

Re: Server IP changed and FreeRADIUS+MySQL does not work

2007-05-15 Thread Kevin Bonner
changed, FreeRADIUS + MySQL does not work. I have edited sql.conf and changed IP to the new correct IP . I also edited the table user in the database mysql and altered the Host field from the old IP to the new correct IP. However these mendings do not work. As Alan stated

Re: Server IP changed and FreeRADIUS+MySQL does not work

2007-05-15 Thread yao guoxian
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