--
*From:* freeradius-users-bounces+frank.ranner=
[EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]
*On Behalf Of *yao guoxian
*Sent:* Monday, 29 January 2007 15:14
*To:* [EMAIL PROTECTED]; FreeRadius users mailing list
*Subject:* Re: Why Freeradius and Mysql dont work
yao guoxian wrote:
input command:./bin/mysql -u root
output results:Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.20-standard-log
*sigh*
You installed MySQL but did none of the security things that it probably
told you
Where is the default config file and how to config it?
I copyed surpport-files/my-medium.cnf to /etc/my.medim.cnf and its
content is as follow:
[client]
#password = your_password
port= 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
hi,
thanks, now that you supplied the full debug we can clearly see that freeradius
is unable to connect to your SQL database. so, questions arise such as - is
your database server running? is it configured for that 'root' account
and password (check using command line tools etc), is it
Thanks a lot!
I dont know why Freeradius and MySQL suddenly works after I did the
following step.
1 insert into radgroupreply (groupname,attribute,op,values) values
('user'，'Auth-Type',':=','Local');
insert into radgroupreply (groupname,attribute,op,values) values
Hi,
But i couldn't use mysql -u root -p rootpass to enter the command line
enviroment any longer. The output is :ERROR 1045 (28000): Access denied for
user 'root'@'localhost' (using password: YES). Seems strange,isnt? Anyway, I
might better re-install Mysql.
not strange at all - does that
Yes，I compiled FR myself. Originally I installed mysql with *.rpm
packages(MySQL-*-5.0.20-0.i386.rpm, include
MySQL-devel-5.0.20-0.i386.rpm),but it doent works. So I uninstall rpm
packages and use
mysql-standard-5.0.20-linux-i686.tar.gz to install Mysql.
Thanks.
2007/1/29, YvesDM [EMAIL
yao guoxian wrote:
rlm_sql_mysql: Mysql error 'Host '202.117.7.243 http://202.117.7.243'
is not allowed to connect to this MySQL server'
I assume this is a test server and is tightly controlled
Login to MySQL as root on the command line.
Type this:
GRANT ALL ON *.* TO [EMAIL PROTECTED]
Platform and Environment:
Freeradius:1.0.5 on Redhat 9
MySQL:MySQL-standard-5.0.20-linux-i686
Step:
1. create database radius;
2.mysql -uroot -prootpass radius db_mysql.sql ;
3.Edit radiusd.conf and sql.conf;
Debug Result:
Nothing to do. Sleeping until we see a request.
Zitat von yao guoxian [EMAIL PROTECTED]:
Platform and Environment:
Freeradius:1.0.5 on Redhat 9
MySQL:MySQL-standard-5.0.20-linux-i686
Step:
1. create database radius;
2.mysql -uroot -prootpass radius db_mysql.sql ;
3.Edit radiusd.conf and sql.conf;
Debug Result:
Nothing to
Hi,
3.Edit radiusd.conf and sql.conf;
Debug Result:
Nothing to do. Sleeping until we see a request.
no. thats not the debug result. you've edited all the lines before
that output.
alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thanks for reply.
The startup message(in debug mode) on my machine:
sql: safe-characters =
@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to [EMAIL
rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (2)'
rlm_sql (sql): Failed to connect DB handle #0
rlm_sql (sql): Failed to connect to any SQL server.
your socket file is not in the place.. maybe you should use an IP in your
sql.conf
Thanks again.
The file /var/lib/mysql/mysql.sock does not exist.When I use an IP in
sql.conf instead of the localhost, I get the following result:
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius
Of yao guoxian
Sent: Monday, 29 January 2007 15:14
To: [EMAIL PROTECTED]; FreeRadius users mailing list
Subject: Re: Why Freeradius and Mysql dont work?
Thanks again.
The file /var/lib/mysql/mysql.sock does not exist.When I
use an IP
this is problem of mysql configuration check /etc/my.cnf file for socket path
and check your mysql working ??? or some mysql put mysql.sock file in
/tmp/mysql.sock so plz check where your sock file in your env ?
install mysql again and try it
Edvin Seferovic [EMAIL PROTECTED] wrote:
Install mysql again
yao guoxian [EMAIL PROTECTED] wrote: Thanks again.
The file /var/lib/mysql/mysql.sock does not exist.When I use an IP in
sql.conf instead of the localhost, I get the following result:
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql
On 1/29/07, satish patel [EMAIL PROTECTED] wrote:
Install mysql again
Did you compile FR yourself?
Did you install the mysql-dev files?
Kind regards,
Yves
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
18 matches
Mail list logo
