Freeradius-Users Digest, Vol 22, Issue 6

[Gaddis, Jeremy L.]

On Thu, 1 Feb 2007, Marilene Lima wrote:
> 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.

GRANT SELECT,INSERT,UPDATE,DELETE
ON radius.*
TO radius@'mysql1.wireless.intranet'
IDENTIFIED BY 'radius_password';

And perhaps a "FLUSH PRIVILEGES;" after that, though i don't think that's 
actually required.


-- 
Jeremy L. Gaddis, MCP, GCWN             jeremy at linuxwiz.net
LinuxWiz Consulting                     http://linuxwiz.net