Marilene Lima wrote:
Hi,
I am starting the freeradius with my mysql server and I noticed this erro: rlm_sql_mysql: Mysql error 'Host 'mysql1.wireless.intranet' is not allowed to connect to this MySQL server'
But I already give the privileges to my user radius and add the server mysql1.wireless.intranet to my list of hosts knowed.
I use linux Debian and mysql 5.0.33 and the both are in the same machine, but they have different ip adress. In the freeradius/sql.conf file I configured this:
First, this does not look like a FreeRADIUS problem, so you need to look elsewhere. connect to mysql and do: SHOW GRANTS FOR radius@mysql1.wireless.intranet; What does it look like? Are the forward and reverse DNS lookups correct for all IP's on that host? For a machine with multiple IP addresses, the source IP of a packet may not be what you expect it to be and if you are not careful with DNS/rDNS, then it will look confusing to MySQL and you. -- Dennis Skinner Systems Administrator BlueFrog Internet http://www.bluefrog.com