Rupak wrote:
Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the
file and found that the value of user= was set to mysql. Where as in the
sql.conf file I pointed out the following
Login = "root"
Password = "password".But I don't know how to configure mysql.Does any one
have a link to a good tutorial.As I am a newbie in the world of mysql
Hi,
Thank you for the reply I think I have compiled free radius with mysql
support because I had installed it --with-experimental-modules.Now if I
start the sql server by giving the command "mysql -u root -p rootpass
radius
< db_mysql.sql" then it returns me with the following error
Error 2002: can't connect to local mysql server through socket
/var/lib/mysql/mysql.sock (111)
What may be the problem.The following is my radius.conf for "authorize and
accounting section
this isnt a FreeRADIUS problem at this point - the above error message is a
straight
'mysql cannot talk to mysql server'. check that
1) mysql is running
2) mysql is configured to allow your host to talk to it
3) mysql is configured to allow root account to talk to it - and that the
password is correct
4) firewall issues - check that you arent blocking mysql conversations in
some wierd way
alan
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
__________ NOD32 1.1111 (20050527) Information __________
This message was checked by NOD32 antivirus system.
http://www.nod32.com
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
usually there is no need to change anythin in my.cnf by default.
Per default the mysql user root exists and has *NO* password set!
If u want to restrict him to use password or restrict him to hosts u
can either use the mysql-set-permission utility or enter the mysql
console and use sql like that:
grant all privileges on <database>.<tables> to root@<host> identified by
"<password>";
wildards at database and tables are allowed. U may use *.* if u want to
restrict root for all existing databases!
host can be your hostname, or localhost or an ip address. Usually it is
a good thing to restrict root to connections from localhost.
And do not forget the semicolon at the end of the line :D
U should not restrict the privileges of root ;)
cheers
Sebastian
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
